C# Discussion Boards - CodeProject

MrJJKoolJ11-Jun-04 8:33

11-Jun-04 8:33

I am getting an InvalidOperationException with a message of "Insert". That's it, pretty useless message. Only hints that it didn't like my Statement for update command I guess. I am using a diffgram dataset to update database.

JJ

Re: Update to DB Failure

Heath Stewart11-Jun-04 8:49

Heath Stewart

11-Jun-04 8:49

If your DiffGram includes inserts, updates, and deletes, all the related properties on a DataAdapter must be assigned. So, if a row was updated and all you supplied was the InsertCommand, then you would see such an operation because the DataAdapter doesn't know how to update the data store.

Microsoft MVP, Visual C#
My Articles

Re: Update to DB Failure

MrJJKoolJ11-Jun-04 9:11

MrJJKoolJ

11-Jun-04 9:11

HI Heath,

That's what I thought too. So in the method that I use to update db. I assigned the Insert command to DataAdapter along with the Update command to DataAdapter. Now it runs but when I execute the DataAdapter update method. I get a new row in database instead of actually updating same row. When I update the datarow with values how do I tell the diffram dataset to go to update mode as well?

Here I find the datarow I want to update in dataset:

<br />
nRow2 = dsDiff.Tables["MidnightReadings"].Select(sRecFind);<br />

It finds it in dataset with no problem

Then I update datarow:

<br />
nRow2[0]["Coal_Feeder_Tot"] = tbCoalFeederTot.Text;<br />
				nRow2[0]["Coal_Silo_Level_Prct"] = tbCoalSiloPrct.Text;<br />
				nRow2[0]["Coal_Barn_Inv_Prct"] = tbCoalBarnInvPrct.Text;<br />
				nRow2[0]["Limestone_Feed_Total"] = tbLimeFeedTot.Text;<br />

I checked the dataset and changes are there but here is the status of row:

<br />
<MidnightReadings diffgr:id="MidnightReadings2" msdata:rowOrder="1" diffgr:hasChanges="inserted"><br />
<MR_Date>2004-06-10T00:00:00.0000000-04:00</MR_Date><br />
<Coal_Feeder_Tot>8789</Coal_Feeder_Tot><br />
<Coal_Silo_Level_Prct>95.5</Coal_Silo_Level_Prct><br />
<Coal_Barn_Inv_Prct>75.8</Coal_Barn_Inv_Prct><br />
<Limestone_Feed_Total>0</Limestone_Feed_Total><br />
<LS_Silo_Level_Prct>0</LS_Silo_Level_Prct><br />
...<br />

This dataset already exists in db but keeps inserting new records.

What am I missing?

Thanks,

JJ

Re: Update to DB Failure

Heath Stewart11-Jun-04 10:38

Heath Stewart

11-Jun-04 10:38

Make sure the row information contains a primary key so that the UpdateCommand can effectively use a WHERE clause so that the right row is updated.

Microsoft MVP, Visual C#
My Articles

Re: Update to DB Failure

MrJJKoolJ11-Jun-04 11:26

MrJJKoolJ

11-Jun-04 11:26

Hi Heath,

Ok really frustrated with trying to create a diffgram dataset.
I assume that I should first create a DataAdapter then build SqlCommand,InsertCommand, UpdateCommand for Adapter, Correct?
Next build parameters for each Commmand, Correct? After that I can then
Fill dataadapter, correct? Then I write my diffgram out to a file.

Does this sound like the correct approach to this?
After I do this I then take dataset and do inserts, updates etc. to
dataset. After done with this process I go back create a new dataadapter with whats mentioned above and call DataAdapter.Update.

What do you think? I did away with the webservice and have the create diffgram and database updates in a separate class.

Thanks,

JJ

Re: Update to DB Failure

Heath Stewart11-Jun-04 11:52

Heath Stewart

11-Jun-04 11:52

To call Fill, you only need the SelectCommand set. When you call DataAdapter.Update, however, you may need all four set depending on what changes have been made. After calling Update, though, there will be no changes because the DataAdapter then calls AcceptChanges on your DataSet or DataTable (whichever you passed in).

So, you really only need to write out a DiffGram (if that's really necessary) after you make changes, otherwise those won't be any differences.

Microsoft MVP, Visual C#
My Articles

Re: Update to DB Failure

MrJJKoolJ11-Jun-04 12:19

MrJJKoolJ

11-Jun-04 12:19

See I need the diffgram because this is a pda app that is only sometimes connected to DB. So I need a way to record data to pda then update the database when a connection can be made. So I thought the diffgram would be the easiest way to accomplish this.

JJ

Import a comma delimited text file to a access database

kornstyle11-Jun-04 7:31

kornstyle

11-Jun-04 7:31

I was wondering if it was possible to import a comma delimited text file into a access database using c#? If someone could help me out that would be great.

Thanks.

Re: Import a comma delimited text file to a access database

Heath Stewart11-Jun-04 8:30

Heath Stewart

11-Jun-04 8:30

Of course it's possible. Create an OleDbConnection to an MDB database file, then create an OleDbCommand from that with something like INSERT INTO MyTable VALUES(?, ?, ?, ...) for the CommandText. Then create an OleDbParameter for each ?.

Open the comma-delimited text file and split the strings on , (if you have other commas in the text, you'll need to do a little better job parsing taking quotes into account). For each line you read in and split, set the values of the OleDbParameters you created above and call OleDbCommand.ExecuteNonQuery (after opening your connection for the batch, of course). When you're done, close the connection.

Read about the OleDbConnection, OleDbCommand, and OleDbParameter in the .NET Framework SDK. If you have specific question, please don't hesitate to ask.

Microsoft MVP, Visual C#
My Articles

DataGridTextBoxColumn won't word wrap

holt11-Jun-04 6:05

holt

11-Jun-04 6:05

How can I get the text in a DataGridTextBoxColumn to word wrap by default? The text just extends off the end of my DataGrid on a single line, even if I set the word wrap property of the Column's TextBox to true. If I select a TextBox for editing, then it wraps, but only while selected.

E. Simmons

Re: DataGridTextBoxColumn won't word wrap

Heath Stewart11-Jun-04 6:27

Heath Stewart

11-Jun-04 6:27

The TextBox is only displayed when editing. When the text is displayed, it is simply drawn in the bounds and is clipped.

In order to word-wrap when displaying the text, you must extend DataGridTextBoxColumn and override Paint (the one with the most parameters, sine that's the one that's ultimately called) and GetMinimumHeight. When painting the string, make sure that StringFormatFlags.NoWrap is not set (negating the StringFormat.FormatFlags property with a bitwise AND), and set/unset anything else you want/don't want, including for other properties of the StringFormat.

The trick is that you have to use the Graphics object passed to Paint to call MeasureString, so that you can adjust the return value of GetMinimumHeight (since only enough for one line of text is displayed by default), but nothing that can't be done.

Microsoft MVP, Visual C#
My Articles

Re: DataGridTextBoxColumn won't word wrap

holt11-Jun-04 7:14

holt

11-Jun-04 7:14

Ahhhh, that works nicely. Thank you.

E. Simmons

C++ pointer char* in dll function - string in C#

SasaTod11-Jun-04 5:46

SasaTod

11-Jun-04 5:46

The function in unmanaged DLL get char* as parametar. When I try to use that function with (out) string parametar, program breaks. How to use that function?

Re: C++ pointer char* in dll function - string in C#

Heath Stewart11-Jun-04 6:22

Heath Stewart

11-Jun-04 6:22

A char* is a string - they're both already pointers. So, don't use out or ref with a string unless you see an unmanaged declaration like char** or LPCSTR* or something.

BTW, if the string is actually a TCHAR*, TCHAR[], or LP(C)TSTR, then make sure you specify CharSet.Auto. If the declaration is a char* or LP(C)STR, be sure to specify CharSet.Ansi since strings are Unicode in .NET natively. Both the DllImportAttribute and StructLayoutAttribute define a CharSet field you should set in the attribute in such a case.

Microsoft MVP, Visual C#
My Articles

Re: C++ pointer char* in dll function - string in C#

SasaTod11-Jun-04 9:29

SasaTod

11-Jun-04 9:29

If I pass only string as parametar program breaks with error message: "Object reference is not set to an instance of an object". Pass parremetar is char* type in dll.

Re: C++ pointer char* in dll function - string in C#

Heath Stewart11-Jun-04 10:40

Heath Stewart

11-Jun-04 10:40

And is the string set to something? Trust me, a char* is a string - in any language.

If the string is supposed to be an output parameter, do not use the out keyword but instead use the OutAttribute. This tells the marshaler that the parameter is an output parameter and will be assigned when the function returns.

Microsoft MVP, Visual C#
My Articles

Re: C++ pointer char* in dll function - string in C#

SasaTod12-Jun-04 3:25

SasaTod

12-Jun-04 3:25

If I understand you well, this is a solution for problem:

[DllImport("Kernel32.dll", CharSet=CharSet.Ansi)]
public static extern bool GetComputerName([Out,MarshalAs(UnmanagedType.LPTStr)] string f1, out int a2);
.
.
.
int v = 0;
string a = "";
if (GetComputerName(a, out v))
{
MessageBox.Show(a+" " + v);
}

But, this will not work???

Re: C++ pointer char* in dll function - string in C#

Heath Stewart12-Jun-04 4:31

Heath Stewart

12-Jun-04 4:31

You have that all wrong. The character set should be CharSet.Auto (since, like I said before, the string is LPTSTR), and the second parameter is documented as [in, out], which means you should use ref because you MUST pass the size of the string buffer, which is probably why you're getting the error (not to mention the wrong character set when using Windows NT (4.0, 2000, XP, 2003). The property signature is:

[DllImport("user32.dll", CharSet=CharSet.Auto)]
public static extern bool GetComputerName(string name, ref uint size);
 
// To call it...
uint size = 16; // MAX_COMPUTERNAME_LENGTH + 1
string name = new string('\0', (int)size);
GetComputerName(name, ref size);

You know what, though? You should browse the class library documentation and learn what's there. This P/Invocation is not necessary. Just use the Environment.MachineName property.

Microsoft MVP, Visual C#
My Articles

Re: Delete child in XML document while running an C# Application!

Heath Stewart11-Jun-04 5:29

Heath Stewart

11-Jun-04 5:29

Why can't you remove it? How are you trying to remove it? Please be more specific or we really can't help you with your problem.

Microsoft MVP, Visual C#
My Articles

Re: Delete child in XML document while running an C# Application!

QzRz11-Jun-04 5:34

QzRz

11-Jun-04 5:34

its because i have no idea how to remove it!
i tried...

i have a xml document called Data!

string id = listBoxSpil.SelectedItem.ToString().Substring(0,2);
//the value of id is 1
XmlNode remove = Data.SelectSingleNode("//food[@id='" + id + "']")
Data.RemoveChild(remove);

But it doesn't work Frown | :(

so if you can tell me a way to remove it please help me!

Re: Delete child in XML document while running an C# Application!

Heath Stewart11-Jun-04 5:43

Heath Stewart

11-Jun-04 5:43

First of all, make sure the id string is correct. When you call RemoveChild, you must call it on the XmlNode.ParentNode, because the XmlNode will most likely not be a child of the document (which only has one child - the root node, a.k.a. document element.

So, change Data.RemoveChild(remove) to remove.ParentNode.RemoveChild(remove) and it should work.

Microsoft MVP, Visual C#
My Articles

Re: Delete child in XML document while running an C# Application!

QzRz11-Jun-04 5:48

QzRz

11-Jun-04 5:48

heyY thanks man... it work now!!! Smile | :)

if there is anything i can do... just say it!

Surely this is an Easy Question...

Adam °Wimsatt11-Jun-04 4:56

Adam °Wimsatt

11-Jun-04 4:56

... But don't call me Sherly. I have a VS.NET 2002 project that uses a 1.1 Framework dll and it is giving me the StrongNameIdentityPermission error because it is looking at the MachineConfig for the 1.0 Framework. How do I get my project to the look at the 1.1 Framework Machine.Config?

Re: Surely this is an Easy Question...

Heath Stewart11-Jun-04 5:28

Heath Stewart

11-Jun-04 5:28

You mean you have an assembly compiled with VS.NET 2002? VS.NET 2002 will only work with the .NET Framework 1.0.

In order to read from the machine.config file you want, mscoree.dll must load the appropriate CLR. This is determined by the assembly publishing policy or the runtime configuration in the .config file. This will only work at runtime however.

Read about the Runtime Settings Schema[^] in the .NET Framework SDK, as well as Redirecting Assembly Versions[^], which may or may not apply depending on what you're trying to do.

Microsoft MVP, Visual C#
My Articles

Assembly Class Locking Issue

Daniel M. Edwards11-Jun-04 4:49

Daniel M. Edwards

11-Jun-04 4:49

I am using the Assembly.LoadFrom() method in my application to extract some information from some DLLs and I am running into a locking problem. Even after I am done with the file and have set the Assembly to null it keeps the file I loaded locked until the application terminates. The problem comes when I try and update the DLL with a new version automatically via the main application. I am unable to copy the newly downloaded version over because the file still reports as locked by Windows.

Does anyone know a way to tell the Assembly object to release it's hold on the file it loaded?

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