Here is the dataClass.cs
using System; using System.Collections.Generic; using System.Linq; using System.Web; //libraries need to talk to database using System.Data; using System.Data.SqlClient; using System.Configuration; ////// This class will connect to the database /// It will have methods to retrieve the Services /// It will also retreive all the grants for that service /// Steve Conger 2016-4-12 /// /// public class DataClass { private SqlConnection connect; public DataClass() { connect = new SqlConnection (ConfigurationManager. ConnectionStrings["CommunityAssistConnectionString"].ToString()); }//end constructor public DataTable GetServices() { DataTable tbl = null; string sql = "Select GrantTypeKey, GrantTypeName from GrantType"; SqlCommand cmd = new SqlCommand(sql, connect); tbl = ReadData(cmd); return tbl; } public DataTable GetGrants(int grantTypeKey) { DataTable tbl = null; string sql = "SELECT GrantRequestDate, GrantRequestExplanation, GrantRequestAmount " + "FROM GrantRequest " + "WHERE GrantTypeKey=@Key"; SqlCommand cmd = new SqlCommand(sql, connect); cmd.Parameters.AddWithValue("@Key", grantTypeKey); tbl = ReadData(cmd); return tbl; } private DataTable ReadData(SqlCommand cmd) { SqlDataReader reader = null; DataTable tbl = new DataTable(); connect.Open(); reader = cmd.ExecuteReader(); tbl.Load(reader); reader.Close(); connect.Close(); return tbl; } }//end class
Here is the Default.aspx page
<%@ Page Language="C#" AutoEventWireup="true"
CodeFile="Default.aspx.cs"
Inherits="_Default" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:DropDownList ID="DropDownList1" runat="server"
AutoPostBack="True"
OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
</asp:DropDownList>
<asp:GridView ID="GridView1" runat="server"></asp:GridView>
</div>
</form>
</body>
</html>
Here is the code behind in Default.aspx.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data; //added for datatable
public partial class _Default : System.Web.UI.Page
{
DataClass dc = new DataClass();
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
LoadDropDownList();
}
protected void LoadDropDownList()
{
DataTable tbl = dc.GetServices();
DropDownList1.DataSource = tbl;
DropDownList1.DataTextField = "GrantTypeName";
DropDownList1.DataValueField = "GrantTypeKey";
DropDownList1.DataBind();
DropDownList1.Items.Insert(0, "Choose a Service");
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
FillGrid();
}
protected void FillGrid()
{
if(!DropDownList1.SelectedValue.Equals("Choose a Service"))
{
int key = int.Parse(DropDownList1.SelectedValue.ToString());
DataTable tbl = dc.GetGrants(key);
GridView1.DataSource = tbl;
GridView1.DataBind();
}
}
}
Here is the web config with the connection string
<?xml version="1.0"?>
<!--
For more information on how to configure your ASP.NET application, please visit
http://go.microsoft.com/fwlink/?LinkId=169433
-->
<configuration>
<system.web>
<compilation debug="true" targetFramework="4.5.2" />
<httpRuntime targetFramework="4.5.2" />
</system.web>
<connectionStrings>
<add name="CommunityAssistConnectionString"
connectionString="data source=srv38;
initial catalog=community_assist;
integrated security=true"/>
</connectionStrings>
</configuration>
No comments:
Post a Comment