1: USE [Test]
2: GO
3: /****** Object: StoredProcedure [dbo].[MyProcedure2] Script Date: 04/04/2011 21:00:18 ******/
4: SET ANSI_NULLS ON
5: GO
6: SET QUOTED_IDENTIFIER ON
7: GO
8: ALTER proc [dbo].[MyProcedure2]
9: @UserID varchar(12),
10: @Pwd varchar(12)
11: as
12: begin
13: insert into Login values (@UserID,@Pwd )
14: end
1: Private Sub btnParNoOut_Click(ByVal sender As System.Object,ByVal e As System.EventArgs) Handles btnParNoOut.Click
2: Dim sql As String = "execute MyProcedure2 @User,@Pwd"
3: Dim cmd As SqlCommand = New SqlCommand(sql,conn)
4: Dim parameter As SqlParameter
5: parameter = New SqlParameter("@User",SqlDbType.VarChar)
6: parameter.Value = Trim(txtParameter.Text)
7: cmd.Parameters.Add(parameter)
8:
9: parameter = New SqlParameter("@Pwd",SqlDbType.VarChar)
10: parameter.Value = Trim(txtPwd.Text)
11: cmd.Parameters.Add(parameter)
12: Try
13: conn.Open()
14: If cmd.ExecuteNonQuery >= 0 Then
15: MsgBox("Success","有参数无返回值")
16: Else
17: MsgBox("Fail")
18: End If
19: Catch ex As Exception
20: MsgBox(ex.Message)
21: End Try
22: conn.Close()
23: End Sub