How to create a dynamic web service from windows application - C# Discussion Boards

5-Oct-09 1:43

Hi..i'm write following pl sql procedure to save data record.i have created a table called SETUP_TAB. i want to add to data from a datagridview in a form.can anyone please tell me how to do it.

PROCEDURE Insert___ (
id_ OUT VARCHAR2,
version_ OUT VARCHAR2,
rec_ IN OUT SETUP_TAB%ROWTYPE,
attribute_ IN OUT VARCHAR2 )

i have write following C# code also.but it gives "Invalid parameter binding" exception.

OracleConnection conn = new OracleConnection();
String str = "Data source=****;user ID=****;Password=****;";
conn.ConnectionString = str;
OracleCommand cmd = new OracleCommand("PROJX_INTEGRATION_SETUP.Insert___",conn);
cmd.CommandType = CommandType.StoredProcedure;

OracleParameter datarow = new OracleParameter();
datarow.ParameterName = "newrec_";
datarow.OracleDbType = OracleDbType.Raw;
datarow.Direction = ParameterDirection.InputOutput;
datarow.Value = this.dataGridView1.Rows[0];
cmd.Parameters.Add(datarow);

OracleParameter attr = new OracleParameter();
attr.ParameterName = "attr_";
attr.OracleDbType = OracleDbType.Varchar2;
attr.Direction = ParameterDirection.InputOutput;
cmd.Parameters.Add(attr);

OracleParameter o1 = new OracleParameter();
o1.ParameterName = "objid_";
o1.OracleDbType = OracleDbType.Varchar2;
o1.Direction = ParameterDirection.Output;
cmd.Parameters.Add(o1);

OracleParameter o2 = new OracleParameter();
o2.ParameterName = "objversion_";
o2.OracleDbType = OracleDbType.Varchar2;
o2.Direction = ParameterDirection.Output;
cmd.Parameters.Add(o2);

try
{
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
catch (OracleException ex)
{
MessageBox.Show(ex.Message, "Oracle Exception");
}

N a v a n e e t h5-Oct-09 2:17

N a v a n e e t h

5-Oct-09 2:17

Parameter names in your procedure and OracleParameter instance should match. Also you need to preserve the order in which parameters are added.

Navaneeth

How to use google | Ask smart questions

sampath_dr5-Oct-09 17:50

5-Oct-09 17:50

thank you for reply my post.i have done that in your way.but still it gives following exception. Frown | :(

"Invalid parameter binding
Parameter name: rec_"

here is my modified code.

OracleParameter rec_ = new OracleParameter();
rec_.ParameterName = "rec_";
rec_.OracleDbType = OracleDbType.Raw;
rec_.Direction = ParameterDirection.InputOutput;
rec_.Value = this.dataGridView1.Rows[0];
cmd.Parameters.Add(rec_);

N a v a n e e t h5-Oct-09 18:08

N a v a n e e t h

5-Oct-09 18:08

As I said, parameters should be in the order which they have written in the procedure. So first id_ then version_ etc should come. rec_ should be the 3rd parameter.

Navaneeth

How to use google | Ask smart questions

sampath_dr5-Oct-09 18:43

5-Oct-09 18:43

yes..i have done that way..but still it gives same result. Confused | :confused:

PROCEDURE Insert___ (
id_ OUT VARCHAR2,
version_ OUT VARCHAR2,
rec_ IN OUT PROJX_INTEGRATION_SETUP_TAB%ROWTYPE,
attribute_ IN OUT VARCHAR2 )

===========================================================
OracleParameter id_ = new OracleParameter();
id_.ParameterName = "id_";
id_.OracleDbType = OracleDbType.Varchar2;
id_.Direction = ParameterDirection.Output;
cmd.Parameters.Add(id_);

OracleParameter version_ = new OracleParameter();
version_.ParameterName = "version_";
version_.OracleDbType = OracleDbType.Varchar2;
version_.Direction = ParameterDirection.Output;
cmd.Parameters.Add(version_);

OracleParameter rec_ = new OracleParameter();
rec_.ParameterName = "rec_";
rec_.OracleDbType = OracleDbType.Raw;
rec_.Direction = ParameterDirection.InputOutput;
rec_.Value = this.dataGridView1.Rows[0];
cmd.Parameters.Add(rec_);

OracleParameter attribute_ = new OracleParameter();
attribute_.ParameterName = "attribute_";
attribute_.OracleDbType = OracleDbType.Varchar2;
attribute_.Direction = ParameterDirection.InputOutput;
cmd.Parameters.Add(attribute_);

sampath_dr6-Oct-09 1:03

How to create a dynamic web service from windows application

6-Oct-09 1:03

I have sorted out my problem.thanks for all , special thank for "navaneeth" ... Laugh | :laugh:

AhmedMasum5-Oct-09 0:52

AhmedMasum

5-Oct-09 0:52

I am creating a windows application which take database configurations from user and save in an xml. I need some code help which will do the following task:
When the user press finish button:
1. It should create a web service which will be able to read data according to the database configuration.
2. Start the web service automatically
3. Configure the IIS server.
4. save the server address into a xml file which will be used by other to consume this service.

All the above points should be done in a single finish button click.
How can I do that. I need some guideline and sample code for that.

Re: How to create a dynamic web service from windows application

sashidhar5-Oct-09 1:50

Re: How to create a dynamic web service from windows application

5-Oct-09 1:50

dokhinahaoa wrote:
It should create a web service which will be able to read data according to the database configuration.

No Method will create a webservice for You .The webservice should be created by Yourself depending upon your requirement and it should be called in finish button.

MyFirstArticlePublished: MenuControlSelectedItem
Why Do Some People Forget To Mark as Answer .If It Helps.

AhmedMasum5-Oct-09 2:29

AhmedMasum

5-Oct-09 2:29

I need some Idea for the following purposes please help me:

Suppose a user is installing my windows application. When the user completed installing, It should send a network address to me and start listening for sql from me. When I will send sql to the user's address it will execute it and return me the dataset or data table(I know how to execute sql and get dataset). As a result the final solution is that: The user will installe my application very easily and started to serve me by executing sql from his database. The user don't have to create a webservice on it's own. Everything should be done by my windows application. So what will I do. Is it possible to create web service and start listening by my windows application?(IIS server may be configured by executing a batch file). Or Should I use client/server socket programming for that? Please need suggestion and help somhow

Re: How to create a dynamic web service from windows application

sashidhar5-Oct-09 2:52

Re: How to create a dynamic web service from windows application

5-Oct-09 2:52

First things first.The client should have the access for the webservice (normally internet Connection should provide ie the webservice should run on webserver)

dokhinahaoa wrote:
It should send a network address

write a webmethod in webservice which returns the users ip address.

dokhinahaoa wrote:
When I will send sql to the user's address

AFAIK You cant send the sql to to the user's address using webservice.Lets Assume that You Sent.

Then If he receives the text and executes then write a webmethod in webservice for returning dataset. and You can Present the data.

dokhinahaoa wrote:
Or Should I use client/server socket programming for that?

Sorry I have no idea abt client/server socket programming..!

MyFirstArticlePublished: MenuControlSelectedItem
Why Do Some People Forget To Mark as Answer .If It Helps.

AhmedMasum5-Oct-09 3:00

AhmedMasum

5-Oct-09 3:00

Here user means another computer/server.But how the user will listen my sql. The user did not created any webservices on it's own. He just installed my windows application.My windows application should create,install,configure and start webservice and start listening for sql from me. My main terget is creating such windows application(This is a part of my full project).

c# and .NET 4.0 where do we stand?

CheifyW5-Oct-09 0:11

CheifyW

5-Oct-09 0:11

I've just gone through my re-birth from a 20Year veteran VB6 developer to a neophyte without a clue c# and .NET developer. I'm using the c# express download that Uncle Bill gave us for free, and I must admit, I am very impressed with it, and would not dream of going back. However, I see looming on the horizon a version 4.0!!!!so do you think that Uncle Bill will give us paupers free copies of that as well? or have we been drawn into the .NET web and be forced to buy upgrades.

Mirko19805-Oct-09 0:35

Mirko1980

5-Oct-09 0:35

There are already been two free Express editions of Visual Studio (2005 and 2008), so I don't see why there shouldn't be a 2010 version too.

N a v a n e e t h5-Oct-09 0:48

N a v a n e e t h

5-Oct-09 0:48

VS2010 is in beta now. Once final version is released, express versions also will be provided.

Navaneeth

How to use google | Ask smart questions

Eddy Vluggen5-Oct-09 2:18

Eddy Vluggen

5-Oct-09 2:18

CheifyW wrote:
and be forced to buy upgrades.

Where'd you get that idea? Anyone forcing you to buy an upgrade?

I are Troll Smile | :)

Re: How to append tables?

CheifyW5-Oct-09 21:42

CheifyW

5-Oct-09 21:42

Eddy, I don't know if you are being sarcastic or what Smile | :)

Uncle Billy has been forcing me to buy upgrades ever since VB2 hit the shelves a long way back.

How to append tables?

lalit145-Oct-09 0:10

lalit14

5-Oct-09 0:10

I want to add two tables row-wise using APPEND.

i dont know about it.

Please help me for this......!!

Thanks in Advance

sashidhar5-Oct-09 2:10

Re: How to append tables?

5-Oct-09 2:10

lalit14 wrote:
I want to add two tables row-wise using APPEND.

MindBlowing..! Confused | :confused:

which Tables? Database..!I think this is C# Forum
If Yes Use Join Not Append..!

MyFirstArticlePublished: MenuControlSelectedItem
Why Do Some People Forget To Mark as Answer .If It Helps.

lalit145-Oct-09 20:06

lalit14

5-Oct-09 20:06

Ya database tables but i want to append them with C# Coding not in SQl or MS Access

Re: How to append tables?

sashidhar5-Oct-09 20:12