DataGridView 数据导出到Excel

42. else

43. {

44. if(xnode.Attributes["type"].Value.ToLower() ==

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

45. {

46. sqlstr=sqlstr + xnode.Attributes["displayname"].Value + " number,";

47. }

48. else

49. {

50. sqlstr=sqlstr + xnode.Attributes["displayname"].Value + " text,";

51. }

52. }

53. // sqlstr =sqlstr + xnode.Attributes["displayname"].Value + " text";

54. ii++;

55. }

56. mandText = sqlstr;

57. olecmd.ExecuteNonQuery();

58. for(int i=0;i<ds.Tables[0].Rows.Count;i++)

59. {

60. sqlstr = "INSERT INTO sheet1 VALUES(";

61. int jj=0;

62. foreach(XmlNode inode in nodec.ChildNodes )

63. {

64. if(jj == nodec.ChildNodes.Count-1)

65. {

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

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

67. {

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

69. }

70. else

71. {

72. sqlstr = sqlstr + "'" +

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