Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Which .NET framework supports Web API?

1051


what is AutoEventWireUp and what is the use of This property explain in details?

1597


What is the difference between mvc (model-view-controller) and mvp (model-view-presenter)? : asp.net mvc

1015


What does the .webpart file do?

1022


In order to get assembly info which namespace we should import?

995


Define the term Web Garden?

952


What is the difference between page-level caching and fragment caching?

966


Why is xap important?

1004


Explain Features in ASP.NET

1084


How to handle errors in Web API?

1179


How can you identify that the page is post back?

989


What is asp.net mvc? : asp.net mvc

1102


Which platform does Microsoft .NET use for exchanging data between applications?

1039


Why do we use datasource in asp.net?

964


What are the asp.net list controls and difference between them?

1019