strCmd = "SELECT TC001,TC002,TC003,TC004 FROM PURTC WHERE PURTC.TC014 = 'Y' AND SUNSTRIN(PURTC.TC003,1,6) = '" + textBox1.Text +"'";
可以这样写 另一个TextBox值:string s_Date = this.TextBox1.Text.Trim(); ... strCmd = "SELECT TC001,TC002,TC003,TC004 FROM PURTC WHERE PURTC.TC014 = 'Y' AND SUNSTRIN(PURTC.TC003,1,6) = '"+s_Date+" '";
string s_Date = this.TextBox1.Text.Trim(); ... strCmd = "SELECT TC001,TC002,TC003,TC004 FROM PURTC WHERE PURTC.TC014 = 'Y' AND SUNSTRIN(PURTC.TC003,1,6) = '"+s_Date+" '"; 这是正确的写法,注意"'"xxx"'"
建议用StringBuilder或者下面的写法 string strSql=string.Format(@"SELECT TC001,TC002,TC003,TC004 FROM PURTC WHERE PURTC.TC014 = 'Y' AND SUNSTRIN(PURTC.TC003,1,6) ='{0}'",s_Date.Text );
另一个TextBox值:string s_Date = this.TextBox1.Text.Trim();
...
strCmd = "SELECT TC001,TC002,TC003,TC004 FROM PURTC WHERE PURTC.TC014 = 'Y' AND SUNSTRIN(PURTC.TC003,1,6) = '"+s_Date+" '";
...
strCmd = "SELECT TC001,TC002,TC003,TC004 FROM PURTC WHERE PURTC.TC014 = 'Y' AND SUNSTRIN(PURTC.TC003,1,6) = '"+s_Date+" '"; 这是正确的写法,注意"'"xxx"'"