UserID and Password

ibrahimtopcuoglu

1.I m a begining student of C#.I want to do form with userid and password boxes by using access table.How can I do this.Would you like to tell me step by step. 2.if I do like this -----string sorgusu=string.Format("SELECT COUNT(UsersID) FROM Users WHERE UserName = '50' AND UserPassword = 'A1'");---------form is working but if it is like this string sorgusu=string.Format("SELECT COUNT(UsersID) FROM Users WHERE UserName = textBox1.text AND UserPassword = textBox2.text"); WHAT MUST I DO? 3.IS THERE ANY NOTES ABOUT SELECTION STATEMENTS WHICH IS USED IN C# FOR ACCESS TABLES THANKS YOU VERY MUCH

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

ibrahimtopcuoglu22y ago
THANK YOU VERY MUCH.
robin 022y ago
try this: string sorgusu=string.Format("SELECT COUNT(UsersID) FROM Users WHERE UserName = {0} AND UserPassword = {1}", textBox1.text, textBox2.text); or this: string sorgusu="SELECT COUNT(UsersID) FROM Users WHERE UserName = "+textBox1.Text+" AND UserPassword = "+textBox2.Text+";";