C# .NET - Iam trying to delete a record in c# on a searched data reader. Here's my code

Asked By JAYA PRAKASH on 21-Feb-13 03:39 AM
 private void del_Click(object sender, EventArgs e)
        {
            scd1 = new SqlCommand();
                del_query = "delete from Product_details where Item='" + ite_name.Text + "'";
                scd1= new SqlCommand(del_query, con);
                scd1.ExecuteNonQuery();
            
            MessageBox.Show("Records deleted");
            sdr.Close();
        }


        private void sear_rec_Click(object sender, EventArgs e)
        {
            scd2 = new SqlCommand();
            str = "select * from Product_details where PrCode='"+pcode.Text+"'";
            scd2= new SqlCommand(str, con);
            SqlDataReader sdr = scd2.ExecuteReader();
            sdr.Read();
            ite_name.Text = sdr["Item"].ToString();
            pcode.Text = sdr["PrCode"].ToString();
            batch.Text = sdr["BatchNo"].ToString();
            manufact.Text = sdr["Manufacturer"].ToString();
            mdate.Text = sdr["MfgDate"].ToString();
            edate.Text = sdr["ExpDate"].ToString();
            qty.Text = sdr["Quantity"].ToString();
            sdr.Close();
        }

Iam getting the error Invalid object name 'dbo.Product_details_Tombstone'.



please somebody give a solution



abdul rehman replied to JAYA PRAKASH on 21-Feb-13 06:06 AM
 Product_details----Table--->u Wrote in quary
 'dbo.Product_details_Tombstone'---error


see u r table name is Product_Details correct? i think u r table name wrong
i think  in u r db tablename is  Product_Details_TombStone
please check and correct table name

Thanks and Regards 
Abdul Rehman