How do i set my datagrid to display only a certain amount of records?

You can achieve this by paging. On how to do this, check these links: http://www.c-sharpcorner.com/asp/Code/northwindLC.asp http://samples.gotdotnet.com/quickstart/aspplus/samples/webforms/ctrlref/webctrl/datagrid/doc_datagrid.aspx http://www.dotnetjunkies.com/Tutorial/AAF84EAD-C412-4304-A88A-AF26F8C883E6.dcik