数据库中有些数据为空值,若我不让其把空值读出来,代码应该如何写?
比如下面这段程序,我是把数据都绑定到下拉框,但是由于前几个字段为null值,所以导致下拉的上面都是空白,怎么解决这个问题?
private void Page_Load(object sender, System.EventArgs e)
{
string con = ConfigurationSettings.AppSettings["SqlConnectionString"];
SqlConnection conn = new SqlConnection(con);
string sql = "SELECT * FROM class";
SqlCommand command = new SqlCommand(sql,conn);
conn.Open();
cpfl.DataSource = command.ExecuteReader();
cpfl.DataTextField = "产品分类";
cpfl.DataValueField = "产品分类";
cpfl.DataBind();
conn.Close();// 在此处放置用户代码以初始化页面
}