我只会绑定一个,请问要绑定俩怎么写啊?我是这么写的 string sql = "select Upload1,Add1 rom tblRight where UserID='" + UserID + "' and ParentID='" + ParentID + "'";SqlCommand sqlcomm = new SqlCommand(sql, sqlconn);sqlconn.Open();this.LUpload1.Text = sqlcomm.ExecuteScalar().ToString();
this.LAdd1.Text = ?sqlconn.Close();
this.LAdd1.Text = ?sqlconn.Close();
不是这个函数
this.label1.text=dataset.tables[0].rows[0]["字段一"].tostring();
this.label2.text=dataset.tables[0].rows[0]["字段2"].tostring();
this.LUpload1.Text = dr["Upload1"].ToString();
this.LAdd1.Text = dr["Add1"].ToString();
sqlconn.Close();
<Lable id='LAdd1' ...... text='<%# DataBinder.Eval(Container.DataItem,"列名")'></Label>
Convert.Tostring(cmd.ExecuScalar())
这样就OK
Ex:
public System.Data.OracleClient.OracleDataReader myReader;Label1.Text = myReader["field1"].ToString().Trim();
Label2.Text = myReader["field2"].ToString().Trim();
LUpload1.Text = dr["Upload1"].ToString();
LAdd1.Text = dr["Add1"].ToString();
sqlconn.Close();
dr.Close();
if(dr.Read())
{
this.LUpload1.Text = dr["Upload1"].ToString();
this.LAdd1.Text = dr["Add1"].ToString();
sqlconn.Close();
dr.close();
}这样才对
try
{
if(dr.Read())
{
LUpload1.Text = dr["Upload1"].ToString();
LAdd1.Text = dr["Add1"].ToString();
}
}
catch
{
提示错误
}
finally
{
sqlconn.Close();
dr.close();
}
{
LUpload1.Text = dr["Upload1"].ToString();
LAdd1.Text = dr["Add1"].ToString();
}