如何修复“查询值和目标字段的数量不相同。” [英] How to Fix "Number of query values and destination fields are not the same."
本文介绍了如何修复“查询值和目标字段的数量不相同。”的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
Private Sub Daftar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Daftar.Click
If Nama.Text = "" Then
MessageBox.Show("Sila Isikan Nama Anda!", "Amaran!")
ElseIf Noic.Text = "" Then
MessageBox.Show("Sila Isikan No I/C Anda!", "Amaran!")
ElseIf Alamat.Text = "" Then
MessageBox.Show("Sila Isikan Alamat Anda!", "Amaran!")
ElseIf Jantina.Text = "" Then
MessageBox.Show("Sila Pilih Jantina Anda!", "Amaran!")
ElseIf Notel.Text = "" Then
MessageBox.Show("Sila Masukkan No Telefon Anda!", "Amaran!")
Else
MessageBox.Show("Pastikan Maklumat Yang Diisi Adalah Tepat!", "Amaran!", MessageBoxButtons.YesNo)
Call Koneksi()
CMD = New OleDbCommand("Select * from Ahli where IDAhli='" & IDahli.Text & "'", CONN)
RD = CMD.ExecuteReader
RD.Read()
If Not RD.HasRows Then
Dim simpan As String = "insert into Ahli values ('" & Nama.Text & "','" & Noic.Text & "','" & Alamat.Text & "','" & Umur.Text & "','" & Bangsa.Text & "','" & Notel.Text & "','" & Jantina.Text & "')"
CMD = New OleDbCommand(simpan, CONN)
CMD.ExecuteNonQuery()
MsgBox("Data berhasil di Input", MsgBoxStyle.Information, "Information")
End If
End If
End Sub
我试图将数据从vb2010添加到Microsoft Acces 2013 ..任何人都可以帮助我!
Im trying to add data from vb2010 to Microsoft Acces 2013.. Can anyone please help me on this!
推荐答案
插入Ahli值('& Nama.Text& ','& Noic.Text&', &安培; Alamat.Text&安培; ','& Umur.Text& ','& Bangsa.Text& ','& Notel.Text& ','& Jantina.Text& ')
在查询中给出列名(在表名后面)。
确保表中的列与提供的数据。
例如插入table1(A,B,C,D)值(a1,b1,c1,d1)
始终提及列名插入如下...
Always mention Column Names while inserting like below...
INSERT INTO TableName(Column1, Column2, Column3) VALUES("somevalue1", "somevalue2", "somevalue3")
由于您没有提到列名,所以如果你不会连续提供所有列,它会抛出异常。因此,请小心并更新您的代码。
As you have not mentioned the column names, so if you are not going to provide all the Columns serially, it would throw you exception. So, be careful and update your code.
这篇关于如何修复“查询值和目标字段的数量不相同。”的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文