Вопрос относительно классов C# для регистрации пользователя
Hi, I am new learning C# and trying to create sql server database. For that I have created a User class and Database class. My problem is if I try to signup a new user, database does not get any data. Can anyone please help me figure out what I am missing. Here is the code **User Class** public class UserDB { public int Id { get; set; } public string UserName { get; set; } public string Password { get; set; } public string Gender { get; set; } public string PhoneNo { get; set; } public string Email { get; set; } public string DateofBirth { get; set; } } **Database Class** { public class Database : UserDB { public SqlConnection conn; public SqlCommand Cmd; public SqlDataReader dr; private DataTable dt; public Database() { conn = new SqlConnection(@"Data Source=DESKTOP;Initial Catalog=Login_DB;Integrated Security=True"); } public int Register(UserDB user) { int code = 1; try { using (SqlCommand command = new SqlCommand( "INSERT INTO UserDB(Name, Password, Gender, Phone, Email, DOB) VALUES(username, password, gender, phoneno, email, dateofbirth, )", conn)) { command.Parameters.Add(new SqlParameter("UserName", UserName)); command.Parameters.Add(new SqlParameter("Password", Password)); command.Parameters.Add(new SqlParameter("Gender", Gender)); command.Parameters.Add(new SqlParameter("PhoneNo", PhoneNo)); command.Parameters.Add(new SqlParameter("Email", Email)); command.Parameters.Add(new SqlParameter("DateofBirth", DateofBirth)); command.ExecuteNonQuery(); } } catch (SqlException ex) { code = -1; } return code; } } **Registration Page** public sealed partial class RegPage : Page { Database db; public RegPage() { this.InitializeComponent(); } private void BtnSubmit_Click(object sender, RoutedEventArgs e) { int code =1; UserDB user = new UserDB(); { user.UserName = Username.Text.Trim(); user.Password = Password.Password; user.PhoneNo = PhoneNo.Text.ToString(); user.Email = Email.Text.Trim(); user.DateofBirth = DateofBirth.ToString(); }; if (code == -1) { var message = new MessageDialog("Register failed"); //await message.ShowAsync(); } else { var message = new MessageDialog("Register success"); this.Frame.Navigate(typeof(MainPage)); } } }
Что я уже пробовал:
различные онлайн-форумы и онлайн-уроки