Comments by harshadcse (Top 27 by date)

protected void btnLoginPartner_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("write your connection string");
string qry;
qry = "select * from tblname where brokercode=@brokercode , username=@username and password=@password";
SqlCommand cmd = new SqlCommand(qry, con);
cmd.Parameters.AddWithValue("@brokercode", txtBrokerPartner.Text);
cmd.Parameters.AddWithValue("@username", txtusername.Text);
cmd.Parameters.AddWithValue("@password", txtpassword.Text);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
Response.Write("Welcome...");
}
else
{
Response.Write("Sorry...");
}