i have a searching in database if record not found then mess

habib ullah

we make a searching in database if the record is not found then show the message "sorry record is not found" how i can do it help me solve problem my code is that

if (ds.Tables["tbl_transaction"].Rows.Count > 0)

{

label1.Text = "sorry record not found";

}

else

{

ds = cls.loaddataset("select * from tbl_expdtl where e_date = '" + dateTimePicker2.Text + "'", "tbl_expdtl");

object query = cls.getspecefisrecord("select sum(amount) from tbl_expdtl where e_date='" + dateTimePicker2.Text + "'");

lbl_show.Text = Convert.ToString(query);

dataGridView3.Rows.Clear();

for (int b = 0; b <= ds.Tables["tbl_expdtl"].Rows.Count - 1; b++)

{

dataGridView3.Rows.Add();

dataGridView3.Rows[b].Cells[0].Value = ds.Tables["tbl_expdtl"].Rows[b]["p_id"];

dataGridView3.Rows[b].Cells[1].Value = ds.Tables["tbl_expdtl"].Rows[b]["expence"];

dataGridView3.Rows[b].Cells[2].Value = ds.Tables["tbl_expdtl"].Rows[b]["amount"];

dataGridView3.Rows[b].Cells[3].Value = ds.Tables["tbl_expdtl"].Rows[b]["remarks"];

dataGridView3.Rows[b].Cells[4].Value = ds.Tables["tbl_expdtl"].Rows[b]["e_date"];

this.dataGridView3.RowsDefaultCellStyle.BackColor = Color.Bisque;

this.dataGridView3.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;

}

4 Replies

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

Sameer Shaik9y ago
Accepted answer
your logic is incorrect here,

you are checking if condition based on dataset ds,
and again you are loading ds in else
ds = cls.loaddataset("select * from tbl_expdtl where e_date = '" + dateTimePicker2.Text + "'", "tbl_expdtl");
There might be a possiblity again you may get empty result in ds, you are not handling in this case..
habib ullah9y ago
if (ds.Tables["tbl_transaction"].Rows.Count ==0)
{
label1.Text = "sorry record not found";
}
else
{
ds = cls.loaddataset("select * from tbl_expdtl where e_date = '" + dateTimePicker2.Text + "'", "tbl_expdtl");
object query = cls.getspecefisrecord("select sum(amount) from tbl_expdtl where e_date='" + dateTimePicker2.Text + "'");
lbl_show.Text = Convert.ToString(query);
dataGridView3.Rows.Clear();
for (int b = 0; b <= ds.Tables["tbl_expdtl"].Rows.Count - 1; b++)
{
dataGridView3.Rows.Add();
dataGridView3.Rows[b].Cells[0].Value = ds.Tables["tbl_expdtl"].Rows[b]["p_id"];
dataGridView3.Rows[b].Cells[1].Value = ds.Tables["tbl_expdtl"].Rows[b]["expence"];
dataGridView3.Rows[b].Cells[2].Value = ds.Tables["tbl_expdtl"].Rows[b]["amount"];
dataGridView3.Rows[b].Cells[3].Value = ds.Tables["tbl_expdtl"].Rows[b]["remarks"];
dataGridView3.Rows[b].Cells[4].Value = ds.Tables["tbl_expdtl"].Rows[b]["e_date"];
this.dataGridView3.RowsDefaultCellStyle.BackColor = Color.Bisque;
this.dataGridView3.AlternatingRowsDefaultCellStyle.BackColor = Color.Beige;
}
}
then show the error object refernce not set instance of the object
ketan borsdiya9y ago
Hi Habib,

You have write code
if (ds.Tables["tbl_transaction"].Rows.Count > 0)
count greater then 0 means record found

you need to write
if (ds.Tables["tbl_transaction"].Rows.Count == 0)
Manas Mohapatra9y ago
You have already implemented to show message if record not. What is the error you are encountering..