|
Dear ALL,
I have encounter problem when I deleting a record in my program. Error msg as follow:
OleDbException was unhandled.
No value given for one or more required parameters.
I think I have declare the correct statement but it still prompt me...
My code as follow:
Public Sub delRec(ByVal column As String, ByVal table As String, ByVal value As String)
'create connection instance with connection string
Dim myConnection As New OleDbConnection(ConnString)
'sql delete query
Dim query As String
If table = "SALPASS" Then
query = "DELETE FROM " & table & " where " + column + " = " + value
Else
query = "DELETE FROM " & table & " where " & column & " = " & value
End If
'create sql command instance with the delete query
Dim myCommand As New OleDbCommand(query, myConnection)
'open database connection
myConnection.Open()
'execute sql delete command found in query string
myCommand.ExecuteNonQuery()
'Close the connection
myConnection.Close()
End Sub
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
If GroupBox1.Text = "Sales" Then
If TextBox1.Text = "" Then
'display error message box
MsgBox("Error!" + vbCrLf + vbCrLf + "Please select User Id to delete", MsgBoxStyle.Exclamation, "Deletion Error")
Else
'deletes record from database
delRec("USER_ID", "SALPASS", TextBox1.Text)
lblLabel.Text = "Record Deleted"
'refresh table
getsaltable()
End If
end sub
I just want to delete the user id and password.
Please advise.
Thanks
Jack
Jack
|
|
|
|
|
Do one thing. the query you build in the function. Copy that Query and run that directly in the SQL Query analyzer or what ever the database you are using. this will clear you that the query is fine.
Also check on which line it creates the problem ?
|
|
|
|
|
ur query i think is somewhat wrong. It should be
query="DELETE FROM '"& table &"' where '" + column + "' = '" + value+"'
format should be
<string_variable>="<insert,update,delete> from '"+<table_name>+"' "
all runtime values should be entered inthis format
'"+<variable_name or="" parameter_name="">+"'
if + sign doesn't work try &
|
|
|
|
|
 Thanks Will try on that
jack
|
|
|
|
|
i would like to view record from the dataabse.but i dont know how to write the coding..sir,pls help me.
|
|
|
|
|
Search for ADO.NET tutorials on this webpage. You will find many resources.
--------------------------------------------------------
My portfolio & development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
Hi ,
please i'm just a beginner in this way i hope to be a good developper , well i'm not going to write a story abt ma life but i wanna know somethings i hope you can make them clear to me
well let start with difecult words
Assembly
.config files
XML
just this three words can you explain what they mean i know this is not a correct question in a forum but when i hear this three words i feel really stupide & weak i think that i'm not & i will never be a good programmer
i wanna know if i'm a programmer even if i don't know how to use those things & i wanna know what those mean & when can we use them & why ??
thank you very much
if you can't answear i will thank you because i will do the same if i see like this stupide question in a vb.net forum but i hope you understand
try to be good if you can't be the best
|
|
|
|
|
Try searching for these terms on Wikipedia[^] or on Google[^].
You'll get quicker and possibly more comprehensive answers there.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
|
|
|
|
|
Back in the good ol' days (dark ages) when real programmers used punched cards, all printout was mono-spaced. We didn't use proportional fonts; we didn't even HAVE proportional fonts. It was easy to make a report mock-up, convert it to fixed positions on the page, and convert that to code (COBOL, Fortran, ASM, whatever).
Now, I'm trying to put together a report with vanilla VB.Net code, not Crystal Reports or anything like that. Now, everything is trial-and-error. I add a couple of items to the page, and run a test. Then I add a couple more and repeat the cycle. I'm thinking that there has to be an easier way. I've found lots of code that writes to the printer. But I've not found any references that explain how to shorten the trial-and-error cycle. I am using PrintPreview, so I'm not taking the time and trees to actually print the report. But the testing cycles are still too time-consuming.
When the boss brings you a sheet of paper with a report scribbled on it, how do you make a pretty report with a minimum of fuss.
Thanks for the help. This is definitely in the category of teaching an old dog a new trick.
HamCoder
|
|
|
|
|
i am using an active-x control but wherever i run the project i got the error that "Active-x Component can not create object" whats is the cause of that error and second thing is that what is the use of somefilename.exe.manifest file" need help here really stucked
From the Dust u r and to Dust u will Return
|
|
|
|
|
Zulnurain wrote: wherever i run the project i got the error that "Active-x Component can not create object"
Ensure that the ActiveX control is properly registered on your system.
Zulnurain wrote: what is the use of somefilename.exe.manifest file"
It's used (in some cases) to specify to Windows what objects to use for UI style rendering. Typically when using a VB6 program on XP so that XP visual styles are applied.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
|
|
|
|
|
I have Initial and Final Date and Time, Post Time and Days, Preview Days and Time. All are fields of task, I have a list of task that today is of alarm day and Time. Help me to do make the algoritm.
|
|
|
|
|
What?
--------------------------------------------------------
My portfolio & development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
 Sorry, we can't help without further info!
I assume this is essentially a schedule with each item having specific milestones/target dates?
Until you further explain what each of these mean and how they relate to each other we can't help.
|
|
|
|
|
You are not making any sense. Maybe it is the translation from Spanish to English that's the problem?
What you need to do is re-state what you are trying to achieve and only then we can help.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
|
|
|
|
|
A basic question from a baby programmer here, I must have accidently clicked something, but I can no longer view properties windows on any of my VB.Net projects; ones I'm working on, ones that are complete and even try opening up new projects - can't open up properties windows - not from drop down menu, not from clicking on icons
|
|
|
|
|
You have tried clicking on the "Properties window" menu item in the "View" menu?
--------------------------------------------------------
My portfolio & development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
yes, of course, thats the first thing, view menu, also the icon, it just won't appear. It was there previously
|
|
|
|
|
I don't know why my properties windows disappeared, but found that if I go to TOOLS, OPTIONS, GENERAL and then click on RESET WINDOWS LAYOUT, they come back
Thanks
|
|
|
|
|
Hello,
I am having difficulties with display text coming up blank when running the complied code on Windows XP test workstation. I have an existing application is displaying blank when a user is prompt the message.
The same executable works just fine development computer.
Example...
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
MessageBox.Show("Hello World !")
'msgbox.Form1("This is a Test using ..." & ControlChars.NewLine _
'& "MsgBox")
End Sub
Thank you
|
|
|
|
|
I don't understand your question fully, but ... what message are you missing?
--------------------------------------------------------
My portfolio & development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
I just figured out the problem. The problem is with "Network Associates McShield" service. When I stop the service the Text is displayed properly from the MS VB.NET application. McAfee has a hot fix #9 to resolve this problem.
Thanks...
|
|
|
|
|
I´m trying to make an "administrative console style" application using
vb.net (an application with a visual layout as usual mmc console applications). I'm
using a main form with a SplitContainer. In the left SplitterPanel I have
a TreeView control, and my idea is to open "subforms" in the right side
SplitterPanel. This is easy to do with code like:
Dim frm As Form
frm = New subform
frm.TopLevel = False
Me.SplitterPanel1.Panel2.Controls.Add(frm)
frm.Show()
This works. The problem is when need to resize the main form. The
"subform" remains in the some original size. Can someone tell me how
to force the subform to resize ? Is there any better way to make
this "administrative console like" type of applications?
Thank you
|
|
|
|
|
You can play around with the form's Dock or Achor properties. Dock will 'stick' the form in Top/Bottom/Left/Right/Fill position in the panel. Achor let the panel resize the form according to which side you want to 'stick' it to.
Remember most if not all controls have these 2 properties too.
|
|
|
|
|
i have to send data packets (9 bytes each) to another terminal device. However due to the hardware design of the terminal device there has to be a pause of 26.3 milli secs between two data packets. in case the pause duration is not matched the device is unable to accept the data. please post a suitable code for delaying the com port output for this specified duration (26.3 m secs).
shergill
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
