SQL结果保存到C＃变量_未分类的问答_编程通用

您好

我如何保存SQL结果保存到C＃变量

请纠正我下面是我的代码，我必须找到在DeliveryOrdertable总数行，并保存它来计数变量。


public void autono()

    {

        int count;

        SqlDataReader reader = null;

        string connectionString = ConfigurationManager.ConnectionStrings["InvoiceConnectionString"].ConnectionString;

        SqlConnection conn = new SqlConnection(connectionString);  

        string selectcmd = " SELECT count(*)as numberofrows FROM DeliveryOrder" ;

        SqlCommand cmd = new SqlCommand(selectcmd, conn);

 

    

        conn.Open();

        reader = cmd.ExecuteReader();

        

        while (reader.Read())

        {

            count = Convert.ToInt32(reader);

                

            conn.Close();

                

 

        }    }

关于
朗西

回答

评论会员：游客时间：2012/02/06

Prerak帕特尔:使用此codeprelang="c#"count=reader.GetInt32(spanclass="code-digit"0/span);/pre/code
OriginalGriff

评论会员：游客时间：2012/02/06

尝试:codeprelang="c#"spanclass="code-keyword"public/spanspanclass="code-keyword"void/spanautono(){spanclass="code-keyword"int/spancount;SqlDataReaderreader=spanclass="code-keyword"null/span;spanclass="code-keyword"string/spanconnectionString=ConfigurationManager.ConnectionStrings[spanclass="code-string""/spanspanclass="code-string"InvoiceConnectionString"/span].ConnectionString;SqlConnectionconn=spanclass="code-keyword"new/spanSqlConnection(connectionString);spanclass="code-keyword"string/spanselectcmd=spanclass="code-string""/spanspanclass="code-string"SELECTcount(*)asnumberofrowsFROMDeliveryOrder"/span;SqlCommandcmd=spanclass="code-keyword"new/spanSqlCommand(selectcmd,conn);conn.Open();count=(spanclass="code-keyword"int/span)cmd.ExecuteScalar();}/pre/code的