Re: Change the EditedFormattedValue of a cell in a DataGridView - C# Discussion Boards

Re: Change the EditedFormattedValue of a cell in a DataGridView

3-Aug-09 23:51

Hello,

I have a bound DataGridView with one of the columns bound to a date field. If date is entered as 31-08-2009 everything works fine, but user wants to fill in the date as 31082009 (European format).

On the cell leave event I have:

if (this.dgvInvoice.Columns[e.ColumnIndex].Name == "DateColumn")
{
string DateText = this.dgvInvoice.Rows[e.RowIndex].Cells["DateColumn"].EditedFormattedValue.ToString();

try
{

this.dgvInvoice.Rows[e.RowIndex].Cells["DateColumn"].Value =
customfunction(DateText);

}
catch
{
this.dgvInvoice.Rows[e.RowIndex].Cells["DateColumn"].Value = DateTime.Today;
}
}

}

The customfunction returns a date like 31-08-2009. The try goes well, but still I have an exception that it's not a valid DateTime.
The EditedFormattedValue is not writeable, and after I set the Value, the EditedFormattedValue is still the same.

How can I solve this ?

Thanks in advance.

Rob

Hristo-Bojilov4-Aug-09 0:27

Hristo-Bojilov

4-Aug-09 0:27

Hi Rob!
It seems you use CellLeave event of the grid and alter leaving the event logic the value not always updates correctly.This event is fired when cell lose its focus,not when it was edited by the user.You would better use CellEndEdit event.

Re: Change the EditedFormattedValue of a cell in a DataGridView

RobScripta4-Aug-09 0:45

Re: Change the EditedFormattedValue of a cell in a DataGridView

4-Aug-09 0:45

Alas, the exception about a bad date is thrown before the endedit event is raised.

Any other suggestions ?

Thanks,

Rob

Hristo-Bojilov4-Aug-09 0:57

Hristo-Bojilov

4-Aug-09 0:57

What kind of DataSource are you using for your grid?
Is it DataTable or someone else?

Re: Change the EditedFormattedValue of a cell in a DataGridView

RobScripta4-Aug-09 1:01

Re: Change the EditedFormattedValue of a cell in a DataGridView

4-Aug-09 1:01

It's a datatable. The specific column is a date field in the datatable.

Rob

Hristo-Bojilov4-Aug-09 1:35

Hristo-Bojilov

4-Aug-09 1:35

I think this have to solve your problem :

private void Grid_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
   {
       if (this.dgvInvoice.Columns[e.ColumnIndex].Name == "DateColumn")
       {
           try
           {
               e.Value=customfunction(e.Value);
           }
           catch
           {
               e.Value = DateTime.Today;
           }
       }

       e.ParsingApplied = true;
   }

Cheers!

Re: Change the EditedFormattedValue of a cell in a DataGridView

RobScripta4-Aug-09 2:28

Re: Change the EditedFormattedValue of a cell in a DataGridView

4-Aug-09 2:28

Thanks for your efforts, I gave a thumbs up.
Unfortunately the parse event didn't give the desired results either.

I've solved the problem by making an extra unbound text column, hiding the date column, and on the validating event from the new unbound text column the hidden "real" date column is filled.

It's not pretty but it works.

Rob

RobScripta4-Aug-09 0:51

How to compare the text in two files using c#?

4-Aug-09 0:51

To test the events, I tried the dataerror event, but with no luck, I can catch the exception (which is ugly), but the value doesn't write through to the EditedFormattedValue.

so still looking for a solution.

Rob

svt gdwl3-Aug-09 23:46

svt gdwl

3-Aug-09 23:46

Consider that there are two files named file1.txt and file2.txt.
file1.txt consists 50lines
file2.txt consists 50lines

Now I want to compare the text of two files taht to line by line,
I mean How can I compare 1st line of file1.txt with 1st line of file2.txt
similarly 2nd line of file1.txt with 2nd line of file2.txt, etc., till the last line

Re: How to compare the text in two files using c#?

stancrm4-Aug-09 0:01

Re: How to compare the text in two files using c#?

4-Aug-09 0:01

string[] file1 = File.ReadAllLines("file1.txt");
string[] file2 = File.ReadAllLines("file2.txt");

then use "for" to go through the array and compare it.

vinodkrebc4-Aug-09 2:25

vinodkrebc

4-Aug-09 2:25

You have to use StreamReader

Suppose you have Two streamreader objects
sr1 and sr2

while((str1=sr1.ReadLine())!="" &&(str2=sr2.ReadLine()))
{
if(str1!=str2)
//The Files Are different...
}

Vinod Kumar Prajapati
Software Engineer
EBC Publishing Pvt. Ltd.

Class/Control Document File Viewer

egpuyos3-Aug-09 23:44

egpuyos

3-Aug-09 23:44

Hi,

Is anyone can help me? please.
I have a small project that I need to view a certain document file in my program, example a .doc file.
Is there any class or a control that I can used to view this certain document?
You're help is appreciated.
Thanks in advance.

regards,
erson

dan!sh 4-Aug-09 1:12

dan!sh

4-Aug-09 1:12

RichTextBox might suit the needs.

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

egpuyos4-Aug-09 2:34

egpuyos

4-Aug-09 2:34

Is there a possibility that I can embed the text editor of the winword.exe? but only to view such a text and also the graphics, there is no menu and toolbar. Is that possible?

best regards,
erson

dan!sh 4-Aug-09 5:34

dan!sh

4-Aug-09 5:34

Have you checked the RichTextBox? It has a lot of features which you might like. As far as embedding the winword.exe is concerned you can start the process outside the application but no idea about embedding it.

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

convert video to flash format

egpuyos4-Aug-09 15:06

egpuyos

4-Aug-09 15:06

Thank you with this kind of information Smile | :)

It help my problem.

kind regards,
erson

RajaAhmed3-Aug-09 23:24

RajaAhmed

3-Aug-09 23:24

i would like to upload the videos in any format and convert it in .flv or swf formats using VS 2008....
is there any third party control available for asp.net/C#

stancrm3-Aug-09 23:38

http://sourceforge.net/projects/sharpffmpeg/[^]

3-Aug-09 23:38

RajaAhmed4-Aug-09 0:01

RajaAhmed

4-Aug-09 0:01

THANX stancrm
i have downloaded class library..
as i am new in the programming, can you plz help me out how to use it in my web page

thanks in advance

stancrm4-Aug-09 0:04

4-Aug-09 0:04

If you are new to programming, then buy a book, learn first C#, learn first something easy.
Video convertion is not so easy.

RajaAhmed4-Aug-09 0:06

RajaAhmed

4-Aug-09 0:06

not that new to buy a book
actually i havnt use any external library yet,

stancrm4-Aug-09 0:10

http://www.deitel.com/books/NET/AddingReferences.pdf[^]

4-Aug-09 0:10