C# :: Form Gets Locked Up When Connecting To Database
Aug 17, 2014
I'm trying to connect to a SQL Server Database, but when I click my button1 my entire form just locks up and nothing happens! I have to click the "Stop" button to stop the form from running in Visual Studio! I'd at least expect to receive an error if some of the connection string was wrong.
Here is my code:
private void button1_Click(object sender, EventArgs e) {
connection();
}
public void connection() {
SqlConnection myConnection = new SqlConnection();
[Code] ....
View 14 Replies
ADVERTISEMENT
Apr 8, 2013
How to connect my c++ code to any database using drivers.
View 2 Replies
View Related
Dec 2, 2013
I was created the mysql database in my Pc. This database connecting with vc++ code Using MySQL C++ Connection Example in Visual Studio. I done this work in single PC. It's working good. i viewed the table values using vc++ application.
But now want to connecting the database through lan connection. I refered the below link but i'm not clear.Step # 5 Grant access to remote IP address
For your reference, (I installed)
PC1 - visual studio 2003, mysql 5.6 for win32 & mysql connector (Ver : mysql-connector-c++-1.0.5-win32), OS : XP SP2, IP : 192.168.100.123
PC2 - mysql 5.6, OS: XP SP3, IP: 192,168,100.9
Table created in PC2, database name "test". server = 'localhost', user = 'root', passwd = "".
I like to connect PC1 & PC2 through Lan & access the table using vc++ code.
How can i view PC2's database table values in PC1?
View 11 Replies
View Related
Jul 6, 2012
I am busy with a project, it is going to consist out of 3 different windows which is logic enough for this whole code to be interactive.
It must be able to pull data into a windows form, displaying it into a textbox, and when you click on the textbox it needs to open up another window where you will have a windows form that will display data as the code loops through the questions in the database.
I am not sure how to push the data that has been selected on the database to the next window..
Here is my code for the first window:
;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form {
//SqlConnection myConnection = new SqlConnection("Data Source=(local);Initial Catalog=KnowledgeEssentials;Integrated Security=SSPI");
//int intType = 0;
public Form1()
[code].....
With the second window the data in the table needs to be displayed and each row from the table needs to have a checkbox next to them, so that if the check box is checked, the relevant information of the checked row will show up in the 3rd window... so MY question is, HOW do I pull that data from that specific database and let it show in the listcheckbox?
View 1 Replies
View Related
Dec 11, 2013
I need to find if a file is locked, but I dont want to open the file as I will be checking 1000's of files.
can I do that in C++ or VC++
View 10 Replies
View Related
Oct 30, 2014
I have a button that opens a file dialog box so that a user can pick a file. I only need it for the path and file name to be passed to another program. I do not want to open the file or care about its contents. I just want the name and path.
private void button1_Click(object sender, EventArgs e)
{
OpenFileDialog dialog = new OpenFileDialog();
[Code].....
The problem is that as long as the program is running the file that the user picked is locked for editing. Adding the Dispose() had no affect. Multiselect and ReadOnlyChecked have no affect. Only closing the application frees the file.
View 7 Replies
View Related
Nov 30, 2013
I wrote a Windows application that comes with two modules: service and user-mode exes. The service implements its own scheduler and may log-off a user at a predefined time. For that I was using the following call that is triggered from my user-mode module exe in a logged-on user session that has to be logged off:
Code : BOOL result = ExitWindowsEx(EWX_LOGOFF, reason);
This works fine, except of the situation when a user's account is locked. In that case that API doesn't seem to do anything at all even through I get 1 returned from it.
So I was curious, is there any other way to log off a user when their account is locked? (One condition I have in this case is that if that user had any unsaved documents then the log-off should not be forced.)
View 9 Replies
View Related
Nov 23, 2014
I have a non form class. I want to update label/ check status of check box etc.. in non form class ( here resides functions that contains logic). How can i do that ?
View 4 Replies
View Related
Nov 11, 2013
I'm currently in the middle of designing a program for some project. one part of the program is to send reminding SMS messages to the employees.
I have already subscribed to a SMS provider that has SMS integration - API. But now I'm wondering how will I be able connect to the SMS server and be able to send messages?
View 1 Replies
View Related
Jan 19, 2015
I have a mobile application for android coded in javascript and a windows form coded in c#. I want my mobile app to send some data to the c# program. It is fine if the transmission is not secure. I searched the net. I found a site called pastebin.com. Unfortunately it provides api for posting and reading data. However I want something, where I can store,read as well as EDIT the data.
View 7 Replies
View Related
Feb 3, 2012
So I have my GUI far along enough to start incorporating my program, but I am hesitant to start because I want to be careful to do it in an effective and easy to manage way.
The code so far for the GUI alone is about 2100 lines, and I estimate it will be about 8000-10000 lines long when the program is complete. The code for the actual program (without GUI), is about 6000 lines long so far, and will probably get up to about 10,000 when I've added most of what I intend.
Is it a good idea to have the GUI portion, or at least some of it in a separate source file? If you were to do this, how would you? Obviously you can only have one main function. Would you have a file just for the main function, a header file with all the necessary includes and global variables, and put different portions of the rest in separate files.
Concerning the GUI; In my main function, if you click a button, a function connected to that button is called. Inside that function, I may have code to hide many other buttons while this button is selected; Also to manage effects which see visually which button is selected. My program so far has like 70 different GUI objects which all get modified, hidden, shown, etc in different circumstances, and multiple menus.
My question; what's the most reasonable way to do this? Right now all my buttons, and their associated objects are all global. Is this reasonable? Is there an exception to the globals are bad rule in cases like this?
View 8 Replies
View Related
Apr 22, 2014
I hav created mdi parent form that contain one user control. I want to access that user control from one of the child form
View 4 Replies
View Related
Aug 25, 2014
This is more of a Application Design question, Let's say I have Form1(Login), this is opened from Program.cs, when the user enters details, the Event Handler makes a instance of a class, adds the data and stores the instance within Program.cs class.
So the best thing to do here, is to close the Form1(Login) and open Form2(Main) via Program.cs so that I can send the List<Login> object with my Login instance objects to said form. This form will remain open throughout the applications use as it's like the main GUI for all the programs functions.
When I close this form, I may want to save some information before the application is terminated, so I may as well store the Login instances in Program.cs anyway.
Main stepping stone: Multiple (usually around 3 max) users can login this system if need be, which will mean closing Form2(Main) and then opening Form1(Login) so that once Form1 is closed it can recreate the From2(Main) form and pass the new List<Login> to that form.
What's the best way to do this, at the moment i'm creating the Form2 instance like so:
//....
//Detect the Login form being closed
loginForm.Closed += new EventHandler(OnLoginClosed);
//...
//Open the main form when the login is closed
private void OnLoginClosed(object sender, EventArgs e)
[Code] .....
This seems like it will work and do the job, but is there a better and cleaner way? The List<Login> will be passed to Forms which are created via Form2(Main) as this information will be needed. It's just that ive been told not to use Forms for too much data containment.
View 2 Replies
View Related
May 30, 2013
I need to create a client and server program. The client will have a GUI that will display all the available servers (since more than one will be running) in a list box.
I’m guessing a TCP connection will be the best method here, but how will the client find the servers to connect to? I won’t know the IP address of the server because anyone could take the server program and run it on their computer and the client would have to find it.
Is there some way to make the server send some kind of signal that only the client application will be to connect to? So the server will be sending out a signal, the client finds the signal and connects to the server. Is this possible?
i also need to be able to store the IP address the client selects so when the client application is run again it will automatically connect to the server that was stored.
View 19 Replies
View Related
Apr 1, 2013
I have a map that is full of 4+ rooms each with one randomly selected door on one of its sides. I need to create a tunnel connecting all of the doors together. I'm not sure the best way to do this A* seems to complicated for me to do at the moment and I cannot think of a way to connect these rooms.
My world is currently a vector<vector<Tiles>> and the tiles contain entities like tunnel, wall, stair, floor, etc.
View 8 Replies
View Related
Oct 19, 2014
I'm trying to make my 1v1 game playable online and I would like to have the 2 players connected directly rather than trough a server.
The problem I'm having is that I don't have any experience with server client communication or internet libraries in c++
View 4 Replies
View Related
May 17, 2013
I am gonna make a simple game in c++. I need a way how to use a particular key on the keyboard ,when I hit the key certain function should be called.
For movement of cursor on screen I want to connect arrow keys.
View 4 Replies
View Related
Nov 11, 2013
I'm currently in the middle of designing a program for some project. one part of the program is to send reminding SMS messages to the employees.
I have already subscribed to a SMS provider and they gave me an access to a control panel (aspx). But now I'm wondering how will I be able connect to the SMS server and be able to send messages?
View 11 Replies
View Related
Mar 10, 2015
I have a form with 2 text boxes (Email and Password)
The user fills in the text boxes and clicks on the Log in button. The code behind the log in button does the following, First connects to a table (Users) in phpmyadmin. Next runs a SQL query (SELECT * FROM `users` WHERE Email = '" + sEmail + "' AND Password = '" + sPassword + "'") sEmail being the variable created from the text entered in Email text box and the same for password.
Next if the record count == to 1 it opens up the main menu form and if the record count == 0 it fails and the user does not get to the main menu.
All of the above is fine and working however what I want to do is take over a variable from the log in form to the other forms.
The code is below for the sign in button as all my code is behind that (I think this may be where I'm going wrong).
public partial class WelcomeForm : Form{
public static string connStr = "server = localhost; " +
"database = ppw5; " +
"uid = James; " +
"pwd = buster;";
[Code] .....
And the Main menu form where I'd like to take a variable over with me, lets assume the variable is the UserID from the database table that I pull from the dTable I created.
public partial class MenuForm : Form {
//Call the CloseProgram class and create a new method called ClassClose.
CloseProgram ClassClose = new CloseProgram();
WelcomeForm User = new WelcomeForm();
public MenuForm() {
InitializeComponent();
[Code] .....
View 7 Replies
View Related
Dec 6, 2014
I have a program which when a button is clicked on Form1 it runs a vision system operation on an image in a window on a Form1. There are also other buttons on the Form1 which can change things like threshold levels so the inspection can be run again with different settings. It all works fine but I want to change it to remove the buttons from Form1 so that when the user clicks on a button on Form1 it opens up another form, Form2, and all the buttons which were on Form1 are now on Form2 and the image analysis should run on Form1 when the buttons are used on Form2. I have taken over all the code from Form1 to Form2 and I'm trying to make this happen by creating a new oject on Form1 which calls a method on Form2 which contains the code which was in Form1 and called when the button was clicked on Form1 - not working!! I have a constructor in Form2 but I think I have become monumentally confused.
This was the code which was on Form1 when the inspection button was clicked.
private void cmdInspectOnce_Click(object sender, EventArgs e)
{
iReturn = VisionSystem.InvModeSet(IpeEngCtrlLib.I_MODE.I_EXE_MODE_ONCE);
if (_imgEngines!=null && _imgEngines[0]!=null)
_imgEngines[0].cmdInspectOnce();//InvModeSet(IpeEngCtrlLib.I_MODE.I_EXE_MODE_ONCE);
}
View 1 Replies
View Related
Sep 5, 2014
I have 3 Windows Form: frmMain, frmFirstForm, and frmSecondForm.
frmMain is the form that will load when the application is started with 2 tabs to access frmFirstForm and frmSecondForm.
Here's my problem:
After making a selection from a combobox on frmFirstForm, I would like a datagridview header to change based on the selection made. Here is a list of items on one combobox: Item1, Item2, Item3, Item4. When somebody chooses Item one, the header on the datagridview on frmSecondForm should display: JohnItem1, PaulItem1, BradItem1 and so on. Those items are not part of the comboboxes, but they will be shown as header text on the datagridview on the second form either automatically or after clicking OK from frmMain. There's no OK button on frmFirstForm, but on frmMain.
The only code I have right now is the if statement on the form load on frmSecondForm. Here's what I have:
private void HeaderTextLoad() {
if(comboboxonfirstform.text = "Item1") {
datagridview1.Columns[0].HeaderText = "ItemJohn";
datagridview1.Columns[1].HeaderText = "ItemPaul";
... And so on.
}
}
View 1 Replies
View Related
Oct 4, 2014
3 3
2 1 3 2 3
1 0 2
1 2 6
First line shows row and column number
First index of the second line tells the number of non-zero entries of the first row and second index tell the column number where the non zero entry is placed
for 1st row of matrix:
non-zero entries=2
column number=1
non-zero entry=3
column number=2
non-zero entry=2
covert this in the given form
0 3 3
2 0 0
0 0 6
View 1 Replies
View Related
Jul 26, 2014
I have a gridview setup. It adds data into it no problem, but if I try and see it on the screen nothing appears?
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.Linq;
namespace FinalProject{
public partial class WebForm1 : System.Web.UI.Page
[Code] ....
View 11 Replies
View Related
Aug 8, 2014
I need writing a program in c++ that will get the input of 50 different users for the following the fields (surname, other names, sex, status, date of birth) and after entering the data for these 50 users, it will then output only the list of all FEMALE users who were registered...
#include <iostream>
#include <string>
using namespace std;
int main () {
string surname, other_names1, other_names2, status, sex, dob;
[Code] ....
I don't really know what to do next - all my attempts have not really given me the result I want.
View 19 Replies
View Related
Mar 11, 2015
I want to update a label from Form2. When I click on the button on Form 2, the textbox on Form2 should update the label on Form1 and take me to a certain website. What ever URL is typed into the textbox on Form2 is what website URL the label on Form1 will take me to. The label on Form1 can say something such as You can check out my website here!!! and when they click on the saying it takes me to their website.
View 2 Replies
View Related
Jun 29, 2014
I have a label on my main form. When I menu select my settings form, I make a change to the label text on the main form but the label text does not update with the new text.
So here is my code in my settings form:
MainForm frm = new MainForm();
frm.paintMainFormThemeTitle(logoText); // updates the main form label
I may not fully understand the new instantiate key word, but doesn't this create another, new copy of my main form to operate on? And isn't that why I can't see my label text change on my main form that is previously in view?
All of the examples that I have been able to find show using this new key word to be able to access a component on another form. But to my understanding, I'm creating another, new form.
View 5 Replies
View Related
