Search

03-21-2006, 1:46 AM puppyonline Joined on 03-16-2006 Posts 1 Export to excel please lead me export dataTable to Excel. and i don't know how insert data to dataTable.but data haven't in database.data is thing(exam:string ,int ,object...).    Report

03-21-2006, 6:24 AM Yasir Joined on 03-15-2006 Posts 44 Re: Export to excel Hi If you are creating a DataTable programmatically, you must first define its schema by adding DataColumn objects to the DataColumnCollection (accessed through the Columns property). use following example code to create a dataTable and columns. private void MakeTable(DataTable myTable){ // Create a DataTable. DataTable myTable = new DataTable("myTable"); // Create a DataColumn and set various properties. DataColumn myColumn = new DataColumn(); myColumn.DataType = System.Type.GetType("System.Decimal"); myColumn.AllowDBNull = false; myColumn.Caption = "Price"; myColumn.ColumnName = "Price"; myColumn.DefaultValue = 25; // Add the column to the table. myTable.Columns.Add(myColumn); // Add 10 rows and set values. DataRow myRow; for(int i = 0; i < 10; i++){ myRow = myTable.NewRow(); myRow["Price"] = i + 1; // Be sure to add the new row to the DataRowCollection. myTable.Rows.Add(myRow); } } in this way you can create the data table. Best Regards -Yasir    Report

Codersource.Net » Programming » C# Programming » Export to excel

(please select) Forums Home |- Search Forums |- Active Topics |- Unanswered Posts User Options |- Sign In |- Create a New Account |- Forgot Password Programming |- C# Programming |- Asp .Net Programming |- C++ Programming |- MFC Programming