DataGridView Multiple columns

JustRun

Hi,

suppose I have a table with one column in the database.
If I tried to display this table in a DataGridView it will be displayed in one vertical column.

I need to display this column in 3 or 4 columns in the gridview. but without repeating, just the data as it is in the DB table will be displayed in GV

Any help

GaryTexmo

Are you saying you want to break that single column in the database up into several columns in a DataGridView?

How do you want to break it up? Every x rows, or by the height of the form? Please let me know if I'm even understanding your problem correctly.

JustRun

Yeah, I want to break the single column in the database into several columns in the DataGridView, and I want to break them by the Height of the form

Thanks

GaryTexmo

Ok cool, that's what I thought but didn't want to assume.

Well, I'd imagine a good way to do this would be to load your data into another DataTable object in the way you want, then display that DataTable in your DGV object. You'll have to do some math to figure out the number of rows you'll want based on the DGV height, as well as update that if you want it to dynamically readjust itself if you resize the form. Also, remember that I believe you can resize the row height of a row in the DataGridView object.

Since the DGV is going to be displaying a different DataTable, you'll probably want to have events set up to reflect changes back into your original DataTable. You'll also need to make sure you're aware of how you map the new row/column representation back to the single column data in order to make sure you update the correct fields.

Does that seem reasonable? There might be a better way to do this... but I don't think there's any "automatic" way with DataGridView. I'll leave you with the general idea for you to try implementing, and if you have any questions, let me know.

JustRun

You know, I was afraid to tell me that there is no other way but the DataTable :) Thank you for ur quick reply,
Nice day

JustRun

I don't know how to do the select statement to separate the tables it, would u help

Expand|Select|Wrap|Line Numbers

 
public DataTable GetDataTable()

        {

            int scalar = GetProCount();

            dbModule.InitConnection();
 
            dbModule.cmd = new SqlCommand("SELECT ProName FROM ProductTable", dbModule.con);

            dbModule.adptr = new SqlDataAdapter(dbModule.cmd);

            dbModule.cmb = new SqlCommandBuilder(dbModule.adptr);
 
            DataSet ds = new DataSet();

            DataTable dt = new DataTable();
 
            try

            {

                    dt.Columns.Add("ProName", typeof(string));

                    dt.Columns.Add("الصنـــف2", typeof(string));

                    dt.Columns.Add("الصنـــف3", typeof(string));

                    dt.Columns.Add("الصنـــف4", typeof(string));

                    dt.Columns.Add("الصنـــف5", typeof(string));
 
                dbModule.adptr.Fill(dt);

            }

            catch (Exception ex)

            {

                MessageBox.Show(ex.Message.ToString());

            }

            dbModule.DestroyConnection();

            return dt;

        }

GaryTexmo

I'd say just do a select statement that gets the whole thing and then divide it up. That way all your data is still stored in a single place that is easy to work with, you only manipulate it for viewing/editing purposes.

I did up a quick example for you... it's basically the solution (I wanted to see if I was actually right, not just feeding you bad theories :P) so if you want to figure it out for yourself, don't look right away. Keep in mind that I'm hard coding the number of columns I'm dividing the source column into... for your solution, you'd pass whatever columns you found to be appropriate based on the height of the form.

http://members.shaw.ca/gtexmo/Code/C...ColumnDivider/
(Note, if you see any coding errors, please feel free to point them out. I did it rather quickly last night so I don't doubt that I may have made a mistake)

JustRun

Yeah, Thank you, There is no errors of course :)

Really Thank you, you helped me a lot.

DataGridView Multiple columns

re: DataGridView Multiple columns

re: DataGridView Multiple columns

re: DataGridView Multiple columns

re: DataGridView Multiple columns

re: DataGridView Multiple columns

re: DataGridView Multiple columns

re: DataGridView Multiple columns

Similar C# / C Sharp bytes

/bytes/development

/bytes/it

/bytes/about