Advertisement

08.17.2007 at 08:54AM PDT, ID: 22770059
[x]
Attachment Details

ERROR [07002] [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 6.

Asked by dhireshinfotronicsindia in Microsoft Access Database

Tags: , , , ,

Hello

below is my code and i get error as
1.) ERROR [07002] [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 6. on Update
2.) ERROR [07002] [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. on delete

Can i get help on this cause
______________________________________________________________________________________
Imports System.Data.Odbc
Partial Class charges
    Inherits System.Web.UI.Page
    Dim conn As New OdbcConnection("dsn=tracking")
    Dim command As New OdbcCommand
    Public come_from As String
    Public ch_id As Integer

    Protected Sub grdview_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles grdview.SelectedIndexChanged
        ch_id = grdview.SelectedRow.Cells(1).Text
        command = New OdbcCommand("select * from tbl_charges where charges_id=" & ch_id & "", conn)
        Dim drreader As OdbcDataReader
        drreader = command.ExecuteReader
        If drreader.Read Then
            txtcode.Text = drreader("charges_code")
            txtcurrency.Text = drreader("currency")
            txtdescription.Text = drreader("description")
           
            If drreader("service_yes") = True Then
                rdyes.Checked = True
                rdno.Checked = False
            ElseIf drreader("service_no") = True Then
                rdno.Checked = True
                rdyes.Checked = False
            End If
        End If
        drreader.Close()
    End Sub

    Protected Sub cmdadd_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmdadd.Click
        txtcode.Text = " "
        txtdescription.Text = " "
        txtcurrency.Text = " "

        txtcode.Enabled = True
        txtdescription.Enabled = True
        txtcurrency.Enabled = True
        cmdadd.Enabled = False
        cmdedit.Enabled = False
        cmdsave.Enabled = True
        cmddelete.Enabled = False
        come_from = "add"
    End Sub

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        txtcode.Enabled = False
        txtdescription.Enabled = False
        txtcurrency.Enabled = False
        cmdadd.Enabled = True
        cmdedit.Enabled = True
        cmdsave.Enabled = False
        cmddelete.Enabled = True
        conn.Open()
    End Sub

    Protected Sub cmdsave_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmdsave.Click

        Dim adp As New OdbcCommand("SELECT charges_code FROM [tbl_charges] where charges_code='" & txtcode.Text & "'", conn)
        Dim ds1 As OdbcDataReader

        ds1 = adp.ExecuteReader
        If ds1.Read Then
            Label1.Text = "Category Already Exists, Kindly Enter Unique Category Name"
        Else
            Dim command As New OdbcCommand("insert into tbl_charges ([charges_code],[description],[currency],[service_yes],[service_no])values('" & txtcode.Text.Trim & "','" & txtdescription.Text.Trim & "','" & txtcurrency.Text.Trim & "'," & rdyes.Checked & "," & rdno.Checked & ")", conn)
            command.ExecuteNonQuery()

        End If
    End Sub

    Protected Sub cmdedit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmdedit.Click
        If cmdedit.Text = "EDIT" Then
            cmdadd.Enabled = False
            cmddelete.Enabled = False
            txtcode.Enabled = True
            txtdescription.Enabled = True
            txtcurrency.Enabled = True
            rdyes.Enabled = True
            rdno.Enabled = True
            cmdedit.Text = "UPADTE"
            come_from = "edit"
        Else
            command = New OdbcCommand("Update tbl_branch set charges_code='" & txtcode.Text.Trim & "',[description]='" & txtdescription.Text.Trim & "', [currency]='" & txtcurrency.Text & "',service_yes=" & rdyes.Checked & ",service_no=" & rdno.Checked & " where charges_id=" & grdview.SelectedRow.Cells(1).Text & "", conn)
            command.ExecuteNonQuery()
            cmdedit.Text = "EDIT"
            cmdadd.Enabled = True
            cmdedit.Enabled = True
            cmdsave.Enabled = False
            cmddelete.Enabled = True
            grdview.DataBind()
            'command = New OdbcCommand("Update tbl_charges set charges_code='" & txtcode.Text.Trim & "',[description]='" & txtdescription.Text.Trim & "',[currency[='" & txtcurrency.Text & "', service_yes=" & rdyes.Checked & ",service_no=" & rdno.Checked & " where charges_id=" & grdview.SelectedRow.Cells(1).Text & "", conn)
        End If
    End Sub

    Protected Sub cmddelete_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmddelete.Click
        command = New OdbcCommand("delete * from tbl_charges where category_id=" & grdview.SelectedRow.Cells(1).Text & "", conn)
        command.ExecuteNonQuery()
    End Sub

    Protected Sub Page_Unload(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Unload
        conn.Close()
    End Sub
End Class

Start Free Trial
[+][-]08.17.2007 at 09:30AM PDT, ID: 19718175

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Access Database
Tags: few, too, access, expected, microsoft
Sign Up Now!
Solution Provided By: dqmq
Participating Experts: 2
Solution Grade: A
 
 
[+][-]08.18.2007 at 02:05PM PDT, ID: 19723814

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_1_20070628