|
I would definitely look into the Task Scheduler for that, because it gives you much more flexibility in terms of when the task runs. It also gives you the ability to view when the task last ran, etc. Your importer application would be a straightforward console application that gets invoked when required by the scheduler. Easier for testing, as well, because that way you can run the import from the command line whenever you want to test it without having to fiddle around with the settings on a service.
If you do decide to go down the service route, all you need is a timer that fires off at fixed intervals (e.g. once a minute) to check the time to decide when to run your import. Unfortunately the VB.NET Timer class does not allow you to schedule an event for a particular time (that has always seems to me to be a bit of an obvious oversight but I guess that takes us back to the Task Scheduler). If you use Thread.Sleep on the main thread of your service be aware that will block the thread and you will not be able to shut it down unless it wakes up occasionally to check for a stop request.
|
|
|
|
|
A Windows Service is a worst choice for your requirement. If you had spelled out your requirements in the original post, you'd have got better answers earlier.
I have an application that does exactly this:
1. The data comes as a text file feed.
2. An SSIS package (SQL Server Integration Services) loads the contents of this file to the database. It is first loaded "as is" in a staging database. Then the SSIS package executes a stored procedure that reads the staging database, does all the required transformations, calculations, etc. and loads the transformed data into the actual application database.
3. An SQL Server job executes the package at a specified time once a day, typically at midnight since no one will be using the database at that time.
Try something on these lines.
|
|
|
|
|
Priya Prk wrote: import some data
If you are using SQL Server you may be able to use the bcp utility. In which case, you need only write a format file and a command file. If you need help with that, you can ask questions in the database forum.
Other databases may also have import utilities.
|
|
|
|
|
There are two applications, one is 64 bit and another one is 32 bit
1, I need to use 64 bit app to launch 32 bit one, how to implement it?
2, Is it possible to access the functions in 32 bit app from 64 bit
Thanks you in advance
|
|
|
|
|
jsjwql123 wrote: 1, I need to use 64 bit app to launch 32 bit one, how to implement it?
Look at the Process.Start() method.
jsjwql123 wrote: 2, Is it possible to access the functions in 32 bit app from 64 bit
No, you cannot mix 32-bit and 64-bit code in the same process.
|
|
|
|
|
He is already asking for two process. So, it is possible, but you must use some kind of RPC/Remoting.
|
|
|
|
|
Paulo Zemek wrote: but you must use some kind of RPC/Remoting.
That would mean 2 seperate processes. 
|
|
|
|
|
Hi all,
I am a newbie to the C# applications,I have a combobox in my application where i need to display the tooltip for the items inside it when mouse is moved over the items.
I tried with the fucntions "m_cbCommPort_MouseHover" and "m_cbCommPort_DropDown", but both did not work fine.Please suggest me a good solution for this.
Thanks in advance.
|
|
|
|
|
I have been trying to change an entry in a combo box for a while now and have got the text to change but when i click out of do something else it hasnt actually changed the entries value in the list.
case (char)Keys.Enter:
comboBox1.Text.Remove(0, comboBox1.Text.Length);
imageViewer1.RenameShape("test");
comboBox1.SelectedText = "test";
comboBox1.Refresh();
break;
Above is my current attempt which changes the text but does not store this change.
So my shape renames but the shapes name in the combo box does not.
Cant help feeling i need to do more than :
comboBox1.SelectedText = "test";
thanx in advance
|
|
|
|
|
Have you tried setting the selected index ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
I have tried this but cannot find a way of getting it to work for me :
I dont know how to set the selected index's text property
|
|
|
|
|
Set the Text property, not the SelectedText. SelectedText is the string within the displayed text that is currently highlighted for cut/copy/paste actions. Setting the Text property will automatically select the correct item in the combo box if it is present. There is also no need to call Refresh.
|
|
|
|
|
Thanx have tried this and the text does change but when i drop down the list test is not there.
case (char)Keys.Enter:
comboBox1.Text.Remove(0, comboBox1.Text.Length);
imageViewer1.RenameShape("test");
comboBox1.Text = "test";
break;
It just displays shape1 , shape2 .........
|
|
|
|
|
Use this:
ComboBox1.Items.Add("test");
ComboBox1.SelectedIndex = ComboBox1.Items.Count-1;
|
|
|
|
|
I think your problem is that you want to change the value of an entry by typing over it. The problem being that once you start typing you loose any reference to the item you want to change. Perhaps an option would be to handle to OnEnter event and store the selected index, then when you detect the 'Enter' key you can use that index to change the value of the correct item.
something like...
int currentIndex = -1;
void OnEnter(object sender, EventArgs e)
{
currentIndex = comboBox1.SelectedIndex;
}
void KeyDown(object sender, KeyDownEventArgs e)
{
case (char)Keys.Enter:
imageViewer1.RenameShape("test");
comboBox1.Items[currentIndex] = comboBox1.Text;
comboBox1.Text = "";
break;
}
Life goes very fast. Tomorrow, today is already yesterday.
|
|
|
|
|
Thank you for all of the replies.
I got everything working now there was alot to it as the shapes can be selected by the mouse too so this also had to change the comboBox :
void imageViewer1_Clicked(object sender, EventArgs e)
{
if (imageViewer1.ListOfShapes.Count > 0)
{
for (int i = 0; i < comboBox1.Items.Count; i++)
{
if ((string)comboBox1.Items[i] == imageViewer1.ListOfShapes[imageViewer1.SelectedShapeIndex].Name)
{
comboBox1.SelectedIndex = i;
m_comboBoxCurrentIndex = i;
}
}
}
}
Above and below (solution) may not be pretty but it works
case (char)Keys.Enter:
if (comboBox1.SelectedIndex != -1)
{
m_comboBoxCurrentIndex = comboBox1.SelectedIndex;
comboBox1.Text.Remove(0, comboBox1.Text.Length);
imageViewer1.RenameShape("test");
comboBox1.Items[m_comboBoxCurrentIndex] = "test";
comboBox1.Text = "";
}
Thanx George
|
|
|
|
|
Hi, i'm having this problem and can't find a solution.
This image describes all the problem.(Image)
Thanks a lot.
|
|
|
|
|
Please post your problem directly in the question and not thru external links. There are many people like me who are behind firewalls and can't access those links.
|
|
|
|
|
There are only two places the dll will be searched if you have added them as reference
1. Current working directory
2. C:\windows\system32 (till XP).
You can place your dlls in any of these places. Otherwise it won't get loaded
|
|
|
|
|
Have you ever heard of anything called assembly probing ?
|
|
|
|
|
Shameel wrote: Have you ever heard of anything called assembly probing ?
No
|
|
|
|
|
You can actually instruct Fusion (the assembly resolution subsystem of CLR) to check subfolders (in your app's folder) for referenced assemblies. This has to be done in the application's config file.
You can even compile referenced assemblies as embedded resources in your app and dynamically extract them and provide it to Fusion. For an example of this, visit www.albahari.com
|
|
|
|
|
Didn't know that. Thank you very much for that.
|
|
|
|
|
|
You have some options:
1. Search Google.
2. Write on your own.
3. Try RentACoder and pay someone to do your work.
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...!!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
