简单,我脑袋不好用

Question

参数化sql中
            string sql = "insert into Siyri_filiale(filiale,url) values(@filiale,@url)";
            SqlParameter[] para = { 
                                    new SqlParameter("@filiale",TextBox1.Text.Trim()),
                                    new SqlParameter("@url",TextBox2.Text.Trim())
                                  };
要判读 如果textbox2为空,则插入#,不为空,则插入textbox2.text.怎么写

Answer 1

string.IsNullOrEmpty(TextBox2.Text)?"#":TextBox2.Text;

Answer 2

new SqlParameter("@url",TextBox2.Text.Trim().length==0?"#"?TextBox2.Text.Trim())

Answer 3

new SqlParameter("@url",TextBox2.Text.Trim().Length==0 ? "#" : TextBox2.Text.Trim())

Answer 4

三元运算符
ls的都回答了！
也可以在外面判断
string str="";
if(textbox2.text=="")
    str="#";
else
    str=textbox2.text;string sql = "insert into Siyri_filiale(filiale,url) values(@filiale,@url)";
            SqlParameter[] para = { 
                                    new SqlParameter("@filiale",TextBox1.Text.Trim()),
                                    new SqlParameter("@url",str)
                                  };
不过这种一般我都用三元运算符来做

Answer 5

string str2=this.textbox2.text.length==0?"#":this.textbox2.text;
参数那边用str2，不要用textbox2.text.trim();