dynamically table create

Question

Hiiiiiiii, How to dynamically create table in c# language with windows application form based on datatable value? plz give me example with code.

Sanjeeb Lenka · Answer

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

Jeetendra Gund · Answer

Hii... try this code, SqlConnection conn = new SqlConnection(); conn.ConnectionString = "Data Source=jeetendra;" + "Initial Catalog=Employee;" + "User id=sa;" + "Password=server@2010;"; conn.Open(); var query = "CREATE TABLE Order1 " + "(OrderID int NOT NULL, " + "ProductID int NOT NULL," + "UnitPrice money NOT NULL," + "Quantity int NOT NULL," + "Discount decimal(2,2) NOT NULL)"; SqlCommand cmd = new SqlCommand("",conn); //var data = new SqlData(ConnectionString); cmd.CommandType = CommandType.Text; cmd.CommandText = query; var nCount = cmd.ExecuteNonQuery(); conn.Close(); Regards, Jeetendra

Suthish Nair · Answer

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

selva kumar · Answer

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 { TableRow row = new TableRow(); for (int j = 0; 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 { for (int j = 0; j { //Print the values entered if (Request.Form["TextBoxRow_" + i + "Col_" + j] != string.Empty) { Response.Write(Request.Form["TextBoxRow_" +i+ "Col_" + j] +" "); } } } } } } }

Iftikar Hussain · Answer

there is no attachment

ranjan sahoo · Answer

i am attaching that is my code . you plz give me the complete designe of this code

Iftikar Hussain · Answer

I am asking you to attach the code.

ranjan sahoo · Answer

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(" {0} ", 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(" {0} ", dr[dc.ColumnName])); } sb.Append(" "); } } sb.Append(" "); }

Iftikar Hussain · Answer

please share your code as a attachment

ranjan sahoo · Answer

it will show dynamically ,

Iftikar Hussain · Answer

can you attach it as some td tag getting rendered here

ranjan sahoo · Answer

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(" {0} ", 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(" {0} ", dr[dc.ColumnName])); } sb.Append(" "); } } sb.Append(" "); }

Iftikar Hussain · Answer

it will not show data to your windows form. Can you share your code?

ranjan sahoo · Answer

not showing data .

Iftikar Hussain · Answer

try like this StringBuilder sb=new StringBuilder(); sb.Append(" "); foreach (DataColumn dc in dataTable.Columns) { sb.Append(String.Format(" {0} ", dc.ColumnName)); } sb.Append(" "); if (dataTable.Rows.Count > 0) { foreach (DataRow dr in dataTable.Rows) { sb.Append(" "); foreach (DataColumn dc in dataTable.Columns) { sb.Append(String.Format(" {0} ", dr[dc.ColumnName])); } sb.Append(" "); } } sb.Append(" ");

ranjan sahoo · Answer

how to use datatable data to stringbuilder and creating a table

Iftikar Hussain · Answer

no, if you want to send the data as format then use the string builder for creating table string and send as mail

ranjan sahoo · Answer

is it possible to send gridview page to another mail address

Iftikar Hussain · Answer

if you want to display those record to the user in your windows application then you need to use datagridview only.

ranjan sahoo · Answer

i am using window application. actually i am retriving data from database to datatable.i want to show this record which are present in datatable that record will show in a table format using row and column.

Iftikar Hussain · Answer

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. StringBuilder sb=new StringBuilder(); sb.Append(" "); sb.Append(" "); sb.Append(" Sl No "); sb.Append(" Name "); sb.Append(" Address "); sb.Append(" "); sb.Append(" "); sb.Append(" 1 "); sb.Append(" Test "); sb.Append(" Delhi "); sb.Append(" "); sb.Append(" "); Regards, Iftikar

ranjan sahoo · Answer

this table will send to one mail so that i am not use any grid controll. is it possible to use TableLayoutPanle control ?

Iftikar Hussain · Answer

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

ranjan sahoo · Answer

dynamically is it possbilbe to create row, column or not?

Iftikar Hussain · Answer

sorry, it will be not possible in windows application. I like to know why you are not able to use datagridview?

ranjan sahoo · Answer

without gridview how it is possible? simply datatable bind to table only

Iftikar Hussain · Answer

there is no table control in windows application.

ranjan sahoo · Answer

No i am asking just like as html table

Jaganathan Bantheswaran · Answer

http://myadventuresincoding.wordpress.com/2012/05/27/c-bulk-copying-data-into-ms-sql-server-with-datatables/ T he above link explains the bulk copy to SQL.

Iftikar Hussain · Answer

Hi, Are asking for creating DataTable? Regards, Iftikar

dynamically table create

Answers (30)