If a dataset contains 100 rows, how to fetch rows between 10
and 20 only ?
Answer Posted / abhishek_gp3
Use Overloaded Fill() function of SqlDataAdapter Class of System.Data.SqlClient namespace.
Fill(1,2);
1- Dataset object
2- Table name
Fill(1,2,3,4);
1- Dataset Object
2- Starting Rec.
3- End Rec.
4- Table Name
--
Sample prog:
------
using System;
using System.Windows;
using System.Data;
using System.Data.SqlDataAdapter;
Class FetchRec
{
SqlConnection Con;
SqlDataAdapter Adap;
Dataset ds;
Public FetchRec()
{
Con = new SqlConnection("initial catalog=master;integrated security=yes");
Con.Open();
Adap= new SqlDataAdapter("Select ID, Name from Employee where ID > 110");
ds= new Dataset();
}//constructor end
try{
ds = Adap.Fill(ds, 10, 20, "Employee");
int rcount=ds.Tables["Employee"].Rows.Count;
for(int i=0; i < rcount ; i++)
{
Console.Writeline(ds.Tables["Employee"].Rows[i][0] + ds.Tables["Employee"].Rows[i][1]);
}
con.close();
} //try end
catch(SqlException exp)
{
MessageBox.Show(exp.Message);
}
}//class end
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Define ado.net?
Which namespaces are used for data access?
Does entity framework use ado.net?
What is ado code?
What is the difference between linq and ado.net?
What are the different execute methods of Ado.Net?
What is datasource in ado.net?
How would you connect to a database by using .NET?
What is ado.net explain with diagram?
What are the steps you will take to improve performance? Will you use dataset or datareader?
What is serialization and de-serialization in .net?
What are the different methods available under the sqlcommand class to access the data?
how Sequence to connect and retrieve data from database using dataset?
Which is faster sqldataadapter and sqldatareader?
differences between ADO and ADO.NET