/// <summary> /// Sets the SQL Parameters which set the column order in the stored procedure /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void SqlDataSource_Elite_uspBMcBEARBillTracker_Selecting(object sender, SqlDataSourceSelectingEventArgs e) { e.Command.CommandTimeout = 0; e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode1(), "1")); e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode2(), "2")); e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode3(), "3")); e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode4(), "4")); e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode5(), "5")); e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode6(), "6")); e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode7(), "7")); e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode8(), "8")); e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode9(), "9")); e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode10(), "10")); e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode11(), "11")); e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode12(), "12")); e.Command.Parameters.Add(new SqlParameter(utility.GetSQLColumnCode13(), "13")); }