String Split by Column wise Dynamically

Question

I have Put my String 1.0121,1.0131,1.0141,1.0151 This String Separated by Comma(,) My Output Ex. Col1 Col2 Col3 Col4 1.0121 1.0131 1.0141 1.0151 thank in Advance

Kiran Mohanty · Answer

string input = "1.0121,1.0131,1.0141,1.0151" ; var columnValues = input.Split( ',' ); for ( int i=1; i Console.WriteLine ( "Col" +i+ " " + columnValues[i]); }

Jignesh Kumar · Answer

Hi Manish, You can use string split with delemeter, here you have comma ',' as deleneter so you can use that to split, var stringInput = "1.0121,1.0131,1.0141,1.0151" ; var stringAfterSplit = stringInput.Split( "," ); foreach (string col in stringAfterSplit ) Console.WriteLine(col);

Rijwan Ansari · Answer

Try this code string input = "1.0121,1.0131,1.0141,1.0151" ; var columnValues = input.Split( ',' ); for ( int i=1; i Console.Write ( "Col" +i+ " " ); } Environment.NewLine; for ( int i=1; i Console.Write ( columnValues[i]); }

Tamil Selvan · Answer

Hi, Try this code as per your requirements. aspx: cs code: protected void Page_Load(object sender, EventArgs e) { splitdata(); } private void splitdata() { string a = "1.0121,1.0131,1.0141,1.0151" ; var val = a.Split( ',' ); List fields = new List (a.Split( new [] { ',' })); for ( int i=0; i { //grid1.DataSource = fields;//val //grid1.DataBind(); //create datatable and columns, DataTable dtable = new DataTable(); dtable.Columns.Add( new DataColumn( "Column 1" )); dtable.Columns.Add( new DataColumn( "Column 2" )); dtable.Columns.Add( new DataColumn( "Column 3" )); dtable.Columns.Add( new DataColumn( "Column 4" )); //simple way create object for rowvalues here i have given only 3 add as per your requirement object[] RowValues = { "" , "" , "" }; //assign values into row object RowValues[0] = val[0]; RowValues[1] = val[1]; RowValues[2] = val[2]; RowValues[1] = val[3]; //create new data row DataRow dRow; dRow = dtable.Rows.Add(RowValues); dtable.AcceptChanges(); //now bind datatable to gridview... grid1.DataSource = dtable; grid1.DataBind(); } } Thanks