using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;
using Microsoft.ApplicationBlocks.Data;namespace Report
{
    public partial class Repeat : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            this.Title = "维护反馈";
            Ddl_ReportID.AutoPostBack = true;
            if (!IsPostBack)
            {
                string ConnectionString = ConfigurationManager.ConnectionStrings["ReportConnectionString"].ConnectionString;
                SqlConnection conn = new SqlConnection(ConnectionString);
                SqlCommand cmd = new SqlCommand("Select * From Reports", conn);
                DataSet ds = new DataSet();
                SqlDataAdapter da = new SqlDataAdapter();
                da.SelectCommand = cmd;
                da.Fill(ds, "Reports");
                DataTable dt = ds.Tables["Reports"];
                DataRow dRow = dt.Rows[0];
                Lb_DateTime.Text = dRow["Datetime"].ToString().Trim();
                Lb_UserName.Text = dRow["UserName"].ToString().Trim();
                Lb_IP.Text = dRow["IP"].ToString().Trim();
                Lb_Fault.Text = dRow["Fault"].ToString().Trim();
                Lb_Telephone.Text = dRow["Telephone"].ToString().Trim();
                Tb_Content.Text = dRow["Content"].ToString().Trim();
                Tb_Repeat.Text = dRow["Repeat"].ToString().Trim();
                Rbl_F.SelectedValue = dRow["Mark"].ToString().Trim();
                conn.Close();
            }
        }        protected void Ddl_ReportID_SelectedIndexChanged(object sender, EventArgs e)
        {
            string ConnectionString = ConfigurationManager.ConnectionStrings["ReportConnectionString"].ConnectionString;
            SqlConnection conn = new SqlConnection(ConnectionString);
            SqlCommand cmd = new SqlCommand("SELECT * FROM [Report].[dbo].[Reports]", conn);
            conn.Open();
            DataSet ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = cmd;
            da.Fill(ds, "Reports");
            DataTable dt = ds.Tables["Reports"];
            int iname = Ddl_ReportID.SelectedIndex;
            DataRow dRow = dt.Rows[iname];
            Lb_DateTime.Text = dRow["Datetime"].ToString().Trim();
            Lb_UserName.Text = dRow["UserName"].ToString().Trim();
            Lb_IP.Text = dRow["IP"].ToString().Trim();
            Lb_Fault.Text = dRow["Fault"].ToString().Trim();
            Lb_Telephone.Text = dRow["Telephone"].ToString().Trim();
            Tb_Content.Text = dRow["Content"].ToString().Trim();
            Tb_Repeat.Text = dRow["Repeat"].ToString().Trim();
            Rbl_F.SelectedValue = dRow["Mark"].ToString().Trim();
            conn.Close();
        }        protected void Btn_Sub_Click(object sender, EventArgs e)
        {
            string ConnectionString = ConfigurationManager.ConnectionStrings["ReportConnectionString"].ConnectionString;
            SqlConnection conn = new SqlConnection(ConnectionString);
            SqlCommand cmd = new SqlCommand ("Select * From Reports",conn);
            DataSet ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter();
            conn.Open();
            string upData = "UPDATE [Report].[dbo].[Reports]  SET [Mark] = '" + Rbl_F.SelectedItem.Value.ToString().Trim() + "',[Repeat] = '" + Tb_Repeat.Text.Trim() + "' WHERE id =" + Ddl_ReportID.SelectedItem.Value.ToString().Trim() + "";
            da.SelectCommand = cmd;
            da.Fill(ds,"Reports");
            SqlCommand updataCmd = new SqlCommand(upData, conn);
            da.UpdateCommand = updataCmd;
            da.UpdateCommand.ExecuteNonQuery();
            conn.Close();
            Response.Write("<script language=javascript>alert('记录更新成功,请单击“返回”按钮回到主页面!');</script>");
        }
    }
}
本应该是Id 45的数据在程序里却显示为Id19的内容,我检查了一下没发现什么问题,为什么就错位了呢???