Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Stat792

    File access across domains?

    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.
  2. Stat792

    Database Update error

    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'...
  3. Stat792

    Database Update error

    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...
  4. Stat792

    ADO export to Excel prepends all values with apostrophe?

    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 + " ("...
  5. Stat792

    How can I make a form load fresh?

    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.
  6. Stat792

    Multi table DataSet - Auto Increment question

    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...
  7. Stat792

    Smooth transitioning between forms

    Hmmm, have you tried showing the new form before hiding the old one?
  8. Stat792

    Smooth transitioning between forms

    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...
  9. Stat792

    Overflowing the Image Column on SQL 2000 server?

    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...
  10. Stat792

    OverFlowing an Image column?

    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...
  11. Stat792

    Word Automation keeps hanging when I intercept events?

    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...
  12. Stat792

    How can I progromatically tell if a word doc has changed?

    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?

Part and Inventory Search

Back
Top