|
Take a look into the Microsoft Sync Framework.
|
|
|
|
|
hi,
i am trying to create an .xls file from a data table and saving it in application local folder. all this i am doing for a web application. everything is fine until i end with an error. so please look into below error and help me out with a solution
Error :
Microsoft Excel cannot access the file 'E:\Syed Project\E-Comply_Project\E-Comply Source Code\COC_Export\'. There are several possible reasons:
. The file name or path does not exist.
. The file is being used by another program.
. The workbook you are trying to save has the same name as a currently open workbook.
Code :
public void DTToExcel(System.Data.DataTable dt, string filePath)
{
try
{
Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook xlWorkBook;
Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;
xlWorkBook = xlApp.Workbooks.Add(misValue);
xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
string data = string.Empty;
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
for (int j = 0; j <= dt.Columns.Count - 1; j++)
{
data = dt.Rows.ItemArray[j].ToString();
xlWorkSheet.Cells[i + 1, j + 1] = data;
}
}
xlWorkBook.SaveAs(filePath + "\\" + "BOM_Matched_ExcelReport.xls", Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();
releaseObject(xlWorkSheet);
releaseObject(xlWorkBook);
releaseObject(xlApp);
}catch(Exception Ex)
{ throw Ex; }
}
Thanks & Regards,
Sateesh kumar Singupuram
sateesh kumar singupuram
|
|
|
|
|
Does the application / user have permission to write to that folder?
Every day, thousands of innocent plants are killed by vegetarians.
Help end the violence EAT BACON
|
|
|
|
|
hi Simon_Whale,
thanks for the immediate reply and i would like to know how to set the folder permissions as i have added that folder to my assembly to maintain as a local folder to my hosting server.
|
|
|
|
|
|
Hello,
I have created an application in C#(Visual studio 2008),which pass some parameters to MATLAB(R2010a(x86) using "matlab builder ne"and output is a graph drawn by MATLAB.
Application is working fine when running in visual studio.
Then | uploaded it on IIS,application is running,but I am not getting graph on browser.
Please help me,i have been working in this problem for a week.  
|
|
|
|
|
Mridul Bagani wrote: Then | uploaded it on IIS,application is running,but I am not getting graph on
browser.
You might have more luck in the ASP.NET forum. I don't know much about websites, but it sounds like the server-version might not have the referenced libraries from MATLAB (or one of their dependencies)
Is there an errorlog somewhere? An exception that's thrown? How did you deploy the application? Just copied the source-files?
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
I am working on code for plugin installation in browsers
For the same, In plugin installation on Internet Explorer.. I need to make some modifications in group policy by my C# code at following path in group policy editor:
User Configuration\Administrative Templates\Windows Components\Internet Explorer\Security Features\Add-on Management\Add-on List
// You can find the same by "gpedit.msc" on RUN.
Please help me out.
Thanks.
|
|
|
|
|
Help you out with what? What code have you got? What's not working?
|
|
|
|
|
I need to initiate the process of communication with group policy via C# code so that I can read and edit the same, some API or method would be sufficient for me.
|
|
|
|
|
|
Hi all,
I am using FolderBrowserDialog and a browse button which allows the user to select a desired folder.
However, what i really want is that when the user closes the application and restarts it, the textbox field should contain the last used path and when i open the FolderBrowserDialog, it should point to the last folder rather than starting from the root (C
Can anyone please help??
|
|
|
|
|
- Store in a .NET Application settings file. This is pretty simple, it is useful as a dictionary and everything is done within the .net framework. Here is an MSDN entry on this[^]
- Store it in the registry: Useful where you have simple key value pairs, the value is availble to multiple applications, though you do have the worry of cleaning the key if/when the app is un-installed. Personsally I try not to use the registry (I've banged up against permissions problems in the past. See Read, write and delete from registry with C#[^] for help on how to store to the registry
- Store it in User Data folders, this is good for more complex data (which you don't have, the above two options should be sufficient) as you have more control over how to structure the data. Basically you serialize the data into the file in this folder. There is a discussion of how to save to this folder here[^], if you do go down this route you should condsider saving a config file there rather than an ad-hoc text file, it will simplify things
“Education is not the piling on of learning, information, data, facts, skills, or abilities - that's training or instruction - but is rather making visible what is hidden as a seed”
“One of the greatest problems of our time is that many are schooled but few are educated”
Sir Thomas More (1478 – 1535)
|
|
|
|
|
Hi, thanks for your reply. I created a temperary file where i would store the paths and when the application starts I would read the path from the file and display it in a textbox.
However, what I am missing is the highlighted folder in the FolderBrowserDialog in corrospondence to the path.
Lets say if my path is C:\Users\Public, the the folder dialog box should start from the folder Public (highlight it)
How can i do this??
|
|
|
|
|
It isn't really a temporary file, if you don't delete it when the app finished.
I understand your problem, I suggest you take a look at my first reply and use a settings file (it is the first option I gave) - it is ideal for storing single values for this, there is a link in reply. When the user opens the folder broweser it is either pre-populated with the last path you stored in the settings file or uses the default location if a value has not been stored there. When the user OKs (or whatever) the Dialog, you need to store the path from the Dialog into the settings file. That way you don't need to go through the hassle of writing the code to write/read from a raw text file.
“Education is not the piling on of learning, information, data, facts, skills, or abilities - that's training or instruction - but is rather making visible what is hidden as a seed”
“One of the greatest problems of our time is that many are schooled but few are educated”
Sir Thomas More (1478 – 1535)
|
|
|
|
|
|
Get your spamming out of here.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
This is actually one of the very few times I do use the registry (HKCU/Software/(your app) which you should always have full access to). This is user data, so it has to go in a user-specific data store, but not important enough to justify writing files into their user/AppData area, and it doesn't really matter if it gets lost when you copy the software to another computer. Your uninstaller should wipe the appropriate application key in the registry already.
You can store complex data in the registry, as you can put binary data in there, though you shouldn't store large objects that way. But what's asked for here is simple text variables which the registry (along with text .properties/.ini files or similar) is ideal for.
|
|
|
|
|
BobJanova wrote: This is actually one of the very few times I do use the registry (HKCU/Software/(your app) which you should always have full access to).
There may have been access problems to the area in the registry I happened to be accessing then(IIRC, when the application went live with typical flair), this isn't something I do very often. But thanks for your advice!
“Education is not the piling on of learning, information, data, facts, skills, or abilities - that's training or instruction - but is rather making visible what is hidden as a seed”
“One of the greatest problems of our time is that many are schooled but few are educated”
Sir Thomas More (1478 – 1535)
|
|
|
|
|
In the CustomHeaderTest app, if I set myListView1.IncreaseHeaderHeight=20 (choose any value), it works as expected: The header is taller.
I then created a brand new Winforms app, added the CustomHeader project to it, added a MyListView to the form. Compiles & runs as expected. I then set the IncreaseHeaderHeight=20 and it does not work as expected... the header is the original height but the font in it is larger!
I've spent a bunch of time trying to figure out why the different behavior happens, but no luck.
Any ideas as to why this happens? Is it due to a project setting, or a Form setting, or what? Does anyone else see this?
|
|
|
|
|
QQ897956996 wrote: the CustomHeaderTest app
Where did you get this from? If it is in a CodeProject article then you should use the forum at the end of the article to communicate with the author.
Use the best guess
|
|
|
|
|
Should I communicate with the author?
|
|
|
|
|
Well if you are using some code written by a third party, rather than part of a standard library then you have to assume that the person who wrote the code is best placed to help you.
Use the best guess
|
|
|
|
|
Hi,
I am developing a cashier POS. I would like to know how many characters to be printed on the receipt paper roll? is it standard?
www.volow.com[^]
Technology News @ www.JassimRahma.com
|
|
|
|
|
It depends on font size and type, so no, its not standard.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
