private void button1_Click(object sender, EventArgs e)
{
var Connect = ConfigurationManager.ConnectionStrings["Test"];
var qury = "SELECT * FROM users WHERE Username = @username and password=@password";
string returnValue = "";
using (SqlConnection conn = new SqlConnection(**Connect**))
{
using (SqlCommand sqlcmd = new SqlCommand(qury, conn))
{
sqlcmd.Parameters.Add("@username", SqlDbType.VarChar).Value = textBox1.Text;
sqlcmd.Parameters.Add("@password", SqlDbType.VarChar).Value = textBox2.Text;
conn.Open();
returnValue = (string)sqlcmd.ExecuteScalar();
}
}
}
private void button1_Click(object sender, EventArgs e)
{
var Connect = ConfigurationManager.ConnectionStrings["Test"];
var qury = "SELECT * FROM users WHERE Username = @username and password=@password";
string returnValue = "";
using (SqlConnection conn = new SqlConnection(**Connect**))
{
using (SqlCommand sqlcmd = new SqlCommand(qury, conn))
{
sqlcmd.Parameters.Add("@username", SqlDbType.VarChar).Value = textBox1.Text;
sqlcmd.Parameters.Add("@password", SqlDbType.VarChar).Value = textBox2.Text;
conn.Open();
returnValue = (string)sqlcmd.ExecuteScalar();
}
}
}