• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 193
  • Last Modified:

Using recordsets or equivelant in vb express working with sql server tables

I am working vb express 2010 and connected to an SQL server in Management Studio Express 2008.

I need to lookup each instance of startdate in tbl_1 and check every row of tbl_2, inserting a the downtime code from tbl_1 when the downtimecode is not currently null

tbl_1

ID     StartDate      StopDate       StopTime    DowntimeCode

1       2014-01-01   2014-01-02         24                     3
2       2014-01-02   2014-01-03         31                     6
3


tbl_2

ID     StartDate      StopDate       StopTime    DowntimeCode
         2014-01-01                                                          3
         2014-01-01                                                          3
         2014-01-02                                                          6

I must do this procedure from vb.

Thankyou very much for your assistance.
0
SweetingA
Asked:
SweetingA
1 Solution
 
CodeCruiserCommented:
You can populate two datatables in vb.net and then use following code


For i As Integer = 0 to dTable1.Rows.Count - 1
  dTable2.DefaultView.RowFilter = "StartDate='" & dTable1.Rows(i).item("StartDate")
  if dTable2.DefaultView.Count > 0
     dTable1.Rows(i).Item("DowntimeCode") = dTable2.DefaultView.Item(0).Item("DowntimeCode")
  End If
Next

Open in new window



*Untested code
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now