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