C# ADO.NET基本添加操作

C# ADO.NET基本添加操作

  public bool Register(UserInfo ui)
        {
            using (SqlConnection conn = new SqlConnection("server=.;uid=sa;pwd=123456;database=oa"))
            {
                conn.Open();

                string sql = "insert Users values(@username,@password,@sex,@hobby,@work,@Head)";
                using (SqlCommand com = new SqlCommand(sql, conn))
                {
                    //给username提供参数                
                    com.Parameters.Add(new SqlParameter("username", ui.username));
                    com.Parameters.Add(new SqlParameter("password", ui.password));
                    com.Parameters.Add(new SqlParameter("sex", ui.sex));
                    com.Parameters.Add(new SqlParameter("hobby", ui.hobby));
                    com.Parameters.Add(new SqlParameter("work", ui.work));

                    if (ui.head == null)
                    {
                        ui.head = "";
                    }
                    com.Parameters.Add(new SqlParameter("Head", ui.head));

                    int count = com.ExecuteNonQuery();
                    if (count > 0)
                        return true;
                    else
                        return false;
                }
            }
        }