|
Sure, I uploaded the code to my website .. you may download it from http://www.waleedeissa.com/temp/HTM2MySQL.zip[^]
BTW, you could just replace MySQL with OleDb and export to Excel using OleDb and this connection string:
string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=\"Excel 8.0;HDR=YES;\"", excelFilePath)
Just change HDR=YES to HDR=No if you don't have headers in your Excel sheet ...
modified on Wednesday, April 16, 2008 3:20 AM
|
|
|
|
|
B Waleed,
The link doesnt seem to be active.
Can you kindly double check?
Thanks
|
|
|
|
|
You're right, sorry, I fixed the link try it again...
I also added a missing file, so if you already downloaded the file, then please download it again...
|
|
|
|
|
Arite,
I have written the problem scenario below.
Can you help me with Step 2? How do i make my application launch the browser with username and password already entered in it?
Sample Scenario:
Step 1 - I want to launch a webpage (www.hotmail.com) using C# Application.
Step 2 - I want my application to enter the username and password in the fields and then click the 'Sign In' button.
Therefore when i launch this application, it takes me directly into the page where data is sitting (Emails)
Here is the code that is working for Step 1
string url = "http://login.live.com/login.srf?wa=wsignin1.0&rpsnv=10&ct=1208358013&rver=4.5.2130.0&wp=MBI&wreply=http:%2F%2Fmail.live.com%2Fdefault.aspx&id=64855";<br />
System.Diagnostics.Process proc = new System.Diagnostics.Process();<br />
System.Diagnostics.ProcessStartInfo startInfo = new System.Diagnostics.ProcessStartInfo(url);<br />
proc.StartInfo = startInfo;<br />
proc.Start();
|
|
|
|
|
Actually I never tried this before but I believe (not sure though) I saw an article here on codeproject.com that talks just about that , so, you could try searching the site .. I can tell you though that you don't need to do it in two steps, you can pass the username and password as a POST request but to do this in the browser this is what I'm not sure of, I'm almost sure it's possible but I don't have experience with that, so, I guess you need to do a little googling .. sorry man, wish I could help ...
|
|
|
|
|
Well, just wanted to be sure that I understood correctly, are you talking about launching the default web browser e.g. IE or FireFox? (this is what I understood) or hosting a browser control in your application? ie. showing the page in your application .. it's much easier in the later case ...
|
|
|
|
|
|
Hello everyone,
In my understanding, this method only prevents GC from invoking Finalize method of the instance, it does not prevent GC from reclaiming the memory consumed by the instance? Right?
thanks in advance,
George
|
|
|
|
|
SuppressFinalize is used to prevent the call to the finalizer, usually after you cleaned up you resources in the Dispose method.
The call removes the object from the finalization queue, so it is destroyed earlier (and the GC may reclaim memory on it).
So yes, you're right.
|
|
|
|
|
Thanks Zoltan!
I noticed that when dispose method is called, we always call SuppressFinalize to prevent from calling Finalize again.
So, it means we should do the same thing (resource de-allocation) in both Dispose and destructor, right?
regards,
George
|
|
|
|
|
It prevents you from cleaning up unmanaged resources twice. The GC will still (always AFAIK) free the managed memory on Finalize.
|
|
|
|
|
Thanks leppie!
I noticed that when dispose method is called, we always call SuppressFinalize to prevent from calling Finalize again.
So, it means we should do the same thing (resource de-allocation) in both Dispose and destructor, right?
regards,
George
|
|
|
|
|
George_George wrote: So, it means we should do the same thing (resource de-allocation) in both Dispose and destructor, right?
Basically, normally you would use the Dispose(bool) pattern that will be called from the Finalizer with a false parameter, where Dispose() calls it with a true parameter. Do a search, you are bound to find more than enough samples.
|
|
|
|
|
Thanks leppie!
I have made some research. I think in destructor, we should call Dispose to release native resource, in Dispose, we should release both native resouce and call Dispose method of wrapped managed resource explicitly. Right?
regards,
George
|
|
|
|
|
hey
any one of u can help me..
i have one pdf file with 4-5 pages and i want to save these pages as images.so i can show these pdf pages in thumbnail .i m using C# in asp.net application.
can any one help me.can any one give me code help.
thx
Ajay Rathi
software engineer
NOIDA(UP),INDIA
|
|
|
|
|
Hi,
What are the maximum number of columns in .NET DataTable.
Thanks in advance
|
|
|
|
|
|
If you have to hit that limit, you've got bigger issues with your application...
It's System.Int32.MaxValue, or 2,147,483,647. But since you wont be able to reach that limit without generating an OutOfMemory Exception, it's limited by available memory.
|
|
|
|
|
|
|
Can we increase size of data table? I am trying to read data from Excel but dataset picks only first 256 column How Can I read all data from Excel
|
|
|
|
|
|
Hi there, sorry about the n00b question but i've really not been able to find an answer on google. What is the easiest way to distribute an application created in visual studio with an installer that will automatically install requirements/prerequisites for the application such as the .net framework? Can I not include necessary files with the exe or the installer?
Kind regards
Linden
|
|
|
|
|
Don't quote me on this, been a while since I did this, but I believe you need to add a setup project to your solution, and you add the prerequisites such as .net framework to that project.
He who makes a beast out of himself gets rid of the pain of being a man
|
|
|
|
|
use third party installer program...its bit easy..it automatically asks what prerequisites must be there and install if not found..
i have tried WISE installer
Ashish Sehajpal
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
