public static void SQLCommand(string CommandText, CommandType CT, ExecuteReaderOrNonQuery Ex) { MyCOnnection.Open(); MyCommand = new SqlCommand(CommandText, MyCOnnection); switch (CT) { case CommandType.Text: MyCommand.CommandType = CommandType.Text; switch (Ex) { case ExecuteReaderOrNonQuery.executeReader: SqlDataReader DataReader = MyCommand.ExecuteReader(); MyDataTable = new DataTable(); MyDataTable.Load(DataReader); break; case ExecuteReaderOrNonQuery.executeNonQuery: MyCommand.Parameters.AddRange(ParameterList.ToArray()); MyCommand.ExecuteNonQuery(); break; case ExecuteReaderOrNonQuery.executeScalar: MyCommand.Parameters.AddRange(ParameterList.ToArray()); MyCommand.ExecuteScalar(); break; } MyCommand.Parameters.Clear(); ParameterList.Clear(); break; case CommandType.StoredProcedure: { MyCommand.CommandType = CommandType.StoredProcedure; switch (Ex) { case ExecuteReaderOrNonQuery.executeReader: SqlDataReader DataReader = MyCommand.ExecuteReader(); MyDataTable = new DataTable(); MyDataTable.Load(DataReader); break; case ExecuteReaderOrNonQuery.executeNonQuery: MyCommand.Parameters.AddRange(ParameterList.ToArray()); MyCommand.ExecuteNonQuery(); break; case ExecuteReaderOrNonQuery.executeScalar: MyCommand.Parameters.AddRange(ParameterList.ToArray()); MyCommand.ExecuteScalar(); break; } MyCommand.Parameters.Clear(); ParameterList.Clear(); break; } } MyCOnnection.Close(); }
public static void SQLCommandWithoutParameters(string CommandText, CommandType CT, ExecuteReaderOrNonQuery Ex) { MyCOnnection.Open(); SqlCommand MyCommand = new SqlCommand(CommandText, MyCOnnection); switch (CT) { case CommandType.Text: MyCommand.CommandType = CommandType.Text; switch (Ex) { case ExecuteReaderOrNonQuery.executeReader: SqlDataReader DataReader = MyCommand.ExecuteReader(); MyDataTable = new DataTable(); MyDataTable.Load(DataReader); break; case ExecuteReaderOrNonQuery.executeNonQuery: MyCommand.ExecuteNonQuery(); break; case ExecuteReaderOrNonQuery.executeScalar: try { scalarReturn = Convert.ToInt32(MyCommand.ExecuteScalar()); } catch { scalarReturn = 0; } break; } break; case CommandType.StoredProcedure: { MyCommand.CommandType = CommandType.StoredProcedure; switch (Ex) { case ExecuteReaderOrNonQuery.executeReader: SqlDataReader DataReader = MyCommand.ExecuteReader(); MyDataTable = new DataTable(); MyDataTable.Load(DataReader); break; case ExecuteReaderOrNonQuery.executeNonQuery: MyCommand.ExecuteNonQuery(); break; case ExecuteReaderOrNonQuery.executeScalar: MyCommand.ExecuteScalar(); break; } break; } } MyCOnnection.Close(); }