换行常量C# [英] New Line Constant C#

问题描述

大家好，我的sql语句太长.我将其分解并添加了enviroment.newline
但是它仍然无法正确阅读，关于我哪里出了问题的任何提示或想法?
非常感谢

谢谢露易丝:)

Hi guys, my sql statement is too long. Ive broken it up and added enviroment.newline
however its still not reading properly, any tips or ideas on where im going wrong?
much appreciated

thankyou Louise :)

DA.UpdateCommand = new SqlCommand("UPDATE BookDetails SET TITLE = @TITLE,  AUTHORFIRSTNAME = @AUTHORFIRSTNAME" + Environment.NewLine +
        "AUTHORSURNAME = @AUTHORSURNAME, ACQUISITIONDATE = @ACQUISITIONDATE,PUBLISHERNAME = @PUBLISHERNAME, ISBN = @ISBN" + Environment.NewLine +
        "DDCLASSIFICATION = @DDCLASSIFICATION WHERE BOOKID = @BOOKID)", SC);

推荐答案

我的sql语句太长"太长了怎么办? SQL处理器不关心换行符，因此我假设您的意思是代码编辑器中的可读性.在这种情况下，Environment.NewLine不执行任何操作，而是用于输出.

"my sql statement is too long" Too long how? The SQL processor doesn''t care about line breaks so I''m assuming you mean for readability in the code editor. In that case Environment.NewLine does nothing, it is meant for output.

string longString = @"Some long string
    that is broken into
    multiple lines";

这篇关于换行常量C#的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！