Solved

multiple line inserts

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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
cannot connect to sqlserver 8 35
Store results in vb.net 3 24
How do sunrise and sunset times change with altitude 14 38
Calculate number of nights between two dates 5 54
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
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 video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

830 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