Re: Removal Of Row By Listbox Troubles - Visual Basic Discussion Boards

Re: Digital dashboard using VB or C# and other technologies

0x3c04-Jun-09 8:58

4-Jun-09 8:58

If you know how the data is transferred over the ports, then you could use inportb and outportb to read and write data to raw ports. I'm not certain how Windows exposes these through the API though - presumably something in kernel32.dll

Between the idea
And the reality
Between the motion
And the act
Falls the Shadow

Master and details saving

atk88774-Jun-09 3:15

atk8877

4-Jun-09 3:15

hi all ,
well , i have invoice form separated into 2 parts the upper part is master (header) and detail (body) in invoices where header contains date,name,invoice number,etc ..and the lower part is the body contains the datagridview with its details like the item name or code,qty,price,discount,etc ..
the problem is i want to save the invoice headers in a table and the body in another different table but with a realtion between the 2 of them by the invoice id i think i put it in the invoices' form load. but i cant get it right .
so if any one have an example by code 2 solve this prob , please send .
by the way iam using vb. net 2005 and my db is sql 2005.
thanx all .

A word of advice

Kschuler4-Jun-09 6:33

Kschuler

4-Jun-09 6:33

People who use these forums get a bit upset when people post requests for them to just do work. Why don't you post YOUR code, tell us why it isn't working and what error messages you are getting, and we'll try to help you.

Re: A word of advice

atk887711-Jun-09 3:38

atk8877

11-Jun-09 3:38

http://www.mediafire.com/download.php?b2cjz24mjad[^]

Removal Of Row By Listbox Troubles [modified]

eginteractive4-Jun-09 0:17

eginteractive

4-Jun-09 0:17

I have a listbox and a button, and whenever I press that button, it's supposed to delete the selected row in the SQL database by the ID. The ID is the primary key.

    Dim sqlconn As New SqlClient.SqlConnection
    sqlconn.ConnectionString = "Server=[Removed];Database=erik_asp;Uid=asp;Pwd=[Removed];"
    Try
        sqlconn.Open()
    Catch ex As Exception
        MsgBox("Could not connect!", MsgBoxStyle.Critical, "Connection Error!")
    End Try
    If sqlconn.State = 1 Then
        Dim sqlremovedata As New SqlCommand( _
   "DELETE FROM [Team] ([ID]) VALUES ('" & ListBox1.SelectedIndex & "')", sqlconn)
        sqlremovedata.ExecuteNonQuery()
        MsgBox("Deleted successfully!", MsgBoxStyle.Information, "Record Deleted!")
        sqlconn.Close()
    End If
End Sub

It throws this error which I can't figure out what I did wrong:

Line 1: Incorrect syntax near '('.

modified on Thursday, June 4, 2009 9:07 AM

Re: Removal Of Row By Listbox Troubles

Dave Kreskowiak4-Jun-09 1:30

Dave Kreskowiak

4-Jun-09 1:30

Your SQL statement is wrong. You may want to lookup the syntax for the DELETE statement. It should be:

DELETE FROM Team WHERE ID = ...

I highly discourage using string concatenation to build an SQL query like this. Google for "SQL Injection Attack" to see why and for example on using a parameterized query that is safer and easier to debug.

By the way, thank you very much for exposing one of your SQL Server's usernames and passwords to everyone on the ENTIRE INTERNET!

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Re: Removal Of Row By Listbox Troubles

EliottA4-Jun-09 2:50

EliottA

4-Jun-09 2:50

Dave Kreskowiak wrote:
thank you very much for exposing one of your SQL Server's usernames and passwords to everyone on the ENTIRE INTERNET!

Ha!

Check out the CodeProject forum Guidelines[^]

Re: Removal Of Row By Listbox Troubles

eginteractive4-Jun-09 3:07

eginteractive

4-Jun-09 3:07

I'm not concerned about it, as it's public anyway, not much you can really do to somehow affect my server.

The password is changed frequently also.

Also, I'm not really worried about SQL Injection as only my trusted friends are going to be able to have access to this application.

Re: Removal Of Row By Listbox Troubles

Oakman4-Jun-09 4:10

Oakman

4-Jun-09 4:10

eginteractive wrote:
Also, I'm not really worried about SQL Injection as only my trusted friends are going to be able to have access to this application.

You are a trusting soul. That's so nice to see these days.

Jon
Smith & Wesson: The original point and click interface

Both democrats and republicans are playing for the same team and it's not us. - Chris Austin

Re: Removal Of Row By Listbox Troubles

dan!sh 4-Jun-09 5:20

dan!sh

4-Jun-09 5:20

IMO you are underestimating the skills of a lot of folks out there.

जय हिंद

Re: Removal Of Row By Listbox Troubles

dan!sh 4-Jun-09 2:07

dan!sh

4-Jun-09 2:07

You have mixed SQL insert and delete statements. Check the syntax for delete.

जय हिंद

Re: Removal Of Row By Listbox Troubles

Jon_Boy4-Jun-09 7:24

Jon_Boy

4-Jun-09 7:24

Confused on what's borked with your SQL command?

1. Run profiler and see what's being sent to the server. Copy and paste that command into a query window in SQL Management Studio. Fix it until its right and reflect the changes in VB.

2. OR get the command.commandtext and paste that into the query window.

Easy to find and easy to fix. If your statement doesn't work in SQL natively, it will never work from VB.

"There's no such thing as a stupid question, only stupid people." - Mr. Garrison

Re: Removal Of Row By Listbox Troubles

eginteractive4-Jun-09 16:49

eginteractive

4-Jun-09 16:49

     sqlconn.Open()
 Catch ex As Exception
     MsgBox("Could not connect!", MsgBoxStyle.Critical, "Connection Error!")
 End Try
 If sqlconn.State = 1 Then
     Dim sqlremovedata As New SqlCommand( _
"DELETE FROM [Team] WHERE ([ID]) = "(ListBox1.SelectedItem))
     sqlremovedata.ExecuteNonQuery()
     MsgBox("Deleted successfully!", MsgBoxStyle.Information, "Record Deleted!")
     sqlconn.Close()
 End If

OH WONDERFUL. Now I've got a new error.

Conversion from type 'DataRowView' to type 'Integer' is not valid.

How to check if a file exists then delete it in vb.net 2005?

Striker.dbz3-Jun-09 23:45

Striker.dbz

3-Jun-09 23:45

I am stuck on a problem.
i need to delete a file by click a button in but before i need to check if the file exists.

Please reply.

Re: How to check if a file exists then delete it in vb.net 2005?

Johan Hakkesteegt3-Jun-09 23:59

Johan Hakkesteegt

3-Jun-09 23:59

Imports System.IO

If File.Exist("YourFileName.txt") Then

End If

My advice is free, and you may get what you paid for.

Re: How to check if a file exists then delete it in vb.net 2005?

Striker.dbz4-Jun-09 0:20

Striker.dbz

4-Jun-09 0:20

Where should i write Imports.Sytem.IO ?

Re: How to check if a file exists then delete it in vb.net 2005?

Johan Hakkesteegt4-Jun-09 0:22

Johan Hakkesteegt

4-Jun-09 0:22

Write Imports System.IO all the way at the top of your code, before all other code.

The rest goes in the click event of your button

My advice is free, and you may get what you paid for.

Re: How to check if a file exists then delete it in vb.net 2005?

Striker.dbz4-Jun-09 0:32

Striker.dbz

4-Jun-09 0:32

Thanks Problem solved.

Re: How to check if a file exists then delete it in vb.net 2005?

Dave Kreskowiak4-Jun-09 1:25

Dave Kreskowiak

4-Jun-09 1:25

The rest goes in a seperate method and the button click event calls. Big Grin | :-D

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Re: How to check if a file exists then delete it in vb.net 2005?

Johan Hakkesteegt4-Jun-09 1:32

Johan Hakkesteegt

4-Jun-09 1:32

Considering the question I figured I'd keep it simple Smile | :)

Have a look at the next post above this one, the code in it is soooo wrong I am afraid to even answer anything.

My advice is free, and you may get what you paid for.

Re: How to check if a file exists then delete it in vb.net 2005?

Dave Kreskowiak4-Jun-09 3:30

Dave Kreskowiak

4-Jun-09 3:30

Yeah, I saw a bunch of things wrong with it, but only pointed out a couple of issues. Since he's bent on writing bad code and practicing bad habits, why bother saying anything...

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Re: How to check if a file exists then delete it in vb.net 2005?

Ashfield4-Jun-09 1:40

Ashfield

4-Jun-09 1:40

Having seen all your recent posts, why not try buying a book and using that? These are very simple, basic questions you are asking and it seems as if you have no real idea what you are doing.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: How to check if a file exists then delete it in vb.net 2005?

Striker.dbz4-Jun-09 4:03

Striker.dbz

4-Jun-09 4:03

I already have many books , but the information is very confusing Confused | :confused:

please suggest a good one for begginners like me?

Re: How to check if a file exists then delete it in vb.net 2005?

Jon_Boy4-Jun-09 7:31

Jon_Boy

4-Jun-09 7:31

If you wanted to be really lazy, you could use the My.Computer.FileSystem methods as well.

Check this. Get you pointed in the right direction with the basics.

You could always search code sites for tutorials (ahem, CodeProject anyone?) or press F1 and search the MSDN library. For most topics, its really not that hard to find examples in the MSDN with minimal searching.

Is it beer thirty yet?

"There's no such thing as a stupid question, only stupid people." - Mr. Garrison

Re: How to check if a file exists then delete it in vb.net 2005?

Ashfield4-Jun-09 8:53

Ashfield

4-Jun-09 8:53

I have no idea what book would be suitable for a beginner as I haven't looked at that level f information for many years, but there are hundreds to choose from. Go to a good book shop or Amazon and browse a few until you find one you can understand. In the meantime, press F1 for help or use google, there are thousands of examples and code snippets out there, it just takes a little initiative to look for yourself rather than expecting other people to do your research for you.

I just had a quick look on Amazon and thsi sounds about your level:

Microsoft Visual Basic.NET Programming for the Absolute Beginner (Absolute Beginners) (Paperback)
by Jonathan Harbour

If that one is too complex then change career, t can't be much simpler than this.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.