On C# Viual Studio

Bilawal Niaz

11y1.1k

I DEVELOP A SOFTWARE ON VISUAL STUDIO (C #) "EMPLOYEE INFROMATION SYSTEM",

WHEN I ENTERED A RECORD IN SOFTWARE, IT ADDED,

BUT WHEN I ADDED A RECORD HAVING EMPTY FIELDS

IT SHOWS RECORD DOES NOT ADDED BECAUSE FIELDS ARE EMPTY,

BUT IN DATA BASE RECORD WILL SAVE HAVING EMPTY FIELDS, WHY?

ANY BUDY HELP ME...!

THE CODE IS THAT:

==>

private void button1_Click(object sender, EventArgs e)

{

try

{

Department obj = new Department();

obj.DeptName = textBox1.Text;

obj.Description = textBox2.Text;

DepartmentDAL obj2 = new DepartmentDAL();

obj2.addDepartment(obj);

if (textBox1.Text != "" && textBox2.Text != "")

{

MessageBox.Show("Record Saved Successfully !", "Employee Information System");

clear();

}

else { MessageBox.Show("Error : Field's Empty \n\nEnter The Record To Save !", "Employee Information System"); }

}

catch { MessageBox.Show("Error : Field's Empty \n\nEnter The Record To Save !", "Employee Information System"); }

}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rahul Prajapat11y ago
Accepted answer
Hello @Bilawal try this

private void button1_Click(object sender, EventArgs e)
{
try
{
if (textBox1.Text != "" && textBox2.Text != "")
{
Department obj = new Department();
obj.DeptName = textBox1.Text;
obj.Description = textBox2.Text;
DepartmentDAL obj2 = new DepartmentDAL();
obj2.addDepartment(obj);

MessageBox.Show("Record Saved Successfully !", "Employee Information System");
clear();
}
else { MessageBox.Show("Error : Field's Empty \n\nEnter The Record To Save !", "Employee Information System"); }
}
catch { MessageBox.Show("Error : Field's Empty \n\nEnter The Record To Save !", "Employee Information System"); }
}
+1
Khan Abrar Ahmed11y ago
Hi Change the code and check the textbox value before inserting the records. like below

private void button1_Click(object sender, EventArgs e)
{
try
{

if (!string.IsnullorEmpty(textBox1.Text) && !string.IsNUllOrEmpty(textBox2.Text))
{
Department obj = new Department();
obj.DeptName = textBox1.Text;
obj.Description = textBox2.Text;
DepartmentDAL obj2 = new DepartmentDAL();
obj2.addDepartment(obj);

MessageBox.Show("Record Saved Successfully !", "Employee Information System");
clear();
}
else { MessageBox.Show("Error : Field's Empty \n\nEnter The Record To Save !", "Employee Information System"); }
}
catch { MessageBox.Show("Error : Field's Empty \n\nEnter The Record To Save !", "Employee Information System"); }
}

0
Munesh Sharma11y ago
Before Passing values of text boxes in object you check it is string.empty or not .. if it is null then you pass obj.Description = string .empty .. otherwise obj.Description = textBox2.Text;
0
Narasimha Reddy Chennupalli11y ago
Hey small change on your code, the issue is first you are adding the data into database then you are checking empty fields.

First you need to check empty fields, if fields are not empty then you need to add data in to database. As like below

if (textBox1.Text != "" && textBox2.Text != "")

{
Department obj = new Department();

obj.DeptName = textBox1.Text;

obj.Description = textBox2.Text;

DepartmentDAL obj2 = new DepartmentDAL();

obj2.addDepartment(obj);
MessageBox.Show("Record Saved Successfully !", "Employee Information System");

clear();

}
+1