how to show new data everytime by clicking on show button which extract data based on date entered in maskedtextbox in windows application in c#

Question

0.00/5 (No votes)

See more:

I have a maskedtextbox, a button and a gridview.

everytime i enter date in maskedtextbox to show data in gridview by clicking on btnshow(button)
it shows me data with the the entered date and again when i enter different date it shows me the data related to the new date entered but also the previous data...so i don't know how to refresh the gridview to show only the new data related to date enetered.
My code for show button is as follows;-

private void BTN_SHOW_Click(object sender, EventArgs e)
        {
            
            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);
            
        }

Posted 28-Sep-13 3:31am

alanmaster

Updated 28-Sep-13 6:34am

Mahesh Bailwal

v3

Add a Solution

Comments

i.fakhari 28-Sep-13 9:48am

let's see your code :-]

alanmaster 28-Sep-13 9:53am

private void BTN_SHOW_Click(object sender, EventArgs e)
{

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);

}

jeenamary 28-Sep-13 11:57am

Where is dtusers declared?

alanmaster 30-Sep-13 4:40am

dtusers declared globally

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Text.RegularExpressions;
using System.Drawing.Printing;
using System.IO;

namespace WindowsFormsApplication9
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
DataTable dtusers = new DataTable();

alanmaster 30-Sep-13 5:09am

dtusers.Clear();

yes it worked thank u very much.

2 solutions

Solution 1

Clear your datagridview before you add rows with datagridview.rows.clear() or datagridview.datatasource = null and then the code to fill it up. Sorry i cant give the exact answer either one should work im answering from iphone and have no access to my notes

Posted 28-Sep-13 7:01am

Homero Rivera

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

jeenamary · Accepted Answer · 2013-09-29T07:45:00

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

C#

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!!