Just post simple code. Give a feedback if it helps u :)

using System;
using System.Collection.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace WindowsApplication1
	public partial class Form1 : Form
		public Form1()
		private void cmdtam_Klik(object sender, EventArgs e)
			string cstr;
			cstr = "data source=jery;initial catalog=latihan;uid=sa;pwd=sri";
			SqlConnection con1 = new SqlConnection(cstr);
			SqlCommand com1 = new SqlCommand();
			com1.Connection = con1;
			com1.CommandType = CommandType.Text;
			com1.CommandText = "select * from customer"
			DataSet ds1 = new DataSet();
			SqlDataAdapter adp1 = new SqlDataAdapter(com1);
			grd1.DataMember = "customer";

thx majestic0110

Pl Help me for query related to update date in SQL Server2005
in C#.NET

did u help me ,i want to connect remote database(mysql) with c#.......
and update database using datagrid in c#