How to check if a record exists in the SQL Server database C# winform?

Question

My windows form application is about Book Store. I would like to display PO numbers in a ComboBox which didn't have create a Good Received Note.

This is the structure of this two tables.

PO Table-

GRN table

How to change following code?

 public void fillPOcombo()
 {
        DynamicConnection con = new DynamicConnection();
        con.mysqlconnection();
        con.sqlquery("select PO_No from TBL_PO");
        con.dataread();

        while (con.datareader.Read())
        {
            cmbpono.Items.Add((int)con.datareader["PO_NO"]);
        }
}

Are you able to show us a SQL query that will return what you need? — mjwills
– mjwills, Commented Jun 23, 2018 at 13:09

Ole EH Dufour · Accepted Answer · 2018-06-23 13:11:08Z

3

I would say as follows :

Change

con.sqlquery("select PO_No from TBL_PO");

to

con.sqlquery("select PO_No from TBL_PO where PO_No not in (select PO_No from GRN)");

answered Jun 23, 2018 at 13:11

Ole EH Dufour

3,2405 gold badges30 silver badges53 bronze badges

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

4 Comments

Kith Over a year ago

Thank You very much.This is the exact thing i have needed.

Ole EH Dufour Over a year ago

No worries! Oyaāva saādarayaena paiḷaigananavaā !

mjwills Over a year ago

Also consider using EXCEPT learn.microsoft.com/en-us/sql/t-sql/language-elements/…

Ole EH Dufour Over a year ago

@mjwills Good one.

Collectives™ on Stack Overflow

How to check if a record exists in the SQL Server database C# winform?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related