Problem on retrieving data from database to C#windows Form.

Question

Good Afternoon Guys

This is Nagarjuna working as a .net developer.I am facing a problem in C# windows form.My problem was

Actually in my database one filed value is '12Years'.I have to retrieve that value to my windows form like '12' value in one textbox and 'Years' to combobox. I am enable to solve that.So,any one plz resolve it.

Thanks & Regards

Nagarjuna Naidu

7 Seas IT Services

Dorababu Meka · Answer

You can do some thing like this to extract the numbers from string string Number= Regex.Match(yourdbcolumn @\d+).Value; As per your requirement string strYears = 12Years; string[] strArray = Regex.Matches(strYears @[a-zA-Z]+|\d+).Cast ().Select(year => year.Value).ToArray(); textBox1.Text = strArray[0].ToString(); comboBox1.Items.Add(strArray[1].ToString()); comboBox1.SelectedIndex = 0;