How to retreive values of a dataset from BLL
Hello Experts,I am working on job search web application written in asp.net 3.5 C#, which is a multitier application, I am facing a problem on how to access values return by a dataset in my Business logic layer which runs Stored Procedure and returns me emailaddress....
Here's my business logic file..
Subscribers.cs
namespace JobSite.BOL
{
public class Subscribers
{
public Subscribers()
{
}
private int strSubscriberID;
private string strEmailAddress;
private string strname;
private string strCompany;
private DateTime dtDateTimeStamp = DateTime.Now;
public int SubscriberID
{
get
{
return strSubscriberID;
}
set
{
strSubscriberID = value;
}
}
public string EmailAddress
{
get
{
return strEmailAddress;
}
set
{
strEmailAddress = value;
}
}
public string name
{
get
{
return strname;
}
set
{
strname = value;
}
}
public string Company
{
get
{
return strCompany;
}
set
{
strCompany = value;
}
}
public DateTime DateTimeStamp
{
get
{
return dtDateTimeStamp;
}
set
{
dtDateTimeStamp = value;
}
}
public int InsertSubscribers(Subscribers s)
{
DBAccess db = new DBAccess();
//SqlParameter p = new SqlParameter();
db.AddParameter("@EmailAddress", s.EmailAddress);
db.AddParameter("@name", s.name);
db.AddParameter("@Company", s.Company);
db.AddParameter("@DateTimeStamp", s.DateTimeStamp);
//db.AddParameter(p);
return db.ExecuteNonQuery("NL_SubscribersInsert");
}
//returns subscribers emailaddress
//***********************************************************
public static DataSet GetSubscribersEmail()
{
DBAccess db = new DBAccess();
return db.ExecuteDataSet("NL_Subscribers_SelectEmail");
}
//***********************************************************
---------------------------^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^¨¨¨¨¨¨
CODE Behind
Jobs.cs
protected void ObjectDataSource1_Inserted(object sender, ObjectDataSourceStatusEventArgs e)
{
//***********************************************************
string subscrEmail;
//ERRORRRRRRR
JobSiteStarterKit.BOL.Subscribers subscription = Subscribers.GetSubscribersEmail();
//***********************************************************
if (e.Exception == null)
{
int id = (int)e.ReturnValue;
MailMessage mailMessage = new MailMessage();
mailMessage.From = new MailAddress("test@asp.com");
//***********************************************************
mailMessage.To.Add(new MailAddress(subscrEmail.EmailAddress));
//***********************************************************
mailMessage.Priority = MailPriority.High;
mailMessage.IsBodyHtml = false;
mailMessage.Subject = " New jobs uploaded example.com";
mailMessage.Body = "this is a job alert";
//Display confirmation message
mailMessage.Body = "Please click the link below to view the job http://www.test.com/jobs.aspx?id=" + id + "";
SmtpClient smtpClient = new SmtpClient();
smtpClient.Send(mailMessage);
}
------------------------------------------------
I have highlighted the code needs attention by : //**********************************************************
Hope i've explained it clearly..
Waiting for solutions ASAP...