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