Binding datatable to datagrid

Question

0.00/5 (No votes)

See more:

.NET3.5

Hi everyone,
I wrote a function which returns DataTable. And called that function in button Click event so when the event is raised the function returns the data table and I am able to bind the data table to data grid. And the problem is when the button event is raised for the second time the data which is bound in the first event is not seen in datagrid when button event raised second time so need to display the old and new information in the data grid and all this is COMPACT FRAMEWORK->WINCE APPLICATION

THIS IS FUNCTION DEFINED

C#

public DataTable getdetails(ComboBox descp, ComboBox veitype)
        {
            InitializeDB();
            SqlCeCommand scmd = new SqlCeCommand();
            DataTable dt = new DataTable();
            SqlCeDataReader sdr;            
            try
            {
                scmd = con.CreateCommand();

                scmd.CommandText = "SELECT CHALLAN_CODE,CHALLAN_DESC,AMOUNT" + " FROM MB_MST_CHALLAN WHERE CHALLAN_DESC='" + descp.Text + "'AND (VEHICLE_TYPE='" + veitype.Text + "' OR VEHICLE_TYPE='A') AND STATUS='A'";
                SqlCeDataAdapter da = new SqlCeDataAdapter(scmd);
                da.Fill(dt);               
            }      
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                scmd.Dispose();
                CloseDbConnection();
            }
            return dt;
        }

Posted 30-Jun-10 23:10pm

vaikuntapu

Updated 30-Jun-10 23:23pm

Ankur^\m/

v2

Add a Solution

4 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)

Toniyo Jackson · Answer 1 · 2010-07-01T00:32:00

Solution 1

you need to merge the old datatable to new datatable

Posted 1-Jul-10 0:32am

Toniyo Jackson

vaikuntapu · Answer 2 · 2010-07-01T02:42:00

Solution 2

Can we Merge 2 data tables
if possible Can u guide me thru some code

Posted 1-Jul-10 2:42am

vaikuntapu

Toniyo Jackson · Answer 3 · 2010-07-01T03:04:00

Solution 3

<pre lang="vb">Dim dt1 As New DataTable
       dt1.Columns.Add("name")

       dt1.Rows.Add("NAME1")

       Dim dt2 As New DataTable
       dt2.Columns.Add("name")

       dt2.Rows.Add("NAME2")

       dt2.Merge(dt1)

but make sure that both table having same column names

Posted 1-Jul-10 3:04am

Toniyo Jackson

vaikuntapu · Answer 4 · 2010-07-01T03:41:00

DataTable dt = new DataTable();
DataTable dt1 = new DataTable();
dt.Columns.Add("Challan code");
dt.Columns.Add("Challan Desc");
dt.Columns.Add("amount");

dt1.Columns.Add("Challan code");
dt1.Columns.Add("Challan Desc");
dt1.Columns.Add("amount");

DataRow dr,dr1;
dr = dt.NewRow();
dt.Rows.Add(dr);
<big>dt= dbmgr.getdetails(chldesc, Vehtype);</big>
dataGrid1.DataSource = dt1;