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

Can you use Web API with ASP.NET Web Form?

1161


Explain what are webservices?

992


How do you implement sql caching in asp.net?

1072


How do http sessions work?

928


Explain the difference between panel and groupbox classes using .net?

985


What is asp.net web pages?

998


What symbol would you use to denote, the start of a code block in aspx views?

975


What do you understand by aggregate dependency?

1106


In which event of the page life cycle, is the viewstate available?

982


Explain the benefits of viewstate?

1043


Can I tap into other windows livetm services?

996


How do you use viewstate?

1018


What are the types of validation in asp net?

1046


What are session and cookies?

995


What tags do you need to add within the asp:datagrid tags to bind columns manually? How?

988