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
Explain the advantage of ADO.Net?
What are the 3 major types of connection objects in ado.net?
What is full form of ado?
Does executenonquery return a value?
Define ado.net?
What are the advantage of ado.net?
What is data access pattern?
Explain the difference between data reader and data set?
Can you explain how to enable and disable connection pooling?
What is sqldatasource?
What is ole data type?
How do you connect to sql server database without using sqlclient?
Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.
Give few examples of datareader that is used in different dataproviders.
how to create a quiz software using 4 options to answer and how to check with answers in the database and award marks....