Display data form sql db onto datagridview with labled columns

Question

1.00/5 (1 vote)

See more:

i have a form with data gridview which has 6 labled columns. i want to display data from
sql db onto only 3 of the labled columns. i tried but only the first row in the db gets displayed
on the datagridview. please help me out
below are the codes i used

public void loadproduct3()
        {
            SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
            conn.ConnectionString = "Data Source=USER-PC;Initial Catalog=BARDB;User ID=sa;Password=mike";
            conn.Open();
            SqlCommand cmd = new SqlCommand();
            string sqlQueryy = null;
            sqlQueryy = "select * from tblproduct";
            cmd.Connection = conn;
            cmd.CommandText = sqlQueryy;
            cmd.CommandType = System.Data.CommandType.Text;
            SqlDataReader dr = null;
            dr = cmd.ExecuteReader();
            if (dr.Read())
            {
                for (int i = 0; i < dgvSales.Rows.Count; i++)
                {
                    dgvSales.Rows[i].Cells["clmProductid"].Value = dr["productid"].ToString();
                    dgvSales.Rows[i].Cells["clmProductname"].Value = dr["productname"].ToString();
                    dgvSales.Rows[i].Cells["clmUnitprice"].Value = dr["unitprice"].ToString();
                }
            }
            else
            {
                //return false;
            }
            conn.Close();
        }

Posted 3-Aug-13 9:17am

mikeoabban

Updated 19-Apr-17 0:52am

v2

Add a Solution

Comments

[no name] 3-Aug-13 15:22pm

"only the row in the db gets displayed", you are only reading the data from your datareader once so all you are going to get is one row.

mikeoabban 3-Aug-13 15:35pm

please how do i read the dtatbase multiple times

[no name] 3-Aug-13 15:42pm

You don't. You read the data out of your reader, once for each row. Try replacing your "if" with a "while".

mikeoabban 3-Aug-13 15:47pm

i tried and only displayed the last row in the db

[no name] 4-Aug-13 6:51am

Then you did something wrong is all I can tell you.

2 solutions

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)

Srinivas Kalabarigi · Answer 1 · 2013-08-03T10:04:00

Use the below:

C#

public void loadproduct3()
    {
        SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
        conn.ConnectionString = "Data Source=USER-PC;Initial Catalog=BARDB;User ID=sa;Password=mike";


        SqlDataAdapter oSDA = new SqlDataAdapter("select * from tblproduct", conn);
        DataSet oDs = new DataSet();
        oSDA.SelectCommand.CommandType = CommandType.Text;
        oSDA.Fill(oDs);

        if (oDs.Tables[0].Rows.Count > 0)
        {
            dgvSales.DataSource = oDs;
            dgvSales.DataBind();
        }
    }

Aleemuddin Siddiqui · Answer 2 · 2017-04-19T00:52:00

Solution 2

mike I think you should use first
while dr.read() before ... for .... to loop
which will end with end while

Posted 19-Apr-17 0:52am

Aleemuddin Siddiqui