While filling comboBox with data from database, i created SqlDataReader. I wish to retrieve a column with product names

Question

This is the code.

void ProdFill()
{
    string coninfo = "datasource=DESKTOP-1F4329L;port=3306;username=root;password=root";
    string query = "select * from prodTest.product;";
    SqlConnection conn = new SqlConnection(coninfo);
    SqlCommand cmdDb = new SqlCommand(query, conn);
    SqlDataReader myReader;

    try
    {
        conn.Open();
        myReader = cmdDb.ExecuteReader();
        while(myReader.Read())
        {
            string prodname = myReader.GetString("pname");
            comboBox2.Items.Add(prodname);
        }
    }
}

It's giving an error at:

string prodname = myReader.GetString("pname");

stating that

it has invalid arguments. Cannot convert from string to int.

please check through breakpoint.what is the generated value is given by prodname? — Mandar Dhadve, Jun 13 '18 at 09:02
Possible duplicate: https://stackoverflow.com/questions/4018114/read-data-from-sqldatareader — Prasad Telkikar, Jun 13 '18 at 09:12

score 0 · Answer 1 · answered Jun 13 '18 at 09:04

0

Pass column index inside GetString()

answered Jun 13 '18 at 09:04

Nody

85
9

Prasad Telkikar · Answer 2 · 2018-06-13T09:15:40.260

0

You can try with following approaches

If you want to get data by column name then you can go with

string prodname = myReader["pname"].ToString();

If you know index of column then you can go with

   string prodname = myReader.GetString(0); //you can replace 0 with index of column

After getting data from myReader, you can add it to combobox

comboBox2.Items.Add(prodname);

edited Jun 13 '18 at 09:15

answered Jun 13 '18 at 09:07

Prasad Telkikar

15,207
5
21
44

While filling comboBox with data from database, i created SqlDataReader. I wish to retrieve a column with product names

2 Answers2