Solved

multiple line inserts

Posted on 2004-08-30
4
166 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

717 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