public List <prvdate> Find_rec(Int32 id) { if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("findvdate", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@id", SqlDbType.Int).Value = id; SqlDataReader dr = cmd.ExecuteReader(); List <prvdate> obj = new List <prvdate>(); if (dr.HasRows) { dr.Read(); prvdate k = new prvdate(); k.id = Convert.ToInt32(dr[0]); k.venue = dr[1].ToString(); obj.Add(k); } dr.Close(); cmd.Dispose(); con.Close(); return(obj); }
public List <prvdate> Disp_Rec() { if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("disvdate", con); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader dr = cmd.ExecuteReader(); List <prvdate> obj1 = new List <prvdate>(); while (dr.Read()) { prvdate k = new prvdate(); k.id = Convert.ToInt32(dr[0]); k.venue = dr[1].ToString(); obj1.Add(k); } dr.Close(); cmd.Dispose(); con.Close(); return(obj1); }
public void Del_rec(prvdate p) { if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("delvdate", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@id", SqlDbType.Int).Value = p.id; cmd.ExecuteNonQuery(); cmd.Dispose(); con.Close(); }
public void Save_Rec(prvdate p) { if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmd = new SqlCommand("insvdate", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@venue", SqlDbType.VarChar, 50).Value = p.venue; cmd.ExecuteNonQuery(); con.Close(); cmd.Dispose(); }