2008 Giugno 30>>MDSoft Weblog

Archive for Giugno 30th, 2008

ExecuteDataTable With Multible Parameters

CodeKeep C# Feed Giugno 30th, 2008

Description: ExecuteDataTable With Multible Parameters (Paging?)

Link: http://www.codekeep.net/snippets/188dacd9-459c-4043-9ff2-1cded2bf33c4.aspx

public DataTable GetDataResults(string parameter, int pageIndex, int pageSize)
{
	MyDbParameterCollection parameters = dbHelper.CreateParameterCollection();
	parameters.AddWithValue("@Parameter", parameter);
	parameters.AddWithValue("@PageIndex", pageIndex);
	parameters.AddWithValue("@PageSize", pageSize);
	return dbHelper.ExecuteDataTable(commandText, parameters.ToArray());
}

ExecuteDataTable With Single Parameter

CodeKeep C# Feed Giugno 30th, 2008

Description: ExecuteDataTable With Single Parameter

Link: http://www.codekeep.net/snippets/0298a377-504e-47fb-9382-c4d87bd6ca20.aspx

public DataTable GetDataResult(string parameterValue)
{
    DbParameter parameter = dbHelper.CreateParameterWithValue(":Parameter", parameterValue);
    return dbHelper.ExecuteDataTable(commandText, parameter);
}