Skip to main content

Posts

Showing posts with the label DataObject

Data Object for DataBase (VB)

VB: Data Object for DataBase Imports Microsoft.VisualBasic Imports MySql.Data.MySqlClient Imports System.Data Public Module MySqlDbConnCls     Public Function getConnection() As MySqlConnection         Dim MySqlConnStr As String = ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString         Return New MySqlConnection(MySqlConnStr)     End Function     Public Function Exec_MySql_Query(ByVal query As String) As DataSet         Try             Dim con As MySqlConnection = getConnection()             con.Open()             Dim da As New MySqlDataAdapter(query, con)             Dim ds As...

Data Object (C#)

Easy way to Manipulating the Database Using the Following DataObject Class File   C#: Data Object  using Microsoft.VisualBasic; using System; using System.Collections; using System.Collections.Generic; using System.Data; using System.Diagnostics; using System.Data.SqlClient; using System.Configuration; public class DataObject {     #region "Global Declaration Values"     private IDbCommand cmd = new SqlCommand();     private string strConnectionString = "";     private bool handleErrors = false;     private string strLastError = "";     #endregion     #region "Open Connection"     private void Open()     {         cmd.Connection.Open();     }     #endregion     #region Close Connection"     private void Close()   ...