使用VB.NET将Datagrid转换为dbf数据库 [英] Datagrid to dbf database using VB.NET

问题描述

Dim con As New OleDbConnection
Dim ds As New DataSet
Dim dt As New DataTable
Dim da As New OleDbDataAdapter
Dim con1 As New OleDbConnection
Dim ds1 As New DataSet
Dim dt1 As New DataTable
Dim da1 As New OleDbDataAdapter


Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    con.ConnectionString = "Provider=vfpoledb.1;Data Source=C:\dbf_folder;Collating Sequence=machine;"
    con.Open()
    ds.Tables.Add(dt)
    da = New OleDbDataAdapter("Select * from area.dbf", con)
    Dim cb = New OleDbCommandBuilder(da)
    cb.QuotePrefix = "["
    cb.QuoteSuffix = "]"
    da.Fill(dt)
    dt.Merge(dt1)
    dbfdatagrid.DataSource = dt.DefaultView
    con.Close()
End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    con1.Close()
    con1.ConnectionString = "Provider=vfpoledb.1;Data Source=C:\dbf_folder1;Collating Sequence=machine;"
    con1.Open()
    da1 = New OleDbDataAdapter("Select * from area.dbf", con1)
    Dim cb = New OleDbCommandBuilder(da1)
    cb.QuotePrefix = "["
    cb.QuoteSuffix = "]"
    Dim columns(5) As DataColumn
    columns(4) = dt.Columns("NAME")
    dt.PrimaryKey = columns

    da1.Fill(dt1)
    da1.Update(dt)
  End Sub

我尝试了什么



Datagrid到dbf数据库更新类型的解决方案找不到任何地方，如果有人解决这个问题请回复我。 错误 - 对于不返回任何键列信息的SelectCommand，不支持UpdateCommand的动态SQL生成。

推荐答案

您是否检查过谷歌这个？



这个问题最可能的原因可能是因为你没有主键在相应的表格中。



检查以下主题 -

错误：对于不返回任何键列信息的select命令，不支持update命令的动态sql生成 [< a href =http://www.codeproject.com/Questions/200154/Error-Dynamic-sql-generation-for-the-update-comman\"target =_ blanktitle =New Window> ^ ]



要将主键约束添加到现有表中，您可以编写类似于

Have you checked this in google?

The most possible cause of this issue could be because you don't have a primary key in the respective table.

Check following threads-
Error:Dynamic sql generation for the update command is not supported against a select command that does not return any key column information[^]

To add primary key constraint to an existing table, you can write like-

ALTER TABLE MyTable ADD CONSTRAINT pkMyTable PRIMARY KEY (MyColumn)

如果我在这里遗漏了什么，请建议。



希望，它有帮助：）

If I am missing something here, please suggest.

Hope, it helps :)

这篇关于使用VB.NET将Datagrid转换为dbf数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！