how to delete from code behind
Posted on 2006-06-19
How would I write a function to delete from a sql table in the code behind?
Would this work?
protected void DeleteRecordByID(string EMail)
String objConnection = ConfigurationManager.ConnectionStrings["MyConnection"].ToString();
String strSQL = "Delete from dbname.dbo.tblname where email ='" + EMail + "'";
SqlDataAdapter objAdapter = new SqlDataAdapter(strSQL, objConnection);
DataSet dataSet = new DataSet();