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
Describe session handling in a webfarm?
Explain the role of global.asax?
How do I debug an asp.net application that was not written with visual studio.net and that does not use code-behind?
What is an axd file?
Is asp.net and .net are same or different?
What is & in a url?
Is data edited in the Repeater control?
Will session work if cookies is disabled?
Is asp.net and .net the same?
Which Is Faster MVC or ASP.net ?
which one is more flexibility and reliability and durability asp.net (VS)php which one is best and which one we do nice to create dynamic websites
What are the different authentication modes in asp.net?
What are session cookies?
What is the namespace to create thread in .net?
What is the purpose of url encoding?