Data Grid

Discussion in 'ASP General' started by Rajani, Oct 4, 2004.

  1. Rajani

    Rajani Guest

    Hello,
    I need to enter many entries at a time related to my production. Like
    operatorID,operationNO,qty,nohours bla bla
    I already designed page. But its used to enter one record at a time. I want
    to allow user to enter all operators details for a specific date at a time. I
    tried using ADO Connection and ADO recordset. When set the properties, its
    displaying error. Its not connecting to database.
    How can i use this? or is there any tool having this feature for free? I am
    using access database. I want to use this in my LAN only.

    Thanx in advance
     
    Rajani, Oct 4, 2004
    #1
    1. Advertisements

  2. From your subject line, I'm assuming that you're using ASP.NET. This group
    is a "classic" ASP group, so you probably won't find your answer here. I
    suggest posting in an ASP.NET group, such as
    microsoft.public.dotnet.framework.aspnet.datagridcontrol. When you do, say
    what the error is and what code is producing it! "displaying error" isn't
    descriptive enough.

    Ray at home

    "Rajani" <> wrote in message
    news:...
    > Hello,
    > I need to enter many entries at a time related to my production. Like
    > operatorID,operationNO,qty,nohours bla bla
    > I already designed page. But its used to enter one record at a time. I
    > want
    > to allow user to enter all operators details for a specific date at a
    > time. I
    > tried using ADO Connection and ADO recordset. When set the properties, its
    > displaying error. Its not connecting to database.
    > How can i use this? or is there any tool having this feature for free? I
    > am
    > using access database. I want to use this in my LAN only.
    >
    > Thanx in advance
     
    Ray Costanzo [MVP], Oct 4, 2004
    #2
    1. Advertisements

  3. Rajani

    Mark Schupp Guest

    You will need to show the code that is not working and any error message
    that is generated. Database structure would be helpful as well.

    --
    Mark Schupp
    Head of Development
    Integrity eLearning
    www.ielearning.com


    "Rajani" <> wrote in message
    news:...
    > Hello,
    > I need to enter many entries at a time related to my production. Like
    > operatorID,operationNO,qty,nohours bla bla
    > I already designed page. But its used to enter one record at a time. I

    want
    > to allow user to enter all operators details for a specific date at a

    time. I
    > tried using ADO Connection and ADO recordset. When set the properties, its
    > displaying error. Its not connecting to database.
    > How can i use this? or is there any tool having this feature for free? I

    am
    > using access database. I want to use this in my LAN only.
    >
    > Thanx in advance
     
    Mark Schupp, Oct 4, 2004
    #3
  4. Rajani

    Rajani Guest

    Hello,
    i am using classic ASP only.
    I want to enter data at once related to specific date. The entry includes
    checkbox, select control, text box bla bla. The select control options are
    retrieved from database. I already designed page. But it is used to enter
    only one record at a time. Instead, i want to enter all records belongs to
    trans_date at once. Like Grid.

    When i submit the form(grid) it checks for duplicates. I have primary key
    column in the table. But its not only used for duplicate checking.

    Table Structure:

    indexno empid trdate opr_no qty pay_type overtime(Y/N) nohours
    othours

    Note: the same empid can have more than one record satisfying the condition
    opr_no,pay_type,trdate(these must be different). Indexno is autonumber field.
    I want to enter bulk data at a time.
    I select trans_date and in the next form i want to show a grid to enter
    empid, operation_no, qty, pay_type, nohours, ot(Y/N), othours





    "Mark Schupp" wrote:

    > You will need to show the code that is not working and any error message
    > that is generated. Database structure would be helpful as well.
    >
    > --
    > Mark Schupp
    > Head of Development
    > Integrity eLearning
    > www.ielearning.com
    >
    >
    > "Rajani" <> wrote in message
    > news:...
    > > Hello,
    > > I need to enter many entries at a time related to my production. Like
    > > operatorID,operationNO,qty,nohours bla bla
    > > I already designed page. But its used to enter one record at a time. I

    > want
    > > to allow user to enter all operators details for a specific date at a

    > time. I
    > > tried using ADO Connection and ADO recordset. When set the properties, its
    > > displaying error. Its not connecting to database.
    > > How can i use this? or is there any tool having this feature for free? I

    > am
    > > using access database. I want to use this in my LAN only.
    > >
    > > Thanx in advance

    >
    >
    >
     
    Rajani, Oct 5, 2004
    #4
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. AD
    Replies:
    1
    Views:
    1,181
    Francis Shanahan
    Aug 23, 2003
  2. krian
    Replies:
    1
    Views:
    636
    Mike Moore [MSFT]
    Nov 12, 2003
  3. josephrthomas
    Replies:
    1
    Views:
    2,901
  4. Dave

    No data in data grid

    Dave, Dec 24, 2003, in forum: ASP .Net
    Replies:
    1
    Views:
    417
    Cowboy \(Gregory A. Beamer\)
    Dec 24, 2003
  5. C Newby
    Replies:
    7
    Views:
    812
    C Newby
    Apr 2, 2004
  6. Brian Henry

    boarders on data grid only on data items

    Brian Henry, Jul 8, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    504
    Brian Henry
    Jul 8, 2004
  7. =?Utf-8?B?UGF1bA==?=

    move data from grid to data set ?

    =?Utf-8?B?UGF1bA==?=, Oct 13, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    392
    Girish Bharadwaj
    Oct 13, 2004
  8. =?Utf-8?B?cG11ZA==?=
    Replies:
    2
    Views:
    1,179
    =?Utf-8?B?cG11ZA==?=
    Jan 10, 2005
Loading...