I am trying to get data from the SQL database with stored procedure using dataset and populate that data in combobox. It gives error as cannot find table 0.

                    SqlConnection conn = new SqlConnection();
                    conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["dbConnection"].ConnectionString;
                    SqlCommand cmd2 = new SqlCommand("GetBatch", conn);
                    cmd2.CommandType = CommandType.StoredProcedure;
                    cmd2.CommandText = "usp_CAMR_GetBatch_Status";
                    cmd2.Connection = conn;
                    cmd2.Parameters.AddWithValue("@batch_name", comboBox1.Text.ToString().Substring(0, 12));
                    cmd2.Parameters.AddWithValue("@batch_status_flg", "");
                    cmd2.Parameters.AddWithValue("@BATCH_STATUS_DT", "");
                    cmd2.Parameters.AddWithValue("@BEGIN_SFN", "");
                    cmd2.Parameters.AddWithValue("@END_SFN", "");
                    cmd2.Parameters.AddWithValue("@TOTAL_SFN", "");
                    cmd2.Parameters.AddWithValue("@TOTAL_AMEND", "");
                    cmd2.Parameters.AddWithValue("@TOTAL_PAGES", "");
                    cmd2.Parameters.AddWithValue("@lst_mod_userid", "");
                    cmd2.Parameters.AddWithValue("@lst_mod_dt", "");
                    cmd2.Parameters.AddWithValue("@ERR_CODE", 0);
                    cmd2.Parameters.AddWithValue("@ERR_MSG", 0);
                    cmd2.Parameters.AddWithValue("@TABLE_NAME", "");
                    cmd2.Parameters.AddWithValue("@batch_status_msg", "");
                    //cmd2.CommandText = @"select batch_name, batch_status_flg from camr_batch_control";
                    try
                    {
                        conn.Open();
                        SqlDataAdapter dapt = new SqlDataAdapter(cmd2);
                        dapt.Fill(ds5);
                            for (int z = 0; z < comboBox1.Items.Count; z++)
                            {
                                for (int a = 0; a < ds5.Tables[0].Rows.Count; a++)
                                {
                                    if (comboBox1.Items[z].ToString() == ds5.Tables[0].Rows[a][0].ToString())
                                    {
                                        comboBox1.Items.Add(comboBox1.Items[z] + " - " + ds5.Tables[0].Rows[a][1].ToString());
                                        comboBox1.Items.Remove(comboBox1.Items[z]);
                                    }
                                } 
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                        if (lblerror.Text == "")
                        {
                            lblerror.Text = ex.Message;
                        }
                        else
                        {
                            lblerror.Text = lblerror.Text + ex.Message;
                        }
                    }
                    finally
                    {
                        conn.Close();
                        conn.Dispose();
                    }

One possible cause is, your query isn't returning any data.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.