Member Avatar for 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 ....

  • 2 Contributors
  • 5 Replies
  • 90 Views
  • 17 Hours Discussion Span
  • Latest Post Latest Post by ravichandra
Member Avatar for ravichandra

Concat the values with some special characters and store it.

Member Avatar for rashmigs84

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

Member Avatar for 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

Member Avatar for rashmigs84

Thanks a Lot.. i ll try doing this.

Member Avatar for 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

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.