Database

r aa j wrote:

sometimes I am getting impression....sometimes timeout expired..

<br />
int currentIndex = 0;<br />
int pageSize = 5;<br />
<br />
string orderSQL = "SELECT * FROM Orders ORDER BY OrderID";<br />
// Assumes that connection is a valid SqlConnection object.<br />
SqlDataAdapter adapter = new SqlDataAdapter(orderSQL, connection);<br />
<br />
DataSet dataSet = new DataSet();<br />
adapter.Fill(dataSet, currentIndex, pageSize, "Orders");<br />

<br />
int currentIndex = 0;<br />
	int pageSize = 5;<br />
	<br />
	DataSet oDataSet = new DataSet("MyData");<br />
	DbProviderFactory oDbFactory = System.Data.Common.DbProviderFactories.GetFactory(strProvider);<br />
	IDbConnection oConn = oDbFactory.CreateConnection(); oConn.ConnectionString = strConn;<br />
	IDbCommand oSqlCmd = oDbProviderFactory.CreateCommand(); oSqlCmd.CommandText = strCmd; oSqlCmd.Connection = oConn; oSqlCmd.CommandTimeout = 10000;<br />
	IDataParameter param = cmd.CreateParameter(); param.ParameterName = "@employeeId"; param.Value = 1120; param.Direction = ParameterDirection.Input; cmd.Parameters.Add(param);<br />
	IDataAdapter oAdapter = oDbProviderFactory.CreateDataAdapter(); oAdapter.SelectCommand = oSqlCmd; oConn.Open(); oAdapter.Fill(oDataSet, currentIndex, pageSize, "MyData");  ATTN! paging is Sql specific, i.e. oAdapter of type "SqlDataAdapter"<br />
	DataView oView = oDataSet.Tables[0].DefaultView; oView.Sort = "Column1, Column2 DESC";	<br />

devvvy wrote:

I bet paging not available to all data adapters

Mika Wendelius wrote:

In the function you fetch and concatenate the strings