The DateTimePicker will only let you pick a SINGLE point date/time. It will not let you pick a RANGE of dates. A guide to posting questions on CodeProject Click this: Asking questions is a skill. Seriously, do it. Dave Kreskowiak

You can get the configuration settings in your main program's code and then pass it in to the method that does the database access, the same as you would any method that accepts input parameters. Use the best guess

thanks!

Sorry about that! You can correct that I am going an exe. I have this question in another thread of mine so I will just close this thread.

Quite possibly.

sc steinhayse wrote: Thus can you tell me and/or show me in code how to fix this problem? What have you tried so far? Have you Googled it? When I did a quick Google, this[^] was the first thread - and it looks quite promising. *pre-emptive celebratory nipple tassle jiggle* - Sean Ewington "Mind bleach! Send me mind bleach!" - Nagy Vilmos CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

Are you sure you did it right? Do you have reference to that dll in project that contain sample.cs? Maybe do you have errors in dependent projects? Or namespaces clash? No more Mister Nice Guy... >: |

sc steinhayse wrote: connectionString="Data Source=instance1\DEV;Initial Catalog=dev3;Integrated Security=True" Err...That is your connection string. It is in your app.config. So if you want it to point to a different database then you change that. If however that is not where your connection string is coming from then it is certainly coming from somewhere so use a text editor to search ALL files you in your source tree for the connection information.

sc steinhayse wrote: I have a question about setting up permissions on a sql server 2008 r2 datbase.   I basically wrote and enhanced some C# 2008 and C# 2010 console applications that connected to my test sql server 2008 r2 database. On my test database, I must all full right my default.   Do you have a business case that mandates these applications need DBO to run? Or are you just granting DBO to make sure they run right? * I suggest you start by granting the least permissions and changing those permissions until the application executes. Then understand what it is about the code that requires the elevated permissions and try to rework it so that you can run at lower permissions. This is tedious but vitally important. My 3 applications were deployed to a user acceptance testing environment that includes a user acceptance sql server 2008 r2 standard database. The user accpetance database was set up by the network administrator at my small company. He is the only one at my small company that knows a little bit about the dba roles and has locked down permissions.   Due to the facts above, I would like to know what should I be aware that may need to have permissions setup for. My questions includes the followinng: 1. When to decide if role(s) need to be setup and how to setup the roles. Roles are a business case. Do you need Admins, Editors, Readers, Etc... The ASP.Net Membership provider can implement role based security with some configuration code. When I ran my applications on my test database, I had the integrated security set to true. I did not need to supply the user name and password in the connection strings to the database. My user account was setup to have a role in the database. Actually integrated security means you are on a domain or using LDAP/Etc... so you don't need to pass in user/pass it's just authenticating you with your domain permissions. Due to what I just said, will I need to have setup roles for the console applications to run on their own? If so, What kind of roles need to be setup and how do you setup these roles? What do you mean by "run on their own"? Application permissions depend on who is signed in. So for example you could create a user {console_app_name}.dbo and grant DBO to that account. Then any user passing that username/password combinatio

If you can change the code you can basically change all Console.WriteLine("") to a log function. Example: public void WriteLog(string logtext){ StreamWriter writer = new StreamWriter("[path here]", true); writer.writeLine(DateTime.Now.ToString() + ": " + text); writer.Close(); } hope this helps. V. (MQOTD Rules )

eDataContext eData = new eDataContext(); var eSelect = (from iw in eData.Ibooks join ip in etData.IPack on iw.P_ID equals ip.P_ID join eTrack in eData.eRPT_Trans on ip.TNum equals eTrack.P_ID where ip.TNum == packageId select new { iw.P_ID, ip.P_ID, eTrack.P_ID /* Other fields */ } ).FirstOrDefault();

Write unit tests for the situations you are worried about and see if the result is correct?

Did you happen to read the documentation on the ProcessClass?? There's a little property called "ExitCode" which will contain the exit code of the process once it terminates. You don't need to call Close. It'll be called by the Process class Dispose method automatically, which you SHOULD be calling when you're done with the Process object. You might want to wrap that process code in a using block to take care of this for you. A guide to posting questions on CodeProject[^] Dave Kreskowiak

You two need to coordinate then. It's getting very confusing answering similar questions from different people. *pre-emptive celebratory nipple tassle jiggle* - Sean Ewington "Mind bleach! Send me mind bleach!" - Nagy Vilmos CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

No, you can add it later. Don't get too used to the Setup and Deployment project in Visual Studio. It no longer exists in VS2012 as it's been replaced by InstallShield LE. Typically, setup projects are built and designed right along side the project it's going to be installing. A guide to posting questions on CodeProject[^] Dave Kreskowiak

You can use Log4Net to generate a log for an application. Go through their documentation to figure out how to use it. Windows Phone Apps - Dilbert | Speed Dial

Listen to Piebald on this one, go educate the the idiot and use the 'yyyy-mm-dd' format. To help with this make up a list of file names using the same prefix and the 2 date formats, sort them and get the idiot to find a particular date/file Oh and the rest of his recommendation is valid as well. Never underestimate the power of human stupidity RAH

Sure. You can find examples of querying XML here[^]. If you were to post a simplified sample of the data structure you are talking about, I could show you a sample query or two that would mean more in the context of what you're trying to do. *pre-emptive celebratory nipple tassle jiggle* - Sean Ewington "Mind bleach! Send me mind bleach!" - Nagy Vilmos CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

Edited. Thanks. You do have an eye for details. :-)