ASP.NET - hi

 can anybody help me in combaining two tables and display data in a gridview
thaNK YOU

hi,

Simple use join to get the data from both table in database query like this


and assign the table data to gridview.



Hope this will help you

Fetch the data using the below method

1.Create one data adapter
2.First fill the first table using Data adapter.Fill(table,1"Name for the table") Method
3.Then fill the second using  Data adapter.Fill(table2,"Name for the table") Method
4.Merge the two table using Datatable.Merge method
5.Show in gridview

public void BindGridview()

   {

     con=new SqlConnection(“Connectionstring”);

     da = new SqlDataAdapter(“Select * from Table1″, con);

     da.Fill(ds1, “Record”);

     da = new SqlDataAdapter(“select * from Table2″, con);

     da.Fill(ds2, “Record”);

     ds1.Merge(ds2);

     Gridview1.DataSource = ds1;

     
     Gridview1.DataBind();

   }

}

Hi..

Try below code sample

ASPX code sample
---------------------
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" OnRowCommand="GridView1_RowCommand" OnRowDataBound="GridView1_RowDataBound">
         <Columns>
           <asp:TemplateField>
             <ItemTemplate>
               <asp:LinkButton ID="lnkTitle" runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"Title" %>' />
             </ItemTemplate>
            </asp:TemplateField>            
           <asp:TemplateField>
             <ItemTemplate>
               <asp:Label ID="lblDescription" runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"Description" %>' />
             </ItemTemplate>
            </asp:TemplateField>   
            <asp:TemplateField>
              <ItemTemplate>
               <asp:Label ID="lblCommentBody" runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"CommentBody" %>' />
              </ItemTemplate>
            </asp:TemplateField>
          </Columns>
      </asp:GridView>                   
 

 CS Code sample
--------------------

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Data.SqlClient;

public partial class Default_Test : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
      SqlConnection sqlConnection1 = new SqlConnection(connectionString);

      SqlDataAdapter sqlAdapter1 = new SqlDataAdapter("SELECT TITLE, DESCRIPTON FROM TABLE1" , sqlConnection1);
      SqlDataAdapter sqlAdapter2 = new SqlDataAdapter("SELECT COMMENTBODY FROM TABLE2" , sqlConnection1);

      DataSet dataSet1 = new DataSet();
      DataSet dataSet2 = new DataSet();

      sqlAdapter1.Fill(dataSet1, "TABLE1");
      sqlAdapter2.Fill(dataSet2, "TABLE2");

      dataSet1.Merge(dataSet2, false, MissingSchemaAction.Add);
      GridView1.DataSource = dataSet1;
      GridView1.DataBind();
    }
}

You can use  join query

hi

refer this



follow
http://aspdotnetcodebook.blogspot.com/2008/04/showing-data-from-multiple-tables.html
http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataset/thread/f63f612f-20be-4bad-a91c-474396941800

Hi here is the sample code .

/ method to fill the dataset
public void FillMyDataSet(MyDataSet ds)
{
    string sql = "SELECT a.*, b.* FROM MyTable a JOIN MyOtherTable b ON a.key = b.key";
    using (SqlDataAdapter da = new SqlDataAdapter(sql, conn))
    {
        da.Fill(ds, "MyTable");
    }
}


// call it like this
MyDataSet dsMine = new MyDataSet();
this.FillMyDataSet(dsMine);
MyGridView.DataSource = dsMine;