Can anyone help me convert the following VB script to C#
Code:Public Sub Main() Dim conn As New SqlConnection("server=(local);Integrated Security=SSPI;database=Test") AddHandler conn.InfoMessage, New SqlInfoMessageEventHandler(AddressOf OnInfoMessage) conn.Open() Dim cmd As New SqlCommand() cmd.Connection = conn cmd.CommandType = CommandType.StoredProcedure cmd.CommandText = "SPWithPrint" cmd.ExecuteNonQuery() conn.Close() Dts.TaskResult.Results.Success End Sub Private Sub OnInfoMessage(ByVal sender As Object, ByVal args As System.Data.SqlClient.SqlInfoMessageEventArgs) Dim sqlEvent As System.Data.SqlClient.SqlError For Each sqlEvent In args.Errors Dts.Events.FireInformation(sqlEvent.Number, sqlEvent.Procedure, sqlEvent.Message, "", 0, False) Next End Sub




Reply With Quote