datagridview数据邦定的问题 现在数据库里有两个字段 tname和tage.请问如何帮这两个字段与datagridview中的两列邦定,我现在邦定后什么都不出现,不邦定直接通过sql可以查询出来.请问怎么设置数据库列字段的邦定和显示. 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 try: SqlConnection conn = new SqlConnection("server=(local);database=yourtable;Integrated Security=SSPI"); conn.Open(); SqlCommand cmd = new SqlCommand("select tname,tage from yourtable", conn); SqlDataReader dr = cmd.ExecuteReader(); this.GridView1.DataSource=dr; this.DataView1.DataBind();或者直接简单绑定也可以的 直接拖拽绑定》》》》 for example:private void Form1_Load(object sender, EventArgs e) { DataBind(); } private void DataBind() { //初始化DataGridView DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn(); column.Name = "sno"; column.HeaderText = "学号"; //设置绑定数据源的sno字段 column.DataPropertyName = "sno"; this.dataGridView1.Columns.Add(column); column = new DataGridViewTextBoxColumn(); column.Name = "sname"; column.HeaderText = "姓名"; //设置绑定数据源的sname字段 column.DataPropertyName = "sname"; this.dataGridView1.Columns.Add(column); column = new DataGridViewTextBoxColumn(); column.Name = "sage"; column.HeaderText = "年龄"; //设置绑定数据源的"sage"字段 column.DataPropertyName = "sage"; this.dataGridView1.Columns.Add(column); //设置不自动产生列 this.dataGridView1.AutoGenerateColumns = false; this.dataGridView1.AllowUserToAddRows = false; //以下进行数据绑定 SqlConnection con = new SqlConnection("server=.;database=student;uid=sa;pwd=0421"); SqlDataAdapter sda = new SqlDataAdapter("select * from studentDetails", con); DataSet ds = new DataSet(); sda.Fill(ds, "student"); this.dataGridView1.DataSource = ds.Tables["student"]; } 查看乱码的源码 如何重写textbox的边框颜色 C#引用C++编写的DLL的问题 局域网内机器之间如何共享数据 我想实现的效果:地图上点击一个省,该省背景突出显示!!!!! 怎样把十六进制内容写入文件? 怎么调试这个文件还是错的呢? 这个问题怎么解决呀user control question???????? 请教:C#如何运行其它程序? 怎样实现word中的标尺功能 新手:C#中如何使用Sleep()和AfxMessageBox()或者类似功能的函数,先谢了,测试成功马上结贴 本人做开发时间太长,得了干眼症(测试〈3,正常为10),现有一家公司要我去做实施,我看电脑时间不能太长
SqlConnection conn = new SqlConnection("server=(local);database=yourtable;Integrated Security=SSPI"); conn.Open();
SqlCommand cmd = new SqlCommand("select tname,tage from yourtable", conn);
SqlDataReader dr = cmd.ExecuteReader();
this.GridView1.DataSource=dr;
this.DataView1.DataBind();
或者直接简单绑定也可以的 直接拖拽绑定》》》》
{
DataBind();
}
private void DataBind()
{
//初始化DataGridView
DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn();
column.Name = "sno";
column.HeaderText = "学号";
//设置绑定数据源的sno字段
column.DataPropertyName = "sno";
this.dataGridView1.Columns.Add(column); column = new DataGridViewTextBoxColumn();
column.Name = "sname";
column.HeaderText = "姓名";
//设置绑定数据源的sname字段
column.DataPropertyName = "sname";
this.dataGridView1.Columns.Add(column); column = new DataGridViewTextBoxColumn();
column.Name = "sage";
column.HeaderText = "年龄";
//设置绑定数据源的"sage"字段
column.DataPropertyName = "sage";
this.dataGridView1.Columns.Add(column); //设置不自动产生列
this.dataGridView1.AutoGenerateColumns = false;
this.dataGridView1.AllowUserToAddRows = false; //以下进行数据绑定
SqlConnection con = new SqlConnection("server=.;database=student;uid=sa;pwd=0421");
SqlDataAdapter sda = new SqlDataAdapter("select * from studentDetails", con);
DataSet ds = new DataSet();
sda.Fill(ds, "student");
this.dataGridView1.DataSource = ds.Tables["student"];
}