dataGridView -- Grid not pulling in data

Question

0.00/5 (No votes)

See more:

The data from my SQL statement is not getting into the grid, even though I can see that three records are getting returned. I use this block of code in another application and it works just fine, I can pull the query out and run it in SSMS and see the three records that are to be returned here. Could someone please point out what I am doing wrong, I am just not seeing it.

Error Message:
System.ArgumentOutOfRangeExce
{"Index was out of range. Must be non-negative and less than the size of the collection.\r\nParameter name: index"}

C#

namespace BackFill_WinForm
{
    public partial class Form_FixReceiverLabel : Form
    {
        private BindingSource bindingSource1 = new BindingSource();
        private SqlDataAdapter dataAdapter = new SqlDataAdapter();
        public string xConnection = ""

        private void GetData(string selectCommand)
        {
            // Connection string
            String connectionString = xConnection;

            // Create a new data adapter based on the specified query.
            dataAdapter = new SqlDataAdapter(selectCommand, connectionString);

            //Create a command builder to generate SQL commands based on selectCommand.
            SqlCommandBuilder commandBuilder = new SqlCommandBuilder(dataAdapter);

            // Populate a new data table and bind it to the BindingSource.
            DataTable table = new DataTable();
            table.Locale = System.Globalization.CultureInfo.InvariantCulture;
            dataAdapter.Fill(table);
            bindingSource1.DataSource = table;

            // Resize the DataGridView columns to fit the newly loaded content.
            dataGridView2.AutoResizeColumns(
                DataGridViewAutoSizeColumnsMode.AllCellsExceptHeader);
            GridCount = dataGridView2.RowCount;

            if (this.dataGridView2.RowCount == 0)
            {
                MessageBox.Show("Error: No data found.");
                return;
            }

            dataGridView2.Columns[0].HeaderText = "Item Number";
            dataGridView2.Columns[0].Width = 50;

            dataGridView2.Columns[1].HeaderText = "Receiver";
            dataGridView2.Columns[1].Width = 80;

            dataGridView2.Columns[2].HeaderText = "Part Number";
            dataGridView2.Columns[2].Width = 200;

            dataGridView2.Columns[3].HeaderText = "Lot Number";
            dataGridView2.Columns[3].Width = 90;


            // Add a column for the select button . 
            DataGridViewButtonColumn buttonColumn =
                new DataGridViewButtonColumn();
            buttonColumn.HeaderText = "";
            buttonColumn.Name = "Status Request";
            buttonColumn.Text = "Select";
            buttonColumn.UseColumnTextForButtonValue = true;
            buttonColumn.DefaultCellStyle.BackColor = Color.DodgerBlue;
            buttonColumn.DefaultCellStyle.SelectionBackColor = Color.Yellow;

            dataGridView2.Columns.Add(buttonColumn);
        }

        private void GetReceiver()
        {
            GetData("SELECT " +
                    "  ISNULL(Rtrim(rcitem.fitemno),'') AS Item_number  " +
                    " ,ISNULL(Rtrim(rcitem.freceiver),'') AS Receiver " +
                    " ,ISNULL(Rtrim(rcitem.fpartno),'') AS Part_Number " +
                    " ,ISNULL(Rtrim(rclotc.fclot),'') AS Lot_number " +
                    " FROM  " + 
                    "  RCITEM_EXT  " +
                    "     INNER JOIN rcitem ON RCITEM_EXT.FKey_ID = rcitem.identity_column " + 
                    "     LEFT OUTER JOIN rcmast ON rcitem.freceiver = rcmast.freceiver " +
                    "     LEFT OUTER JOIN rclotc ON rcitem.freceiver + rcitem.fitemno  = fcrcitmkey " +
                    " 	LEFT OUTER JOIN inmastx ON rcitem.fpartno = inmastx.fpartno AND rcitem.fpartrev = inmastx.frev " +
                    " WHERE (rcitem.freceiver = '" + TextBox_Reciver.Text + "')");
        }
   }
}

Posted 31-Dec-14 11:31am

Daniel 1102

Updated 31-Dec-14 11:42am

v2

Add a Solution

2 solutions

Solution 1

By observing this working code I've found that everything of your code is correct except that in the form load event or any other time you should set the property AutoGenerateColumns of your dataGridView to "true"

C#

dataGridView2.AutoGenerateColumns = true;

The Complete code is given below observe and fix yours

C#

public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void btnLoad_Click(object sender, EventArgs e)
        {
            DataTable dt = new DataTable();
            DataColumn dc = new DataColumn("EmployeeID", typeof(int));
            DataColumn dc1 = new DataColumn("EmployeeName", typeof(string));
            dt.Columns.Add(dc); dt.Columns.Add(dc1);
            DataRow row = dt.NewRow();

            row["EmployeeID"] = 100;
            row["EmployeeName"] = "ANIS";

            dt.Rows.Add(row);

            row = dt.NewRow();
            row["EmployeeID"] = 101;
            row["EmployeeName"] = "SUMON";

            dt.Rows.Add(row);

            bindingSource1.DataSource = dt;

            DataGridViewButtonColumn buttonColumn =
                new DataGridViewButtonColumn();
            buttonColumn.HeaderText = "";
            buttonColumn.Name = "Status Request";
            buttonColumn.Text = "Select";
            buttonColumn.UseColumnTextForButtonValue = true;
            buttonColumn.DefaultCellStyle.BackColor = Color.DodgerBlue;
            buttonColumn.DefaultCellStyle.SelectionBackColor = Color.Yellow;

            dataGridView1.Columns.Add(buttonColumn);
            


            
        
        }

        private void Form1_Load(object sender, EventArgs e)
        {
           
            dataGridView1.AutoGenerateColumns = true;
        }
    }

Posted 31-Dec-14 18:15pm

Anisuzzaman Sumon

Comments

Daniel 1102 2-Jan-15 19:21pm

Thank you for taking the time to help me trouble shoot the problem, but adding the “dataGridView1.AutoGenerateColumns = true;” to the Form1_Load did not resolve it.

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)

Sisir Patro · Accepted Answer · 2015-01-01T21:47:00

Solution 2

Hi,

I can see you are creating the BindingSource but you are not assigning the BindingSource to the dataGridView. You have to use the following line to bind the datasource to the grid.

dataGridView2.DataSource = bindingSource1;

Add this line and your grid will be binded with the data that you are populating from database.

Thanks
Sisir Patro

Posted 1-Jan-15 21:47pm

Sisir Patro

Comments

Daniel 1102 2-Jan-15 19:22pm

Adding the line of code you suggested fixed the issue I was having with the grid not showing up. Thanks for your help.

[no name] 6-Jan-15 6:58am

Great... Enhoy coding bro...