Question

c#winform开发中有多个Label标签用于绑定从数据库中查出的字段,一个标签绑定一个字段,该如何快速实现？

Answer 1

点红色的框里的三角,绑定

Answer 2

做一个实体类, 从数据库里查出后赋与实体类, 然后将实体的各属性分别赋值于每个标签

Answer 3

把查询结果 赋值给一个 固定数组

然后再循环
label a = 数组[1];
label b = 数组[2];
label c = 数组[3];
.............

Answer 4

不想敲代码就用2楼的方法

敲代码就把数据查到一个datatable里面，然后循环赋值

Answer 5

Lable a="select * from biaom"

追问

这样的太麻烦了，难道有50个标签要读50次数据库？

追答

DataTable dt = JlDcmHQ.DataLayer.BaseArchives.BD_BranchArchiv_DB.ArchivSelectInfo(iColumnsBD_ArchivInfoID, strCompanyCode, strPassWord, strNuitName, strNuitAddress, strProjectManager, strCompanyType, strContractNuitName, strContractNuitAddress, strContractLegalRepresentative, strContractTel, strContractOurBank, strContractAccounts, strContractCode, strRemark, strEnable,ref strErrorMessage);
if (strErrorMessage != "")
{
MessageBox.Show(JlDcmHQ.Common.AlertMessage.strSqlErrorMsg + "\r\n\r\n" + strErrorMessage, JlDcmHQ.Common.AlertMessage.strWarningFrmText, MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.Close();
return;
}
this.labCompanyCode.Text = dt.Rows[0]["CompanyCode"].ToString();
this.labDataPassWord.Text = JlDcmHQ.Common.CryptoService.DesDecrypt(dt.Rows[0]["DataPassWord"].ToString());
this.labNuitName.Text = dt.Rows[0]["NuitName"].ToString();
this.labNuitAddress.Text = dt.Rows[0]["NuitAddress"].ToString();
this.labProjectManager.Text = dt.Rows[0]["ProjectManagerID"].ToString();
this.labContractNuitName.Text = dt.Rows[0]["ContractNuitName"].ToString();
this.labContractNuitAddress.Text = dt.Rows[0]["ContractNuitAddress"].ToString();
this.labContractLegalRepresentative.Text = dt.Rows[0]["ContractLegalRepresentative"].ToString();
this.labContractTel.Text = dt.Rows[0]["ContractTel"].ToString();
this.labContractOurBank.Text = dt.Rows[0]["ContractOurBank"].ToString();
this.labContractAccounts.Text = dt.Rows[0]["ContractAccounts"].ToString();
this.labContractCode.Text = dt.Rows[0]["ContractCode"].ToString();
this.labRemark.Text = dt.Rows[0]["Remark"].ToString();