如何设置带有显示数据库中表值的组合列的datagridview [英] how to set a datagridview with a combo column that display table value from a database

问题描述

如何设置带有组合列的datagridview，该组合列在表单加载时显示数据库中的表值...

谁能帮我

iam使用以下代码在datagridview中显示数据库表中的数据

how to set a datagridview with a combo column that display table value from a database while form load...

Can any one help me

iam using following code for displaying data from DB table in datagridview

private void edit_res_per_Load(object sender, EventArgs e)
     {
         mycon = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\\ETMS\\ETMS\\ETMS\\etms.accdb");
         string query = "Select resid as ID, resname as Person_Name,resdesg as Designation, resdept as Department From resperson order By resid ";
         da = new OleDbDataAdapter(query, mycon);
         OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
         dt = new DataTable();
         da.Fill(dt);
         dgv1.AllowUserToAddRows = false;


         dgv1.DataSource = dt;
         dgv1.Columns[0].ReadOnly = true;



     }

推荐答案

您可以使用DataGridViewComboBoxColumn类-请参见 ^ ].

You can use the DataGridViewComboBoxColumn class - see here[^].

这篇关于如何设置带有显示数据库中表值的组合列的datagridview的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！