Storing the Trilateral Index Value

[rashmigs84]

hi

i got a problem regarding inserting value into database.
i have 2 labels and one textbox.. but in database only one cell is there to store these three values.please let me know the solution for this..

thanks ....

[ravichandra]

Concat the values with some special characters and store it.

[rashmigs84]

this information is not enough for me to try with the codes.. pl let me know some sample codes
thank

[ravichandra]

string value=Label1.Text+"/"+Label2.Text+"/"+TextBox1.Text

INSERT INTO EMP(NAME)VALUES(value)

While retrieving the value, you can use

string retrievedValue = "data_table_field_value"
string [] names=retrievedValue.split('/')

The names array will contain the values after splitting.

Good Luck

[rashmigs84]

Thanks a Lot.. i ll try doing this.

[ravichandra]

But what if you want to create a substring array separated by more than one characters like '#$' or '#$%' ?
Please refer the following thread:
http://www.daniweb.com/forums/thread113322.html
Mr. SerkanSendur has written a nice method (SplitText) which returns a substring array separated by more than one characters like '#$' or '#$%.

Good Luck

Thanks Mr. SerkanSendur