public List <clstecprp> fnd_rec(Int32 teccod) { if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("fndtec", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@teccod", SqlDbType.Int).Value = teccod; SqlDataReader dr = cmd.ExecuteReader(); List <clstecprp> obj = new List <clstecprp>(); if (dr.HasRows) { dr.Read(); clstecprp x = new clstecprp(); x.teccod = Convert.ToInt32(dr[0]); x.tecnam = dr[1].ToString(); obj.Add(x); } dr.Close(); cmd.Dispose(); con.Close(); return(obj); }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { nsskills.clstec obj = new nsskills.clstec(); nsskills.clstecprp objprp = new nsskills.clstecprp(); objprp.teccod = Convert.ToInt32(GridView1.DataKeys[e.RowIndex][0]); obj.del_rec(objprp); GridView1.DataBind(); e.Cancel = true; }
public void del_rec(clstecprp p) { if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("deltec", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@teccod", SqlDbType.Int).Value = p.teccod; cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); }
public void save_rec(clstecprp p) { if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("instec", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@tecnam", SqlDbType.VarChar, 100).Value = p.tecnam; cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); }
protected void Button1_Click(object sender, EventArgs e) { nsskills.clstec obj = new nsskills.clstec(); nsskills.clstecprp objprp = new nsskills.clstecprp(); objprp.tecnam = txttec.Text; if (Button1.Text == "Submit") { obj.save_rec(objprp); } else { objprp.teccod = Convert.ToInt32(ViewState["cod"]); obj.upd_rec(objprp); Button1.Text = "Submit"; } txttec.Text = String.Empty; GridView1.DataBind(); }
public List <clstecprp> dsp_rec() { if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("dsptec", con); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader dr = cmd.ExecuteReader(); List <clstecprp> obj = new List <clstecprp>(); while (dr.Read()) { clstecprp x = new clstecprp(); x.teccod = Convert.ToInt32(dr[0]); x.tecnam = dr[1].ToString(); obj.Add(x); } dr.Close(); cmd.Dispose(); con.Close(); return(obj); }