RepeatHost Business Hosting

ObjectDataSource TypeName with Constructor Parameters

Say you have a class for something like a Data Access Layer but the default constructor of the class has a required parameter. For instance, something like this:

public class MyDataClass
{
    public MyDataClass(string sConnectionString)
    {
        // default constructor contains a parameter
        // so we need to handle this for the ObjectDataSource.
    }
 
    public int SelectCount()
    {
        // get count for pagination
        return 1;
    }
 
    public DataTable SelectAll(string sortType, int startRowIndex, int maximumRows)
    {
        // get data from data source and return as DataTable.
        return new DataTable();
    }
}

By default, the ObjectDataSource requires a parameterless default constructor on the TypeName class to instantiate. To solve this problem, you need to implement the OnObjectCreating event for the ObjectDataSource. Here is an example of how you might set up your ObjectDataSource in the HTML source view:

<asp:ObjectDataSource ID="ods1" runat="server" 
    EnablePaging="true" 
    OnObjectCreating="ods1_ObjectCreating"
    SelectCountMethod="SelectCount"
    SelectMethod="SelectAll" 
    TypeName="MyDataClass">
</asp:ObjectDataSource>

Then implement the OnObjectCreating event to set the TypeName object to an instance using the constructor:

protected void ods1_ObjectCreating(object sender, ObjectDataSourceEventArgs e)
{
    string sConnectionString = "Put a connection string here";
    MyDataClass myDataClass = new MyDataClass(sConnectionString);
    // set ods object
    e.ObjectInstance = myDataClass;
}

The list of valid C-Types

Submitted by Anonymous on Mon, 06/28/2010 - 13:12.

The list of valid C-Types defined in the ODBC specification is the same for all ODBC drivers exams preparation. Typically, data store manufacturers create new data types for new scenarios or new customer needs 000-330 exam. Applications usually use the generic C-type SQL_C_BINARY to work with these new data-source specific types 000-331 exam. ODBC 3.80 allows driver manufacturers to define their own C-Types. This means that a driver can define its own client-side type conversion rule for its new driver-specific data type, and thus provide a better developer experience.
iphone blog Saudi Arabia healthy diet