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的内容,我检查了一下没发现什么问题,为什么就错位了呢???
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的内容,我检查了一下没发现什么问题,为什么就错位了呢???
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货