所有成绩查询.aspx.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace WebApplication9
{
    public partial class 所有成绩查询 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            try
            {
                string Sno = TextBox1.Text.Trim();

                Dao Sqltest = new Dao();

                if (Sno.Equals(""))
                {
                    Response.Write("<script>alert('请输入学号!');</script>");
                }
                else
                {
                    string res = "select * from SC where Sno='" + Sno + "'";
                    SqlConnection con = new SqlConnection("Data Source=MLZ-DELL007;Initial Catalog=School;Integrated Security=True;");
                    con.Open();
                    SqlDataAdapter sdap = new SqlDataAdapter(res, con);
                    DataSet ds = new DataSet();
                    sdap.Fill(ds, "table");
                    GridView1.DataSource = ds.Tables[0];
                    GridView1.DataBind();
                }





            }
            catch
            {
                Response.Write("<script>alert('查询语句有误，请认真检查SQL语句!');</script>");

            }
            finally
            {

            }
        }
    }
}