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