protected void btnView_Click(object sender, EventArgs e)
{
switch (rbnPapersetter.SelectedItem.Value)
{
case "Code":
SqlCommand cmd = new SqlCommand("select Code,Name,SCode,Course,Session from PaperSetter where Code='" + txtSearch.Text.ToString() + "'", con);
DataSet ds = new DataSet();
con.Open();
SqlDataAdapter dap = new SqlDataAdapter(cmd);
dap.Fill(ds, "PaperSetter");
GridpaperView.DataSource = ds;
GridpaperView.DataBind();
break;
case "Name":
SqlCommand cmd1 = new SqlCommand("select Code,Name,SCode,Course,Session from PaperSetter where Name='" + txtSearch.Text.ToString() + "'", con);
DataSet ds1 = new DataSet();
con.Open();
SqlDataAdapter dap1 = new SqlDataAdapter(cmd1);
dap1.Fill(ds1, "PaperSetter");
GridpaperView.DataSource = ds1;
GridpaperView.DataBind();
break;
}
}
public void grid()
{
SqlCommand cmd = new SqlCommand("select Code,Name,SCode,Course,Session from PaperSetter", con);
DataSet ds = new DataSet();
SqlDataAdapter dap = new SqlDataAdapter(cmd);
dap.Fill(ds, "PaperSetter");
GridpaperView.DataSource = ds;
GridpaperView.DataBind();
}
protected void GridpaperView_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
if (GridpaperView.Rows.Count > 0)
{
SqlDataAdapter ad = new SqlDataAdapter("select Code,Name,SCode,Course,Session from PaperSetter", con);
DataSet ds = new DataSet();
ad.Fill(ds);
GridpaperView.DataSource = ds;
GridpaperView.DataBind();
pnlselect.Visible = true;
}
}
protected void ddlCourse_SelectedIndexChanged(object sender, EventArgs e)
{
pnlGrid.Visible = true;
if (ddlCourse.SelectedValue.ToString() == "Civil")
{
pnlGrid.Visible = true;
SqlCommand cmd4 = new SqlCommand("select Code,Name,SCode,Course,Session from PaperSetter where Course ='" + ddlCourse.SelectedValue.ToString() + "'", con);
DataSet ds4 = new DataSet();
SqlDataAdapter dap4 = new SqlDataAdapter(cmd4);
dap4.Fill(ds4, "PaperSetter");
GridpaperView.DataSource = ds4;
GridpaperView.DataBind();
}
else if (ddlCourse.SelectedValue.ToString() == "Architecture")
{
pnlGrid.Visible = true;
SqlCommand cmd4 = new SqlCommand("select Code,Name,SCode,Course,Session from PaperSetter where Course ='" + ddlCourse.SelectedValue.ToString() + "'", con);
DataSet ds4 = new DataSet();
SqlDataAdapter dap4 = new SqlDataAdapter(cmd4);
dap4.Fill(ds4, "PaperSetter");
GridpaperView.DataSource = ds4;
GridpaperView.DataBind();
}
}
