Inherit System.Data.Common.DbDataAdapter

Question

0.00/5 (No votes)

See more:

How can I add constructor to take SQL statement and connection object or How can I add connection object for this class?

C#

public class Class3 : System.Data.Common.DbDataAdapter, IDataAdapter
    {
        #region IDataAdapter Members
        int IDataAdapter.Fill(DataSet dataSet)
        {
            return this.Fill(dataSet);
        }
        DataTable[] IDataAdapter.FillSchema(DataSet dataSet, SchemaType schemaType)
        {
            return this.FillSchema(dataSet, schemaType);
        }
        IDataParameter[] IDataAdapter.GetFillParameters()
        {
            return this.GetFillParameters();
        }
        MissingMappingAction IDataAdapter.MissingMappingAction
        {
            get
            {
                return MissingMappingAction;
            }
            set
            {
                MissingMappingAction = value;
            }
        }
        MissingSchemaAction IDataAdapter.MissingSchemaAction
        {
            get
            {
                throw new NotImplementedException();
            }
            set
            {
                throw new NotImplementedException();
            }
        }
        ITableMappingCollection IDataAdapter.TableMappings
        {
            get { return this.TableMappings; }
        }
        int IDataAdapter.Update(DataSet dataSet)
        {
            return this.Update(dataSet);
        }
        public int FillFromReader(DataTable dataTable, IDataReader dataReader)
        {
            return this.Fill(dataTable, dataReader);
        }
        #endregion
    }

Posted 30-Dec-10 15:16pm

Mostafa Elsadany

Updated 30-Dec-10 15:34pm

Venkatesh Mookkan

v2

Add a Solution

Comments

Venkatesh Mookkan 30-Dec-10 21:34pm

Always use code block option to add codes

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Venkatesh Mookkan · Accepted Answer · 2010-12-30T15:37:00

Solution 1

So simple add the below code into your class,

C#

public Class3(DbConnection connection, string sql)
            : base()
        {
            //Do your stuff

        }

Mark it as answer if it helpful

Posted 30-Dec-10 15:37pm

Venkatesh Mookkan

Updated 30-Dec-10 15:41pm

v3

Comments

Mostafa Elsadany 30-Dec-10 21:43pm

so how i can add connection to class
as

oledbDataAdapter x=new oledbDataAdapter("select * from emp",connection);
can you tell me how
i assign to my class this connection and select statement
tnx for any help

Venkatesh Mookkan 30-Dec-10 21:58pm

You know what you are confusing us.

Mostafa Elsadany 30-Dec-10 21:58pm

DbConnection connection how i can assign or pass this parameter
to any method

Ali Al Omairi(Abu AlHassan) · Accepted Answer · 2010-12-31T01:34:00

if you want to construct your own classes then try this:

public class MyConnection : DbConnection
{
public MyConnection(string connectionString):base()
{
// do any thing.
this.ConnectionString = connectionString;
}
}
public class MyCommand : DbCommand
{
public MyCommand(string sql,MyConnection connection):base()
{
// do any thing.
this.CommandText = sql;
this.Connection = connection;
}
}
public MyAdapter : DbAdapter
{
public MyAdapter(string sql, MyConnection connection):base()
{
this.SelectCommand = new MyCommand(sql, connection);
}
}