datakeyfield中如何写啊?
Sub BindDataGrid()
Dim conn As SqlConnection = New SqlConnection("server=(local);uid=sa;pwd=sa;database=ZFDRUYI2006")
'Dim cmd As SqlCommand = New SqlCommand("select * from PubDataList where sSysDataId=2006001 order by iOrderID", conn)
'conn.Open()
'DataGrid1.DataSource = cmd.ExecuteReader()
'DataGrid1.DataBind()
'conn.Close()
Dim adp1 As SqlDataAdapter = New SqlDataAdapter("select * from PubDataList where sSysDataId=2006001 order by iOrderID", conn)
Dim ds As DataSet = New DataSet
adp1.Fill(ds, "oneTable")
DataGrid1.DataSource = ds.Tables("oneTable")
Dim adp2 As SqlDataAdapter = New SqlDataAdapter("select * from StatEconomyMonthDetail", conn)
adp2.Fill(ds, "towTable")
DataGrid1.DataSource = ds.Tables("towTable")
DataGrid1.DataBind()
End Sub这样写我的datakeyfield写的字段如何定义两个表的ID呢
Sub BindDataGrid()
Dim conn As SqlConnection = New SqlConnection("server=(local);uid=sa;pwd=sa;database=ZFDRUYI2006")
'Dim cmd As SqlCommand = New SqlCommand("select * from PubDataList where sSysDataId=2006001 order by iOrderID", conn)
'conn.Open()
'DataGrid1.DataSource = cmd.ExecuteReader()
'DataGrid1.DataBind()
'conn.Close()
Dim adp1 As SqlDataAdapter = New SqlDataAdapter("select * from PubDataList where sSysDataId=2006001 order by iOrderID", conn)
Dim ds As DataSet = New DataSet
adp1.Fill(ds, "oneTable")
DataGrid1.DataSource = ds.Tables("oneTable")
Dim adp2 As SqlDataAdapter = New SqlDataAdapter("select * from StatEconomyMonthDetail", conn)
adp2.Fill(ds, "towTable")
DataGrid1.DataSource = ds.Tables("towTable")
DataGrid1.DataBind()
End Sub这样写我的datakeyfield写的字段如何定义两个表的ID呢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货