Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

multiple line inserts

Posted on 2004-08-30
4
Medium Priority
?
168 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 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

604 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