Customer survey problem

Please support our VB.NET advertiser: Intel Parallel Studio Home
Reply

Join Date: Oct 2009
Posts: 1
Reputation: deepak12333 is an unknown quantity at this point 
Solved Threads: 0
deepak12333 deepak12333 is offline Offline
Newbie Poster

Customer survey problem

 
0
  #1
Oct 7th, 2009
hi

I am in deep trouble to loose my job please help me


I am working on a website where a user comes and login
when it enters a pop up screen appears where it is written continue or remind me later now i am unable to handle this functionality that on the 5th time a user logins if he did not coducted the survey that the remind me later screen grayed out and he need to fill survey
please help me about how to track the customer that it is his 5th time he is login and he must take survey
i m pasting my code please help me now
OracleConnection Conn = new OracleConnection("Data Source=xyz;User ID=SYSTEM;Password=omar;");
OracleCommand cmd = new OracleCommand();
cmd.Connection = Conn;
Conn.Open();

string strConn = Request.QueryString["uid"];

//string orc = string.Empty;

//orc = "insert into TABLE1(USERNAME,COUNTER) VALUES ('" + strConn + "','" + count1 + "')";
//cmd.CommandText = orc;
//cmd.ExecuteNonQuery();


string test = string.Empty;

test = "select COUNTER from TABLE1 where USERNAME =('" + strConn+"')";
cmd.CommandText = test;

cmd.ExecuteNonQuery();
OracleDataReader odr = cmd.ExecuteReader();
odr.Read();
int count = Int32.Parse(odr.GetValue(0).ToString());

if (count < 5)
{
count++;
string test1 = "update TABLE1 set(COUNTER= '" + count + "') where (USERNAME= '" + strConn + "')";
cmd.CommandText = test1;
}
else
{
btnRemind.Enabled = false;
}


Conn.Close();


Response.Redirect("HomePage1.aspx?uid=" + strConn);
}

value in database is not updating
Reply With Quote Quick reply to this message  
Reply

Tags
.net, database, survey, vb

Message:



Similar Threads
Other Threads in the VB.NET Forum
Thread Tools Search this Thread



Tag cloud for .net, database, survey, vb
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC