|
Would you please stop asking the same question over and over and over and over and over again, at least until you have read the replies that you already have gotten.
---
single minded; short sighted; long gone;
|
|
|
|
|
how to pass the unnamed parameter in the database in vb.net?
If con.State = ConnectionState.Closed Then
con.Open()
End If
Try
cmd = New OleDbCommand("insert into resume_details(Name,Skill,City,Experience,Email,Filetype) values(?,?,?,?,?,?)", con)
cmd.Parameters.Add(New OleDbParameter("", namee))
cmd.Parameters.Add(New OleDbParameter("", skill))
cmd.Parameters.Add(New OleDbParameter("", city))
cmd.Parameters.Add(New OleDbParameter("", year))
cmd.Parameters.Add(New OleDbParameter("", mail))
cmd.Parameters.Add(New OleDbParameter("", exts))
cmd.ExecuteNonQuery()
MsgBox(" 1 Record is inserted")
con.Close()
Catch ex As Exception
MsgBox(ex.ToString)
End Try
-- modified at 5:10 Wednesday 7th March, 2007
|
|
|
|
|
Just give the parameters any name you want. In OleDB, named parameters are not supported, and are ignored, but the order in which the parameters are added MUST match the order of the question marks in your SQL statement.
You are also missing the parameter data types. You can do what you're doing and it might work, but it's always a good idea to specify the database data types for each of your parameters. Otherwise, the parameter objects will "guess" at what they're supposed to be by looking at the type of data that is being passed into it.
cmd.Parameters.Add(New OleDbParameter("@name", OleDbType.VarChar, 30, name))
cmd.Parameters.Add(New OleDbParameter("@skill", OleDbType.VarChar, 30, skill))
cmd.Parameters.Add(New OleDbParameter("@city", OleDbType.WChar, 20, city))
cmd.Parameters.Add(New OleDbParameter("@year", OleDbType.Integer, year))
cmd.Parameters.Add(New OleDbParameter("@mail", OleDbType.WChar, 30, mail))
cmd.Parameters.Add(New OleDbParameter("@exts", OleDbType.VarChar, 5, exts))
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I have a client that want me to include finger print authenticator
in a project I deployed earlier.
Can anybody give me a guide on how to go about this?
I have never handle biometric before in any of my project.
ssonuh
|
|
|
|
|
It's rare to come acrossed a requirement like that. You'll have to contact the manufacturer of the fingerprint capture hardware you're using and get their SDK. The documentation on it, and the manufacturer's support staff, would be a much better source of information on this question than any forum.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Thanks for you advice. I will try that out and see.
ssonu
|
|
|
|
|
i got fillowing error:
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
Additional information: System error.
str = ("Data Source=server;Initial Catalog=mehul;User Id=sa;Password=airborne")
Dim slp As String = "INSERT INTO Table1 values(" & CInt(txtcont.Text) & ")"
con.ConnectionString = str
cmd = New SqlCommand(slp, con)
con.Open()
'error
cmd.ExecuteNonQuery()
'error
con.Close()
Imagine the I.T
|
|
|
|
|
Thanks for the SA account name and password! You might want to remove those items from future posts...
The error came up because something in either your connection string or your SQL INSERT statement is bad. In your SQL statement
INSERT INTO Table1 VALUES(somenumber)
you didn't mention which column this value was going into. It should be changed to something like this:
INSERT INTO Table1 (columnName) VALUES (value)
Why are you converting the contents of a textbox (a string value) to an integer, only to have it converted back to a string value to be inserted into this SQL statement?
You should seriously look into parameterized queries to avoid some major problems in the future. YOu can read more about them in Colin's article SQL Injection Attacks and Some Tips on How to Prevent Them[^].
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I need to know testcases for designing Vb form
|
|
|
|
|
swathibhandarkar wrote: I need to know testcases for designing Vb form
I'm not entirely sure what you mean by that - however, I'd imagine it really depends on what you want your form to do.
|
|
|
|
|
I am workin on Crystal Reports for VS2005
1>Can i create alerts in it,if yes how?
2>How can i read values that are assigned to formula fields in the application code?
Regards
Shaurya
|
|
|
|
|
Dear friends, can anyone please help me to put scroll bar in menuitems or any other way to have a quick navigation among 500 items or so.
thanks,
Jwalant Soneji (BE IT)
Mobile: +91 9969059127
http://jnsoneji.spaces.live.com
http://jnsoneji.blogspot.com
|
|
|
|
|
Menus don't get scrollbars. If you have to put 500 items in a single menu, you seriously need to rethink how that menu is presented. How about dividing it up into navigible groups of items, perhaps in submenus?
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Ohh, thanks, that is a good idea, i think i can make submenus containing 1-25 items and then 26-50 and so on.
currently i am using a for loop to fill the menuitems, and with sub menus to use, i think should use two for loops to bind them. is there any other better way?
thanks,
Jwalant Soneji (BE IT)
Mobile: +91 9969059127
http://jnsoneji.spaces.live.com
http://jnsoneji.blogspot.com
|
|
|
|
|
Copmletely reorganize your app so you don't have so many options for what appears to be a single field?
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I have take about 500-600 no of images in a group and i am putting the titles in a menuitem called images.
but when items goes more than almost 42 it gets a scroll at the bottom of it and its too slow to go to the like 350th item.
another thing i got in my mind is that to separate images in like groups of 25 images and put them into sub menu items.
what say?
Jwalant Soneji (BE IT)
Mobile: +91 9969059127
http://jnsoneji.spaces.live.com
http://jnsoneji.blogspot.com
|
|
|
|
|
unless you're giving them some sort of preview of what the images are when they go to pick them, I think a menu is out of the question. More like a dialog box with a preview of each image would be more appropriate.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
ohh thats a great idea, thanx, but then question arises for me is that, what contol is good if i am fetching images path from database and not all the images from a folder are available to the user?
and how the preview is achieved?
thanks,
Jwalant Soneji (BE IT)
Mobile: +91 9969059127
http://jnsoneji.spaces.live.com
http://jnsoneji.blogspot.com
|
|
|
|
|
A ListView or a ListBox would be good. You'll probably have to owner draw either of them.
Which images are available would be easy enough. All you do is put the images into the list that the user can see. How that is done depends on your secutiry system.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi, someone, I have a problem, I want to print priview listview how can i do? Give me example?
Socheat
................
|
|
|
|
|
try use PrintDocument and Printpreview Object to report the content of the listview.
ssonu
|
|
|
|
|
have try but it does only on the richtextbox but listview comes a blank page
|
|
|
|
|
I am designing a program for my father and he wants to be able to access a file from anywhere through the internet. He has an ftp space available on AOL, and I have got it to be able to download that file but I am unable to upload a file to it. I have code for it and it goes through the process and I never get an error saying that something went wrong, I even have it when it is finished I get a message box telling me it is done, and I get the message. Here is my code for the upload.
Dim c As WebClient = New WebClient
Dim FileName As String = Path & "\Limo Bookings\LimoBookings.run"
Dim URL As String = "http://members.aol.com/XXXXXXX/"
Dim responseArray As Byte()
Try
responseArray = c.UploadFile("http://members.aol.com/XXXXXXXX", "POST",FileName) c.Dispose()
MsgBox("Upload Completed!")
Catch ex As Exception
MsgBox(ex.Message, MsgBoxStyle.Critical, "Error")
End Try
I appreciate any suggestion you have! And I Thank You in advanced!
|
|
|
|
|
I think that AOL doesn't support HTTP uploads.
However you may use the FTP Upload, .Net framework provides a class for this.
Bye,
Webmaster of: www.thetotalsite.it
My web blog: blog.thetotalsite.it
|
|
|
|
|
you can use ftp access from ms-dos in a hidden process, you system must create a bat file with the ftp commands to upload these file, example
ftp -A -i -s:ftp_file_instructions.txt ftp_address
where
-A anonymous access, sorry, i don't know how access with permisses
-i no confirmation to each operation (yes or no to upload/download files)
-s param to describe the text file with instructions, this text file contain each ftp command in the current session.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
