//insert to database SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["connect"].ToString()); con.Open(); string empcode = txtempcode.Text; string empname = txtEmpname.Text; SqlCommand com = new SqlCommand(); com.Connection = con; com.CommandText = "insert into ankemp values(@empcode,@empname)"; com.Parameters.Add("@empcode", empcode); com.Parameters.Add("@empname", empname); com.ExecuteNonQuery(); bindgrid(); //datasource to grid void bindgrid() { SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["connect"].ToString()); con.Open(); string query = "select * from ankemp"; SqlDataAdapter da = new SqlDataAdapter(query.ToString(), con); DataTable dt = new DataTable(); da.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); } //while clicking the fetch button in grid (in aspx page protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "fetch") { int empcode = int.Parse(e.CommandArgument.ToString()); fetch(empcode); } } //fetch method public void fetch(int empcode) { SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["connect"].ToString()); con.Open(); txtempcode.Text = empcode.ToString(); StringBuilder sb = new StringBuilder(); sb.Append(" select empname, "); sb.Append(" from ankemp where empcode="+empcode); SqlCommand com = new SqlCommand(sb.ToString(), con); SqlDataReader dr = com.ExecuteReader(); if (dr.Read()) { txtEmpname.Text = dr["empname"].ToString(); } //update SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["connect"].ToString()); con.Open(); string empcode = txtempcode.Text; string empname = txtEmpname.Text; string update = "update ankemp set empname='" + empname + "'where empcode='" + empcode + "'"; SqlCommand cmd = new SqlCommand(update, con); cmd.ExecuteNonQuery(); bindgrid(); con.Close(); //deleteing (in aspx page protected void GridView1_RowDeleting(object sender, GridViewDe
