how to compare textbox with database

Question

I have one table in which I have two column. I need to compare those columns value by textbox, one by one.

Eg: If user will enter user name and password then it will check in the database that it is correct or not.

Please reply for this....

Amruta Kirdat · Answer

hiii chk following code //for this i used access database and assume you have two txtboxes to take input for Name and Password resp. oledbConnection conn = new OleDbConnection(strConn); //strConn is your connectionString string strQuery = "Select Name,Password from Login"; //Table Name : Login with two Clmns:Name and Password conn.open(); oledbCommand cmd = new OleDbCommand(strQuery,conn); oledbAdapter adapter = new OleDbAdapter(cmd); dataset ds = new dataset(); adapter.Fill(ds); conn.close(); //declare these variables at beginning string strName; string strPassword; string strNameText; string strPassText; strNameText = txtName.Text; //textbox from where you r taking i/p strPassText = txtPassword.text; if(ds.tables[0].rows.count>0) { for(int i=0;i { strName = convert.ToString(ds.tables[0].rows[i]["Name"].tostring()); //fetch Name clm from db strPasword = convert.ToString(ds.tables[0].rows[i]["Password"].tostring()); if(strNameText == strName && strPassText == strPasword) { //correct; } else { //incorrect } } }

Sahil Jani · Answer

Thanks Amruta, I got what I want from your reply. Thank-you so much.

Sahil Jani · Answer

Thanks Micke, I got the idea what youwant to say is but I a using MS-Access database and it doesn't provide stored procedure from my knowledge. And I am realy sory that I forgot to write down in question that I am using MS-Access. BDW thank-you very much for your reply.

Micke Blomquist · Answer

First you need a stored procedure in the database responding with a record if the username and password are correct. Creat this: CREATE PROCEDURE [dbo] . [GetUserInfo] @username varchar ( 10 ), @pwd varchar ( 10 ) AS BEGIN select userid , username , email from users where userid = @username and pwd = @pwd END Then you need to invoke that procedure from your form. Put this in your click event: try { using ( SqlConnection c = new SqlConnection (c_string)) { using ( SqlCommand cmd = new SqlCommand ( "GetUserInfo" , c)) { cmd.CommandType = CommandType .StoredProcedure; cmd.Parameters.AddWithValue( "@UserId" , value_from_textbox1); cmd.Parameters.AddWithValue( "@Pwd" , value_from_textbox2); using ( DataSet dsUser = new DataSet ()) { u sing (System.Data.SqlClient. SqlDataAdapter da = new SqlDataAdapter (cmd)) { c.Open(); da.Fill(dsUser); c.Close(); // dsUser should contain of one row } } } } } catch ( Exception rror) { throw new Exception ( "Couldn't fetch user from database. Msg: " + rror.Message); } If you get a datarow back from the database, your user has been validated. This is very simple described, but I'll guess you get the point.

how to compare textbox with database

Answers (4)