C#

Imports System<br />
Imports System.Data<br />
Imports System.Data.SqlClient<br />
Imports AddressBook.usermod1<br />
<br />
Public Class clsDataAccess<br />
<br />
    Public objConnection As SqlConnection<br />
    Public objTransaction As SqlTransaction<br />
<br />
    Public Function SqlConnect() As Boolean<br />
<br />
        Try<br />
            objConnection = New SqlConnection<br />
            'objConnection.ConnectionString = "Server=(local);database=AddressBook;user id=sa;password=;"<br />
            objConnection.ConnectionString = "Server=" & GetServer("\conn.cfg") & "; DataBase=" & GetDatabase("\conn.cfg") & "; User ID =" & GetUser("\conn.cfg") & "; Integrated Security=false"<br />
<br />
            If objConnection.State = ConnectionState.Closed Then _<br />
                objConnection.Open()<br />
<br />
            Return True<br />
<br />
        Catch ex As Exception<br />
<br />
            MsgBox("Failed to connect to data source.", MsgBoxStyle.Information, "")<br />
            Return False<br />
<br />
        Finally<br />
            objConnection.Close()<br />
<br />
        End Try<br />
<br />
    End Function<br />
<br />
    Public Function ExecuteQuery(ByVal strSQL As String) As DataTable<br />
        Dim objDataTable As DataTable<br />
        Dim objDataAdapter As SqlDataAdapter<br />
<br />
        Try<br />
<br />
            SqlConnect()<br />
            objDataAdapter = New SqlDataAdapter<br />
<br />
            With objDataAdapter<br />
<br />
                objDataTable = New DataTable<br />
                .SelectCommand() = New SqlCommand(strSQL, objConnection, objTransaction)<br />
                .Fill(objDataTable)<br />
<br />
                Return objDataTable<br />
<br />
            End With<br />
<br />
        Catch sqlex As Exception<br />
            Throw sqlex<br />
<br />
        Catch ex As Runtime.InteropServices.COMException<br />
            Throw ex<br />
        Finally<br />
            objDataAdapter = Nothing<br />
<br />
        End Try<br />
    End Function<br />
<br />
    Public Sub ExecuteNonQuery(ByVal strSQL As String)<br />
        Dim objSqlCommand As SqlCommand<br />
<br />
        Try<br />
            SqlConnect()<br />
            objSqlCommand = New SqlCommand(strSQL, objConnection)<br />
            objSqlCommand.Connection.Open()<br />
            objSqlCommand.ExecuteNonQuery()<br />
<br />
        Catch ex As SqlException<br />
            Throw ex<br />
<br />
        Catch ex As Runtime.InteropServices.COMException<br />
            Throw ex<br />
<br />
        Finally<br />
            objSqlCommand = Nothing<br />
<br />
        End Try<br />
    End Sub<br />
<br />
    Public Function ExecuteNonQuery(ByVal strSQL As String, ByVal sqlparams As SqlParameter()) As Boolean<br />
<br />
        Try<br />
            Dim intindex As Integer<br />
            Dim objsqlcommand As New SqlCommand(strSQL, objConnection, objTransaction)<br />
<br />
            For intindex = 0 To UBound(sqlparams)<br />
                objsqlcommand.Parameters.Add(sqlparams(intindex))<br />
            Next<br />
<br />
            objsqlcommand.ExecuteNonQuery()<br />
            Return True<br />
<br />
        Catch ex As Exception<br />
<br />
            Throw ex<br />
<br />
        End Try<br />
    End Function<br />
End Class

Don't block the drive way of all the newbies in programming.

[Serializable]
    public class IndexedBaseDataCollection : Dictionary<int, IBaseDataContainer>, IBaseDataContainer
    {
        public IndexedBaseDataCollection()
        {
        }
        .
        .
        // some more methods here
    }

<br />
System.Runtime.Serialization.SerializationException: The constructor to deserialize an object of type 'Engineer.Data.IndexedBaseDataCollection' was not found. ---> System.Runtime.Serialization.SerializationException: The constructor to deserialize an object of type 'Engineer.Data.IndexedBaseDataCollection' was not found.<br />
   at System.Runtime.Serialization.ObjectManager.GetConstructor(Type t, Type[] ctorParams)<br />
   at System.Runtime.Serialization.ObjectManager.CompleteISerializableObject(Object obj, SerializationInfo info, StreamingContext context)