Click here to Skip to main content
16,015,072 members
Home / Discussions / Visual Basic
   

Visual Basic

 
Generallabel autosize Pin
soumyadev_kar8-Jun-05 7:09
soumyadev_kar8-Jun-05 7:09 
GeneralRe: label autosize Pin
Mitch F.8-Jun-05 17:05
Mitch F.8-Jun-05 17:05 
GeneralWrapping Row Headers in Listview Pin
Member 20299148-Jun-05 6:51
Member 20299148-Jun-05 6:51 
QuestionHow to solve this? Thanks. Pin
shapper8-Jun-05 3:46
shapper8-Jun-05 3:46 
AnswerRe: How to solve this? Thanks. Pin
Dave Kreskowiak8-Jun-05 6:01
mveDave Kreskowiak8-Jun-05 6:01 
GeneralThread was being aborted Pin
macca248-Jun-05 3:30
macca248-Jun-05 3:30 
GeneralRe: Thread was being aborted Pin
Dave Kreskowiak8-Jun-05 6:00
mveDave Kreskowiak8-Jun-05 6:00 
GeneralCast from type 'DBNull' to type 'Integer' is not valid. Pin
msogun8-Jun-05 3:07
msogun8-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
GeneralRe: Cast from type 'DBNull' to type 'Integer' is not valid. Pin
Dave Kreskowiak8-Jun-05 5:57
mveDave Kreskowiak8-Jun-05 5:57 
GeneralRe: Cast from type 'DBNull' to type 'Integer' is not valid. Pin
rwestgraham8-Jun-05 11:43
rwestgraham8-Jun-05 11:43 
GeneralPlease help regarding NGen Pin
prashant79_pawar8-Jun-05 3:00
prashant79_pawar8-Jun-05 3:00 
GeneralRe: Please help regarding NGen Pin
Dave Kreskowiak8-Jun-05 5:52
mveDave Kreskowiak8-Jun-05 5:52 
GeneralRe: Please help regarding NGen Pin
Dave Kreskowiak9-Jun-05 2:50
mveDave Kreskowiak9-Jun-05 2:50 
GeneralUrgent - Cant Lock Application Pin
kakomalis8-Jun-05 2:32
kakomalis8-Jun-05 2:32 
GeneralRe: Urgent - Cant Lock Application Pin
Dave Kreskowiak8-Jun-05 5:50
mveDave Kreskowiak8-Jun-05 5:50 
GeneralMapi controls Pin
smita_roy8-Jun-05 2:29
smita_roy8-Jun-05 2:29 
GeneralRe: Mapi controls Pin
Dave Kreskowiak8-Jun-05 5:39
mveDave Kreskowiak8-Jun-05 5:39 
Generalsp with temptables doesnt work in crystal reports Pin
7-Jun-05 23:40
suss7-Jun-05 23:40 
Generalremoving temporary files after setup Pin
7-Jun-05 23:27
suss7-Jun-05 23:27 
GeneralRe: removing temporary files after setup Pin
rwestgraham8-Jun-05 1:49
rwestgraham8-Jun-05 1:49 
GeneralRe: removing temporary files after setup Pin
Rizwan Bashir8-Jun-05 2:05
Rizwan Bashir8-Jun-05 2:05 
GeneralRe: removing temporary files after setup Pin
rwestgraham8-Jun-05 2:35
rwestgraham8-Jun-05 2:35 
GeneralRe: removing temporary files after setup Pin
Brian Van Beek8-Jun-05 4:15
Brian Van Beek8-Jun-05 4:15 
GeneralRe: removing temporary files after setup Pin
Rizwan Bashir8-Jun-05 22:32
Rizwan Bashir8-Jun-05 22:32 
GeneralRe: removing temporary files after setup Pin
rwestgraham9-Jun-05 0:08
rwestgraham9-Jun-05 0:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.