|
The fastest way to get the data from a FoxPro table into SQL is by using SSMS. It is best to create your own package to run rather than using the default Import functionality, if for no other reason than you can have a permanent copy of the code.
In my experience you must always pre-process the foxpro data into a staging table (still in foxpro). The most common pre-processing task is to sort out dates as Foxpro handles a far wider range of dates to SQL. The other major concern is that foxpro has three data 'states'. These are Populated, Empty, and Null. SQL only has two (Populated and Null). Again dates are the worst culprit. Empty dates should be either SQL Null or the earliest SQL date (1/1/1900 for shortDateTime and 1/1/1753 for DateTime).
|
|
|
|
|
C# CODE SNIPET FOR RUN AS ADMINISTRATOR
I want my C# application to automatically RUN AS ADMINISTRATOR on VISTA and WINDOWS 7 by default. Please I need the code snipet to achieve this. Thanks for your reply.
omoniyiogunderu@yahoo.com
|
|
|
|
|
|
Omoniyi Ogunderu wrote: C# application to automatically RUN AS ADMINISTRATOR
Not sure how you can do that. You would need to elevate the rights of the user under which your application runs and then again remove that once the run is over.
Although, you can show that UserAccount control dialog (the one with cancel and allow options). You can achieve this by using a manifest file. Add the following entry into your manifest file and it should work:
< requestedExecutionLevel level="requireAdministrator" uiAccess="false" />
50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!
|
|
|
|
|
This seems more like a demand than a request for assistance and is very rude.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
The user decides what should be run as administrator, not the application.
.45 ACP - because shooting twice is just silly
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"The staggering layers of obscenity in your statement make it a work of art on so many levels." - J. Jystad, 2001
|
|
|
|
|
Think about what you are asking: would it not defeat the purpose of having Administrator / User priviledges in the first place?
Oh, and don't post your email in any forums - spambots do have such fun with them!
All those who believe in psycho kinesis, raise my hand.
|
|
|
|
|
Oh, and I forgot.
DON'T SHOUT!
It doesn't make anyone want to help you any more, or any quicker.
It does annoy people, though.
All those who believe in psycho kinesis, raise my hand.
|
|
|
|
|
Hi,
I'm just beginning work on an assembly which, amongst other things, will perform some transformations and other operations on objects passed from COM. I've created a stub assembly to receive these objects to see what they look like in the debugger. However, because they're passed as "Object" I am not able to see any of their methods or properties.
Can someone advise me on how I can get a view of the methods and properties of these objects so that I can better understand what I'm dealing with?
All help and advice will be warmly received.
Kind Regards,
Dave
Regards,
Dave
|
|
|
|
|
You can use oleview.exe to explore COM types registered on your computer. I assume that you know at least name of the COM type that is passed to your assembly. Use the name to look for the type inside oleview.exe.
|
|
|
|
|
Hi Experts,
I'd like to enable my MyPanel:System.Windows.Forms.Panel to
- scroll vertically on mouse wheel move
- scroll horizontally on [Shift] + mouse wheel move and
- zoom on [Ctrl] + mouse wheel move
Scrolling vertically is Panel's built-in functionality. It's enough to use
base.OnMouseWheel(e); for that purpose.
To achieve horizontal scrolling I tried this one:
protected override void OnMouseWheel(MouseEventArgs e)
{
if ((Control.ModifierKeys & Keys.Shift) == Keys.Shift)
{
m_iMouseWheelDeltaAccumulator += e.Delta;
int iHorizontalPosition = 0;
while (
m_iMouseWheelDeltaAccumulator < -m_iMouseWheelDeltaThreshold
|| m_iMouseWheelDeltaAccumulator > m_iMouseWheelDeltaThreshold
)
{
iHorizontalPosition = HorizontalScroll.Value;
if (m_iMouseWheelDeltaAccumulator < 0)
{
iHorizontalPosition -= m_iMouseWheelDeltaThreshold;
m_iMouseWheelDeltaAccumulator += m_iMouseWheelDeltaThreshold;
}
else if (m_iMouseWheelDeltaAccumulator > 0)
{
iHorizontalPosition += m_iMouseWheelDeltaThreshold;
m_iMouseWheelDeltaAccumulator -= m_iMouseWheelDeltaThreshold;
}
if (iHorizontalPosition < HorizontalScroll.Minimum)
iHorizontalPosition = HorizontalScroll.Minimum;
else if (iHorizontalPosition > HorizontalScroll.Maximum)
iHorizontalPosition = HorizontalScroll.Maximum;
}
HorizontalScroll.Value = iHorizontalPosition;
}
}
And it does work.
Nearly.
But there are two unexpected points:
- The movement of content and scroll bars differs.
- The panel doesn't scroll the same distance every time I scroll one mouse wheel step. The distance gets bigger at first. Then, after ten or so steps, it gets smaller for the same amount of steps. And then it gets bigger again. The scrolling distance seems to oscillate (without the negative alternation).
How do I achieve a "normal" behaviour, like in OpenOfficeOrg, for example?
Ciao,
luker
|
|
|
|
|
I didn't understand your complete code but maybe thats the problem:
while (condition)
{
iHorizontalPosition = HorizontalScroll.Value;
...
}
HorizontalScroll.Value = iHorizontalPosition;
Maybe you meant:
while (condition)
{
iHorizontalPosition = HorizontalScroll.Value;
...
HorizontalScroll.Value = iHorizontalPosition;
}
Because you recalulate iHorizontalPosition every while iteration but you also overwrites it in the next iteration.
Greetings
Covean
|
|
|
|
|
Hello Covean,
this is indeed a mistake.
Both assignments should be either within or outside of the loop, not one inside and the other one outside.
But unfortunately, that doesn't solve my problem (see my first answer to the original post).
Ciao,
luker
|
|
|
|
|
Tried to look for at the LargeChange / SmallChange value properties of HorizontalScroll?
Because one "step"/"delta" of my mouse wheel is +-120 and maybe this differs from the Large/SmallChange values.
Greetings
Covean
|
|
|
|
|
The values for SmallChange (=5) and LargeChange (=995) don't seem to have anything to do with mouse wheel scrolling.
They are used for scrolling on mouse click or keyboard hit, IIRC. At least, my problem persists with both values set to 120, which equals MouseEventArgs.Delta on my system, too.
Ciao,
luker
|
|
|
|
|
Last 3 ideas of mine:
1. Take a look at the 5 AutoScroll values of your panel.
2. I would look at every place where you access the scrollbar.
3. Set a conditional breakpoint (on change) at the scroll value to find out where the gets changed.
Hope this helps.
Greetings
Covean
|
|
|
|
|
I'm afraid my code was not as clear as possible.
The behaviour I described is generated by this code, too:
protected override void OnMouseWheel(MouseEventArgs e)
{
if ((Control.ModifierKeys & Keys.Shift) == Keys.Shift)
{
int iHorizontalPosition = HorizontalScroll.Value;
iHorizontalPosition += e.Delta;
if (iHorizontalPosition < HorizontalScroll.Minimum)
iHorizontalPosition = HorizontalScroll.Minimum;
else if (iHorizontalPosition > HorizontalScroll.Maximum)
iHorizontalPosition = HorizontalScroll.Maximum;
HorizontalScroll.Value = iHorizontalPosition;
}
}
What could cause the described behaviour?
And how do I scroll MyPanel horizontally in a satisfactory manner?
Ciao,
luker
|
|
|
|
|
Hello again,
I did some testing. As you can see in this piece of code,
if ((Control.ModifierKeys & Keys.Shift) == Keys.Shift)
{
int iHorizontalPosition = HorizontalScroll.Value;
if (iHorizontalPosition != m_iSavedHorizontalPosition)
{
;
}
HorizontalScroll.Value = iHorizontalPosition;
m_iSavedHorizontalPosition = iHorizontalPosition;
}
the method remembers m_iSavedHorizontalPosition (a MyPanel member variable) after applying it to HorizontalScroll.Value. On the next call the method compares the saved member variable with the value of HorizontalScroll.Value.
They differ.
Do I have to call some "ApplyScrollSettings"-method on MyPanel for HorizontalScroll.Value to take effect?
Ciao,
luker
|
|
|
|
|
Hello!
I am using the windows context menu. My problem is that when i select multiple files the application will open as many times as selected files.
In HKEY_CLASSES_ROOT\*\shell i have a key with the shortcut to my app and %1. Should the "%1" parameter be changed?
Using the "SendTo" and creating a shortcut to the application will work as i wish, but how can i make it work the same way "SendTo" works for the context menu?
I hope i made myself understood. I know this is more of a windows problem and not a C# one.
Thanks!
|
|
|
|
|
Islorvat wrote: I am using the windows context menu. My problem is that when i select multiple files the application will open as many times as selected files.
Windows will launch a new process for each item, each process with a single parameter pointing to a file. You'd have to make sure that your application is launched just once, and collect the parameters from the other instances there.
This[^] article might help 
I are Troll 
|
|
|
|
|
I have a date fields on my MS Report. If the date is blank or null, I do I suppress the date so It doesn't show 01/01/0001 on my report.
Thanks!
|
|
|
|
|
What you need to do is to tweak your query so that the date field shows whatever you want in the way you want. There are built-in functions for this.
|
|
|
|
|
If the user has typed an invalid entry, so that CellValidating raises an error, and they then decide to abandon the edit and want to click the Cancel button, the form won't close because the eror still exists. Error needs to be cleared first.
I just can't work out a way to achieve that, short of teaching the user that if they click Cancel, and the form doesn't close, press Esc so text reverts to original and then click Cancel again. Not ideal.
|
|
|
|
|
I know it's pretty old but I faced the same problem and wanted to ask if you managed solve it or not?
Even setting CausesValidation property of the close button doesn't work. What have you done to work around the issue?
Thanks a lot.
|
|
|
|
|
As far as I can remember I didn't solve the problem. User must press Esc to cancel the edit before doing ANYTHING else. You notice no-one offered a solution.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
