dynamically table create

Sign in to answer this question.

• 

  Jeetendra Gund13y agoPosted Sep 16, 2013, 7:44 AM

  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 Nair13y agoPosted Sep 11, 2013, 9:28 AM

  
   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 kumar13y agoPosted Sep 11, 2013, 6:54 AM

  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]  +"
  ");
                          }
                      }
                  }
              }
          }
      }
  }
  
  
• IH

  Iftikar Hussain13y agoPosted Aug 27, 2013, 4:11 AM

  there is no attachment
• RS

  ranjan sahoo13y agoPosted Aug 27, 2013, 4:05 AM

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

  Iftikar Hussain13y agoPosted Aug 27, 2013, 3:43 AM

  I am asking you to attach the code.
• RS

  ranjan sahoo13y agoPosted Aug 27, 2013, 3:40 AM

  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}

  "); }
• IH

  Iftikar Hussain13y agoPosted Aug 27, 2013, 3:37 AM

  please share your code as a attachment
• RS

  ranjan sahoo13y agoPosted Aug 27, 2013, 3:35 AM

  it will show dynamically ,
• IH

  Iftikar Hussain13y agoPosted Aug 27, 2013, 3:33 AM

  can you attach it as some td tag getting rendered here
• RS

  ranjan sahoo13y agoPosted Aug 27, 2013, 3:29 AM

  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}

  "); }
• IH

  Iftikar Hussain13y agoPosted Aug 27, 2013, 3:23 AM

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

  ranjan sahoo13y agoPosted Aug 27, 2013, 3:22 AM

  not showing data .
• IH

  Iftikar Hussain13y agoPosted Aug 27, 2013, 3:16 AM

  try like this
  
  

  StringBuilder sb=new StringBuilder();

  sb.Append("");

  foreach (DataColumn dc in dataTable.Columns)

  {

    sb.Append(String.Format("

  ", 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("

  ", dr[dc.ColumnName]));

                          }

                          sb.Append("

  ");

                      } 

  }

  sb.Append("

  {0}

  {0}

  ");
• RS

  ranjan sahoo13y agoPosted Aug 27, 2013, 3:07 AM

  how to use datatable data to stringbuilder and creating a table
• IH

  Iftikar Hussain13y agoPosted Aug 27, 2013, 3:02 AM

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

  ranjan sahoo13y agoPosted Aug 27, 2013, 3:00 AM

  is it possible to send gridview page to another mail address
• IH

  Iftikar Hussain13y agoPosted Aug 27, 2013, 2:58 AM

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

  ranjan sahoo13y agoPosted Aug 27, 2013, 2:56 AM

  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.
• IH

  Iftikar Hussain13y agoPosted Aug 27, 2013, 2:51 AM

  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("

  ");

              sb.Append("

  ");

              sb.Append("

  ");

              sb.Append("

  ");

              sb.Append("

  ");

              sb.Append("

  ");

              sb.Append("

  ");

              sb.Append("

  ");

              sb.Append("

  ");

              sb.Append("

  Sl No	Name	Address
  1	Test	Delhi

  ");

  
  Regards,
  Iftikar
• RS

  ranjan sahoo13y agoPosted Aug 27, 2013, 2:46 AM

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

  Iftikar Hussain13y agoPosted Aug 27, 2013, 2:38 AM

  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
• RS

  ranjan sahoo13y agoPosted Aug 27, 2013, 2:37 AM

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

  Iftikar Hussain13y agoPosted Aug 27, 2013, 2:36 AM

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

  ranjan sahoo13y agoPosted Aug 27, 2013, 2:34 AM

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

  Iftikar Hussain13y agoPosted Aug 27, 2013, 2:32 AM

  there is no table control in windows application.
• 

  Sanjeeb Lenka13y agoPosted Aug 27, 2013, 2:31 AM

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

  ranjan sahoo13y agoPosted Aug 27, 2013, 2:30 AM

  No i am asking just like as html table
• 

  Jaganathan Bantheswaran13y agoPosted Aug 27, 2013, 2:25 AM

  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. 
• IH

  Iftikar Hussain13y agoPosted Aug 27, 2013, 2:10 AM

  Hi,
          Are asking for creating DataTable?
  
  Regards,
  Iftikar