public SqlCommand GetSql(string sqlString, int caseSwitch2, object[,] array, bool i) { conn = DB_Connection.GetConnection(); //object[,] k = array; using (SqlCommand cmd = conn.CreateCommand()) // SqlCommand cmd = new SqlCommand("stored_procedure", conn) { if (conn.State.ToString() == "Closed") { conn.Open(); } using (SqlTransaction tr = conn.BeginTransaction()) { cmd.Connection = conn; cmd.Transaction = tr; cmd.CommandType = CommandType.Text; cmd.CommandText = sqlString; if (i) { //cmd.Parameters.AddWithValue(array[0, 0].ToString(), array[0, 1]); //cmd.Parameters.AddWithValue(array[1, 0].ToString(), array[1, 1]); //cmd.Parameters.AddWithValue(array[2, 0].ToString(), array[2, 1]); for (int x = 0; x < array.GetLength(0); x += 1) { cmd.Parameters.AddWithValue(array[x, 0].ToString(), array[x, 1]); } } //foreach(a in b) //{ // cmd.Parameters.AddWithValue("@" + value, atribute); //} //for (int x = 0; x < array.GetLength(0); x += 1) //{ // for (int y = 0; y < array.GetLength(1); y += 1) // { // Console.Write(array[x, y]); // } //} switch (caseSwitch2) { case 1: cmd.ExecuteNonQuery(); break; case 2: var count = (int)cmd.ExecuteScalar(); break; case 3: var count2 = (bool)cmd.ExecuteScalar(); break; } //some code tr.Commit(); //tr.Dispose(); } return(cmd); } }
public DB_Access() { conn = DB_Connection.GetConnection(); }