WinForm获取TextBox里分行的数据
设置TextBox为可以多行显示的属性:TextBox1.Multline=true;
//循环获取TextBox里分行数据——员工工号的值,拼接成字符串
private string EmpNoArr2;
for (int i = 0; i < TxtInputEmpNo.Lines.Length; i++)
{
if (i == 0)
{
EmpNoArr2 = "'" + TxtInputEmpNo.Lines[i].ToString() + "'";
}
else
{
EmpNoArr2 += ",'" + TxtInputEmpNo.Lines[i].ToString() + "'";
}
}
strSelect.Append(" Select EmpNo ,EmpName,Begindate ");
strSelect.Append(" From kq_new_leavereport Where EmpNo in (" + EmpNoArr2 + ") Order by EmpNo");
posted on 2013-05-15 16:32 ZorroBubble 阅读(396) 评论(0) 编辑 收藏 举报