Concatenate columns into one

Question

Concatenate columns into one

Navigation

#1 by (1 votes)
#2 by (0 votes)
#3 by (0 votes)

1

I need to concatenate these two columns into one:

columna1: columns.Bound(c => c.primer_nombre).Title("Nombre").Width(30);
Columna2: columns.Bound(c => c.primer_apellido).Title("Apellido"=.Width(30);

That those two remain in a single column, how can I do that? It's ASP.NET with a framework called Kendo UI GRID.

This is the code environment I'm working on:

kendoui asp.net asp.net-mvc

asked by Felipe 16.09.2016 в 00:25

source

3 answers

transpilar angular 2 What is the asp.net equivalent of the "Execute" function of asp

score 1 · Answer 1

1

Maybe so?

columna1: columns.Bound(c => (c.primer_nombre + c.primer_apellido)).Title("Nombre y Apellido").Width(60);

answered by 16.09.2016 в 00:30

score 0 · Answer 2

Testing using a template is easier.

        .Columns(columns =>
        {
            columns.Bound(p => p.FirstName).Width(150);
            columns.Bound(p => p.LastName).Width(150);
            columns.Template(@<text></text>).ClientTemplate("#=FirstName# #=LastName#").Title("Full Name");


        })

score 0 · Answer 3

I need your help, I'm trying to concatenate my first and last name in an ASP.NET dropdownlist. This is my code and it does not work.

public void LLenarDdlCliente()
{

        string constr = ConfigurationManager.ConnectionStrings["FitposConnectionString"].ToString();
        SqlConnection con = new SqlConnection(constr);
        con.Open();
        SqlCommand com = new SqlCommand("SELECT CONCAT(nombre, apellidopat) AS 
        clientes FROM cliente", con);
        SqlDataAdapter da = new SqlDataAdapter(com);
        DataSet ds = new DataSet();
        da.Fill(ds);
        this.drpempleado.DataTextField = "clientes";
        drpempleado.DataSource = ds.Tables[0];
        drpempleado.DataBind();
}