如何实现读出一条记录,显示出来,修改后保存到数据库?有源码吗?我弄了一天啦,老是出问题 如何实现读出一条记录,显示出来,修改后保存到数据库?有源码吗?我弄了一天啦,老是出问题 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 <%@ Register TagPrefix="ftb" Namespace="FreeTextBoxControls" Assembly="FreeTextBox"%><%@ Page language="c#" Codebehind="news_edit.aspx.cs" AutoEventWireup="false" Inherits="aspnetc.admin.news_edit" %><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" ><HTML> <HEAD> <title>news_edit</title><meta content="Microsoft Visual Studio .NET 7.1" name=GENERATOR><meta content=C# name=CODE_LANGUAGE><meta content=JavaScript name=vs_defaultClientScript><meta content=http://schemas.microsoft.com/intellisense/ie5 name=vs_targetSchema><LINK href="../style/adminCss.css" type=text/css rel=stylesheet > <!--<LINK href="../style/BasicLayout.css" type="text/css" rel="stylesheet">--><script language=JavaScript src="../style/meizzDate.js"></script><script language=javascript src="../Style/Script.js"></script></HEAD><body class=main><form id=Form1 method=post runat="server"><FONT face=宋体><TABLE class=mainBorder id=Table1> <TR> <TD> </TD> <TD class=Title>编 辑 新 闻</TD> <TD></TD></TR> <TR> <TD class=border colSpan=3></TD></TR> <TR> <TD>新闻类别</TD> <TD><asp:dropdownlist id=DDLNewsType runat="server" DataValueField="id" DataTextField="name" AutoPostBack="False"></asp:dropdownlist></TD> <TD></TD></TR> <TR> <TD class=border colSpan=3 <TD></TD> <TR> <TD>标题</TD> <TD><asp:textbox id=NewsTitle runat="server"></asp:textbox><asp:requiredfieldvalidator id=checkTitle ErrorMessage="*" ControlToValidate="NewsTitle" Runat="server"></asp:requiredfieldvalidator></TD> <TD></TD></TR> <TR> <TD class=border colSpan=3 <TD></TD> <TR> <TD>日期3</TD> <TD><asp:textbox id=newsDate onfocus=setday(this) Runat="server"></asp:textbox></TD> <TD></TD></TR> <TR> <TD class=border colSpan=3 <TD></TD> <TR> <TD>正文</TD> <TD> <table> <tr> <td><FTB:FREETEXTBOX id=FTBContent runat="server" AllowHtmlMode="True" ImageGalleryPath="UploadFiles/" HelperFilesParameters="HelperScripts/" HelperFilesPath="HelperScripts/" ButtonPath="images/ftb/office2003/" Text="该书暂时没有简介" Width="600px" Height="500px"></FTB:FREETEXTBOX></TD></TR></TABLE></TD> <TD></TD></TR> <TR> <TD class=border colSpan=3 <TD></TD> <TR> <TD> </TD> <TD><asp:button id=BtnSure runat="server" Text="保存"></asp:button> <asp:button id=BtnReset runat="server" Text="重置"></asp:button> <asp:button id=BtnGoBack runat="server" Text="返回"></asp:button></TD> <TD></TD></TR></TABLE></FONT></FORM> </body></HTML> using System;using System.Collections;using System.ComponentModel;using System.Data;using System.Data.SqlClient;using System.Drawing;using System.Web;using System.Web.SessionState;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.HtmlControls;//using aspnetc;//using aspnetc.pubFunction;namespace aspnetc.admin{ /// <summary> /// news_edit 的摘要说明。加入DropDownLoad /// </summary> public class news_edit : System.Web.UI.Page { protected System.Web.UI.WebControls.TextBox NewsTitle; protected System.Web.UI.WebControls.Button BtnSure; protected System.Web.UI.WebControls.Button BtnReset; protected System.Web.UI.WebControls.Button BtnGoBack; protected FreeTextBoxControls.FreeTextBox FTBContent; protected ClassConn connE=new ClassConn(); public SqlDataAdapter ada; public DataSet ds; protected System.Web.UI.WebControls.DropDownList DDLNewsType; protected System.Web.UI.WebControls.TextBox newsDate; protected System.Web.UI.WebControls.RequiredFieldValidator checkTitle; public DataRow dr; private void Page_Load(object sender, System.EventArgs e) { // 在此处放置用户代码以初始化页面 if (!IsPostBack) { //若为修改则初始化内容 string nNewsID,strSql; nNewsID=Request.QueryString["nNewsID"]; newsDate.Text=System.DateTime.Now.ToShortDateString(); this.DDLNewsType.DataSource=connE.GetDs("select * from newsType"); this.DDLNewsType.DataBind(); //nNewsID=""; if(nNewsID!=null) //若为修改则初始化 { strSql="select * from news where news_id="+nNewsID; ds=connE.GetDs(strSql); dr=ds.Tables[0].Rows[0]; NewsTitle.Text=dr["news_title"].ToString(); newsDate.Text=((DateTime)(dr["news_date"])).ToShortDateString().ToString(); FTBContent.Text=dr["news_content"].ToString(); DDLNewsType.SelectedValue=dr["news_type"].ToString(); } //客户端数据验证 BtnSure.Attributes.Add("onclick","Javascript:return vdf('NewsTitle','请输入标题','r','newsDate','请输入日期类型','r_date');"); } } #region Web 窗体设计器生成的代码 override protected void OnInit(EventArgs e) { // // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。 // InitializeComponent(); base.OnInit(e); } /// <summary> /// 设计器支持所需的方法 - 不要使用代码编辑器修改 /// 此方法的内容。 /// </summary> private void InitializeComponent() { this.BtnSure.Click += new System.EventHandler(this.BtnSure_Click); this.BtnGoBack.Click += new System.EventHandler(this.BtnGoBack_Click); this.Load += new System.EventHandler(this.Page_Load); } #endregion //保存 private void BtnSure_Click(object sender, System.EventArgs e) { //判断输入是否正确 //保存数据 string newsTitle,newsDate,newsContent,strSql,nNewsID,newsType; newsTitle=this.NewsTitle.Text.ToString(); newsDate=this.newsDate.Text.ToString(); newsType=this.DDLNewsType.SelectedValue; newsContent=this.FTBContent.Text.ToString(); nNewsID=Request.QueryString["nNewsID"]; if (nNewsID==null) //增加记录 { //生成序号 nNewsID=connE.GetMaxIDRead("news_id","news").ToString(); //nNewsID="740108"; strSql="select top 1 * from news order by news_Id desc "; //Response.Write("sql:"+strSql); //Response.Write ("<br>"+Server.HtmlEncode(newsContent)); try { connE.Builder(strSql); connE.dr["news_id"]=nNewsID; connE.dr["news_title"]=newsTitle; connE.dr["news_type"]=newsType; connE.dr["news_date"]=newsDate; connE.dr["news_Content"]=newsContent; connE.BuilderClose(); } catch(SqlException Ex) { Response.Write("<br>err:"+Ex.Message.ToString()); Response.End(); }// //生成序号// nNewsID=connE.GetMaxIDRead("news_id","news").ToString();// strSql="select * from news";// try// {// connE.TransBuilder(strSql);// connE.dr["news_id"]=nNewsID;// connE.dr["news_title"]=newsTitle;// connE.dr["news_type"]=newsType;// connE.dr["news_date"]=newsDate;// connE.dr["news_Content"]=newsContent;// connE.TransBuilderClose();// }// catch (SqlException Ex)// {// connE.TransRollback();// Response.Write("操作失败!");// Response.End();// } } else ///更新记录 { strSql="select * from news where news_id="+nNewsID; try { connE.BuilderEdit(strSql); connE.dr["news_id"]=nNewsID; connE.dr["news_title"]=newsTitle; connE.dr["news_type"]=newsType; connE.dr["news_date"]=newsDate; connE.dr["news_content"]=newsContent; connE.BuilderEditClose(); } catch(SqlException Ex) { Response.Write("<br>Err:"+Ex.Message.ToString()); Response.End(); }// //加入事务// strSql="select * from news where news_id="+nNewsID;// try// {// connE.TransEditBuilder(strSql);// connE.dr["news_id"]=nNewsID;// connE.dr["news_title"]=newsTitle;// connE.dr["news_type"]=newsType;// connE.dr["news_date"]=newsDate;// connE.dr["news_content"]=newsContent;// connE.TransEditBuilderClose();// }// catch(SqlException Ex)// { // connE.TransRollback();// Response.Write(Ex.ToString());// Response.Write("操作失败!");// Response.End();// } } Response.Redirect("news_manage.aspx"); } //返回 private void BtnGoBack_Click(object sender, System.EventArgs e) { Response.Redirect("news_manage.aspx"); } }} 感谢adandelion(猪头),错误见http://community.csdn.net/Expert/topic/4215/4215807.xml?temp=.5120813 最好是不用FREETEXTBOX的,简单点的就可以 using System;using System.Collections;using System.ComponentModel;using System.Data;using System.Data.SqlClient;using System.Drawing;using System.Web;using System.Web.SessionState;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.HtmlControls;namespace baozang{ /// <summary> /// paimaihui_edit 的摘要说明。 /// </summary> public class paimaihui_edit : System.Web.UI.Page { protected System.Web.UI.WebControls.TextBox txtName; protected System.Web.UI.WebControls.TextBox txtAddress; protected System.Web.UI.WebControls.TextBox txtTel; protected System.Web.UI.WebControls.TextBox txtYuzhanAddress; protected System.Web.UI.WebControls.TextBox txtYuzhanTime; protected System.Web.UI.WebControls.TextBox txtContent; protected System.Web.UI.WebControls.Button btnSure; protected System.Web.UI.WebControls.TextBox txtDateEnd; protected System.Web.UI.WebControls.TextBox txtDateStart; protected System.Web.UI.WebControls.DropDownList ddlCom; protected System.Web.UI.WebControls.TextBox txtTime; protected System.Web.UI.WebControls.Button btnGoBack; //数据访问类的实例 protected classConn connE = new classConn(); protected DataSet ds; protected System.Web.UI.WebControls.RequiredFieldValidator checkTitle; protected DataRow dr; private void Page_Load(object sender, System.EventArgs e) { // 在此处放置用户代码以初始化页面 if (!IsPostBack) { string id;//拍卖会ID id=Request.QueryString["id"]; //id="2"; //初始化发起公司信息 ds=connE.getDs("select * from paimaiCom"); ddlCom.DataSource=ds; ddlCom.DataBind(); ds.Clear(); //this.ddlCom.DataSource=connE.getDs("select * from paimaiCom"); //this.ddlCom.DataBind(); txtTime.Text=System.DateTime.Now.ToShortDateString(); txtYuzhanTime.Text=System.DateTime.Now.ToShortDateString(); txtDateStart.Text=System.DateTime.Now.ToShortDateString(); txtDateEnd.Text=System.DateTime.Now.ToShortDateString(); //Response.End(); //初始化拍卖会信息 if (id!=null) {// string strSql="select * from paimaihui where hui_id="+id;// Response.Write(strSql+"<br>");// ds=connE.getDs(strSql);// dr=ds.Tables[0].Rows[0]; string strSql="select * from paimaihui where hui_id="+id; //DataSet ds = new DataSet(); ds = connE.getDs(strSql); dr = ds.Tables[0].Rows[0]; txtName.Text=dr["hui_name"].ToString(); //Response.Write(dr["hui_name"].ToString()+"<br>"); txtAddress.Text=dr["hui_address"].ToString(); ddlCom.SelectedValue=dr["hui_com"].ToString(); //Response.Write(dr["hui_com"].ToString()); //Response.End(); txtTel.Text=dr["hui_tel"].ToString(); txtTime.Text=dr["hui_date"].ToString(); txtYuzhanTime.Text=dr["hui_yuzhan_date"].ToString(); txtYuzhanAddress.Text=dr["hui_yuzhan_address"].ToString(); txtContent.Text=dr["hui_content"].ToString(); txtDateStart.Text=dr["hui_date_start"].ToString(); txtDateEnd.Text=dr["hui_date_end"].ToString(); } } } #region Web 窗体设计器生成的代码 override protected void OnInit(EventArgs e) { // // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。 // InitializeComponent(); base.OnInit(e); } /// <summary> /// 设计器支持所需的方法 - 不要使用代码编辑器修改 /// 此方法的内容。 /// </summary> private void InitializeComponent() { this.btnSure.Click += new System.EventHandler(this.btnSure_Click); this.btnGoBack.Click += new System.EventHandler(this.btnGoBack_Click); this.Load += new System.EventHandler(this.Page_Load); } #endregion /// <summary> /// 保存拍卖会信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSure_Click(object sender, System.EventArgs e) { Page.Validate(); if (IsValid) { string strId,strSql; int nMaxid; strId=Request.QueryString["id"]; if (strId==null || strId==string.Empty) //增加记录 { try { nMaxid=connE.getMaxId("hui_id","paimaihui");//获得新的ID nMaxid=nMaxid; strSql="select top 1 * from paimaihui"; connE.builder(strSql); connE.dr["hui_id"]=nMaxid; connE.dr["hui_name"]=txtName.Text; connE.dr["hui_com"]=ddlCom.SelectedValue; connE.dr["hui_address"]=txtAddress.Text; connE.dr["hui_date"]=txtTime.Text; connE.dr["hui_tel"]=txtTel.Text; connE.dr["hui_yuzhan_date"]=txtYuzhanTime.Text; connE.dr["hui_yuzhan_address"]=txtYuzhanAddress.Text; connE.dr["hui_content"]=txtContent.Text; connE.dr["hui_date_start"]=txtDateStart.Text; connE.dr["hui_date_end"]=txtDateEnd.Text; connE.builderClose(); } catch(SqlException Ex1) { Response.Write("<br>add error:"+Ex1.ToString()); Response.End(); } finally { //Response.Write("<br>add ok!"); //Response.End(); } } else //修改记录。 { strSql="select * from paimaihui where hui_id="+strId; try { connE.builderEdit(strSql); //connE.dr["hui_id"]=nMaxid; connE.dr["hui_name"]=txtName.Text; connE.dr["hui_com"]=ddlCom.SelectedValue; connE.dr["hui_address"]=txtAddress.Text; connE.dr["hui_date"]=txtTime.Text; connE.dr["hui_tel"]=txtTel.Text; connE.dr["hui_yuzhan_date"]=txtYuzhanTime.Text; connE.dr["hui_yuzhan_address"]=txtYuzhanAddress.Text; connE.dr["hui_content"]=txtContent.Text; connE.dr["hui_date_start"]=txtDateStart.Text; connE.dr["hui_date_end"]=txtDateEnd.Text; connE.builderEditClose(); } catch(SqlException Ex) { Response.Write("<br>Err:"+Ex.Message.ToString()); Response.End(); } } Response.Redirect("paimaihui_manage.aspx"); } } private void btnGoBack_Click(object sender, System.EventArgs e) { Response.Redirect("paimaihui_manage.aspx"); } }} 不要急,慢慢来,那有一开始就会的:)楼主可以找个例子看看嘛,现在asp.net源码也很多嘛~~~~有些书的例子有源代码的,找一找. 自从装了SQL2005 ,,,VS2005每次打开项目都出现这种问题 gridview单击选中行问题 怎么获取不带参数的Url呢? VS2005 自带的Crystal Report 有使用次数的规定吗? 腾讯rtx 二次开发 发消息????---------急 正在尝试用C#写windows应用程序出错了 请教个关于数据绑定的问题 很急的需求!!!!! 文件不能使用 不知道怎么回事.小弟初学请各位提点 IIS服务无法启动,急等高手解答 几道面试题 asp.net一定要用到.xml吗?
<%@ Page language="c#" Codebehind="news_edit.aspx.cs" AutoEventWireup="false" Inherits="aspnetc.admin.news_edit" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>news_edit</title>
<meta content="Microsoft Visual Studio .NET 7.1" name=GENERATOR>
<meta content=C# name=CODE_LANGUAGE>
<meta content=JavaScript name=vs_defaultClientScript>
<meta content=http://schemas.microsoft.com/intellisense/ie5 name=vs_targetSchema><LINK href="../style/adminCss.css" type=text/css rel=stylesheet >
<!--<LINK href="../style/BasicLayout.css" type="text/css" rel="stylesheet">-->
<script language=JavaScript src="../style/meizzDate.js"></script><script language=javascript src="../Style/Script.js"></script>
</HEAD>
<body class=main>
<form id=Form1 method=post runat="server"><FONT face=宋体>
<TABLE class=mainBorder id=Table1>
<TR>
<TD> </TD>
<TD class=Title>编 辑 新 闻</TD>
<TD></TD></TR>
<TR>
<TD class=border colSpan=3></TD></TR>
<TR>
<TD>新闻类别</TD>
<TD><asp:dropdownlist id=DDLNewsType runat="server" DataValueField="id" DataTextField="name" AutoPostBack="False"></asp:dropdownlist></TD>
<TD></TD></TR>
<TR>
<TD class=border colSpan=3 <TD></TD>
<TR>
<TD>标题</TD>
<TD><asp:textbox id=NewsTitle runat="server"></asp:textbox><asp:requiredfieldvalidator id=checkTitle ErrorMessage="*" ControlToValidate="NewsTitle" Runat="server"></asp:requiredfieldvalidator></TD>
<TD></TD></TR>
<TR>
<TD class=border colSpan=3 <TD></TD>
<TR>
<TD>日期3</TD>
<TD><asp:textbox id=newsDate onfocus=setday(this) Runat="server"></asp:textbox></TD>
<TD></TD></TR>
<TR>
<TD class=border colSpan=3 <TD></TD>
<TR>
<TD>正文</TD>
<TD>
<table>
<tr>
<td><FTB:FREETEXTBOX id=FTBContent
runat="server" AllowHtmlMode="True"
ImageGalleryPath="UploadFiles/"
HelperFilesParameters="HelperScripts/"
HelperFilesPath="HelperScripts/" ButtonPath="images/ftb/office2003/"
Text="该书暂时没有简介" Width="600px"
Height="500px"></FTB:FREETEXTBOX></TD></TR></TABLE></TD>
<TD></TD></TR>
<TR>
<TD class=border colSpan=3 <TD></TD>
<TR>
<TD> </TD>
<TD><asp:button id=BtnSure runat="server" Text="保存"></asp:button>
<asp:button id=BtnReset runat="server" Text="重置"></asp:button>
<asp:button id=BtnGoBack runat="server" Text="返回"></asp:button></TD>
<TD></TD></TR></TABLE></FONT></FORM>
</body>
</HTML>
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
//using aspnetc;
//using aspnetc.pubFunction;
namespace aspnetc.admin
{
/// <summary>
/// news_edit 的摘要说明。加入DropDownLoad
/// </summary>
public class news_edit : System.Web.UI.Page
{
protected System.Web.UI.WebControls.TextBox NewsTitle;
protected System.Web.UI.WebControls.Button BtnSure;
protected System.Web.UI.WebControls.Button BtnReset;
protected System.Web.UI.WebControls.Button BtnGoBack; protected FreeTextBoxControls.FreeTextBox FTBContent; protected ClassConn connE=new ClassConn();
public SqlDataAdapter ada;
public DataSet ds;
protected System.Web.UI.WebControls.DropDownList DDLNewsType;
protected System.Web.UI.WebControls.TextBox newsDate;
protected System.Web.UI.WebControls.RequiredFieldValidator checkTitle;
public DataRow dr; private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if (!IsPostBack)
{
//若为修改则初始化内容
string nNewsID,strSql;
nNewsID=Request.QueryString["nNewsID"];
newsDate.Text=System.DateTime.Now.ToShortDateString();
this.DDLNewsType.DataSource=connE.GetDs("select * from newsType");
this.DDLNewsType.DataBind();
//nNewsID="";
if(nNewsID!=null) //若为修改则初始化
{
strSql="select * from news where news_id="+nNewsID;
ds=connE.GetDs(strSql);
dr=ds.Tables[0].Rows[0];
NewsTitle.Text=dr["news_title"].ToString();
newsDate.Text=((DateTime)(dr["news_date"])).ToShortDateString().ToString();
FTBContent.Text=dr["news_content"].ToString();
DDLNewsType.SelectedValue=dr["news_type"].ToString();
}
//客户端数据验证
BtnSure.Attributes.Add("onclick","Javascript:return vdf('NewsTitle','请输入标题','r','newsDate','请输入日期类型','r_date');"); }
} #region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.BtnSure.Click += new System.EventHandler(this.BtnSure_Click);
this.BtnGoBack.Click += new System.EventHandler(this.BtnGoBack_Click);
this.Load += new System.EventHandler(this.Page_Load); }
#endregion
//保存
private void BtnSure_Click(object sender, System.EventArgs e)
{
//判断输入是否正确 //保存数据
string newsTitle,newsDate,newsContent,strSql,nNewsID,newsType;
newsTitle=this.NewsTitle.Text.ToString();
newsDate=this.newsDate.Text.ToString();
newsType=this.DDLNewsType.SelectedValue; newsContent=this.FTBContent.Text.ToString(); nNewsID=Request.QueryString["nNewsID"];
if (nNewsID==null) //增加记录
{
//生成序号
nNewsID=connE.GetMaxIDRead("news_id","news").ToString();
//nNewsID="740108";
strSql="select top 1 * from news order by news_Id desc ";
//Response.Write("sql:"+strSql);
//Response.Write ("<br>"+Server.HtmlEncode(newsContent));
try
{
connE.Builder(strSql);
connE.dr["news_id"]=nNewsID;
connE.dr["news_title"]=newsTitle;
connE.dr["news_type"]=newsType;
connE.dr["news_date"]=newsDate;
connE.dr["news_Content"]=newsContent;
connE.BuilderClose();
}
catch(SqlException Ex)
{
Response.Write("<br>err:"+Ex.Message.ToString());
Response.End();
}
// //生成序号
// nNewsID=connE.GetMaxIDRead("news_id","news").ToString();
// strSql="select * from news";
// try
// {
// connE.TransBuilder(strSql);
// connE.dr["news_id"]=nNewsID;
// connE.dr["news_title"]=newsTitle;
// connE.dr["news_type"]=newsType;
// connE.dr["news_date"]=newsDate;
// connE.dr["news_Content"]=newsContent;
// connE.TransBuilderClose();
// }
// catch (SqlException Ex)
// {
// connE.TransRollback();
// Response.Write("操作失败!");
// Response.End();
// }
}
else ///更新记录
{
strSql="select * from news where news_id="+nNewsID;
try
{
connE.BuilderEdit(strSql);
connE.dr["news_id"]=nNewsID;
connE.dr["news_title"]=newsTitle;
connE.dr["news_type"]=newsType;
connE.dr["news_date"]=newsDate;
connE.dr["news_content"]=newsContent;
connE.BuilderEditClose();
}
catch(SqlException Ex)
{
Response.Write("<br>Err:"+Ex.Message.ToString());
Response.End();
}
// //加入事务
// strSql="select * from news where news_id="+nNewsID;
// try
// {
// connE.TransEditBuilder(strSql);
// connE.dr["news_id"]=nNewsID;
// connE.dr["news_title"]=newsTitle;
// connE.dr["news_type"]=newsType;
// connE.dr["news_date"]=newsDate;
// connE.dr["news_content"]=newsContent;
// connE.TransEditBuilderClose();
// }
// catch(SqlException Ex)
// {
// connE.TransRollback();
// Response.Write(Ex.ToString());
// Response.Write("操作失败!");
// Response.End();
// }
}
Response.Redirect("news_manage.aspx");
} //返回
private void BtnGoBack_Click(object sender, System.EventArgs e)
{
Response.Redirect("news_manage.aspx");
}
}
}
http://community.csdn.net/Expert/topic/4215/4215807.xml?temp=.5120813
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace baozang
{
/// <summary>
/// paimaihui_edit 的摘要说明。
/// </summary>
public class paimaihui_edit : System.Web.UI.Page
{
protected System.Web.UI.WebControls.TextBox txtName;
protected System.Web.UI.WebControls.TextBox txtAddress;
protected System.Web.UI.WebControls.TextBox txtTel;
protected System.Web.UI.WebControls.TextBox txtYuzhanAddress;
protected System.Web.UI.WebControls.TextBox txtYuzhanTime;
protected System.Web.UI.WebControls.TextBox txtContent;
protected System.Web.UI.WebControls.Button btnSure;
protected System.Web.UI.WebControls.TextBox txtDateEnd;
protected System.Web.UI.WebControls.TextBox txtDateStart;
protected System.Web.UI.WebControls.DropDownList ddlCom;
protected System.Web.UI.WebControls.TextBox txtTime;
protected System.Web.UI.WebControls.Button btnGoBack; //数据访问类的实例
protected classConn connE = new classConn();
protected DataSet ds;
protected System.Web.UI.WebControls.RequiredFieldValidator checkTitle;
protected DataRow dr; private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if (!IsPostBack)
{
string id;//拍卖会ID
id=Request.QueryString["id"];
//id="2";
//初始化发起公司信息
ds=connE.getDs("select * from paimaiCom");
ddlCom.DataSource=ds;
ddlCom.DataBind();
ds.Clear();
//this.ddlCom.DataSource=connE.getDs("select * from paimaiCom");
//this.ddlCom.DataBind();
txtTime.Text=System.DateTime.Now.ToShortDateString();
txtYuzhanTime.Text=System.DateTime.Now.ToShortDateString();
txtDateStart.Text=System.DateTime.Now.ToShortDateString();
txtDateEnd.Text=System.DateTime.Now.ToShortDateString();
//Response.End(); //初始化拍卖会信息
if (id!=null)
{
// string strSql="select * from paimaihui where hui_id="+id;
// Response.Write(strSql+"<br>");
// ds=connE.getDs(strSql);
// dr=ds.Tables[0].Rows[0];
string strSql="select * from paimaihui where hui_id="+id;
//DataSet ds = new DataSet();
ds = connE.getDs(strSql);
dr = ds.Tables[0].Rows[0];
txtName.Text=dr["hui_name"].ToString();
//Response.Write(dr["hui_name"].ToString()+"<br>");
txtAddress.Text=dr["hui_address"].ToString();
ddlCom.SelectedValue=dr["hui_com"].ToString();
//Response.Write(dr["hui_com"].ToString());
//Response.End();
txtTel.Text=dr["hui_tel"].ToString();
txtTime.Text=dr["hui_date"].ToString();
txtYuzhanTime.Text=dr["hui_yuzhan_date"].ToString();
txtYuzhanAddress.Text=dr["hui_yuzhan_address"].ToString();
txtContent.Text=dr["hui_content"].ToString();
txtDateStart.Text=dr["hui_date_start"].ToString();
txtDateEnd.Text=dr["hui_date_end"].ToString();
}
}
} #region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.btnSure.Click += new System.EventHandler(this.btnSure_Click);
this.btnGoBack.Click += new System.EventHandler(this.btnGoBack_Click);
this.Load += new System.EventHandler(this.Page_Load); }
#endregion /// <summary>
/// 保存拍卖会信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSure_Click(object sender, System.EventArgs e)
{
Page.Validate();
if (IsValid)
{
string strId,strSql;
int nMaxid;
strId=Request.QueryString["id"];
if (strId==null || strId==string.Empty) //增加记录
{
try
{
nMaxid=connE.getMaxId("hui_id","paimaihui");//获得新的ID
nMaxid=nMaxid;
strSql="select top 1 * from paimaihui";
connE.builder(strSql);
connE.dr["hui_id"]=nMaxid;
connE.dr["hui_name"]=txtName.Text;
connE.dr["hui_com"]=ddlCom.SelectedValue;
connE.dr["hui_address"]=txtAddress.Text;
connE.dr["hui_date"]=txtTime.Text;
connE.dr["hui_tel"]=txtTel.Text;
connE.dr["hui_yuzhan_date"]=txtYuzhanTime.Text;
connE.dr["hui_yuzhan_address"]=txtYuzhanAddress.Text;
connE.dr["hui_content"]=txtContent.Text;
connE.dr["hui_date_start"]=txtDateStart.Text;
connE.dr["hui_date_end"]=txtDateEnd.Text;
connE.builderClose();
}
catch(SqlException Ex1)
{
Response.Write("<br>add error:"+Ex1.ToString());
Response.End();
}
finally
{
//Response.Write("<br>add ok!");
//Response.End();
}
}
else //修改记录。
{
strSql="select * from paimaihui where hui_id="+strId;
try
{
connE.builderEdit(strSql);
//connE.dr["hui_id"]=nMaxid;
connE.dr["hui_name"]=txtName.Text;
connE.dr["hui_com"]=ddlCom.SelectedValue;
connE.dr["hui_address"]=txtAddress.Text;
connE.dr["hui_date"]=txtTime.Text;
connE.dr["hui_tel"]=txtTel.Text;
connE.dr["hui_yuzhan_date"]=txtYuzhanTime.Text;
connE.dr["hui_yuzhan_address"]=txtYuzhanAddress.Text;
connE.dr["hui_content"]=txtContent.Text;
connE.dr["hui_date_start"]=txtDateStart.Text;
connE.dr["hui_date_end"]=txtDateEnd.Text;
connE.builderEditClose();
}
catch(SqlException Ex)
{
Response.Write("<br>Err:"+Ex.Message.ToString());
Response.End();
} } Response.Redirect("paimaihui_manage.aspx");
}
} private void btnGoBack_Click(object sender, System.EventArgs e)
{
Response.Redirect("paimaihui_manage.aspx");
}
}
}
楼主可以找个例子看看嘛,现在asp.net源码也很多嘛~~~~
有些书的例子有源代码的,找一找.