GridView1.DataBind(); ERROR

Kirtan:
YES... It worked. I had to get rid of something that I put in the properties.
 
Now I can work on the MSSQL ConnectionString version. I used the MySQL because it was easier to connect to. I have to do some configurations to the MSSQL server so it will allow me access it.
 

Kirtan:
 
Thanks for your help. I changed the line to what you recommended.
BUT: Should I put back in the "dataGridViewCompany.Bind();" so it populated the dataGridViewCompany?
It has an issue with the "Bind".

BTW:
 
Here is the code I have so far:
 
private void buttoTest_Click(object sender, EventArgs e)
{
try
{
MySqlConnection TestConnection = new MySqlConnection();
TestConnection.ConnectionString = "Data Source=localhost;Database= icepack;User ID=Demo;Password=Demo";
TestConnection.Open();
//
MySqlDataAdapter TestDataAdapter = new MySqlDataAdapter("SELECT * FROM Company", TestConnection);
DataSet TestDataSet = new DataSet();
//
TestDataAdapter.Fill(TestDataSet);
dataGridViewCompany.DataSource = TestDataSet;
//dataGridViewCompany.Bind(); // <<<< ERROR

MessageBox.Show("Got here...MySQL");
}
catch (SqlException SQLExecute)
{
MessageBox.Show("Can not connect to TestConnection...\r\r" + SQLExecute, "Test Connection...", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
 
 

If you are going to use MSSQL then learn it's syntax not MySql you will only be confusing yourself. People with lots of experience are trying to help you but you are not listening.

There is an enormous differences between the Sql.Data provider and the MySql Connector which is what you would need.

There are differences between MSSQL and MySql  calling conventions, so why are you learning something that you know you are not going to use! I am completely baffled.

Finaly there is a website you can go to to get ALL you connection strings for ANY database or xl or txt or jet or ole or odbc  connectionstrings.com try it .