Wrox Programmer Forums
|
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 4th, 2004, 04:58 AM
Authorized User
 
Join Date: Aug 2004
Posts: 58
Thanks: 0
Thanked 0 Times in 0 Posts
Default Data Grid

Hello,

  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 retrived 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 on record satisfying the condition opr_no,pay_type,trdate(these must be different).

Thanx in advance

 
Old October 4th, 2004, 09:37 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Is your question that you want to bulk load data? Or add one and check it against the existing data?
 
Old October 4th, 2004, 08:19 PM
Authorized User
 
Join Date: Aug 2004
Posts: 58
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello bmains,

  I want to load bulk data. at the same time i want to check not to have duplicate entries.



 
Old October 5th, 2004, 07:26 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

From a data set or a file, upload and read the data into a dataset, which is where you could make comparisions. You could also store it in a temporary table in the actual database and use SQL to do your comparisions. This could be a DTS process, if you have SQL Server. You have your options. What is your data source?

Brian





Similar Threads
Thread Thread Starter Forum Replies Last Post
How to sort data in a data grid? zaheerabbas.sk ASP.NET 1.0 and 1.1 Basics 3 April 10th, 2007 02:37 PM
Export data from data grid to excel pomoc VB.NET 2002/2003 Basics 0 December 16th, 2005 03:11 PM
Export data from data grid to Excel pomoc Visual Basic 2005 Basics 0 December 16th, 2005 02:56 PM
trying to load db data into data grid itsajourney Beginning VB 6 2 June 7th, 2005 12:05 PM
About data grid Asteroid ASP.NET 1.0 and 1.1 Basics 4 December 9th, 2004 05:42 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.