Mach ich ja eigentlich. hier ist der volle Code der Klasse:
 
public class MySqlCon
{
  public string cmdMySQL;
  public MySqlConnection myCon;
  public MySqlCommand myCmd;
 
  public MySqlCon()
  {
    string strCon = "Server...";
    myCon = new MySqlConnection(strCon);
    try
    { myCon.Open(); }
    catch(Exception e)
    { ... }
  }
 
  public void MySqlCmd(string cmdMySQL)
  {
    try
    {
      MySqlCommand myCmd = new MySqlCommand();
      myCmd.CommandText = cmdMySQL;
      myCmd.Connection = myCon;
    }
    catch(Exception e)
    { ... }
  }

  public DataSet GetData()
  {
    try
    {
       MySqlDataAdapter myAd = new MySqlDataAdapter(myCmd);
       myAd.SelectCommand = myCmd;
       DataSet myDs = new DataSet("data");
       myAd.Fill(myDs, "data");
       myCon.Close();
       return  myDs;
    }
    catch(Exception e)
    { ... }
    return null;
  }
}
 
Gru�,
Sven
 
 
----- Original Message -----
From: A-Schubert
Sent: Monday, July 19, 2004 11:34 AM
Subject: AW: [CSharp.net] DataSet in eigener Klasse

 MySqlDataAdapter myAd = new MySqlDataAdapter();

 

Du musst diesem Konstruktor die Connection und das Command Objekt �bergeben, sonst weiss der Adapter nicht was

er machen soll.

 

Andr�

Antwort per Email an