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(22) 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 onlyi 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_ida.Project_ida.Module_Namea.Work_Descc.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_ida.Project_ida.Module_Namea.Work_Descc.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