private void button1_Click(object sender, EventArgs e) { EmpDetails obj = new EmpDetails(); obj.EmpId = Convert.ToInt32(textemp.Text); obj.EmpName = textName.Text; obj.Age = Convert.ToInt32(textAge.Text); if (radioButton1.Checked) { obj.Gender = radioButton1.Text; } else if (radioButton2.Checked) { obj.Gender = radioButton2.Text; } //MessageBox.Show(obj.Gender); obj.Location = textLocation.Text; obj.Mobile = Convert.ToInt64(textMobile.Text); obj.Email = textMail.Text; obj.Address = textAddress.Text; int result = obj.getDetails(obj.EmpId, obj.EmpName, obj.Age, obj.Gender, obj.Location, obj.Mobile, obj.Email, obj.Address); if (result == 1) { MessageBox.Show("Details Added"); } else { MessageBox.Show("Company not Added"); } }
public List<EmpDetails> viewBang() { List<EmpDetails> old = new List<EmpDetails>(); string name = "bangalore"; SqlConnection connect = new SqlConnection("server=D11-PC\\SQLEXPRESS; database=employee; Integrated Security=true"); SqlCommand command = new SqlCommand("select * from Emp where Location='" + name + "'", connect); connect.Open(); SqlDataReader readers = command.ExecuteReader(); while (readers.Read()) { EmpDetails obj = new EmpDetails(); obj.EmpId = Convert.ToInt32(readers["EmpID"]); obj.EmpName=Convert.ToString(readers["EmpName"]); obj.Age = Convert.ToInt32(readers["Age"]); obj.Gender=Convert.ToString(readers["Gender"]); obj.Location = Convert.ToString(readers["Location"]); obj.Mobile = Convert.ToInt64(readers["Mobile"]); obj.Email = Convert.ToString(readers["Email"]); obj.Address = Convert.ToString(readers["Address"]); old.Add(obj); } //old.Add(obj); return old; }