comma seperated row in gridview

Question

0.00/5 (No votes)

See more:

Hi all,

I want to fetch comma seperated values in gridview.

means i have data like

Name keyskills
aarohi C#,Sql server

I want to fetch this two key skills in different row in gridview.

how can i do this . i use split function but it not works.

help!!!

Posted 27-Aug-12 21:14pm

aarohi verma

Updated 27-Aug-12 21:29pm

__TR__

v2

Add a Solution

Comments

Sandeep Mewara 28-Aug-12 4:59am

Tried anything?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mohamed Mitwalli · Accepted Answer · 2012-08-27T21:54:00

Solution 1

Hi ,
check this

C#

protected void Page_Load(object sender, EventArgs e)
   {
       string xx = " aarohi C#,Sql server";
      string [] All=  xx.Split(',').ToArray();
      GridView1.DataSource = All;
      GridView1.DataBind();
   }

Best Regards
M.Mitwalli

Posted 27-Aug-12 21:54pm

Mohamed Mitwalli

Comments

aarohi verma 28-Aug-12 4:13am

I have to fetch from database.so if i write GridView1.DataSource = All; this it not fetch from database .it only give string result.

Mohamed Mitwalli 28-Aug-12 4:25am

You mean it's stored in DB like this " aarohi C#,Sql server" and you want apply separated comma on it

aarohi verma 28-Aug-12 4:30am

ya . aarohi as 'name' and C#,sql server as 'keyskills' is my table and i want to different row in gridview for C# and Sql server.

Mohamed Mitwalli 28-Aug-12 4:39am

Could you give me your Table Schema Like
Name Keyskills
aarohi sql server , C#

and Final result would be

name Keyskills
aarohi C#
aarohi sql server Am i right

[no name] 28-Aug-12 5:02am

my 5's....

Mohamed Mitwalli 28-Aug-12 5:09am

Thanks Karthik

aarohi verma 28-Aug-12 5:02am

ya.

I have Two table

1 jobseeker personal detail,

table seekerInfo

id int identity(1,1) primary key,,
fname varchar(100),
country varchar(20),
state varchar(70),
city varchar(70),
mobno varchar(50),
LLno varchar(50),
sex varchar(50),
dob varchar(50),
matrialstatus varchar(10),
totexpyr varchar(10),
totexpmnth varchar(10),
sallac varchar(10),
salthousand varchar(10),
currentindustry varchar(70),
functionarea varchar(70),
keyskill varchar(MAX),
resumeheadline varchar(Max),
plocation varchar(90),
pfarea varchar(90),
pindustry varchar(90),
basicgradution varchar(100),
bsubject varchar(100),
byear varchar(50),
postgradution varchar(100),
pgsubject varchar(100),
myear varchar(50),
doctorate varchar(30),
course1 varchar(max),
course2 varchar(max),
course3 varchar(max),
course4 varchar(max),
course5 varchar(max),
uname varchar(30),
eid varchar(50),
password varchar(15),
resume varchar(max),
date1 date ,
date2 date,
logdate date,
dpname varchar(50)

and 2 table

for keyskills

fname varchar(100),
keyskill varchar(max)

and I want to use both this table and fetch the data in gridview keyskill wise.

i want output in gridview like this columnwise

Name | Email id | Fuctional Area | key Skilld

Mohamed Mitwalli 28-Aug-12 5:11am

aarohi Could you Check Solution 2

aarohi verma 28-Aug-12 7:52am

ya but error occurs at

for(int i=0;i<=dTable.rows.count;i++) at dTable.

aarohi verma 28-Aug-12 7:31am

I tried but not working database error occurs.

I tried this

<%-- <asp:TemplateField HeaderText="Client">
<itemtemplate>
<asp:Label ID="lblcname" runat="server" Text=<%# Eval("cname").ToString().Split(',')[0] %>>

--%>

and also from direct sql query but that also not work.
If you have some other solution than plz suggest me plz Mohamed and kartik.

Karthik J, Coimbatore · Accepted Answer · 2012-08-27T23:01:00

u r right Mohamed Mitwalli !!!

dear aarohi verma,

ur DataTable contains name column and keyskill column named dTable.

C#

// Create new DataTable.
DataTable myDataTable = new DataTable();
// Declare DataRow variables.
DataRow myRow;
for(int i=0;i<=dTable.rows.count;i++)
{
  myRow = myDataTable.NewRow();
  myRow["name"] = dTable.Row[i][0].ToString();

  //declare string global plz
  string xx = dTable.Row[i][1].ToString();
  string [] All=  xx.Split(',').ToArray();

myRow["keyskill_1"] = All[0].ToString() ;
myRow["keyskill_2"] = All[1].ToString() ;
myDataTable.Rows.Add(myRow);
}