16 Ocak 2016 Cumartesi

c# SQL Insert/Update/Select/Delete

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