|
Heloo,
How can i read a specific txt file and open a new 'mdb' file that will contain some things that the file has.
For instance,
The File contains:
00000 33333 22222 11111
ID=32 Name=Fox DATE=040208
33333 33333 33333 33333
Number=45 Add=LA Cell=12345678
22222 11111 22222 11111
ID=12 Name=LOLA DATE=020207
and so on....
i want to create a new mdb file that will contain a specific columns (ID,NAME,DATE,NUMBER,ADD,CELL)..
i want that the comp will read the file and ignore the numbers(on the first line,on the third line and on the fifth line) and the comp will add a new line for the mdb file(for example: gil.mdb)
it will very help me..
it is for my HUGE project..
thank you very much..
|
|
|
|
|
System.IO.StreamReader sr = new System.IO.StreamReader("c:\\1.txt");
String Line = sr.ReadLine();
And Look for String.Split to split string to array based on entry. And using String.Substring to get specific chars of specific lenght.
You need to manualy create parser to intercept and convert it to your DB writer
|
|
|
|
|
Hello All,
Array.FindAll, Array.Find and List<t>.RemoveAll() are not available in Silverlight. I'm looking for the equivalent Linq expressions of those methods. I'm also finding the equivalent one but it would be great if you guys can share if you already have something. thanks in advance..
|
|
|
|
|
I think it will work.
public static class ArrayHelper {
public static T Find<t>(T[] array,
Predicate<t> match) {
foreach (var o in array) {
if (match(o)) {
return o;
}
}
return default(T);
}
public static T[] FindAll<t>(T[] array,
Predicate<t> match) {
List<t> list = new List<t>();
foreach (var o in array) {
if (match(o)) {
list.Add(o);
}
}
return list.ToArray();
}
}
|
|
|
|
|
I have a custom button class that has some events. so do i need to remove the button events although though I am disposing the button object.
CustomButton b new CustomButton();
Fom1.Controls.Add(b);
b.MyEvent -= MyEventHandler(myEvent);
Fom1.Controls.Remove(b);
b.Dispose();
CustomButton b new CustomButton();
Fom1.Controls.Add(b);
Fom1.Controls.Remove(b);
b.Dispose();
|
|
|
|
|
I would think that disposing the button would remove the connection to the event procedure.
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my homepage Oracle Studios
Discounted or Free Software for Students:
DreamSpark - downloads.channel8.msdn.com
MSDN Academic Alliance - www.msdnaa.com
|
|
|
|
|
|
Hi there,
I am writing an application to run on the compact framework.
The application accepts data from a usb barcode scanner and validate the entry against data held on a file read sequentially.
If the barcode data does not match the data on the file I want my user to be able to decide to accept the entry or not, so far so good.
I have a problem with my messagebox.show selection.
The problem is that the messagebox does not display for longer than 1/2 a second or so and code keeps running until the end of the method without stopping.
ps:The carriage return marks the end data input.
Here is the code:
// Textbox to catch the data from the USB scanner
private void textBox1_KeyPress(object sender, KeyPressEventArgs e)
{
try
{
if (e.KeyChar == 13) // Catch carriage return from barcode
{
string scannedData = textBox1.Text.Trim();
this.lblBarCode.Text = scannedData;
if (validate_data(scannedData) == false)
{
this.textBox1.Enabled = false;
DialogResult dlgRes = MessageBox.Show("BarCode data does not match, Accept entry ?",
"Validate BarCode",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question,
MessageBoxDefaultButton.Button1);
if (dlgRes == DialogResult.Yes)
{
// TODO write to output file, don't forget system date !!
}
else
{
// TODO ignore input tidy up
}
}
else
{
// TODO write to output file, don't forget system date !!
}
}
}
catch (Exception z)
{
MessageBox.Show("Error " + z);
}
}
private Boolean validate_data(string scannedData)
{
int i = 0;
string lineData;
lineData = this.lstBoxFiles.SelectedItem.ToString();
i = lineData.IndexOf("-") + 1;
lineData = lineData.Substring(i);
if (lineData != scannedData)
{
return false;
}
else
return true;
}
}
Would any one be so kind as to explain what I am doing wrong.
Thank you
modified on Friday, July 11, 2008 9:55 AM
|
|
|
|
|
Is it the carriage return from the scanner that's invoking the button press on your message box?
If so try setting the e.handled property before showing your message box. Alternatively, most barcode scanners can be programmed to use the tab character instead of the carriage return - in fact that's the normal configuration in my experience. If you can configure it this way you can use the LostFocus event instead with no problems.
Dave
|
|
|
|
|
It is the carriage return invokes yes,
Thanks for your help, will try all this today
Thanks Dave,
modified on Friday, July 11, 2008 9:56 AM
|
|
|
|
|
Hi there,
I could still not make it work.
What I noticed is that if I display a messagebox in my keypress event when I run the code the messagebox displays then disappears without human intervention but the next messagebox does not?
I had to put two messageboxes one after the other in order to achieve my goal.
Pretty ugly I admit. I am missing some fundamental understanding somewhere.
I am running the code on an psion 8515, Compact Framework 3.5, OS windows CE.NET version 5.
Here is the code for anyone interested
private void textBox1_KeyPress(object sender, KeyPressEventArgs e)
{
try
{
if (e.KeyChar == (char)Keys.Return) // Catch carriage return from barcode
{
MessageBox.Show(""); // do not delete. I do not understand why but if we remove this event then the next message box does not stop.
e.Handled = true;
this.lblBarCode.Text = textBox1.Text.Trim();
if (validate_data(lblBarCode.Text) == false)
{
this.textBox1.Enabled = false;
switch(MessageBox.Show(" BarCode does not match, Accept BarCode ?",
"Validate BarCode", MessageBoxButtons.YesNo,
MessageBoxIcon.Question,
MessageBoxDefaultButton.Button1))
{
case DialogResult.Yes:
// TODO write to output file, don't forget system date !!
MessageBox.Show("Yes ");
break;
case DialogResult.No:
MessageBox.Show("No ");
// TODO ignore input tidy up
break;
}
}
else
{
// TODO write to output file, don't forget system date !!
}
}
}
catch (Exception z)
{
MessageBox.Show("Error in btnOpenSort_Click" + z);
}
}
private Boolean validate_data(string scannedData)
{
try
{
int i = 0;
string lineData;
lineData = this.lstBoxFiles.SelectedItem.ToString();
i = lineData.IndexOf("-") + 1;
lineData = lineData.Substring(i);
if (lineData != scannedData)
return false;
else
return true;
}
catch (Exception z)
{
MessageBox.Show("Error in validate_data " + z);
return false;
}
}
Thank you,
Scalpabob
modified on Friday, July 11, 2008 9:57 AM
|
|
|
|
|
Sorry for the delay in responding - I've only just checked this thread!
I stripped your code a little so I could just run it on a form with one textbox and it works fine!
private void textBox1_KeyPress(object sender, KeyPressEventArgs e)
{
try
{
if (e.KeyChar == (char)Keys.Return)
{
e.Handled = true;
if (validate_data(textBox1.Text.Trim()) == false)
{
this.textBox1.Enabled = false;
switch (MessageBox.Show(" BarCode does not match, Accept BarCode ?",
"Validate BarCode", MessageBoxButtons.YesNo,
MessageBoxIcon.Question,
MessageBoxDefaultButton.Button1))
{
case DialogResult.Yes:
break;
case DialogResult.No:
break;
}
}
}
}
catch (Exception z)
{
MessageBox.Show("Error in btnOpenSort_Click" + z);
}
}
private Boolean validate_data(string scannedData)
{
return false;
}
Have you tested it just inputting data using the keyboard? If it works for you that way you need to look into the configuration codes for the scanner.
Dave
|
|
|
|
|
Thanks for your help.
Indeed it works fine.
|
|
|
|
|
You're welcome 
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)
|
|
|
|
|
Hi,
I am reading data from an xml file.
The xml is set up so that there could be line feeds for some of the lines.
When I get these data back in the immediate window I see \n which I believe indicates the carriage return for each line?
How can I get rid of these?
Thanks
"\n use master\n go\n IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[uspGetDomainName]') AND type in (N'P', N'PC'))\n BEGIN\n EXEC dbo.sp_executesql @statement =
...
...
...
|
|
|
|
|
arkiboys wrote: How can I get rid of these?
String.Replace()
/ravi
|
|
|
|
|
Is it possible to read a specific cell or a range of cells from a spreadsheet document?
Thank you
|
|
|
|
|
|
I am trying to calculate the AVG for fields in a SQL SERVER database for a specified time interval. There may be times when there is no data for this interval. What would be the SELECT statement which will not execute the AVG of data if there is no data. I have tried to use "WHERE field IS NOT NULL", but this still throws an exception and stops execution of the program.
|
|
|
|
|
Instead of where clause use ISNULL(FieldName,'1900-1-1')
Good luck
Kutty
|
|
|
|
|
hi,
i am new to windows services and i have created a windows service which works fine when i manually start and stop it. i have changed the property to start the service automatically. and i need the service to start at the time of machine logging in. but the service is not starting. help me with fixing this issue. and this service is not related to any software. what it does is when the service is started is saves a string to the event viewer. but its not automatically started even if its property is set to start automatically.
|
|
|
|
|
karthi84 wrote: at the time of machine logging in
The Service will start when the Operating System starts, not when a user logs in.
You could use a Scheduled Task to do that. Especially if the "Service" writes and then exits, that's not what services are for.
Services normally start when the system starts, and run continuously until the system shuts down.
|
|
|
|
|
thanks for the reply. my problem is fixed. the problem was it was depending on a service which starts after this service starts. so i have fixed with this issue and once again thanks for your answer.
|
|
|
|
|
Are you running on Vista?
Dave
|
|
|
|
|
thanks for your time for replying me. my problem is fixed. the problem was it was depending on a service which starts after this service starts. so i have fixed with this issue and once again thanks for your answer.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
