default.aspx.cs

C#环境下

using System;
using System.Data;
using System.Configuration;
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 _Default : System.Web.UI.Page 
{
    string connsql1 = System.Configuration.ConfigurationManager.AppSettings["connstring"];
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = "server=szmt-37;database=shiyong;uid=sa;password=123456";
        conn.Open();
        String strQuerySQLna = "Select * from stu where ID=1";
        SqlCommand sqlCmd = new SqlCommand(strQuerySQLna, conn);
        SqlDataReader sqlReader = sqlCmd.ExecuteReader();
        while (sqlReader.Read())
        {
            TextBox1.Text = sqlReader["Stu_Name"].ToString();
        }

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection connections1 = new SqlConnection(connsql1);
        connections1.ConnectionString = "server=szmt-37;database=shiyong;uid=sa;password=123456";
        connections1.Open();
        string strsqlTQ = "insert into stu(Stu_Num,Stu_Name) values('" + DropDownList1.SelectedValue.ToString() + "','" + TextBox2.Text + "')";
        SqlCommand sqlcmd1 = new SqlCommand(strsqlTQ, connections1);
        int iResult = sqlcmd1.ExecuteNonQuery();
        if (iResult >= 1)
        {
            GridView1.DataBind();
        }
        else
        {
            Response.Write("<script language=javascript>alert('不成功');</script>");

        }
        connections1.Close();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        SqlConnection connections1 = new SqlConnection(connsql1);
        connections1.ConnectionString = "server=szmt-37;database=shiyong;uid=sa;password=123456";
        connections1.Open();
        String update = "update stu set password='" + TextBox3.Text + "' where Stu_Name='"+TextBox4.Text+"'and Stu_Num='"+TextBox5.Text+"'";
        SqlCommand sqlcmd1 = new SqlCommand(update, connections1);
        int iResult = sqlcmd1.ExecuteNonQuery();
        connections1.Close();
    }
}