protected void update_button(object sender, EventArgs e)
{
ADOlayer ado = new ADOlayer();
string ex = ado.updateRec(Convert.ToInt32(T1.Text), float.Parse(T2.Text.ToString()));
label1.Text = ex;
}
protected void button1_click(object sender, EventArgs e)
{
int eid = int.Parse(TextBox1.Text);
string ename = Convert.ToString(TextBox2.Text);
long ssn = long.Parse(TextBox3.Text);
double esal = double.Parse(TextBox4.Text);
DateTime dob = Convert.ToDateTime(TextBox5.Text);
int did = int.Parse(TextBox6.Text);
ADOlayer ado = new ADOlayer();
ado.insertrecord(eid, ename, ssn, esal, dob, did);
//string constr = "";
//constr = ConfigurationManager.ConnectionStrings["myconstring"].ConnectionString;
//try
//{
// SqlConnection con = new SqlConnection(constr);
// con.Open();
// DataSet ds = new DataSet();
//
// string query="insert into Employee (EmployeeId,EmployeeName,SSN,EmployeeSalary,DOB,Deptid) values("+eid+",'"+ename+"',"+ssn+","+esal+",'"+dob+"',"+did+")";
// SqlCommand cmd = new SqlCommand(query, con);
// int i=cmd.ExecuteNonQuery();
}
protected void Page_Load(object sender, EventArgs e)
{
ADOlayer ado = new ADOlayer();
var stlist = ado.Getallrecords();
GridView1.DataSource = stlist;
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
ADOlayer ad = new ADOlayer();
int Id = Convert.ToInt32(Id1.Text);
string Sname = Sname1.Text;
ad.UpdateRecord(Id, Sname);
var t = ad.Getallrecords();
GridView1.DataSource = t;
GridView1.Dispose();
ADOlayer ado = new ADOlayer();
var stlist = ado.Getallrecords();
GridView1.DataSource = stlist;
GridView1.DataBind();
}