调试易

update Products set ProductName='chair''ss' where ProductID=1
这样就行了！

SqlConnection sqlCon = new SqlConnection("server=.;database=test;uid=sa;pwd=pass");
sqlCon.Open();
SqlCommand sqlCmd = new SqlCommand(string.Format("Insert into Tree(ID,Name) values ({0},@Name)","1"),sqlCon);
SqlParameter sqlptr = new SqlParameter("@Name",this.TextBox1.Text);
sqlCmd.Parameters.Add(sqlptr);
sqlCmd.ExecuteNonQuery();
sqlCon.Close();

"'"-->"''"
SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
            SqlCommand comm=new SqlCommand("update tb1 set vName=@vName,iAge=@iAge where ID=@id",conn);
            SqlParameter parm1=new SqlParameter("@vName",SqlDbType.NVarChar,50);
            parm1.Value=((TextBox)e.Item.FindControl("name")).Text;
            SqlParameter parm2=new SqlParameter("@iAge",SqlDbType.Int);
            parm2.Value=((TextBox)e.Item.FindControl("age")).Text;
            SqlParameter parm3=new SqlParameter("@id",SqlDbType.Int);
            parm3.Value=this.DataGrid1.DataKeys[e.Item.ItemIndex];
            comm.Parameters.Add(parm1);
            comm.Parameters.Add(parm2);
            comm.Parameters.Add(parm3);
            conn.Open();
            comm.ExecuteNonQuery();
            conn.Close();