|
Dear Jon_Boy,
"Sounds like a homework question to me. You might start to get some overly hostile responses with dumb posts like this."
This is definitely NOT a "homework question" - I must apologise profusely if it sounds like one and also if this post is construed as a "dump post".
"Sorry. I got my degree years ago and NO, I won't do your homework/work for you. Feel free to search CodeProject for tutorials and post back any specific questions with your current code."
I tried to be explicit and detail exactly what I was trying to achieve. You might be interested to know that;
1) I spent several hours searching/trolling Google.
2) I also spent quite some time searching CodePoject.
3) I was hoping to find some guidance as to an overall approach to take for this problem, so that I could go away and learn the required technologies. I currently have an understanding of VB an C#, but it is many years since I was employed as a professional programmer (like you I have a degree in computing) so I am a little behind the "8-ball" when it comes to the latest technologies etc, hence why I sort the advise of the experts, - I was not seeking the entire solution just guidance on how to best approach this problem.
Thank you again for your input.
Regards,
Sciencez
|
|
|
|
|
Sciencez wrote: 2) An answer that provided specific solutions (with source code). You might be interested to know that I have already received one such answer that addressed a particular part of the issue/problem aforementioned.
I cannot see any source code in that post. Can you?
Sciencez wrote: I thought (and still believe) that this forum was for people with detailed knowledge and/or expertise in a particular area to assist others (who have different knowledge or expertise) to address issues that they are struggling with (or wish to learn more about) - your response suggests that you see it otherwise.
Offcourse it is. But it is not a plcae where you can expect someone else to write code for you. You have asked for the source code and no one will do that for you atleast here. If you can show what you have tried and where do you struggle then there will be many to help you out.
जय हिंद
|
|
|
|
|
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
|
|
|
|
|
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 .
|
|
|
|
|
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.
|
|
|
|
|
|
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
|
|
|
|
|
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!
|
|
|
|
|
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!
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
IMO you are underestimating the skills of a lot of folks out there.
जय हिंद
|
|
|
|
|
You have mixed SQL insert and delete statements. Check the syntax for delete.
जय हिंद
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
Imports System.IO
If File.Exist("YourFileName.txt") Then
End If
My advice is free, and you may get what you paid for.
|
|
|
|
|
Where should i write Imports.Sytem.IO ?
|
|
|
|
|
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.
|
|
|
|
|
|
The rest goes in a seperate method and the button click event calls. 
|
|
|
|
|
Considering the question I figured I'd keep it simple 
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.
|
|
|
|
|
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...
|
|
|
|
|
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
|
|
|
|
|
I already have many books , but the information is very confusing
please suggest a good one for begginners like me?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
