Experts Exchange connects you with the people and services you need so you can get back to work.

convert from vb to c#

I have the following simple vb code. How to convert to c#? Thanks.

Dim conn = New OracleConnection(System.Configuration.ConfigurationManager.AppSettings("ConnectionString"))
Dim CMD = New OracleCommand
Dim da = New OracleClient.OracleDataAdapter(CMD)
Dim ds = New DataSet

CMD.Connection = conn
conn.Open()

CMD.CommandTEXT = "MY_PROC"

CMD.Parameters.Add("in_psr_type", OracleType.VarChar)
CMD.Parameters("in_psr_type").Value = Request.QueryString("in_type")

CMD.CommandType = CommandType.StoredProcedure

da.SelectCommand = CMD
da.Fill(ds, "ContactRequests")

conn.Close()

ewang1205

Asked: 2006-11-02

Advertise Here

1 Solution

LVL 52

Carl TawnSystems and Integration DeveloperCommented: 2006-11-02

OracleConnection conn = new OracleConnection(System.Configuration.ConfigurationManager.AppSettings("ConnectionString"));
OracleCommand CMD = new OracleCommand();
OracleClient.OracleDataAdapter da = new OracleClient.OracleDataAdapter(CMD);
DataSet ds = new DataSet();

CMD.Connection = conn;
conn.Open();

CMD.CommandText = "MY_PROC";

CMD.Parameters.Add("in_psr_type", OracleType.VarChar);
CMD.Parameters["in_psr_type"].Value = Request.Querystring["in_type"];

CMD.CommandType = CommandType.StoredProcedure;

da.SelectCommand = CMD;
da.Fill(ds, "ContactRequests");

conn.Close();

LVL 15

ozymandiasCommented: 2006-11-02

OracleConnection conn = new OracleConnection(System.Configuration.ConfigurationManager.AppSettings("ConnectionString"));
                  OracleCommand CMD = new OracleCommand();
                  OracleDataAdapter da = new OracleDataAdapter(CMD);
                  DataSet ds = new DataSet();

                  CMD.Connection = conn;
                  conn.Open();

                  CMD.CommandText = "MY_PROC";

                  CMD.Parameters.Add("in_psr_type", OracleType.VarChar);
                  CMD.Parameters["in_psr_type"].Value = Request.QueryString("in_type");

                  CMD.CommandType = CommandType.StoredProcedure;

                  da.SelectCommand = CMD;
                  da.Fill(ds, "ContactRequests");

                  conn.Close();

LVL 15

ozymandiasCommented: 2006-11-02

doh!

Question has a verified solution.

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

convert from vb to c#

Join & Write a Comment Already a member? Login.

Featured Post