using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace register
{
public partial class Reg : Form
{
public Reg()
{
InitializeComponent();
}
private void label4_Click(object sender, EventArgs e)
{
}
private void textBox8_TextChanged(object sender, EventArgs e)
{
}
private void button1_Click(object sender, EventArgs e)
{
try
{
SqlConnection con = new SqlConnection(@"Data Source=(localdb)\Projects;Initial Catalog=CCAD;Integrated Security=True");
con.Open();
SqlCommand cmd = new SqlCommand ("insert into [Admin](Username,Password,Firstname,Middlename,LastName,Gender,Birthday,Age,Email) values(@Username,@Password,@Firstname,@Middlename,@LastName,@Gender,@Birthday,@Age,@Email)", con);
cmd.Parameters.AddWithValue("@Username", textBox1.Text);
cmd.Parameters.AddWithValue("@Password", textBox2.Text);
cmd.Parameters.AddWithValue("@Firstname", textBox3.Text);
cmd.Parameters.AddWithValue("@Middlename", textBox4.Text);
cmd.Parameters.AddWithValue("@LastName", textBox5.Text);
cmd.Parameters.AddWithValue("@Gender", textBox6.Text);
cmd.Parameters.AddWithValue("@Birthday", textBox7.Text);
cmd.Parameters.AddWithValue("@Age", textBox8.Text);
cmd.Parameters.AddWithValue("@Email", textBox9.Text);
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Register Complete!", "Massage", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
}
}
private void button2_Click(object sender, EventArgs e)
{
Login form = new Login();
this.Hide();
form.Show();
}
}
}