public void Sil(Sira s)
{
try
{
cmd.CommandText = "Delete From Sira Where hasta_TC=" + s.Hasta_TC + "";
cmd.CommandType = CommandType.Text;
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
if (con != null)
{
con.Close();
}
}
}
public void Ekle(Sira s)
{
try
{
cmd.CommandText = "Insert Into Sira (hasta_TC, doktor_TC, hasta_Sira, hasta_Durum) Values (" + s.Hasta_TC + ",'" + s.Doktor_TC + "','" + s.Hasta_Sira + "','" + s.Hasta_Durum + "')";
cmd.CommandType = CommandType.Text;
con.Open();
cmd.ExecuteNonQuery();
}
catch (Exception)
{
throw;
}
finally
{
if (con != null)
{
con.Close();
}
}
}
