I have this class file within the App_Code folder
CorrectionsDB.c s
namespace CorrectionsDB.c s
{
using System;
using System.Data;
using System.Configur ation;
using System.Web;
using System.Web.Secu rity;
using System.Web.UI;
using System.Web.UI.W ebControls;
using System.Web.UI.W ebControls.WebP arts;
using System.Web.UI.H tmlControls;
/// <summary>
/// Summary description for CorrectionsDB
/// </summary>
public class CorrectionsDB
{
public CorrectionsDB() { }
public static System.Data.Dat aSet GetCampaign()
{
string connectionStrin g =
ConfigurationMa nager.Connectio nStrings["Developmen t"].ConnectionStri ng;
System.Data.IDb Connection dbConnection = new
System.Data.Sql Client.SqlConne ction(connectio nString);
string queryString = "Select Campaign from tCampaigns Order
By Campaign";
System.Data.IDb Command dbCommand = new
System.Data.Sql Client.SqlComma nd();
dbCommand.Comma ndText = queryString;
dbCommand.Conne ction = dbConnection;
System.Data.IDb DataAdapter dataAdapter = new
System.Data.Sql Client.SqlDataA dapter();
dataAdapter.Sel ectCommand = dbCommand;
System.Data.Dat aSet dataSet = new System.Data.Dat aSet();
dataAdapter.Fil l(dataAdapter);
return dataSet;
}
}
}
..... and this .aspx file
<%@ Page Language="C#" AutoEventWireup ="true" CodeFile="gift. aspx.cs"
Inherits="gift" %>
<%@ Register TagPrefix="Corr ectionsDB" Namespace="Corr ectionsDB.cs"
Assembly="App_C ode/CorrectionsDB.c s" %>
<%@ Import Namespace="Syst em.Data" %>
<%@ Import Namespace="Syst em.Data.SqlClie nt" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dt d">
<tr>
<td style="width: 170px">Campaign </td>
<td width="230">
<asp:DropDownLi st ID="DropDownnLi st1" runat="Server"
DataSourceID="O bjectDataSource 1" DataTextField=" campaign"
DataValueField= "campaign" />
<asp:ObjectData Source ID="ObjectDataS ource1" runat="server"
TypeName="Corre ctionsDB" SelectMethod="G etCampaign" />
</td>
<td width="170">Cam paign</td>
<td width="230">
</td>
</tr>
