I have this class file within the App_Code folder
CorrectionsDB.cs
namespace CorrectionsDB.cs
{
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
/// <summary>
/// Summary description for CorrectionsDB
/// </summary>
public class CorrectionsDB
{
public CorrectionsDB() { }
public static System.Data.DataSet GetCampaign()
{
string connectionString =
ConfigurationManager.ConnectionStrings["Development"].ConnectionString;
System.Data.IDbConnection dbConnection = new
System.Data.SqlClient.SqlConnection(connectionStri ng);
string queryString = "Select Campaign from tCampaigns Order
By Campaign";
System.Data.IDbCommand dbCommand = new
System.Data.SqlClient.SqlCommand();
dbCommand.CommandText = queryString;
dbCommand.Connection = dbConnection;
System.Data.IDbDataAdapter dataAdapter = new
System.Data.SqlClient.SqlDataAdapter();
dataAdapter.SelectCommand = dbCommand;
System.Data.DataSet dataSet = new System.Data.DataSet();
dataAdapter.Fill(dataAdapter);
return dataSet;
}
}
}
..... and this .aspx file
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="gift.aspx.cs"
Inherits="gift" %>
<%@ Register TagPrefix="CorrectionsDB" Namespace="CorrectionsDB.cs"
Assembly="App_Code/CorrectionsDB.cs" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<tr>
<td style="width: 170px">Campaign</td>
<td width="230">
<asp:DropDownList ID="DropDownnList1" runat="Server"
DataSourceID="ObjectDataSource1" DataTextField="campaign"
DataValueField="campaign" />
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
TypeName="CorrectionsDB" SelectMethod="GetCampaign" />
</td>
<td width="170">Campaign</td>
<td width="230">
</td>
</tr>
