If a dataset contains 100 rows, how to fetch rows between 10
and 20 only ?
Answers were Sorted based on User's Feedback
Answer / tiger kumar
We have the option of the fetching the starting record and
the maximum record options.
_dataadapter.Fill(_dset,"Test",11,10);
It will retrieve the record from 11 to next 10 records.
Is This Answer Correct ? | 11 Yes | 2 No |
Answer / avanish singh
_adapter.Fill(ds,11,10).
or By iterate record from 11 to 20.
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / suresh jayaraman
for(int
RowsCount=1;RowsCount<dataset.rows.count;RowsCount++)
{
if(RowsCount>10 && RowsCount<20)
{
//if you GirdView or DataGrid
Gridview1.DataSource=dataset;
GridView1.DataBind()
}
}
Is This Answer Correct ? | 8 Yes | 4 No |
Answer / pra vesh hajela
SqlConnection conn = new
SqlConnection(AppConfiguration.ConnectionString);
SqlCommand cmd = new
SqlCommand("SelectCustomerInfo", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
//da.Fill(ds);
da.Fill(ds, 10, 10, "table");
return ds;
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / vijay
Dataset consists of DataTable collection which consists of
DataRows. Create Dataset object, then create DataRow object
Dim objRow as New DataRow
objRow(9) to objTow(19) woud give the rows between 10 and
20, as first row is stored with index 0.
Is This Answer Correct ? | 7 Yes | 4 No |
Answer / raghwendra ji chaubey
SqlDataAdapter sda = new SqlDataAdapter(sqlquery , con);
DataSet ds = new DataSet();
sda.Fill(ds);
sda.Fill(ds, 3, 2, "SrcTables");
Is This Answer Correct ? | 5 Yes | 2 No |
Answer / satyambabu
Dataset consists of DataTable collection which consists of
DataRows. Create Dataset object, then create DataRow object
Dim objRow as New DataRow
objRow(9) to objTow(19) woud give the rows between 10 and
20, as first row is stored with index 0.
Is This Answer Correct ? | 5 Yes | 3 No |
Answer / 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 |
Answer / vaidyanathan r.
DataRow[] dr = new DataRow[10];
for(int i = 10 to 19)
dr[i] = DataSet1.Tables[<TableIndex>].Rows[i];
DataRow array dr contains Records between 10 and 20.
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / muthu kumar
DataSet ds = new DataSet();
ds.Load(cmd.ExecuteReader(),
LoadOption.OverwriteChanges, "sample");
DataRow[] dr = ds.Tables[0].Select("id>1 and id<10");
for (int i = 0; i < dr.Length; i++)
{
Response.Write(dr[i][0].ToString()+"<br>");
}
Is This Answer Correct ? | 2 Yes | 2 No |
What is difference between executequery and executeupdate?
what is different between SqlCommand object and Command Behaviour Object
How to check if the Dataset has records ?
What is ole2 format?
What is ado recordset?
What are the Different layers in ADO.Net?
What is the difference between data reader and data adapter?
How do you filter the data in datagrid?
2 Answers Apps Lab, Choice Solutions,
What are the namespaces used in ado.net for data access?
what is sql Injection?
What is ado.net in mvc?
Why do we serialize data?