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 is faster union or union all?
What is _viewstart?
How is mvc different from asp.net? : Asp.Net MVC
What is the difference between union and join?
What is the difference between a default skin and a named skin?
What is the difference between the get method () and post method ()?
What is mta?
What is a session government?
How to disable cut, copy and paste in TextBox using jQuery in asp.net?
Can you explain autopostback?
Explain MVC model binders?
What is the difference between user control and custom control?
Is asp.net 64-bit enabled? How?
What are the differences between clr & cts?
What are the different session state management options available in asp.net?