SQL Insert/Update/Select/Delete using C#

more

1. //Basic SELECT method to populate a DataSet from a SqlDataAdapter
2. SqlConnection sqlConn = new SqlConnection(connection string here);
3. SqlDataAdapter sqlAdapt = new SqlDataAdapter(@"SELECT * FROM tableName WHERE conditionColumn='False'", sqlConn);
4. SqlCommandBuilder sqlCmdBuilder = new SqlCommandBuilder(sqlAdapt);
5. DataSet sqlSet = new DataSet();
6. feedbackAdapt.Fill(sqlSet, "dataSetTableName");
7. feedbackConn.Close();
9. //Basic INSERT method with Parameters
10. SqlConnection sqlConn = new SqlConnection(connection string here);
11. SqlCommand sqlComm = new SqlCommand();
12. sqlComm = sqlConn.CreateCommand();
13. sqlComm.CommandText = @"INSERT INTO tableName (paramColum) VALUES (@paramName)";
14. sqlComm.Parameters.Add("@paramName", SqlDbType.VarChar);
15. sqlComm.Parameters["@paramName"].Value = paramSource;
16. sqlConn.Open();
17. sqlComm.ExecuteNonQuery();
18. sqlConn.Close();
20. //Basic UPDATE method with Parameters
21. SqlConnection sqlConn = new SqlConnection(connection string here);
22. SqlCommand sqlComm = new SqlCommand();
23. sqlComm = sqlConn.CreateCommand();
24. sqlComm.CommandText = @"UPDATE tableName SET paramColumn='@paramName' WHERE conditionColumn='@conditionName'";
25. sqlComm.Parameters.Add("@paramName", SqlDbType.VarChar);
26. sqlComm.Parameters["@paramName"].Value = paramSource;
27. sqlComm.Parameters.Add("@conditionName", SqlDbType.VarChar);
28. sqlComm.Parameters["@conditionName"].Value = conditionSource;
29. sqlConn.Open();
30. sqlComm.ExecuteNonQuery();
31. sqlConn.Close();
33. //Basic DELETE method with Parameters
34. SqlConnection sqlConn = new SqlConnection(connection string here);
35. SqlCommand sqlComm = new SqlCommand();
36. sqlComm = sqlConn.CreateCommand();
37. sqlComm.CommandText = @"DELETE FROM tableName WHERE conditionColumn='@conditionName'";
38. sqlComm.Parameters.Add("@conditionName", SqlDbType.VarChar);
39. sqlComm.Parameters["@conditionName"].Value = conditionSource;
40. sqlConn.Open();
41. sqlComm.ExecuteNonQuery();
42. sqlConn.Close();