我在数据库中定义了table的颜色
比如
table tr td
#e0e0e0 #e3e3e3 #e5e5e5
我想把它绑定到页面的table中.那么我怎么在代码中定义方法呢?private static string GetColor()
{
//这部分怎么写呢?
}<TABLE align="center" bgcolor = '<%# GetColor() %>'>
比如
table tr td
#e0e0e0 #e3e3e3 #e5e5e5
我想把它绑定到页面的table中.那么我怎么在代码中定义方法呢?private static string GetColor()
{
//这部分怎么写呢?
}<TABLE align="center" bgcolor = '<%# GetColor() %>'>
{
SqlCommand cmd = new SqlCommand("Select * from tbColor");
SqlConnection conn = new Connection("Data Source=.....");
cmd.Connection = conn;
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
string color = "";
if(reader.Read())
color = reader["Table"].ToString();
reader.Close();
conn.Close();
return color;
}
{
SqlCommand cmd = new SqlCommand("Select * from tbColor");
SqlConnection conn = new Connection("Data Source=.....");
cmd.Connection = conn;
catch{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
string color = "";
if(reader.Read())
color = reader["Table"].ToString();
reader.Close();
conn.Close();
return color;
}
private static string GetColor()
{
SqlCommand cmd = new SqlCommand("Select * from tbColor");
SqlConnection conn = new Connection("Data Source=.....");
try
{cmd.Connection = conn;
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
string color = "";
if(reader.Read())
color = reader["Table"].ToString();
}
catch
{}
finally
{
reader.Close();
conn.Close();
}
return color;
}
最后加上
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面 if(!IsPostBack)
{
Page.DataBind();
}}