For all of you developers please NEVER select "*"
Try : Select <FieldList> from MyTable The least # of Columns out of your data source will ALWAYS be faster. Isn't that what we strive for? Stephen Russell Senior Visual Studio Developer, DBA Memphis, TN 901.246-0159 > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of ArunKumar > Sent: Tuesday, April 14, 2009 9:20 AM > To: DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web > Services,.NET Remoting > Subject: [DotNetDevelopment] Re: gridview > > > Change your Query like > For SQL : SELECT * FROM table WHERE emp_id=1 > For MS Access : SELECT * FROM table WHERE emp_id=TRUE > Then bind to gridview > > ****************** > *C.Arun Kumar* > ****************** > > On Apr 14, 9:40 am, vikas arora <[email protected]> wrote: > > hi everyone, > > > > I have a gridview which has several columns like as > > emp_id,emp_name,emp_salary etc. > > and left column has checkboxes. > > > > I need to display those record only which checkboxes are selected. > > can anyone help me > > > > Thanx > > -------------- > > No virus found in this incoming message. > Checked by AVG - www.avg.com > Version: 8.5.287 / Virus Database: 270.11.54/2056 - Release Date: > 04/13/09 05:51:00
