How to save width of a column in a datagridview after changing the width of a column dynamically

Question

0.00/5 (No votes)

See more:

I want to save width of a column in a datagridview. I have written this code but I didn't get the correct output.

when we close a form the datagridview columns width will be saved.

Whenever we debug again and again it will show that column width as Saved column width

in the datagridview.

For that where should I write these code.

C#

DataTable dt = new DataTable(DG.Name);
            dt.Columns.Add("name");
            dt.Columns.Add("width");
            dt.Columns.Add("index");
            for (int i = 0; i < DG.Columns.Count; i++)
            {
                DataRow dr = dt.NewRow();
                dr["name"] = DG.Columns[i].Name;
                dr["width"] = DG.Columns[i].Width;
                dr["index"] = DG.Columns[i].DisplayIndex;
                string name = "";
                int width, index;
                name = dr["name"].ToString();
                width = Convert.ToInt32(dr["width"].ToString());
                index = Convert.ToInt32(dr["width"].ToString());
                Details_Grid.Columns[i].Width = width;
            }

Would u please suggest me correct code

Posted 12-Oct-14 17:56pm

TarunKumarSusarapu

Updated 12-Oct-14 19:13pm

v3

Add a Solution

Comments

ashok rathod 13-Oct-14 0:17am

what is not working ?

[no name] 13-Oct-14 0:18am

have you tried debugging? I think you are missing a code for adding that particular row to that data table.
dt.rows.add(dr). After do this, try to loop through again.

Sergey Alexandrovich Kryukov 13-Oct-14 0:36am

Not clear. Save where and why?
—SA

TarunKumarSusarapu 13-Oct-14 1:14am

when we close a form the datagridview columns width will be saved.

Whenever we debug again and again it will show that column width as Saved column width

in the datagridview.

For that where should I write these code.

Sinisa Hajnal 13-Oct-14 2:19am

You didn't answer: Save WHERE? There is no persistent storage (database?) in your code. There is an event ColumnWidthChanged or some such.

TarunKumarSusarapu 13-Oct-14 2:52am

Here we should not use database for saving the column width it automatically saves and after re debugging also it shows same width

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)

Mycroft Holmes · Answer 1 · 2014-10-12T22:26:00

Solution 1

You are getting the column widths correctly, placing them in a new datarow in a new datatable but you are not persisting the information between sessions(every time you start debug).

What you need to do is PERSIST the data, if you won't use a database then you need to write it to the local users hard drive. Then when the session starts READ that information and format the column widths. I would not use the index as the user may be able to reorder the columns.

Here is an article [^]where I store and read the forms states.

Posted 12-Oct-14 22:26pm

Mycroft Holmes

Comments

TarunKumarSusarapu 13-Oct-14 4:46am

Would u please tell me how to use local users database

Mycroft Holmes 13-Oct-14 4:55am

What database are you using for the local storage (I don't think you know). I would use an XML file, read the article it has example and code.

TarunKumarSusarapu 13-Oct-14 5:20am

Here Have u taken empty xml file or adding any columns

TarunKumarSusarapu 13-Oct-14 5:23am

Would u please explain breifly what should I do