we are lost the impressions
-
hi all , I am developing advertising Website-Registering Impression,click etc..here problem is whenever user registering Impression that we are loss the 40% impression and here we doing geolocation also.I attached following code also..Plz reply me if u know...Thanks using System; using System.Data; using System.Data.SqlClient; using dataacesslayer; using System.Web; public partial class Admin_getbase : System.Web.UI.Page { string Crid = ""; SqlConnection conn = null; SqlCommand cmdinsert = null; protected void Page_Load(object sender, EventArgs e) { Response.Cache.SetCacheability(HttpCacheability.NoCache); SqlParameter paramvalue; conn = new SqlConnection("Data Source=dddd;Initial Catalog=new;User ID=fg;Password=hg"); if (Request.QueryString["Crid"] != null) { Crid = Request.QueryString["Crid"].ToString(); } try { cmdinsert = new SqlCommand("sd_Basreg", conn); cmdinsert.CommandType = CommandType.StoredProcedure; paramvalue = new SqlParameter("@Crid", SqlDbType.Int); paramvalue.Direction = ParameterDirection.Input; paramvalue.Value = Crid; cmdinsert.Parameters.Add(paramvalue); paramvalue = new SqlParameter("@IpNum", SqlDbType.BigInt); paramvalue.Direction = ParameterDirection.Input; paramvalue.Value = IpAddress(); cmdinsert.Parameters.Add(paramvalue); conn.Open(); cmdinsert.ExecuteNonQuery(); Response.ContentType = "text/plain"; Response.Write("&imp=registered&"); } catch (Exception ex) { cmdinsert = new SqlCommand("sd_Basreg", conn); cmdinsert.CommandType = CommandType.StoredProcedure; paramvalue = new SqlParameter("@Crid", SqlDbType.Int); paramvalue.Direction = ParameterDirection.Input; paramvalue.Value = Crid; cmdinsert.Parameters.Add(paramvalue); paramvalue = new SqlParameter("@IpNum", SqlDbType.BigInt, 50); paramvalue.Direction = ParameterDirection.Input; paramvalue.Value = "0"; cmdinsert.Parameters.Add(paramvalue); conn.Open(); cmdinsert.ExecuteNonQuery(); Response.ContentType = "text/plain"; Response.Write("&imp=registered&"); } finally {
-
hi all , I am developing advertising Website-Registering Impression,click etc..here problem is whenever user registering Impression that we are loss the 40% impression and here we doing geolocation also.I attached following code also..Plz reply me if u know...Thanks using System; using System.Data; using System.Data.SqlClient; using dataacesslayer; using System.Web; public partial class Admin_getbase : System.Web.UI.Page { string Crid = ""; SqlConnection conn = null; SqlCommand cmdinsert = null; protected void Page_Load(object sender, EventArgs e) { Response.Cache.SetCacheability(HttpCacheability.NoCache); SqlParameter paramvalue; conn = new SqlConnection("Data Source=dddd;Initial Catalog=new;User ID=fg;Password=hg"); if (Request.QueryString["Crid"] != null) { Crid = Request.QueryString["Crid"].ToString(); } try { cmdinsert = new SqlCommand("sd_Basreg", conn); cmdinsert.CommandType = CommandType.StoredProcedure; paramvalue = new SqlParameter("@Crid", SqlDbType.Int); paramvalue.Direction = ParameterDirection.Input; paramvalue.Value = Crid; cmdinsert.Parameters.Add(paramvalue); paramvalue = new SqlParameter("@IpNum", SqlDbType.BigInt); paramvalue.Direction = ParameterDirection.Input; paramvalue.Value = IpAddress(); cmdinsert.Parameters.Add(paramvalue); conn.Open(); cmdinsert.ExecuteNonQuery(); Response.ContentType = "text/plain"; Response.Write("&imp=registered&"); } catch (Exception ex) { cmdinsert = new SqlCommand("sd_Basreg", conn); cmdinsert.CommandType = CommandType.StoredProcedure; paramvalue = new SqlParameter("@Crid", SqlDbType.Int); paramvalue.Direction = ParameterDirection.Input; paramvalue.Value = Crid; cmdinsert.Parameters.Add(paramvalue); paramvalue = new SqlParameter("@IpNum", SqlDbType.BigInt, 50); paramvalue.Direction = ParameterDirection.Input; paramvalue.Value = "0"; cmdinsert.Parameters.Add(paramvalue); conn.Open(); cmdinsert.ExecuteNonQuery(); Response.ContentType = "text/plain"; Response.Write("&imp=registered&"); } finally {
Raj, I am sure no one will read the entire code and come up with a solution. You will get good replies if you post only relevant code and explain the issues clearly. :)
Navaneeth How to use google | Ask smart questions
-
Raj, I am sure no one will read the entire code and come up with a solution. You will get good replies if you post only relevant code and explain the issues clearly. :)
Navaneeth How to use google | Ask smart questions
concept is whenever getting the impression we are insert +1 to database with creative ID,Already Inserted means we are Updating...the problem is In clientSide(Company Client) server is showing impression more than Our Application(we handling other server)....Both server sholud be display same... that means we are lossing the impression.. Plz help me in this
Raaj