C# - Basic CRUD operation for SQL

//Basic SELECT method to populate a DataSet from a SqlDataAdapter

SqlConnection sqlConn = new SqlConnection(connection string here);

SqlDataAdapter sqlAdapt = new SqlDataAdapter(@"SELECT * FROM tableName WHERE conditionColumn='False'", sqlConn);

SqlCommandBuilder sqlCmdBuilder = new SqlCommandBuilder(sqlAdapt);

DataSet sqlSet = new DataSet();

sqlAdapt.Fill(sqlSet, "dataSetTableName");

sqlConn.Close();

//Basic INSERT method with Parameters

SqlConnection sqlConn = new SqlConnection(connection string here);

SqlCommand sqlComm = new SqlCommand();

sqlComm = sqlConn.CreateCommand();

sqlComm.CommandText = @"INSERT INTO tableName (paramColum) VALUES (@paramName)";

sqlComm.Parameters.Add("@paramName", SqlDbType.VarChar);

sqlComm.Parameters["@paramName"].Value = paramSource;

sqlConn.Open();

sqlComm.ExecuteNonQuery();

sqlConn.Close();

//Basic UPDATE method with Parameters

SqlConnection sqlConn = new SqlConnection(connection string here);

SqlCommand sqlComm = new SqlCommand();

sqlComm = sqlConn.CreateCommand();

sqlComm.CommandText = @"UPDATE tableName SET paramColumn='@paramName' WHERE conditionColumn='@conditionName'";

sqlComm.Parameters.Add("@paramName", SqlDbType.VarChar);

sqlComm.Parameters["@paramName"].Value = paramSource;

sqlComm.Parameters.Add("@conditionName", SqlDbType.VarChar);

sqlComm.Parameters["@conditionName"].Value = conditionSource;

sqlConn.Open();

sqlComm.ExecuteNonQuery();

sqlConn.Close();

//Basic DELETE method with Parameters

SqlConnection sqlConn = new SqlConnection(connection string here);

SqlCommand sqlComm = new SqlCommand();

sqlComm = sqlConn.CreateCommand();

sqlComm.CommandText = @"DELETE FROM tableName WHERE conditionColumn='@conditionName'";

sqlComm.Parameters.Add("@conditionName", SqlDbType.VarChar);

sqlComm.Parameters["@conditionName"].Value = conditionSource;

sqlConn.Open();

sqlComm.ExecuteNonQuery();

sqlConn.Close();