hericles 289 Master Poster Featured Poster

In your CSS #navigation ul style you have left: -10px. That should be margin-left: -10px;
This should make it move over.

hericles 289 Master Poster Featured Poster

Google analytics figures that out from the URL. Just paste the code they gave you into every page you want to be monitored.

hericles 289 Master Poster Featured Poster

This is a static website with no code behind (PHP, JSP, .Net)? In that case you will have to use javascript to access the form elements will the booking.html page loads but its pretty hawkish and not pretty.

Using some form of server side code would be far more useful.To do this you must have a form on the first page with an action attribute set and a submit button (which I hope you have or you might find this difficult). Then use PHP to read the posted form and use the result.

hericles 289 Master Poster Featured Poster

I the website on a server with PHP available? A simple PHP include will let you reference the footer in each page but only require you to update it once (in the footer.php file you would create).
Although I always assumed that the date updated applied to that page in particular. If you only update page 1 should the updated date change for page 2?

hericles 289 Master Poster Featured Poster

Basically, the position of the sub menus is placed off screen (-999em which is far to the left) and when the top level <li> are hovered over the child <ul> has its margin reset to auto which makes it appear under the menu item. Taking the mouse off the <li> removes the hover effect and its absolute position reverts back to off screen.

hericles 289 Master Poster Featured Poster

You can read this article on how to use ButtonState to adjust the appearance:
http://msdn.microsoft.com/en-us/library/system.windows.forms.buttonstate.aspx

Or, if you are using images for the buttons, you can have a second image that denotes the pressed status.

hericles 289 Master Poster Featured Poster

You can look into the system tables of your SQL server but the password is probably encrypted so that won't really help you. You could use T-SQL to create a new user to the database but adding users just because you don't know the credentials for the current user is not a very good reason.
You can't just ask your partner what the username/password is? Someone must have it documented somewhere.

hericles 289 Master Poster Featured Poster

Well, if it is a web app it needs to be installed on a server like IIS. If you simply moved the files to another computer and expected them to run, that won't work.

Begginnerdev commented: True! Found this out the hard way. +3
hericles 289 Master Poster Featured Poster

Personal preference, nothing more. I have a dislike for JSP thats all, you may really like it.
PHP makes use of a lot of includes to make better use of code and large projects tend to gather a large number of small code files. They can be handled properly of course, and stored efficiently but I find that unless you (or your team) are highly structured, things just get messy. Its human nature.

hericles 289 Master Poster Featured Poster

What? Is this meant to be a question asking for help?

hericles 289 Master Poster Featured Poster

Functionally there is little difference - the end result will be a working website. I find easy PHP easy to code with but a little messy in the long run. I prefer .Net and avoid JSP where possible. Its a fine product to use from a functionality perspective but I find the resulting project has more pages, files, servlets than I would like.
My ruby knowledge is limited but I quite liked it, it is something I would prefer to put more time into and learn better.
You should, of course, learn the one that you find the most interesting and sensible. .Net, PHP, ruby will all be around for a while I imagine.

hericles 289 Master Poster Featured Poster

The answer really depends on how you are storing the questions and answers. Are they in a database or simply hard coded into each screen?
If they are hardcoded you can include the answer as a hidden field (visible = false) and then just check it when the button is clicked. Note: hardcoding is a poor way to handle the problem.

hericles 289 Master Poster Featured Poster

Hi,
I'm wondering if a return is needed after your While objReader.Read() loop.
It may be that the compiler considers that to be a branch and is wanting a return to be available after that loop is case the while() can't process. I don't know if that is the problem but it really is the only place I can see that might address the issue.

hericles 289 Master Poster Featured Poster

The mistake is quite clear. That function is deprecated (out of date, no longer supported) and you should use mysql_query() as the message states.

hericles 289 Master Poster Featured Poster

You can't just use a long int or GID? If the id column is auto increment it won't cause any conflicts or double up.

hericles 289 Master Poster Featured Poster

Thats because you are using executeScalar() which returns one row. Using a reader will return all rows that meet the criteria. You should be asking yourself if the exact same data should be in the database twice. If the only thing that changes is the id column you have redundency is your database.

hericles 289 Master Poster Featured Poster

If that is the case, and the components aren't a part of your program, you may need to create a custom msi that includes the dependencies. I'm not very familiar with devExpress so I can't give too much advice about that.

hericles 289 Master Poster Featured Poster

It looks like an unhanded error occurs. Does your program use any resources that you haven't installed or assume will be on the target machine?

hericles 289 Master Poster Featured Poster

I see you're using an IP address. Is the database on a remote machine rather than local host? Maybe you need to include a port number? And try changing password to pwd as well. A handy site for locating the format of connection strings is http://www.connectionstrings.com. It has every connection string you will ever need.

hericles 289 Master Poster Featured Poster

If you are using mySql for your database then your connection string is wrong. Use uid not user Id.

hericles 289 Master Poster Featured Poster

Practice, practise, practise. It takes time unfortunately, no quick fixes here. Decide on an area you don't know well and learn something new. Build completely useless apps that use XML save to and read from a file, use drawing to make a ball bounce around the screen. You get the idea.

hericles 289 Master Poster Featured Poster

You have a comma directly before FROM in your SQL statement. You need to remove that.

discovery-power commented: much appreciated, thanks +3
hericles 289 Master Poster Featured Poster

It sounds like you are trying to enforce presentation into the database which is not the right way to go about it. The database simply holds data, the interface needs to parse the data into the desired form.

hericles 289 Master Poster Featured Poster

Hmmm, sounds like a homework assignment:)
It is fairly simple to accomplish though. I'm assuming your two lists have the values preset. So you just need to find the selected item of each list, convert to integer and multiply them.
Once you have that value a loop that includes that value as the maximum can be done that calculates a new random number each iteration of the loop.
Have a go and post up some code when you get stuck.

hericles 289 Master Poster Featured Poster

You can have two divs, the outer with the background color and 100% width and another div inside that one that holds your links and has margin:auto set. margin:auto only works when a length for the parent container is set (I think) otherwise it doesn't know what distance to do the maths on.

hericles 289 Master Poster Featured Poster

Quite a few <strong> tags should be avoided. Its hard to tell if overuse of any SEO element is really penalized but its best to be cautious. Interestingly, you want to emphasize the keywords for a bot but not for the actual reader. Strong around the keywords (one or two on the page) show me that what I searched for is on the page and where. Whats the point of getting high page rank if you're not actually making your page user friendly?

hericles 289 Master Poster Featured Poster

Because if you do call the function in the page_load and don't use the Not IsPostBack check it will get called on a page reload as well.

hericles 289 Master Poster Featured Poster

3 posts ago you said you did call it in the page_load function. Was that a typo?

hericles 289 Master Poster Featured Poster

Its probably the lack of a space between Val(TextBox2.Text) & "where name='" because its going to join the TextBox2.Text to where e.g. someValuewhere name = ....
And feel free to create your own posts, there's no need to hijack someone else's.

hericles 289 Master Poster Featured Poster

If you have the initial call in the page_load event it is running twice. Once when the page loads and again when the controls are redrawn after entering text.
You need to call the function inside of this code:

if Not IsPostBack then
   TambahRekod()
end if

This will only call the code when the page is first loaded. Page reloads ignore it.

hericles 289 Master Poster Featured Poster

Firstly, do you really want to create a new table for every user just to record their name, link and description? If your site/app becomes even reasonably popular that amounts to a lot of tables. That data can easily be kept in one table for everyone.
If you need to create the table (I'm assuming in the ELSE part of the loop) it the same as executing any other scalar operation on the database. Set your SQL string and use the command object as you already have done to insert or extract the data.

hericles 289 Master Poster Featured Poster

As someone who posts here a fair bit I can tell you that seeing the word urgent in the title does nothing to make me frantically rush to help the poster. I don't really care if your problem is urgent. I still want to help or I wouldn't be here. A well worded post with adequate information about the problem is far more likely to attract advice than one with a minimum of words.
I'm not going at you in particular here, plenty of people could help themselves by creating better posts.

hericles 289 Master Poster Featured Poster

Giving a column an alias in the SQL statement is as simple:
SELECT user_id AS User FROM table_name

This will cause your dataset to populated with the data from user_id but the column will be called User in the dataset. You can do this for as many columns as you need in your SQL.

hericles 289 Master Poster Featured Poster

The exectuteNonQuery is only being called once so the only thing that could be causing the duplication is that your function TambahRekod() is being called twice. What calls the function initially?

hericles 289 Master Poster Featured Poster

What exactly goes wrong? A screenshot would be nice so we could see what you are referring to.
Without forcing a minimum width on the containers you should just get a scroll bar if your content becomes larger than the screen. Once minimum width is hit everything starts to get shuffled down if there isn't enough space. In your case the moving down of items will happen after the screen size goes below 1000 pixels (i think based on what I see here).

hericles 289 Master Poster Featured Poster

He's talking about CSS3 (Cascading Style Sheets version3), this has nothing to do with version of photoshop...

hericles 289 Master Poster Featured Poster

Do you even need the grid view? I doubt you are viewing 11000+ rows on the screen. A direct export from the database to XML would be much faster. This is assuming the file doesn't NEED to be a .xls however. If you did that you would, of course, end up with an XML file (which can be opened in excel).

hericles 289 Master Poster Featured Poster

Again, thats a bit vague. Exactly how do you want to use Facebook, what data do you want to send to it?

hericles 289 Master Poster Featured Poster

Well, you're making it do 11201 * 80 reads from the grid view so that simply will take time. Is the problem that it is timing out or are you simply looking for a way to make it faster?

hericles 289 Master Poster Featured Poster

Inability to save the the file to the specified location? Where is it trying to save the file to?
It also shows your code isn't production ready, saving files is something that should have error handling code for just this kind of exception.

hericles 289 Master Poster Featured Poster

Hi,
It all comes down to what functionality you are building in. If you cover a full range of pages yourself and don't expect the user (or allow the user) to customize the information the database holds then building tables at run time should not be required.
I wouldn't expect a CMS to build tables for the user if the CMS was well thought out in the first place but, on the flip, that kind of versatility might be useful...

hericles 289 Master Poster Featured Poster

Does the page you go back to check to see if a valid session is active?
In the page load part of the page check for whatever session variable shows the user is logged in. If it exists or is set to the correct value continue to load the page. If not then redirect to the home page or login screen. Once you have cleared the session this page won't display even by pushing the back button

hericles 289 Master Poster Featured Poster

Call the Session.Clear() method when the log out code is complete (but before the redirect to the home page). This will clear out all session values regardless of whether the back button is clicked - as long as each page checks for an active session anyway.

hericles 289 Master Poster Featured Poster

The visualisation of big data is a current area that has some people thinking hard (how to formulate, display, make sense of terabytes or more of data).
Or you can always tackle an implementation of the semantic web.

hericles 289 Master Poster Featured Poster

I'm assuming you already have the email code because you didn't ask for that.
As I understand it you have the emails stored in a file which allows you to count how many emails you are going to be sending (as each email is unique you send one email per address). The number of emails in the file then becomes the number of emails you are going to send in total.
You are going to run through the email sending code many times so after each iteration (i.e. after calling the send method of the Mail object) increment the current value of the progress bar by one (thereby moving it towards the max value).
This isn't the code you asked for but its late and I'm tired:) It explains the principle behind how to handle the problem though.

hericles 289 Master Poster Featured Poster

If the email being sent is the same for each user why don't you just use cc or bcc to send the email once but to many recipients? Then a progress bar isn't really needed.
If you want to send the emails sequentially (because the emails are different), count how many addresses there are and max this the max value of the progress bar and then, after each individual email has been sent, increase the progress bar by one.

hericles 289 Master Poster Featured Poster

This means your SQL statement is returning null from the database table. Check your SQL, especially if a where clause is being used, and make sure null isn't being returned.

hericles 289 Master Poster Featured Poster

Do you have a site that is currently slow? Or is this for building something new?
Site loading speed depends on a variety of factors. You should make sure all images are no larger on the server than they appear on the page, script files should be optimised and made as small as possible, database operations should only return the bare minimum of required data and be handled efficently.
One thing to be aware of is using the Page.isPosBack function. If the page is being reloaded, rather than loaded for the first, a lot of set up can be skipped (say, loading data into views or dropdowns etc) as it is already there.
If you explain exactly what you need we can probably help more.

narendrajarad commented: solved +0
hericles 289 Master Poster Featured Poster

For your database I would have another linking table that links staff to projects (project_id, staff_id) so that staff members can be tracked by project ID. I know you have client ID, project ID and staff ID in the one table but two tables would be better (clients to projects, projects to staff).
For displaying the data a drop downlist of clients can be selected, after that a second dropdown is populated with their projects and once a project is selected then the staff members can be displayed. that would give you 3 queries against the database as you moved through the client-project-staff tables and it would prevent the user simply getting possibly irrelevant info dumped on screen (staff of a project they're not interested in).

hericles 289 Master Poster Featured Poster

3 databases for 3 accounts is a bit weird. Event 3 tables, 1 per account, isn't really the best way to do. Considering each is going to display pretty much the same information, I wouldn't have bothered with 3 forms either.
You could have one table that stores all the transactions (money in and out) and simply include the account as part of each record. Transactions could be stored as positive or negative amounts and then the SQL SUM function will instantly give you the total amount in any of the account.