想根据数据库里的数据确定label和button的属性
protected void Page_Load(object sender, EventArgs e)
{
string Number, Title, Content, Name, Time, Havefile = "0", Filename = "";
int Count, AnsCount;
string connectionString = constr;
SqlConnection con = new SqlConnection(connectionString);
string cmdtext = "SELECT * FROM PUB_INFO WHERE Pub_Num=" + Request.Params[0].ToString();
SqlCommand cmd = new SqlCommand(cmdtext, con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Number = dr.GetValue(0).ToString();
Title = dr.GetValue(1).ToString();
Content = dr.GetValue(2).ToString();
Name = dr.GetValue(3).ToString();
Time = dr.GetValue(4).ToString();
Count = Convert.ToInt32(dr.GetValue(5).ToString());
AnsCount = Convert.ToInt32(dr.GetValue(6).ToString());
Havefile = dr.GetValue(7).ToString();
Filename = dr.GetValue(8).ToString();
}
if (Havefile == "0")
{
((Button)DataList1.Items[0].FindControl("Button1")).Visible = false;
((Label)DataList1.Items[0].FindControl("Label7")).Text = "无附件";
}
else
{
((Button)DataList1.Items[0].FindControl("Button1")).Visible = true;
((Button)DataList1.Items[0].FindControl("Button1")).Text = Filename;
((Label)DataList1.Items[0].FindControl("Label7")).Text = "";
}
}
每次都是页面读取出来时两个控件的属性都没有值啊,点一个botton后才显示值,求高手指导!!如果
protected void Page_Load(object sender, EventArgs e)
{
string Number, Title, Content, Name, Time, Havefile = "0", Filename = "";
int Count, AnsCount;
string connectionString = constr;
SqlConnection con = new SqlConnection(connectionString);
string cmdtext = "SELECT * FROM PUB_INFO WHERE Pub_Num=" + Request.Params[0].ToString();
SqlCommand cmd = new SqlCommand(cmdtext, con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Number = dr.GetValue(0).ToString();
Title = dr.GetValue(1).ToString();
Content = dr.GetValue(2).ToString();
Name = dr.GetValue(3).ToString();
Time = dr.GetValue(4).ToString();
Count = Convert.ToInt32(dr.GetValue(5).ToString());
AnsCount = Convert.ToInt32(dr.GetValue(6).ToString());
Havefile = dr.GetValue(7).ToString();
Filename = dr.GetValue(8).ToString();
}
if (Havefile == "0")
{
((Button)DataList1.Items[0].FindControl("Button1")).Visible = false;
((Label)DataList1.Items[0].FindControl("Label7")).Text = "无附件";
}
else
{
((Button)DataList1.Items[0].FindControl("Button1")).Visible = true;
((Button)DataList1.Items[0].FindControl("Button1")).Text = Filename;
((Label)DataList1.Items[0].FindControl("Label7")).Text = "";
}
}
每次都是页面读取出来时两个控件的属性都没有值啊,点一个botton后才显示值,求高手指导!!如果
解决方案 »
- 关于程序打包请教
- 水晶报表批量打印
- windows mobile做一个rdaserver是否可用的监听线程
- 又来200分 问思路 (c# 通讯问题(cell的报表获取服务器数据))
- 下拉菜单被控件盖住,显示不完整,求解决方案。 急急急……万分感激!!!!解决后立即给分!!!
- 如何捕获高速摄像头视频流.并且逐帧显示出来?
- 谁知道命令行参数的算法改如何写???让人很困惑的问题
- C#怎么处理特殊符号?和$.....求解....
- C# Combobox如何加载jsonString
- 如何在程序中建立表
- winform下默认读取路径是\\bin\\debug,webservice默认读取路径是什么
- 批量修改lable标签背景颜色。
if (Havefile == "0")
{
((Button)DataList1.Items[0].FindControl("Button1")).Visible = false;
((Label)DataList1.Items[0].FindControl("Label7")).Text = "无附件";
}
else
{
((Button)DataList1.Items[0].FindControl("Button1")).Visible = true;
((Button)DataList1.Items[0].FindControl("Button1")).Text = Filename;
((Label)DataList1.Items[0].FindControl("Label7")).Text = "";
}
这里下断点
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
string Number, Title, Content, Name, Time, Havefile = "0", Filename = "";
int Count, AnsCount;
string connectionString = constr;
SqlConnection con = new SqlConnection(connectionString);
string cmdtext = "SELECT * FROM PUB_INFO WHERE Pub_Num=" + Request.Params[0].ToString();
SqlCommand cmd = new SqlCommand(cmdtext, con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Number = dr.GetValue(0).ToString();
Title = dr.GetValue(1).ToString();
Content = dr.GetValue(2).ToString();
Name = dr.GetValue(3).ToString();
Time = dr.GetValue(4).ToString();
Count = Convert.ToInt32(dr.GetValue(5).ToString());
AnsCount = Convert.ToInt32(dr.GetValue(6).ToString());
Havefile = dr.GetValue(7).ToString();
Filename = dr.GetValue(8).ToString();
}
if (Havefile == "0")
{
((Button)DataList1.Items[0].FindControl("Button1")).Visible = false;
((Label)DataList1.Items[0].FindControl("Label7")).Text = "无附件";
}
else
{
((Button)DataList1.Items[0].FindControl("Button1")).Visible = true;
((Button)DataList1.Items[0].FindControl("Button1")).Text = Filename;
((Label)DataList1.Items[0].FindControl("Label7")).Text = "";
}
}
}
datalist里面有个button和label控件