dynamically table create

Hii...
try this code,

 DataGridView - Insert, Update, Delete and Retrieve records using stored procedure

 http://www.codeproject.com/Articles/23640/How-to-send-DataGridView-contents-by-email

 http://stackoverflow.com/questions/16547588/sending-datagridview-to-email

 

have a look at this code.i m using on asp.net...this is reference only,,i think it may helpful to you.mark as answered if it is heplful...

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class Default4 : System.Web.UI.Page
{
    private int numOfRows = 0;
    private int numOfColumns = 0;

    protected void Page_Load(object sender, EventArgs e)
    {
        // the two paramters are declared globally
        GenerateTable(numOfColumns, numOfRows);
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        //Check if the inputs are numbers
        if (int.TryParse(TextBox1.Text.Trim(), out numOfColumns) && int.TryParse(TextBox2.Text.Trim(), out numOfRows))
        {
            //Generate the Table based from the inputs
            GenerateTable(numOfColumns, numOfRows);

            //Store the current Rows and Columns In ViewState as a reference value when it post backs
            ViewState["cols"] = numOfColumns;
            ViewState["rows"] = numOfRows;
        }
        else
        {
            Response.Write("Values are not numeric!");
        }
    }
    private void GenerateTable(int colsCount, int rowsCount)
    {

        //Creat the Table and Add it to the Page
        Table table = new Table();
        table.ID = "Table1";
        Page.Form.Controls.Add(table);

        // Now iterate through the table and add your controls
        for (int i = 0; i < rowsCount; i++)
        {
            TableRow row = new TableRow();
            for (int j = 0; j < colsCount; j++)
            {
                TableCell cell = new TableCell();
                TextBox tb = new TextBox();

                // Set a unique ID for each TextBox added
                tb.ID = "TextBoxRow_" + i + "Col_" + j;
                // Add the control to the TableCell
                cell.Controls.Add(tb);
                // Add the TableCell to the TableRow
                row.Cells.Add(cell);
            }

            // Add the TableRow to the Table
            table.Rows.Add(row);
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        //Check if ViewState values are null
        if (ViewState["cols"] != null && ViewState["rows"] != null)
        {
            //Find the Table in the page
            Table table = (Table)Page.FindControl("Table1");
            if (table != null)
            {
                //Re create the Table with the current rows and columns
                GenerateTable(int.Parse(ViewState["cols"].ToString()), int.Parse(ViewState["rows"].ToString()));

                // Now we can loop through the rows and columns of the Table and get the values from the TextBoxes
                for (int i = 0; i < int.Parse(ViewState["rows"].ToString()); i++)
                {
                    for (int j = 0; j < int.Parse(ViewState["cols"].ToString()); j++)
                    {
                        //Print the values entered
                        if (Request.Form["TextBoxRow_" + i + "Col_" + j] != string.Empty)
                        {
                            Response.Write(Request.Form["TextBoxRow_" +i+ "Col_" + j]  +"
");
                        }
                    }
                }
            }
        }
    }
}

public void databind() { DateTime today = DateTime.Today; string str = "SELECT a.Emp_id,a.Project_id,a.Module_Name,a.Work_Desc,c.Emp_Name FROM DPPR a inner join Emp_Master c on a.Emp_id = c.Emp_id where a.Del_Flag=0 and Rpt_Dt='" + today + "'"; SqlDataAdapter da = new SqlDataAdapter(str, con); DataTable dt = new DataTable(); da.Fill(dt); StringBuilder sb = new StringBuilder(); sb.Append(""); foreach (DataColumn dc in dt.Columns) { sb.Append(String.Format("", dc.ColumnName)); } sb.Append(""); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { sb.Append(""); foreach (DataColumn dc in dt.Columns) { sb.Append(String.Format("", dr[dc.ColumnName])); } sb.Append(""); } } sb.Append("

{0}

{0}

"); }

it will show dynamically ,

public void databind() { DateTime today = DateTime.Today; string str = "SELECT a.Emp_id,a.Project_id,a.Module_Name,a.Work_Desc,c.Emp_Name FROM DPPR a inner join Emp_Master c on a.Emp_id = c.Emp_id where a.Del_Flag=0 and Rpt_Dt='" + today + "'"; SqlDataAdapter da = new SqlDataAdapter(str, con); DataTable dt = new DataTable(); da.Fill(dt); StringBuilder sb = new StringBuilder(); sb.Append(""); foreach (DataColumn dc in dt.Columns) { sb.Append(String.Format("", dc.ColumnName)); } sb.Append(""); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { sb.Append(""); foreach (DataColumn dc in dt.Columns) { sb.Append(String.Format("", dr[dc.ColumnName])); } sb.Append(""); } } sb.Append("

{0}

{0}

"); }

try like this

ok, so you are not displaying in your windows application. In that case you can create one string builder with table format and send it thru mail.


Regards,
Iftikar

you can create dynamically only for DataTable. If you want same like as ASP.NET in windows form for HTML table then answer is not possible. 

Regards,
Iftikar

hi,

you can use datagridview control of windows form to show your data in tabular format.

http://myadventuresincoding.wordpress.com/2012/05/27/c-bulk-copying-data-into-ms-sql-server-with-datatables/

The above link explains the bulk copy to SQL. 

Hi,
        Are asking for creating DataTable?

Regards,
Iftikar