How Do I Show Mysql Database In C# Grid View Here Is My Piece Of Code This Displays Nothing

Question

1.00/5 (1 vote)

See more:

C#

private void frmpatient_Load(object sender, EventArgs e)
        {
            con = new MySqlConnection();
            con = dbcon.openconnection();

            showdatabase();
        }

C#

public void showdatabase() {

          con.Open();
          ds = new DataSet();
          cmd = new MySqlCommand();
          cmd.Connection = con;
          cmd.CommandText = "SELECT * FROM `Ptient`";
          da = new MySqlDataAdapter(cmd);
          da.Fill(ds, "st");
          dataGridViewpatient.DataSource = ds;
          dataGridViewpatient.DataMember = "st";

          con.Close();
      }

Posted 19-Mar-14 20:04pm

zakirox123

Updated 20-Mar-14 19:27pm

VICK

v2

Add a Solution

Comments

V5709 21-Mar-14 1:51am

Have you checked that data is coming in ds or not?

Marcin Kozub 21-Mar-14 5:23am

1. I think that should be 'Patient' instead of 'Ptient' in your SQL query.
2. What is dbcon?

zakirox123 21-Mar-14 14:18pm

hi dude my table name is same as this my spelling mistakes ;)

2 solutions

Add a Solution

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

Anudeep Jaiswal - MCA · Answer 1 · 2014-03-20T00:26:00

Solution 1

C#

private void frmpatient_Load(object sender, EventArgs e)
{
if (!(IsPostBack))
      {
con = new MySqlConnection();
con = dbcon.openconnection();

showdatabase();
}
}

Check IsPostBack Property.

Posted 20-Mar-14 0:26am

Anudeep Jaiswal - MCA

zakirox123 · Answer 2 · 2014-03-21T08:21:00

Hi every one i am sorry its my mistake i have created the connection already in a separate class and again i have been coded new Mysqlconnection :D that's my mistake any how i sought out the problem

//database connection

C#

MySqlConnection con;
dbconnection dbcon = new dbconnection();


MySqlDataAdapter da;
DataSet ds;

public frmpatient()
{
    InitializeComponent();
}

private void frmpatient_Load(object sender, EventArgs e)
{


    showdatabase();
}

public void showdatabase() {

    con = dbcon.openconnection();
    con.Open();
    MessageBox.Show("Connection ok");
    da = new MySqlDataAdapter("select * from actor",con);
    ds = new DataSet();
    da.Fill(ds);
    dataGridViewpatient.DataSource = ds.Tables[0];
    con.Close();


}

How Do I Show Mysql Database In C# Grid View Here Is My Piece Of Code This Displays Nothing

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How Do I Show Mysql Database In C# Grid View Here Is My Piece Of Code This Displays Nothing

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us