using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bind();
}
}
public void bind()
{
SqlConnection con = new SqlConnection("Data Source=(local);database=users;Trusted_Connection=true;");
string str = "select * from user";
SqlCommand cmd = new SqlCommand(str, con);
DataSet ds = new DataSet();
SqlDataAdapter dapt = new SqlDataAdapter(cmd);
con.Open(); dapt.Fill(ds,"user");
GridView1.DataSource = ds;
GridView1.DataKeyNames = new string[] { "Acc" };
GridView1.DataBind();
con.Close();
}
}代码没错误啊,但是一调试的话dapt.Fill(ds,"user");这里就出问题,说Incorrect syntax near the keyword 'user'.这是怎么回事呢??请高手们帮忙看下!
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bind();
}
}
public void bind()
{
SqlConnection con = new SqlConnection("Data Source=(local);database=users;Trusted_Connection=true;");
string str = "select * from user";
SqlCommand cmd = new SqlCommand(str, con);
DataSet ds = new DataSet();
SqlDataAdapter dapt = new SqlDataAdapter(cmd);
con.Open(); dapt.Fill(ds,"user");
GridView1.DataSource = ds;
GridView1.DataKeyNames = new string[] { "Acc" };
GridView1.DataBind();
con.Close();
}
}代码没错误啊,但是一调试的话dapt.Fill(ds,"user");这里就出问题,说Incorrect syntax near the keyword 'user'.这是怎么回事呢??请高手们帮忙看下!
解决方案 »
- 时间对比判断
- 做了一个页面静态化小软件,和大家分享,up有分
- 大家看看我这样理解对不对? 没分了 可怜下我吧
- 客户端阻止事件触发的问题,分别是webcontrol和html run = server 控件,结果阻止效果都不能完满完成,而且在ie和firefox中只有一个得到想
- 请问,一个文本框输入完数字直接回车后,如何自动触发一个按钮的点击事件阿?
- 请问各位什么是正则表达式???
- dataview1[0].Row[15]是什么意思?
- DropDownList绑定以后,怎么每次选择的项都是第一个,大家帮忙看看!
- Hello World & 程序员的进化(ZT)
- 在客户端提交表单出错
- 怎么来确定系统的架构?
- 请问类似于CSDN头像上传剪切的源代码
dapt.Fill(ds,"user");
//这里阿,改过来就是了
GridView1.DataSource = ds.Tables["user"].DefaultView;
GridView1.DataKeyNames = new string[] { "Acc" };
string str = "select * from [user]";
SqlCommand cmd = new SqlCommand(str, con);
DataSet ds = new DataSet();
SqlDataAdapter dapt = new SqlDataAdapter(cmd);
con.Open(); dapt.Fill(ds,"user");
改為:string str = "select * from user";
SqlCommand cmd = new SqlCommand(str, con);
SqlDataAdapter dapt = new SqlDataAdapter(cmd);
DataTable ds = new DataTable();
dapt.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataKeyNames = new string[] { "Acc" };
GridView1.DataBind();
con.Close();