Of course, for all of the developers who have a data access layer that converts table contents to objects, "select *" is just fine, since the data layer probably requires this. So "NEVER" is a bit strong, don't you think?
On Apr 14, 8:06 am, "Stephen Russell" <[email protected]> wrote: > 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
