logo
down
shadow

Number of query values and destination fields are not the same. Error Message


Number of query values and destination fields are not the same. Error Message

Content Index :

Number of query values and destination fields are not the same. Error Message
Tag : visual-studio , By : SachinJadhav
Date : November 22 2020, 10:58 AM

it should still fix some issue I'm having an error message with my codes in visual basic. Please help. . , You had extra Comma (,) here
& Me.txtYear.Text & "','
Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click Dim cmd As New OleDb.OleDbCommand

If Not cnn.State = ConnectionState.Open Then
    cnn.Open()
End If

cmd.Connection = cnn

If Me.txtID.Tag & "" = "" Then
    cmd.CommandText = "INSERT INTO ProfessorListTable(ID,LastName,FirstName,MI,Gender,Department,ContactNo,[Address],EmailAddress,YearEmployed)" & _
        " VALUES(" & Me.txtID.Text & ",'" & Me.txtLName.Text & "','" & _
        Me.txtFName.Text & "','" & Me.txtMI.Text & "','" & _
        Me.txtGender.Text & "','" & Me.txtDept.Text & "','" & _
        Me.txtNo.Text & "','" & Me.txtAddress.Text & "','" & _
        Me.txtEAdd.Text & "','" & Me.txtYear.Text & "')"

    cmd.ExecuteNonQuery()
Else
    cmd.CommandText = "UPDATE ProfessorListTable " & _
    " SET txtID=" & Me.txtID.Text & _
    ", LastName='" & Me.txtLName.Text & "'" & _
    ", FirstName='" & Me.txtFName.Text & "'" & _
    ", MI='" & Me.txtMI.Text & "'" & _
    ", Gender='" & Me.txtGender.Text & "'" & _
    ", Department='" & Me.txtDept.Text & "'" & _
    ", ContactNo='" & Me.txtNo.Text & _
    ", [Address]='" & Me.txtAddress.Text & "'" & _
    ", EmailAddress='" & Me.txtEAdd.Text & "'" & _
    ", YearEmployed='" & Me.txtYear.Text & _
    " WHERE stdid=" & Me.txtID.Tag
    cmd.ExecuteNonQuery()


End If
RefreshData()
End Sub

Comments
No Comments Right Now !

Boards Message :
You Must Login Or Sign Up to Add Your Comments .

Share : facebook icon twitter icon

Number of query values and destination fields are not the same error


Tag : chash , By : Comfly
Date : March 29 2020, 07:55 AM
I think the issue was by ths following , I think you just missed some single quotes . I see you have enclosed all the parameters with a starting and end single quotes . See this
One more thing , as you are passing lot of parameter prepare a SqlCommand Object for Parameters. See msdn for more details.
  SqlCommand comm = new SqlCommand("INSERT INTO table VALUES (@txtsno, @txtdesg, @txtbasic)", connection);

  comm.Parameters.AddWithValue("@txtsno", txtsno.Text.Trim());

  comm.Parameters.AddWithValue("@txtsno", txtdesg.Text.Trim());

  comm.Parameters.AddWithValue("@txtsno", txtbasic.Text.Trim());

Number of query values and destination fields are not the same in vb6 Error


Tag : sql , By : Habikki
Date : March 29 2020, 07:55 AM
This might help you I want to ask something, , You missed a comma. Change
"'" & TBox(30).Text & "'" & _
                      ^^^
"'" & TBox(30).Text & "'," & _

Number of query values and destination fields are not the same error in C#?


Tag : chash , By : SilverRuby
Date : March 29 2020, 07:55 AM
I hope this helps you . am trying to store my textedit valued to MS Access Database but am getting error like this "Number of query values and destination fields are not the same". But my query values and destination fields are same. I try to inserting in two methods both method getting same error. , You have a missing comma after "ShippingA" in the line
"WholeDiscountP,WholeDiscountA,ShippingP,ShippingA". 

"Number of query values and destination fields are not the same" error on INSERT


Tag : development , By : Ganesh
Date : March 29 2020, 07:55 AM
this one helps. You have 17 columns in your columns list, but you are adding an extra (18th) zero-length string value onto the end of your VALUES list:
TextBox13.Text & "','" & "')"
                   ^^^^^^^^
str = 
        "Insert into accountsTable (Account_Number, First_Name, Midle_Name, Last_Name, Date_of_birth, Occupation, Age, Marital_Status, Address, City, Country, State, Account_Type, Pin_Code, Mobile_Number, Email_ID, Opening_Balance) " &
        "values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"
cmd = New OleDb.OleDbCommand(str, con)
cmd.Parameters.AddWithValue("?", TextBox1.Text)
cmd.Parameters.AddWithValue("?", TextBox2.Text)
cmd.Parameters.AddWithValue("?", TextBox3.Text)
cmd.Parameters.AddWithValue("?", TextBox4.Text)
cmd.Parameters.AddWithValue("?", DateTimePicker1.Value)
cmd.Parameters.AddWithValue("?", TextBox6.Text)
cmd.Parameters.AddWithValue("?", TextBox7.Text)
cmd.Parameters.AddWithValue("?", TextBox8.Text)
cmd.Parameters.AddWithValue("?", TextBox9.Text)
cmd.Parameters.AddWithValue("?", ComboBox1.Text)
cmd.Parameters.AddWithValue("?", ComboBox2.Text)
cmd.Parameters.AddWithValue("?", ComboBox3.Text)
cmd.Parameters.AddWithValue("?", ComboBox4.Text)
cmd.Parameters.AddWithValue("?", TextBox10.Text)
cmd.Parameters.AddWithValue("?", TextBox11.Text)
cmd.Parameters.AddWithValue("?", TextBox12.Text)
cmd.Parameters.AddWithValue("?", TextBox13.Text)
cmd.ExecuteNonQuery()
If TextBox13.Text.Length = 0 Then
    cmd.Parameters.AddWithValue("?", DBNull.Value)
Else
    cmd.Parameters.AddWithValue("?", Convert.ToDecimal(TextBox13.Text))
End If

Error: Number of query values and destination fields are not the same - what am I doing wrong?


Tag : chash , By : Ben Kohn
Date : March 29 2020, 07:55 AM
Related Posts Related QUESTIONS :
  • What causes the error: The "NgenLocalized" parameter is not supported
  • F# Breakpoints only work after a an exception is thrown
  • Unable to build a Dockerfile created by Visual Studio 2019 - Docker and Azure
  • I want to blur my parent grid with black shade at the time of popup in uwp. Is there any way to implement this in uwp
  • Nuget Restore in a Docker Container
  • How to mark files of a folder as embedded resource with wildcards with the new project format?
  • How do you deploy different logins based on environment in SQL Server Database Project 2017?
  • After PostBuild event Visual Studio/MS Build
  • Visual Studio 17 - example colors visibility
  • MSBuild how to pass parameters to be used in CPP source file?
  • How to enable .gitignore file in private repository in GitHub with GUI
  • How to create an exe for .NetCore service
  • Show tooltip on hover over text
  • Confusion about CUDA installation instructions (What exactly is microsoft visual studio?)
  • How should I include Package References in a VSIX project
  • Group by multiple columns, then order results
  • Visual Studio 2019 not entering break point in Azure Functions local debuging mode
  • How can you create a view as a post deployment script in a SQL Server Database Project?
  • Import error data source of Oracle to Visual Studio (Azure analysys Server)
  • Why the script does not work / the button is not pressed in the web browser (control/component)?
  • Bootstrap 4 library name in Libman (CDNJS) from Visual Studio 2019
  • Is there a way to configure Visual Studio 2019 to display tab groups title on the bottom instead of top (as in VS2017)?
  • Package Manager Console fails to read ConnectionStrings when running Add-Migration
  • Nuget Package - Properties - Path is not set
  • Visual Studio - Automatically convert new lines in code when pasting
  • Why is my App Insights not recording data?
  • Can't create a Team Project for Azure DevOps Server 2019 from Visual Studio 2017
  • How to add child project additional output to publish items with MSBuild?
  • Adding SSIS capability to Visual Studio Enterprise 2017
  • Visual studio push to Github
  • Visual Studio Net Core Web App: No option to output as web app in project properties?
  • How do I update my IntelliCode model in Visual Studio 2019?
  • Microsoft visual studio doesn't show any android emulator or physical device for Xamarin project
  • Nuget: Unable to retrieve results from one or more sources
  • When using WinSCPnet from NuGet, how can I get the executable into a custom output directory without a duplicate of the
  • Setting up botan in visual C++
  • How do I set some project references to CopyLocal = false based on metadata?
  • visual studio keeps adding a _1 to a project name crashing the build
  • Generating the dll file for the solution
  • Adding umbraco folders to build with MsBuild
  • TFS build unable to locate the project file and dlls
  • In Razor Pages with Visual Studio 2019, editing a tag attribute will scramble all tag helper attribute values
  • Why doesn't Visual Studio create an APK when building a Xamarin Forms app?
  • Visual Studio Code Editor Settings
  • Visual Studio 2015 Update 3 (KB3165756) Setup Blocked
  • Xamarin.ios CollectionView Delete and Insert Items
  • What can I scrape off the Visual Studio 2015 installation package (like SQL) and still leave it functional?
  • T4 templates vs TT Templates vs Includes in visual studio
  • function tagged `stdcall` isn't recognized as `stdcall`
  • Converting a Julian Date to datetime in Visual Studio (SSIS Package)
  • QT build fails with NMAKE : fatal error U1077: 'echo' : return code '0x1'
  • Visual Studio: Is there a keyboard shortcut to jump between code editor window and find results?
  • Visual studio 2013 deploy file on save
  • Angular2=>Angular 5.2 in visual studio 2015 very slow launch after update
  • The build tools for v140 cannot be found
  • Nuget Install always fails after successfull install
  • How does Visual Studio choose which iOS simulator to start?
  • Error reading NuGet.config
  • Missing Microsoft RDLC Report Designer in Visual Studio after installation of Sql server Data Tools
  • How can I run a specific page in my UWP app?
  • shadow
    Privacy Policy - Terms - Contact Us © scrbit.com