Add 2 columns in Grid, one with textboxes and another with button

[kostas]

Hello
I have a query and i bind the results with the following code

Dim oConn As OdbcConnection<br>
Dim connectionString As String<br>
connectionString = ConfigurationManager.ConnectionStrings("ODBCConnection").ToString<br>
oConn = New OdbcConnection(connectionString)<br>
commandString = "SELECT sCode as Κωδικός, sName as Περιγραφή,sUnitOM as ΜΜ,sWhsalePr as Λιανική From smast where sCode like '" + TextBox1.Text + "%' or sSuplCode like '" + TextBox1.Text + "%' order by scode"<br>
Dim myAdapter As New OdbcDataAdapter(commandString, oConn)<br>
Dim productDataSet As DataSet = New DataSet<br>       
myAdapter.Fill(productDataSet)<br>
RadGrid1.DataSource = productDataSet<br>
RadGrid1.DataBind()

I want to add 2 columns, one with textboxes and another with button so the user fills the desired quantity and then press the button to add the product to a shopping cart
Can you help me how to do that?
Thank you

[Shinu]

Hi,

I suppose you need to add a TextBox column and a Button column programmatically. Please try the following code snippet.

C#:

protected void Page_Init(object sender, EventArgs e)
{
    GridTemplateColumn templateColumn = new GridTemplateColumn();
    grid.MasterTableView.Columns.Add(templateColumn);
    templateColumn.ItemTemplate = new MyTemplate();
}

public partial class MyTemplate : ITemplate
{
    public void InstantiateIn(Control container)
    {
        TextBox textbox1 = new TextBox();
        textbox1.ID = "TextBox";
        textbox1.Text = "textbox1";
        Button btn = new Button();
        btn.Text = "Text";
        btn.ID = "Button1";
        container.Controls.Add(textbox1);
        container.Controls.Add(btn);
    }
}

Thanks,
Shinu.