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
Can you use Web API with ASP.NET Web Form?
Explain what are webservices?
How do you implement sql caching in asp.net?
How do http sessions work?
Explain the difference between panel and groupbox classes using .net?
What is asp.net web pages?
What symbol would you use to denote, the start of a code block in aspx views?
What do you understand by aggregate dependency?
In which event of the page life cycle, is the viewstate available?
Explain the benefits of viewstate?
Can I tap into other windows livetm services?
How do you use viewstate?
What are the types of validation in asp net?
What are session and cookies?
What tags do you need to add within the asp:datagrid tags to bind columns manually? How?