大家帮我看下代码有没错咯。..public partial class EX09_06 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//获取留言者的名字
string UserName=Request["UserName"];
string strConn="server=Localhost;uid=sa;pwd=;database=Aspnet";
string selCmd="server * from Ex09_User where UserName like'"+UserName+"'";
SqlConnection myConnection=new SqlConnection();
myConnection.ConnectionString=strConn;
SqlDataAdapter da = new SqlDataAdapter(selCmd, myConnection);
DataSet ds = new DataSet();
da.Fill(ds, "user");
Repeater1.DataSource = ds.Tables["user"].DefaultView;
Repeater1.DataBind();
myConnection.Close();
}下面是错误提示:
public partial class EX09_06 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//获取留言者的名字
string UserName=Request["UserName"];
string strConn="server=Localhost;uid=sa;pwd=;database=Aspnet";
string selCmd="server * from Ex09_User where UserName like'"+UserName+"'";
SqlConnection myConnection=new SqlConnection();
myConnection.ConnectionString=strConn;
SqlDataAdapter da = new SqlDataAdapter(selCmd, myConnection);
DataSet ds = new DataSet();
da.Fill(ds, "user");
Repeater1.DataSource = ds.Tables["user"].DefaultView;
Repeater1.DataBind();
myConnection.Close();
}
{
protected void Page_Load(object sender, EventArgs e)
{
//获取留言者的名字
string UserName=Request["UserName"];
string strConn="server=Localhost;uid=sa;pwd=;database=Aspnet";
string selCmd="server * from Ex09_User where UserName like'"+UserName+"'";
SqlConnection myConnection=new SqlConnection();
myConnection.ConnectionString=strConn;
SqlDataAdapter da = new SqlDataAdapter(selCmd, myConnection);
DataSet ds = new DataSet();
da.Fill(ds, "user");
Repeater1.DataSource = ds.Tables["user"].DefaultView;
Repeater1.DataBind();
myConnection.Close();
}下面是错误提示:
public partial class EX09_06 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//获取留言者的名字
string UserName=Request["UserName"];
string strConn="server=Localhost;uid=sa;pwd=;database=Aspnet";
string selCmd="server * from Ex09_User where UserName like'"+UserName+"'";
SqlConnection myConnection=new SqlConnection();
myConnection.ConnectionString=strConn;
SqlDataAdapter da = new SqlDataAdapter(selCmd, myConnection);
DataSet ds = new DataSet();
da.Fill(ds, "user");
Repeater1.DataSource = ds.Tables["user"].DefaultView;
Repeater1.DataBind();
myConnection.Close();
}
错误提示:
第 1 行: '*' 附近有语法错误。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.SqlClient.SqlException: 第 1 行: '*' 附近有语法错误。源错误:
行 23: SqlDataAdapter da = new SqlDataAdapter(selCmd, myConnection);
行 24: DataSet ds = new DataSet();
行 25: da.Fill(ds, "user");
行 26: Repeater1.DataSource = ds.Tables["user"].DefaultView;
行 27: Repeater1.DataBind();
源文件: d:\C#\WebSite1\EX09_06.aspx.cs 行: 25