public Boolean ExecuteNonQuery(string strSQL, SqlParameter[] paramList, ref string sonuc)
{
try
{
conn = new SqlConnection(DbPath);
conn.Open();
cmd = new SqlCommand(strSQL, conn);
if (paramList != null)
cmd.Parameters.AddRange(paramList);
sonuc = (cmd.ExecuteNonQuery()).ToString() + " Satır Etkilendi";
conn.Close();
return true;
}
catch (Exception hata)
{
sonuc = hata.Message.ToString();
return false;
}
}
Örnek Kullanımı :
private void KayitSil(int ID)
{
try
{
string strSQL = "delete from TabloAdi where ID=@ID";
SqlParameter[] paramList = new SqlParameter[1];
paramList[0] = new SqlParameter("@ID", strIdtEtiket);
string strSonuc = "";
ExecuteNonQuery(strSQL, paramList, ref strSonuc);
}
catch (Exception hata)
{
strSonuc=hata.Message.ToString();
}
}