Skip to main content

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()
    {
        cmd.Connection.Close();
    }
    #endregion
    #region "Constructor Class"
    public DataObject(bool IsProcedure)
    {
        //Dim objConnectionStringSettings As SqlConnectionStringBuilder = My.Settings.PosImsConnectionString.ToString("connectionString")
        //strConnectionString = objConnectionStringSettings.ConnectionString
        SqlConnection cnn = new SqlConnection();
        //cnn.ConnectionString = My.Settings.IMSConnectionString.ToString();
        cnn.ConnectionString = ConfigurationManager.ConnectionStrings["agrivestdbConnectionString"].ConnectionString;
        //MsgBox(cnn.ConnectionString)
        cmd.Connection = cnn;
        if (IsProcedure) {
            cmd.CommandType = CommandType.StoredProcedure;
        } else {
            cmd.CommandType = CommandType.Text;
        }
    }
    #endregion
    #region  "Execute Scalar"
    public object ExecuteScalar()
    {
        object obj = null;
        try {
            this.Open();
            obj = cmd.ExecuteScalar();
            this.Close();
        } catch (Exception ex) {
            if (handleErrors) {
                strLastError = ex.Message;
            } else {
                throw;
            }
        }
        return obj;
    }
    #endregion
    #region "Execute Scalar Command TEXT"
    public object ExecuteScalar(string commandtext)
    {
        object obj=null;
        try {
            //this.Open();
            cmd.CommandText = commandtext;
            obj = this.ExecuteScalar();
           // this.Close();
        } catch (Exception ex) {
            if ((handleErrors)) {
                strLastError = ex.Message;
            } else {
                throw;
            }
        }
        return obj;
    }
    #endregion
    #region "Execute Dataset"
    public DataSet ExecuteDataSet()
    {
        SqlDataAdapter da = null;
        DataSet ds = null;
        try {
            da = new SqlDataAdapter();
            da.SelectCommand = (SqlCommand)cmd;
            ds = new DataSet();
            da.Fill(ds, "tab1");
        } catch (Exception ex) {
            if ((handleErrors)) {
                strLastError = ex.Message;
            } else {
                throw;
            }
        }
        return ds;
    }
    #endregion
    #region "Execute Dataset Command TEXT"
    public DataSet ExecuteDataSet(string commandtext)
    {
        DataSet ds = null;
        try {
            cmd.CommandText = commandtext;
            ds = this.ExecuteDataSet();
        } catch (Exception ex) {
            if (handleErrors) {
                strLastError = ex.Message;
            } else {
                throw;
            }
        }
        return ds;
    }
    #endregion
    #region "Sql Parameters"
    public IDataParameterCollection Parameters {
        get { return cmd.Parameters; }
    }
    #endregion
    #region "Add Sql Parameter"
    public void AddParameter(string paramname, object paramvalue)
    {
        SqlParameter param = new SqlParameter(paramname, paramvalue);
        cmd.Parameters.Add(param);
    }
    #endregion
    #region "Add Sql Parameter param "
    public void AddParameter(IDataParameter param)
    {
        cmd.Parameters.Add(param);
    }
    #endregion
    #region "Execute Nonquery"
    public int ExecuteNonQuery()
    {
        int i = -1;
        try {
            this.Open();
            i = cmd.ExecuteNonQuery();
            this.Close();
        } catch (Exception ex) {
            if (handleErrors) {
                strLastError = ex.Message;
            } else {
                throw;
            }
        }
        return i;
    }
    #endregion
    #region "ExecutenonQuery Command Text"
    public int ExecuteNonQuery(string commandtext)
    {
        int i = -1;
        try {
            cmd.CommandText = commandtext;
            i = this.ExecuteNonQuery();
        } catch (Exception ex) {
            if (handleErrors) {
                strLastError = ex.Message;
            } else {
                throw;
            }
        }
        return i;
    }
    #endregion
}

Comments

  1. Date Object is easy way to manuplating the datebase...

    ReplyDelete

Post a Comment

Popular posts from this blog

Authentication ASP.NET_SessionId (Session) along with AuthToken (GUID) cookie

Authentication ASP.NET_SessionID (Session) along with AuthToken (GUID) cookie Introduction ASP.NET Session keeps track of the user by creating a cookie called  ASP.NET_SessionId  in the user browser. This cookie value is checked for every request to ensure that the data being served is specific to that user. In many applications, a Session variable is used to track the logged in user, i.e., if a session variable exists for that user, then the user is logged in, otherwise not. Background Whenever any data is saved into the Session, the  ASP.NET_SessionId  cookie is created in the user’s browser. Even if the user has logged out (means the Session data has been removed by calling the  Session.Abandon() or  Session.RemoveAll()  or  Session.Clear()  method), this  ASP.NET_SessionId  cookie and its value is not deleted from the user browser. This legitimate cookie value can be used by the hijacker to hijack the user session by g...

PNR Status by web Scraping Method (ASP.NET) C#

To Get the PNR Status by web Scraping Method Steps to Execute the Function Step 1 : Add the below method in your Form and Pass the PNR Number arguement public string GetPNRStatus( string sPNR) { string URI = "http://www.indianrail.gov.in/cgi_bin/inet_pnrstat_cgi.cgi" ; string Parameters = Uri .EscapeUriString( "lccp_pnrno1=" +sPNR+ "&submitpnr=Get Status" ); System.Net. HttpWebRequest req = ( HttpWebRequest )System.Net. WebRequest .Create(URI); //HTTP POST Headers req.ContentType = "application/x-www-form-urlencoded" ; req.Host = "www.indianrail.gov.in" ; //You can use your own user-agent. req.UserAgent = "Mozilla/5.0 (compatible; MSIE 7.0; Windows Phone OS 7.5; Trident/5.0; IEMobile/9.0) DELL;Venue Pro" ; req.Headers.Add( HttpRequestHeader .AcceptLanguage, "en-us,en;q=0.5" ); req.Headers.Add( HttpRequestHeader .AcceptCharset, "ISO-8859-1,utf-8;q=...
C# HttpClient tutorial C# HttpClient tutorial shows how to create HTTP requests with HttpClient in C#. In the examples, we create simple GET and POST requests. The Hypertext Transfer Protocol (HTTP) is an application protocol for distributed, collaborative, hypermedia information systems. HTTP is the foundation of data communication for the World Wide Web. HttpClient  is a base class for sending HTTP requests and receiving HTTP responses from a resource identified by a URI. C# HttpClient status code HTTP response status codes indicate whether a specific HTTP request has been successfully completed. Responses are grouped in five classes: Informational responses (100–199) Successful responses (200–299) Redirects (300–399) Client errors (400–499) Server errors (500–599) Program.cs using System; using System.Net.Http; using System.Threading.Tasks; namespace HttpClientStatus { class Program { static async Task Main(string[] args) { using var client =...