C# .NET - how to create a dynamic table

Asked By srinivasarao
01-Feb-11 01:24 AM
hai to all...

       Can any one tell me how to create a dynamic table in my windows application and how to add the dynamic controls to the dynamic table........


Thanks in advance
srinu
  Mihir Soni replied to srinivasarao
01-Feb-11 01:32 AM
Hello,

You can create dynamic table as follow

//Create a object of Datatable
    DataTable dynamicTable = new DataTable();
 
    //DataRow
    DataRow dynamicRow;
    //DataColumn for Name and Time
    DataColumn NameColumn = new DataColumn("Name", typeof(string));
    DataColumn TimeColumn = new DataColumn("Time", typeof(string));
 
    //add Column to Datatable
    dynamicTable.Columns.Add(NameColumn);
    dynamicTable.Columns.Add(TimeColumn);
    //loop for 10 item in DataTable
    for (int i = 0; i < 10; i++)
    {
      dynamicRow = dynamicTable.NewRow();
      //Add Rows to dymanicTable
      dynamicTable.Rows.Add(dynamicRow);
      //Assign Column value
      dynamicTable.Rows[i][NameColumn] = Guid.NewGuid().ToString();
      dynamicTable.Rows[i][TimeColumn] = DateTime.Now.ToString();
    }

Above is simple datatable with two column and 10 rows.

What do you mean by dynamic controls to dynamic table??
  Mihir Soni replied to srinivasarao
01-Feb-11 01:33 AM
Hello,

You can create dynamic table as follow

//Create a object of Datatable
    DataTable dynamicTable = new DataTable();
 
    //DataRow
    DataRow dynamicRow;
    //DataColumn for Name and Time
    DataColumn NameColumn = new DataColumn("Name", typeof(string));
    DataColumn TimeColumn = new DataColumn("Time", typeof(string));
 
    //add Column to Datatable
    dynamicTable.Columns.Add(NameColumn);
    dynamicTable.Columns.Add(TimeColumn);
    //loop for 10 item in DataTable
    for (int i = 0; i < 10; i++)
    {
      dynamicRow = dynamicTable.NewRow();
      //Add Rows to dymanicTable
      dynamicTable.Rows.Add(dynamicRow);
      //Assign Column value
      dynamicTable.Rows[i][NameColumn] = Guid.NewGuid().ToString();
      dynamicTable.Rows[i][TimeColumn] = DateTime.Now.ToString();
    }

Above is simple datatable with two column and 10 rows.

What do you mean by dynamic controls to dynamic table??
  srinivasarao replied to Mihir Soni
01-Feb-11 01:46 AM
how to add this dynamic table to form...................

my code is this.controls.Add(dynamictable);

but it is showing error
  Mihir Soni replied to srinivasarao
01-Feb-11 01:48 AM
But it should be in gridview or some other controls

you can do this like drag and drop Gridview on form and write following code after creating datatable

Gridview1.Datasource=dt;
Gridview1.DataBind();
  srinivasarao replied to Mihir Soni
01-Feb-11 02:11 AM
i am doing windows application..... in this we don't have gridview..............
  srinivasarao replied to Mihir Soni
01-Feb-11 02:16 AM
can we display it as a table in windows just like as a table in web applicaiton ?
  Mihir Soni replied to srinivasarao
01-Feb-11 02:16 AM
Use DATAGRIDVIEW from DATA section of toolkit
  Mihir Soni replied to srinivasarao
01-Feb-11 02:16 AM
Use DATAGRIDVIEW from DATA section of toolkit
Create New Account
help
Datagridview to Datatable How can i get datagridview particular cell values to datatable in vb.net? DataTable dynamicTable = new DataTable(); DataRow dynamicRow; DataColumn dcMacAddress = new DataColumn("MacAddress", typeof(string)); DataColumn Serial = new DataColumn("Serial Number", typeof(string)); dynamicTable.Columns.Add(dcMacAddress
DataGridView - Overview - Dataset .NET Framework Hello, I'm searching a good overview for that. DataGridView dataGridView1 = new DataGridView(); DataTable dt = new DataTable ("Daten"); dt.Columns.Add(new DataColumn("Name")); dt.Columns.Add(new DataColumn("Reich", typeof(bool))); dt.Columns.Add(new DataColumn("Neffen", typeof(int))); dt.Columns.Add(new DataColumn("Geburtsdatum", typeof(DateTime))); dataGridView1.DataSource = dt; DataRow
Datarow How to create datatable and add textbox values as a row and want to show in Datagridview using vb.net? To add the textbox control value to a dataTable you can try like this. / / Your DataTable DataTable myDataTable = new DataTable(); DataColumn myDataColumn; myDataColumn = new DataColumn(); myDataColumn.DataType = Type.GetType("System.String"); myDataColumn.ColumnName = "id"; myDataTable.Columns.Add(myDataColumn); myDataColumn = new
serial number column in my table(mysql table). but i need to display srno in DatagridView(windows applications) how can i generate serial number in query please help me. Function to generate serial number private DataTable AutoNumberedTable( DataTable SourceTable) { DataTable ResultTable = new DataTable (); DataColumn AutoNumberColumn = new DataColumn (); AutoNumberColumn.ColumnName = "S.No." ; AutoNumberColumn.DataType = typeof ( int ); AutoNumberColumn.AutoIncrement = true ; AutoNumberColumn.AutoIncrementSeed = 1; AutoNumberColumn using ( SqlCommand Command = Connection.CreateCommand()) { Command.CommandText = "SELECT * FROM [myTable]" ; SqlDataAdapter dataAdapter = new SqlDataAdapter (Command); DataTable dataTable = new DataTable (); dataAdapter.Fill(dataTable); this .dataGridView1.DataSource = AutoNumberedTable(dataTable); } } } Build Connection string private
OutOfMemoryException when using a datagridview in a panel .NET Framework Hi, I am using .NET 2.0 and a datagridview in panel. The datagridview is bound to a datatable which is populated through a database. The first column should be a combobox column. The combobox column has a datasource which is another datatable so an integer is mapped to a string (easier for the user to understand). This fine in a standalone project. Code follows here: private void Form1_Load(object sender, EventArgs e) { DataTable table = new DataTable("test"); AddColumns(table); DataSet set = new DataSet(); set.Tables.Add(table); SetupDataGridView(dataGridView1); AddData(set Key"] = "test"; row["Value"] = "val"; set.Tables[0].Rows.Add(row); } public static void SetupDataGridView(DataGridView datagridview) { if(null = = datagridview) return; datagridview.AutoGenerateColumns = false; datagridview.Columns.Clear(); AddComboColumn(datagridview); DataGridViewColumn keycolumn