C#_datatable Export EXECL to custom caption

         Public BOOLExportexcel (DataTable TB,stringPathstringtbname) {            //Excel 2003 Format            stringConnString ="Provider=Microsoft.Jet.OLEDB.4.0;Data source="+ Path +"; Extended Properties=excel 8.0;"; //Excel 2007 Format//string connstring = "Provider=microsoft.ace.oledb.12.0;data source=" + filepath + "; Extended Properties=excel 12.0 Xml; ";            Try            {                using(OleDbConnection con =NewOleDbConnection (connstring)) {con.                    Open (); StringBuilder strSQL=NewStringBuilder (); Strsql.append ("CREATE TABLE"). Append ("["+ Tbname +"]"); Strsql.append ("(");  for(inti =0; I < TB. Columns.count; i++)                    {                        Switch(TB. Columns[i]. ColumnName) { Case "ID": TB. Columns[i]. ColumnName="numbering";  Break;  Case "name": TB. Columns[i]. ColumnName="name";  Break;  Case "Phone": TB. Columns[i]. ColumnName="Telephone";  Break;  Case "Address": TB. Columns[i]. ColumnName="Address";  Break;  Case "Schedulelength": TB. Columns[i]. ColumnName="book The Order length";  Break;  Case "Welfare": TB. Columns[i]. ColumnName="Types of Benefits";  Break;  Case "Commoditytype": TB. Columns[i]. ColumnName="type of merchandise snapped up";  Break;  Case "Discount": TB. Columns[i]. ColumnName="Discount";  Break;  Case " Time": TB. Columns[i]. ColumnName="Date";  Break;  Case "remarks": TB. Columns[i]. ColumnName="Notes";  Break; } strsql.append ("["+ TB. Columns[i]. ColumnName +"] text,"); } strSQL= Strsql.remove (Strsql.length-1,1); Strsql.append (")"); OleDbCommand cmd=NewOleDbCommand (strsql.tostring (), con); Cmd.                    ExecuteNonQuery (); stringColumn =string.                    Empty;  for(inti =0; I < TB. Rows.Count; i++) {strsql.clear (); StringBuilder Strfield=NewStringBuilder (); StringBuilder strvalue=NewStringBuilder ();  for(intj =0; J < TB. Columns.count; J + +)                        {                            Switch(TB. COLUMNS[J]. ColumnName) { Case "ID": TB. COLUMNS[J]. ColumnName="numbering";  Break;  Case "name": TB. COLUMNS[J]. ColumnName="name";  Break;  Case "Phone": TB. COLUMNS[J]. ColumnName="Telephone";  Break;  Case "Address": TB. COLUMNS[J]. ColumnName="Address";  Break;  Case "Schedulelength": TB. COLUMNS[J]. ColumnName="book The Order length";  Break;  Case "Welfare": TB. COLUMNS[J]. ColumnName="Types of Benefits";  Break;  Case "Commoditytype": TB. COLUMNS[J]. ColumnName="type of merchandise snapped up";  Break;  Case "Discount": TB. COLUMNS[J]. ColumnName="Discount";  Break;  Case " Time": TB. COLUMNS[J]. ColumnName="Date";  Break;  Case "remarks": TB. COLUMNS[J]. ColumnName="Notes";  Break; } Strfield. Append ("["+ TB. COLUMNS[J]. ColumnName +"]"); strvalue. Append ("'"+ TB. ROWS[I][J]. ToString () +"'"); if(J! = TB. Columns.count-1) {Strfield. Append (","); strvalue. Append (","); }                            Else{}} cmd. CommandText= Strsql.append ("INSERT INTO ["+ Tbname +"]( ")                            . Append (Strfield. ToString ()). Append (") VALUES ("). Append (strvalue). Append (")").                        ToString (); Cmd.                    ExecuteNonQuery (); } con.                Close (); }                return true; }            Catch(Exception ex) {return false; }        }

C#_datatable Export EXECL to custom caption