|
|
Yes write an stored procedure and pass path parameter.
If your question is how then plz find below url
http://weblogs.sqlteam.com/tarad/archive/2004/06/16/1607.aspx
Parwej Ahamad
g_parwez@rediffmail.com
|
|
|
|
|
Hello actually i don't have much idea about the oracle but your can try on the basis of that code.
if you have further problem then you can discuss with me.
Parwej Ahamad
g_parwez@rediffmail.com
|
|
|
|
|
Hi, But i don't know oracle stored procedure. so i would like, which part of code not converted.
In which part of code you have face the problem, then i will try.Because i have no oracle server, that i can test it.
send me line of the code or whatever you have problem.
Parwej Ahamad
g_parwez@rediffmail.com
|
|
|
|
|
Please read below link.
http://www.dbasupport.com/oracle/scripts/Backup_Recovery/
I will try to convert in oracle.
Parwej Ahamad
g_parwez@rediffmail.com
|
|
|
|
|
This really should be done by the database and not your code. Adding this would make your code not very scalable since multiple copies of your application (on multiple servers) would all be trying to backup the database themselves.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
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
|
|
|
|