新手测试题目的change.aspx与change.cs的内容。

最新推荐文章于 2024-07-19 21:48:59 发布

gelasis

最新推荐文章于 2024-07-19 21:48:59 发布

阅读量274

点赞数

分类专栏：项目源码文章标签：测试 button textbox radiobutton server asp

本文链接：https://blog.csdn.net/gelasis/article/details/6550606

版权

项目源码专栏收录该内容

6 篇文章 0 订阅

订阅专栏

change.aspx的内容：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="change.aspx.cs" Inherits="change" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

change.cs的内容：

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class change : System.Web.UI.Page
{

    string username;
    int userID;
    string Staus;
    protected void Page_Load(object sender, EventArgs e)
    {
        username = Request.QueryString["username"];
        userID = Convert.ToInt32(username);
        if (!IsPostBack)
        {
            Boolean mystring;
            SqlConnection nowcon = DB.createCon();
            SqlCommand nowcmd = new SqlCommand();
            nowcmd.Connection = nowcon;
            nowcmd.CommandText = " Select * from Prjinfo WHERE ID='" + userID + "'";
            SqlDataAdapter sda = new SqlDataAdapter();
            sda.SelectCommand = nowcmd;
            DataSet ds = new DataSet();
            sda.Fill(ds, "Prjinfo");
            changeName.Text = ds.Tables["Prjinfo"].Rows[0].ItemArray[1].ToString();
            changecustomer.Text = ds.Tables["Prjinfo"].Rows[0].ItemArray[2].ToString();
            changeDate.Text = ds.Tables["Prjinfo"].Rows[0].ItemArray[4].ToString();
             mystring= Convert.ToBoolean(ds.Tables["Prjinfo"].Rows[0].ItemArray[3].ToString());
            changeRemark.Text = ds.Tables["Prjinfo"].Rows[0].ItemArray[5].ToString();
            if (mystring)
            {
                changestaus.Checked = true;
            }
            else
            {
                changestaus2.Checked = true;
            }

}

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
            ///string Staus;
            string ProjName = this.changeName.Text;
            string Customer = this.changecustomer.Text;
            string CompleteDate = this.changeDate.Text;
            string Remark = this.changeRemark.Text;

            if (this.changestaus.Checked == true)
            {
                Staus = "true";

            }
            else
            {
                Staus = "false";
            }

            SqlConnection conn = DB.createCon();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = "Update Prjinfo Set ProjName='" + ProjName + "',Staus='" + Staus + "',Customer='" + Customer + "',CompleteDate='" + CompleteDate + "',Remark='" + Remark + "' WHERE ID='" + userID + "'";
            if (cmd.ExecuteNonQuery() > 0)
            {
                Response.Write("<script>alert('修改成功！');location.href='default.aspx';</script>");
            }
            else
            {
                Response.Write("<script>alert('修改失败！');window.location = window.location;</script>");
            }

    }

    protected void Button2_Click(object sender, EventArgs e)
    {
        this.changeName.Text = "";
        this.changecustomer.Text = "";
        this.changeRemark.Text = "";
        this.changeDate.Text = "";

    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        Response.Write("<script>location.href='default.aspx';</script>");
    }
}

gelasis

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
新手测试题目的change.aspx与change.cs的内容。

change.aspx的内容： http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">http://www.w3.org/1999/xhtml" > 修改记录 text-align: center">
复制链接

扫一扫