10-27-2011, 11:23 AM | #1 |
Kawaii Desu
Difficulty Consulting Cat
Join Date: Mar 2007
Age: 30
Posts: 4,811
|
C# programming help
In my programming class I am trying to make an SQL Database in Microsoft Visual C# 2010 Express using a windows form that would allow you to input data (such as a username and password) into the database.
This is the first time I have messed with SQL and I have no idea what I am doing >.> I am not sure what you would need to know to help me but I will provide the code I have and a SS of the table I have for the database.
__________________
|
10-27-2011, 11:38 AM | #2 |
Doing the wrong thing the right way since 2010.
Site and Game Administrator
Join Date: Jul 2007
Posts: 1,812
|
Re: C# programming help
Code:
string sqlquery = "INSTERT INTO [UserTable] (Username, Password) VALUES ('" + UsernameTextBox.Text + "," + "'" + PasswordTextBox.Text + "')"; I don't have any C# knowledge, just pointing the SQL mistype out :p Last edited by Velocity; 10-27-2011 at 11:42 AM.. |
10-27-2011, 11:47 AM | #3 |
Snek
Join Date: Jan 2003
Location: Kansas
Age: 34
Posts: 9,192
|
Re: C# programming help
I've never tried using SQL with C# but I don't see anything wrong with this simple example other than what velocity pointed out.
You have these lines both on load and when you click register. This is most likely redundant. Code:
string connection = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\UserDatabase.mdf;Integrated Security=True;User Instance=True"; SqlConnection cn = new SqlConnection(connection); |
10-27-2011, 11:52 AM | #4 |
Kawaii Desu
Difficulty Consulting Cat
Join Date: Mar 2007
Age: 30
Posts: 4,811
|
Re: C# programming help
ok thanks. I will see if that fixes things. I feel so stupid not seeing that mistype x.x
I am in lunch right now and so I won't be able to try it until my next class which is LAN.
__________________
|
10-27-2011, 12:23 PM | #5 |
FFR Player
Join Date: Sep 2005
Age: 32
Posts: 4,245
|
Re: C# programming help
Always check your database queries manually in the MySQL command line. Regardless of OS, get into its CLI and execute:
Code:
mysql -uroot -p Also if they're making you code applications that use databases with zero knowledge of them learn them. It's mind boggling to me why on earth they would do that. Edit: also instead of taking a screen shot in the MySQL CLI you can just use: DESC <tableName> then copy paste. Last edited by fido123; 10-27-2011 at 02:38 PM.. |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|
|