1. 加在字符串前面,字符串中的 \ 失去转义符的作用,直接写字符串而不需要考虑转义字符
- string path = @"C:\Windows\";
-
- string path2 = "C:\\Windows\\";
- string path = @"C:\Windows\";
-
- string path2 = "C:\\Windows\\";
2. 加在字符串前面,字符串中的 " 要用 "" 表示
- string str = @"aaa=""bbb""";
-
- string str2 = "aaa=\"bbb\"";
- string str = @"aaa=""bbb""";
-
- string str2 = "aaa=\"bbb\"";
3 加在字符串前面,换行空格都保存着,方便阅读代码
- string insert = @"
- insert into Users
- (
- UserID,
- Username,
- Email
- ) values
- (
- @UserID,
- @Username,
- @Email
- )";
- string insert = @"
- insert into Users
- (
- UserID,
- Username,
- Email
- ) values
- (
- @UserID,
- @Username,
- @Email
- )";
4 用关键字做变量时在关键字前面加@
- string @operator = "+";
- string @class = "分类一";
- Console.WriteLine(@operator);
- Console.WriteLine(@class);
- string @operator = "+";
- string @class = "分类一";
- Console.WriteLine(@operator);
- Console.WriteLine(@class);
5 作为sql语句里的一个“标签”,声明此处需要插入一个参数
- string delete = "delete from Categery where CategoryID=@CategoryID";
- SqlConnection connection = new SqlConnection("connectionString");
- SqlCommand command = new SqlCommand(delete, connection);
- command.Parameters.Add("@CategoryID", SqlDbType.BigInt);