|
I have a Microsoft Access 2003 database with a .mdb extension with a table and a query on that table. In my query I have a parameter that allows me to get prompted within MS Access just before running the query.
The problem is when adding that .mdb file to my projects solution within VS I get prompted with the "Data Source Configuration Wizard" that shows the tables and views I can import. The view doesn't come up. Now if I take that parameter off and then try to import the .mdb file into my projects solution the view is there ready to be imported.
Do anyone know a workaround to import a query with a parameter?
Chris
|
|
|
|
|
Dear all,
I've got a directory full of files of the same type. Basically what they are CSV or TXT files. I would like to parse each individual file to a DLL for processing. I can select each individual file manually and process it :
<br />
private void btnGo_Click(object sender, EventArgs e)<br />
{<br />
string abd = "D:\\data\\File\\File1.csv";<br />
try<br />
{<br />
StreamReader rdr = new StreamReader(abd);<br />
while (rdr.Peek() >= 0)<br />
{<br />
dataGridView2.DataSource = CsvParser.Parse(rdr);<br />
}<br />
}<br />
catch (Exception)<br />
{<br />
MessageBox.Show("Error opening file.", "File Input Error",<br />
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);<br />
}<br />
}<br />
}
This works perfect, however if I have multiple files ( File0, File1, File2 .. etc ) I would like my method to loop through each file and process it. Is there an easy way of doing this.
Kind regards,
|
|
|
|
|
You can use Directory.GetFiles() to get all the files in the current directory. Then parse each file individually.
|
|
|
|
|
foreach (string fileName in Directory.GetFiles("path to the directory of files"))
{
}
|
|
|
|
|
Thank you guys , for your quick and accurate anwsers
|
|
|
|
|
Do any of u have idea about the structure of a database for a farm any link or guidance
Alrizq
|
|
|
|
|
table: animal
colums: ID, type, num_of_legs, color
table: crops
columns: ID, type
INSERT INTO animal (type, num_of_legs, color) VALUES ('cow', 4, 'brown')
INSERT INTO animal (type, num_of_legs, color) VALUES ('dog', 3, 'black')
INSERT INTO crop (type) VALUES ('corn')
INSERT INTO crop (type) VALUES ('wheat')
only two letters away from being an asset
|
|
|
|
|
|
Mark Nischalke wrote: INSERT INTO animal (type, num_of_legs, color) VALUES ('dog', 3, 'black')
pissing dog, huh?
"Throughout human history, we have been dependent on machines to survive. Fate, it seems, is not without a sense of irony. " - Morpheus
"Real men use mspaint for writing code and notepad for designing graphics." - Anna-Jayne Metcalfe
|
|
|
|
|
No, it's Tripod[^].
---
single minded; short sighted; long gone;
|
|
|
|
|
Guffa wrote: it's Tripod
"too much daily WTF for someone..." - Anton Afanasyev
|
|
|
|
|
Mark Nischalke wrote: INSERT INTO animal
Stop right there, I don't want to hear it!!
|
|
|
|
|
Sorry, guess I wasn't thinking up the Aussie sheep farmers around here.
only two letters away from being an asset
|
|
|
|
|
|
Ewwwwwwwwwwwwwwwwwwww
"too much daily WTF for someone..." - Anton Afanasyev
|
|
|
|
|
It could be worse. He can get much more verbose, thus descriptive, writing in COBOL!
|
|
|
|
|
Dave Kreskowiak wrote: He can get much more verbose, thus descriptive, writing in COBOL!
Then I'd change it from ewwwwwww to ughhhhhhhh ( which is my feelings about Cobol anyways )
"too much daily WTF for someone..." - Anton Afanasyev
|
|
|
|
|
depending where you are there may be strict regulatory requirements for data. Animals in the UK now have to be traceable. You need to may need to know parentanimals. Places the animal has moved to with dates. Animal passport Number etc.
Best bet is to talk to a farmer and see what they have to do on paper and try to replicate that. Don't try to replicate the whole mess of paperwork systems at once, concentrate on getting one working as well as possible and then add extra functionality later.
Russell
|
|
|
|
|
Is it possible to get the logged on users password or to use the users account to start an application?
We have two options: restart a windows service under the windows logon account or start an executable with the windows logon account.
If we start the application via the windows service it starts with the SYSTEM account and we don't want that.
Any ideas? Thanks...
|
|
|
|
|
No you can't retrieve the password.
You can change the account a service uses to logon with via the services management console.
only two letters away from being an asset
|
|
|
|
|
thanks, but wanted to it programmatically... .
We can't tell the user to this...
|
|
|
|
|
thanks, but wanted to do it programmatically... .
We can't tell the user to this...
|
|
|
|
|
V. wrote: Is it possible to get the logged on users pa
Nope.
V. wrote: restart a windows service under the windows logon accou
You have to supply the username AND PASSWORD in order to do this. The only way to get the users password is to ask for it and have them type it in. Then you can restart the service.
But, in the case of Windows XP, you can have multiple users logged in on the machine at any time. How is your service going to handle this situation? You really can't stop the service and change the account every time someone logs in.
If you have a process that needs to run under the users account, create your application as a normal console or Windows Forms .EXE and put a shortcut to it in the Startup folder. The app runs under the users security context when the user logs in.
|
|
|
|
|
Thanks for the reply.
Dave Kreskowiak wrote: If you have a process that needs to run under the users account, create your application as a normal console or Windows Forms .EXE and put a shortcut to it in the Startup folder. The app runs under the users security context when the user logs in.
Unfortunately it's not that easy, there is more to it then that.
we're searching in an entirely different direction now...
|
|
|
|
|
how can i add new button next to maximize or minimize buttons (on border of form)
|
|
|
|