Connection.Connection C# (CSharp) Method

Connection() public method

public Connection ( ConnectionPool pool, string connectionString )
pool ConnectionPool
connectionString string
        public Connection(ConnectionPool pool, string connectionString) {
            this.pool = pool;
            //this.connectionString = connectionString; // I moved it because I could.
            this.pool.Register(this);
            this.connectionString = connectionString;
            this.Init();        
        }
        private void Init() { //blah }

Usage Example

Example #1
0
    public void FetchRecordPending()
    {
        EnableControls();
        string     SqlPass = null;
        SqlCommand Cmd     = new SqlCommand();

        SqlPass         = "******";
        Cmd             = new SqlCommand(SqlPass, obj.Connection());
        Cmd.CommandType = CommandType.StoredProcedure;
        Cmd.Parameters.Add("@EmployeeCode", SqlDbType.VarChar, 10).Value = Session["EmpCode"];
        Cmd.Parameters.Add("@Param", SqlDbType.VarChar, 20).Value        = DrpLvStatus.SelectedItem.Text;
        SqlDataAdapter Da = new SqlDataAdapter(Cmd);
        DataSet        ds = new DataSet();

        Da.Fill(ds);

        if (ds.Tables.Count == 0)
        {
            GridExtTask.DataSource = null;
            GridExtTask.DataBind();
            string script = "alert('No Record Found');";
            ScriptManager.RegisterStartupScript(this, this.GetType(), "ServerControlScript", script, true);
            return;
        }
        else
        {
            GridExtTask.DataSource = ds.Tables[0];
            GridExtTask.DataBind();
        }
    }
All Usage Examples Of Connection::Connection