C#中很长的SQL语句如何换行啊,我直接打回车总是报错,在网上看到了什么_ &的换行方式,但还是不行,请高手赐教.如下边的SQL语句如何换行,最好是可以很自由的换
string sql = string.Format("SELECT WordName,WordMean,WordId FROM Word WHERE WordListId IN (SELECT SWordListId FROM WordList WHERE SWordListName LIKE '%{0}%') AND WordName LIKE '%{1}%'", cboWordList.Text, txtWordName.Text);
string sql = string.Format("SELECT WordName,WordMean,WordId FROM Word WHERE WordListId IN (SELECT SWordListId FROM WordList WHERE SWordListName LIKE '%{0}%') AND WordName LIKE '%{1}%'", cboWordList.Text, txtWordName.Text);
+"WordListId IN (SELECT SWordListId FROM WordList WHERE SWordListName LIKE '%{0}%') "
+"AND WordName LIKE '%{1}%'", cboWordList.Text, txtWordName.Text);
Word WHERE WordListId IN (SELECT SWordListId FROM WordList WHERE SWordListName LIKE '%{0}%') _
AND WordName LIKE '%{1}%'", cboWordList.Text, txtWordName.Text);
" OrderDate, RequiredDate, " +
" ShippedDate, ShipVia " +
" FROM Orders " +
" WHERE CustomerID = '" + sCustID + "'";