这个哪错了呀?有人说是用datatable替换ds,我不明白呀,怎么改呀? Dim ds = New DataSet
Dim conn As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("./") & "../anshan.mdb")
Dim sign As String
Dim sql As String = "select reg.id, reg.title, pro.content from reg,pro where reg.pro_id=pro.id order by reg.pro_id desc"
Dim sqlada As OleDbDataAdapter
sqlada = New OleDbDataAdapter(sql, conn)
sqlada.Fill(ds, "reg")
MyDataGrid.DataSource = ds
MyDataGrid.DataBind()错误行
行 34: sqlada.Fill(ds, "reg")表达式中的类型不匹配。
Dim conn As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("./") & "../anshan.mdb")
Dim sign As String
Dim sql As String = "select reg.id, reg.title, pro.content from reg,pro where reg.pro_id=pro.id order by reg.pro_id desc"
Dim sqlada As OleDbDataAdapter
sqlada = New OleDbDataAdapter(sql, conn)
sqlada.Fill(ds, "reg")
MyDataGrid.DataSource = ds
MyDataGrid.DataBind()错误行
行 34: sqlada.Fill(ds, "reg")表达式中的类型不匹配。
改为
Dim sql As String = "select reg.[id], reg.title, pro.content from reg,pro where reg.pro_id=pro.[id] order by reg.pro_id desc"