怎样用sql语句实现对某个字段的统计并且统计结果在text中显示.doc

怎样用sql语句实现对某个字段的统计，并且统计结果在text中显示？ 问： 怎样用sql语句实现对某个字段的统计，并且统计结果在text中显示？我的sql语句写为：select sum score from tables1 where field 1 我该怎么把选出的值给text ，希望给个例子 ______________________________________________________________________________________________ 答1： 用command对象，结果给datareader，在调用getstring 0 SqlConnection myconn new SqlConnection ... ; myconn.Open ; SqlCommand mycommand new SqlCommand sql,myconn ; SqlDataReader myreader mycommand.ExecuteReader ; while myreader.Read text1.text myreader.GetString 0 ; myreader.Close ; myconn.Close ; ______________________________________________________________________________________________ 答2： 我用的是oledbdatasetcommand,不是datareader这样不行吗？ ______________________________________________________________________________________________ 答3： 同样存在OleDbDataReader, OleDbCommand ______________________________________________________________________________________________ 答4： 把select sum score from tables1 where field 1 改写成select sum score as one,count * as two from tables1 where field 1然后在把ONE当作字段来访问. ______________________________________________________________________________________________ 答5： string sql select sum score from tables1 where field 1; OleDbCommand cmd new OleDbCommand sql,conn ; TextBox1.Text string cmd.ExecuteScalar ; ______________________________________________________________________________________________ 答6： to luningjfy_2001 ln 执行了sql后，我该怎么把它给text? m_contentSQL select sum gjsl as zh from Session ywnameid1 where Session bcxid m_objdscommand New OleDbDataAdapter m_contentSQL, Provider MSDAORA.1;Password swpi;User ID toollib;Data Source connect_toollib m_objdscommand.Fill m_objdataset, appd_tabs m_objtable m_objdataset.Tables appd_tabs myview m_objtable.DefaultView TextBox1.Text 这个地方怎么写？） TextBox1.DataBind ______________________________________________________________________________________________ 答7： 试试 TextBox1.Text TextBox m_objtable.DefaultView[0] .Text ______________________________