geting a erro System.NullReferenceException

Question

1.00/5 (2 votes)

See more:

SQL-Server-2008R2

getting this error cant understand whats wrong here

plz help ..

SqlDataSource sqlds =(SqlDataSource) e.Item.FindControl("SqlDataSource3") as SqlDataSource;
Line 86:
Line 87: sqlds.ConnectionString = "Data Source=DIMPLE;Initial Catalog=torqbolt;Integrated Security=True";
Line 88: sqlds.SelectCommand = "select comment,rply_name,rpl_date,task_id from rply where task_id ='" + lblID.Text + "'";

System.NullReferenceException: Object reference not set to an instance of an object.

XML

<asp:ListView ID="ListView1" runat="server" DataSourceID="SqlDataSource2" OnItemCommand="ListView1_ItemCommand"
     OnItemDataBound="use" DataKeyNames="task_id">
    <AlternatingItemTemplate><br>
    <div class="postback">
        <span>
        <asp:Label ID="id_Label" runat="server" Text='<%# Eval("task_id") %>' />
        <span class="heding_color">Assigned to </span>
        <asp:Label ID="post_nameLabel" runat="server" Text='<%# Eval("post_name") %>'  />
        <br />
        <br />
        <span class="heding_color">Description</span><br />
        <asp:Label ID="messageLabel" runat="server" Text='<%# Eval("message") %>' />
        <br />

        <br />


        <br />


        <br />
        <span class="heding_color">Posted by : </span>
        <asp:Label ID="asigntask_nameLabel" runat="server"
            Text='<%# Eval("asign_name") %>'  />



        <span class="asgndate "><span class="heding_color"> Posted On </span>
        <asp:Label ID="curnt_dateLabel" runat="server"
            Text='<%# Eval("curnt_date") %>'  /></span><br />



            <span id='<%# Eval("task_id") %>'>

       <asp:ListView id="rply" runat="server" DataSourceID="SqlDataSource3">
       <ItemTemplate>
       <ul>
       <li>

           <asp:Label ID="task_id" runat="server" Text='<%# Eval("task_id") %>' />
       <asp:Label ID="comment_Label" runat="server" Text='<%# Eval("comment") %>' />
           <asp:Label ID="rply_name" runat="server" Text='<%# Eval("rply_name") %>' />
           <asp:Label ID="date" runat="server" Text='<%# Eval("rpl_date") %>' />
       </li>
       </ul>
       </ItemTemplate>

       </asp:ListView>

            <div class="cust_summary replaybtn">Replay</div>

            <div id="cust_details" class="cust_details" style="display:none; ">
            <br />

            <asp:TextBox ID="TextBoxL"    placeholder="Write Your Comment.." class="commentTextArea"  runat="server" TextMode="MultiLine" Rows="2"></asp:TextBox><br /> <br />

                <asp:Button ID="Button3" CommandName="insert" runat="server" class="btncomment" Text="Post" onclick="Button3_Click" /> </div> <br />

    </span></span></div>
    </AlternatingItemTemplate>


<ItemTemplate><br>
<div class="postback">
    <span>
    <asp:Label ID="id_Label" runat="server" Text='<%# Eval("task_id") %>'/>
    <span class="heding_color">Assigned to </span>
     <asp:Label ID="post_nameLabel" runat="server" Text='<%# Eval("post_name") %>'  />
    <br /><br />
    <span class="heding_color">Description</span><br />
    <asp:Label ID="messageLabel" runat="server" Text='<%# Eval("message") %>'   />
    <br />
    <br />

    <br />

    <br />




    <br />
    <span class="heding_color"> Posted by : </span>
    <asp:Label ID="asign_nameLabel" runat="server"
        Text='<%# Eval("asign_name") %>' />


    <span class="asgndate"><span class="heding_color"> Posted On </span>
    <asp:Label ID="curnt_dateLabel" runat="server"
        Text='<%# Eval("curnt_date") %>' /></span><br /><br />


        <span id='<%# Eval("task_id") %>'>
    <asp:ListView id="rply" runat="server" DataSourceID="SqlDataSource3">
       <ItemTemplate>
       <ul>
       <li>

           <asp:Label ID="task_id" runat="server" Text='<%# Eval("task_id") %>' />
       <asp:Label ID="comment_Label" runat="server" Text='<%# Eval("comment") %>' />
           <asp:Label ID="rply_name" runat="server" Text='<%# Eval("rply_name") %>' />
           <asp:Label ID="date" runat="server" Text='<%# Eval("rpl_date") %>' />
       </li>
       </ul>
       </ItemTemplate>

       </asp:ListView>
        <div class="cust_summary replaybtn">Replay</div>

            <div id="cust_details" class="cust_details" style="display:none; "><br />

            <asp:TextBox ID="TextBoxL" Enabled="true"   placeholder="Write Your Comment.." class="commentTextArea"  runat="server" TextMode="MultiLine" Rows="2"></asp:TextBox><br />
            <br />
                <asp:Button ID="Button3" runat="server" class="btncomment" Text="Post" onclick="Button3_Click" />
                </div>
    <br />


   </span> </span></div>
</ItemTemplate>
    <LayoutTemplate>

    <br>
        <div ID="itemPlaceholderContainer" runat="server">


            <span runat="server" id="itemPlaceholder" />
        </div>
        <div style="">
        </div>
    </LayoutTemplate>
    <SelectedItemTemplate>
    <div class="postback">
        <span >
        <asp:Label ID="id_Label" runat="server" Text='<%# Eval("task_id") %>'/>
        <span class="heding_color">Assigned to </span>
          <asp:Label ID="post_nameLabel" runat="server" Text='<%# Eval("post_name") %>'   />
        <br />
        <span class="heding_color">Description</span><br />
        <asp:Label ID="messageLabel" runat="server" Text='<%# Eval("message") %>' />
        <br />
        <br />


        <br />

               <span class="heding_color"> Posted by : </span>

        <asp:Label ID="asign_nameLabel" runat="server"
            Text='<%# Eval("asign_name") %>' />
        <span class="asgndate"><span class="heding_color">Posted On </span>
        <asp:Label ID="curnt_dateLabel" runat="server"
            Text='<%# Eval("curnt_date") %>' /></span><br /><br />

        <span id='<%# Eval("task_id") %>'>
         <asp:ListView id="rply" runat="server" DataSourceID="SqlDataSource3">
       <ItemTemplate>
       <ul>
       <li>
           <div><%# Eval("task_id") %></div>
           <asp:Label ID="task_id" runat="server" Text='<%# Eval("task_id") %>' />
       <asp:Label ID="comment_Label" runat="server" Text='<%# Eval("comment") %>' />
           <asp:Label ID="rply_name" runat="server" Text='<%# Eval("rply_name") %>' />
           <asp:Label ID="date" runat="server" Text='<%# Eval("rpl_date") %>' />
       </li>
       </ul>
       </ItemTemplate>

       </asp:ListView>

            <div class="cust_summary replaybtn">Replay</div>

            <div id="cust_details" class="cust_details" style="display:none; "><br />

            <asp:TextBox ID="TextBoxL" placeholder="Write Your Comment.." class="commentTextArea"  runat="server" TextMode="MultiLine" Rows="2"></asp:TextBox><br />
            <br />
                <asp:Button ID="Button3"  class="btncomment" runat="server" Text="Post" onclick="Button3_Click" />
                </div>
        <br />
       <br />

       </span> </span></div>
    </SelectedItemTemplate>


</asp:ListView>


   <asp:SqlDataSource ID="SqlDataSource1" runat="server"
    ConnectionString="<%$ ConnectionStrings:ApplicationServices %>"
    SelectCommand="SELECT [name]FROM [names]">


</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" >
</asp:SqlDataSource>

 <asp:SqlDataSource ID="SqlDataSource3" runat="server" >
</asp:SqlDataSource>

C#

protected void Page_Load(object sender, EventArgs e)
{
    SqlDataSource2.ConnectionString = "Data Source=DIMPLE;Initial Catalog=torqbolt;Integrated Security=True";
    SqlDataSource2.SelectCommand = "select task_id,message,post_name,curnt_date,asign_name from task";

   // string s2 = System.Web.HttpContext.Current.User.Identity.Name;
     Session["name"] = s2;
    }

protected void use(object sender, ListViewItemEventArgs e)
{
Label d = (Label)e.Item.FindControl("id_Label");
ViewState["task_id"] = d.Text;
// try
// {
Label lblID =(Label)e.Item.FindControl("id_Label") as Label;

SqlDataSource sqlds =(SqlDataSource) e.Item.FindControl("SqlDataSource3") as SqlDataSource;

sqlds.ConnectionString = "Data Source=DIMPLE;Initial Catalog=torqbolt;Integrated Security=True";
sqlds.SelectCommand = "select comment,rply_name,rpl_date,task_id from rply where task_id ='" + lblID.Text + "'";
}

Posted 17-Oct-14 23:51pm

Aarti Yadav

Updated 17-Oct-14 23:53pm

v2

Add a Solution

Comments

Aarti Yadav 18-Oct-14 6:07am

thsi is a nested listview

surajsurve 18-Oct-14 9:10am

Can you tell me on which line you are getting an exception?

2 solutions

Solution 1

My guess is that you get your error here:

C#

sqlds.ConnectionString = "Data Source=DIMPLE;Initial Catalog=torqbolt;Integrated Security=True";

because sqlds is null.

Use the debugger and set a break point here:

C#

Label d = (Label)e.Item.FindControl("id_Label");

then step through the code.

Posted 18-Oct-14 4:15am

George Jonsson

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Naser Hassan · Accepted Answer · 2014-10-18T06:26:00

Solution 2

how to solve null reference exception ?
step 1:Check in which you are getting Exception
step 2:you must be invoking the member(method or property) of some object (that object must be not initialized any where)
step 3: initialized that object of which you are calling the member (method or property)

Posted 18-Oct-14 6:26am

Naser Hassan

Updated 18-Oct-14 6:27am