string connection = System.Configuration.ConfigurationManager.ConnectionStrings["itax"].ConnectionString; SqlConnection con = new SqlConnection(connection); con.Open(); SqlCommand cmd = new SqlCommand("SELECT @UserId 'UserId',@userPassword 'userPassword' FROM Userlogin WHERE UserId = @UserId", con); cmd.Parameters.Add("@UserId", SqlDbType.VarChar, 50).Value = lbl_Employee_code.Text; cmd.Parameters.Add("@userPassword", SqlDbType.VarChar, 50).Value = lbl_employee_name.Text; cmd.ExecuteNonQuery(); con.Close();
SqlDataReader
SqlDataReader dr=cmd.ExecuteQuery(); if(dr.Read()) { Label1.Text=dr["UserId"].ToString(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)