Problem with datasource and gridview

Question

I put this as a datasource in my gridView

var source = from p in allComments
         select new {p.Img, p.Name, p.Comment};
          GridView1.DataSource = source;
          GridView1.DataBind();

and i get this:

The DataSourceID of 'GridView1' must be the ID of a control of type IDataSource.

A control with ID 'SqlDataSource1' could not be found.

My Gridview Markup:

     <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
        style="z-index: 1; left: 317px; top: 374px; position: absolute; height: 597px; width: 666px" 
       BackColor="#CCCCCC" BorderColor="#999999" 
        BorderWidth="0px" CellPadding="4" CellSpacing="2" 
        DataSourceID="SqlDataSource1" ForeColor="Black" AllowPaging="True" 
        onrowdatabound="GridView1_RowDataBound">

 <Columns>
      <asp:TemplateField HeaderText="#">
                        <HeaderStyle Width="500px" />
                         <ItemStyle Width="500px" />
                        <ItemTemplate>
                            <asp:Label ID="lblMessage" runat="server"  Text='<%# Bind("Comment") %>'></asp:Label>
                        </ItemTemplate>
       </asp:TemplateField>

           <asp:TemplateField HeaderText="#">
                        <HeaderStyle Width="100px" />
                          <ItemStyle Width="100px" />
                        <ItemTemplate>
                            <asp:Image ID="imgName" runat="server"  imageUrl='<%# Bind("Img") %>'></asp:Image><br />
                            <asp:Hyperlink ID="hyperLink" runat="server"  Text='<%# Bind("Name") %>' ></asp:Hyperlink>
                        </ItemTemplate>
       </asp:TemplateField>
   </Columns>

      </asp:GridView>

I guess you copy and paste code from other page and forget to remove DataSourceID="SqlDataSource1" :) — Muhammad Akhtar
– Muhammad Akhtar, Commented Jul 4, 2011 at 6:53

Off The Gold · Accepted Answer · 2016-02-15 15:13:45Z

2

Remove DataSourceID="SqlDataSource1" from the Gridview, as you set the DataSource in Code behind..

var source = from p in allComments
select new {p.Img, p.Name, p.Comment};
GridView1.DataSource = source;
GridView1.DataBind();

You can either assign DataSourceID or DataSource, but can't do both.

Edit: Following your comments, you have a problem in Paging, to handle paging you have to to bind the data again.

 protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
    GridView1.PageIndex = e.NewPageIndex;
    var source = from p in allComments
                 select new { p.Img, p.Name, p.Comment };
    GridView1.DataSource = source;
    GridView1.DataBind();
}

edited Feb 15, 2016 at 15:13

Off The Gold

1,23615 silver badges28 bronze badges

answered Jul 4, 2011 at 6:49

Muhammad Akhtar

52.2k37 gold badges142 silver badges191 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Dmitry Makovetskiyd Over a year ago

The data source does not support server-side data paging.---My var linq statement doesnt support paging :(

Muhammad Akhtar Over a year ago

your problem is paging, I have update my answer. just try now.

Dmitry Makovetskiyd Over a year ago

Alright, it doesnt through an Exception.. But my datasource is not bound on the page load right no but on page index changing hmm... what if page index isnt changing?

Muhammad Akhtar Over a year ago

You have to bind the data first time in page load, so the code goes in page load as well. Secondly when user change the page number, Page IndexChanging event fire, which assign new page index and you need to set the DataSource again here.

Dmitry Makovetskiyd Over a year ago

But if i put that code in the page load, it throws me the same exception saying that it doesnt support paging..May be i should use Group By statement to divide the whole collection into 10 groups

|

Filip Ekberg · Accepted Answer · 2011-07-04 06:50:12Z

You've got the attribute DataSourceID="SqlDataSource1", the error message indicates that there are no SqlDataSource with the Id SqlDataSource1 in your code.

Therefore, you need to remove that attribute in order to bind it from code-behind.

Your Grid-View decleration should look like this instead:

 <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
    style="z-index: 1; left: 317px; top: 374px; position: absolute; height: 597px; width: 666px" 
    BackColor="#CCCCCC" BorderColor="#999999" 
    BorderWidth="0px" 
    CellPadding="4" CellSpacing="2" 
    ForeColor="Black" AllowPaging="True" 
    onrowdatabound="GridView1_RowDataBound">

You can now Bind the GridView without that issue, you can only have one of them set. Either you bind from code behind using the DataSource-attribute. Or you specify the Attribute DataSourceId.

Saurabh · Accepted Answer · 2011-07-04 06:51:04Z

0

Remove DataSourceID="SqlDataSource1"

answered Jul 4, 2011 at 6:51

Saurabh

5,7272 gold badges28 silver badges32 bronze badges

Collectives™ on Stack Overflow

Problem with datasource and gridview

3 Answers 3

8 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

8 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related