|
Hi Paul,
Could you please provide me a good C# example for odbc/jet driver thing?
I tried on the internet but still I couldn't find a proper one. I could find several nice article for "Excel Automation Library".
Thanks for your kind help!
Good Luck!!!
jayasshc
|
|
|
|
|
Try something like this:
string dataFile = "<path to your excel file>";
File.SetAttributes(dataFile, FileAttributes.Normal);
System.Data.OleDb.OleDbConnection tempExcelConnection = new System.Data.OleDb.OleDbConnection();
tempExcelConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;";
tempExcelConnection.ConnectionString += "Data Source=" + dataFile + ";";
tempExcelConnection.ConnectionString += @"Extended Properties=""Excel 8.0;HDR=Yes;"";";
System.Data.OleDb.OleDbCommand tempExcelCommand = new System.Data.OleDb.OleDbCommand();
tempExcelCommand.Connection = tempExcelConnection;
System.Data.SqlClient.SqlDataReader dr = null;
tempExcelCommand.Connection.Open();
if (dr.HasRows)
{
while(dr.Read())
{
tempExcelCommand.CommandText = String.Format("INSERT INTO [mynamedrange] VALUES ({0}, {1}, {2}, {3}, {4})", dr[0], dr[1], dr[2], dr[3], dr[4]);
tempExcelCommand.ExecuteNonQuery();
}
}
dr.Close();
tempExcelCommand.Connection.Close();
Regards
Paul
|
|
|
|
|
This article shows you another approach: http://www.bbv.ch/pdf_files/system_event/2005_XMLto%20Excel.pdf
XSLT is used to create Excel files.
The advantage is that you do not need Excel itself to create the files.
The disadvantage is that you have a Excel-xml file in the end. If you need to have an xls then you still have to use Excel to transform the xml to a xls file. But this is mus easier then program all data into Excel with interop.
-^-^-^-^-^-
no risk no funk ................... please vote ------>
|
|
|
|
|
|
Hi,
if you are looking for a solution for a large project, you should evaluate the libraries offered by aspose http://www.aspose.com[^]. I started a project using COM/INTEROP to create an interface to the office world. Then it was necessary to support the generation of word documents on a server without having any MS office application installed. We decided to use aspose. Finally we were able to improve our applications noticeably.
Erik
|
|
|
|
|
i want get now month from system. how to get it.
thank you
|
|
|
|
|
hi
int month = DateTime.Now.Month;
regards
|
|
|
|
|
Can anyone tell me how to search a particular record from the MS Access database using C#. I want to use a combobox on which primary key of the table will be there and clicking on any particular primary key value, all the records related to that primary key value should be displayed in respective text boxes.
Help appriciated...
Thanks
Imran
|
|
|
|
|
Can you clarify a little more what you need to do?
Do you need to search one table for a PK or the entire DB?
ImranTech wrote: all the records related to that primary key value
Normally a PK is unique within the table.
God Bless,
Jason
I am not perfect but I try to be better than those before me.
So those who come after me will be better than I am.
|
|
|
|
|
I have come up with an authentication scheme that I wanted to run past everyone to see if you all agree with my logic. Here is the process:
1) The clients windows login credentials are automatically passed (manual option also provided) with the webservice call using:
WebService.Credentials = System.Net.CredentialCache.DefaultCredentials
2) The web.config is set to impersonate the user.
3) At this point I thought I could assume that the client is who they say they are since the user was able to log in to IIS. My plan is to use the username and SID to retrieve the information for that user as opposed to the traditional username and password scenario.
4) If the user's SID is ever out of sync I will provide the admin a sync option. Basically the same option I would have given them when they set up the user.
 I guess I am worried about two things. Can I rely on these SID's as long as the user is not recreated in the domain and hopefully I can store the SID's in a database. I am not sure how "variable" in length these SID's can be. If I stored it in a character field at 255 will I be safe?
|
|
|
|
|
Hey all,
I am trying to load and parse a MIDI file in C#. So far, I have been able to read the header and make it to the first track. However, I am now confused. Some values in the file are kept as a variable length format (link to the page I am looking at: MIDI File Format[^]), and I am not sure how to manipulate this. Basically, it shifts bits around like so: C8 (11001000) becomes 8148 (10000001 01001000). The top bit is used to signal that another 7 bits of information follow. So... I guess I need to know how to move the bits back into a format that I can use. Is there a way to handle individual bits in C#?
|
|
|
|
|
|
Thanks a bunch for the reply. I tried using the first link, but got confused. The last link seems to be very helpful, almost exactly what I need. Thanks again 
|
|
|
|
|
I have an application that logs data based on messages sent to it from another app. It works great.
Now I want to hide it from the taskbar and live in the system tray (Notify Icon area).
When I call "ShowInTaskbar = false;" for my mainwindow, it stops recieving the messages.
I am registering the message in question and sending it to my app with a HWND_BROADCAST.
Any Ideas?
|
|
|
|
|
Hi!
I'm using a similar approach in one of my projects (although the hidden window is created from C++) and it works nicely, so it shouldn't be a general problem.
Could it relate to the fact that switching ShowInTaskbar recreates the window handle?
Regards,
mav
--
Black holes are the places where God divided by 0...
|
|
|
|
|
Hi guys,
I tried googling but no luck, please help, I need to confirm that a particular report was printed after printtoprinter is called. Please advice on how to achieve this.
sasa
|
|
|
|
|
I am trying to remove some images in a temperary directory when a user loses their session. Session_OnEnd is ignored when the Session State is set to "SQLServer". Does anyone have any ideas on how I can do this when the application is set to SQLServer mode? Thanks!
|
|
|
|
|
I figured I'd ask before rewriting to test the alternate implementation.
Is there any significant performance difference between:
for (i = 1; i < bignum; i++)
myStreamWriter.WriteLine(GetNextLineOfData))
and
for (i = 1; i < bignum; i++)
myStringBuilder.Append(GetNextLineOfData())
myStreamWriter.Write(myStringBuilder.ToString())
--
If you view money as inherently evil, I view it as my duty to assist in making you more virtuous.
|
|
|
|
|
Yes, the second one is using a StringBuild to build a very large string, then calling ToString on it to create a new String object, then your writing the new string out to a file.
The two pieces of code are no doing the same thing. Your appending some data to a StringBuild, then creating a new String of all the data, appending some more data, creating a new String of all that data, ..., .... The string is getting bigger and bigger and bigger and your recreating the beginning part of the string over and over again with each pass. Your writing out something akin to:
1111 11112222 111122223333 1111222233334444 11112222333344445555 111122223333444455556666
whereas the first little snippet is doing this:
1111
2222
3333
4444
5555
6666
|
|
|
|
|
Hi Dave,
Dave Kreskowiak wrote: The two pieces of code are no doing the same thing
Indentation suggests and absence of curly brackets causes the output to be the same.
But I fully agree, the big string (and the iterative growth of the StringBuilder) are
bad for performance.
Luc Pattyn [Forum Guidelines] [My Articles]
this weeks tips:
- make Visual display line numbers: Tools/Options/TextEditor/...
- show exceptions with ToString() to see all information
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
No semicolons either, so I really couldn't do anything other than guess...
|
|
|
|
|
the intended output from both was intended to be the same and what Dave had as his second sample output. The missing semis were an oversight since I wasn't able to copy code directly the actual generation of the batch file being rather more fugly and not suitable for a copy/paste/cleanup process.
I'd posted the question since I didn't know what the StreamWriter was doing internally. I strongly suspected that the later would be faster if the StreamWriter had a simple implementation, if it was using a stringbuilder as an internal buffer and waiting until it had a predetermined optimum amount of text before dumping to the disk there wouldn't have been any actual speedup from the change.
I guess I should've explained what I was doing a bit better, but I'd something else to do and was trying to post as quickly as I could while still being understandable. Obviously I failed in the attempt.
--
If you view money as inherently evil, I view it as my duty to assist in making you more virtuous.
|
|
|
|
|
Hi Dan,
AFAIK the general answer to your question is streams are intended to facilitate AND
optimize what you are trying to do, so there is no need, no benefit, in organizing
your own buffering scheme. Streams use their own buffering system, which incidentally is
not based on StringBuilder since a stream can write/read a lot of different types.
Regards.
Luc Pattyn [Forum Guidelines] [My Articles]
this weeks tips:
- make Visual display line numbers: Tools/Options/TextEditor/...
- show exceptions with ToString() to see all information
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
In Explorer under Details file view there is a tab you can add called Pages that works for Tiff Images.
In a program I'm writing, I'm trying to get the page count of tiff images without involving
<br />
Image img = Image.FromFile(fnsQueue.Peek());<br />
Guid[] guid = img.FrameDimensionsList;<br />
FrameDimension fd = new FrameDimension(guid[0]);<br />
int pgCount = img.GetFrameCount(fd);<br />
img.Dispose();
I'd rather not have to pull the image into memory to get the frame count, is there a way I can access the pages attribute without resorting to the image bit? I've been exploring FileInfo but have not found anything yet.
Appreciate the help.
|
|
|
|
|
There is nothing in the .NET BCL that will do this without loading the file. You'd have to either write your own, or use a third party library that can get the attributes directly from the file without loading it. I, myself, don't know of any because image processing isn't in my main line of work.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
