SqlDataSource -connection problem

Question

while i do the web application i tried to display those details in gridview. when i configure SqlDataSource it shows an error like object reference not set to an instance of an object. anyone can help me?

Ravikumar G · Answer

Go through this link for better understanding and solving the error. http://codebetter.com/raymondlewallen/2005/06/23/system-nullreferenceexception-object-reference-not-set-to-an-instance-of-an-object-3-common-causes-in-vb-net/

Sunny Sharma · Answer

Hi Bala sorry for a little delay.. I went through your code and found it working perfectly. Ther only may be the case that the data is not returned properly from the database. I suggest you to check with your table schema and select query if it's working ok. Your code is absolutely fine and nothing needs to be modified. Hope this helps!!

Sandeep Singh Shekhawat · Answer

SqlDataSource Design Code asp : SqlDataSource ID =EmployeeDataSource runat =server ConnectionString =Data Source=sandeepss-PC; database=development; user=sa;password=knowdev SelectCommand =select Id Name Emp_CodeEmp_Age from EMPLOYEE> asp : SqlDataSource > GridView Design DataSourceID property set by SqlDataSource ID to bind grid view. asp : GridView ID =gvCustomres runat =server DataSourceID =EmployeeDataSource AutoGenerateColumns =False GridLines =None AllowPaging =true CssClass =mGrid PagerStyle-CssClass =pgr AlternatingRowStyle-CssClass =alt Width =40%> Columns > asp : TemplateField HeaderText =S.No. ItemStyle-HorizontalAlign =Center> ItemTemplate > # Container.DataItemIndex+1 %> ItemTemplate > asp : TemplateField > asp : BoundField DataField =Name HeaderText =Employee Name /> asp : BoundField DataField =Emp_Code HeaderText =Employee Code /> asp : BoundField DataField =Emp_Age HeaderText =Employee Age /> Columns > asp : GridView >

Sunny Sharma · Answer

Well the error says all about the problem. You must set a non-blank DataSource to the DataSource property of gridview in order to see the values there inside GridView. Wanna more help? share you codes!! Hope this helps !!