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));
}
