一楼说的对,如果你用LABEL显示,可以用DataReader,如DataReader reader1= sql.GetSqlReader("select * from table1 where id="+this.search.Text)//sql.GetSqlReader为读取数据的方法 if (reader1.Read()) { this.countnum.Text = reader1["name"].ToString(); } 如果要显示总数改为DataReader reader1= sql.GetSqlReader("select count(*) as countnum from table1 ")就OK了!
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!IsPostBack)
{
BindData();
Response.Write(DateTime.Now.ToString("yyyy-MM-dd")); }
}
private void BindData()
{
SqlConnection sqlcon = new SqlConnection(Configuration.ConnectionString);
SqlCommand sqlcom =new SqlCommand();
sqlcon.Open();
sqlcom.Connection = sqlcon;
sqlcom.CommandText = "select a.SubProjectID ,a.TSMainProID,FristCensorDate ,b.MainBulidUnit ,b.SubRegisterContent,"+
" c.sjdwmc,c.kcdwmc,b.SubProjectName " +
" from TS_ProState a left join TS_ProjectInformation b on a.SubProjectID = b.SubProjectID "+
" left join TS_TSProjectInfo c on a.SubProjectID = c.dxgcbh "+
" where a.SubProjectID like '%"+TextKeyWords.Text.ToString()+"%' and isnull(TSMainProID,'popopopo')!= 'popopopo'";
SqlDataReader my = null;
try
{
my = sqlcom.ExecuteReader();
projectinfo.DataSource = my;
projectinfo.DataBind();
}
catch(Exception e)
{
throw(e);
}
finally
{
sqlcon.Close();
my.Close();
}
}
if (reader1.Read())
{
this.countnum.Text = reader1["name"].ToString();
}
如果要显示总数改为DataReader reader1= sql.GetSqlReader("select count(*) as countnum from table1 ")就OK了!
label1.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "person.name"));
lable1.text= dataset.tables(0).rows.count '得到记录数
可以看下帮助,很简单的
文本框=ds.Tables[表名].Rows[某行][字段名].ToString();
dataset可以操作数据库,dataset是一个表的集合