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_Code,Emp_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 !!

SqlDataSource -connection problem

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (4)