日期:2014-05-20  浏览次数:20509 次

请问这个数据库连接怎么调试?
using   System;
using   System.Data;
using   System.Configuration;
using   System.Web;
using   System.Web.Security;
using   System.Web.UI;
using   System.Web.UI.WebControls;
using   System.Web.UI.WebControls.WebParts;
using   System.Web.UI.HtmlControls;
using   System.Data.SqlClient;

public   partial   class   _Default   :   System.Web.UI.Page  
{
        protected   void   Page_Load(object   sender,   EventArgs   e)
        {
                string   strConn= "server=(local);database=Northwind;uid   =sa;   Pwd=123456 ";

                SqlConnection   cn=new   SqlConnection(strConn);
                cn.Open;
                SqlCommand   cm=new   SqlCommand( "select   *   from   categories ",cn);
                SqlDataReader   dr=cm.ExecuteReader();
                dgCust.DataSource=dr;
                dgCust.DataBind();
                cn.Close;


        }
}


调试结果为:


Server   Error   in   '/WebSite2 '   Application.
--------------------------------------------

Compilation   Error  
Description:   An   error   occurred   during   the   compilation   of   a   resource   required   to   service   this   request.   Please   review   the   following   specific   error   details   and   modify   your   source   code   appropriately.  

Compiler   Error   Message:   CS0201:   Only   assignment,   call,   increment,   decrement,   and   new   object   expressions   can   be   used   as   a   statement

Source   Error:
 

Line   17:  
Line   18:                   SqlConnection   cn=new   SqlConnection(strConn);
Line   19:                   cn.Open;
Line   20:                   SqlCommand   cm=new   SqlCommand( "select   *   from   categories ",cn);
Line   21:                   SqlDataReader   dr=cm.ExecuteReader();
 

Source   File:   d:\Documents   and   Settings\Administrator\My   Documents\Visual   Studio   2005\WebSites\WebSite2\Default.aspx.cs         Line:   19  

--------------------------------------------
Version   Information:   Microsoft   .NET   Framework   Version:2.0.50727.42;   ASP.NET   Version:2.0.50727.210  



------解决方案--------------------
少了括号,改成这样
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)