deleting a record from dataview

Question

0.00/5 (No votes)

See more:

Hello.

VB

Dim dv As New DataView(_DataSet.Tables(0))
            dv.RowStateFilter = DataViewRowState.Deleted
       For _irow As Long = 0 To dv.Table.Rows.Count - 1
                      If Not IsDBNull(dv!serial) Then
               Dim strconnection As String = "Data Source=EASMAR-PC;Initial Catalog=Database Connection;Integrated Security=True;"
               Dim _cn As SqlConnection = New SqlConnection(strconnection)
               _cn.Open()
               Dim cmd As New SqlCommand
               cmd.CommandText = "Delete from tblCustomer where serial= " & txtSerial.Text
           End If
       Next

What am i missing?

I am getting this error:

VB

Conversion from string "serial" to type integer is not valid.

On this line:

VB

If Not IsDBNull(dv!serial) Then

Posted 1-Jan-14 20:54pm

Member 10388494

Updated 2-Jan-14 0:35am

v3

Add a Solution

Comments

thatraja 2-Jan-14 4:05am

In which line the error occurs? Always mention this

Glagace_7763 2-Jan-14 14:59pm

Not positive what you are trying to accomplish but it seems you are passing the entire column to the IsDBNull function, even though you believe you are looping through the dataview. dv!serial is not a specific row in the dataview. Could provide more information on what you are trying accomplished.

This thread may provide a better way to perform the task you are attempting.

http://www.vbforums.com/showthread.php?469872-Retrieving-and-Saving-Data-in-Databases

[no name] 3-Jan-14 2:49am

After i delete, insert, update into my dataset;I am trying to loop through the rows in my dataview, check the row state, if it's deleted(respectevely updated, inserted) i do the delete(respectively update, insert) in the database.
I know that the dataadapter does that for me. But i have to do it this way.
Any help would be appreciated

G-code101 5-Feb-14 7:42am

Try passing the row instead of the string value of the column name

If Not IsDBNull(dv.Table.Rows(_irow).Item(COLUMNINDEX)) Then

let me know if it worked

Member 10506215 5-Feb-14 7:44am

Thank you for your reply. The issue has been resolved :)

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)