Solved

multiple line inserts

Posted on 2004-08-30
4
165 Views
Last Modified: 2010-04-23
I have a multiple line insert that I have to do.

 it contain these fields

 dd   mm   yyyy   procedure codes    surface codes   fees      other fees   total fees    and verification number
 dd   mm   yyyy   procedure codes    surface codes   fees      other fees   total fees    and verification number
 dd   mm   yyyy   procedure codes    surface codes   fees      other fees   total fees    and verification number
 dd   mm   yyyy   procedure codes    surface codes   fees      other fees   total fees    and verification number
 dd   mm   yyyy   procedure codes    surface codes   fees      other fees   total fees    and verification number
 dd   mm   yyyy   procedure codes    surface codes   fees      other fees   total fees    and verification number
 dd   mm   yyyy   procedure codes    surface codes   fees      other fees   total fees    and verification number
 dd   mm   yyyy   procedure codes    surface codes   fees      other fees   total fees    and verification number
 dd   mm   yyyy   procedure codes    surface codes   fees      other fees   total fees    and verification number
 dd   mm   yyyy   procedure codes    surface codes   fees      other fees   total fees    and verification number

I can have 0 to  10 entries.

how should I attack this situation.

should I make independent arrays of text boxes or datagrid but I am not sure in what I should do?

i will have to do business logic  for dates, procedure codes to see if exists, and surface codes to see if exists.



0
Comment
Question by:genesisproject
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 18

Expert Comment

by:DotNetLover_Baan
ID: 11938069
HI there,
your question is not clear enough.. but what I suggest, run a loop and execute INSERT statement 10 times.
-Baan
0
 

Author Comment

by:genesisproject
ID: 11938278
thank baan but my question is should i use datagrids to populate or create a 10 by 6 frame of text boxes
0
 
LVL 18

Accepted Solution

by:
DotNetLover_Baan earned 500 total points
ID: 11938301
Use datagrid... without any doubt...  Are you in a windows application ?  What is ur Database ?
-Baan
0
 
LVL 10

Expert Comment

by:123654789987
ID: 11940173
Considering that u have some business operations to be performed. Datagrid would be the ideal option
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question