How to display data from database with multiple tables to data grid view?

Question

0.00/5 (No votes)

See more:

private void LoadData()
       {
           setConnection();
           sql_con.Open();
           sql_cmd = sql_con.CreateCommand();
           string CommandText = "SELECT Rents.Name, Rents.Brand_Model_Plate_Number, Rents.rental_date,Rents.return_date,Car.rate,Payment.charges FROM Rents INNER JOIN Car ON Rents.rental_id = Car.car_id INNER JOIN Payment ON Rents.rental_id = Payment.payment_id; ";
           DB = new SQLiteDataAdapter(CommandText, sql_con);
           DS.Reset();
           DB.Fill(DS);
           DT = DS.Tables[0];
           dgvBills.DataSource = DT;

           sql_con.Close();

       }

it only show the column name but no data

What I have tried:

tried different joins and sql statement but to no avail

Posted 1-Apr-22 19:14pm

Ernest Jan Sandoval

Updated 1-Apr-22 20:03pm

Add a Solution

1 solution

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)

OriginalGriff · Answer 1 · 2022-04-01T20:03:00

If it shows no data, that's because your JOIN is failing to produce any rows.
This code works for me:

C#

string strConnect = SMDBSupport.SMInstanceStorage.GetInstanceConnectionString("MyDBName");
using (SQLiteConnection con = new SQLiteConnection(strConnect))
    {
    try
        {
        con.Open();
        using (SQLiteDataAdapter da = new SQLiteDataAdapter(getCount, con))
            {
            using (DataTable dt = new DataTable())
                {
                da.Fill(dt);
                myDataGridView.DataSource = dt;
                }
            }
        }
    catch (Exception ex)
        {
        Debug.WriteLine(ex.ToString());
        }
    }

It's literally my boilerplate code for a DataAdapter to a DataGridView for SQLite (it's drag'n'dropped from the VS Toolbox into my code ready to fill in!)

So ... use the debugger to find out exactly what is happening - and that any exception isn't being swallowed - then use SSMS or similar to open the SQLite DB and check exactly what in in your DB and what results your SELECT returns.

Sorry, but we can't do that for you!