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 ....

Concat the values with some special characters and store it.

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

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

Thanks a Lot.. i ll try doing this.

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.