我做的一个仓库管理系统
入库
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 store
{
public partial class In : Form
{
public In()
{
InitializeComponent();
}
DataSet ds;
private void button1_Click(object sender, EventArgs e)
{
SqlConnection coon = new SqlConnection("Data Source=.;Initial Catalog=store;Integrated Security=True");
coon.Open();
string sql = "insert into in(ino,itime,inum) values" + "('" + textIno.Text.Trim() + "','" + textItime.Text.Trim() + "','" + textInum.Text.Trim() + "')"; SqlDataAdapter adp = new SqlDataAdapter();
adp.SelectCommand = new SqlCommand(sql, coon);
ds = new DataSet();
ds.Clear();
adp.Fill(ds, "in");
MessageBox.Show("入库成功!");
}
}
}
出现了“关键字 'in' 附近有语法错误”的错误,改了好长时间,试了好多方法都不行,很郁闷,希望高手帮我解决一下,谢谢!
入库
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 store
{
public partial class In : Form
{
public In()
{
InitializeComponent();
}
DataSet ds;
private void button1_Click(object sender, EventArgs e)
{
SqlConnection coon = new SqlConnection("Data Source=.;Initial Catalog=store;Integrated Security=True");
coon.Open();
string sql = "insert into in(ino,itime,inum) values" + "('" + textIno.Text.Trim() + "','" + textItime.Text.Trim() + "','" + textInum.Text.Trim() + "')"; SqlDataAdapter adp = new SqlDataAdapter();
adp.SelectCommand = new SqlCommand(sql, coon);
ds = new DataSet();
ds.Clear();
adp.Fill(ds, "in");
MessageBox.Show("入库成功!");
}
}
}
出现了“关键字 'in' 附近有语法错误”的错误,改了好长时间,试了好多方法都不行,很郁闷,希望高手帮我解决一下,谢谢!
in是表名?和sql关键字重复了
把所有用到in的都改了in是保留字来着吧。
把in价格括号[in]
数据表的表名尽量不要使用保留字
如果使用的话
好像可以通过[in]来处理