I'm interviewing for a .net position on thursday and they will teach me c# during work... rock out with your junk out.... :eek:
Anyhow, I would love to see that code and even try to decipher it after implementation. Do you think it would work saving to Access?
Hey man, good luck with the interview! Keep us posted on how it goes. Here's the class I am using, and you can certainly use Access if you want. However, if your hosting company has SQL Server, that plus stored procedures is the way to go. Let me know if you have any questions about this.
Note: Server.GetServer() calls a class I have that determines my connection string based on if I'm on localhost or my live server.
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Mail;
namespace loans
{
/// <summary>
/// Summary description for AdTracking.
/// </summary>
public class AdTracking
{
public static int GetData()
{
int TrackingID = 0;
//we want to get querystring data, send to the db, and return an id for tracking
if (HttpContext.Current.Request.QueryString["ysm"] != null)
{
try
{
//get the campaign, adgroup and ad ids
string YahooAdInfo = HttpContext.Current.Request.QueryString["ysm"].Trim();
string [] YahooArray = YahooAdInfo.Split('|');
int CampaignID = Convert.ToInt16(YahooArray[0]);
int AdGroupID = Convert.ToInt16(YahooArray[1]);
int AdID = Convert.ToInt16(YahooArray[2]);
//write to database, return id of this record
SqlCommand objCmd = new SqlCommand("YahooTracking", new SqlConnection(Server.GetServer()));
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.Add("@CampaignID", SqlDbType.Int).Value = CampaignID;
objCmd.Parameters.Add("@AdGroupID", SqlDbType.Int).Value = AdGroupID;
objCmd.Parameters.Add("@AdID", SqlDbType.Int).Value = AdID;
objCmd.Parameters.Add("@Host", SqlDbType.VarChar, 250).Value = HttpContext.Current.Request.ServerVariables["HTTP_Host"].ToString();
objCmd.Parameters.Add("@FullURL", SqlDbType.VarChar, 250).Value = HttpContext.Current.Request.Url.AbsoluteUri.ToStri ng();
//make sure other values were passed in
if (HttpContext.Current.Server.UrlDecode(HttpContext. Current.Request.QueryString["OVKey"]) != null)
objCmd.Parameters.Add("@OVKey", SqlDbType.VarChar, 500).Value = HttpContext.Current.Server.UrlDecode(HttpContext.C urrent.Request.QueryString["OVKey"].ToString());
if (HttpContext.Current.Server.UrlDecode(HttpContext. Current.Request.QueryString["OVRaw"]) != null)
objCmd.Parameters.Add("@OVRaw", SqlDbType.VarChar, 500).Value = HttpContext.Current.Server.UrlDecode(HttpContext.C urrent.Request.QueryString["OVRaw"].ToString());
try
{
objCmd.Connection.Open();
//return the id of this entry
TrackingID = Convert.ToInt32((objCmd.ExecuteScalar()));
}
catch (Exception ex)
{
//send error msg
MailMessage msg = new MailMessage();
msg.To = "you@yourdomain.com";
msg.From = "you@yourdomain.com";
msg.Subject = "Web Error " + HttpContext.Current.Request.ServerVariables["HTTP_Host"].ToString();
msg.BodyFormat = MailFormat.Html;
msg.Body = "<table><tr><td><h4>Error Information</h4></td></tr><tr><td>" +
ex.ToString() + "</td></tr></table>";
try
{
SmtpMail.Send(msg);
}
catch
{}
}
finally
{
objCmd.Connection.Close();
objCmd.Connection.Dispose();
objCmd.Dispose();
}
}
catch (Exception ex)
{
//send error msg
MailMessage msg = new MailMessage();
msg.To = "you@yourdomain.com";
msg.From = "you@yourdomain.com";
msg.Subject = "Web Error " + HttpContext.Current.Request.ServerVariables["HTTP_Host"].ToString();
msg.BodyFormat = MailFormat.Html;
msg.Body = "<table><tr><td><h4>Error Information</h4></td></tr><tr><td>" +
ex.ToString() + "</td></tr></table>";
try
{
SmtpMail.Send(msg);
}
catch
{}
}
}
return TrackingID;
}
public AdTracking()
{
}
}
}