Solved

multiple line inserts

Posted on 2004-08-30
4
160 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
  • 2
4 Comments
 
LVL 18

Expert Comment

by:DotNetLover_Baan
Comment Utility
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
Comment Utility
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
Comment Utility
Use datagrid... without any doubt...  Are you in a windows application ?  What is ur Database ?
-Baan
0
 
LVL 10

Expert Comment

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

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

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…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

763 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now