asp.net 连接sql server 插入

            第二天了，昨天整了一个查询，今天整一个插入

        string username = this.TextBox1.Text; //获取USERNAME        string password = this.TextBox2.Text; //获取PASSWORD        string sqlCon = "server=你的IP;uid=用户名;pwd=密码;database =数据库名";        string sql = "Insert into  table1(id,name)Values( " + username + "," + password +")";        SqlConnection conn = new SqlConnection(sqlCon);        SqlCommand cmd = new SqlCommand(sql, conn);        conn.Open();        int val = cmd.ExecuteNonQuery();        if (val >= 1)        {            this.Label1.Text = "成功";  //在前端有一个Lable控件 插入进去了就在控件上显示成功        }        else        {            this.Label2.Text = "失败;        }        conn.close();

不知道这个有没有rollback 还没有尝试