关键字旁边的语法不正确 "用户"
错误如下:
未加工的类型消除 ' System.Data.SqlClient.SqlException ' 发生在 System.Data.dll
附加信息:关键字旁边的语法不正确 'User'.
在如:
未加工的类型消除 ' System.Data.SqlClient.SqlException ' 发生在 System.Data.dll
附加信息:关键字旁边的语法不正确 'User'.
在如:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
SqlConnection conn;
SqlDataAdapter GameDA;
SqlDataAdapter DetailDA;
DataSet DetailDS;
SqlCommandBuilder cmdBuilder;
SqlDataAdapter UserDA;
SqlDataAdapter AdministratorDA;
SqlDataAdapter OrderDA;
DataSet OrderDS;
SqlCommandBuilder cmdBuilder2;
public Form1//
{
InitializeComponent//;
conn = new SqlConnection/"Data Source=HOME-AC284121FE\\SQLEXPRESS;Initial Catalog=GameShop;Integrated Security=SSPI;"/;
SqlCommand command1 = new SqlCommand/"SELECT * FROM Game", conn/;
GameDA = new SqlDataAdapter/command1/;
SqlCommand command2 = new SqlCommand/"SELECT * FROM Detail WHERE GameID = @GameID", conn/;
command2.Parameters.Add/new SqlParameter/"@GameID", SqlDbType.Int//;
DetailDA = new SqlDataAdapter/command2/;
SqlCommand command3 = new SqlCommand/"SELECT * FROM Administrator", conn/;
AdministratorDA = new SqlDataAdapter/command3/;
SqlCommand command4 = new SqlCommand/"SELECT * FROM User", conn/;
UserDA = new SqlDataAdapter/command4/;
SqlCommand command5 = new SqlCommand/"SELECT * FROM Order WHERE UserID = @UserID", conn/;
command5.Parameters.Add/new SqlParameter/"@UserID", SqlDbType.Int//;
OrderDA = new SqlDataAdapter/command5/;
cmdBuilder2 = new SqlCommandBuilder/OrderDA/;
cmdBuilder = new SqlCommandBuilder/DetailDA/;
}
private void Form1_Load/object sender, EventArgs e/
{
DetailDS = new DataSet//;
OrderDS = new DataSet//;
GameDA.Fill/DetailDS, "Game"/;
**UserDA.Fill/OrderDS, "User"/; // <-- Error**
AdministratorDA.Fill/OrderDS, "Administrator"/;
comboBoxGame.DisplayMember = "Name";
comboBoxGame.ValueMember = "GameID";
comboBoxGame.DataSource = DetailDS.Tables["Game"];
dataGridView.DataSource = DetailDS.Tables["Detail"];
dataGridView.Columns["GameID"].Visible = false;
dataGridView.Columns["DetailID"].Visible = false;
}
private void comboBoxGame_SelectedIndexChanged/object sender, EventArgs e/
{
if /comboBoxGame.SelectedValue != null/
if /DetailDS.Tables.Contains/"Detail"//
{
DetailDS.Tables["Detail"].Clear//;
}
DetailDA.SelectCommand.Parameters[0].Value = comboBoxGame.SelectedValue;
DetailDA.Fill/DetailDS, "Detail"/;
}
private void buttonExit_Click/object sender, EventArgs e/
{
this.Close//;
}
}
}
没有找到相关结果
已邀请:
2 个回复
八刀丁二
赞同来自:
http://msdn.microsoft.com/en-u ... .aspx
在 SQL Server, 因此,你必须使用
http://msdn.microsoft.com/en-u ... .aspx
参考您的表格。 尝试
SqlCommand command4 = new SqlCommand/"SELECT * FROM [User]", conn/;
而不是这一点 ... 或在未保留的内容中重命名表。
/我也强烈建议您保留访问代码之外的数据。 UI, 完全处理化合物等......但这是另一件事。/
风见雨下
赞同来自:
- 这是一个内置的功能 SQL Server. 名称必须用方形括号括起来:
[User]
. 这适用于表意外遇到关键字或内置名称的表的所有名称和其他用户定义的名称,因此我怀疑您还需要写入
[Order]
, 只要
- 这是一个关键字 SQL.