how to load data for individual row of a gridview from different tables

Question

0.00/5 (No votes)

See more:

Please,Can anyone help me in loading data as Rows(Not as Columns) of Gridview From Multiple Tables.Through Code.

Thanking You

With Regards
NanKi

Posted 22-Jan-12 17:39pm

Nandakishore G N

Add a Solution

Comments

amolpatil2243 22-Jan-12 23:42pm

is the coulmns differ or remain same as gridview...

Nandakishore G N 22-Jan-12 23:44pm

sorry Amol...I couldnt Follow....But,Columns Remain Same..

3 solutions

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)

amolpatil2243 · Answer 1 · 2012-01-22T17:54:00

1) declare one data table
2) fetch whatever data you want
3) declare one data row to data table
4) arrange data as per your requirement in row
5) insert row into data table.
likewise this you can arrange data row wise from different tables

6) after adding all rows to data table assign this data table as data source to grid view

try it......

C#

DataTable oDtTemp = new DataTable();
for (int iCol = 0; iCol < dsIncentivePay.Tables[0].Columns.Count; iCol++)
{
        oDtTemp.Columns.Add(dsIncentivePay.Tables[0].Columns[iCol].ColumnName.ToString().Trim());
}

for (int iRwCount = 0; iRwCount < dsIncentivePay.Tables[0].Rows.Count; iRwCount++)
{
     DataRow oDrTemp = oDtTemp.NewRow();
     for (int iCol = 0; iCol < dsIncentivePay.Tables[0].Columns.Count; iCol++)
{
     oDrTemp[dsIncentivePay.Tables[0].Columns[iCol].ColumnName.ToString()] = dsIncentivePay.Tables[0].Rows[iRwCount]    [iCol].ToString();
}

     oDtTemp.Rows.Add(oDrTemp);
}

Manoj Kumar Choubey · Answer 2 · 2012-01-22T18:03:00

If you can not able to make a possible Select Query, then you can create datatable and bound with grid , other solution is select possible data by Query and Create template column in grid and add controls and you can assign values and you can change this values without making datatable again , all above solution is situational, what do you want ....

Rockstar_ · Answer 3 · 2012-01-23T02:16:00

Solution 3

Hi,

Solution 1: Create stored procedure and call.......

Solution 2: create temporary table in sql,load the data from different table into the temporary table, then it is very easy to bind the data to Grid View or any other data bound controls...

Posted 23-Jan-12 2:16am

Rockstar_