Hi,
connect database SQL2000
Cshap Code:
private void Form2_Load(object sender, EventArgs e) { string connString = "server=HONGQUAN;database=test;Integrated Security=SSPI"; string sql = @"select * from common"; SqlConnection conn = new SqlConnection(connString); try { SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = new SqlCommand(sql, conn); DataSet ds = new DataSet(); da.Fill(ds, "common"); dt = ds.Tables["common"]; i = dt.Rows.Count; dataGrid1.DataSource = dt; } catch (Exception ex) { MessageBox.Show(ex.Message); } }