private SqlDataSource GetSqlStoredProceduteDataSource() { var selectCommand = SqlDataSourceSelectCommand; var connectionString = SqlDataSourceConnectionString.HasText() ? SqlDataSourceConnectionString : ConfigurationManager.ConnectionStrings["projectDBConnectionString"].ConnectionString; var result = new SqlDataSource(connectionString, selectCommand) { SelectCommandType = SqlDataSourceCommandType.StoredProcedure, UpdateCommand = SqlDataSourceUpdateCommand, InsertCommand = SqlDataSourceInsertCommand, DeleteCommand = SqlDataSourceDeleteCommand }; return(result); }
private SqlDataSource GetSqlTextSelectDataSource() { var selectCommand = MakeSqlPaginationQuery(SqlDataSourceSelectCommand, SqlDataSourceFromCommand, SqlDataSourceWhereCommand, SqlDataSourceOrderByCommand); var connectionString = SqlDataSourceConnectionString.HasText() ? SqlDataSourceConnectionString : ConfigurationManager.ConnectionStrings["projectDBConnectionString"].ConnectionString; var result = new SqlDataSource(connectionString, selectCommand) { UpdateCommand = SqlDataSourceUpdateCommand, InsertCommand = SqlDataSourceInsertCommand, DeleteCommand = SqlDataSourceDeleteCommand }; if (!PagingDisabled) { result.SelectParameters.Add("startRowIndex", DbType.Int32, SqlDataSourceStartRowIndex.ToString()); result.SelectParameters.Add("maximumRows", DbType.Int32, SqlDataSourceMaximumRows.ToString()); } return(result); }