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();
}