我的VS2008通讯录项目源码 · 用户讨论与问答

我模仿了一下http://www.51aspx.com/CV/MyPhoneBook/#bbs 这个通讯录源码碰见了一个问题 我的代码如下： 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>"); } } } 复制代码 修改成功了 ，但是为什么本应该是 ID45的数据却显示在了ID19上面，请大家帮忙看看，万分感激！！

顶顶顶顶顶顶顶