以下是代码 protected void GetSelectedData() { try { DataSet ds=new DataSet(); string sqlStr; SqlConnection sqlConn=new SqlConnection(Conn); sqlStr="select Detail,Reason,SettleWay,"+ "(select Name from TB_OperatorInfo where OperatorNo=TB_ProblemRecord.RecorderNo) as RecorderName,"+ "(select Name from TB_OperatorInfo where OperatorNo=TB_ProblemRecord.ManagerNo) as ManagerName,"+ "(case State when '0' then '未处理' when '1' then '已处理' else '' end) as State,"+ "(select TypeName from TB_ProblemBigType where TypeNo=TB_ProblemRecord.BigSort) as BigType,"+ "(select TypeName from TB_ProblemSmallType where TypeNo=TB_ProblemRecord.SmallSort) as SmallType,"+ "(case Level when '0' then '忽略' when '1' then '一般' when '3' then '严重' when '4' then '特别严重' else '' end) as Level,"+ "(case IsIssue when '0' then '未发布' when '1' then '已发布' else '' end) as IsIssue,"+ "BigSort,SmallSort"+ " from TB_ProblemRecord where RecordNo=@RecordNo"; SqlCommand sqlCmd=new SqlCommand(sqlStr,sqlConn); sqlCmd.Parameters.Add("@RecordNo",SqlDbType.Char,10,"RecordNo"); sqlCmd.Parameters["@RecordNo"].Value=recordno; sqlConn.Open(); SqlDataReader sqlReader=sqlCmd.ExecuteReader(); sqlReader.Read();
this.txt_Detail.Text=sqlReader.GetString(0); this.txt_SettleWay.Text=sqlReader.GetString(2); if (sqlReader.IsDBNull(1)) { this.txt_Reason.Text=null;
protected void GetSelectedData()
{
try
{
DataSet ds=new DataSet();
string sqlStr;
SqlConnection sqlConn=new SqlConnection(Conn); sqlStr="select Detail,Reason,SettleWay,"+
"(select Name from TB_OperatorInfo where OperatorNo=TB_ProblemRecord.RecorderNo) as RecorderName,"+
"(select Name from TB_OperatorInfo where OperatorNo=TB_ProblemRecord.ManagerNo) as ManagerName,"+
"(case State when '0' then '未处理' when '1' then '已处理' else '' end) as State,"+
"(select TypeName from TB_ProblemBigType where TypeNo=TB_ProblemRecord.BigSort) as BigType,"+
"(select TypeName from TB_ProblemSmallType where TypeNo=TB_ProblemRecord.SmallSort) as SmallType,"+
"(case Level when '0' then '忽略' when '1' then '一般' when '3' then '严重' when '4' then '特别严重' else '' end) as Level,"+
"(case IsIssue when '0' then '未发布' when '1' then '已发布' else '' end) as IsIssue,"+
"BigSort,SmallSort"+
" from TB_ProblemRecord where RecordNo=@RecordNo"; SqlCommand sqlCmd=new SqlCommand(sqlStr,sqlConn);
sqlCmd.Parameters.Add("@RecordNo",SqlDbType.Char,10,"RecordNo");
sqlCmd.Parameters["@RecordNo"].Value=recordno; sqlConn.Open();
SqlDataReader sqlReader=sqlCmd.ExecuteReader();
sqlReader.Read();
this.txt_Detail.Text=sqlReader.GetString(0);
this.txt_SettleWay.Text=sqlReader.GetString(2); if (sqlReader.IsDBNull(1))
{
this.txt_Reason.Text=null;
}
else
{
this.txt_Reason.Text=sqlReader.GetString(1);
}
string recordername,managername,state,bigtype,smalltype,level,isissue;
int bigno,smallno; recordername=sqlReader.GetString(3);
managername=sqlReader.GetString(4);
state=sqlReader.GetString(5);
bigtype=sqlReader.GetString(6);
smalltype=sqlReader.GetString(7);
level=sqlReader.GetString(8);
isissue=sqlReader.GetString(9);
bigno=Int32.Parse(sqlReader["BigSort"].ToString().Trim());
smallno=Int32.Parse(sqlReader["SmallSort"].ToString().Trim()); bigtype=bigno.ToString()+"---"+bigtype;
smalltype=smallno.ToString()+"---"+smalltype;
(this.ddl_RecorderName.Items.FindByValue(recordername)).Selected = true;
(this.ddl_ManagerName.Items.FindByValue(managername)).Selected = true;
(this.ddl_State.Items.FindByValue(state)).Selected= true;//此处提示错误,但上面两个没有错误可执行,ddl_为dropdownlist
(this.ddl_BigType.Items.FindByValue(bigtype)).Selected = true;
(this.ddl_SmallType.Items.FindByValue(smalltype)).Selected = true;
(this.ddl_Level.Items.FindByValue(level)).Selected = true;
(this.ddl_IsIssue.Items.FindByValue(isissue)).Selected = true;
sqlReader.Close();
sqlConn.Close(); }
catch(Exception ex)
{
JavaClass.ShowMsg(this,ex.Message);
}
}
是否设置了value值?