62,072
社区成员
发帖
与我相关
我的任务
分享
protected void btnSave_Click(object sender, EventArgs e)
{
//修改服务器信息
string id = Request.QueryString["id"].ToString();
string strServerName = txtName.Text.Trim();
//取界面要改的控件的值
string strSql = "语句";
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["连接字符串"]);
conn.Open();
SqlCommand cmd = new SqlCommand(strSql , conn);
try
{
cmd.ExecuteNonQuery();
conn.Close();
}
catch (System.Exception e) {
conn.Close();
return false;
} }
}
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if (!IsPostBack)
{
string strId = Request.QueryString["id"].ToString();
string strSql = "select * from 表 where id='" +strId+ "'";
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["连接字符串"]);
conn.Open();
SqlDataAdapter dbAdapter = new SqlDataAdapter(strSql , conn);
DataSet ds = new DataSet();
dbAdapter.Fill(ds, 表名);
DataTable dt = ds.Table["表名"].DefultView;
foreach (DataRow dr in dt.Rows)
{
界面上的控件 = dr["要改的数据库的字段"].ToString();
}
}
}
<asp:Repeater ID="rptSearch" runat="server" OnItemCommand="rptSearch_ItemCommand">
<ItemTemplate>
<asp:LinkButton ID="lbtSaveMusic" CommandName="edit" runat="server" CommandArgument='<%#DataBinder.Eval(Container.DataItem,"ID")%>'>修改 </asp:LinkButton>
</ItemTemplate>
</asp:Repeater>
protected void rptSearch_ItemCommand(object source, RepeaterCommandEventArgs e)
{
string strID=string.Empty;
if ("edit".Equals(e.CommandName))
{
strID= (Convert.ToInt32(e.CommandArgument)).ToString();
//都得到主键了就update表吧,下面的我不写了
}