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
Which .NET framework supports Web API?
what is AutoEventWireUp and what is the use of This property explain in details?
What is the difference between mvc (model-view-controller) and mvp (model-view-presenter)? : asp.net mvc
What does the .webpart file do?
In order to get assembly info which namespace we should import?
Define the term Web Garden?
What is the difference between page-level caching and fragment caching?
Why is xap important?
Explain Features in ASP.NET
How to handle errors in Web API?
How can you identify that the page is post back?
What is asp.net mvc? : asp.net mvc
Which platform does Microsoft .NET use for exchanging data between applications?
Why do we use datasource in asp.net?
What are the asp.net list controls and difference between them?