Need help in gridview displaying data

Question

Hi all, I want to display all the data in gridview which i am inserting in runtime. For that i have written code but getting this error.

"Both DataSource and DataSourceID are defined on 'GridView1'. Remove one definition."

protected void Page_Load(object sender, EventArgs e)
{
    if (!Page.IsPostBack)
    {
        BindData();
    }
}

public void BindData()
{
     string str = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString.ToString();
     SqlConnection con = new SqlConnection(str);
     SqlDataAdapter da = new SqlDataAdapter("select * from Items where ItemId='" + TxtItemId.Text + "'", con);
     DataSet ds = new DataSet();
     da.Fill(ds,"Items");
     GridView1.DataSource = ds;         
     GridView1.DataBind();
}

Pls modify my code where is my mistake.

Thanks, Sumit

Answer 1

The two properties are mutually exclusive (when you use one of them, you are not allowed to use the other one):

1. The DataSourceID property is to be used with a DataSource control (ObjectDataSource, XmlDataSource, SqlDataSource, etc)
2. The DataSource property is to be used with custom objects / custom data binding.

Examples:

1. DataSourceId

   @asp:ObjectDataSource ID="ods1" runat="server" SelectMethod="Test" TypeName="TestBL" /@ @asp:GridView ID="gv1" runat="server" DataSourceID="ods1" /@

in this case databinding occurs automatically

1. DataSource

   @asp:GridView ID="gv2" runat="server" %@

and in code behind you would have something like this:

overrides void OnLoad(..)
{
    List<DataObject> source = new List<DataObject>();
    source.Add(new DataObject(..));
    source.Add(new DataObject(..));
    source.Add(new DataObject(..));
    gv2.DataSource = source;
    gv2.DataBind();
}

Please note that I have used @ instead of angular brackets.

Answer 2

It seems like you want to bind your datasource manually. Remove the DataSourceID property at the design view from your gridview. It should be something like that :

<asp:GridView runat="server" ID="grid" DataSourceID="SqlDataSource1"></asp:GridView>

Just remove the DataSourceID="SqlDataSource1" property.