There is a multilinetextbox.i want to insert the data into database [Resolved]

Posted by Santosh.Choudhury under ASP.NET on 4/12/2012 | Points: 10 | Views : 1424 | Status : [Member] | Replies : 5
There is a multilinetextbox.There are some data which are separated by comma when i click in insert button then all these are inserted in different column divide by comma.
example :
santosh,ram,shyam

all are inserted in 3 column
santtosh
ram
shyam Then how is posoble




Responses

Posted by: Kavi.Sirius on: 4/12/2012 [Member] Starter | Points: 25

Up
0
Down
hi,
whether u want to insert the data in one column or three different columns

if u want to on column means

use "string builder"
or
eg:
string strCoordinates = string.Empty;
strCoordinates = textbox1.Text + "," + textbox2.Text +"," + textbox3.Text + "," + textbox4.Text;




Regards
Kavi.n

Santosh.Choudhury, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Santosh.Choudhury on: 4/12/2012 [Member] Starter | Points: 25

Up
0
Down

ya i want to insert it in 3 different column .please tell me how i use string split() function.give me a small example

Santosh.Choudhury, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Santosh.Choudhury on: 4/12/2012 [Member] Starter | Points: 25

Up
0
Down
yes thankss sakthi.


Santosh.Choudhury, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Kavi.Sirius on: 4/12/2012 [Member] Starter | Points: 25

Up
0
Down
hi sakthi,

i didt get the question correctly.k
now explain clearly

Regards
Kavi.n

Santosh.Choudhury, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Kavi.Sirius on: 4/12/2012 [Member] Starter | Points: 25

Up
0
Down
kk fine
thank u


Regards
Kavi.n

Santosh.Choudhury, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response