using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient;namespace WinTest { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { using (SqlConnection myCon = new SqlConnection("你的连接字符串")) { SqlDataAdapter myDa = new SqlDataAdapter("你的查询SQL语句", myCon); DataSet myDs = new DataSet(); myDa.Fill(myDs, "temTable"); DataGridView1.DataSource = myDs.Tables[0]; } } } }
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;namespace WinTest
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
} private void Form1_Load(object sender, EventArgs e)
{
using (SqlConnection myCon = new SqlConnection("你的连接字符串"))
{
SqlDataAdapter myDa = new SqlDataAdapter("你的查询SQL语句", myCon);
DataSet myDs = new DataSet();
myDa.Fill(myDs, "temTable");
DataGridView1.DataSource = myDs.Tables[0];
}
}
}
}
DataTable dt=New DataTable();
dt.Columns.add("名称",Typeof(string));
...............................
dt.Rows["名称"]="名称";