|
Hi,
I would like to create something i.e. a Job so that the .txt files can be imported into a sql server 2005 database tables.
The system has to be flexible so that I can tell it where the .txt file (Source) is and to which database I want to import to.
This system has to sit outside sql server, so I guess I can not use something like DTS ???
Any ideas please?
Thanks
|
|
|
|
|
I'm not sure if this is the right thing for you, but I think you can take a look at this page
http://filehelpers.sourceforge.net/
Regards
Hansjörg
|
|
|
|
|
|
Did you read the part where he had already ruled out DTS (for some odd reason)?
|
|
|
|
|
The whole idea is:
What we need to do is make sure we can run this job without needing to use SQL wizards.
And that we can run it on different source data into different databases.
I wonder if this is possible in DTS ?
Thanks
|
|
|
|
|
fmardani wrote: I wonder if this is possible in DTS ?
yes!
|
|
|
|
|
Is it possible to make a web set up application which donwloads application from a website and install automatically in a single key press in a quite mode.
Please any one help me out.
Regards
Mukilan
|
|
|
|
|
|
If you're using .NET 2.0, take a look at Click Once deployment.
Using this, you 'publish' your application to a website. Your users download the application from the website, and from that point forward when they run the application it automatically checks if there is a new version of itself available and fetches it if need be.
There's very little you need to do to get this to work, and works well in an Intranet environment.
Regards,
Rob Philpott.
|
|
|
|
|
Thank you very much Rob,
Its very much helpful for me. Is it possible to install the downloaded application in a quite mode. Using command line arguement "/q" we can install the application in a quite mode when we are installing the msi r exe file from the command prompt or from any other .Net application using the Process.Start with the arguement "/Q". Is it possible to do in the same way in the ClickOnce deployment.
Is it possible to get the values an do some processing like, checking the Licencse key and getting the email id or pin from the user or client.
Please reply me.
Regards
Mukilan.P.S
|
|
|
|
|
In the validation summary control, it display the errors as lists.. with maybe a message like: Error: registration not successful . How do I disable that the error list don't show, I only want the Error message to show.
I thought of taking out the validation summary control and putting in a label control, that displays this message. I set it to visible="false" . I'm assuming this must be set to visible="true" on the client side? How do I do this? How do I "link" this label so that when there is an error it will trigger the label to show?
Thanks.
Regards,
ma se
|
|
|
|
|
I would like to know if there is a way to check from code if there is any instance of sql server 2005 on the local machine running in order to use it to create a new database.
Thanks in advance
From Greece:
Dimitris Iliopoulos
dimilio@yahoo.com
|
|
|
|
|
|
Every DHCP network has a DHCP server, and every DHCP server has a lease table. Every DHCP Lease table has a correlation of Mac to IP. I want to be able to access the information in the DHCP Lease Table without shutting down services. The Microsoft DHCP management console can do this, and the W2K3 admin pack (installed on a client computer) allows this to happen from a remote computer, so I know it can be done. Not all DHCP servers are Windows machines, some are Routers, some are Linux, etc. So is there a way of accessing the information in the Lease table regardless if it is on a Windows server, router, etc.? Could perhaps output the information to a .csv file in a temp folder for input/review for our program.
|
|
|
|
|
Can you determin the filesize of files that are opened by another application?
(You can by using File.Open(path, FileMode.Open).Length, but the open will fail if the file is in use)
I need to check the total size of files in a certain directory, if it reaches a certain treshhold I need to delete them (kill the process, delete the files, restart the process)
tnx a lot.
No hurries, no worries.
|
|
|
|
|
Use Directory.GetFiles to get the names of the files, then create a FileInfo for each file to get the file size.
---
b { font-weight: normal; }
|
|
|
|
|
worked perfectly thank you
No hurries, no worries.
|
|
|
|
|
Hi
I use Windows-XP/Embedded and I want to shut down my application properly if the user presses the Power-Button.
The system is powered by an ATX power supply.
I used the following code to test it:
<br />
using Microsoft.Win32;<br />
<br />
...<br />
SystemEvents.PowerModeChanged +=new PowerModeChangedEventHandler(SystemEvents_PowerModeChanged);<br />
...<br />
<br />
private void SystemEvents_PowerModeChanged(object sender, PowerModeChangedEventArgs e) <br />
{<br />
System.Windows.Forms.MessageBox.Show("Power Off!!!!!!!!!!!!!!!!!!");<br />
}
Unfortunately the message never appears if I click the main button.
The only thing that happens is that the top most form/dialog is closed.
Is here anything wrong or are there better solutions?
Thanks and best regards,
Martin
|
|
|
|
|
Such amazing...
Here is a Class
[Serializable]<br />
public class S1<br />
{<br />
private object _value = new Unit () ;<br />
public object TheValue { get { return _value ; } set { _value = value ; } }<br />
}
If i try to serialize it using XmlSerializer:
XmlSerializer xs = new XmlSerializer(typeof(S1));<br />
xs.Serialize(new MemoryStream() , new S1());
Exception occurs as following:
System.InvalidOperationException: The type System.Web.UI.WebControls.Unit was not expected. Use the XmlInclude or SoapInclude attribute to specify types that are not known statically.
Here is S2:
[Serializable]<br />
public class S2<br />
{<br />
private Unit_value = new Unit () ;<br />
public Unit TheValue { get { return _value ; } set { _value = value ; } }<br />
}
It works fine.
Here is S3:
[Serializable]<br />
public class S2<br />
{<br />
private object_value = new Guid () ;<br />
public object TheValue { get { return _value ; } set { _value = value ; } }<br />
}
It works fine too.
Any ideas?
Foxcoming
-- modified at 4:40 Tuesday 14th March, 2006
|
|
|
|
|
It's because Unit isn't a system class and isn't defined in your class layout
Just add the XmlInclude attribute to the class:
[Serializable]<br />
[XmlInclude(typeof(Unit))]<br />
public class S1<br />
{<br />
private object _value = new Unit () ;<br />
public object TheValue { get { return _value ; } set { _value = value ; } }<br />
}
|
|
|
|
|
Thanks Steve!
But another question is What the "System Class" means?
Foxcoming
Another Brick in the WALL
|
|
|
|
|
I'm sorry, I just ment all the classes in the System namespace.
|
|
|
|
|
i have to integrate google earth and GPS device using C#.how can i do that.waiting for ur reply.
|
|
|
|
|
Hi,
You may have misunderstood the purpose of this forum. We take people's programming problems and we help the to resolve coding issues.
Seeing as you have posted neither code, nor an actual problem you are facing, there is little technical answer that can be given.
|
|
|
|
|
Go to Google[^] and look for the links to the SDK's for their products. Also post this on their own forums since you'll not get an answer in this one.
...Steve
1. quod erat demonstrandum
2. "Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." I read that somewhere once
(Translation: I'll show you the way, but not write the code for you.)
|
|
|
|