Re: Free "ORM" Application - Database Discussion Boards

Re: how to insert variable values in SQL server using INSERT INTO statement?

PIEBALDconsult7-Nov-10 4:12

7-Nov-10 4:12

It partly depends on what language you host your SQL in, also on which database system you use.

INSERT INTO table (field0, field1 ...) VALUES (@Param0, @Param1 ... )

Then create parameters.

Then, as you loop through the data to insert, set the parameters and execute the statement.

Re: how to insert variable values in SQL server using INSERT INTO statement?

RaviRanjanKr8-Nov-10 8:12

RaviRanjanKr

8-Nov-10 8:12

I let you from the beginning step by step to insert data into table

Create a connection by using SqlConnection class as

SqlConnection con = new SqlConnection("connectionString") // Connectionstring is responsible to store info to connect database.

then, you need to create Command object by SqlCommand Class as

string str = INTERT into mytable VALUES('"+str+"');
SqlCommand cmd = new SqlCommand(str,con); // str is responsible to hold you insert command and con is object of connection

then you need to execute query by using ExecuteNonQuery Method as

cmd.ExecuteNonQuery();

This is easiest way to insert data into table. Hope it will work for you.. Smile | :)

Re: how to insert variable values in SQL server using INSERT INTO statement?

MahaKh9-Nov-10 8:11

MahaKh

9-Nov-10 8:11

thanks a lot RaviRanjankr! for ur concern...but i have tried this is a simple one...actually + sign is not recognized in the query, it gives syntex error...but n e ways thanks a lot my problem has been solved now,thanks

Re: how to insert variable values in SQL server using INSERT INTO statement?

MDNadeemAkhter8-Nov-10 17:55

MDNadeemAkhter

8-Nov-10 17:55

if you don;t want to use parameter then simple make Connction and Command and Execute your command it will save your data.

Re: how to insert variable values in SQL server using INSERT INTO statement?

Pete O'Hanlon9-Nov-10 10:36

Pete O'Hanlon

9-Nov-10 10:36

Please don't give people bad advice like this. You've basically just advised the poster that they should leave themselves wide open to a SQL Injection attack, and that's not cool.

I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be

Forgive your enemies - it messes with their heads

My blog | My articles | MoXAML PowerToys | Onyx

Free "ORM" Application [modified]

baymyo3-Nov-10 22:09

baymyo

3-Nov-10 22:09

See link below for detailed information about the application.
http://www.codeproject.com/Messages/3656015/ORM-Application-and-Open-Source-database-layer.aspx[^]

modified on Thursday, November 4, 2010 10:04 AM

Re: Free "ORM" Application

Rajesh Anuhya4-Nov-10 1:06

Rajesh Anuhya

4-Nov-10 1:06

Rajesh B --> A Poor Workman Blames His Tools <--

Re: Free "ORM" Application

baymyo4-Nov-10 3:15

baymyo

4-Nov-10 3:15

i can't understand your comment? can you describe it?

Re: Free "ORM" Application

Chris Meech4-Nov-10 3:39

Chris Meech

4-Nov-10 3:39

Two Words.
First word, Homer. Smile | :)

Chris Meech
I am Canadian. [heard in a local bar]

In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]

posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]

Re: Free "ORM" Application

Simon_Whale4-Nov-10 3:46

Simon_Whale

4-Nov-10 3:46

please don't advertise your wares the forums please..

As barmey as a sack of badgers

Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.

Re: Free "ORM" Application

Mycroft Holmes4-Nov-10 4:29

Mycroft Holmes

4-Nov-10 4:29

This is inappropriate, you should be writing an article for CP rather than peppering links to your web/blog.

The only reason it is still here is that it is borderline.

Never underestimate the power of human stupidity
RAH

Re: Free "ORM" Application

baymyo4-Nov-10 5:05

baymyo

4-Nov-10 5:05

http://www.codeproject.com/Messages/3656015/ORM-Application-and-Open-Source-database-layer.aspx[^]

Re: Free "ORM" Application

scottgp4-Nov-10 5:40

scottgp

4-Nov-10 5:40

http://www.codeproject.com/Messages/3656304/Re-ORM-Application-and-Open-Source-database-layer.aspx

OracleCommandBuilder.DeriveParameters doesn't return parameters every time

Tesic Goran3-Nov-10 2:18

Tesic Goran

3-Nov-10 2:18

Hello,

I use Microsoft's Oracle client provider.

I have 2 Oracle stored procedures that do the same thing and have only different names:

SP1:

create or replace procedure GetScalar(last_name IN PERSON.LastName%TYPE, row_count OUT INTEGER)
as
begin
SELECT COUNT(*) INTO row_count FROM PERSON
WHERE LASTNAME = last_name;
end GetScalar;

SP2:

create or replace procedure Get_Bool(last_name IN PERSON.LastName%TYPE, r_count OUT INTEGER)
as
begin
SELECT COUNT(*) INTO r_count FROM PERSON
WHERE LASTNAME = last_name;
end Get_Bool;

I use the same C# code for both.

When I use stored procedure SP1 after this code was called:

OracleCommandBuilder.DeriveParameters(objCmd);
int n = objCmd.Parameters.Count;

n is 2, which is ok.

But, when I use stored procedure SP2:

n is 0, which is not ok.

What should I do yo make it work?

When I call both store procedures inside Oracle enviroment both work fine.

Re: OracleCommandBuilder.DeriveParameters doesn't return parameters every time

jschell4-Nov-10 9:46

jschell

4-Nov-10 9:46

Would help if code tags were used but it appears that the stored proc signature, excluding identifiers, is the same.

If that is the case then you have a faulty assumption.

You are assuming that a difference in identifies makes a difference. Excluding key word usage (which I do not see any) that is not possible.

Since it isn't possible it suggests that you need to look for a difference source of the problem.

So possible reasons are the following. This is not a complete list.
- The proc in your C# code is not named correctly.
- The proc does not exist in the database, or it is an older version with no parameters.
- You are pointing at a different database.

Re: OracleCommandBuilder.DeriveParameters doesn't return parameters every time

PIEBALDconsult7-Nov-10 8:51

PIEBALDconsult

7-Nov-10 8:51

Roll your own -- don't depend on automagic tools.

sql

jeyaranjani2-Nov-10 22:32

jeyaranjani

2-Nov-10 22:32

random question retrival from database

Re: sql

R. Giskard Reventlov2-Nov-10 23:29

R. Giskard Reventlov

2-Nov-10 23:29

You could always try asking a question.

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum

me, me, me

Re: sql

Luc Pattyn3-Nov-10 7:36

Luc Pattyn

3-Nov-10 7:36

the OP does not have a question, he wants to get a question, a random one.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

Re: sql

R. Giskard Reventlov3-Nov-10 7:40

R. Giskard Reventlov

3-Nov-10 7:40

I sets them up, he knocks them down...

Hey: fix cp vanity: I'm sure you can't have anything better to do Smile | :)

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum

me, me, me

Re: sql

Rajesh Anuhya4-Nov-10 1:04

Rajesh Anuhya

4-Nov-10 1:04