Home
Manage Your Code
Snippet: ExecuteDataTable With Multible Parameters (C#)
Title: ExecuteDataTable With Multible Parameters Language: C#
Description: ExecuteDataTable With Multible Parameters (Paging?) Views: 121
Author: Eric Fine Date Added: 6/30/2008
Copy Code  
1public DataTable GetDataResults(string parameter, int pageIndex, int pageSize)
2{
3	MyDbParameterCollection parameters = dbHelper.CreateParameterCollection();
4	parameters.AddWithValue("@Parameter", parameter);
5	parameters.AddWithValue("@PageIndex", pageIndex);
6	parameters.AddWithValue("@PageSize", pageSize);
7	return dbHelper.ExecuteDataTable(commandText, parameters.ToArray());
8}