C#中字符串变量,加了转义字符的(例:string str = @”ab\”!c”),
中间能插入字符串变量吗?
一般:String sql = “Select a from table1 Where a = ‘” + para + ”’”;
不一般: String sql = @“Select a from table1 Where a = ‘” + para + ”’”;(可能多行)
中间能插入字符串变量吗?
一般:String sql = “Select a from table1 Where a = ‘” + para + ”’”;
不一般: String sql = @“Select a from table1 Where a = ‘” + para + ”’”;(可能多行)
SELECT a
FROM table1
WHERE a ='{0}'
AND b='{1}'
",para,para1);
String sql =String.Format(@"
SELECT a
FROM table1
WHERE a ='{0}'
AND b='{1}'
",para,para1);
另外也不建议这样的写法,这种习惯很不好。应该使用参数化SQL。
7楼的这位,说话就知道是个.net高手啊。
能给个参数化SQL的小例子吗?
SqlCommand cmd = new SqlCommand(queryString, conn);
cmd.Parameters.Add("@para", para);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
this.GridView1.DataSource = dt;
this.GridView1.DataBind();