Comments by suhan 2012

suhan 2012 29-Jan-13 2:24am View

ok, thanks

suhan 2012 29-Jan-13 2:16am View

Actually I'm getting the exception if the table is completely blank and I open that user form after log in form. But when I open it as startup form, it works.

suhan 2012 29-Jan-13 2:12am View

Dim reg_id As Double = 0
reg_id = ds.Tables(0).Compute("Max(registrationID)", Nothing)

suhan 2012 29-Jan-13 2:03am View

Sir, Sorry for that, actually it is my login form's code.

Actually I wanted to tell you that your code is working fine when I open that form as startup form. But when I try to open that form after logging in I'm getting the same error. "Conversion from type 'DBNull' to type 'Double' is not valid." I think there is a conflict between the login form and user form. Can you please tell me how to solve this?

suhan 2012 29-Jan-13 1:53am View

Deleted

Public Function ask()
getconnect()
con.Open()

Dim da As New SqlDataAdapter("select * from users", con)
da.Fill(dt)
For Each DataRow In dt.Rows
If TextBox1.Text = DataRow.item(0) And TextBox2.Text = DataRow(1) Then
con.Close()
Return True

End If
Next
con.Close()
Return False
End Function

suhan 2012 28-Jan-13 10:34am View

Having some problem with BooleanIsNum..

suhan 2012 28-Jan-13 10:30am View

Working fine. Thanks.

suhan 2012 28-Jan-13 3:31am View

It works now. Thanks.

suhan 2012 28-Jan-13 3:31am View

Thanks.

suhan 2012 27-Jan-13 12:26pm View

and that's why I need your help.

suhan 2012 26-Jan-13 13:06pm View

I add that message box because I know that the data will be saved at that moment.

suhan 2012 26-Jan-13 12:25pm View

I've found it. The problem is occurring just because I changed the connection string to application.startuppath. It was working fine when the project folder was on the desktop and connection string was set to like, users\desktop\project folder\\ etc. So, can you please help me to keep the database in the debug folder and use it by application.startuppath?

suhan 2012 26-Jan-13 12:10pm View

Err! I have found it. The problem is occurring just because I changed the database path to application.startuppath. It was working fine when it was in its default path. So, can you please tell me what should I do in this moment?

suhan 2012 26-Jan-13 11:45am View

vs 2008, SQL sever 2005

suhan 2012 26-Jan-13 11:43am View

No, there is not any error message I get when I run this program. The problem is, I do not see any data in the table.

suhan 2012 26-Jan-13 11:39am View

The same code concept works fine with my access database!! But what's wrong with sql server? I see a blank table when I open it.

suhan 2012 26-Jan-13 11:32am View

Sorry for this Andre.

suhan 2012 31-Dec-12 5:20am View

I changed the line as what Karthik said, but found no improvement. BTW I am using "Java Programming by Joyce Farrell". Is this a good book for me as a beginner? Waiting for your reply..

Comments by suhan 2012 (Top 18 by date)