944,052 Members | Top Members by Rank

Ad:
  • VB.NET Discussion Thread
  • Unsolved
  • Views: 1661
  • VB.NET RSS
Oct 7th, 2009
0

Customer survey problem

Expand Post »
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
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
deepak12333 is offline Offline
1 posts
since Oct 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in VB.NET Forum Timeline: Crystal Reprts VS ComponenetOne
Next Thread in VB.NET Forum Timeline: Desktop search engine using vb.net





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC