| | |
Customer survey problem
Please support our VB.NET advertiser: Intel Parallel Studio Home
![]() |
•
•
Join Date: Oct 2009
Posts: 1
Reputation:
Solved Threads: 0
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
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
- should you register your domain name independently from your web host? (Domains and DNS)
- Random access files problem (C++)
- iframe not working in IE, works fine in Firefox (JavaScript / DHTML / AJAX)
- Random No Signal Error (Troubleshooting Dead Machines)
- ATI Radeon graphics card problem--computer won't start (Monitors, Displays and Video Cards)
- DC SQL job with Microsoft (Work from home) (Software Development Job Offers)
- SanDisk JumpDrive Problems (USB Devices and other Peripherals)
- hello from pittsburgh pa (Community Introductions)
- retrieving ids from dynamically created controls in asp.net (ASP)
- Running Low on Virtual Memory, Runtime C++ Error (Windows NT / 2000 / XP)
Other Threads in the VB.NET Forum
- Previous Thread: Crystal Reprts VS ComponenetOne
- Next Thread: Desktop search engine using vb.net
| Thread Tools | Search this Thread |
Tag cloud for .net, database, survey, vb
.net 3.5 access age amd apple application array asp avatar backup basic bigbrother bluegene c# chips community connection crime daniweb data database databasesearch deployment development dos ecommerce economy encryption energy enterprise enterprisesoftware file flash gartner hardware ibm ibm.news images intelibm internet java linux medicine memory microsoft mobile mobilephone mono mysql networks news openoffice opensource operatingsystem oracle pc php ps3 recession record redhat remoting research russia search security server social software sql sqlite sqlserver sun supercomputer supercomputing survey table technology trends twitter ubuntu uk update vb vb.net vb6 virtual virtualization vista visual visualbasic visualstudio web webbrowser windows winforms working wpf x86






