Pulling records from the database

debjanib · April 14th, 2006, 12:26 PM

Hi, I have another problem.
In my database I have a field Firstname and Lastname.Now In my datagrid I have to merge both the firstname and the lastname together with a space in between and it will be called as Fullname.Moreover the list of name will be linked to their email address.
Pls help

dutguoyi · April 14th, 2006, 10:21 PM

Code:

                                                                VB
                                                                <asp:TemplateColumn HeaderText="FullName">
                                                                     <ItemTemplate>            
                                                                        <a href='<%#"mailto:"+Container.DataItem("email")%>'>
                                                                        <%# Container.DataItem("firstname")%><%# Container.DataItem("lastname")%>                        
                                                                        </a>
                                                                    </ItemTemplate>
                                                              </asp:TemplateColumn>  
                                                               C#
                                                                <asp:TemplateColumn HeaderText="FullName">
                                                                     <ItemTemplate>            
                                                                        <a href='<%#"mailto:"+DataBinder.Eval(Container.DataItem,"email")%>'>
                                                                        <%# DataBinder.Eval(Container.DataItem,"firstname")%><%# DataBinder.Eval(Container.DataItem,"lastname")%>               
                                                                        </a>
                                                                    </ItemTemplate>
                                                              </asp:TemplateColumn>

debjanib · April 17th, 2006, 09:03 AM

Thank you so much. You are great.