|
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");
}
|
|
|
|
|
Parameter names in your procedure and OracleParameter instance should match. Also you need to preserve the order in which parameters are added.
|
|
|
|
|
thank you for reply my post.i have done that in your way.but still it gives following exception.  
"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_);
|
|
|
|
|
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.
|
|
|
|
|
yes..i have done that way..but still it gives same result.
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_);
|
|
|
|
|
I have sorted out my problem.thanks for all , special thank for "navaneeth" ... 
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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..!
|
|
|
|
|
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).
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
VS2010 is in beta now. Once final version is released, express versions also will be provided.
|
|
|
|
|
CheifyW wrote: and be forced to buy upgrades.
Where'd you get that idea? Anyone forcing you to buy an upgrade?
I are Troll 
|
|
|
|
|
Eddy, I don't know if you are being sarcastic or what Uncle Billy has been forcing me to buy upgrades ever since VB2 hit the shelves a long way back.
|
|
|
|
|
I want to add two tables row-wise using APPEND.
i dont know about it.
Please help me for this......!!
Thanks in Advance
|
|
|
|
|
lalit14 wrote: I want to add two tables row-wise using APPEND.
MindBlowing..!
which Tables? Database..!I think this is C# Forum
If Yes Use Join Not Append..!
|
|
|
|
|
Ya database tables but i want to append them with C# Coding not in SQl or MS Access
|
|
|
|
|
For tht purpose also You added it with join query in the query ..!Or You want to append columns and present it in datagrid..!
Can You Be More Clear?
|
|
|
|
|
Hi all,
Would like to explain the need first,
There is device attached to the server, device reads data, server validates it and stores in the DB.
So, this part is put in as windows service.
But, simultaniously, data also need to be put into TCP channels so that other systems can access the data directly(real time application).
i.e., if the UI application is running the client side then it takes data from the TCP channel and show it to the user.
Is it the correct way of doing real time applcation?
I could able to connect the windows service and the UI applcation. But it is working in local system only. There is previlage error if i put the UI application in other system.
Please let me know is there any other efficient method or how can i solve this issue.
Regards,
Kishor
|
|
|
|
|
So, considering you haven't said anything about how your client is connecting to the service, or anything else useful about your app or the error message your getting, how is anyone supposed to answer this?
|
|
|
|
|
I appologise for that.
Let me brief the application,
1) There are many devices connected in the network
2) All the devices report to the server (the windows service located in server will monitor each device)
3) Rate at which device read may be 100 read/sec.
4) When device reads the data comes to the server thorugh the windows service and this service will post the data on the TCP channel and also the DB. (DB is for storing data permnently and TCP channel data is for instant and temporary use)
5) There may be any number of clients connected on the network. who actually get the TCP channel data and show the instant(real time) report(if the client system is ON).
code used to collect the data from TCP channel is :
remotableMessage =(ServiceMessageRemotable)Activator.GetObject(typeof(ServiceMessageRemotable),"tcp://localhost:9090/ServiceMessage");
MessageBox.Show(remotableMessage.serviceMessage.Message);
Here in this is line, localhost is used. I would like know how it can be done for remote server.
I gave IP address instead of localhost. But it is saying "NO previlage". Please advice.
Also, i would like to know that is this the efficient/safe way of real time data handling.
Regards,
Kishor
|
|
|
|
|
This program open source to do forms style circle
Ameen alseady
|
|
|
|
|
amen al-seady wrote: This program open source to do forms style circle
Ameen alseady
Excellent. That's great news. I'll form a human chain around the world and give it a hug.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
