How Do I Avoid Code Duplication in Overloaded Functions?

[gkinu]

I want to write an overloaded function. Each overload will take as parameter one of different command objects like MySqlCommand, SqlCommand, OledbCommand etc and different DataAdapters. The function has many lines of code and the command object passed as a parameter will be referenced many times in the code. However, most lines of code do not reference the passed parameter value. My question is, do i have to repeat the whole function (duplicate same code) for all the overloads? I feel there could be a better way of doing this for easy code maintenance .

Illustration: -

private void xx (MySqlCommand c, MySqlDataAdapter a)
{
   c.CommandText = "statement1";
   c.ExecuteNonQuery();
   c.CommandText = "select * from sometable";
   a.SelectCommand=c;
   DataSet d = new DataSet();
   a.Fill(d,"Table1");
   foreach(DataRow r in d.Tables["Table1"])
   {
      int i=int.Parse(r["Table1"].ToString());
      //do something with i
      //other code some referencing c & a, others not
   }
}
 
 
private void xx (OleDbCommand c, OleDbDataAdapter a)
{
   c.CommandText = "statement1";
   c.ExecuteNonQuery();
   c.CommandText = "select * from sometable";
   a.SelectCommand=c;
   DataSet d = new DataSet();
   a.Fill(d,"Table1");
   foreach(DataRow r in d.Tables["Table1"])
   {
      int i=int.Parse(r["Table1"].ToString());
      //do something with i
      //other code some referencing c & a, others not
   }
}
 
//Other overloads with other command/dataadapter parameters

[kenobewan]

Have you tried using a class?

[gkinu]

I solved it using interfaces as illustrated below. This way, i did not need to have any overloads.

private void xx (IDbCommand c, IDbDataAdapter a)
{
   c.CommandText = "statement1";
   c.ExecuteNonQuery();
   c.CommandText = "select * from sometable";
   a.SelectCommand=c;
   DataSet d = new DataSet();
   a.Fill(d,"Table1");
   foreach(DataRow r in d.Tables["Table1"])
   {
      int i=int.Parse(r["Table1"].ToString());
      //do something with i
      //other code some referencing c & a, others not
   }
}

Thank you very much.