system.data.dataRowview 不包含名为"manager1的属性"

[lixiang4024]

private string sqlstr1 = "Data Source=.;Initial Catalog=company;User ID=sa;Password=overmax2005";
protected void GridView1_RowDataBound1(object sender, GridViewRowEventArgs e)
{
if (((DropDownList)e.Row.FindControl("DDLXueli1")) != null)
{
DropDownList ddlxueli = (DropDownList)e.Row.FindControl("DDLXueli1");



DataSet ds = new DataSet();
SqlConnection sqlconn = new SqlConnection(sqlstr1);
string sql = "SELECT * FROM manager1";
SqlDataAdapter sqlAdapter = new SqlDataAdapter(sql, sqlconn);
sqlconn.Open();
sqlAdapter.Fill(ds);
sqlconn.Close();
DataTable dt = ds.Tables[0];
DataRow dr = dt.NewRow();
dt.Rows.InsertAt(dr, 0);
ddlxueli.DataSource = dt.DefaultView;
ddlxueli.DataTextField = "manager1";
ddlxueli.DataValueField = "manager1";
ddlxueli.DataBind();//这行提示datarowview
ddlxueli.SelectedValue = ((HiddenField)e.Row.FindControl("HDFXueli")).Value;

提示d

[lixiang4024]

这个应该怎么优化？在一个gridview中安插两个dropdownlist并实现更新. dropdwonlist的数据是从另外两个表读取

private string sqlstr1 = "Data Source=.;Initial Catalog=company;User ID=sa;Password=2007";
protected void GridView1_RowDataBound1(object sender, GridViewRowEventArgs e)
{
if (((DropDownList)e.Row.FindControl("DDLXueli1")) != null)
{
DropDownList ddlxueli = (DropDownList)e.Row.FindControl("DDLXueli1");



DataSet ds = new DataSet();
SqlConnection sqlconn = new SqlConnection(sqlstr1);
string sql = "SELECT * FROM manager1";
SqlDataAdapter sqlAdapter = new SqlDataAdapter(sql, sqlconn);
sqlconn.Open();
sqlAdapter.Fill(ds);
sqlconn.Close();
DataTable dt = ds.Tables[0];
DataRow dr = dt.NewRow();
dt.Rows.InsertAt(dr, 0);
ddlxueli.DataSource = dt.DefaultView;
ddlxueli.DataTextField = "manager1";
ddlxueli.DataValueField = "manager1";
ddlxueli.DataBind();
ddlxueli.SelectedValue = ((HiddenField)e.Row.FindControl("HDFXueli")).Value;

}
}



protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{

String strConnection = ConfigurationSettings.AppSettings["ConnectionString"];
SqlConnection myConnection = new SqlConnection(strConnection);

SqlCommand cm = new SqlCommand("updatelogin", myConnection);
cm.CommandType = CommandType.StoredProcedure;
cm.Connection.Open();


int id;
string username, userkind, wentilist, wenti, prio, status,manager1;
id = int.Parse(GridView1.Rows[e.RowIndex].
Cells[0].Text);
username = ((TextBox)GridView1.Rows[e.RowIndex].
Cells[1].Controls[0]).Text;
userkind = ((TextBox)GridView1.Rows[e.RowIndex].
Cells[2].Controls[0]).Text;
wenti = ((TextBox)GridView1.Rows[e.RowIndex].
Cells[3].Controls[0]).Text;
wentilist = ((TextBox)GridView1.Rows[e.RowIndex].
Cells[4].Controls[0]).Text;

status = ((DropDownList)GridView1.Rows[e.RowIndex].FindControl("DDLXueli")).SelectedValue;

manager1= ((DropDownList)GridView1.Rows[e.RowIndex].FindControl("DDLXueli1")).SelectedValue;

cm.Parameters.Add(new SqlParameter("@id", id));
cm.Parameters.Add(new SqlParameter("@username", username));
cm.Parameters.Add(new SqlParameter("@userkind", userkind));
cm.Parameters.Add(new SqlParameter("@wenti", wenti));
cm.Parameters.Add(new SqlParameter("@wentilist", wentilist));
cm.Parameters.Add(new SqlParameter("@status", status));
cm.Parameters.Add(new SqlParameter("@manager1", manager1));

cm.ExecuteNonQuery();

GridView1.EditIndex = -1;
Bindgridview();
}
private string sqlstr = "Data Source=.;Initial Catalog=company;User ID=sa;Password=2007";
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (((DropDownList)e.Row.FindControl("DDLXueli")) != null)
{
DropDownList ddlxueli = (DropDownList)e.Row.FindControl("DDLXueli");



DataSet ds = new DataSet();
SqlConnection sqlconn = new SqlConnection(sqlstr);
string sql = "SELECT * FROM status";
SqlDataAdapter sqlAdapter = new SqlDataAdapter(sql, sqlconn);
sqlconn.Open();
sqlAdapter.Fill(ds);
sqlconn.Close();
DataTable dt = ds.Tables[0];
DataRow dr = dt.NewRow();
dt.Rows.InsertAt(dr, 0);
ddlxueli.DataSource = dt.DefaultView;
ddlxueli.DataTextField = "status";
ddlxueli.DataValueField = "status";
ddlxueli.DataBind();
ddlxueli.SelectedValue = ((HiddenField)e.Row.FindControl("HDFXueli")).Value;

}
}

[jimu8130]

你的gridview怎么对应两个rowdatabound事件啊？
另外，ddlxueli.DataSource = dt.DefaultView;
ddlxueli.DataTextField = "manager1";
ddlxueli.DataValueField = "manager1";
和
ddlxueli.DataTextField = "status";
ddlxueli.DataValueField = "status";

到底manager1和status哪个是相应数据库表的字段名称？

[jimu8130]

rowupdate事件里面
String strConnection = ConfigurationSettings.AppSettings["ConnectionString"];
这个连接字符串最好能设置成为一个全局常量
这样不用每次都查询xml文件

然后下面的语句可以改写成
using（SqlConnection myConnection = new SqlConnection(strConnection)）
{
SqlCommand cm = new SqlCommand("updatelogin", myConnection);
cm.CommandType = CommandType.StoredProcedure;
cm.Connection.Open();


int id;
string username, userkind, wentilist, wenti, prio, status,manager1;
id = int.Parse(GridView1.Rows[e.RowIndex].
Cells[0].Text);
username = ((TextBox)GridView1.Rows[e.RowIndex].
Cells[1].Controls[0]).Text;
userkind = ((TextBox)GridView1.Rows[e.RowIndex].
Cells[2].Controls[0]).Text;
wenti = ((TextBox)GridView1.Rows[e.RowIndex].
Cells[3].Controls[0]).Text;
wentilist = ((TextBox)GridView1.Rows[e.RowIndex].
Cells[4].Controls[0]).Text;

status = ((DropDownList)GridView1.Rows[e.RowIndex].FindControl("DDLXueli")).SelectedValue;

manager1= ((DropDownList)GridView1.Rows[e.RowIndex].FindControl("DDLXueli1")).SelectedValue;

cm.Parameters.Add(new SqlParameter("@id", id));
cm.Parameters.Add(new SqlParameter("@username", username));
cm.Parameters.Add(new SqlParameter("@userkind", userkind));
cm.Parameters.Add(new SqlParameter("@wenti", wenti));
cm.Parameters.Add(new SqlParameter("@wentilist", wentilist));
cm.Parameters.Add(new SqlParameter("@status", status));
cm.Parameters.Add(new SqlParameter("@manager1", manager1));

cm.ExecuteNonQuery();

GridView1.EditIndex = -1;
Bindgridview();
}

[lixiang4024]

另外，ddlxueli.DataSource = dt.DefaultView;
ddlxueli.DataTextField = "manager1";
ddlxueli.DataValueField = "manager1";
和
ddlxueli.DataTextField = "status";
ddlxueli.DataValueField = "status";

到底manager1和status哪个是相应数据库表的字段名称？

ddlxueli.DataTextField = "manager1";
ddlxueli.DataValueField = "manager1

string sql = "SELECT * FROM manager1";





ddlxueli.DataTextField = "status";
ddlxueli.DataValueField = "status";
string sql = "SELECT * FROM status";

[jimu8130]

郁闷，lz只会贴代码，不会描述信息啊？

[lixiang4024]

你有MSN或QQ吗，57125749

[jimu8130]

msn发消息你了

[ylqmf]

up

[leafsword_519]

string sql = "SELECT * FROM manager1";
ddlxueli.DataTextField = "manager1";//这里应该用你查询到数据库字段表示
ddlxueli.DataValueField = "manager1";//同上

比如
string sql = "select cityid,cityname from city";
ddl.DataTextField = "cityname";
ddl.DataValueField = "cityid";

[jimu8130]

建议你加上这个判断在rowdatabound事件里面If (e.Row.RowType = DataControlRowType.DataRow)
{}

[jiao545214147]

If (e.Row.RowType = DataControlRowType.DataRow)

{
....代码
}