回复主题| C＃开发人员社区

信息

<blockquote data-quote ="ahmedsalah" data-source="post: 9494" data-attributes="member: 11365">[FONT=&amp;quot]Problem[/FONT][h = 1]我在循环内写了些什么，以便在datagridview上显示类似的项目代码，并在数据库sql服务器上插入不同的项目代码[/ h][FONT=&amp;quot]SQL Server数据库（2014）项表[/FONT][FONT=&amp;quot]ItemCode(pk)&nbsp; &nbsp; ItemName&nbsp; [/FONT][FONT=&amp;quot]001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; mouse[/FONT][FONT=&amp;quot]002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; keyboard[/FONT][FONT=&amp;quot]003&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Headphone[/FONT][FONT=&amp;quot]在Excel 2010表格上&nbsp; &nbsp;&nbsp; [/FONT][FONT=&amp;quot]ItemCode&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ItemName&nbsp; [/FONT][FONT=&amp;quot]001&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; mouse[/FONT][FONT=&amp;quot]002&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; keyboard[/FONT][FONT=&amp;quot]004&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; screen[/FONT][FONT=&amp;quot]005&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Ram[/FONT][FONT=&amp;quot]其实我需要在导入Excel文件时插入不存在的不同项目代码[/FONT][FONT=&amp;quot]在sql server数据库上和在Excel上找到的“数据库中的现有项目”不会插入，而是在datagridview上显示。[/FONT][FONT=&amp;quot]根据我的情况，在表格Items上插入商品代码004,005。[/FONT][FONT=&amp;quot]并在网格视图中显示001,002作为存在项目。[/FONT][FONT=&amp;quot]我的功能如下[/FONT][FONT=&amp;quot]我的代码（内部循环）[/FONT][CODE] [COLOR =＃000088] public [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃000088]静态[/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃000088 ] void [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃660066] ImportFromExcelToDataBase [/ COLOR] [COLOR =＃666600]（）[/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; [/ COLOR] [COLOR =＃666600] {[/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp;&nbsp; [/ COLOR] [COLOR =＃660066] Datatable [/ COLOR] [COLOR =＃000000] dt [/ COLOR] [COLOR =＃666600] = [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR = ＃660066] ShowExcelData [/ COLOR] [COLOR =＃666600]（）; [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp;&nbsp; [/ COLOR] [COLOR =＃660066] DataTable [/ COLOR] [COLOR =＃000000] dtItems [/ COLOR] [COLOR =＃666600] = [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR = ＃660066] GetSqlItems [/ COLOR] [COLOR =＃666600]（）; [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [/ COLOR] [COLOR =＃000088]表示[/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃666600]（[/ COLOR] [COLOR =＃000088] int [/ COLOR] [COLOR = ＃000000] i [/ COLOR] [COLOR =＃666600] = [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃006666] 0 [/ COLOR] [COLOR =＃666600]; [/ COLOR ] [COLOR =＃000000]我[/ COLOR] [COLOR =＃666600] &lt; [/ COLOR] [COLOR =＃000000] dt [/ COLOR] [COLOR =＃666600]。[/ COLOR] [COLOR =＃660066]行[/COLOR][COLOR=#666600]。[/COLOR] [COLOR =＃660066]计数[/ COLOR] [COLOR =＃666600]; [/ COLOR] [COLOR =＃000000] i [/ COLOR] [COLOR =＃666600] ++）[/ COLOR] [COLOR =＃ 000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [/ COLOR] [COLOR =＃666600] {[/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [/ COLOR] [COLOR =＃880000] //我在这里写什么[/ COLOR][COLOR=#880000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //如果Excel上存在itemcode，则SQL服务器数据库上存在[/ COLOR][COLOR=#880000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;然后在数据库上显示相似的项目，并且在datagridview [/ COLOR]上显示为001,002[COLOR=#880000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // else [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; [/ COLOR] [COLOR =＃880000] //插入数据[/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [/ COLOR] [COLOR =＃000088]字符串[/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃660066]插入[/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃ 666600] = [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃008800]&quot;插入值（&quot; [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃666600] + [/ COLOR] [COLOR =＃000000]数据[/ COLOR] [COLOR =＃666600] + [/ COLOR] [ COLOR =＃000000] [/ COLOR] [COLOR =＃008800]&quot;)&quot; [/ COLOR] [COLOR =＃666600]; [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [/COLOR][COLOR=#660066]DataAccess[/COLOR][COLOR=#666600].[/COLOR][COLOR=#660066]ExecuteNonQuery[/COLOR][COLOR=#666600]([/COLOR][COLOR =＃660066]插入[/ COLOR] [COLOR =＃666600]）; [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [/ COLOR] [COLOR =＃666600]} [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; [/ COLOR] [COLOR =＃666600]} [/ COLOR] [COLOR =＃000000][/ COLOR] [COLOR =＃000088] public [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃660066] DataTable [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃ 660066] ShowExcelData [/ COLOR] [COLOR =＃666600]（）[/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; [/ COLOR] [COLOR =＃666600] {[/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [/ COLOR] [COLOR =＃000088]字符串[/ COLOR] [COLOR =＃000000] connectionString [/ COLOR] [COLOR =＃666600] = [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR = ＃000088]字符串[/COLOR][COLOR=#666600]。[/COLOR][COLOR=#660066]格式[/ COLOR] [COLOR =＃666600]（[/ COLOR] [COLOR =＃008800]&quot; Provider = Microsoft.ACE.OLEDB.12.0; Data Source = {0}; Extended Properties = \&quot; Excel 12.0 Xml; HDR = YES; IMEX = 1 \&quot;;&quot; [/ COLOR] [COLOR =＃666600]，[/ COLOR] [COLOR =＃000000] txtpath [/ COLOR] [COLOR =＃666600]。[/ COLOR] [COLOR =＃660066]文本[/ COLOR] [COLOR =＃666600]）; [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [/ COLOR] [COLOR =＃660066] OleDbConnection [/ COLOR] [COLOR =＃000000] con [/ COLOR] [COLOR =＃666600] = [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR = ＃000088] new [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃660066] OleDbConnection [/ COLOR] [COLOR =＃666600]（[/ COLOR] [COLOR =＃000000] connectionString [/ COLOR ] [COLOR =＃666600]）; [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; con [/ COLOR] [COLOR =＃666600]。[/ COLOR] [COLOR =＃660066]打开[/ COLOR] [COLOR =＃666600]（）; [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [/ COLOR] [COLOR =＃660066] DataTable [/ COLOR] [COLOR =＃000000] dt [/ COLOR] [COLOR =＃666600] = [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR = ＃000088] new [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃660066] DataTable [/ COLOR] [COLOR =＃666600]（）; [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dt [/ COLOR] [COLOR =＃666600] = [/ COLOR] [COLOR =＃000000] con [/ COLOR] [COLOR =＃666600]。[/ COLOR] [COLOR =＃660066] GetOleDbSchemaTable [/ COLOR] [ COLOR =＃666600]（[/ COLOR] [COLOR =＃660066] OleDbSchemaGuid [/ COLOR] [COLOR =＃666600]。[/ COLOR] [COLOR =＃660066]表[/ COLOR] [COLOR =＃666600]， [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃000088] null [/ COLOR] [COLOR =＃666600]）; [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [/ COLOR] [COLOR =＃000088]字符串[/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃660066] SheetName [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃ 666600] = [/ COLOR] [COLOR =＃000000] dt [/ COLOR] [COLOR =＃666600]。[/ COLOR] [COLOR =＃660066]行[/ COLOR] [COLOR =＃666600] [[/ COLOR ] [COLOR =＃006666] 0 [/ COLOR] [COLOR =＃666600]] [[/ COLOR] [COLOR =＃008800]&quot;TABLE_NAME&quot; [/ COLOR] [COLOR =＃666600]]。[/ COLOR] [COLOR =＃660066] ToString [/ COLOR] [COLOR =＃666600]（）; [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [/ COLOR] [COLOR =＃660066] OleDbCommand [/ COLOR] [COLOR =＃000000] com [/ COLOR] [COLOR =＃666600] = [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR = ＃000088] new [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃660066] OleDbCommand [/ COLOR] [COLOR =＃666600]（）; [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; com [/ COLOR] [COLOR =＃666600]。[/ COLOR] [COLOR =＃660066]连接[/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃666600] = [/ COLOR] [COLOR =＃000000] con [/ COLOR] [COLOR =＃666600]; [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; com [/ COLOR] [COLOR =＃666600]。[/ COLOR] [COLOR =＃660066] CommandText [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃666600] = [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃666600] @ [/ COLOR] [COLOR =＃008800]&quot;SELECT&nbsp; [ItemCode]，[ItemsName]，[ItemAddress]来自&nbsp; [&quot; [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃666600] + [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃660066] SheetName [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃666600] + [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃008800]&quot;] &quot; [/ COLOR] [COLOR =＃666600]; [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [/ COLOR] [COLOR =＃660066] OleDbDataAdapter [/ COLOR] [COLOR =＃000000] oledbda [/ COLOR] [COLOR =＃666600] = [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR = ＃000088] new [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃660066] OleDbDataAdapter [/ COLOR] [COLOR =＃666600]（）; [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; oledbda [/ COLOR] [COLOR =＃666600]。[/ COLOR] [COLOR =＃660066] SelectCommand [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃666600] = [/ COLOR] [COLOR =＃000000] com [/ COLOR] [COLOR =＃666600]; [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [/ COLOR] [COLOR =＃660066] DataSet [/ COLOR] [COLOR =＃000000] ds [/ COLOR] [COLOR =＃666600] = [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR = ＃000088] new [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃660066] DataSet [/ COLOR] [COLOR =＃666600]（）; [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; oledbda [/ COLOR] [COLOR =＃666600]。[/ COLOR] [COLOR =＃660066]填充[/ COLOR] [COLOR =＃666600]（[/ COLOR] [COLOR =＃000000] ds [/ COLOR] [ COLOR =＃666600]）; [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dt [/ COLOR] [COLOR =＃666600] = [/ COLOR] [COLOR =＃000000] ds [/ COLOR] [COLOR =＃666600]。[/ COLOR] [COLOR =＃660066]表[/ COLOR] [ COLOR =＃666600] [[/ COLOR] [COLOR =＃006666] 0 [/ COLOR] [COLOR =＃666600]]; [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; con [/ COLOR] [COLOR =＃666600]。[/ COLOR] [COLOR =＃660066]关闭[/ COLOR] [COLOR =＃666600]（）; [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [/ COLOR] [COLOR =＃000088]返回[/ COLOR] [COLOR =＃000000] dt [/ COLOR] [COLOR =＃666600]; [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; [/ COLOR] [COLOR =＃666600]} [/ COLOR] [COLOR =＃000000]dt [/ COLOR] [COLOR =＃666600] = [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃660066] ShowExcelData [/ COLOR] [COLOR =＃666600]（）; [/ COLOR] [COLOR =＃000000][/ COLOR] [COLOR =＃000088] public [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃660066] DataTable [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃ 660066] GetSqlItems [/ COLOR] [COLOR =＃666600]（）[/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; [/ COLOR] [COLOR =＃666600] {[/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [/ COLOR] [COLOR =＃000088]字符串[/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃660066] GetItems [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃ 666600] = [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃666600] @ [/ COLOR] [COLOR =＃008800]&quot;select 项目代码,ItemsName,ItemAddress from Items&quot; [/ COLOR] [COLOR =＃666600]; [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; [/ COLOR] [COLOR =＃660066] DataTable [/ COLOR] [COLOR =＃000000] tbGetItems [/ COLOR] [COLOR =＃666600] = [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR = ＃660066] DataAccess [/ COLOR] [COLOR =＃666600]。[/ COLOR] [COLOR =＃660066] ExecuteDataTable [/ COLOR] [COLOR =＃666600]（[/ COLOR] [COLOR =＃660066] GetItems [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃666600]）; [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [/ COLOR] [COLOR =＃000088]返回[/ COLOR] [COLOR =＃000000] tbGetItems [/ COLOR] [COLOR =＃666600]; [/ COLOR] [COLOR =＃000000]&nbsp; &nbsp; &nbsp; &nbsp; [/ COLOR] [COLOR =＃666600]} [/ COLOR] [COLOR =＃000000]dtItems [/ COLOR] [COLOR =＃666600] = [/ COLOR] [COLOR =＃000000] [/ COLOR] [COLOR =＃660066] GetSqlItems [/ COLOR] [COLOR =＃666600]（）; [/ COLOR][/CODE][h=1][/h]</blockquote>

验证