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编辑  收藏  举报

导航