Datagridview returned with empty row

Question

0.00/5 (No votes)

See more:

Today i am facing problem to fill datagridview1. i have created void for fill the gridview from data source. it is working fine in buttons click but not fill if i putted it to the page load.

What I have tried:

C#

private void fillgidview()
        {
            try
            {
                cnn.Open();
                string sqlcommand = " select OPD_NO as [OPD No],Patientname as [Pateint Name],Age,VisitDate as [visit Date],Department,Consultent_Doctor  from OPD_table  where Status_pet='Checked In'   and Consultent_Doctor='" + label5.Text + "'";

                SqlDataAdapter adap = new SqlDataAdapter(sqlcommand, cnn);

                DataTable dt = new DataTable();

                adap.Fill(dt);
                
                this.dataGridView1.DataSource = dt;
                
                cnn.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());

            }
        }

Posted 6-Oct-16 21:05pm

Member 10532715

Updated 7-Oct-16 0:49am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v2

Add a Solution

Comments

Sinisa Hajnal 7-Oct-16 4:15am

IF this is web development (as implied by Page load) then you need to call dataGridView1.DataBind()

If it is not (as implied by use of DataGridView) then you need to do form load not page load event.

Also, you should never EVER add user input value to your SQL.

Member 10532715 7-Oct-16 4:37am

yes it is windows desktop application pls see my full code

previous page code where i have putted

private void adminMenuToolStripMenuItem_Click(object sender, EventArgs e)
{
FrmDoctorOPD doctoropd = new FrmDoctorOPD();
doctoropd.Show();
doctoropd.label5.Text = label12.Text;

}

now in page to i have putted it as..

private void FrmDoctorOPD_Load(object sender, EventArgs e)
{

label7.Text = System.DateTime.Now.ToShortDateString();
fillgidview();

}

private void fillgidview()
{
try
{
cnn.Open();
string sqlcommand = " select OPD_NO as [OPD No],Patientname as [Pateint Name],Age,VisitDate as [visit Date],Department,Consultent_Doctor from OPD_table where Status_pet='Checked In' and Consultent_Doctor='" + label5.Text + "'";

SqlDataAdapter adap = new SqlDataAdapter(sqlcommand, cnn);

DataTable dt = new DataTable();

adap.Fill(dt);

this.dataGridView1.DataSource = dt;

cnn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());

}

}

1 solution

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)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 1 · 2016-10-06T22:35:00

Solution 1

Refer - How to: Bind Data to the Windows Forms DataGridView Control[^].

Make sure your data is coming from database.

Posted 6-Oct-16 22:35pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

Member 10532715 7-Oct-16 4:41am

yes it is coming from data base.. when i use search button .. its working fine but not in page load.. pls see search button code it is working like charm..

private void search()
{

try
{
cnn.Open();
string sqlcommand = " select OPD_NO as [OPD No],Patientname as [Pateint Name],Age,VisitDate as [visit Date],Department,Consultent_Doctor from OPD_table where Status_pet='Checked In' and Consultent_Doctor='" + label5.Text + "' and visitdate between '" + DateTime.ParseExact(this.dateTimePicker1.Text, "MM/dd/yyyy", CultureInfo.InvariantCulture) + "' and '" + DateTime.ParseExact(this.dateTimePicker2.Text, "MM/dd/yyyy", CultureInfo.InvariantCulture) + "'";

SqlDataAdapter adap = new SqlDataAdapter(sqlcommand, cnn);

DataTable dt = new DataTable();

adap.Fill(dt);

if (dt.Rows.Count > 0)
{

this.dataGridView1.DataSource = dt;

cnn.Close();
}

else
{
MessageBox.Show("No Records found");
dataGridView1.DataSource = null;
cnn.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());

}

}

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 7-Oct-16 6:48am

Your query is different here inside the search method. Can you debug and see in the code if the data is coming and binding to the datatable?

Member 10532715 7-Oct-16 4:42am

private void metroTile3_Click(object sender, EventArgs e)
{
search();

}

Member 10532715 7-Oct-16 6:54am

It has been solved, actually my constructor pass data after form load i have putted it to after.. then its working fine.. Thanks Mr.Tadit.. for looking my problem...

wrong code..
FrmDoctorOPD doctoropd = new FrmDoctorOPD();
doctoropd.Show();
doctoropd.label5.Text = label12.Text; /// here is wrong afterload

Correct code..

FrmDoctorOPD doctoropd = new FrmDoctorOPD();
doctoropd.label5.Text = label12.Text; before load
doctoropd.Show();

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 7-Oct-16 6:57am

Glad to hear that. Most welcome. Keep coding. :)