示例#1
0
 /// <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"));
 }