Windows Forms C# retrieving SQL data using WHERE clause

Question

Bit of a hobbyist coder (and Novice) so I appreciate I may be approaching this in the wrong way so any advice on changing my approach would also be appreciated.

The idea is to have a "More Details" button on a form, that will open another form showing the customers contact details retrieved from a SQL table. The table called 'Project_Info' contains all of the contact/address data, using a 'Project' ID as the unique identifier.

The code for the button:

private void button2_Click(object sender, EventArgs e)
{
    SqlConnection con = new SqlConnection("Data Source=WIN-M9TBGRD70BU;Initial Catalog=Disk_Tracker;User ID=Tracker;Password=********");
    SqlDataAdapter sda = new SqlDataAdapter("Select * FROM Project_Info WHERE (Project = 'P3890T')", con);
    DataTable dt = new DataTable();
    sda.Fill(dt);
    {
        this.Hide();
        TRACK_10_PI T10 = new TRACK_10_PI();
        T10.Show();
    }
}

The new form TRACK_10_PI opens but always displays the data from the top row rather than as the WHERE clause has specified.

The reason I want the data retrieved from a database rather than simply hard coding it to the page is to accommodate possible changes to the information.

Thanks in advance

What results do you get when you run the query directly against the database using your favourite database querying tool? — Enigmativity
– Enigmativity, Commented May 18, 2018 at 12:39
it would appear that TRACK_10_PI has it's own query that doesn't include a WHERE clause. I don't see where you're using the datatable that you populate here. — Charles May
– Charles May, Commented May 18, 2018 at 12:53

Milad Rashidi · Accepted Answer · 2018-05-18 17:48:26Z

1

I would suggest you will use usinngs, so you don't Need to dispose expliciet. Place a datagridview on your form which is filled by your code. You can parameterize your instantiation of your form. Now you have to fill the datasouse in TRACK_10_PI.

Example:

using (SqlConnection con = new SqlConnection("Data Source=WIN-M9TBGRD70BU;Initial Catalog=Disk_Tracker;User ID=Tracker;Password=********"))
{
    using (SqlDataAdapter sda = new SqlDataAdapter("Select * FROM Project_Info WHERE (Project = 'P3890T')", con))
    {
        DataTable dt = new DataTable();
        sda.Fill(dt);
        this.Hide();
        TRACK_10_PI T10 = new TRACK_10_PI(sda);
        T10.Show();
    }
}

edited May 18, 2018 at 17:48

Milad Rashidi

1,3964 gold badges24 silver badges40 bronze badges

answered May 18, 2018 at 12:55

Kostarsus

375 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Soham Dasgupta · Accepted Answer · 2018-05-18 12:39:52Z

0

I'm suspecting you're not passing the newly created dt in the form TRACK_10_PI. I don't see any problem with you code except that you should dispose the SqlConnection and the SqlDataAdapter objects.

answered May 18, 2018 at 12:39

Soham Dasgupta

5,24926 gold badges81 silver badges129 bronze badges

Collectives™ on Stack Overflow

Windows Forms C# retrieving SQL data using WHERE clause

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related