关于查询的问题..在3个表之间选择和插入 [英] problem about query .. of select and insert between 3 tables

问题描述

 OleDbCommand cmd =  new  OleDbCommand（  INSERT INTO SlideShowTable1 ss（ss.ImageName，ss.Description，ss.CategoryName，ss.ADshop_name，ss.ADShop_Address，ss.ADshop_city，ss.ADShop_mob，ss.ADshop_Email，ss.U_id，ss.AreaName ，ss.startddate，ss.endddate，ss.ImagePath，ss.BImageName，ss.BImagePath，ss.Total_Days，ss.Days_remain）选择u.U_id，u.U_name，u.U_Email，s.ImageName，s.Description， s.CategoryName，s.ADshop_name，s.ADShop_Address，s.ADshop_city，s.ADshop_mob，s.ADshop_Email，s.AreaName，s.startddate，s.endddate，s.ImagePath，s.BImageName，s.BImagePath，S。 Total_Days，s.Days_remain来自LOGIN u，SlideShowTable s其中u.U_id = + userid，s.U_id =   + userid，ss.U_id = + userid，con）; 
 
  int  result = cmd.ExecuteNonQuery（）; 

它给出错误s在当前上下文中不存在

解决方案

你的问题就在你的最后OleDbCommand

 u。 U_id =+ userid，s.U_id =+ userid，ss.U_id =+ userid，con）; 

你需要一些额外的引号 - 我认为它应该是

 u.U_id =+ userid  +， s.U_id =+ userid  +， ss.U_id =+ userid，con）; 

我怀疑你最后可能会出现sql错误，但至少你的代码会编译

OleDbCommand cmd = new OleDbCommand("INSERT INTO SlideShowTable1 ss(ss.ImageName,ss.Description,ss.CategoryName,ss.ADshop_name,ss.ADShop_Address,ss.ADshop_city,ss.ADShop_mob,ss.ADshop_Email,ss.U_id,ss.AreaName,ss.startddate,ss.endddate,ss.ImagePath,ss.BImageName,ss.BImagePath,ss.Total_Days,ss.Days_remain)Select u.U_id ,u.U_name, u.U_Email,s.ImageName ,s.Description,s.CategoryName,s.ADshop_name,s.ADShop_Address,s.ADshop_city,s.ADshop_mob,s.ADshop_Email,s.AreaName,s.startddate,s.endddate,s.ImagePath,s.BImageName,s.BImagePath,s.Total_Days,s.Days_remain from LOGIN u ,SlideShowTable s where u.U_id= " + userid, s.U_id = " + userid,ss.U_id=" + userid, con);

        int result = cmd.ExecuteNonQuery();

it gives an error that s is not exist in current contex

解决方案

Your problem is at the end of you OleDbCommand

u.U_id= " + userid, s.U_id = " + userid,ss.U_id=" + userid, con);

You need some extra quotation marks in there - I think it should be

u.U_id= " + userid + ", s.U_id = " + userid + ",ss.U_id=" + userid, con);

I suspect you''ll then probably end up with a sql error but at least your code will compile

这篇关于关于查询的问题..在3个表之间选择和插入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！