ASP.NET 2.0 Question: Download ASP.NET 2.0 PDF
How does u get record no from 5 to 15 from a dataset of 100 records?
Answer:
// ds-> daata set
//dr as datarow
for i=5 to 15
{
dr=ds.table.row(i)
}
You can also archive using this syntax. sqlconnection con=new sqlconnection(""); Sqldataadapter da=new Sqldataadapter("T-SQlQUARy",con); dataset ds=new dataset(); da.Fill(ds,5,15,"tablename");
//dr as datarow
for i=5 to 15
{
dr=ds.table.row(i)
}
You can also archive using this syntax. sqlconnection con=new sqlconnection(""); Sqldataadapter da=new Sqldataadapter("T-SQlQUARy",con); dataset ds=new dataset(); da.Fill(ds,5,15,"tablename");
| Previous Question | Next Question |
| How do u declare static variable and how it is declared and what is its lifetime? | Which namespace is used to get assembly details? |