0 Replies - 681 Views - Last Post: 30 November 2009 - 11:10 PM Rate Topic: -----

#1 ho-ho  Icon User is offline

  • D.I.C Head

Reputation: 5
  • View blog
  • Posts: 69
  • Joined: 04-May 09

how to connect to mysql using oledb in c#

Post icon  Posted 30 November 2009 - 11:10 PM

I am trying to create an app. in which the data from dataGridView1 is stored or displayed in mysql. I am trying to establish connection to mysql using oledb.I want to transfer all the data from dataGridView1 to mysql database. How can I do that?(mysql is on a remote computer, I have IP address)
Thanks
dataGridView1.Columns[0].Name = "Title";
				dataGridView1.Columns[1].Name = "Date";
				dataGridView1.Columns[2].Name = "Description";

				int lastrow;

				dataGridView1.Rows.Add();
				lastrow = dataGridView1.Rows.Count - 2;
				dataGridView1.Rows[lastrow].Cells[0].Value = rowNews.SubItems[0].Text;
				dataGridView1.Rows[lastrow].Cells[1].Value = rowNews1.SubItems[0].Text;
				dataGridView1.Rows[lastrow].Cells[2].Value = rowNews2.SubItems[0].Text;




Is This A Good Question/Topic? 0
  • +

Page 1 of 1