1
Answer

SQL in C# with OLEDB and datagridview

Manu Laureys

Manu Laureys
2y
719
1

I have a SQL select that works in MS Access, but when I put it in C# I get an error (Error in From).

This is the code I use to fill my datagridview:

                // Bind data to datagrid
                strCmd = "Select Serial.ID, Serial.Datum, Product.Type, Product.Omschrijving, Serial.SerialNumber, Serial.Chassis, Serial.WOrder, Serial.VOrder, Klant.Naam, User.Init" +
                    " From ((Serial Left Join Product On Serial.ProductID = Product.ID)" +
                    " Left Join Klant On Serial.KlantID = Klant.ID)" +
                    " Left Join User On Serial.UserID = User.ID" +
                    " Where Serial.ProductID = 61" +
                    " Order By Serial.SerialNumber";
                MessageBox.Show("Sql: " + strCmd);
                OleDbDataAdapter da = new OleDbDataAdapter(strCmd, conn);
                DataSet ds = new DataSet();
                da.Fill(ds, "Serial");

                dgrSerial.DataSource = ds;
                dgrSerial.DataMember = "Serial";
 

Answers (1)
Next Recommended Forum