Visual Basic

Re: HOW CAN I CONNECT FROM VISUAL BASIC TO ORACLE 10G

7-Mar-07 5:48

DON'T YELL! It's considered very rude to post in all upper case.

Dave Kreskowiak
Microsoft MVP - Visual Basic

Marcus J. Smith7-Mar-07 9:52

Marcus J. Smith

7-Mar-07 9:52

Me thinks COBOL programmer.

_Cle^aKO

"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)

Check Database after every 5 Seconds?

Abubakarsb6-Mar-07 23:44

Abubakarsb

6-Mar-07 23:44

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

Re: Check Database after every 5 Seconds?

Dave Kreskowiak7-Mar-07 5:47

Re: Check Database after every 5 Seconds?

7-Mar-07 5:47

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

Parwej Ahamad7-Mar-07 5:51

Parwej Ahamad

7-Mar-07 5:51

I think you should be use Ajax.

Parwej Ahamad
g_parwez@rediffmail.com

Re: Check Database after every 5 Seconds?

Guffa7-Mar-07 7:36

Guffa

7-Mar-07 7:36

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;

unnamed parameter [modified]

lopashree6-Mar-07 23:05

lopashree

6-Mar-07 23:05

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

Re: unnamed parameter

Dave Kreskowiak7-Mar-07 5:45

Inclusion of Finger Print Authenticator in VB.Net Project

7-Mar-07 5:45

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

ssonuh6-Mar-07 22:59

ssonuh

6-Mar-07 22:59

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

Re: Inclusion of Finger Print Authenticator in VB.Net Project

Dave Kreskowiak7-Mar-07 5:36

Re: Inclusion of Finger Print Authenticator in VB.Net Project

7-Mar-07 5:36

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

ssonuh9-Mar-07 21:54

ssonuh

9-Mar-07 21:54

Thanks for you advice. I will try that out and see.

ssonu

error in vb.net

ajay588866-Mar-07 22:43

ajay58886

6-Mar-07 22:43

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

Re: error in vb.net

Dave Kreskowiak7-Mar-07 5:34

Crystal Report Alerts and reading report values in code

7-Mar-07 5:34

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

Test cases

swathibhandarkar6-Mar-07 21:32

swathibhandarkar

6-Mar-07 21:32

I need to know testcases for designing Vb form Confused | :confused:

Re: Test cases

Colin Angus Mackay6-Mar-07 22:34

Colin Angus Mackay

6-Mar-07 22:34

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.

Upcoming events:
* Edinburgh: Web Security Conference Day for Windows Developers (12th April)
* Glasgow: AJAX, SQL Server, Mock Objects

My: Website | Blog | Photos

Shaurya_Rastogi6-Mar-07 21:17

Shaurya_Rastogi

6-Mar-07 21:17

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

how to use scroll bar in menuitems

Jwalant Natvarlal Soneji6-Mar-07 21:15

6-Mar-07 21:15

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

Dave Kreskowiak7-Mar-07 5:22

7-Mar-07 5:22

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

Jwalant Natvarlal Soneji7-Mar-07 15:16

7-Mar-07 15:16

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

Dave Kreskowiak8-Mar-07 2:30

8-Mar-07 2:30

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

Jwalant Natvarlal Soneji8-Mar-07 15:41

8-Mar-07 15:41

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

Dave Kreskowiak9-Mar-07 12:18

9-Mar-07 12:18

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

Jwalant Natvarlal Soneji9-Mar-07 15:29

9-Mar-07 15:29

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

Dave Kreskowiak10-Mar-07 2:52