dynamically create datagrid with prepopulated text boxes from datatable

[JulesBonnot]

Hi,
I need to build a datagrid dynamically, entirely in c# so no asp tags can be used.

I need my datagrid to contain a textbox in each cell; pre-populated with the corresponding value from the datatable.

My code creates the text box in each cell perfectly BUT every value in the columns is the value of the last cell in that column of the datagrid.

The InstantiateIn method doesn’t seem to be being called for each row and only runs once for the last row. I can’t figure it out....

I pretty inexperienced with c# so any answers would be most appreciated.

Please help.

Thanks,

Jules

//---------------My  c# Code Behind file-------------------- 
using System; 
using System.Collections.Generic; 
using System.Linq; 
using System.Web; 
using System.Web.UI; 
using System.Web.UI.WebControls; 
using System.Configuration; 
using System.Data; 
using System.Data.SqlClient; 
using System.Web.UI.HtmlControls; 
 
public partial class _Default : System.Web.UI.Page 
{ 
    protected void Page_init(object sender, EventArgs e) 
    { 
        GenerateDataGrids(); 
        if (!Page.IsPostBack) 
        { } 
    } 
 
 
    public void GenerateDataGrids() 
    { 
           //-- Instantiate the data set and table 
 
            DataSet ds = new DataSet(); 
 
            DataTable dt = ds.Tables.Add(); 
 
            //-- Add columns to the data table 
 
            dt.Columns.Add("ID", typeof(int)); 
 
            dt.Columns.Add("Book", typeof(string)); 
 
            dt.Columns.Add("Author", typeof(string)); 
 
            //-- Add rows to the data table 
 
            dt.Rows.Add(1, "1984", "George Orwell"); 
 
            dt.Rows.Add(2, "Notes from the Underground", "Fydor Dostoyevsky"); 
 
            dt.Rows.Add(3, "The Outsider", "Albert Camus"); 
 
            dt.Rows.Add(4, "Post Office", "Charles Buchowski"); 
 
            dt.Rows.Add(5, "The Chant of Maldoror", "Comte De Lautremont"); 
 
            DataGrid dg = new DataGrid(); 
 
            dg.ID = ID; 
            dg.DataSource = ds; 
            dg.AutoGenerateColumns = false; 
        
 
            DataTable Workdt = new DataTable(); 
            Workdt = ds.Tables[0]; 
 
 
            for (int i = 0; i <= dt.Columns.Count - 1; i++) 
            { 
                // Creating Template Column 
                 TemplateColumn tc = new TemplateColumn(); 
                 
                string columnName = dt.Columns[i].ColumnName; 
            
                tc.HeaderTemplate = new DataGridTemplate(ListItemType.Header, columnName); 
 
 
                for (int j = 1; j <= dt.Rows.Count - 1; j++) 
                { 
 
                    string RowCallName = dt.Rows[j][i].ToString(); 
 
                    tc.ItemTemplate = new DataGridTemplate(ListItemType.EditItem, RowCallName); 
 
 
                } 
                dg.Columns.Add(tc); 
 
            } 
 
            dg.DataBind(); 
          form1.Controls.Add(dg); 
        } 
} 
 
 public class DataGridTemplate : ITemplate 
{ 
        ListItemType templateType; 
        string columnName; 
 
 
        public DataGridTemplate(ListItemType type, string colname) 
        { 
            templateType = type; 
 
            columnName = colname; 
 
        } 
 
        public void InstantiateIn(System.Web.UI.Control container) 
        { 
            Literal lc = new Literal(); 
            switch (templateType) 
            { 
                case ListItemType.Header: 
                    lc.Text = "<B>" + columnName + "</B>"; 
                    container.Controls.Add(lc); 
                    break; 
                case ListItemType.Item: 
                    lc.Text = "Item " + columnName; 
                    container.Controls.Add(lc); 
                    break; 
                case ListItemType.EditItem: 
                    TextBox tb = new TextBox(); 
                    tb.Text = columnName; 
                    container.Controls.Add(tb); 
                    break; 
                case ListItemType.Footer: 
                    lc.Text = "<I>" + columnName + "</I>"; 
                    container.Controls.Add(lc); 
                    break; 
 
            } 
 
        } 
 
 
 
}

<%----------------The ASP.NET File-------------------------%> 
 
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="_Default" %> 
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
 
<html xmlns="http://www.w3.org/1999/xhtml"> 
<head runat="server"> 
    <title></title> 
</head> 
<body> 
    <form id="form1" runat="server"> 
    <div> 
    
    </div> 
    </form> 
</body> 
</html>

[ddanbe]

You never seem to be doing a new on DataTable dt.

[JulesBonnot]

You never seem to be doing a new on DataTable dt.

Thanks
But thats not the problem and the example seemed to work anyway?

either way imagine the new is there.

How to i get the datatable values into the text boxes of the grid

Thanks again,

Jules