下拉框中 显示数据库的值 代码如下
private void binduser(string id)
{
string Sql = "select * from t_dlsda where id=" + id + ""; DataTable dt = conn.SqlQuery(Sql);
txtname.Text = dt.Rows[0]["t_name"].ToString();
dropsf.SelectedIndex= dropsf.Items.IndexOf(dropsf.Items.FindByValue("t_sf"));
dropdq.SelectedIndex =dropdq.Items.IndexOf(dropdq.Items.FindByValue("t_dq"));
TextBox1.Text = dt.Rows[0]["t_dh"].ToString();
TextBox2.Text = dt.Rows[0]["t_phone"].ToString();
TextBox3.Text = dt.Rows[0]["t_cz"].ToString();
TextBox4.Text = dt.Rows[0]["t_gpsy"].ToString();
TextBox5.Text = dt.Rows[0]["t_pssy"].ToString();
txtaddr.Text= dt.Rows[0]["t_add"].ToString();
TextBox6.Text = dt.Rows[0]["t_nrwl"].ToString();
TextBox7.Text = dt.Rows[0]["t_bzj"].ToString();
TextBox8.Text = dt.Rows[0]["t_fl"].ToString();
}
dropsf和dropdq赋数据库中的值 应该怎么改?
private void binduser(string id)
{
string Sql = "select * from t_dlsda where id=" + id + ""; DataTable dt = conn.SqlQuery(Sql);
txtname.Text = dt.Rows[0]["t_name"].ToString();
dropsf.SelectedIndex= dropsf.Items.IndexOf(dropsf.Items.FindByValue("t_sf"));
dropdq.SelectedIndex =dropdq.Items.IndexOf(dropdq.Items.FindByValue("t_dq"));
TextBox1.Text = dt.Rows[0]["t_dh"].ToString();
TextBox2.Text = dt.Rows[0]["t_phone"].ToString();
TextBox3.Text = dt.Rows[0]["t_cz"].ToString();
TextBox4.Text = dt.Rows[0]["t_gpsy"].ToString();
TextBox5.Text = dt.Rows[0]["t_pssy"].ToString();
txtaddr.Text= dt.Rows[0]["t_add"].ToString();
TextBox6.Text = dt.Rows[0]["t_nrwl"].ToString();
TextBox7.Text = dt.Rows[0]["t_bzj"].ToString();
TextBox8.Text = dt.Rows[0]["t_fl"].ToString();
}
dropsf和dropdq赋数据库中的值 应该怎么改?
下拉ID.DataSource = bllType.GetAllList().Tables[0];//下拉框绑定数据表
下拉ID.DataTextField = "TraceType";//绑定text
下拉ID.DataValueField = "id";//绑定Value
下拉ID.DataBind();//绑定
绑定之后你可以指定下拉初始化时候选得是哪项.........
{
if (ddlName.Items[i].Text == ddl_value)
{
ddlName.Items[i].Selected = true;
break;
}
}