bind grid from two different table

tausif shaikh

16y5.5k.NET

hi,,,i have two tables,,,table1 & table2 ...table1's primary key is a foreign key of table2.....

i want to display some column of table 2 as well as table1 in a single grid,,,

plz provide me code with example....

thanks..

2 Replies

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

Amit Choudhary16y ago
hi friend,

if you don't want to join the tables then you can do following:

Create a dataset fill it with data from table1...

Dataset ds=new DataSet();
adp.fill(ds);

now you can add columns to your dataset...

DataColumn dc=new DataColumn("Col_tabl2",System.Type.GetType("SystemString"));
ds.Columns.Add(dc);

now you add rows from table2 manually...
Get the data from Table 2 in datareader and add it to the specific column like this:

DataReader rdr=cmd.ExecuteReader();
for(int i=0;i{
ds.Tables[0].Rows[i]["Col_tab2"]=rdr["Col_tab2"].ToString();
}

Similarly you can add more column and rows manually to your dataset and
finally bind your Grid.

Please mark as answer if it helps.
0

Vasanth16y ago

<html>
 <head>
  <title>Datagrid sampletitle>
 head>
 <body>
  <form runat="server" ID="Form1">
   <asp:DataGrid ID="dgSample" EnableViewState="False" Runat="server" />
  form>
 body>
html>

Page.cs
--------

using System.Data;

using System.Data.SqlClient;
using System.Configuration;

void Page_Load(Object sender, EventArgs e)
{
 SqlConnection myConn = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"].ToString());
 
 // Query initiates two table using joins
Command myCmd = new SqlCommand("Select Table1.ColA,Table1.ColB,Table2.ColB,Table2.ColC from Table1 INNER JOIN Table2 ON Table1.ColA = Table2.ColA", myConn);
 
 // Connection open myConn.Open();
 // assign the data source through execute reader
 dgSample.DataSource = myCmd.ExecuteReader();
 // bind the data source
 dgSample.DataBind();
 // Connection closed
 myConn.Close();
}
 
Really its helps out, please mark as answer.