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

Is your question that you want to bulk load data? Or add one and check it against the existing data?

Hello bmains,

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

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