string sql ="SELECT dbo.Supplier.s_Name AS 供应商, dbo.Purchase.p_datetime AS 开单日期, dbo.WarehouseCode.w_Name AS 所在仓库," +
"dbo.Employees.e_Name AS 操作人" +
"FROM dbo.Employees INNER JOIN" +
"dbo.Purchase ON dbo.Employees.e_ID = dbo.Purchase.e_ID INNER JOIN" +
"dbo.Supplier ON dbo.Purchase.s_ID = dbo.Supplier.s_ID INNER JOIN" +
"dbo.WarehouseCode ON dbo.Purchase.WareHouse = dbo.WarehouseCode.w_ID";
总出现dbo附近有语法错误,该怎么样解决?我是新手,麻烦各位了
"dbo.Employees.e_Name AS 操作人" +
"FROM dbo.Employees INNER JOIN" +
"dbo.Purchase ON dbo.Employees.e_ID = dbo.Purchase.e_ID INNER JOIN" +
"dbo.Supplier ON dbo.Purchase.s_ID = dbo.Supplier.s_ID INNER JOIN" +
"dbo.WarehouseCode ON dbo.Purchase.WareHouse = dbo.WarehouseCode.w_ID";
总出现dbo附近有语法错误,该怎么样解决?我是新手,麻烦各位了
解决方案 »
- C# CA2000警告
- fontDialog怎么更改对话框标题
- 如何停止掉当前正在执行的进程
- [Winform] Process执行问题。谢谢
- C#中怎样设置文本框的属性,当按一下Tab键以后自动转到下一文本框(焦点从txtA二转到txtB中去)
- 和RichTextBox 的Undo()和SelectionAlignment属性相关
- 从网上搜的经典的winForm中datagrid导为Excel文件的程序
- 请教各位兄弟姐妹!如何在SQLDMO中设置登录服务器的认证模式为WINDOWS NT集成安全!
- windows服务能向外提供API吗?
- 怎样在窗体里打开flash文件!
- dataGridView 单击主标头排序或单击后收缩子标头
- 帮忙看下怎么使用水晶C#报表,显示数据和条形统计图?用ado。net连接的,不是ole的?
要么去掉dbo.
要么在前面加上你的数据库名字.
DataBase.dbo.Table.Field
"dbo.Employees.e_Name AS 操作人 " +
"FROM dbo.Employees INNER JOIN " +
"dbo.Purchase ON dbo.Employees.e_ID = dbo.Purchase.e_ID INNER JOIN " +
"dbo.Supplier ON dbo.Purchase.s_ID = dbo.Supplier.s_ID INNER JOIN " +
"dbo.WarehouseCode ON dbo.Purchase.WareHouse = dbo.WarehouseCode.w_ID";