<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Class_Details.aspx.cs" Inherits="Websearch.Class_Details" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> </head> <body> <form id="form1" runat="server"> <div> <hr /> <asp:Label ID="LabelClass" runat="server" Text="class Details" BorderColor="White"></asp:Label> <hr /> <br /> <br /> <asp:GridView ID="GridView3" runat="server"></asp:GridView> </div> </form> </body> </html>
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Data; using System.Configuration; namespace Websearch { public partial class Class_Details : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { String MainCon = ConfigurationManager.ConnectionStrings["MyConn"].ConnectionString; SqlConnection sqlcon = new SqlConnection(MainCon); sqlcon.Open(); LabelClass.Text = Request.QueryString["Classno"].ToString(); int Classnum = Convert.ToInt32(LabelClass.Text); SqlCommand sqlcom1 = new SqlCommand(); String sqlquerry1 = "Select Class, Item from [customer_class_item] where Class = " + Classnum ; sqlcom1.CommandText = sqlquerry1; sqlcom1.Connection = sqlcon; sqlcom1.Parameters.AddWithValue("Class", LabelClass.Text); DataTable dt1 = new DataTable(); SqlDataAdapter sd1 = new SqlDataAdapter(sqlcom1); sd1.Fill(dt1); GridView3.DataSource = dt1; GridView3.DataBind();
int Classnum = Convert.ToInt32(LabelClass.Text);
Classnum
using (SqlConnection sqlcon = new SqlConnection(MainCon)) using (SqlCommand sqlcom1 = new SqlCommand("SELECT Class, Item FROM [customer_class_item] WHERE Class = @Class", sqlcon)) { sqlcom1.Parameters.AddWithValue("@Class", Classnum); DataTable dt1 = new DataTable(); SqlDataAdapter sd1 = new SqlDataAdapter(sqlcom1); sd1.Fill(dt1); GridView3.DataSource = dt1; GridView3.DataBind(); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)