用户登录后，点击查看个人信息的代码

Question

登陆后，点击查看个人资料，老是出错，
我是新手，请各位看看哪儿出错了?protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            SqlConnection cn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["cn"]);
            cn.Open();
            SqlCommand cmd = new SqlCommand("select * from dbo.Denglu where ID=" + Request["ID"], cn);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds, "dbo.Denglu");
            DataRowView rowview = ds.Tables["dbo.Denglu"].DefaultView[0];
            LBLName.Text = rowview["Personname"].ToString();
            LBLAge.Text = rowview["Personage"].ToString();
            LBLSex.Text = rowview["Personsex"].ToString();
            LBLPosition.Text = rowview["Personposition"].ToString();
            LBLAddress.Text = rowview["Address"].ToString();
            LBLTel.Text = rowview["Tel"].ToString();
            LBLEmail.Text = rowview["Email"].ToString();
            ds.Clear();
            cn.Close();
        }
    }

Answer 1

select * from dbo.Denglu where ID=" + Request.QueryString["ID"],
if(ds.Tables["dbo.Denglu"].Row.Count>0)
{}
值是否存在

Answer 2

用户代码未处理 System.Data.SqlClient.SqlException
  Message="'=' 附近有语法错误。"
  Source=".Net SqlClient Data Provider"
  ErrorCode=-2146232060
  Class=15
  LineNumber=1
  Number=102
  Procedure=""
  Server="localhost"
  State=1
  StackTrace:
       在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       在 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       在 System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
       在 System.Data.SqlClient.SqlDataReader.get_MetaData()
       在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
       在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
       在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
       在 Info.Page_Load(Object sender, EventArgs e) 位置 e:\学习\ASP.NET实例自学手册 (G)\mr\Zhengshu\Info.aspx.cs:行号 23
       在 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
       在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
       在 System.Web.UI.Control.OnLoad(EventArgs e)
       在 System.Web.UI.Control.LoadRecursive()
       在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Answer 3

 我想也是ID没传过来...Request.QueryString["字段名"] 这样好些.还有你没给出出错的信息...

Answer 4

看错误的信息在SqlConnection就出错了是不是连接字符串有不对的地方

Answer 5

cn.Open()这句有没有报异常？是否未连接上数据库，如果是的话检查连接字符串是否正确。。
其次写SqlCommand语句之前选判断Request.QuerString["id"]是否为null。。