public string DataTableToExcel {if {return "DataTable can not be empty";} int rows = dt.Rows.Count; int cols = dt.Columns.Count; StringBuilder sb; string connString; if {return "no data";} sb = new StringBuilder; connString = string.Format; / / generate create table script sb.Append; sb.Append; for {ifsb.Append); elsesb.Append ", dt.Columns [i]. ColumnName));} using) {OleDbCommand objCmd = new OleDbCommand; objCmd.Connection = objConn; objCmd.CommandText = sb.ToString; trycatch {return "create table in Excel failed with error message:" + e.Message;} # region Generate script generates insert data into the data script sb.Remove; sb.Append; sb.Append; for {ifsb.Append; elsesb.Append values;} for {ifsb.Append; elsesb.Append ");}# endregion / / create insert action CommandobjCmd.CommandText = sb.ToString; OleDbParameterCollection param = objCmd.Parameters; for {param.Add );}// traverse data into the new DataTable to Excel file foreach {for {param [i]. Value = row [i];} objCmd . ExecuteNonQuery;} return "data has been successfully imported Excel ";}// end using} Examples of methods for data members of the anonymous usage of our example, let us in the Program class, define a new instance of the method, and use the example of an instance of class data members. The following code shows a modified example: public class Program {public delegate void MyDelegate; public static void Main {/ / instance data members of the Test Program p = new Program; forp.TestInstanceDataMembers;} public void TestInstanceDataMembers {MyDelegate d = delegate { Console.WriteLine;}; d;} public int m_iCount = 0;}
In this program, Dell introduced a technology designed specifically for virtual server - PE R805 and PE R905. Both machines are quad-core AMD Opteron processors, this new processors Direct Connect Architecture can break through bottlenecks in virtualized applications, which can effectively reduce the response delay to help users achieve the maximum benefits of virtualization. More to the point, these two products are designed entirely from the perspective of virtualization, with the same level server market, many new features not available. To PE R805, for example, this product has a memory and I / O capacity is twice the typical two-way servers, and embedded directly in the hardware VMware ESXi 3.5 virtual system, press the power this server, the user just a few minutes you can go directly to the virtual system, the virtual machine to easily complete the deployment and maintenance: The PE R905, before the launch of this product and Dells PE R900 is equipped with Intel processors as the virtual technologies are made a fully optimized, can easily support 60 virtual machines, the authority of the Vmark testing has shown that these two four-socket server is running a large-scale virtual system performance is outstanding, enabling enterprise IT be greatly simplified.