Click here to Skip to main content
15,041,525 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
i have to capture bank account information of client on a web form ,client can have multiple bank accounts. instead of using different textbox's like bank acctno1 , bankacctno2 etc. i want to insert it in single column.
how can i do this in c#.
pls help.
__TR__ 3-Dec-12 1:42am
When you say "insert it in single column" are you referring to inserting data into SQL server?
ruby kaur 3-Dec-12 2:16am
i mean accepting data from single textbox and inserting them into different column of sql server 2008
__TR__ 3-Dec-12 2:54am
I am assuming you have multiple account numbers in a single textbox and each account number is separated by a comma. If this is the case you can pass the textbox value to a SQL function and the function will split the account number into rows.
Check this link[^] for the sql function.

Concatenate your bankaccount number by special character

bankaccount = bankaccount1.Text+"~"+bankaccount2.Text+"~"+....
Why don't you add some component like Expanders?
Try to make a new type of Expander in your columns,add your values as many as you like.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900