我在VB.net 2013,Windows窗体应用程序,我需要做一个左侧连接sql语句,我第一次尝试过它 . 我的问题是,如果列名不同但是他们拥有的数据是相同的,你可以交叉引用两个表 . 在我的例子中,我有tableA和tableB . TableA有一个名为“JobNum”的列,TableB有一个名为“JobNumber”的列 . 考虑到这一点,仍然可以执行join语句 . 这是我的代码:
'load Job List
Try
'set/open sql connection
Using conn1 As New SqlConnection(connstring)
conn1.Open()
'Using comm1 As SqlCommand = New SqlCommand("Select JobNum, Shear from Production.dbo.[Floor Cell Jobs\Shears]", conn1)
Using comm1 As SqlCommand = New SqlCommand("SELECT JobNum FROM Production.dbo.[Floor Cells Jobs\Shears] LEFT OUTER JOIN Production.dbo.tblFCOrdered ON Production.dbo.[Floor Cells Jobs\Shears].JobNum = Production.dbo.fcOrdered.JobNumber", conn1)
'dim the variable rs as an sql datareader and execute that reader with sql comm1
Dim rs As SqlDataReader = comm1.ExecuteReader
'dim dt as a new datatable and load it into data set rs
Dim dt As DataTable = New DataTable
dt.Load(rs)
'set the combobox vale and display members
CBJob1.ValueMember = "JobNum"
CBJob1.DisplayMember = "JobNum"
'set the datasource for combobox CBJob1
CBJob1.DataSource = dt
End Using
End Using
1 回答
当然,你只是做这样的事情