How to save formatted DataGridView cells in database?

Hi Amit,

 

my main concern is to give a user to make all the changes according to his/her preference.

I mean, if you like 'Tahoma' you'll prefer as the name will print/show in Tahoma and if I like 'Arial' I'll choose it as print/show the name in Arial.

 

the form in which the user will choose the font and style etc. I found a DGV the best option to do so. the changes will be save in a table and at the time of report the data will be fetched from the same table.

 

meanwhile, I have found something on net to save the cell formatting details to the dt. it's working but I am facing some bugs in it. I am working on it.

there is one DGV having one column and seven rows

//first I get details of each row formatting....

var NameSize = dgvPrintSettings.Rows[0].Cells[0].Style.Font.Size;
var NameBold = dgvPrintSettings.Rows[0].Cells[0].Style.Font.Bold;
var NameItalics = dgvPrintSettings.Rows[0].Cells[0].Style.Font.Italic;
var NameUnderline = dgvPrintSettings.Rows[0].Cells[0].Style.Font.Underline;

//then for second row

var NameSize = dgvPrintSettings.Rows[1].Cells[0].Style.Font.Size;
var NameBold = dgvPrintSettings.Rows[1].Cells[0].Style.Font.Bold;
var NameItalics = dgvPrintSettings.Rows[1].Cells[0].Style.Font.Italic;
var NameUnderline = dgvPrintSettings.Rows[1].Cells[0].Style.Font.Underline; 

 

then update query for each var.

I think this is a long process but I get result out of it. the data get saved to dt but the problem is I have to select all the cells (one by one) and change format of everyone. if not, I get error 'Object reference not set to an instance of an object.'

trying to solve this error.

 

could you please send test mail to [email protected]?

 

Thank You

 

Mayank Jani

If this was the scenario, I suggest you to do this in a more concise way instead of saving all different fonts

 

1. Create a global form that saves for your font for name, notes etc instead allowing user to do in each cell.

 

2. On crystal report, design that and load the fonts to the report from global form. 

 

3. That's it.

 

Do let me know if you require any clarification 

Dear Laxmidhar,

Thanks but my problem is how to do that? 

Hi Amit,

Greetings of the day...

Nice to see you again...

 

I understood you point. I want to add these formats into crystal report. all these formatting are to be done in a different page (say... Admin form) and will be reflacted in a crystal report or print. such as name to be printed in Arial, some reminders to be printed in Times New Roman, Notes to be printed in some other font which are already set in Admin form.

 

I have created a table to save all these fields like font, size, bold or italics etc. the Items (Name, Address, Notes, Reminders etc.) come from a datatable and I want to save the formatting details (Name=bold, underline, Notes=Times, 12, Italics etc.) to the same datatable so I can use the details at the time of report creation or print.

 

If you want to know any other details please write back...

I hope I have described properly.

 

Thank You

 

Mayank Jani

Hey

 

The thing you are asking has a broad answer. Although I am unaware of why you are doing these such things inspite you can color based on some condition instead formatting each cell by different font. (If user deleted that font then your program not perform well in that condition).

 

Elaborate your condition so that one can give you optimized way to solve. 

Hi Sagar,

thanks for reply...

 

that I know, how to save dgv values to the database. my problem is how to save the formatted values. suppose, in the first row I have text "Sunday", the word is formatted with font dialoge box and assigned font as Times New Roman, bold, size 13 and with underline. now how to save all these details to the datatable? next when I reopen the form I get exact "Sunday" what I have been formatted.

and how to save all the rows with formatted values.

 

Thank You

Mayank Jani

Hi,

Refer below links :-

 

https://www.aspsnippets.com/Articles/Insert-Save-Selected-Checked-rows-from-DataGridView-to-Database-in-Windows-Forms-WinForms-Application-using-C-and-VBNet.aspx

https://www.codeproject.com/Articles/12846/Auto-Saving-DataGridView-Rows-to-a-SQL-Server-Data

https://stackoverflow.com/questions/26161682/how-to-save-datagridview-cell-style-to-database

 

Hope it helps....