Re: updating data from datagridview - C# Discussion Boards

1-Jun-09 23:34

[Message Deleted]

monstale1-Jun-09 23:35

1-Jun-09 23:35

STOP POSTING THE SAME, please

ahmed mega2-Jun-09 2:37

updating data from datagridview

2-Jun-09 2:37

sorry for that, my connection was interrupted
which caused this fault.

sorry again

ahmed mega1-Jun-09 23:13

1-Jun-09 23:13

hello every body,

i use a datagrid view bounded to a datasource, but i can't update the changes happens in it.
although, i've added the insert, update & delete queries i also use a dataset with a tableAdapter .

and this what iam doing in the onSaveButton_Click:

try
{
dataGridView1.EndEdit();
this.visitorTableAdapter.Update(this.omvDataSet.visitor);
omvDataSet.AcceptChanges();
MessageBox.Show("Changes saved successfully");
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
so, what is the right solution to accomplish what i want.

Regards

monstale1-Jun-09 23:31

1-Jun-09 23:31

hi,

what's wrong now? code looks good, but you don't need to .AcceptChanges() because .Update() does it for you. Wink | ;-)

kind regards

ahmed mega2-Jun-09 2:43

2-Jun-09 2:43

ok i removed .AcceptChanges()
now i tried to delete then i had this exception:
Update requires a valid DeleteCommand when passed DataRow collection with deleted rows.

regards

monstale2-Jun-09 3:15

2-Jun-09 3:15

Hi,

are you sure you filled all commands of DataAdapter? There are InsertCommand, UpdateCommand, DeleteCommand and SelectCommand (last is filled by constructor, normally). Wink | ;-)

King regards

ahmed mega3-Jun-09 5:23

Installing Windows assembly in GAC

3-Jun-09 5:23

Hi,

yes i did filled these commands by the dataset designer but, i found that i have to add them into the properties window by myself and now it's working.

thanks for your help, i really appreciate it.

Regards

AmmySA1-Jun-09 23:12

AmmySA

1-Jun-09 23:12

Hi to all

I am trying to add windows assembly to the GAC using the following command in the command prompt.

C:\Program Files\Microsoft Visual Studio 8\VC>gacutil /i C:\WINDOWS\system32\odb
c32.dll

But it is not being install and I am getting the following error.

"Failure adding assembly to the cache: The module was expected to contain an assembly manifest."

I am not getting the reference of the assembly neither in the .NET Assembly nor in the COM objects.

Can anyone tell me how can I install this assembly in the GAC.

Thanks in advance

Amit

monstale1-Jun-09 23:34

1-Jun-09 23:34

hi,

did you sign your assembly? Project Properties --> Signing --> Sign the assembly Wink | ;-)

kind regards

Luc Pattyn2-Jun-09 1:45

Luc Pattyn

2-Jun-09 1:45

Hi,

why would you want that? the GAC is for managed code DLLs only, odbc32.dll is a native code DLL, it is fine where it is.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

0x3c02-Jun-09 2:29

0x3c0

2-Jun-09 2:29

Luc Pattyn wrote:
why would you want that?

It doesn't match the curtains

Between the idea
And the reality
Between the motion
And the act
Falls the Shadow