con.Open();
cmd = new SqlCommand("select count(*) from CUM_Dist_Users where CUM_UserName='" + txt_username.Text + "' and CUM_Password='" + txt_password.Text + "'", con);
a = Convert.ToInt32 (cmd.ExecuteScalar());
if (a == 1)
{
cmd = new SqlCommand("G_dis_suggselect", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CUM_usrnm",txt_username.Text);
cmd.Parameters.AddWithValue("@CUM_pwd", txt_password.Text);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
Session["s_cuid"] = Convert.ToInt32(dr.GetValue(1).ToString());
Session["s_ccmpycd"] = dr.GetValue(0).ToString();
Session["s_cfstnm"] = dr.GetValue(3).ToString();
Session["s_clstnm"] = dr.GetValue(4).ToString();
Session["s_cdesg"] = dr.GetValue(2).ToString();
Session["s_cemail"] = dr.GetValue(8).ToString();
Session["s_cphone"] = dr.GetValue(6).ToString();
Session["s_cmpynm"] = dr.GetValue(9).ToString();
}
Response.Redirect("Dis_Home.aspx");
}
else
{
ScriptManager.RegisterStartupScript(this.Page,this.GetType(),"Alert","alert('Enter the valid username & password')",true);
}
This post has been edited by eclipsed4utoo: 01 April 2011 - 06:49 AM
Reason for edit:: LEARN TO USE THE CODE TAGS...[code] your code here [/code]

New Topic/Question
Reply



MultiQuote




|