Split the Value of databse field in asp.net

Question

Split the Value of databse field value like agm.txt,egm.txt.And use it in asp.net page

Jignesh Kumar · Answer

Hi Priyanka, You can use asEnumberable on dataset. DataTable dt = new DataTable(); dt.Columns.Add( "Id" , typeof ( int )); dt.Columns.Add( "Attachment" , typeof ( string )); dt.Rows.Add(1, "abc.txt, xyz.txt" ); dt.Rows.Add(2, "abc.txt, xyz.txt" ); dt.Rows.Add(3, "abc.txt, xyz.txt" ); var SelectedValues = dt.AsEnumerable().Select(s => s.Field string >( "attachment" ).Split( ',' )).ToArray(); You will get all splited values in SelectedValues

Priyanka Singh · Answer

I want to split it and use it on cs page '> ' Text="Click Here" /> along with gridview what code should be written that for a single text like agm.txt a single hyperlink clicl here is display and egm.txt another hyperlink displayed

Kalyani Shevale · Answer

try this code string str="Hello World,programming"; string [] tokens = str.Split( ',' ); String QuestionId="some,there,off,something"; List string > QuestionNFileName = new List string >(QuestionID.Split( new string [] { "," }, StringSplitOptions.None));

Kalyani Shevale · Answer

U want SQL query or c# code????

Priyanka Singh · Answer

protected void gvMasters_RowDataBound( object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { HiddenField lblAttachement = (HiddenField)e.Row.FindControl( "hda" ); string attacment = "" ; if (lblAttachement.Value != "" ) { string [] att = lblAttachement.Value.Split( ',' ); int k = 0; for (var a = 0; a { k = k + 1; if (att.Length == 1) { attacment = attacment + " + att[a] + "'>CLICK HERE" + " " ; } else { attacment = attacment + " + att[a] + "'>CLICK HERE-" + k.ToString().Replace( "1" , "I" ).Replace( "2" , "II" ) + " " ; } } strb.Append(attacment); } else { strb.Append(attacment); } } }

Jignesh Kumar · Answer

Hi Priyanka, Please find below code. string strResult= "agm.txt,egm.txt" ; string [] values = strResult.Split( ',' ); for each(var splitedValue in v alues) { Console.WriteLine( splitedValue ); }

Priyanka Singh · Answer

C# code