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

Explain the namespaces in which .net has the data functionality class.

1089

---

What is fill method in ado.net?

982

---

What is ole used for?

942

---

What are the main differences between classic ado and ado.net?

1023

---

What do you know about ADO.NET's objects and methods?

979

---

How to load multiple tables into a dataset?

1055

---

What you mean by filtering of data?

971

---

Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.

1015

---

Which is faster ado.net or linq?

1027

---

What is data adapter in ado.net with example?

1043

---

What is the difference between ado.net and entity framework?

1050

---

Explain how to bind the controls(best practice) comboboxes to the data in the dataset?

1027

---

What is the difference between ado.net and oledb?

952

---

Which object holds only data and does not interact with data source?

990

---

How to bind the controls(best practice) comboboxes to the data in the dataset?

1050

---