if i have 1000 records and i want to access 20 ata time
from SQL server, what will be the query?
Answer Posted / sunny
Assume EMP is my Table where 1000 Records there. We retrive
20 top record from database through by following c# code.
}
sqlconection cn = new sqlconnection(@"Conection string...");
dataset ds = new dataset();
SqldataAdapter da = new SqldataAdapter("select top 20 *
from Emp", cn);
da.fill(ds);
Gridview1.datasource = ds.table[0];
Gridview1.databind();
}
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is full trust in asp.net?
How do http sessions work?
What is query string with example?
Disable browser cache for entire ASP.NET website?
What is difference between rest and soap?
Define static member?
What are strong names?
How does http session work?
What is session in web technology?
What is meant by web application?
witch is the best insistute in sharpoint course.what abt future of share point course.
How does asp.net page work?
How can we prevent browser from caching an aspx page?
What is a response cookie?
Difference between application events and session events