using System.Data.SqlClient;

public partial class studentinfoM : System.Web.UI.Page
{
//SqlConnection conn;
//SqlDataAdapter da;

protected void Page_Load(object sender, EventArgs e)
{
string str = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ms.mdf;Integrated Security=True;User Instance=True";
SqlConnection conn = new SqlConnection(str);
conn.Open();
SqlDataAdapter da = new SqlDataAdapter();
string SelectSql = "select * from student";
da.SelectCommand = new SqlCommand(SelectSql, conn);
DataSet ds = new DataSet();
da.Fill(ds);
conn.Close();
GridView1.DataSource = ds;
GridView1.DataBind();

}
protected void LinkButton1_Click(object sender, EventArgs e)
{
Response.Redirect("addstudent.aspx");
}
protected void Button2_Click(object sender, EventArgs e)
{
Response.Redirect("studentlist.aspx");
}

protected void Button1_Click1(object sender, EventArgs e)
{
string str = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ms.mdf;Integrated Security=True;User Instance=True";
SqlConnection conn = new SqlConnection(str);
conn.Open();
SqlDataAdapter da = new SqlDataAdapter();
string SelectSql = "";
switch (MySelect.SelectedIndex)
{
case 0:
SelectSql = "select * from student where classID like '%" + TextBox1.Text + "%'";
break;
case 1:
SelectSql = "select * from student where studentID like '%" + TextBox1.Text + "%'";
break;
case 2:
SelectSql = "select * from student where studentName like '%" + TextBox1.Text + "%'";
break;
}
da.SelectCommand = new SqlCommand(SelectSql, conn);
DataSet ds = new DataSet();
da.Fill(ds);
conn.Close();
GridView1.DataSource = ds; 图片说明
GridView1.DataBind();
}

Gaodl0106

SQL问题，急急急，大神帮帮忙！！！！！！

5条回答

为你推荐