public string tblDataUpdateDAL(tblDataBAL tdBal) { dbc.mycon(); dbc.cmd = new SqlCommand("Update tier set password='******' where uname='@nm' ", dbc.con); dbc.cmd.Parameters.AddWithValue("@nm", tdBal.uname); dbc.cmd.Parameters.AddWithValue("@pswd", tdBal.pswd); dbc.cmd.ExecuteNonQuery(); return("Data Updated Succesfully"); }
public string tblDataInsertDAL(tblDataBAL tdBAL) { dbc.mycon(); dbc.cmd = new SqlCommand("Insert into tier values(@nm,@pswd)", dbc.con); dbc.cmd.Parameters.AddWithValue("@nm", tdBAL.uname); dbc.cmd.Parameters.AddWithValue("@pswd", tdBAL.pswd); dbc.cmd.ExecuteNonQuery(); dbc.con.Close(); return("Successfully Stored Data"); }
protected void Button1_Click(object sender, EventArgs e) { tblDataBAL tdBAL = new tblDataBAL(); tdBAL.uname = txt1.Text; tdBAL.pswd = txt2.Text; tblDataBLL tdBLL = new tblDataBLL(); string val = tdBLL.tblDataInsertBLL(tdBAL); Response.Write(val); }
public string tierDataSelectBLL(tblDataBAL tdBAL) { throw new NotImplementedException(); }
public string tblDataUpdateBLL(tblDataBAL tdBal) { tblDataDAL tdDAL = new tblDataDAL(); return(tdDAL.tblDataUpdateDAL(tdBal)); }
public string tblDataInsertBLL(tblDataBAL tdBal) { tblDataDAL tdDAL = new tblDataDAL(); return(tdDAL.tblDataInsertDAL(tdBal)); }