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();
}
