|
I was already working on a project that uses Excel Automation and was able to get Excel to export the WorkBook I was using into dBase III with the following line:
wsWorkSheet.SaveAs("c:\\temp\\NewDBF.DBF",Excel.XlFileFormat.xlDBF3,Type.Missing,Type.Missing,0,0,Type.Missing,Type.Missing,Type.Missing);
|
|
|
|
|
Michael
Tks - the Excel method looks possible, but its not something I've used before.
Does it mean that the user has to open up Excel to do it - if they do, then I may as well stick with Access reading the SQL table through an ODBC connection, as I am familair with that.
What I really want is something that does it all inside my .net app.......
Tks
Dave
|
|
|
|
|
Dave,
If you use Automation the user will not see a thing...You could have the whole processes linked to a single buttion click or no button at all.
|
|
|
|
|
In that case, where do I start....
Dave
|
|
|
|
|
Lets converse via e-mail rather then add 20 threads to the board....
|
|
|
|
|
Just wonedering if anyone has any idea of how to change the background color of specific items in a Listbox?
I would have thought that there might be a property like ListBox1.Items[1].BackColor or something similar but alas that does not exist?
|
|
|
|
|
I don't believe you can, I've tried this before.
My solution was to use a ListView in Report format.....
|
|
|
|
|
I actually solved my problem. The Listbox has a property called DrawMode which you set to OwnerDrawFixed. The ListBox then has an event called DrawItem which exposes a lot of properties like BackColor, its Bounds etc which give you all the necessary things to force the drawing of the ListBox.
|
|
|
|
|
del.icio.us links uses http auth. I send a link such as:
http://username:password@del.icio.us/api/posts/add?&url=http://www.engadget.com/&description=engadget&extended=engadget&tags=blog&dt=3/10/2005 12:34:49 AM
with my username and password, and I get the little xml snippet via html <result code='done'>
If I try to grab this result code with
<br />
<br />
<br />
string lcUrl="http://username:password@del.icio.us/api/posts/add?&url=http://www.engadget.com/&description=engadget&extended=engadget&tags=blog&dt=3/10/2005 12:34:49 AM"<br />
HttpWebRequest loHttp =<br />
(HttpWebRequest) WebRequest.Create(lcUrl);<br />
<br />
loHttp.Timeout = 10000;
loHttp.UserAgent = "code I borrowed trying to do this dang-it!";<br />
<br />
HttpWebResponse loWebResponse = (HttpWebResponse) loHttp.GetResponse();<br />
<br />
Encoding enc = Encoding.GetEncoding(1252);
<br />
StreamReader loResponseStream =<br />
new StreamReader(loWebResponse.GetResponseStream(),enc);<br />
<br />
string lcHtml = loResponseStream.ReadToEnd();<br />
<br />
loWebResponse.Close();<br />
loResponseStream.Close();<br />
<br />
I get the 401 error. I am trying to stream out the result code so I can store it in a string variable.
Any guidance is appreciated.
|
|
|
|
|
I search in Google and found only in RichtTextBox. But I want to retrive in everywhere. Help me Please.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
KERNEL32.DLL
|
|
|
|
|
Hi,
I have two panels on a C# WinForm contains set of buttons with shortcut (eg. Alt+K) on each Panel.
Now when the user is on one panel, the shortcuts of other panel buttons are not functioning. Same way when we place a UserControl on one of the panel.
Also, when the user is in a textbox below the Button on the same panel, button short-cut is not working.
Is there any solution for this problem??
Thanks in advance.....
Regards
Sundar
|
|
|
|
|
Hi all.
I've written a program that uses the joystick port to interface with a coin mechanism. I am using joySetCapture, etc via pinvoke. It all worked fine in testing, but in the real world, apparently sometimes the capture fails, and sometimes it breaks after time. What can I do, apart from install DX ?
Christian
I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer
|
|
|
|
|
Hi Christian!
joySetCapture is having problems under XP. The first capture works, trying to re-capture the joystick after a joyReleaseCapture always fails.
I've solved a similar problem by not using joySetCapture and joyReleaseCapture , but using joyGetPos() and doing the polling myself. For joyGetPos to work you don't have to capture the joystick, so it can be called as often as you want.
Regards,
mav
|
|
|
|
|
Hi,
I'm trying to call a method that resides in a .DLL that was built with the Watcom C/C++ 10.6 compiler. The method was exported and the compiler gave it the modifies my name with an underscore and stack length. IE: ProcAuthorizationWeb becomes _ProcAuthorizationWeb@4 because it accepts a 4 byte pointer.
I have the following code setup:
[DllImport("mcp.dll")]<br />
public static extern bool _ProcAuthorizationWeb(ref CreditCardStruct CreditCardStruct);<br />
.....<br />
_ProcAuthorizationWeb(ref CreditCardStruct);<br />
But I get the following error: [EntryPointNotFoundException: Unable to find an entry point named _ProcAuthorizationWeb in DLL mcp.dll.]
The compiler is exporting it as _ProcAuthorizationWeb@4 so I thought I might create an export alias via: '_ProcAuthorizationWeb'='_ProcAuthorizationWeb@4' in the Linker/Binder, but that gave the same error. If I put the @4 at the end of the exported name, the .NET compiler gives me an error.
Any ideas on how to call the method within the .DLL? Is there a way to see the actual exported names in the .DLL?
Thank you,
Glenn
|
|
|
|
|
Hi,
You can do this.
[DllImport("mcp.dll", EntryPoint="_ProcAuthorizationWeb@4", SetLastError=true)]
internal static extern bool _ProcAuthorizationWeb(ref CreditCardStruct CreditCardStruct);
Hope it helps.
Cheers.
Regards,
Chua Wen Ching
Visit us at http://www.necoders.com
|
|
|
|
|
Hello, I want to handle pressing Enter or Tab key in the DataGridTextBox of the DataGrid. Are there any way to do this?
Thanks.
|
|
|
|
|
Create a new class that inherits the datagridtextboxcolumn class. In this inherited class, you will have access to the textbox and can handle any events.
Good luck
|
|
|
|
|
I tried to handle the KeyDown event of the DataGridTextBoxColumn.TextBox but the Enter and Tab key can not be handled.
|
|
|
|
|
Hello, I want handle pressing Enter or Tab key in the DataGridTextBox of the DataGrid. Are there any way to do this?
Thanks.
|
|
|
|
|
hi
i want to do:
1. have count of my website visitors.
2. have the visitor IP.
3. count of the evry link clicked on my pages.
4. do a jump to another url in C# code area. ( not with html tag)
How i can do them?
thanks
|
|
|
|
|
1. Keep a counter and increment it everytime the main page loads
2. Their IP address is available to you within your codebehind as well.
3. To do this, you need to use linkbuttons, so that you can capture the click as opposed to a browse to a page, and then keep another counter.
4. response.redirect, from memory.
Christian
I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer
|
|
|
|
|
hi , thanks
mey u explain more about:
--getting ip
--open new window for a url from c# code area
thanks again
|
|
|
|
|
Oh - response.redirect will not open a new window. I'm not sure how to do that in code, a link has target = "_blank" to do that, from memory.
Request.ServerVariables("REMOTE_ADDR") will give you the IP address.
Christian
I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer
|
|
|
|
|
Hi,
For outlook automation with C#, is there a single way of automation
for different version of MS Outlook (97, 2000,xp,2003) ? Or it need to
be done seperately by different methodology ?
Many thanks
|
|
|
|
|
The Oulook Object Model is nearly the same for Outlook 97 and newer versions. Some methods have been added, but none has been removed.
If you develop with Outlook 97 only, the result should run with newer versions, too.
_________________________________
Vote '1' if you're too lazy for a discussion
|
|
|
|