|
PLS I NEED CODE THAT WILL ALLOW ME TO CONNECT FROM VISUAL BASIC TO ORACLE 10G DATABASE.
THANKS
ADEMOLA
|
|
|
|
|
|
DON'T YELL! It's considered very rude to post in all upper case.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Me thinks COBOL programmer.
CleaKO
"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy "Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)
|
|
|
|
|
Hi Friends,
I am developing a website to watch online movies. User needs to call a number to view movie (A company provide service to check whether user is connected to line or not They will call a script that will save or delete record in the database when user connects or disconnects phone line).
The only think which I need is that I need to run a script that checks database after every 5 or 10 seconds whether user record exists or not. I know it is possible to 'Refresh' page after certain time but my client doesn't want to do like this. I am using vb.net and Access database for this. I am struggling in it so waiting desperately for your reply.
Regards,
Abubakar Malik
|
|
|
|
|
This would probably require some JavaScript code on your page to do the 5 second timer and the checking of the database.
No, I don't have any examples. I don't do web development for living...
Your question would be better asked in the ASP.NET Forum.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I think you should be use Ajax.
Parwej Ahamad
g_parwez@rediffmail.com
|
|
|
|
|
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
|
|
|
|