Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
S

sampath_dr

@sampath_dr
About
Posts
14
Topics
6
Shares
0
Groups
0
Followers
0
Following
0

Posts

Recent Best Controversial

  • How to convert portlet into gadget
    S sampath_dr

    First of all thanks Gray for your reply, :) yes,I mean java portlets convert to google gadgets.Some portlets i have source,but for some i only have url only.I don't want to rewrite them as gadgets.Again thanks Gray :)

    Web Development tutorial

  • How to convert portlet into gadget
    S sampath_dr

    Hi all. I don't know this is the correct section to post my question,if it wrong please forgive me. Anybody know How to convert portlet into gadget.I searched it google but didn't find useful links.Frown .If anybody know it please support. thanks.

    XML / XSL tutorial question

  • How to convert portlet into gadget
    S sampath_dr

    Hi all. Anybody know How to convert portlet into gadget.I searched it google but didn't find useful links. :( .If anybody know it please support. thanks.

    Web Development tutorial

  • Comparing two xml files
    S sampath_dr

    Can you explain it more.may be i can help.

    XML / XSL question com sysadmin xml

  • Comparison or travel algorithm for n-ary tree
    S sampath_dr

    Anyone know about travel or comparison algorithm for n-ary tree.please help me..:confused::confused:

    Algorithms algorithms data-structures help

  • please help me : How to call Pl sql function return record type in C#
    S sampath_dr

    i'm doing my indusrial training these days.To my project need it.can you help me? thank you reply my post.

    C# database csharp help tutorial workspace

  • please help me : How to call Pl sql function return record type in C#
    S sampath_dr

    OracleConnection conn = new OracleConnection(); String str = "Data source=****;user ID=****;Password=****;"; conn.ConnectionString = str; OracleCommand cmd = new OracleCommand("Setup_API.Get", conn); cmd.CommandType = CommandType.StoredProcedure; OracleParameter id_ = new OracleParameter(); id_.ParameterName = "id_"; id_.OracleDbType = OracleDbType.Varchar2; id_.Value = "11"; id_.Direction = ParameterDirection.Input; cmd.Parameters.Add(id_); i have write this code..and can you tell me how to get return value(record) and and how to set it inti dataset.i'm new to C#,pl sql.thank you for reply my post.:confused::confused:

    C# database csharp help tutorial workspace

  • please help me : How to call Pl sql function return record type in C#
    S sampath_dr

    Hi all.. ======================================== TYPE Public_Rec IS RECORD (user_id SETUP_TAB.user_id%TYPE, tool SETUP_TAB.tool%TYPE, database SETUP_TAB.database%TYPE); ======================================== FUNCTION Get ( id_ IN VARCHAR2 ) RETURN Public_Rec IS temp_ Public_Rec; CURSOR get_attr IS SELECT user_id, tool, database FROM SETUP_TAB WHERE id = id_; BEGIN OPEN get_attr; FETCH get_attr INTO temp_; CLOSE get_attr; RETURN temp_; END Get; ======================================== can any one tell me how to this function and set return value to dataset.:confused::confused:

    C# database csharp help tutorial workspace

  • Oracle stored procedure call in C#
    S sampath_dr

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

    C# database csharp oracle wpf wcf

  • Oracle stored procedure call in C#
    S sampath_dr

    yes..i have done that way..but still it gives same result.: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_);

    C# database csharp oracle wpf wcf

  • Oracle stored procedure call in C#
    S sampath_dr

    thank you for reply my post.i have done that in your way.but still it gives following exception. :( :confused: "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_);

    C# database csharp oracle wpf wcf

  • Oracle stored procedure call in C#
    S sampath_dr

    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"); }

    C# database csharp oracle wpf wcf

  • Password field in datagridview,C#
    S sampath_dr

    // // dataGridView2 // this.dataGridView2.AllowUserToAddRows = false; this.dataGridView2.AllowUserToDeleteRows = false; this.dataGridView2.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;this.dataGridView2.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { this.inteSetupI, this.inteExtPlanTool, this.inteExtPlanToolDB, this.inteExtPlanToolUID, this.inteExtPlanToolPW}); this.dataGridView2.Location = new System.Drawing.Point(6, 6); this.dataGridView2.Name = "dataGridView2"; this.dataGridView2.Size = new System.Drawing.Size(716, 300); this.dataGridView2.TabIndex = 0; // // inteExtPlanToolPW // this.inteExtPlanToolPW.HeaderText = "External Planing Tool Password"; this.inteExtPlanToolPW.Name = "inteExtPlanToolPW"; this.inteExtPlanToolPW.Resizable = System.Windows.Forms.DataGridViewTriState.True; thank you ravimori to answer my question.this is my code.i want to use "inteExtPlanToolPW" culomn as password fild.can explain it with code.thank you.

    C# csharp tutorial

  • Password field in datagridview,C#
    S sampath_dr

    Anyone please tell me how to add password column to datagridview in C#. :( :( :( :( :( :( thanks.

    C# csharp tutorial
  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups