C中数据导出到Excel表格(19)

DataGridView 数据导出到Excel

74. }

75. else

76. {

77. if(inode.Attributes["type"].Value.ToLower() ==

"int"||inode.Attributes["type"].Value.ToLower() == "decimal")

78. {

79. sqlstr = sqlstr + isnull(ds.Tables[0].Rows[i].ItemArray[jj].ToString()) + "," ;

80. }

81. else

82. {

83. sqlstr = sqlstr + "'" +

isnull(ds.Tables[0].Rows[i].ItemArray[jj].ToString().Replace("'","''")) + "'," ;

84. }

85. }

86. jj++;

87. }

88. mandText = sqlstr;

89. olecmd.ExecuteNonQuery();

90. }

91. MessageBox.Show(@"Excel文件：" + filePath + " 导出成功！");

92. }

93. catch(Exception ex)

94. {

95. MessageBox.Show(ex.Message);

96. }

97. finally

98. {

99. olecmd.Dispose();

100. olecon.Close();

101. olecon.Dispose();

102. }

103. }

104.

105. // 判断对象为空