Connecting C#.Net to SQL Server 2000
-
hi, i am a vb.net user and i want to try to convert my vb.net program to C#.Net. i have a class (clsDataAccess) where i execute my query. i'd try it to convert it to C#.Net but it gives me a lot of errors. i want to use this clsDataAccess as my default class when executing my query. can you pls help me to convert it. below is my code.
Imports System Imports System.Data Imports System.Data.SqlClient Imports AddressBook.usermod1 Public Class clsDataAccess Public objConnection As SqlConnection Public objTransaction As SqlTransaction Public Function SqlConnect() As Boolean Try objConnection = New SqlConnection 'objConnection.ConnectionString = "Server=(local);database=AddressBook;user id=sa;password=;" objConnection.ConnectionString = "Server=" & GetServer("\conn.cfg") & "; DataBase=" & GetDatabase("\conn.cfg") & "; User ID =" & GetUser("\conn.cfg") & "; Integrated Security=false" If objConnection.State = ConnectionState.Closed Then _ objConnection.Open() Return True Catch ex As Exception MsgBox("Failed to connect to data source.", MsgBoxStyle.Information, "") Return False Finally objConnection.Close() End Try End Function Public Function ExecuteQuery(ByVal strSQL As String) As DataTable Dim objDataTable As DataTable Dim objDataAdapter As SqlDataAdapter Try SqlConnect() objDataAdapter = New SqlDataAdapter With objDataAdapter objDataTable = New DataTable .SelectCommand() = New SqlCommand(strSQL, objConnection, objTransaction) .Fill(objDataTable) Return objDataTable End With Catch sqlex As Exception Throw sqlex Catch ex As Runtime.InteropServices.COMException Throw ex Finally objDataAdapter = Nothing End Try End Function Public Sub ExecuteNonQuery(ByVal strSQL As String) Dim objSqlCommand As SqlCommand Try SqlConnect() objSqlCommand = New SqlCommand(strSQL, objConnection) objSqlCommand.Connection.Open() objSqlCommand.ExecuteNonQuery() Catch ex As SqlException Throw ex Catch ex As Runtime.InteropServices.COMException Throw ex Fina -
hi, i am a vb.net user and i want to try to convert my vb.net program to C#.Net. i have a class (clsDataAccess) where i execute my query. i'd try it to convert it to C#.Net but it gives me a lot of errors. i want to use this clsDataAccess as my default class when executing my query. can you pls help me to convert it. below is my code.
Imports System Imports System.Data Imports System.Data.SqlClient Imports AddressBook.usermod1 Public Class clsDataAccess Public objConnection As SqlConnection Public objTransaction As SqlTransaction Public Function SqlConnect() As Boolean Try objConnection = New SqlConnection 'objConnection.ConnectionString = "Server=(local);database=AddressBook;user id=sa;password=;" objConnection.ConnectionString = "Server=" & GetServer("\conn.cfg") & "; DataBase=" & GetDatabase("\conn.cfg") & "; User ID =" & GetUser("\conn.cfg") & "; Integrated Security=false" If objConnection.State = ConnectionState.Closed Then _ objConnection.Open() Return True Catch ex As Exception MsgBox("Failed to connect to data source.", MsgBoxStyle.Information, "") Return False Finally objConnection.Close() End Try End Function Public Function ExecuteQuery(ByVal strSQL As String) As DataTable Dim objDataTable As DataTable Dim objDataAdapter As SqlDataAdapter Try SqlConnect() objDataAdapter = New SqlDataAdapter With objDataAdapter objDataTable = New DataTable .SelectCommand() = New SqlCommand(strSQL, objConnection, objTransaction) .Fill(objDataTable) Return objDataTable End With Catch sqlex As Exception Throw sqlex Catch ex As Runtime.InteropServices.COMException Throw ex Finally objDataAdapter = Nothing End Try End Function Public Sub ExecuteNonQuery(ByVal strSQL As String) Dim objSqlCommand As SqlCommand Try SqlConnect() objSqlCommand = New SqlCommand(strSQL, objConnection) objSqlCommand.Connection.Open() objSqlCommand.ExecuteNonQuery() Catch ex As SqlException Throw ex Catch ex As Runtime.InteropServices.COMException Throw ex Fina -
hi, i am a vb.net user and i want to try to convert my vb.net program to C#.Net. i have a class (clsDataAccess) where i execute my query. i'd try it to convert it to C#.Net but it gives me a lot of errors. i want to use this clsDataAccess as my default class when executing my query. can you pls help me to convert it. below is my code.
Imports System Imports System.Data Imports System.Data.SqlClient Imports AddressBook.usermod1 Public Class clsDataAccess Public objConnection As SqlConnection Public objTransaction As SqlTransaction Public Function SqlConnect() As Boolean Try objConnection = New SqlConnection 'objConnection.ConnectionString = "Server=(local);database=AddressBook;user id=sa;password=;" objConnection.ConnectionString = "Server=" & GetServer("\conn.cfg") & "; DataBase=" & GetDatabase("\conn.cfg") & "; User ID =" & GetUser("\conn.cfg") & "; Integrated Security=false" If objConnection.State = ConnectionState.Closed Then _ objConnection.Open() Return True Catch ex As Exception MsgBox("Failed to connect to data source.", MsgBoxStyle.Information, "") Return False Finally objConnection.Close() End Try End Function Public Function ExecuteQuery(ByVal strSQL As String) As DataTable Dim objDataTable As DataTable Dim objDataAdapter As SqlDataAdapter Try SqlConnect() objDataAdapter = New SqlDataAdapter With objDataAdapter objDataTable = New DataTable .SelectCommand() = New SqlCommand(strSQL, objConnection, objTransaction) .Fill(objDataTable) Return objDataTable End With Catch sqlex As Exception Throw sqlex Catch ex As Runtime.InteropServices.COMException Throw ex Finally objDataAdapter = Nothing End Try End Function Public Sub ExecuteNonQuery(ByVal strSQL As String) Dim objSqlCommand As SqlCommand Try SqlConnect() objSqlCommand = New SqlCommand(strSQL, objConnection) objSqlCommand.Connection.Open() objSqlCommand.ExecuteNonQuery() Catch ex As SqlException Throw ex Catch ex As Runtime.InteropServices.COMException Throw ex Fina