How Can I Switch Between Two Tables In Same Database For Displaying The Data In A Gridview In C# ?

Question

0.00/5 (No votes)

See more:

Hi I have two tables : VehicleMaintenance_log and safety_log. i want to display only one table data at a time. i have one combobox with two options:maintenance log and safety_report, When i select on one item oncombobox ex: for maintenance log, the gridview should display only that maintenance log values according to registration number. How can i acheive this? I know only to select from a table at a time. I am doing this for the first time. I am using visual studio 2013 and for the database mysql.My data resides in two tables(maintenance_log and safety_report) in the same schema.This is what i tried i used " if" loops.please help.

C#

private void button1_Click(object sender, EventArgs e)
        {
            string constring = "datasource=localhost;port=3306;username=root;password=Ammoos123";
            MySqlConnection conDatabase = new MySqlConnection(constring);
            if((this.cmb2.SelectedItem.ToString())=="SafetyInspection_Report")
            {
                MySqlCommand cmdDatabase = new MySqlCommand("select * from vehicle_automation.safetyinspection_report where vehRegNo=@regno and inspection_date between @date1 and @date2", conDatabase);
                cmdDatabase.Parameters.AddWithValue("@regno", this.cmb1.SelectedItem);
                cmdDatabase.Parameters.AddWithValue("@date1", this.dt1.Text);
                cmdDatabase.Parameters.AddWithValue("@date2", this.dt2.Text);
                try
                {
                    MySqlDataAdapter sda = new MySqlDataAdapter();
                    sda.SelectCommand = cmdDatabase;
                    DataTable dbdataset = new DataTable();
                    sda.Fill(dbdataset);
                    BindingSource bsource = new BindingSource();
                    bsource.DataSource = dbdataset;
                    dtgv1.DataSource = bsource;
                    sda.Update(dbdataset);

                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message);
                }
            }
            else if((this.cmb2.SelectedItem.ToString())=="Maintenance_log")
            {
                 MySqlCommand cmdDatabase = new MySqlCommand("select * from vehicle_automation.maintenance_log where vehRegNo=@regno and inspection_date between @date1 and @date2", conDatabase);
                cmdDatabase.Parameters.AddWithValue("@regno", this.cmb1.SelectedItem);
                cmdDatabase.Parameters.AddWithValue("@date1", this.dt1.Text);
                cmdDatabase.Parameters.AddWithValue("@date2", this.dt2.Text);
            try
            {
                MySqlDataAdapter sda = new MySqlDataAdapter();
                sda.SelectCommand = cmdDatabase;
                DataTable dbdataset = new DataTable();
                sda.Fill(dbdataset);
                BindingSource bsource = new BindingSource();
                bsource.DataSource = dbdataset;
                dtgv1.DataSource = bsource;
                sda.Update(dbdataset);

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }        
         }

additional information copied from comment below
Hai actually i dont know if this is the proper way to do it.Its working for safety inspection.bt if there is no data in the table also the gridview is giving the empty table there I need to display "there is no datas found".

Posted 7-Dec-14 0:03am

Helen Jess

Updated 7-Dec-14 0:37am

Nelek

v2

Add a Solution

Comments

Kornfeld Eliyahu Peter 7-Dec-14 6:05am

And what's wrong with your code?

Helen Jess 7-Dec-14 6:08am

Hai actually i dont know if this is the proper way to do it.Its working for safety inspection.bt if there is no data in the table also the gridview is giving the empty table there I need to display "there is no datas found".

BillWoodruff 7-Dec-14 6:46am

This may be quite an unusable idea, but: have you thought of having two DataGridViews, and simply switching which of them appears based on the ComboBox selection ?

Or, might it be possible to switch what the (one) DataGridView is bound to ?

Helen Jess 7-Dec-14 7:47am

Hai many thanks both code is working now. i added one more gridview and i am getting both the table records.

DamithSL 7-Dec-14 10:12am

if you solve your problem please post the solution and mark it as answer. ( it will save time of others who open this question for answering)
or otherwise delete it.

BillWoodruff 7-Dec-14 10:34am

I believe that the OP took my advice and used two DataGridViews :)

Helen Jess 7-Dec-14 11:03am

Yeah thanks Billwoodruff

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

Helen Jess · Answer 1 · 2014-12-07T04:20:00

The is the solution.
private void button1_Click(object sender, EventArgs e)
{
string constring = "datasource=localhost;port=3306;username=root;password=Ammoos123";
MySqlConnection conDatabase = new MySqlConnection(constring);
if((this.cmb2.SelectedItem.ToString())=="SafetyInspection_Report")
{
dtgv4.Visible = false;
dtgv1.Visible = true;
MySqlCommand cmdDatabase = new MySqlCommand("select * from vehicle_automation.safetyinspection_report where vehRegNo=@regno and inspection_date between @date1 and @date2", conDatabase);
cmdDatabase.Parameters.AddWithValue("@regno", this.cmb1.SelectedItem);
cmdDatabase.Parameters.AddWithValue("@date1", this.dt1.Text);
cmdDatabase.Parameters.AddWithValue("@date2", this.dt2.Text);

try
{
MySqlDataAdapter sda = new MySqlDataAdapter();
sda.SelectCommand = cmdDatabase;
DataTable dbdataset = new DataTable();
sda.Fill(dbdataset);
BindingSource bsource = new BindingSource();
bsource.DataSource = dbdataset;
dtgv1.DataSource = bsource;
sda.Update(dbdataset);

}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else if((this.cmb2.SelectedItem.ToString())=="Maintenance_Log")
{
dtgv1.Visible = false;
dtgv4.Visible = true;
MySqlCommand cmdDatabase = new MySqlCommand("select * from vehicle_automation.maintenance_log where vehRegNo=@regno and maintenance_date between @date1 and @date2", conDatabase);
cmdDatabase.Parameters.AddWithValue("@regno", this.cmb1.SelectedItem);
cmdDatabase.Parameters.AddWithValue("@date1", this.dt1.Text);
cmdDatabase.Parameters.AddWithValue("@date2", this.dt2.Text);
try
{
MySqlDataAdapter sda = new MySqlDataAdapter();
sda.SelectCommand = cmdDatabase;
DataTable dbdataset = new DataTable();
sda.Fill(dbdataset);
BindingSource bsource = new BindingSource();
bsource.DataSource = dbdataset;
dtgv4.DataSource = bsource;
sda.Update(dbdataset);

}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}

DamithSL · Answer 2 · 2014-12-07T04:29:00

Quote:
Hi How can i show a message if there is no data on the database for the search criteria?

check this answer
[^] you can use EmptyDataRow [^]template style. there are some other alternatives, check
http://forums.asp.net/t/1222441.aspx?how+to+display+empty+gridview+with+a+message+No+data+Avaialable+[^]

How Can I Switch Between Two Tables In Same Database For Displaying The Data In A Gridview In C# ?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0