Binding Values from Single column of databes to Multiple column in GridView

Question

0.00/5 (No votes)

See more:

Hello,

I have to Bind values from Single column of database to multiple column in Gridview.
I.e. Suppose I have column "Name" in table having value "Firstname.Lastname",now I have to bind "Firstname" in one column and "Lastname" in other column.

Please help me..

Thanks in advance.

Posted 5-Apr-12 1:08am

rahulbhadouria

Add a Solution

Comments

sjelen 5-Apr-12 9:07am

Both solutions below will work, but you should consider having two separate columns in database. How would you sort records by last name in your current database?

Member 10486850 27-Dec-13 7:25am

code to bind same column value in the grid view

Member 10486850 27-Dec-13 7:25am

code to bind same column value in the grid view...plzz reply urgent

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)

Reza Ahmadi · Answer 1 · 2012-04-05T01:58:00

Hi,
You can do it using a code like this:

ASP.NET

<asp:lable name="FirstName" text="<%# GetFirstName(Bind("Name"))%> />
<asp:lable name="LastName" text="<%# GetLastName(Bind("Name"))%> />

In your code behind you need to write these methods:

C#

public string GetFirstName(string name){
  //TODO write code to split your string and return the FirstName
}


public string GetLastName(string name){
  //TODO write code to split your string and return the LastName
}

Ii hope it will help,
Cheers.

Ankur^\m/ · Answer 2 · 2012-04-05T01:58:00

Create a DataTable which will have 2 columns - FirstName and LastName (or the required number of columns). Populate it with the existing data returned from database using some logic to separate the values (say based on white space). You can do this while reading the values as well (if you are using a SqlDataReader). Bind the GridView to this DataTable.

This is one of the way that first came to my mind. There could be different ways to do this.
Hope this helps!

Binding Values from Single column of databes to Multiple column in GridView

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0