📄 default.aspx.cs
字号:
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.Xml;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
string strCon = "Data Source=(local);Database=mrdb;Uid=sa;Pwd=";
SqlConnection sqlcon;
sqlcon = new SqlConnection(strCon);
string sqlstr = "select * from tb_EmPloyee0";
SqlDataAdapter myda = new SqlDataAdapter(sqlstr, strCon);
DataSet myds = new DataSet();
sqlcon.Open();
myda.Fill(myds);
sqlcon.Close();
myds.WriteXml(Server.MapPath("test.xml"));
Button2.Enabled = true;
}
protected void Button2_Click(object sender, EventArgs e)
{
DataSet myds = new DataSet();
myds.ReadXml(Server.MapPath("test.xml"));
GridView1.DataSource = myds;
GridView1.DataBind();
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -