[C#] MySQl database problems

Hello everyone,

I've a problem with a MySQL database and filling the dataset, the database is running local on XAMPP.

this is my Class where I set the properties.

Code:

namespace SQLDatabaseApp
{
    class DBSettings
    {
        public void BasicSettings(DataGridView Grid)
        {
            string strConnectionstring = "Data Source=localhost;" + "Initial Catalog=reisbureau;" + "username=root;password=''";
            string strCommandtext = "SELECT * FROM klanten";

            MySqlConnection Connection = new MySqlConnection(strConnectionstring);
            MySqlCommand Command = new MySqlCommand(strCommandtext);
            MySqlDataAdapter Adapter = new MySqlDataAdapter();
            DataSet ds = new DataSet();

            Connection.Open();
            Adapter.SelectCommand = Command;
            Adapter.Fill(ds);

        }


    }
}

this is my Form.cs Code

Code:

namespace SQLDatabaseApp
{
    public partial class Form1 : Form
    {
        DBSettings settings = new DBSettings();
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            settings.BasicSettings(dgvViewDatabase);
        }
    }
}

If i try to run this code is selects the line: "Adapter.Fill(ds);" and report the following error

Fill: SelectCommand.Connection property has not been initialized.


Does somebody knows what I am doing wrong?

thank you for your support.

Greetings

Jelte.

"SelectCommand.Connection property has not been initialized."

that should tell you everything you need to know.
either set the connection property of your command to the sqlconnection object, or use CreateCommand() from the sqlconnection object.

Are you using the MyODBC interface to connect? If so, can I assume you have it set up correctly? If not did you RTFM?

No, i use the MySQL .net Connector.

Originally Posted by bling

"SelectCommand.Connection property has not been initialized."

that should tell you everything you need to know.
either set the connection property of your command to the sqlconnection object, or use CreateCommand() from the sqlconnection object.

QFT

You failed to supply the second argument to your commands contructor call.

Oke I think I fixed the initialization problem. but if I run the program, no errors or something else shows up, only the Datagridview stays empty. XAMPP is runing and there is no firewall or something like it that blocks the program.

this is my code:

Code:

namespace DBSQLApp
{
    class DBSettings
    {
        public void BasicSettings(DataGridView grid)
        {
            string strConnectionstring = "Data Source=localhost;" + "Initial Catalog=reisbureau;" + "username=root;password=''";
            string strCommandtext = "SELECT * FROM klanten";

            
            MySqlConnection Connection = new MySqlConnection(strConnectionstring);
            MySqlCommand Command = new MySqlCommand(strCommandtext,Connection);
            MySqlDataAdapter Adapter = new MySqlDataAdapter();
            DataSet ds = new DataSet();

            Connection.Open();
            Adapter.SelectCommand = Command;
            Adapter.Fill(ds,"klanten");

            grid.DataSource = ds;
        }

Form.cs Code:

Code:

namespace DBSQLApp
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        DBSettings settings = new DBSettings();

        public void Form1_Load(object sender, EventArgs e)
        {
            settings.BasicSettings(Gridview);
        }
    }
}

everyone Thank you for your Help.

Greetings

Jelte.

Edit:
Thanks for all your help people, I fixed the problem:

the Solution was.

Grid.Datasource = ds.Tables[0];