protected void Button1_Click(object sender, EventArgs e) { SqlConnection con = null; try { con = DBLogic.GetConnection(); con.Open(); //build a query String query = "update reg set password = '******' ,emailid='" + txtemail.Text + "' where userid = '" + txtuserid.Text + "'"; SqlCommand com = new SqlCommand(query, con); //call the method of command object int result = com.ExecuteNonQuery(); if (result > 0) { Label4.Text = "Record is UPDATED successfully"; } } catch (Exception err) { Label4.Text = err.Message; } finally { if (con != null) { con.Close(); } } }
public static RegInfo SearchSingleRecord(String uid) { SqlConnection con = null; RegInfo regobj = new RegInfo(); try { con = DBLogic.GetConnection(); con.Open(); String query = "select * from reg where userid = '" + uid + "'"; SqlCommand com = new SqlCommand(query, con); SqlDataReader dr = com.ExecuteReader(); dr.Read(); regobj.UserId = dr[0].ToString(); regobj.Pass = dr[1].ToString(); regobj.EmailId = dr[2].ToString(); } catch (Exception err) { //Label1.Text = err.Message; } finally { if (con != null) { con.Close(); } } return(regobj); }
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { SqlConnection con = null; Label1.Text = DropDownList1.SelectedValue; try { con = DBLogic.GetConnection(); String query = "select * from reg where userid = '" + DropDownList1.SelectedValue + "'"; //create the SqlDataAdapter object SqlDataAdapter da = new SqlDataAdapter(query, con); //create the object Dataset DataSet ds = new DataSet(); //Call the fill Method and pass the //DataSet object da.Fill(ds); //get the no of tables dataset contains DataTable dt = ds.Tables[0]; //bind the dataset table with the GridView GridView1.DataSource = dt; GridView1.DataBind(); } catch (Exception err) { Label1.Text = err.Message; } finally { if (con != null) { con.Close(); } } }
public static DataTable FetchAllRecord() { SqlConnection con = null; DataTable dt = null; try { con = DBLogic.GetConnection(); String query = "select * from reg "; //create the SqlDataAdapter object SqlDataAdapter da = new SqlDataAdapter(query, con); //create the object Dataset DataSet ds = new DataSet(); //Call the fill Method and pass the //DataSet object da.Fill(ds); //get the no of tables dataset contains dt = ds.Tables[0]; } catch (Exception err) { //Label1.Text = err.Message; } finally { if (con != null) { con.Close(); } } return(dt); }
protected void Button1_Click(object sender, EventArgs e) { SqlConnection con = null; try { con = DBLogic.GetConnection(); con.Open(); String query = "select * from reg where userid = '" + txtuserid.Text + "' and password = '******'"; SqlCommand com = new SqlCommand(query, con); SqlDataReader dr = com.ExecuteReader(); if (dr.Read()) { Session["uid"] = txtuserid.Text; Response.Redirect("AfterLogin.aspx"); } else { Label4.Text = "INVALID UID OR PASS"; } } catch (Exception err) { Label4.Text = err.Message; } finally { if (con != null) { con.Close(); } } }