When You run this proc, what the value of @ReferenceID?

Your Update method waiting for 1 record to be updated, but your update sp doesn't update any row. Check you sp manually, sent the same values by parameter and watch the results.

I need a help about this. I've made a program to import csv files. Sometimes I caught this error message "must be less than or equal to max (-1)", I've been search at google and I found some messages saying about DataTable.Select(), something about that. But I don't know why this error happens, if is the number of parameters or lenght of my csv files. The really problem is that error never happens at development time.

Hello Everybody I developed a console app that imports CSVs files to DataBase. Well, I need that app runs each 2 min, then I used SQL Server Agent to create a job to do that. But when my app raise a exception, the job can't recognize this error and enter in continuous process (looping). So the job can't execute next schedule. When app runs successful, the ExitCode == 0. See code belowtry { .... code Environment.ExitCode = 0; } catch(Exception e) { Environment.ExitCode = -1; process.Kill(); } finally { process.Close(); }

Yeah, something like this.. I created one user at pc01 and the same user at PC02 I impersonate my user at PC02 then I obtained to have access the protected folder in PC02 Tks 4all!!!! [:D]

Well I created a shared folder, and I created also a user in the same machine (aka Maq048) the user that was created is xmlowner, then I've a Maq048\xmlowner user. In the folder I set permission to Maq048\xmlowner (full control), and now I want access this folder across network and save a file. But I don't know how to authenticate this user by C# application.

Hello, tks for help. I tried to use this code, but I got a exception at this command DirectorySecurity ds = Directory.GetAccessControl(path); with message "Attempted to perform an unauthorized operation" Almost there..heheheeh

Hello everybody! I've a trouble and I can't solve :-( I've a PC with a local login/password shared folder and I need authenticate this user across winforms application to write a xml file. The question is, how do I authenticate this user? This user doesn't in AD group (is just a local user in machine).I need to do authentication manually. Somebody knows? Tks 4all!

The problem was solved :) Tks for all When I attached the mdf file, I needed attach it as Data File When I changed this option, everything works all right

Hello developers. I need a help with clickonce deployment. I my app it's has a *.mdf file, when I install my app the *.mdf goes to ...\Local Settings\Apps\2.0\... folder But the app's folder has a complex name, as app...ex3ynnnnnadiGGGfzzzsds Can I customize this name?

Hello I've a question about FormatConditions (Interop.Excel) I need sent to parameter a string empty value, however in execution mode, the app throw a exception "Additional information: The parameter is incorrect." See the code below: rng.FormatConditions.Add(XlFormatConditionType.xlCellValue,XlFormatConditionOperator.xlEqual,"",Type.Missing); How can I sent a empty string param? Thks all

For to get a different resx u can load from a file System.Resources.ResXResourceSet resxSet = new System.Resources.ResXResourceSet("C:\\..."); for to load Setting I can't remeber now:sigh:

What do u want? To create Nodes, Child Node?

How do u read the data from cells? Does the app always read first cell?

To get original row, include the original value ((DataRowView)DataGrid.BindingContext[DataSource].Current).Row["Column",System.Data.DataRowVersion.Original]

Sorry... But these days I'm in vocation Now I came back See the code below to open a Excel App. ApplicationClass excel = new Microsoft.Office.Interop.Excel.ApplicationClass(); Workbooks oBooks = excel.Workbooks; object nulo = System.Reflection.Missing.Value; //here u have open method, there's many parameteres, but they can be null. oBooks.Open("C:\\file.xls",nulo,false,nulo,nulo,nulo,nulo,nulo,nulo,true,nulo,nulo,nulo,nulo,nulo); //A _workbook where the sheet lives _Workbook b = oBooks.get_Item(1); ;P

;) Well, I'm going to send a example for you with copy for emails in the first post I'm from Brazil, I'm .net developer, my english is poor but I can communicate...:laugh:

Yes, is possible In your project you need add reference COM Microsoft Office XX Object Library where XX is the version of MSOffice that you'll work. The namespace is Microsoft.Office.Interop.Excel If you look in for this namespace you going to find many examples. Isn't too easy, but isn't impossible ;)

Do You basically going to manipulate a excel by .net application?

Thanks Allan But I can to close one window.... The problem is many windows.. I'm going to explain my app, when time expire I need to close all windows that are open, however, some of these windows are ShowDialog, when I execute the sample code above the only windows that are closed are the MDIChildren, however, ShowDialog windows not is MDIChild and therefore still open, I can't handle these. I don't know who is owner of theses windows ShowDialog() I'm tired..:laugh: