public void deletedata(propertyservice p) { cmd = new SqlCommand("delete from info where id=@id", con); cmd.Parameters.AddWithValue(@"id", p.id); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
public void insertdata(propertyservice p) { cmd = new SqlCommand("insert into info values(@fname, @lname)", con); cmd.Parameters.AddWithValue(@"fname", p.fname); cmd.Parameters.AddWithValue(@"lname", p.lname); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
public void updatedata(propertyservice p) { cmd = new SqlCommand("update info set fname=@fname,lname=@lname where id=@id", con); cmd.Parameters.AddWithValue(@"id", p.id); cmd.Parameters.AddWithValue(@"fname", p.fname); cmd.Parameters.AddWithValue(@"lname", p.lname); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }