c# - 与数据库中的两列值绑定(bind)后，如何使下拉菜单中的内容看起来整洁？

Question

我在查询中组合了全名和姓氏以形成全名。这是我的 sql，适用于此问题:

SELECT l_name|| ' ' ||f_name AS student_info FROM studentdb;

如何在最长的 l_name 之后留出空间，以便在下拉菜单中显示两个整齐的列？

Answer 1

fill one or more columns fill in your dropdownbox

您可以根据自己的信息和要求应用此代码，实现起来非常容易

sql = "select " + displaycol + ", " + valcol + " from " + tblName+ " WHERE " + where + " order by " + displaycol;
SqlCommand ObjCommand = new SqlCommand(sql, ObjConnection);

SqlDataAdapter ObjAdapter = new SqlDataAdapter(ObjCommand);
ObjConnection.Open();
ObjAdapter.Fill(DT);
ObjConnection.Close();
ObjCommand.Dispose();
ObjAdapter.Dispose();

cmb.Enabled = false;
cmb.DataTextField = displaycol;
cmb.DataValueField = valcol;
cmb.DataSource = DT;