SqlDataSource -connection problem

Bala

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?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ravikumar G13y ago
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 Sharma13y ago
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 Shekhawat13y ago
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 Sharma13y ago
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 !!