Imports System Imports System.Data Imports System.Data.SqlClient
Namespace E Public Class Program Private Shared Sub Disp(sender As Object, evtargs As SqlInfoMessageEventArgs) For Each err As SqlError In evtargs.Errors Console.WriteLine("Message: " & err.Message) Next End Sub Public Shared Sub Main(args As String()) Using con As New SqlConnection("Server=ARNEPC3\SQLEXPRESS2008;Integrated Security=true;Database=Test") con.Open() Dim cmd As New SqlCommand() cmd.CommandText = "sp_dbcmptlevel" cmd.CommandType = CommandType.StoredProcedure cmd.Connection = con Dim p As New SqlParameter() p.ParameterName = "@dbname" p.DbType = DbType.[String] p.Size = 128 p.Direction = ParameterDirection.Input p.Value = "Test" cmd.Parameters.Add(p) AddHandler con.InfoMessage, AddressOf Disp Dim rdr As SqlDataReader = cmd.ExecuteReader() While rdr.Read() Console.WriteLine("result set: " & Convert.ToString(rdr(0))) End While rdr.Close() End Using Console.ReadKey() End Sub End Class End Namespace
Jeg er rimeligt ny i VB.NET, så jeg skal have lidt mere hjælp. Her er dine sub's (med en ændring i Disp), og en button_1.click - hvordan skal det kobles sammen så jeg kører det når jeg klikke på knappen?
'Button1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
End Sub
Private Shared Sub Disp(ByVal sender As Object, ByVal evtargs As SqlInfoMessageEventArgs) For Each err As SqlError In evtargs.Errors MessageBox.Show("Message: " & err.Message) 'Console.WriteLine("Message: " & err.Message) Next End Sub
Public Shared Sub Main(ByVal args As String()) Using con As New SqlConnection("Server=.\SQL2008;Integrated Security=true;Database=taclogdata") con.Open() Dim cmd As New SqlCommand() cmd.CommandText = "sp_dbcmptlevel" cmd.CommandType = CommandType.StoredProcedure cmd.Connection = con Dim p As New SqlParameter() p.ParameterName = "@dbname" p.DbType = DbType.[String] p.Size = 128 p.Direction = ParameterDirection.Input p.Value = "Test" cmd.Parameters.Add(p) AddHandler con.InfoMessage, AddressOf Disp Dim rdr As SqlDataReader = cmd.ExecuteReader() While rdr.Read() Console.WriteLine("result set: " & Convert.ToString(rdr(0))) End While rdr.Close() End Using Console.ReadKey() End Sub
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.