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

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.

[Hasankhan]

Hi

Sir
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

I am trying open the link you have given is not opening.
it says page not found. please help.

http://members.shaw.ca/gtexmo/Code/C...ColumnDivider/



Thanks
Hasan

@GaryTexmo

[GaryTexmo]

Interesting coincidence... I checked this forum after a long break, roughly 1 hour after you posted that haha.

I recently changed ISPs so all my links to my old web space are no longer valid. Fortunately I made a backup. Here is an archive with the files you're looking for.

[Hasankhan]

Thanks a lot you have solved my problem

May be it was my lucky day

Just one more Thing how do i use SQLServer data in place of temporary data.

thanks



@GaryTexmo

[Hasankhan]

Just one more Thing how do i use SQLServer data in place of temporary data.

Thanks

Interesting coincidence... I checked this forum after a long break, roughly 1 hour after you posted that haha.

I recently changed ISPs so all my links to my old web space are no longer valid. Fortunately I made a backup. Here is an archive with the files you're looking for.

[GaryTexmo]

By temporary data, you mean the DataTable I created in the constructor? You should just be able to query your SQLServer and it should return a DataSet for you. I believe there should be a DataAdapter object (probably SQLDataAdapter) that you can set up with a command or connection. Executing it will return a DataSet with the results in it. If you're just doing a simple query, the DataSet will contain a single DataTable (assuming it was successful) and that's all the input you require.

Hopefully that answers your question :)

[Hasankhan]

Thanks

Sorry for bad English.

I did so but I am confuse how do I replace dcValue(dataColumn) with my table Column.


Please have a look to my code. if I run it throws error Column '' does not belong to table.

Please Help

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Configuration;
 
namespace RS.Forms
{
    public partial class Form2 : Form
    {
         DataTable dtMain = new DataTable();
         DataColumn dcValue = new DataColumn();
        public Form2()
        {
            InitializeComponent();
 
            string conStr = ConfigurationManager.ConnectionStrings["RS.Properties.Settings.RS2012ConnectionString"].ConnectionString.ToString();
            SqlConnection connection = new SqlConnection(conStr);
            string com = string.Format("SELECT ItemName From Item");
 
            SqlCommand command = new SqlCommand(com, connection);
            connection.Open();
 
            command.CommandType = CommandType.Text;
            DataSet ds = new DataSet();
            command.CommandText = com;
            SqlDataAdapter adapter = new SqlDataAdapter(com, connection);
            adapter.Fill(ds);
 
            dtMain = ds.Tables[0];
 
              for (int i = 0; i < dtMain.Rows.Count; i++)
                {
                    DataRow dr = dtMain.NewRow();
                    dr[dcValue] = i;
                    dtMain.Rows.Add(dr);
                }
                dataGridView1.DataSource = DivideColumn(dtMain, dcValue, 15);
            }  
 
 
 
 
        public DataTable DivideColumn(DataTable source, DataColumn column, int rowsPerColumn)
        {
            DataTable retTable = null;
 
            if (source != null && source.Columns.Contains(column.ColumnName) && source.Rows.Count > rowsPerColumn)
            {
                string baseColName = column.ColumnName;
                int numCols = (int)Math.Ceiling((double)source.Rows.Count / (double)rowsPerColumn);
 
                if (numCols > 0)
                {
                    retTable = new DataTable();
                    for (int i = 0; i < numCols; i++)
                    {
                        DataColumn newCol = new DataColumn(string.Format("{0}{1}", baseColName, i));
                        retTable.Columns.Add(newCol);
                    }
 
                    // Copy width-wise
                    //for (int i = 0; i < source.Rows.Count; i += numCols)
                    //{
                    //    DataRow dr = retTable.NewRow();
 
                    //    for (int j = 0; j < numCols; j++)
                    //    {
                    //        dr[baseColName + j.ToString()] = dtMain.Rows[i + j][column];
                    //    }
 
                    //    retTable.Rows.Add(dr);
                    //}
 
                    // Copy length-wise
                    for (int i = 0; i < rowsPerColumn; i++)
                    {
                        DataRow dr = retTable.NewRow();
 
                        for (int j = 0; j < numCols; j++)
                        {
                            int sourceCell = i + (j * rowsPerColumn);
                            if (sourceCell < source.Rows.Count)
                            {
                                dr[baseColName + j.ToString()] = dtMain.Rows[sourceCell][column];
                            }
                        }
 
                        retTable.Rows.Add(dr);
                    }
                }
            }
 
            return retTable;
        }
 
 
 
 
 
    }
}
 
//-------------------------------------------------------

By temporary data, you mean the DataTable I created in the constructor? You should just be able to query your SQLServer and it should return a DataSet for you. I believe there should be a DataAdapter object (probably SQLDataAdapter) that you can set up with a command or connection. Executing it will return a DataSet with the results in it. If you're just doing a simple query, the DataSet will contain a single DataTable (assuming it was successful) and that's all the input you require.

Hopefully that answers your question :)

[Hasankhan]

Sorry to bother u and for reposting my comment. I did not know that there is holiday in Canada.
I thought you did not receive so I reposted it.

Thanks
Hasan

[GaryTexmo]

Please don't repost your entire comment just to bump it. It was a holiday weekend in Canada so I wasn't checking the thread.

For your question, please read and understand what the code does. The variable, dcValue, is just the column I created for the purposes of your example. If your data table has a different column you want to split with, use that instead.

You don't need to construct dtMain... your adapter.Fill already gets you the dataset, so just pick the table you want and go from there. I think you can reference columns by names as well (look at DataTable.Columns["COLUMN_NAME"]).

[Hasankhan]

Thanks Alot
Mr. GaryTexmo

Finaly its working its all because of you,
you are great.

Thanks again
Hasan