Update query coming from textboxes to gridview

Question

0.00/5 (No votes)

See more:

VB

Protected Sub cmdUpdate_Click(ByVal sender As Object, ByVal e As System.EventArgs)
        Dim connection As OleDbConnection
        connection = New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=C:\Users\emong\Documents\Visual Studio 2008\WebSite1\Database\dbLupon.mdb")

        Dim command As OleDbCommand
        command = New OleDbCommand("UPDATE tblLUPON_C SET REGION_C = '" & lblRegion_C.Text & "', PROVINCE_C = '" & lblProvince.Text & "', CITYMUN_C = '" & cmbCityMun.SelectedValue & "', BARANGAY_C = '" & DropDownList1.SelectedValue & "',  POSITION_C = '" & cmbPosition.Text & "', COUNT_C = '" & lblUnique.Text & "', LAST_M = '" & txtLName.Text & "', FIRST_M = '" & txtFName.Text & "', MIDDLE_M = '" & txtMName.Text & "', SUFFIX_C = '" & txtSuffix.Text & "', SEX_C = '" & cmbSex.Text & "' WHERE COUNT_C = @COUNT_C", connection)
        connection.Open()
        command.ExecuteNonQuery()
        connection.Close()
        BindGrid()
    End Sub
</script>

hello.
I'm having a problem regarding the update button..
the table has 11 fields.. and I only display six of the fields.

the error was : "No value given for one or more parameters "

your answer will be great help! :)thanks!

Posted 14-Feb-11 18:04pm

sevengenn

Add a Solution

Comments

Albin Abel 15-Feb-11 0:17am

this problem could occur when a not null field given a null value to update. Did you check all the values you are passing in the query is not null for a not null columns. If a column is a foreign key column to another table, then it also should not be null

sevengenn 15-Feb-11 0:27am

thanks.

but I put all the values on the textbox, but it didn't work :(

4 solutions

Solution 1

WHERE COUNT_C = @COUNT_C
You didn't declare any value for @count_c in your query.

Posted 14-Feb-11 18:14pm

m@dhu

Comments

sevengenn 15-Feb-11 0:27am

thanks :)

I changed it. :)
but it has the same error :(

Solution 2

Is there another way to update a gridview without using the Update query?

Posted 14-Feb-11 18:28pm

sevengenn

Comments

Kirankumar Ballapalli 15-Feb-11 0:31am

Hi,
Check that whether table columns allowing null values or not.
Because one of textbox values coming as empty then table column value is expecting values.
I think it will help you.
Regards,
Kiran

sevengenn 15-Feb-11 0:40am

thanks kiran :) I will

Solution 3

If you want to write update query you have to use RowUpdating event of gridveiw control.

Posted 14-Feb-11 18:33pm

Ramalinga Koushik

Comments

sevengenn 15-Feb-11 0:39am

sir, can I used this way..

row.Cells(3).Text = txtLName.text?

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mohd Wasif · Accepted Answer · 2011-02-14T19:01:00

VB

Protected Sub cmdUpdate_Click(ByVal sender As Object, ByVal e As System.EventArgs)
        Dim connection As OleDbConnection
        connection = New OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=C:\Users\emong\Documents\Visual Studio 2008\WebSite1\Database\dbLupon.mdb")
        Dim command As OleDbCommand
        command = New OleDbCommand("UPDATE tblLUPON_C SET REGION_C = '" & lblRegion_C.Text & "', PROVINCE_C = '" & lblProvince.Text & "', CITYMUN_C = '" & cmbCityMun.SelectedValue & "', BARANGAY_C = '" & DropDownList1.SelectedValue & "',  POSITION_C = '" & cmbPosition.Text & "', COUNT_C = '" & lblUnique.Text & "', LAST_M = '" & txtLName.Text & "', FIRST_M = '" & txtFName.Text & "', MIDDLE_M = '" & txtMName.Text & "', SUFFIX_C = '" & txtSuffix.Text & "', SEX_C = '" & cmbSex.Text & "' WHERE COUNT_C = @COUNT_C", connection)
command.Parameter.AddWithValue("@COUNT_C",it's value)
        connection.Open()
        command.ExecuteNonQuery()
        connection.Close()
        BindGrid()
    End Sub
</script>

/*This Line You missed it*/
command.Parameter.AddWithValue("@COUNT_C",it's value)

Update query coming from textboxes to gridview

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us