|
Hi everyone,
I've recentley started using C# and am doing an application to insert data using oledataadapter and dataset, and i have an error data type mismatch in this line 'int t1 = adapter.InsertCommand.ExecuteNonQuery();' can anyone tell mi what that means and what ive done wrong, because all my data types are text. Here's the code below:
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 />
int t1 = adapter.InsertCommand.ExecuteNonQuery(); <br />
conn.Close();<br />
<br />
if (t1 > 0)<br />
{<br />
MessageBox.Show("added successfully!");<br />
<br />
}
Thanks very much
Csanda
|
|
|
|
|
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,
|
|
|
|
|
Hi,
Thanx for your reply, but it still returns the same error. Tell me is this code compatible with c# .net 2005.
Csanda
|
|
|
|
|
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.
|
|
|
|
|
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!");
}
|
|
|
|
|
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.
|
|
|
|
|
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!
|
|
|
|
|
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
|
|
|
|
|
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 |(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
|
|
|
|
|
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 )
|
|
|
|
|
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".
|
|
|
|
|
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?
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
Hello,
Interesting question!
I have a very dirty workaround for you. Some, might say I only provide dirty solutions 
.)
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)
{
if(e.Clicks>1)
{
ListBox ActListBox = sender as ListBox;
int YactHeight;
if(ActListBox.BorderStyle == BorderStyle.None)
{
YactHeight= ActListBox.PreferredHeight;
}
else
{
YactHeight= ActListBox.PreferredHeight - 8;
}
if(e.Y<=YactHeight)
{
}
}
}
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
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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....
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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")
|
|
|
|
|
How to call BRE rules in C# applications like windows forms or web form, if possible please provide samples....
Prashant
|
|
|
|
|
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?? 
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. 
|
|
|
|
|
Michael Sync wrote: What is BRE?
Assumption: Business Rules Engine (AKA Business Layer)
|
|
|
|
|
J4amieC wrote: Business Rules Engine (AKA Business Layer)
Oh.. Thanks...
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.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
