User Profile

Collapse

Profile Sidebar

Collapse
kasukur
kasukur
Last Activity: Mar 10 '08, 10:16 AM
Joined: Feb 27 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • kasukur
    started a topic How can we mention Dataset to use the column default value if we don't give a value t
    in .NET

    How can we mention Dataset to use the column default value if we don't give a value t

    Hi

    what i was trying to do is, i am using Dataset to populate data and update the database. The problem is i have a column which is of type Varchar(1), doesn't accept Nulls and default value is 0

    when i insert a row through SQL and if i don't enter any value, it inserts 0 but when i try to do the same using Dataset it doesn't seem to be picking the default value and displaying an error message "A value must be...
    See more | Go to post
    • kasukur
      replied to How to call a SQL function which returns a cursor using c#
      in .NET
      How to call a SQL function which returns a cursor using c#

      Hi

      i am new to .net. Can someone please advise how to call a SQL function which returns a cursor using c#

      i have tried to call using
      Code:
      OracleCommand.CommandType = CommandType.StoredProcedure 
OracleParameter p_case_action_id = new OracleParameter("@p_case_action_id", OracleDbType.Int32);
p_case_action_id.Direction
      ...
      See more | Go to post
      Last edited by Plater; Mar 3 '08, 02:39 PM. Reason: added CODE tags

        Leave a comment:

      • kasukur
        replied to How to get column size of a table
        in .NET
        Thanks for your replies

        i can't use select query, what i need to do is call a stored procedure which returns me a cursor and i need to find out the actual defined size of each column

        Hope i'm clear

        thanks
        Sri
        See more | Go to post

          Leave a comment:

        • kasukur
          started a topic How to call a SQL function which returns a cursor using c#
          in .NET

          How to call a SQL function which returns a cursor using c#

          Hi

          i am new to .net. Can someone please advise how to call a SQL function which returns a cursor using c#

          i have tried to call using
          OracleCommand.C ommandType = CommandType.Sto redProcedure
          OracleParameter p_case_action_i d = new OracleParameter ("@p_case_actio n_id", OracleDbType.In t32);
          p_case_action_i d.Direction = ParameterDirect ion.Input;
          ...
          See more | Go to post
          • kasukur
            started a topic How to get column size of a table
            in .NET

            How to get column size of a table

            Hi

            Can someone please help me... It's seem like there is not a single way to get the column size from a dataset, table, datarow from SQL/Oracle in .Net using C# or VB

            Thanks in advance
            See more | Go to post
            No activity results to display
            Show More
            Working...