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

Re: How to edit Dataset value (NOT DATA GRID)

kstls4-Aug-09 0:25

4-Aug-09 0:25

would it be ok to do it with you sql statement.
In that case you could do:

Select name, adress, age / 2 as age
from [yourdbname]

Re: How to edit Dataset value (NOT DATA GRID)

sacr834-Aug-09 1:42

sacr83

4-Aug-09 1:42

Thank you for you reply .....But i had a problem when i going to DataBind.

this is the error..

GridView1.DataBind(); //------ error - A field or property with the name 'age' was not found on the selected data.

But i correctly configured on GridView1.I use a BoundField to view this 'age' with DataField='age'on my GridView1 control..

Why i got this error..????

CheeN

Re: How to edit Dataset value (NOT DATA GRID)

sacr834-Aug-09 1:47

sacr83

4-Aug-09 1:47

hey i fixed that prob...thank you bude rly thank......

CheeN

Re: How to edit Dataset value (NOT DATA GRID)

kstls4-Aug-09 2:14

kstls

4-Aug-09 2:14

My pleasure. Glad i could help

Re: How to edit Dataset value (NOT DATA GRID)

Fired.Fish.Gmail4-Aug-09 1:36

Fired.Fish.Gmail

4-Aug-09 1:36

You can create new coloum that age value is divied by 2, and delete the old age column and set the new column's name to "age"

Re: How to edit Dataset value (NOT DATA GRID)

sacr834-Aug-09 2:01

sacr83

4-Aug-09 2:01

Thank you friend..i fixed that problem.using follwing codes

string result="select name,address,age/2 as nAge";

On my GridView1 I set my DataField ='nAgew'

Then its all right...

Thank you all of you to Guide me to fixed that problem....

CheeN

Re: How to edit Dataset value (NOT DATA GRID)

vinodkrebc4-Aug-09 2:20

vinodkrebc

4-Aug-09 2:20

You can change it very easily
suppose you have the dataset ds
Then
ds.Tables[0].rows[2].columns[2]="Your New Value";

Thank you

Vinod Kumar Prajapati
Software Engineer
EBC Publishing Pvt. Ltd.

Change the EditedFormattedValue of a cell in a DataGridView

RobScripta3-Aug-09 23:51

RobScripta

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

Re: Change the EditedFormattedValue of a cell in a DataGridView

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

RobScripta

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

Re: Change the EditedFormattedValue of a cell in a DataGridView

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

RobScripta

4-Aug-09 1:01

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

Rob

Re: Change the EditedFormattedValue of a cell in a DataGridView

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

RobScripta

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

Re: Change the EditedFormattedValue of a cell in a DataGridView

RobScripta4-Aug-09 0:51

RobScripta

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

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

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

stancrm

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.

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

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

Re: Class/Control Document File Viewer

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

Re: Class/Control Document File Viewer

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

Re: Class/Control Document File Viewer

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

Re: Class/Control Document File Viewer

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

convert video to flash format

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#

Re: convert video to flash format

stancrm3-Aug-09 23:38

stancrm

3-Aug-09 23:38

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

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.