Insert Insert Select - .net Experts

[sanfunnyguy09]

.Net &sql

 

From .net am passing var1, var2 to the sql SP which has couple f inser statements and one SELECT statement 

I f Use execute nonquery i can get the records get inserted properly.. but how to get the SELECT stmt results back to the .net scrren???????????

 

 

CREATE SP mySp

@var1,

var2

 

Insert stament..

Intesrt stement

 

select * from sometable

 

 

Ee sp lo last lo select stmnt ni .Net lo ela read cheyali..

 

 

Pls help....

[heropanthi]

execute reader use cheyu mayyaaaa

[sanfunnyguy09]

Apudu insert avvadu kada..

[Spartan]

what it this bootu puranam man... Insert Insert.....

[sanfunnyguy09]

what it this bootu puranam man... Insert Insert.....

pakkana .Net ani pettina kada sitti... :5_2_108:

[Pichkaari]

ltt

[Suhaas]

ExecuteNonQuery select ki work avvadhu bhayya. Use ExecuteReader instead. 

[sanfunnyguy09]

ExecuteNonQuery select ki work avvadhu bhayya. Use ExecuteReader instead. 

Appudu insert stmts pancichesthaya?

[Suhaas]

Appudu insert stmts pancichesthaya?

 

Yes. Certainly. 

[saradagakasepu]

ExecuteReader();

[Suhaas]

 

ExecuteNonQuery() use chey...oka outparameter pass chey.....

 

.NET code 

this.AddParameter(new OracleParameter("o_OUTPUTPARAMETER", OracleDbType.Int64, ParameterDirection.Output));

Command.ExecuteNonQuery();

if (Command.Parameters["o_OUTPUTPARAMETER"].Value != null)

    string something = Command.Parameters["o_OUTPUTPARAMETER"].Value.ToString();

 

 

store proc

INSERT INTO table(column1, column2)

VALUES (value1,value2)

RETURNING returnvalue INTO o_OUTPUTPARAMETER;

COMMIT;

 

 

Multipe output result set kavali bhayya TS ki. ExecuteNonQuery will only return the count of number of rows effected anthe so ExecuteReader needs to be used. 

[gudachari007]

I think this is helpful.

 

using (IDataReader reader = command.ExecuteReader())

                {

                    // get all column names

                    for (int i = 0; i < reader.FieldCount; i++)

                    {

                        columns.Add(reader.GetName(i));

                    }

 

                    while (reader.Read())

                    {

                        T obj = GetItem<T>(reader, columns);

 

                        list.Add(obj);

                    }

                }