
(2)如果是直接显示在列表中的话,comboBox1.Items.Add(textBox1.Text.Trim())就可以了。
//先设置datagridview的visible设置成falsepublic static string 连接字符串 = "Data Source=LocalHost实例名Initial Catalog=数据库名Integrated Security=True"
SqlConnection sqlConnection = new SqlConnection(连接字符串)
string cmdText = "SELECT 。。。。。。。"
SqlCommand selectCommand = new SqlCommand(cmdText, sqlConnection)
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(selectCommand)
DataTable dt = new DataTable()
sqlConnection.Open()
sqlDataAdapter.Fill(dataTable)
sqlConnection.Close()
dataGridView1.DataSource=dt
dataGridView1.Visible = true
this.datagridview1.datasource=dataset1.tables[0]//绑定数据源,这样在界面修改单元格时,就可以更新到datasetdataAdapter dataadapter1=new dataAdapter(selectSQL,connnection)
dataadapter1.update(dataset1.tables[0])//通过datatable修改数据库
欢迎分享,转载请注明来源:内存溢出
微信扫一扫
支付宝扫一扫
评论列表(0条)