gridview problem so please help me out!!

Question

0.00/5 (No votes)

See more:

, +

hello,

i need to show a gird view in a page having data with comma in between them.

example of data in the table..
emp id.........emp Language
1.................English
2.................Russian
1.................Spanish
1.................American
2.................Chinise

i need to show the grid view like:

emp id........emp language
1................English,Spanish,American
2.................Russian,Chinise

please help ...

thanx in advance.

Posted 27-Nov-12 18:34pm

ishandeb

Add a Solution

1 solution

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)

Mohd. Mukhtar · Accepted Answer · 2012-11-27T18:40:00

Solution 1

Hi Ishan,

Write your query with the COALESCE option. This will resolve your problem.

SQL

SELECT empid ,REPLACE(RTRIM((SELECT empLanguage + ' ' FROM TableName WHERE ( empid  = Results.empid  ) FOR XML PATH (''))),' ',', ') AS NameValues
FROM TableName Results
GROUP BY empid

Apply below code to bind checkbox

C#

for(int i=0;i<lstCheckBox.Items.Count;i++)
{ 
   for(int j=0;j<ds.Table[0].Rows.Count;j++)
   {
      if(lstCheckBox.Items[i].Value == ds.Table[0].Rows[j]["LanguageId"].ToString())
           lstCheckBox.Items[i].Selected = true;
   }
}

Posted 27-Nov-12 18:40pm

Mohd. Mukhtar

Updated 27-Nov-12 21:05pm

v4

Comments

[no name] 28-Nov-12 0:44am

hello Mukhtar,
can u give me an example please..

Mohd. Mukhtar 28-Nov-12 0:57am

Yeah sure please have a look above query and try to run.

[no name] 28-Nov-12 1:41am

can u help me out once more...
how to repopulate this languages names to checkbox list...

Mohd. Mukhtar 28-Nov-12 1:45am

If you want to repopulate then you need to split the language with "," separator and after that you can bind checkbox.

[no name] 28-Nov-12 1:54am

but i need to bind the checkbox with both the value and text.
language names are only the text but the values are the language id.
can u give me an example please.

Mohd. Mukhtar 28-Nov-12 2:03am

In this case you need to execute select command on language table.

SELECT languageId, languageName FROM tblLanguage;

Then bind the result with checkboxlist.

[no name] 28-Nov-12 2:07am

select T3.LanguageName ,T2.EmpName,T1.EmpId,T1.LanguageId
from EmpLanguage T1 left outer join
Employee T2 on T1.EmpId=T2.EmpId left outer join
Language T3 on T1.LanguageId=T3.LanguageId
where T1.EmpId=@EmpId
I have written this query but how to bind it in the check box list..
please help me.

Mohd. Mukhtar 28-Nov-12 2:17am

Write below code in your aspx page.

<asp:CheckBoxList ID="lstCheckBox" runat="server" DataTextField='<%# Eval("LanguageName") %>' DataValueField=<%# Eval("LanguageId"%>'>

And Then bind the value with below code.

lstCheckBox.DataSource = queryResult; //query result should be dataset or datatable.
lstCheckBox.DataBind();

[no name] 28-Nov-12 2:24am

actually the checkboxlist is already binded i just need to check the boxes according to the language he has selected earlier.

Mohd. Mukhtar 28-Nov-12 2:45am

Hmmm

Mohd. Mukhtar 28-Nov-12 2:56am

Apply the below code.

for(int i=0; i

Mohd. Mukhtar 28-Nov-12 3:06am

see updated answer.

[no name] 28-Nov-12 3:22am

string[] items = paramEmpLanguageInfo.LanguageName.Split(',');
for (int i = 0; i <= items.GetUpperBound(0); i++)
{

for (int j = 0; j < cklLanguage.Items.Count; j++)
{
ListItem currentCheckBox= cklLanguage.Items.FindByText(items[i].ToString())
if (currentCheckBox != null)
{
currentCheckBox.Selected = true;
}
}
}
can u solve this one out...

Mohd. Mukhtar 28-Nov-12 3:36am

string[] items = paramEmpLanguageInfo.LanguageName.Split(','); for (int i = 0; i <= items.Length; i++)
{
ListItem currentCheckBox= cklLanguage.Items.FindByText(items[i].ToString())
if (currentCheckBox != null)
{ currentCheckBox.Selected = true; } }

[no name] 28-Nov-12 3:46am

no... the string items has the languages..
now i need to check the items in check box list with the items in the string items. if both of them are equal then the list in the check box will be selected..
for this one i have this code..
string[] items = paramEmpLanguageInfo.LanguageName.Split(',');
for (int i = 0; i <= items.GetUpperBound(0); i++)
{

for (int j = 0; j < cklLanguage.Items.Count; j++)
{
ListItem currentCheckBox= cklLanguage.Items.FindByText(items[i].ToString())
if (currentCheckBox != null)
{
currentCheckBox.Selected = true;
}
}
}

Mohd. Mukhtar 28-Nov-12 4:43am

Yes correct. For this you are using FindByText, And this will fetch only those item which is avail into the array item, So it will just select that item.

[no name] 28-Nov-12 1:39am

Thanx a lot....
u made my day....
thank you very much...

Mohd. Mukhtar 28-Nov-12 1:43am

Welcome :-)

Mohd. Mukhtar 28-Nov-12 3:02am

Apply the below code.

for(int i=0; i

Member-515487 28-Nov-12 3:08am

what if i want to in place of empLanguage a number
it getting error Error converting data type varchar to numeric.

Mohd. Mukhtar 28-Nov-12 3:21am

It is because empLanguage is char string and hence you can not convert it into integer.

[no name] 29-Nov-12 1:03am

hi how r u??

Mohd. Mukhtar 29-Nov-12 1:17am

Hi,

me fine, What abt you?

BTW this is not a place for chatting ;-)

[no name] 30-Nov-12 3:41am

lol... well said...
can i have ur gmail id...
i can mail u if i need some help..

Mohd. Mukhtar 30-Nov-12 3:49am

yeah sure,

mukhtar.bhumca@gmail.com