User Profile

Collapse

Profile Sidebar

Collapse
riyap
riyap
Last Activity: Feb 11 '08, 05:24 PM
Joined: Nov 19 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • riyap
    replied to to add a character value to datarow in vb.net
    in .NET
    Thanks for the response
    i used "P" as you said that was working but
    my doubt is how to update this data table in msaccess DB using vb.net
    i used
    datatables dlog3 has selected values(i.select command values) and dlog2 has updated values(changed new values) so how to relate these 2 datatables and update in db table
    if possible can u give me the code
    its would be really helpfull
    Code:
    comm=select
    ...
    See more | Go to post

      Leave a comment:

    • riyap
      started a topic update query in vb.net for access DB
      in .NET

      update query in vb.net for access DB

      hi i have 2 tables
      i want to update few table 1 fields to table 2 both have same primary keys
      please help me how to do it
      table1(id,sno,b illingsys,name, phone) has data in all fields
      table2(id,sno,b illingsys,a/cno,contactname ,contactphone)h as data in primarykey field and a/cno
      Primary kew for both table are (id,sno)
      (id is text,sno is Number)
      i want to update contactname,con tactphone with name and phone...
      See more | Go to post
      • riyap
        replied to Bulk Insert of Data using Oracle
        in .NET
        do you want to insert bulk data into oracle
        then use sqlloader
        See more | Go to post

          Leave a comment:

        • riyap
          replied to Asp .Net: SqlException on Update
          in .NET
          are you calling any stored procedure
          or just updating the values
          See more | Go to post

            Leave a comment:

          • riyap
            started a topic Where condition for Access DB in Vb.net
            in .NET

            Where condition for Access DB in Vb.net

            hello
            im new to vb.net
            can anyone help me
            how to write a select,update commands for access database in VB.net 2005
            if i have to check 2 fields in criteria 1 integer and another text

            eg table1 has
            id Number
            status text
            phone text

            qry1 = select phone from table where id = '+id+' and status = 'status'

            and i want to update table2(id,statu s,ph)
            so want...
            See more | Go to post
            • riyap
              started a topic to update using datatable,dataset,data adapter
              in .NET

              to update using datatable,dataset,data adapter

              Hi
              i have a question regarding a update in msaccess DB using string builder,DATA SET AND DATA RELATIONS
              can we do that in access DB
              i have a table in access i need to pass more than 1 record and get o/p value and update in table again
              so for this i used :
              i have 2 datatables which i loaded with select command n records in
              dlog1 ,dlog2
              so im passing log 1 values into oracle stored procedure ,i got...
              See more | Go to post
              • riyap
                started a topic to add a character value to datarow in vb.net
                in .NET

                to add a character value to datarow in vb.net

                hi
                can anyone let me know
                how to add a character value to datarow.item
                for example
                i wanted to add a status field value with "S" then how can i add it using vb.net
                i did in many ways but its still showing value=nothing

                Code:
                                    drTemp1 = dlog2.NewRow
                    drTemp1.Item("status") = "'P'"
                    drTemp1.Item("errMsg")
                ...
                See more | Go to post
                • riyap
                  started a topic update in DB using stringbuilder,datarelations
                  in Visual Basic

                  update in DB using stringbuilder,datarelations

                  Hi,
                  can anyone guide me how to update a access db with datatables and string builder
                  im trying to update 3 columns

                  does sb.Append(drRel .Item("id").ToS tring() & ",") this means im i updating the feild value into DB.
                  my program is a big process
                  so i just need help on update thing
                  it also have select command to filter records and call the stored proc in oracle nd insert and...
                  See more | Go to post
                  • riyap
                    replied to oracle stored procedure
                    in Oracle
                    i did in vb.net for oracle database and the error im getting is
                    im passing values to the package
                    Code:
                    ORA-01036:illegal variable name/number
                    can you please hellp me with this
                    See more | Go to post

                      Leave a comment:

                    • riyap
                      replied to hi output parameter value in vb.net(stored Procedure)
                      in Visual Basic
                      i already created package in oracle database
                      and these are the 2 param im passing if i send the input param il get the output param value
                      but how to put the value there
                      im getting following error
                      ORA-01036: illegal variable name/number

                      can you help me with this...
                      See more | Go to post

                        Leave a comment:

                      • riyap
                        started a topic oracle stored procedure
                        in Oracle

                        oracle stored procedure

                        hi can anyone let me know how to get a output param value from stored procedure
                        i used following code to get the o/p value from stored procedure
                        so near .value what i need to give
                        if keep it blank it is giving me error
                        for input we can give a value but not for output
                        what i need to write near "?????"

                        Code:
                        sqlComm = New OracleCommand

sqlComm.Parameters.Add(New OracleParameter("p_title",
                        ...
                        See more | Go to post
                        Last edited by amitpatel66; Nov 29 '07, 04:39 AM. Reason: code tags
                        • riyap
                          started a topic hi output parameter value in vb.net(stored Procedure)
                          in Visual Basic

                          hi output parameter value in vb.net(stored Procedure)

                          hi can anyone let me know how to get a output param value from stored procedure
                          i used following code to get the o/p value from stored procedure
                          so near .value what i need to give
                          if keep it blank it is giving me error
                          for input we can give a value but not for output
                          what i need to write near "?????"

                          sqlComm = New OracleCommand

                          sqlComm.Paramet ers.Add(New OracleParameter ("p_title",...
                          See more | Go to post
                          • riyap
                            started a topic to assign parameter values from access qry to oracle stored procedure
                            in Visual Basic

                            to assign parameter values from access qry to oracle stored procedure

                            i understood the oracle procedure
                            but only question is after executing the access db query, how do i assign those values(each field values) to the parameters iam passing into oracle procedure
                            i.e value=???
                            how do i give the access fields values to oracle parameters and pass it

                            Code:
                            sqlComm.Parameters.Add(New OracleParameter("name", OracleType.VarChar)).Value = [B]value[/B]
            sqlComm.Parameters.Item("name").Direction
                            ...
                            See more | Go to post
                            • riyap
                              replied to Re:stored procedure in oracle-to insert values and get output value
                              in .NET
                              i understood the oracle procedure
                              but only question is after excuting the acess db query, how do i assign those values(each field values) to the parameters im passing into oracle procedure
                              i.e value=???
                              how do i give the access feilds values to oracle parameters and pass it
                              Kindly help me
                              ur help is appreciated
                              See more | Go to post

                                Leave a comment:

                              • riyap
                                replied to Stored procedure in oracle
                                in Visual Basic
                                i understood the oracle procedure
                                but only question is after excuting the acess db query, how do i assign those values(each field values) to the parameters im passing into oracle procedure
                                i.e value=???
                                how do i give the access feilds values to oracle parameters and pass it
                                Kindly help me
                                ur help is appreciated...
                                See more | Go to post

                                  Leave a comment:

                                • riyap
                                  replied to Stored procedure in oracle
                                  in Visual Basic
                                  Thanks For your help
                                  Il have a look at it
                                  See more | Go to post

                                    Leave a comment:

                                  • riyap
                                    started a topic Stored procedure in oracle
                                    in Visual Basic

                                    Stored procedure in oracle

                                    hi
                                    can anyone help me to simplify my logic in writing code,
                                    i have ms acess database table.i want to get the data from there(using select command with where clause) and insert into a stored procedure in oracle database.
                                    stored procedure package has 8 i/p fields and 1 output feilds.
                                    when i insert fields i need to get the o/p value from it and update it into ms acess DB table.

                                    My doubt is how to get data from...
                                    See more | Go to post
                                    • riyap
                                      started a topic Re:stored procedure in oracle-to insert values and get output value
                                      in .NET

                                      Re:stored procedure in oracle-to insert values and get output value

                                      hi
                                      can anyone help me to simplify my logic in writing code,
                                      i have ms acess database table.i want to get the data from there(using select command with where clause) and insert into a stored procedure in oracle database.
                                      stored procedure package has 8 i/p fields and 1 output feilds.
                                      when i insert fields i need to get the o/p value from it and update it into ms acess DB table.

                                      My doubt is how to get data...
                                      See more | Go to post
                                      • riyap
                                        started a topic objDataRow? what it means
                                        in .NET

                                        objDataRow? what it means

                                        hi all, can anyone please explain me about the following fields
                                        what it does?we use that to close connection.so let me know what it actually does the job.

                                        objDataRow = Nothing

                                        objDataTable.Di spose()

                                        objDataTable = Nothing

                                        objDataAdapter. Dispose()

                                        objDataAdapter = Nothing

                                        objCommand.Disp ose()

                                        objCommand = Nothing

                                        objConnection.D ispose()...
                                        See more | Go to post
                                        • riyap
                                          replied to Console application using vb.net
                                          in .NET
                                          Can you Please let me know how to add task scheduler
                                          im actually new in creating console applications

                                          Thanks
                                          See more | Go to post

                                            Leave a comment:

                                          No activity results to display
                                          Show More
                                          Working...