SqlConnection conn = new SqlConnection("Data Source=PX-JCZX-05;Initial Catalog=wzgl;Integrated Security=True");
conn.Open();
SqlCommand sql = new SqlCommand("select * from [azyda] where [xm] like '%" + comboBox2.SelectedValue + "%'");
SqlDataAdapter admain = new SqlDataAdapter(sql);
admain.SelectCommand.Connection = conn;
DataSet ds = new DataSet();
admain.Fill(ds, "table");
ds.Tables["table"].Columns[0].ColumnName = "序号";
ds.Tables["table"].Columns[1].ColumnName = "单位";
ds.Tables["table"].Columns[2].ColumnName = "设备名称";
ds.Tables["table"].Columns[3].ColumnName = "规格型号";
ds.Tables["table"].Columns[4].ColumnName = "机电号";
ds.Tables["table"].Columns[5].ColumnName = "计量单位";
ds.Tables["table"].Columns[6].ColumnName = "数量";
ds.Tables["table"].Columns[7].ColumnName = "使用单位";
dataGridView1.DataSource = ds.Tables["table"];
dataGridView1.DataBindings();
conn.Close();
conn.Dispose();
提示错误:错误 “System.Windows.Forms.Control.DataBindings”是“属性”,但此处被当做“方法”来使用
是哪里的问题?
conn.Open();
SqlCommand sql = new SqlCommand("select * from [azyda] where [xm] like '%" + comboBox2.SelectedValue + "%'");
SqlDataAdapter admain = new SqlDataAdapter(sql);
admain.SelectCommand.Connection = conn;
DataSet ds = new DataSet();
admain.Fill(ds, "table");
ds.Tables["table"].Columns[0].ColumnName = "序号";
ds.Tables["table"].Columns[1].ColumnName = "单位";
ds.Tables["table"].Columns[2].ColumnName = "设备名称";
ds.Tables["table"].Columns[3].ColumnName = "规格型号";
ds.Tables["table"].Columns[4].ColumnName = "机电号";
ds.Tables["table"].Columns[5].ColumnName = "计量单位";
ds.Tables["table"].Columns[6].ColumnName = "数量";
ds.Tables["table"].Columns[7].ColumnName = "使用单位";
dataGridView1.DataSource = ds.Tables["table"];
dataGridView1.DataBindings();
conn.Close();
conn.Dispose();
提示错误:错误 “System.Windows.Forms.Control.DataBindings”是“属性”,但此处被当做“方法”来使用
是哪里的问题?
解决方案 »
- 请教datetime转换问题
- WPF_c#:能不能在listView的每一行内容前面,加一个“可钩选的框”?
- webBrowser1.Document.Body.InnerHtml获取的网页内容如何防止自动转义?
- itext!
- 【急】关于Common language runtime debugging services(公共语言运行库调试服务)
- 大家有没有将xsd文件转成数据库的工具和快捷方法呀,谢谢!!!
- WinForm中如何使用用户控件中TreeView控件的事件?
- 帮我看看怎么向axWindowsMediaPlayer组件的列表里添加歌曲??
- 如何求嵌套结构体的大小?
- 有关System.IO
- B/S下实现语音聊天、文字聊天、文件传输 请高手指点 分多的是 可以另加 关键是问题要解决
- 谁用.net做过视频采集的 进来看看 急啊!!!!!!!!!!
→→→→→→→
dataGridView1.DataBind();
dataGridView1.Refresh();
conn.Open();
SqlCommand sql = new SqlCommand("select * from [azyda] where [xm] like '%" + comboBox2.SelectedValue + "%'");
SqlDataAdapter admain = new SqlDataAdapter(sql);
admain.SelectCommand.Connection = conn;
DataSet ds = new DataSet();
admain.Fill(ds, "table");
ds.Tables["table"].Columns[0].ColumnName = "序号";
ds.Tables["table"].Columns[1].ColumnName = "单位";
ds.Tables["table"].Columns[2].ColumnName = "设备名称";
ds.Tables["table"].Columns[3].ColumnName = "规格型号";
ds.Tables["table"].Columns[4].ColumnName = "机电号";
ds.Tables["table"].Columns[5].ColumnName = "计量单位";
ds.Tables["table"].Columns[6].ColumnName = "数量";
ds.Tables["table"].Columns[7].ColumnName = "使用单位";
dataGridView1.DataSource = ds.Tables["table"];
dataGridView1.DataBindings();
conn.Close();
conn.Dispose();
提示错误:错误 “System.Windows.Forms.Control.DataBindings”是“属性”,但此处被当做“方法”来使用
是哪里的问题?
改成dataGridView1.DataBind();后提示错误 1 “System.Windows.Forms.DataGridView”并不包含“DataBind”的定义 D
winform是不需要“DataBind”的,
获取DataSource就可以了!
dataGridView1.DataSource = ds.Tables["table"];这句应该已经显示出数据了
Web页面里的GridView才需要 DataBinds()
Private Sub MainForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
sqlConn = New OleDbConnection("provider=sqloledb;server=.;database=coc;uid=coc;pwd=coc")
sqlComm = New OleDbCommand()
sqlConn.Open()
sqlComm.Connection = sqlConn
sqlComm.CommandText = "select * from meter"
Dada = New OleDbDataAdapter()
Dada.SelectCommand = sqlComm
Dset = New DataSet()
Dada.Fill(Dset)
DataGridView1.DataSource = Dset.Tables(0)
sqlConn.Close()
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
Dim cb As OleDbCommandBuilder = New OleDbCommandBuilder(Dada)
Dada.Update(Dset.Tables(0))
End Sub