Reply to thread

Message

[QUOTE="tombihn, post: 137834, member: 32416"]
I saw another post where jmcilhinney graciously helped another programmer with fixing a coding issue and suggested using parameters. The link to his blog in his post was very helpful and I'm trying to change my code in to use parameters instead of the previous method. In my previous method, I concatenated the sql query and included the dtBeginDate variable in the query. It is querying an Access database. The method I was using involved creating a dataadapter object from this query then filling my DataSet, ds, with this table called "WorkOrders". I never do an update with this data. The purpose is only to get the data from the database.

My question is how can I use a command object to pass a parameter and add a table to the dataset. Below is the code I have so far, but I'm stuck trying to figure out where to go from here.

[XCODE=vb.net]
            Dim dtBeginDate As Date = Today().Date.AddYears(-1)
            Dim SQL_RecentWorkOrders As String = "SELECT workorders.CustID as WO_CustID, " +
                                                        "workorders.[Work Order Number] as WO_Number, " +
                                                        "workorders.Date as WO_Date, " +
                                                        "customer.lastname as CustLastName, " +
                                                        "workorders.OperLast, " +
                                                        "workorders.OperFirst, " +
                                                        "workorders.FieldID as WO_Desc, " +
                                                        "workorders.Acres, " +
                                                        "workorders.Grid " +
                                                 "FROM   workorders " +
                                                 "INNER JOIN customer " +
                                                 "ON     workorders.custid = customer.custid " +
                                                 "WHERE  workorders.Date> @BeginDate ORDER BY workorders.[Work Order Number] DESC"

' Old code:  daAccess = New OleDbDataAdapter(SQL_RecentWorkOrders, cnAccess)
            ' Old code:  daAccess.Fill(ds, "WorkOrders")

Dim cmd As New OleDbCommand(SQL_RecentWorkOrders)
            cmd.Parameters.AddWithValue("@BeginDAte", dtBeginDate)
            cmd.ExecuteNonQuery()
            ds.Tables.Add(....

[/XCODE]

How do I get a table into my DataSet at this point?
[/QUOTE]

Verification