using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace WindowsFormsApplication1
{
public partial class gradeview查询器 : Form
{
public gradeview查询器()
{
InitializeComponent();
}
public DataTable goujian()
{
DataTable dt = new DataTable();
dt.Columns.Add("code");
dt.Columns.Add("name");
dt.Columns.Add("sex");
DataRow dr = dt.NewRow();
dr["code"] = "1001";
dr["name"] = "张三";
dr["sex"] = "男";
dt.Rows.Add(dr);
DataRow dr1 = dt.NewRow();
dr1["code"] = "1002";
dr1["name"] = "李四";
dr1["sex"] = "女";
dt.Rows.Add(dr1);
return dt;
}
private void button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(textBox1.Text);
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select *from " + textBox2.Text;
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
DataTable dt = null;
if (dr.HasRows)//如果有数据
{
dt = new DataTable();//创建datatable 用来临时存储表的数据
dt.Columns.Clear();//清空列数据
for (int i = 0; i < dr.FieldCount; i++)//行
{
dt.Columns.Add(dr.GetName(i));//获取所有列标题的集合(获取指定列的名称)
}
dt.Rows.Clear();//清空行数据
while (dr.Read())
{
DataRow dtr=dt.NewRow();//创建与该表相同构架的newrow
for (int j = 0; j < dr.FieldCount; j++)//行中的列数
{
dtr[j]=dr[j];
}
dt.Rows.Add(dtr);
}
}
dataGridView1.DataSource = dt;
conn.Close();
}
private void button2_Click(object sender, EventArgs e)
{
DataTable dt = goujian();
dataGridView1.DataSource = dt;
}
}
}