How can I access a file that's on the same physical network but on a differnet domain? Should I just specify the server?
I'll need differnet user credentials to login to that domain also.
My first post still stands, you'll need to set the update related commands to update. But looking at the error, it seems like there is a problem with your dataset. Can you include the code you used to create / load it?
It kinda looks like the data adapter is expecting a table named 'Table'...
My guess is that you're not providing the update command. You need to create a sqlCommandBuilder after you create the data adapter. Place this line right after the line you instanced the data adapter:
SqlCommandBuilder foo = new SqlCommandBuilder(adap);
You shouldn't have to do anything else...
I'm using c# and ADO.NET to create and write to an excel spreadsheet via the jet4.0 ole provider. Works great except that excel seems to be prepending every cell with an apostrophe! Here's some of my code:
//Create a new file
xlscnn.Open();
cmd.CommandText = "CREATE TABLE " + tablename + " ("...
You should always call dispose on the form when you get done using it. Calling dispose does not cause the GC to collect it anyways, the system decides that. If you don't call dispose and try to instance the form again to soon and with the same name you might get strange results.
Assume that you're working with a dataset that contains two tables, and these tables share a relationship.
Table1:
Column1 (PK) (AutoIncrement)
Cloumn 2
Table2:
ColumnA
ColumnB (foriegn key to table1.Column1)
How can you insert rows into table1, and insert related rows into table2 before...
This is a total shot in the dark but; one second sounds like an awful long time, are you processing something or establishing any kind of database connections in your form load?
If you are then all those routines must complete before the new form will paint. You should consider refactoring the...
I keep getting a 'Binary data would be truncated' error when I try to write large files to my image column, and the write does not occur. But there's only 2,158,080 bytes in the file I'm writing! I thought the image type could handle 2,147,483,647 bytes.
The app is VB.net, and I'm just putting...
I keep getting a 'Binary data would be truncated' error when I try to write large files to my image column, and the write does not occur. But there's only 2,158,080 bytes in the file I'm writing! I thought the image type could handle 2,147,483,647 bytes.
The app is VB.net, and I'm just putting...
I'm automating word and opening a document. I'm intercepting the word apps document save event and trying to insert my own code. Problem is that the app and word hang every time I do this.
BUT! If I set a break point in the event and just F8 through it then everything works just fine. It's...
I'm storing word docs as BLOB's on a sql server and automating word with .NET to open them. But I don't want to save the document every time the user closes it on the chance they changed something.
I know word stores this information somewhere but where?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.