Parsing Text file Data - C# Discussion Boards

Rick van Woudenberg28-Aug-07 22:00

28-Aug-07 22:00

Hi csanda,

You're trying to assign an insert statement as the value for integer t1, while an insert statement should be executed by itself and an integer can only have numbers as a value. I would do it differently. Try the following code :

void Whatever()<br />
{<br />
try<br />
{<br />
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=datacapt.mdb";<br />
OleDbConnection conn = new OleDbConnection(strConnection);<br />
conn.Open();<br />
string strCommand = "INSERT INTO compdata(ID,CompanyName,ContactName) Values ('" + txID.Text + "','" + txtName.Text + "','" + txtcontact.Text + "')";<br />
<br />
OleDbDataAdapter adapter = new OleDbDataAdapter();<br />
adapter.InsertCommand = new OleDbCommand(strCommand, conn);<br />
<br />
<br />
adapter.InsertCommand.ExecuteNonQuery(); <br />
conn.Close();<br />
<br />
{<br />
MessageBox.Show("Added successfully!");<br />
}<br />
}<br />
catch (Exception exc)<br />
{<br />
MessageBox.Show("An error occured :" + exc.ToString());<br />
}<br />
}

cheers,

Re: data type mismatch error

csanda129-Aug-07 0:09

csanda1

29-Aug-07 0:09

Hi,
Thanx for your reply, but it still returns the same error. Tell me is this code compatible with c# .net 2005.

Csanda

Re: data type mismatch error

J4amieC28-Aug-07 22:18

J4amieC

28-Aug-07 22:18

Although you can return a value from a call to ExecuteNonQuery, its slightly harder to setup as you must use output or return parameters from your query.

If you want to return a single value (say a 1 or 0 to indicate success/failure), you may find it easier to use ExecuteScalar. However, this returns a type called object which you must cast to an int (if that is what is being returned from the query)

Now, it is not clear from your code what t1 was supposed to return, but the sensible thing would be to return the new key from the table row just inserted. You could return 0 if the insert did not succeed and the rest of your code should then work fine.

I think @@IDENTITY works for Access for returning a newly inserted key, so your statement should change to:

string strCommand = "INSERT INTO compdata(ID,CompanyName,ContactName) Values ('" + txID.Text + "','" + txtName.Text + "','" + txtcontact.Text + "');SELECT @@IDENTITY";

then change:

int t1 = (int)adapter.InsertCommand.ExecuteScalar();

If @@IDENTITY does not work there will be loads of articles on the web about returning a newly inserted key.

---

How to get answers to your questions[^]

Re: data type mismatch error

PIEBALDconsult29-Aug-07 4:11

PIEBALDconsult

29-Aug-07 4:11

You might want to simplify it by not using the OleDbDataAdapter, but use an OleDbCommand directly.

string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=datacapt.mdb";
OleDbConnection conn = new OleDbConnection(strConnection);
conn.Open();
string strCommand = "INSERT INTO compdata(ID,CompanyName,ContactName) Values ('" + txID.Text + "','" + txtName.Text + "','" + txtcontact.Text + "')";

OleDbCommand comm = new OleDbCommand(strCommand, conn);

int t1 = command.ExecuteNonQuery(); 
conn.Close();

if (t1 > 0)
{
MessageBox.Show("added successfully!");
}

How to make a dialog box modal? [modified]

TaiZhong28-Aug-07 21:18

TaiZhong

28-Aug-07 21:18

I call the "GetOpenFileName" (Win32 API function) to creates and Open a dialog box. The dialog box is popped up but it is a modeless dialog. What I want is a modal dialog box. Anyone know how to solve this problem? Thanks.

-- modified at 5:35 Wednesday 29th August, 2007
I have to customise the OpenFileDialog so that it support the picture preview in the OpenFileDialog box. So I can't use the normal OpenFileDialog class.

Re: How to make a dialog box modal?

Bekjong28-Aug-07 22:58

Bekjong

28-Aug-07 22:58

Why not use the .net function in stead of the win32 one? You can show it modally like this:

OpenFileDialog ofd = new OpenFileDialog();
ofd.ShowDialog();

Standards are great! Everybody should have one!

Regasm Registration Problem

swamy Narasimha28-Aug-07 21:07

swamy Narasimha

28-Aug-07 21:07

Hi,
I have cretated one Class Library using C# and i have done tlbexp<dll> and red asm<dll>.
I wrote Client Application using win32 Console application by importing tlb.
but when Iam trying to do the CreateInstance it is giving "Class Not Registered".. Can ypu give me the Solution for this.

Thanks And Regards
Swamy

..swamy

Parsing Text file Data

MussaratAziz28-Aug-07 20:32

MussaratAziz

28-Aug-07 20:32

Hi dears, i have problem regarding spliting and parsing Data from TextFile.. i want to store that data into the database.
my file look like this.

Product Specs :
Ambient Temperature: ||-40ï¿½ to +40ï¿½C
Connector: ||N, BNC, TNC, 7/16
Coolant: ||Dry (Convection cooled)
Finish: ||Silver ot Tri-alloy plated
Frequency Range and VSWR: ||DC to 1 GHz at 1.10:1 max, 1 GHz to 6 GHz at 1.25:1 max. (N type), 1 GHz at 4 GHz at 1.25:1 max. (BNC and TNC)
Nominal Size Hmmm | :|

|(with Male N-type connector): 1.6" L x 0.8" Dia.,(40.7 mm x 20.4 mm)
Operating Position: ||Any
Power Rating: ||2 Watts
Weight: ||1.9 oz. (55 g)

"||" is a delimeter before this delimeter there is value like weight i want all these into a sperate AraryList and After the Delimiter i need to store all the data to the coresponding index of the first Arraylist...
Any help would be Appericiated.

Mussarat Aziz

Re: Parsing Text file Data

Christian Graus28-Aug-07 20:45

Christian Graus

28-Aug-07 20:45

Read each line, use the Split method to split on the ||, then write your database code from there.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: Parsing Text file Data

J4amieC28-Aug-07 22:11

J4amieC

28-Aug-07 22:11

MussaratAziz wrote:
Hi dears

This is a really creepy way to introduce your post in English. I think the more appropriate form would be something like "Hi everyone" or just "Hi".

Blush | :O

---

How to get answers to your questions[^]

Re: Parsing Text file Data

ChandraRam28-Aug-07 23:50

ChandraRam

28-Aug-07 23:50

I agree with you, but I have received a lot of mails from the UK starting with "Dear Chandra"... Is this a British thing, then?

Re: Parsing Text file Data

J4amieC29-Aug-07 0:32

J4amieC

29-Aug-07 0:32

Completely different.

The formal way to start a letter is indeed "Dear Surname", but you I would say to my wife "Hi dear"... outside of formal letter writing its a term of endearment.

---

How to get answers to your questions[^]

double click on ListBox items

Maddie from Dartford28-Aug-07 20:25

Maddie from Dartford

28-Aug-07 20:25

hello,
I am having list box on form filled with some items. I want to close the form on the double click on any of List items.

I am able to handle double click event but that is of ListBox control not of the item. So once the item is selected and somewhere else(not on item) user double clicks unintentionally then also it gives me selection.

Is there way i can hanldle the event only for double click on listBox items?

Thanks.

Re: double click on ListBox items

Martin#28-Aug-07 21:33

Martin#

28-Aug-07 21:33

Hello,

Interesting question!

I have a very dirty workaround for you. Some, might say I only provide dirty solutions Wink | ;)

.)
Easy solution would be to use the MouseDown event and chack the Clicks property of the MouseEventArgs.
I know that "Clicks>1" is not equal doubleclick, but maybe it fits for you.
Here you can do a check if the Y position of the MouseEventArgs is inside a region.
This region can be validated with the "PreferredHeight" property of the ArrayList class.
Dirty is, that it needs an offset depending on the "BoarderStyle" you are using.
Here an example:

private void yourListBoxes_MouseDown(object sender, System.Windows.Forms.MouseEventArgs e)
{
	//Not really DoubleClick, but maybe ok for you
	if(e.Clicks>1)
	{
		ListBox ActListBox = sender as ListBox;
		int YactHeight;
		if(ActListBox.BorderStyle == BorderStyle.None)
		{
			YactHeight= ActListBox.PreferredHeight;
		}
		else
		{
			YactHeight= ActListBox.PreferredHeight - 8;	//Offset needed
		}
		if(e.Y<=YactHeight)
		{
                        //Is inside Items region
                        //Do stuff here
                }
	}
}

If you need it more often I would suggest you to inherit your ownb ListBox.
This should override the OnMouseDown method and do the validation there.
If the position is inside the Items region you could fire an custom event there, which you handle in your code.

.)
The other solution could be, to handle the DoubleClick.
As the System.EventArgs do not provide a act position, you would have to use the Cursor position in combination with the controls position PointToScreen.

Hope it helps!

All the best,

Martin

Re: double click on ListBox items

Maddie from Dartford29-Aug-07 2:04

Maddie from Dartford

29-Aug-07 2:04

Thanks a lot Martin.

I was approaching to ur suggestion only. Meanwhile i got other suggestion also. I would like to share it with you.

Add this to your double-clicked event handler:

Point p = Cursor.Position;
p = listBox1.PointToClient(p);
if (listBox1.IndexFromPoint(p) != -1)
{
//An item was double-clicked!
}

it also works fine for me.

Re: double click on ListBox items

Martin#29-Aug-07 2:11

Martin#

29-Aug-07 2:11

Hello,

Interesting!

I was close with my second suggestion, but never heard of "IndexFromPoint" before.

Thanks for the feedback!
Got my '5'!

All the best,

Martin

reports in c#

Sonia Gupta28-Aug-07 20:13

Sonia Gupta

28-Aug-07 20:13

Actually I am using MSAccess And i am storing only the path of image now in this case what I have to do in order to show the images in the cystal reports

Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....

Rendering movie in Desktop background

Anindya Chatterjee28-Aug-07 19:54

Anindya Chatterjee

28-Aug-07 19:54

Hallo,
Anybody there please help me to show me how I can render movie as desktop wallpaper (like Dreamscene in Vista) using managed DirectX and C# ?

Thanks in advance...

Anindya Chatterjee

Word file parser

Rahul.RK28-Aug-07 19:13

Rahul.RK

28-Aug-07 19:13

Hello friends,

I want to do word file parsing. i want to fetch out particular information from it.

E.g. I want to take email id , phone etc from resume document.

What thing should be used for this. I have searched ineterop library may be helpfull

for this. What other things are there.

Thanks in Advance.

Rahul Kulkarni

Re: Word file parser

Justin Perez29-Aug-07 1:43

Justin Perez

29-Aug-07 1:43

What type of doucment is it you ware wanting to parse? Is the file fixed width, or is it delimited?

I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")

Calling BRE rules in C# project

Prashant C28-Aug-07 19:13

Prashant C

28-Aug-07 19:13

How to call BRE rules in C# applications like windows forms or web form, if possible please provide samples....

Prashant

Re: Calling BRE rules in C# project

Michael Sync28-Aug-07 19:46

Michael Sync

28-Aug-07 19:46

parasu_516 wrote:
How to call BRE rules

What is BRE?

parasu_516 wrote:
C# applications like windows forms or web form

What do you mean?? Blush | :O

C# application can be Windows form or webform....

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.