给数据库中添加数据，一直没成功，网页不 跳转。急！！

Question

string connectionString = @"Data Source=DELL-PC;Initial Catalog = GXBYXS;User ID=sa;Password=123456 "; //定义字符串
System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection(connectionString); //创建Sqlconnection对象
// string sql = "insert into zhuce values('" + DropDownList1.SelectedValue + "," + txtname.Text + "," + txtpassword.Text + "," + txtSpassword.Text + "," + txtemail.Text + ")";
string sql=string.Format("insert into zhuce(Usertype,Username,Usermima,Usersmima,Useremail) values('{0}','{1}','{2}','{3}','{4}')", DropDownList1.SelectedValue .ToString(),
txtname.Text.ToString(), txtpassword.Text.ToString(),txtSpassword.Text.ToString(),txtemail.Text.ToString()) ;
try
{

        connection.Open();    //打开数据库的连接
        //  SqlCommand command=new SqlCommand(sql,connection);     //创建SqlCommand对象
        SqlCommand command = connection.CreateCommand();
        command.CommandText = sql;
        command.CommandType = CommandType.Text;


         int result =command.ExecuteNonQuery();
        if (result == 1)
        {

            Page.Response.Redirect("login.aspx");
        }
    }

Answer 1

if (result == 1)
你的插入语句不会返回1。
除非你在string sql = "..."
下面加上sql += ";select 1;"