Split the Value of databse field in asp.net

Priyanka Singh

7y965.NET

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

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

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

I want to split it and use it on cs page

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

Hi Priyanka,

Please find below code.

try this code

String QuestionId="some,there,off,something";
List<string> QuestionNFileName = new List<string>(QuestionID.Split(new string[] { "," }, StringSplitOptions.None));

C# code

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