Hi,
If your datatable dtusers is declared outside the BTN_SHOW_Click, issue might be due to, the datatabe is persisting its old values.
Please add the line dtusers.Clear(); like as follows
private void BTN_SHOW_Click(object sender, EventArgs e)
{
dtusers.Clear();
SqlDataAdapter da = new SqlDataAdapter("select dicharge_date AS 'Discharge Date',bed_id AS 'Room No',level1 AS 'Floor No',last_name AS 'Patient Name',doctor_name AS 'Patient Dr. Name',Discharge_Advice AS 'Dis Adv',Discharge_Card AS 'Dis Card',File_Check AS 'File Check',Billing,Actual_Discharge AS 'Actual Discharge',Time,reg_no,discharge_reason AS Remarks from NewDischargeTimes where dicharge_date=CONVERT(date, '" + maskedtxbx_dischargedate.Text + "', 103)", con);
SqlCommandBuilder cmd = new SqlCommandBuilder(da);
da.Fill(dtusers); dataGridView1.DataSource = dtusers;
dataGridView1.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
Please let me if it worked!!