Any particular reason you want to set the timeout to an arbitary value of 200 or do you just want the session variables to remain indefinately?

If its indefinately then check that the user has been authenticated and populate the session variables accordingly

Essentially you need to start the timer server-side and then ensure that page refreshes do not alter the client-side countdown status (otherwise you just need to refresh constantly to reset the timer)

To invoke the timer I have the following:

protected void Page_Load(object sender, EventArgs e)
if (!Page.IsPostBack)
{ TimerStart(); }

The TimerStart routine is defined as:

private void TimerStart()
if (Session["TimerStart"] == null)
Session["TimerStart"] = true;
endDate = new BOL.Date();

The Session settings is to prevent the page refreshes as mentioned earlier and the class BOL.Date is a class I have created to return the date from my SQL server, it allows me to break the date format down into year, month, day, hour, minute, seconds - if you don't have access to an SQL server you can use various methods to return this information easily.

The user can move to the next item in my list of items displayed without waiting for a full count down by pressing the 'Next Button', the code for this is as follows:

protected void btnNext_Click(object sender, System.EventArgs e)
Session["TimerStart"] = null;

To start the javascript timer, the following code needs to be added to the PreRender:

protected override void OnPreRender(EventArgs e)
if (Session["TimerStart"] != null)
string script = string.Format("javascript: countdownTimer({0}, {1}, {2}, {3}, {4}, {5}, {6});", endDate.Year, endDate.Month, endDate.Day, endDate.Hour, endDate.Minute, endDate.Second, );
ScriptManager.RegisterStartupScript(this, this.GetType(), "TimerStarted", script, true);



The is ...

__avd commented: Good post! :) +11

Ideally you should be using a virtual or relative path so using Server.MapPath is not to be recommended as it gives a hacker a chance to peruse your directory structure.

Have you tried...



BTW what is the value of htmlOutPut AFTER you have assigned the image name to it?

It depends on what format you are receiving the data from the WebService but the syntax is as follows:

Dim reader As New System.IO.StringReader()

DataSet dataset = new DataSet();

myDropDownList.DataSource = dataset.Tables[0];
myDropDownList.DataValueField = "value_field"
myDropDownList.DataTextField = "text_field"

The reader object is used to access the Webservice feed which and is expecting an XML string (for this example)

The code...

string image = "Images"; +"//" + fileName;

Should be..

string image = "Images" +"//" + fileName;

You have added an unnecessary semi-colon which will effectively terminate that statement so the filename never gets added.

Surprised your IDE did not flag up a warning on compilation - mine certainly did!


Your problem will be whether you intend on having a 'real-time' look and feel to your application or whether you want to check the actual time spent on the question AFTER the user submits the request to the server.

What adatapost has suggested will offer you server-side processing which may not be what you require - the time is set on the server and checked when the processing returns to the server again (after the user submits his/her question response). This has the unfortunate side-effect of the user being able to spend as long as they like on the questions but only being told they have taken too long when they click a button to submit their response or move on to the next question.

I suspect what you are looking for is a client-side timer script which counts down and keeps a track of the total time spent on the questions - this is quite intricate and will require some time invested by you on understanding its operation. I have such a script and will post it here is its what you require.

Please let us know what solution you are looking for...

There is some debate whether its a good idea to store images in a database or on a file server.

If you insist on using a database then you'll need to set up a webhandler file which streams the image to your webpage.

Create a new item in your project of type of WebHandler and call it PhotoHandler

Then change the code to the following:


<%@ webhandler language="C#" class="PhotoHandler" %>
using System;
using System.Web;
using System.Data;
using System.Data.SqlClient;

public class PhotoHandler : IHttpHandler
public bool IsReusable { get { return true; } }

public void ProcessRequest(HttpContext ctx) 
    string id = ctx.Request.QueryString["PhotoID"]; 

    SqlConnection con = new SqlConnection(<<INSERT CONNECTION STRING HERE>>); 
    SqlCommand cmd = new SqlCommand("SELECT [PhotoData] FROM [PhotoTable] WHERE PhotoID = @PhotoID", con); 
    cmd.CommandType = CommandType.Text; 
    cmd.Parameters.Add("@PhotoID", PhotoID); 

    byte[] pict = (byte[])cmd.ExecuteScalar(); 

    ctx.Response.ContentType = "image/bmp"; 
    ctx.Response.OutputStream.Write(pict, 0, pict.Length); 



then in your Web page you would do the following:



__avd commented: Good option! +11

As we don't have access to yer data - what exactly is going wrong?

BTW would'nt it it easier to bind the DropDownLists to the ticketPrice - then you don't have to do your "If DropDownList2.SelectedValue = ..."






Bind more than 100 Grids - Are you displaying these all simultaneously (which would be highly inadvisable and downright madness)

Why not use a couple of placeholders and load the datagrid dynamically as and when the need arises.

Better still, let us know what you're trying to achieve and we may be able to point you in the right direction

Its better to retrieve the time from a server rather than use the local machine time (which can be easily amended) and compare the current server time with the duration time as held on the database.

Maintaining the duration time in a database will allow you greater flexibility as you can dynamically set this time without the need to release a web.config file or new code.

The following code...

FROM [TableName]
GROUP BY [TelephoneNo]
HAVING COUNT(TelephoneNo)>1

Will return all the duplicate telephone numbers and the Largest account balance - you can then put the results of this in a temporary hash table and join onto your original table. Record with the same telephone number but lesser ACCT_BALs can then be deleted from your original table.

Other ways of doing this but really depends on yer SQL knowledge

How would you know which record to keep if the phone numbers are the same but the record information is different?

Do you have a timestamp on each record so you know whioh is the latest record?

Any particular reason you're using an HTML table?

Why don't you use a gridview to display the results from a datasource?

How do you intend to set/display this time for people accessing your site from different countries?

Do you know how to use a validator control or do you want to do the validation in code-behind?


ErrorMessage="Please enter a default 10 digit contact number (eg:111-111-1111)"
ValidationExpression="(((\d{3}) ?)|(\d{3}-))?\d{3}-\d{4}">*</asp:RegularExpressionValidator>


If you are loading the pictures and labels proramtically them you must have an idea of which objects are being updated.

Do you know which obkjects you want to clear?

Why don't you just hide it and iterate through the grid for the hidden rows?

e.g to hide the row on 'deleting'

protected void gd_OnRowDeleting(object sender, GridViewDeleteEventArgs e)


Now iterate through the Gridview looking for the hidden rows

foreach (GridViewRow gvr in gd.Rows)
if (gvr.Visible==false)
some process...


I have tried it and it does work...

I think you've misunderstood what you should be doing:

This is how it should be done...

protected void gd_OnRowDeleting(object sender, GridViewDeleteEventArgs e) {
... Delete from Database
gd_Subjects.DataSource = DatabaseQuery;



Otherwise you will always have a false reading as the row will only be deleted from the UI and not the database.

Have you tried the following?...

ON T2.ID = T1.ID


You will get everyting in table 2 (which has an ID but no date) and only the date from table 1 (which has an ID and a date)

The you can filter on the result as you see fit

Seems to be missing the following:


Other that that it seems to be working (When you get build errors on compilation just click the 'Yes' button 'to continue and run the last successful build')

Presumably because its an invalid URL you're using?

Error 400: Requested URL invalid or incomplete

I have tried to use the website using the recommended example and it does not work - suspect the site has changed its policy for access


I assuming that the 'other machine' is your web server and you've loaded the images to the relevant directory on that server but you are now working on a local machine and cannot find the images.

Or have I got it completely wrong?

Nitin Daphale: Not actually sure what you're trying to do - presumably the row deleting event is being fired because you are trying to delete the row?

So why do you need to remove the row programatically as the inbuilt delete function will take care of this - do you have more than one delete buttons?

Tell us abit more about your program design and we may be able to offer further assistance

Is there any reason why you aren't checking the username directly in your SQL query instead of iterating through the user table?

// don't ever do this!
String sql = "SELECT * FROM UserNew WHERE u_name = '" + uname + "'";

Ideally you should be doing this using the SQL Command, SqlParameter and SQLDataReader methods to prevent injection attacks.

SqlDataReader reader = null;
SqlCommand cmd = new SqlCommand("select * from UserNew where u_name = @uname", con);
cmd.Parameters.Add(new SqlParameter("@uname", uname));

// get data stream
reader = cmd.ExecuteReader();
if (reader["u_pass"].ToString() == upass)
{return true;}

//Password does not match or the username cannot be found
return false;


This will return the exact match and you can then check if the password has been entered correctly.

Further to the above post you will need to add the following in your webconfig:


add name="LocalSqlServer1" connectionString="Data Source=myServerAddress1;Initial Catalog=myDataBase1;User Id=myUsername1;Password=myPassword1;"/>


And in your code-behind...

using System.Configuration;

string sqlServer;
if(LoginOption ==1){
sqlServer = ConfigurationManager.ConnectionStrings["LocalSqlServer1"].ConnectionString;}

elseif(LoginOption ==2)
{sqlServer = ConfigurationManager.ConnectionStrings["LocalSqlServer2"].ConnectionString;}


You now have different connection strings (which reside in the Webconfig file) being used for different Login Options

Also you may have the AutoPostBack set to 'true' in the HTML of your textbox in which case it will do a postback on the enter key.

Delete this option, create a seperate button and do the postback on that

In your HTML...

And in your code-behind... protected void btnContinue_Click(object sender, EventArgs e) { // validate the textbox... } [/CODE]

Visual Studio is the Development Envrionment and C# is the programming language.

Normally you would use the ViewState object to save page-specific information and the Session object to save Site-specific information.


//Page Specific
ViewState["UrlReferrer"] = Request.UrlReferrer.ToString();
ViewState["ValueEntered"] = TextBox1.Text;

//Website specific
Session["UserName"] = "JohnThomas";


The only issue you will have is ensuring you can update the tables in your database using the logged-in user's identity (which is GUID based)

Otherwise the memebrship/roles will do nearly everything you need.

Be advised that the Membership data resides in your App_Data folder unless you specifically point to an external database - A few people I know have overwritten this membership data in a production environment when they FTP a new release of their web application with the local membership data

I've used DotNetNuke and its a very good system but to get the fun stuff you need to buy the commercial add-ons which is not always a good idea as DNN do very regular upgrades and the third-party stuff always lags several version behind.

You can easily run multiple sites off a single installation of DNN and the free stuuf should be more than enuff to give you a fairly robust out-of-box solution.

The source code is written in VB - not sure if they do a C# version