How to display data on two datagridview

Question

0.00/5 (No votes)

See more:

Hi all,
i need to display data in two datagridview from two datatable

C#

dtEntry = clsMain.tableBind("Exec [GrmnFins].[EntryRecord_rajshree_userwise] '" + DtEntry.Value.ToString("MM/dd/yyyy") + "' , '" + CboOprtrNm.Text + "'");
    // data is  coming from stored procedure  and CboOprtrNm.Text  is a combobox

                int im = CboOprtrNm.SelectedIndex;
                if (dtEntry.Rows.Count > 0)
                {

                    dtnew = clsMain.GenerateTransposedTable(dtEntry);

                    dtGridEntry.DataSource = dtnew;
                    GridAlternateColor(dtGridEntry);

                }
                dtQC = clsMain.tablebind(" Exec [GrmnFins].[ShrHldrOfflineQCRecord_rajshree_user] '" + DtEntry.Value.ToString("MM/dd/yyyy") + "' , '" + CboOprtrNm.Text +"'");

              //this is another table

                if (dtQC.Rows.Count > 0)
                {
                    dtnewQC = clsMain.GenerateTransposedTable(dtQC);
                    dtGridQC.DataSource = dtnewQC;
                    GridAlternateColor(dtGridQC);
                }


     // data is getting displayed on first datagridview and not on second datagridview and showing error..

//dtentry is a datetimepicker
// the exception is "The method or operation is not implemented"

Posted 8-Dec-14 18:22pm

rajshree748

Updated 8-Dec-14 18:33pm

v2

Add a Solution

Comments

/\jmot 9-Dec-14 0:36am

what is the Error??

/\jmot 9-Dec-14 0:37am

Use...Databind()..Like..

dtGridEntry.DataSource = dtnew;
dtGridEntry.DataBind();
GridAlternateColor(dtGridEntry);

rajshree748 9-Dec-14 0:40am

error is "The method or operation is not implemented" but with thid same code data is coming on datagridview..on the same code i am not getting on second one.error is on the second one 'dtGridQC'.

/\jmot 9-Dec-14 0:55am

in which part of the code you are getting this error??

rajshree748 9-Dec-14 1:00am

Error is after dtQC, when data is coming from database (i.e Exec [GrmnFins].[ShrHldrOfflineQCRecord_rajshree_user])

syed shanu 9-Dec-14 1:06am

What is "dtnew" and "dtnewQC" and what this both method return " clsMain.GenerateTransposedTable(dtQC)" and "clsMain.GenerateTransposedTable(dtEntry);
" if this return dataset then you can write code like below
dtGridEntry.datasource=dtnew.Tables[0];
dtGridQC.datasource=dtnewQC.Tables[1];

rajshree748 9-Dec-14 1:16am

dtnew and dtnewQC are the datatables .I have a class clsmain where GenerateTransposedTable() method is defined..GenerateTransposedTable() is to transpose table from row to column

rajshree748 9-Dec-14 2:11am

The break point is going upto dtQC = .

after this line it is showing error.

syed shanu 9-Dec-14 1:20am

Did you check dtnewQC = clsMain.GenerateTransposedTable(dtQC);
is reeturn the datatable with data.

rajshree748 9-Dec-14 2:18am

The break point is going upto dtQC = clsmain.tableBind("");

after this line it is showing error.

syed shanu 9-Dec-14 2:26am

What error you get .
I hope you need to do something like this
create one Stored Procedure with 2 select query for example like below
create procedure sample()
begin
select * from table1 where field1=@field1;select * from table2 where field2=@field2.

In your CS file in Dataset fill the records using DataAdapter.
datagridview1.DataSource=ds.Tables[0];
datagridview2.DataSource=ds.Tables[1];

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 9-Dec-14 3:23am

Don't send the parameter like this. Use Parameterized query, which will help you to prevent the SQL Injection attacks.

rajshree748 10-Dec-14 1:42am

This is resolved.

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)