OracelHelper class again!!

I need to insert records into a table from a form where can input my values.
I have to use the Microsoft Data Access Application Block , OracleHelper class only!!
I am having a nightmare from the time i was introduced to this DAAB, there are lots
of methods like ExecuteDataset,ExecuteReader,ExecuteScalar,ExecuteNonQuery

which one should i use
I did a lot of searching but the parameters which these methods are stored procedures
but i dont have any storeprocs.
i just have to do one small insertion
can anyone help me out??


vishnunarayanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

123654789987Commented:
For a simple insertion in the database u have to use the ExecuteNonQuery method with the following signature

public shared ExecuteNonQuery(connection as OracleConnection, commandText as string ) as Int

or u can use
     
public shared ExecuteNonQuery(connection as OracleConnection, CommandYype.Text,commandText as string ) as Int


u don't have to worry about any other parameters or overloads
0
vishnunarayanAuthor Commented:
Can i use something like

OracleHelper.ExecuteNonquery(sConnectionString as OracleConnection, CommandType.Text, commandText as string)
where
commandText = "insert into mytablename values(' ', ' ')"  ?????

I actually want to give my qurey as "select * from mytable"
and say recordset.addnew so that i can check for duplication in my table.
0
vishnunarayanAuthor Commented:
ok now i get it
ExecuteNonquery will return an integer value
i used it this way
Dim rtnvalue as integer

rtnvalue = OracleHelper.ExecuteNonQuery(sConnectionString, CommandType.Text, "INSERT INTO OraTest values (" & txtcatno.Text & "," & txtsiteid.Text & "," & txtCategory.Text & "," & txtEmail.Text & ")")

But this doubt of mine remains still

I actually want to give my qurey as "select * from mytable"
and say recordset.addnew so that i can check for duplication in my table
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

vishnunarayanAuthor Commented:
i want to use the qurey "select * from mytable " with a WHERE clause
which method should i use
0
mani_saiCommented:
First Step :
You can use ExecuteReader for the select query.

Second Step:
Check to see If it returns nothing then you can use ExecuteNonQuery for Insert.

Thanks

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
vishnunarayanAuthor Commented:
If i want to do the same in ASP.Net i think i can use the methods in the same way isnt't??
0
mani_saiCommented:
Sorry for the delay in replying.

Sure, you can do it the same way.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.