Visual Basic

Cast from type 'DBNull' to type 'Integer' is not valid.

8-Jun-05 6:00

You might want to try the ASP.NET[^] Forum for this question...

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

msogun8-Jun-05 3:07

msogun

8-Jun-05 3:07

I am trying to get an orderId back from my table and could not. I create a stored procedure did not work. I use the select statement with where clause and did not work as well. Could someone help. Here is my code in stored procedure and select statement.

====================================================
CREATE PROCEDURE proc_getID
(@OrderId int out,
@CustomerName varchar(50)
)
As

SELECT @OrderId, @CustomerName FROM Orders WHERE Orders.CustomerName = @CustomerName
GO
==================================================================

Dim ConnStr As String
Dim SQL As String

ConnStr = "server=(local);database=Orders;uid=sa;pwd="
Dim MySqlConn As New SqlConnection(ConnStr)
MySqlConn.Open()
'''''''''''''''''''''''''''''''''''''''''''''''''
'''' I used select statement here '''''''''''''''
'''''''''''''''''''''''''''''''''''''''''''''''''
Dim myCommand As New SqlCommand("SELECT @OrderId ,@CustomerName FROM Orders WHERE CustomerName = @CustomerName", MySqlConn)
myCommand.Parameters.Add(New SqlParameter("@OrderId", SqlDbType.Int))
myCommand.Parameters.Add(New SqlParameter("@CustomerName", SqlDbType.VarChar, 50))
myCommand.Parameters("@CustomerName").Direction = ParameterDirection.Input
myCommand.Parameters("@CustomerName").Value = "steve"
myCommand.Parameters("@OrderId").Direction = ParameterDirection.Output
Dim eCount As Integer
eCount = 0
myCommand.ExecuteNonQuery()

eCount = CInt(myCommand.Parameters("@OrderId").Value)

TextBox4.Text = eCount.ToString
=========================================================================
===== I used stored procedure here =============
=================================================
'Dim cmdAuthor As New SqlCommand("proc_getID", MySqlConn)
'cmdAuthor.CommandType = CommandType.StoredProcedure
'cmdAuthor.Parameters.Add(New SqlParameter("@OrderId", SqlDbType.Int))
'cmdAuthor.Parameters.Add(New SqlParameter("@CustomerName", SqlDbType.VarChar, 50))
'cmdAuthor.Parameters("@CustomerName").Direction = ParameterDirection.Input
'cmdAuthor.Parameters("@CustomerName").Value = "steve"

'cmdAuthor.Parameters("@OrderId").Direction = ParameterDirection.Output
'Dim eCount As Integer
'eCount = 0
'cmdAuthor.ExecuteNonQuery()

''eCount = CInt(cmdAuthor.Parameters("@OrderId").Value)
'If cmdAuthor.Parameters("@OrderId").Value Is DBNull.Value Then
' '' The stored procedure returned a NULL output parameter
' eCount = -12345
' TextBox4.Text = eCount.ToString()

'Else
' eCount = cmdAuthor.Parameters("@OrderId").Value

' TextBox4.Text = eCount.ToString()
'End If

'TextBox4.Text = eCount.ToString()

MySqlConn.Close()
End Sub

Re: Cast from type 'DBNull' to type 'Integer' is not valid.

Dave Kreskowiak8-Jun-05 5:57

Re: Cast from type 'DBNull' to type 'Integer' is not valid.

8-Jun-05 5:57

Try wrapping your assignment line in a Try/Catch block...

Try
    eCount = CInt(myCommand.Parameters("@OrderId").Value)
Catch ex As Exception
    ' -1 will signify an invalid OrderID...
    eCount = -1
End Try

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

rwestgraham8-Jun-05 11:43

Please help regarding NGen

8-Jun-05 11:43

You can use a Try Catch block to trap this exception, and as a matter of principle all database operations should have error handling because they can fail for numerous reasons.

However, a stored procedure returning a Null value is not always a true error, and it is best to test for this condition. You should test for the DBNull condition BEFORE you attempt to assign the return parameter value to an integer. This will allow you to trap the null before your code raises an invalid cast error.

Change your code to:

If IsDBNull(cmdAuthor.Parameters("@OrderID").Value) Then
eCount = -12345
Else
eCount = CInt(cmdAuthor.Parameters("@OrderID").Value)
End If

Robert

prashant79_pawar8-Jun-05 3:00

prashant79_pawar

8-Jun-05 3:00

Hi
Iam using Ngen tool to speed up my application my .net framework version is 1.1. Iam using it like this.
Ngen and my assembly name on Dos prompt.My assenply means the exe file and dll which are in bin directory
d:\>foldername\bin>ngen assemly name with my two dll
Is it sufficeient to do to cache or ihave to do more because there is no effect on my app. performance
Please help with solution

Regards
Prashant

Re: Please help regarding NGen

Dave Kreskowiak8-Jun-05 5:52

Re: Please help regarding NGen

8-Jun-05 5:52

Of course is doesn't speed up your application. All NGen does is convert the IL code that's in the assemblies you specified into native processor code. It doesn't do any caching at all and will NOT speed up your application's startup time.

Do you have a startup form with ALOT of controls on it perhaps???

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Dave Kreskowiak9-Jun-05 2:50

Urgent - Cant Lock Application

9-Jun-05 2:50

Never heard of the problem.

Since we know nothing of what your forms are doing on load, what they look like, what the code looks like, ..., there's nothing we can do to help you. You have to provide A LOT more information about your forms and their code for anyone to help.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

kakomalis8-Jun-05 2:32

kakomalis

8-Jun-05 2:32

Hello,

I have a class in my web application that is used to connect to the database and submit or gain data from my tables.

The class is called dataAccess and is as follow:

Public Class DataAccess

Private Function Connect() As SqlClient.SqlConnection

Try

myConnection = New SqlClient.SqlConnection
myConnection.ConnectionString = myConnectionString
myConnection.Open()

Return myConnection

Catch ex As Exception

'Database Cannot be reached
Return Nothing

End Try

End Function

Protected Friend Function alertDatabase(ByVal myQuery As String) As Boolean

Dim myCommand As SqlClient.SqlCommand

Try

'Application.Lock()

myCommand = New SqlClient.SqlCommand(myQuery, Connect())
myCommand.ExecuteNonQuery()
DisConnect()

'Application.UNLock()

Return True

Catch ex As Exception

DisConnect()
Return False

End Try

End Function

End Class

At Application.Lock() my compiler says that namespace is not declare!!!

how can i solve this problem? Can i declare the application?

Thanks in advance,

Kakomalis

Re: Urgent - Cant Lock Application

Dave Kreskowiak8-Jun-05 5:50

8-Jun-05 5:50

I'm guessing that this is a seperate class file from your ASP web form. Try adding Imports System.Web to the top of your DataAccess class file.

BTW: Your data layer classes, properly written, shouldn't care about what type of application is using them. Your code is using a web application Lock method where it shouldn't have to. The data layer should never have this kind of dependancy.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Mapi controls

smita_roy8-Jun-05 2:29

smita_roy

8-Jun-05 2:29

I am using mapi controls to send emails automatically to the clients.I can send the mails but it always prompts to send message .how do i stop it

smita

Re: Mapi controls

Dave Kreskowiak8-Jun-05 5:39

sp with temptables doesnt work in crystal reports

8-Jun-05 5:39

You have to go into Outlook Express, click on the Tools Menu, click Options..., then click on the Security tab. Uncheck "Warn me when other applications try to send mail as me."

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

7-Jun-05 23:40

Hi,
I have written a stored procedure in SQL Server which uses temp tables and returns the rows of a temptable.

When i try to use this sp as datasource for Crystal report(Add Database), the fields are not listed.

Why is that? If this wouldnt work how do i implement this.

Am using a custom version of crystal report bundled in VS .NET.

Any help would be appreciated.

Geetha

removing temporary files after setup

7-Jun-05 23:27

Hello there
I have built a setup for the project. in which I included couple of image files to be displayed when user will run the setup. I want those files to be deleted after the installation is completed.
can any one tell me how ?

rwestgraham8-Jun-05 1:49

8-Jun-05 1:49

How exactly are you originally installing and displaying these images? If you add an image to a setup dialog, it can be embedded in the MSI itself, and does not need to be "installed". You can also add a custom action to delete the image files at the end of the setup, however if the image files are originally installed by the MSI itself, you must be careful how the atributes of the files are set, because deleting a file that is marked as required will trigger a repair to run automatically.

Robert

Rizwan Bashir8-Jun-05 2:05

Rizwan Bashir

8-Jun-05 2:05

well thanks for both the replies. in this scenario I am putting the image on SetupDialog. But the problem is when I click browse to assign the image to a dialog page it asks me the location of file according to the project... means file in Application Folder or User Desktop... etc. the folders exist in the project. so if the file is not there then you cannot assign. and if I add the files in application folder then it remains there after setup runs..

rwestgraham8-Jun-05 2:35

8-Jun-05 2:35

In order of easiest to hardest, also in order of least elegant to most elegant solutions:

1) You can just leave them, a couple of image files are no big deal.

2) You can write a custom action to delete them at the end of the setup. See MSDN for creating custom actions. Test it to make sure it does not triggera reinstall. If it does you need to adjust the file attributes.

3) If you have Orca you can do a lot of things not supported by VS IDE. By manually editing the msi package, you can embed each image as a binary stream, and you can set the dialog properties to display the image in the particular dialog by loading it from the msi itself rather than fropm a disk. This is not exactly hard to do, but it is not trivial either.

Depends on how much effort you want to put into the problem.

Robert

Brian Van Beek8-Jun-05 4:15

Brian Van Beek

8-Jun-05 4:15

Please don't do number 1. There is nothing I hate more than installers that leave temp stuff used only during installation on my computer when they finish. Therefore, I'm glad to hear that you are looking for a solution to get rid of them.

Brian Van Beek
My Blog is Awesome, ok maybe not, but is still fun!!

Rizwan Bashir8-Jun-05 22:32

Rizwan Bashir

8-Jun-05 22:32

Thanks for the solutions. I am going for solution 2 and 3 to test both. as far the point 3 is concerned I have seen your article as well. good job. I found the URL for orca over there but it says that page has been moved and then they moved me to page
http://www.microsoft.com/downloads/details.aspx?FamilyId=A55B6B43-E24F-4EA3-A93E-40C0EC4F68E5&displaylang=en[^]

which doesnt look orca. I have searched at google and it took me to same place. Can you just check and confirm the url so that I can download the right thing.

thanks alot for the support

rwestgraham9-Jun-05 0:08

9-Jun-05 0:08

Yes, it is the correct link. They call oit the Platform SDK, but it includes the Windows Installer SDK. Let me know if you have problems once you start working with Orca.

Robert