UserID and Password

Question

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

ibrahimtopcuoglu · Answer

THANK YOU VERY MUCH.

robin 0 · Answer

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+;;