How Do I Bind Dataset To Datagrid In A Foreach Loop

Question

1.00/5 (1 vote)

See more:

Hello house,

Please does anyone know how to bind dataset to datagrid in a foreach loop? i have tried something like this:

C#

foreach ( long k in listAttributeRegion )
                    {
                        var dataId = k;

                        try
                        {

                            using ( var strCon = new SqlConnection( ConfigurationManager.ConnectionStrings["edms"].ConnectionString ) )
                            {
                                using ( var com = new SqlCommand( "Select l.AttrID , l.ValStr from csowner.LLAttrData l join csowner.dtree d on  ID = d.DataID where d.DataID = @DataID order by l.AttrID asc", strCon ) )
                                {
                                    com.CommandType = CommandType.Text;
                                    // command.Parameters.Add( "@SelectOption", SqlDbType.VarChar, 25 ).Value = "staffLastname";
                                    com.Parameters.Add( "@DataID", SqlDbType.Int ).Value = 56059;
                                    using ( var adapter = new SqlDataAdapter( com ) )
                                    {
                                        //DataSet ds;
                                        using ( var ds = new DataSet( ) )
                                        {
                                            try
                                            {
                                                adapter.Fill( ds );

                                                dataGridView1.DataSource = ds.Tables[0];
                                            }
                                            catch ( Exception ex )
                                            {

                                                MessageBox.Show( ex.Message );
                                            }

                                        }
                                    }
                                }
                            }
                        }
                        catch ( SqlException ex )
                        {
                            // log.Error( ex.Message + "\r\n\r\n " + ex.StackTrace );
                            MessageBox.Show( ex.Message );
                        }
                    }


                    reader.Close( );
                    //Console.ReadKey( );
                }
            }
            catch ( Exception ex )
            {
                MessageBox.Show( ex.Message );
            }

But it is not working! any assistance will be appreciated. Thanks in advance.

Posted 23-Jun-14 5:11am

Uwakpeter

Add a Solution

Comments

Bitla Phanindra 23-Jun-14 11:38am

What error are you getting?

Uwakpeter 23-Jun-14 11:55am

Not error message, it went into an endless loop, but if i step through it, i could see the result set for each dataid in the ds and datasource.

Bitla Phanindra 23-Jun-14 12:03pm

The foreach you have at the top might be causing the issue.

Uwakpeter 23-Jun-14 12:06pm

i felt i needed the foreach loop there so i could iterate through each item in the list and pass to the parameter in the select statement. Or is there any other way i could handle this? Thanks

1 solution

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)

DamithSL · Accepted Answer · 2014-06-23T06:34:00

create one sql statement which return all the data you want.

C#

string sql = string.Format("Select l.AttrID , l.ValStr from csowner.LLAttrData l join csowner.dtree d on  ID = d.DataID where d.DataID in ({0}) order by l.AttrID asc", string.Join(",", listAttributeRegion));
using (var strCon = new SqlConnection( ConfigurationManager.ConnectionStrings["edms"].ConnectionString ) )
using (var com = new SqlCommand(sql, strCon))
using (var adapter = new SqlDataAdapter( com ))
{
   var ds = new DataSet();
   adapter.Fill(ds);
   dataGridView1.DataSource = ds.Tables[0];

}