Some Button code:
private void CmbSelectedName_SelectedIndexChanged(object sender, EventArgs e)
{
Register regis = new Register();
DataTable dt = new DataTable();
if (combo == false)
{
dt = regis.ViewSelectedRecords(Convert.ToInt32(CmbSelectedName.SelectedValue));
if (dt.Rows.Count > 0)
{
txtName.Text = dt.Rows[0]["Name"].ToString();
txtAge.Text = dt.Rows[0]["Age"].ToString();
txtAddress.Text = dt.Rows[0]["Address"].ToString();
if (dt.Rows[0]["Gender"].ToString() == "Male")
{
rdbFemale.Checked = true;
}
else
{
rdbMale.Checked = true;
}
cmbCity.Text = dt.Rows[0]["City"].ToString();
txtPin.Text = dt.Rows[0]["Pin"].ToString();
txtMobileNum.Text = dt.Rows[0]["MobileNum"].ToString();
cmbState.Text = dt.Rows[0]["State"].ToString();
cmbCountry.Text = dt.Rows[0]["Country"].ToString();
txtEmail.Text = dt.Rows[0]["Email"].ToString();
}
}
}
private void Form1_Load(object sender, EventArgs e)
{
this.Size = Screen.PrimaryScreen.WorkingArea.Size;
combo = true;
fillmethod();
ClearData();
combo = false;
}
private void fillmethod()
{
DataTable dtName = new DataTable();
Register reg = new Register();
CmbSelectedName.DataSource = reg.GetName();
CmbSelectedName.DisplayMember = "Name";
CmbSelectedName.ValueMember = "Id";
CmbSelectedName.SelectedIndex = -1;
}
private void ClearData()
{
CmbSelectedName.SelectedItem = "";
txtName.Text = "";
txtAge.Text = "";
txtAddress.Text = "";
rdbFemale.Checked = false;
rdbMale.Checked = false;
cmbCity.Text = "";
txtPin.Text = "";
txtMobileNum.Text = "";
cmbState.Text = "";
cmbCountry.Text = "";
txtEmail.Text = "";
}
private void btnSaved_Click_1(object sender, EventArgs e)
{
Register regi = new Register();
if (txtName.Text == "")
{
MessageBox.Show("enter your name");
txtName.Focus();
return;
}
if (txtAge.Text == "")
{
MessageBox.Show("enter your age");
txtAge.Focus();
return;
}
regi.Name = txtName.Text;
int a = Convert.ToInt32(txtAge.Text);
if (a > 10)
{
MessageBox.Show("Can't Register for age greater than 10");
ClearData();
return;
}
else
{
// int Age = DateTime.Today.Year - dateTimePicker1.Value.Year; // CurrentYear - BirthDate
// txtAge.Text = Age.ToString();
regi.Age = Convert.ToString(txtAge.Text);
}
regi.Address = txtAddress.Text;
if (rdbMale.Checked == true)
{
regi.Gender = "MALE";
}
else
{
regi.Gender = "Female";
}
regi.City = cmbCity.Text;
if (txtPin.Text.Length == 6)
{
regi.Pin = txtPin.Text;
}
else
{
MessageBox.Show("Invalid Pin Number");
ClearData();
return;
}
regi.Pin = txtPin.Text;
if (txtMobileNum.Text.Length == 10)
{
regi.MobileNum = txtMobileNum.Text;
}
else
{
MessageBox.Show("Invalid Phn Number");
ClearData();
return;
}
regi.State = cmbState.Text;
regi.Country = cmbCountry.Text;
System.Text.RegularExpressions.Regex rEmail = new System.Text.RegularExpressions.Regex(@"^[a-zA-Z][\w\.-]{2,28}[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$");
if (txtEmail.Text.Length > 0)
{
if (rEmail.IsMatch(txtEmail.Text))
{
regi.Email = txtEmail.Text;
}
else
{
MessageBox.Show("Give valid mail id");
ClearData();
return;
}
int saveRecords = regi.SaveToRegister();
if (saveRecords > 0)
{
MessageBox.Show("Successfuly Saved");
fillmethod();
ClearData();
}
else
{
MessageBox.Show("Failed to Save");
}
}
}
private void btnUpdated_Click(object sender, EventArgs e)
{
Register reg = new Register();
reg.Name = txtName.Text;
reg.Age = Convert.ToString(txtAge.Text);
reg.Address = txtAddress.Text;
if (rdbMale.Checked == true)
{
reg.Gender = "Male";
}
else
{
reg.Gender = "Female";
}
reg.City = cmbCity.Text;
reg.Pin = txtPin.Text;
reg.MobileNum = txtMobileNum.Text;
reg.State = cmbState.Text;
reg.Country = cmbCountry.Text;
reg.Email = txtMobileNum.Text;
int UpdateRecord = reg.UpdateRecords(CmbSelectedName.SelectedIndex + 1);
if (UpdateRecord > 0)
{
MessageBox.Show("Member updated");
fillmethod();
ClearData();
}
else
{
MessageBox.Show("Failed To Updated");
ClearData();
}
}
private void btnCleared_Click(object sender, EventArgs e)
{
CmbSelectedName.SelectedIndex = -1;
txtName.Text = "";
txtAge.Text = "";
txtAddress.Text = "";
rdbFemale.Checked = false;
rdbMale.Checked = false;
cmbCity.Text = "";
txtPin.Text = "";
txtMobileNum.Text = "";
cmbState.Text = "";
cmbCountry.Text = "";
txtEmail.Text = "";
}
private void btnDeleted_Click(object sender, EventArgs e)
{
Register re = new Register();
int rs = re.DeleteRecords(Convert.ToInt32(CmbSelectedName.SelectedValue));
if (rs > 0)
{
MessageBox.Show("Deleted Successfully");
fillmethod();
ClearData();
}
else
{
MessageBox.Show("Failed to Delete");
ClearData();
}
}
private void btnViewd_Click(object sender, EventArgs e)
{
frmView objView = new frmView();
objView.Show();
}
private void btnClosed_Click(object sender, EventArgs e)
{
//LoginPage lp = new LoginPage();
this.Close();
}
private void btnLogout_Click(object sender, EventArgs e)
{
MessageBox.Show("Thank you for registration");
this.Hide();
LoginPage lp = new LoginPage();
lp.Show();
}
private void btnDetails_Click(object sender, EventArgs e)
{
detailsView df = new detailsView();
string gender = "";
if (rdbFemale.Checked)
{
gender = "Male";
}
else
{
gender = "Female";
}
df.setvalues(txtName.Text,
Convert.ToInt32( txtAge.Text),
txtAddress.Text,gender,
cmbCity.Text.ToString(),
txtPin.Text,txtMobileNum.Text,
cmbState.Text.ToString(),
cmbCountry.Text.ToString(),
txtEmail.Text);
df.ShowDialog();
}
private void txtAge_TextChanged(object sender, EventArgs e)
{
}
private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
{
int age = DateTime.Today.Year - dateTimePicker1.Value.Year;
txtAge.Text = age.ToString();
}
private void CmbSelectedName_SelectedIndexChanged(object sender, EventArgs e)
{
Register regis = new Register();
DataTable dt = new DataTable();
if (combo == false)
{
dt = regis.ViewSelectedRecords(Convert.ToInt32(CmbSelectedName.SelectedValue));
if (dt.Rows.Count > 0)
{
txtName.Text = dt.Rows[0]["Name"].ToString();
txtAge.Text = dt.Rows[0]["Age"].ToString();
txtAddress.Text = dt.Rows[0]["Address"].ToString();
if (dt.Rows[0]["Gender"].ToString() == "Male")
{
rdbFemale.Checked = true;
}
else
{
rdbMale.Checked = true;
}
cmbCity.Text = dt.Rows[0]["City"].ToString();
txtPin.Text = dt.Rows[0]["Pin"].ToString();
txtMobileNum.Text = dt.Rows[0]["MobileNum"].ToString();
cmbState.Text = dt.Rows[0]["State"].ToString();
cmbCountry.Text = dt.Rows[0]["Country"].ToString();
txtEmail.Text = dt.Rows[0]["Email"].ToString();
}
}
}
private void Form1_Load(object sender, EventArgs e)
{
this.Size = Screen.PrimaryScreen.WorkingArea.Size;
combo = true;
fillmethod();
ClearData();
combo = false;
}
private void fillmethod()
{
DataTable dtName = new DataTable();
Register reg = new Register();
CmbSelectedName.DataSource = reg.GetName();
CmbSelectedName.DisplayMember = "Name";
CmbSelectedName.ValueMember = "Id";
CmbSelectedName.SelectedIndex = -1;
}
private void ClearData()
{
CmbSelectedName.SelectedItem = "";
txtName.Text = "";
txtAge.Text = "";
txtAddress.Text = "";
rdbFemale.Checked = false;
rdbMale.Checked = false;
cmbCity.Text = "";
txtPin.Text = "";
txtMobileNum.Text = "";
cmbState.Text = "";
cmbCountry.Text = "";
txtEmail.Text = "";
}
private void btnSaved_Click_1(object sender, EventArgs e)
{
Register regi = new Register();
if (txtName.Text == "")
{
MessageBox.Show("enter your name");
txtName.Focus();
return;
}
if (txtAge.Text == "")
{
MessageBox.Show("enter your age");
txtAge.Focus();
return;
}
regi.Name = txtName.Text;
int a = Convert.ToInt32(txtAge.Text);
if (a > 10)
{
MessageBox.Show("Can't Register for age greater than 10");
ClearData();
return;
}
else
{
// int Age = DateTime.Today.Year - dateTimePicker1.Value.Year; // CurrentYear - BirthDate
// txtAge.Text = Age.ToString();
regi.Age = Convert.ToString(txtAge.Text);
}
regi.Address = txtAddress.Text;
if (rdbMale.Checked == true)
{
regi.Gender = "MALE";
}
else
{
regi.Gender = "Female";
}
regi.City = cmbCity.Text;
if (txtPin.Text.Length == 6)
{
regi.Pin = txtPin.Text;
}
else
{
MessageBox.Show("Invalid Pin Number");
ClearData();
return;
}
regi.Pin = txtPin.Text;
if (txtMobileNum.Text.Length == 10)
{
regi.MobileNum = txtMobileNum.Text;
}
else
{
MessageBox.Show("Invalid Phn Number");
ClearData();
return;
}
regi.State = cmbState.Text;
regi.Country = cmbCountry.Text;
System.Text.RegularExpressions.Regex rEmail = new System.Text.RegularExpressions.Regex(@"^[a-zA-Z][\w\.-]{2,28}[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$");
if (txtEmail.Text.Length > 0)
{
if (rEmail.IsMatch(txtEmail.Text))
{
regi.Email = txtEmail.Text;
}
else
{
MessageBox.Show("Give valid mail id");
ClearData();
return;
}
int saveRecords = regi.SaveToRegister();
if (saveRecords > 0)
{
MessageBox.Show("Successfuly Saved");
fillmethod();
ClearData();
}
else
{
MessageBox.Show("Failed to Save");
}
}
}
private void btnUpdated_Click(object sender, EventArgs e)
{
Register reg = new Register();
reg.Name = txtName.Text;
reg.Age = Convert.ToString(txtAge.Text);
reg.Address = txtAddress.Text;
if (rdbMale.Checked == true)
{
reg.Gender = "Male";
}
else
{
reg.Gender = "Female";
}
reg.City = cmbCity.Text;
reg.Pin = txtPin.Text;
reg.MobileNum = txtMobileNum.Text;
reg.State = cmbState.Text;
reg.Country = cmbCountry.Text;
reg.Email = txtMobileNum.Text;
int UpdateRecord = reg.UpdateRecords(CmbSelectedName.SelectedIndex + 1);
if (UpdateRecord > 0)
{
MessageBox.Show("Member updated");
fillmethod();
ClearData();
}
else
{
MessageBox.Show("Failed To Updated");
ClearData();
}
}
private void btnCleared_Click(object sender, EventArgs e)
{
CmbSelectedName.SelectedIndex = -1;
txtName.Text = "";
txtAge.Text = "";
txtAddress.Text = "";
rdbFemale.Checked = false;
rdbMale.Checked = false;
cmbCity.Text = "";
txtPin.Text = "";
txtMobileNum.Text = "";
cmbState.Text = "";
cmbCountry.Text = "";
txtEmail.Text = "";
}
private void btnDeleted_Click(object sender, EventArgs e)
{
Register re = new Register();
int rs = re.DeleteRecords(Convert.ToInt32(CmbSelectedName.SelectedValue));
if (rs > 0)
{
MessageBox.Show("Deleted Successfully");
fillmethod();
ClearData();
}
else
{
MessageBox.Show("Failed to Delete");
ClearData();
}
}
private void btnViewd_Click(object sender, EventArgs e)
{
frmView objView = new frmView();
objView.Show();
}
private void btnClosed_Click(object sender, EventArgs e)
{
//LoginPage lp = new LoginPage();
this.Close();
}
private void btnLogout_Click(object sender, EventArgs e)
{
MessageBox.Show("Thank you for registration");
this.Hide();
LoginPage lp = new LoginPage();
lp.Show();
}
private void btnDetails_Click(object sender, EventArgs e)
{
detailsView df = new detailsView();
string gender = "";
if (rdbFemale.Checked)
{
gender = "Male";
}
else
{
gender = "Female";
}
df.setvalues(txtName.Text,
Convert.ToInt32( txtAge.Text),
txtAddress.Text,gender,
cmbCity.Text.ToString(),
txtPin.Text,txtMobileNum.Text,
cmbState.Text.ToString(),
cmbCountry.Text.ToString(),
txtEmail.Text);
df.ShowDialog();
}
private void txtAge_TextChanged(object sender, EventArgs e)
{
}
private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
{
int age = DateTime.Today.Year - dateTimePicker1.Value.Year;
txtAge.Text = age.ToString();
}