|
Looks OK if that's what you want to do. But...
Do you really need a DataSet or will a single DataTable do?
I would do new SqlCommand("MyTestSP", new SqlConnection(_connectionString) ), but that's just me.
Other than that, are you sure you won't need the Connection and Command again? I prefer to create a Connection and Command and use them multiple times throughout a program's run. If you're doing that Web crap it may not matter.
|
|
|
|
|
While I retain the connection I always use a new command object. And yes I find the datatable more satisfactory to manipulate, although the overhead would be identical.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
The Current Design:
You click on the shortcut and a window pops up asking you for the source directory and target directory. You provide this information and then the files in one directory get copied to another directory. When I schedule this to run as a automated task, the window always pops up asking for the source dir and target dir.
What I would like:
When you schedule the program to run as an automated task, it doesn't ask the user for the source and target directories. If the user needs to change the source and target, they double click on the shortcut and the interface pops up again asking them for the source and target info.
Question:
How do I do this in C#?
|
|
|
|
|
Hi,
I think your problem is more about design rather than any particular language. If I read you correctly your current design is interactive and prompts the user for source and target directories.
When running unattended what is your source of directory data? One solution would be to provide a command line interface. e.g.
FileCopier srcdir targetdir
Your code could then do the following:
1) If there are any command line arguments assume that this is an unattended run.
2) Validate the arguments to ensure that the directories exist.
3) Perform your actions on the src and dest directories.
4) Write a log file so that you can check what happened when you weren't there.
Hope that helps, ....Alan.
|
|
|
|
|
Check System.Environment.UserInteractive
|
|
|
|
|
Thank you both. I will try your suggestions.
|
|
|
|
|
Hey there,
I'm really stuc and would appreciate anybody's help on this..
I am using visual c# express edition (windows forms app) and need to on Form_load event open a textfile that i specify in the code automatically and display its contents into a textbox on my form. Below is an example:
on form load
open c:\hello.txt
read c:\hello.txt
insert c:\hello.txt into Textbox.Text
-- I know that that above example is nothing like the way you'd code it but i'm am completely stuck on this pls help! i'd really appreciate it, thank you
|
|
|
|
|
Welcome to CodeProject ![Beer | [beer]](https://www.codeproject.com/script/Forums/Images/beer.gif)
I strongly urge you to use beginner based materials to start learning how to program rather than asking questions on internet forums. Things like books or tutorials found on the web. We have a large collection of Articles here at CodeProject some of which are targeting beginners. You can find those articles under the Chapters section of the site menu.
I believe most people will learn beginner level subjects much faster from coordinated material rather than using internet forums.
led mike
|
|
|
|
|
Check out msdn and look at the FileInfo, DirectoryInfo, StreamReader, and StreamWriter classes. MSDN gives some good examples as to how to use these classes.
|
|
|
|
|
jay_t55 wrote: on form load
open c:\hello.txt
read c:\hello.txt
insert c:\hello.txt into Textbox.Text
As its been already said that you should first read the basic of c#(infact programming).
My suggestion is that even ebfroe posting the question try to Google its out. a simple serach would have yield this [^]result for you.
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
How can I write the C# code that would allow me to view an image file using a viewer control. I want to be able to say:
On selected index changed
read System.Byte in the Details_dwg field
Load into viewer control.
|
|
|
|
|
technette wrote: How can I write the C# code
I prefer to use a keyboard. 
led mike
|
|
|
|
|
New to C# and am under the gun. Please include keyboard stroke.
|
|
|
|
|
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
Control myControl = FindControl("dwgViewerCtrl");
const string sql = "SELECT Detail_dwg @Detail_dwg FROM Detail_Info WHERE [Detail_ID] = Detail_ID";
using (SqlConnection myConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["DetailsDBFConnectionString3"].ConnectionString))
{
myConnection.Open();
myControl = BoundField("@Detail_dwg", imageBytes);
}
Not finding my SQL Connection. WHY? 
|
|
|
|
|
I'm trying to create a report with a crystalReportViewer, who knows if it is possible to make a scroll bar scrolling not only one page but through all pages?
Thank you.
|
|
|
|
|
Hi everyone.
I have wrote a little program which uses mysql server, but now I need to remove mysql server and you some sql database witch do not need to you another install application...
Anyone has any ANYYY kind of tip??
Thanks A LOT in advance.
|
|
|
|
|
You want to replace MySql database with MS Sql database for your application?
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Hi!
I need to replace the mysql for any other database type... Because...
The client doesn´t want to install anything else besides my application and I don´t want to lose my implementation with "insert"s "delete"s and "update"s....
|
|
|
|
|
|
|
Hey guys.
Can we show an object (for example an imageBox) by toolTip ?
Thanks in advance .
|
|
|
|
|
|
Hello All.
I would like to know what api calls/functions are required to retrieve all the application version numbers that are currently installed on a windows platform.
What I want is to get all the version numbers as displayed when one goes to the Control Panel->Add/Remove Programs.
I want to get the application names and the versions so I can generate reports, forward in an email etc.
Does any body know how to do this?
Many thanks,
Matt
|
|
|
|
|
You need to enumerate the registry entries in this location
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)Expect everything to be hard and then enjoy the things that come easy. (code-frog)
|
|
|
|
|
Try these:
Assembly Version:
Assembly.GetExecutingAssembly().GetName().Version
File Version:
System.Diagnostics.FileVersionInfo.GetVersionInfo(Assembly.GetExecutingAssembly().Location)
"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." - Jason Jystad, 10/26/2001
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
