副本 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;
using System.IO;

public partial class _Default : System.Web.UI.Page 
{
    SqlData shishi = new SqlData();
    protected void Page_Load(object sender, EventArgs e)
    {
        RandomCs rn = new RandomCs();
        String name = shishi.ReturnOnesValue("Select * from stu where ID=1", "Stu_Name");//不加“where ID=1”则选出所有内容中间不分开
        String num = shishi.ReturnOnesValue("Select * from stu where ID=1", "Stu_Num");
        String pass = shishi.ReturnOnesValue("Select * from stu where ID=1", "password");
        lblName.Text = name;
        lblSuiji.Text = rn.RandomNum(4);
        lblNum.Text = num;
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        String insert = shishi.InsertValue("insert into stu(Stu_Name,Stu_Num) values('" + txtInName.Text + "','" + txtInNum.Text + "')");
        GridView1.DataBind();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        String update = shishi.UpdateValue("update stu set password='" + txtPass.Text + "' where Stu_Name='"+lblName.Text+"'and Stu_Num='"+lblNum.Text+"'");
        GridView1.DataBind();
    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        //以txt形式写入到指定路径的文件夹下
        string text = TextBox1.Text.ToString();//定义字符串变量text ，来读取TextBox1的内容
        string sss = TextBox3.Text.ToString() + ".txt";//".txt"也可以是“.doc”或者是其他的后缀       

        sss = "e:\\sqlCSLJ\\testTxt\\" + sss; //指定保存的路径，路径名为sss 
        //新建文件 （.append 是追加写 ）
        FileStream fst = new FileStream(sss,FileMode.Append); 
        //写数据到a.txt格式 
        StreamWriter swt = new StreamWriter(fst,System.Text.Encoding.GetEncoding("utf-8")); 
        //写入 
        swt.WriteLine(text); //将text的内容写入到sss文件里
        swt.Close(); 
        fst.Close();

    }
    protected void btnRead_Click(object sender, EventArgs e)
    {
        //读取文件
        string ss =TextBox2.Text.ToString()+".txt";//指定路径名
        ss = "e:\\sqlCSLJ\\testTxt\\" + ss; 
        try 
        { 
            StreamReader srt = new StreamReader(ss,Convert.ToBoolean(FileMode.Open)); 
            //存在 文件，则读出内容
            TextBox4.Text = srt.ReadToEnd();
            srt.Close(); 
        } 
        catch(FileNotFoundException ee) 
        { 
            TextBox4.Text = "未找到指定文件，请检查文件名！"; 
        } 

    }
}