private void btnSave_Click(object sender, EventArgs e) { int found = 0; if (txtname.Text.Equals("")) { MessageBox.Show("Insert data Please"); } else { DataTable dt = ClassSetting.searchProTypeByName(txtname.Text); for (int j = 0; j < dt.Rows.Count; j++) { if (txtname.Text.Equals(dt.Rows[j][0].ToString())) { found = 1; } } if (found == 1) { MessageBox.Show("This name already exists . ."); } else { int add = ClassSetting.sp_addty(txtname.Text); txtname.Text = ""; MessageBox.Show("Done"); } } }