473,241 Members | 1,472 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,241 software developers and data experts.

Data Grid

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
Jul 19 '05 #1
3 1623
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.datagridc ontrol. When you do, say
what the error is and what code is producing it! "displaying error" isn't
descriptive enough.

Ray at home

"Rajani" <Ra****@discussions.microsoft.com> wrote in message
news:32**********************************@microsof t.com...
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

Jul 19 '05 #2
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" <Ra****@discussions.microsoft.com> wrote in message
news:32**********************************@microsof t.com...
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

Jul 19 '05 #3
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" <Ra****@discussions.microsoft.com> wrote in message
news:32**********************************@microsof t.com...
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


Jul 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Jordan O'Hare | last post by:
Hello Everyone, I am after some help with the following: I have a windows application that contains a list box and two data grids. All three controls are binded to a dataset that contains...
2
by: kk | last post by:
Have 2 problems, any help is appreciated. Tab with Grids -------------- BL - fetching data from DB ( 5 secs - 10 rows) Grid Laod - 20 secs Grid Paint on tab change - 20 secs Problem: The...
5
by: pmud | last post by:
Hi, I need to display columns in a data grid based on 7 different queries. Now I have 32 questions: 1. Is it possble to have 1 single data adapter with 7 queries & 1 data set or do I need to...
2
by: Josef Meile | last post by:
Hi, I'm using a ComboBox, some Textboxes, and a DataGrid to represent a many-to-many relationship between Person and Course. Each time that I change the value in the ComboBox (which for now is...
6
by: Hutty | last post by:
I've looked around and have yet to find anything that would answer my question regarding formating a column in a datagrid. My grid looks like this as far as data" AMHQCON|51300.01|-3147 The...
3
by: pmud | last post by:
Hi, I have a web page (asp.net, code:c#). I havean html table with text boxes. Based on the user input , records are displayed in the data grid below it. Now the datagrid has a large no. of...
5
by: tshad | last post by:
Is there a way to carry data that I have already read from the datagrid from page to page? I am looking at my Datagrid that I page through and when the user says get the next page, I have to go...
0
by: hlam | last post by:
Help - Calculating the total of a column in a data grid -- when data grid is part of Master-Detail set-up I have setup a Master-Detail form using Visual Studio.Net. A ListBox is the (Master)...
9
by: Anil Gupte | last post by:
After reading a tutorial and fiddling, I finally got this to work. I can now put two tables created with a DataTable class into a DataRelation. Phew! And it works! Dim tblSliceInfo As New...
6
by: insirawali | last post by:
Hi all, I have this problem, i need to know is there a way i cn use the data adapter's update method in this scenario. i have 3 tables as below create table table1{ id1 int identity(1,1)...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.