Posts by hericles

You shouldn't need to match the your home user name and password to the office one as it is the particular database you are trying to access and that has no record of the sql server login details. But if you have changed them to match that shouldn't cause a problem anyway.
Have you confirmed it installed correctly? i.e you can run queries against the database on the command line or using the admin screen?

OK, because you aren't getting any database errors your syntax is correct so it could be that the dataset is empty based on the where clause (where brcod = 6281014472210). Check the dtable.Rows.count value is more than zero.
If not either the returned dataset is empty or setting dtable = DS.Tables["localpos"]
is the problem.

You can attach the database when you build your installer, its been a while since I've done and I can't remember the exact steps but you'll find an online tutorial to help. Or, if the config specifies the correct location, you can just dump the database there afterwards. But location will matter. If you have specified a drive and folder where the database will be it will need to be there.

Go to the control panel and select users accounts and pick the account you want to change (if there is more than one) and you'll see the option to remove the password.
To disable programs from startup click run in the Start menu and type in msconfig and hit enter.Select the startup tab and disable whatever you need to. NOTE: I'm not to blame for you inadvertantly turning off the wrong things :)

Where abouts in your code does the crash occur? If you can narrow down what code is running when it happens that will help.

That is correct. And seeing the config file is just XML that is easy to do.

The connection string works properly pulling data into a checkboxlist control on another page of the site.

Now that is weird. If it is connecting to the same database and it works on one page you know the connection string is OK.
Can you post up the database code on the page that does work and the page that doesn't?
There has to be something different about the two.

You haven't highlighted which line is causing the error but it will be one of your assignment lines - where you are setting something with the = symbol.
It normally happens because the object you are trying to assign is null soI'm guessing it is either:

OracleDataAdapter xx = new OracleDataAdapter("SELECT * FROM POS WHERE barcode = " + this.textBox1.Text, conn);

or

ListViewItem lvi = new ListViewItem(drow["product_name"].ToString());

But it may be something else. Debug your code, see what line is throwing the error and make sure you are trying to assign an something (not null).

That error means your website could not connect to the database. Either your config connection string is giving the correct details or the database hasn't been created at that location yet. Which of the connection strings are you using and is the database stored on goDaddy or is it remote?

No, your .cs file should be OK. If the error solely relates to not being able to locate the database then the connection string in the config file was the problem.

There are several ways you can do this. Lightbox or one of its derivatives will work for you. Or if you want something a little quicker (and hackish) you can create your lockout div and position it off screen using CSS. Alter its CSS style to place it on screen when needed and when the user has finished whatever action is required, you move it off screen again.

Unfiltered text input placed directly into an SQL statement in production code... It hurts my eyes.

You can use validators on the first page to check some of the values entered (check that something is entered, that it is a number, falls within a certain range, matches a regular expression, etc). These validators fire when a control is clicked (such as the submit button) and if any fail the user is directed back to that page with the error messages displayed. Check them out in the VS IDE, they are simple to use. drag them onto the page, link them to the control they should validate, set the validation check and the error message. They should cover most of what you need.

Your data source will need to be the actual location of the database, so if it resides on F drive you will need to include the full path to the file.

Hey,
Is your javascript trying to run before the js file has downloaded? You can compress your js and css files by removing all spaces and line feeds. This doesn't really save too much space if you are also downloading images of course.
If you need the page to load fully before calling scripts you can place the script that calls the function at the bottom of the page so it loads last and is called last (the js file will still be in the header of course).

In your HTML you define a new CSS class by using the class="name" element. For example:

<div class="div1" ></div>

Then your CSS is like this:

.div1 {
  // your style rules.
}

Thats the basic answer. Is that what you need?

Either PHP or Javascript can fix the particular problem with the linking. If you wanted to add more specialized functionality then server side code (be it PHP, .Net, ruby, etc) would be required.
If you aren't familar with any of these I would suggest outsourcing the job to someone who is.

Are you talking about checking in the database (you have access to it) or scraping an HTML page to see what is on it?
If scraping, you need to use the WebRequest class to retrieve the contents of a webpage and then parse through it looking for what you need. You can find plenty of screen scraping tutorials online.

If it is a long running procedure you can increase the timeout of your connection object.

Either use <span></span> to hold your date (removing the <div>) or change the divs to use display: inline-block. Either one will make the two display side by side.
Divs are block elements by default which means they don't lie side by side unless you style them to do so.

Add this to your CSS file:

table {
  margin-bottom: 10px // or whatever spacing works for you
}

How is your javascript? You need to create a function that accepts the selected style as an input parameter and then find the current page the user is on. The javascript command document.location.href will give you the full URL. You can then split that to get the actual page.
Rebuild the URL to include the selected style and current page and then call the redirect to send the user to the new page.

I've never had my actual grades examined by an employer (it may be different in the states), the fact that I can show them a degree has been enough. You can always make yourself stand out from the crowd by doing your own projects and showing them to potential employers or join an open source project and be active in it. There are plenty of ways to show you know your stuff.

For others that come along, I'm pretty sure the error was that bg was being declared as UIImageView in the property but as UIImage in the interface declaration.

To err is human but to really f**k up you need a computer.

The issue with changing the style and being redirected to the home page is that the links do exactly that - redirect the user to the homepage of the selected style. You would need to add some javascript functionality so the current page is taken into consideration and then a change to the style would redirect the user to the same page but of the selected style version. Does that make sense?

The SQL standard connection string looks like this:
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

What you have there looks more like a MySQL database connection string.

I'm not too familiar with joomla but if you view the page source and copy it you should (theoretically) end up with the structure of the page as standard HTML. Then you just need to link the CSS. I don't actually know if this will work but it would only take 5 minutes to find out.

I think to send from gmail you need to specify it (gmail) as the host and refer to smtp.gmail.com
This C# article shows it but it is easy enough to convert the one line of code to VB

http://blog.ysatech.com/post/2010/12/02/ASP-NET-Send-email-using-GMAIL.aspx

Look at line 34 in particular.

size isn't a CSS property or is font either. You would ned to use font-family and font-size in your CSS file for these to work. Why the mix of inline and external styles? Everything can easily be put in your CSS file.

Pagination can be applied to a repeater control. That'll give you the advantage of repeater control styling which would probably be a plus too. There is a bit more code to type but I think it would be worth it for what you want.
I have coded up pagination for repeaters myself and it's not too tricky but if you want ready made code check out this post that uses the PagedDataSource class:
http://www.4guysfromrolla.com/articles/081804-1.aspx

Are you wanting to start a service? Some code that runs in the background with no visual interface?

The stream reader will let you access the text in the file. Once it is a string you can do whatever you want with it

Are you including variables in your string? Syntax errors are easy to get if you don't watch your spaces and accidentally concatenate some text together.
Of course, you haven't posted up your SQL query so we can't give you very accurate advice.

Is the rowDataBound event getting called at all? It looks right to me. Or is it some code inside the event that isn't working as it should?

You will want to check out how to use the stream reader class to open a file (stream) and read the data.
The MSDN article can be found here:
http://msdn.microsoft.com/en-us/library/system.io.streamreader.aspx

What you can do is execute another LIKE statement against the database based on the characters entered in the text box and populate the list with the result. Then you only have the relevant LIKE items remaining. Items that don't meet the criteria are removed.

You will need another table in your database that stores the user ID and the time/date they logged in. You can then use that as a filter to extract users that accessed the system at certain times. A select statement joining your login times with the users table when do the trick.
If you wanted to actually monitor what they did while logged in you'll going to need at least one more table and also figure out how you're going to record the actions efficiently.

background-color is a CSS property so I would add that to whatever styling rules you are applying to those areas.
Did you write this code or download it from somewhere? You have a style rule floating in the middle of the page.
And your PHP session_start() code needs to be the very first thing on the page to work i.e. right at the top, the first line of code. You can't have it further down the page like that - unless my PHP is very rusty...

He was referring more to the fact that you set radioButton1_CheckedChanged = true
and then two lines later have an if statement checking if it is true or false. It can't possibly be false so the second part of your if statement never fires.

well, your connection string (where ever you store it) will need to point to the actual location of the database or you will have problems. If the connection string is wrong you will get an error for all tables though as your code can't locate the database, let alone specific tables within it.

It might be time to post some code up so we can understand the issue.

Normally you would use the background-color property of the div. If you want it to extend the width of the page set the div width to 100% (or whatever width is relevant if you only want to cover a certain area) and then center your banner and menu.
Does that help?

What error does it give and what exactly do you mean by 'different output'. The connection string you have in your app.config is exactly the same as the one you used in your class?

Access has a limit of 16 JOINs and that error appears when you have exceeded that limit. You'll need to find a way to reduce the number before it will work.

YOU MUST RUN THE FILE FIRST install.php

Are you using Drupal?

I agree. I can obviously work during the day but when I code at night I seem more focused, less distracted (maybe that the key actually) and I get far more done.

This happens because the cell it is looking to get a value out of does not exist. Nothing was extracted from the database (or whatever the population method was) and so it crashes when it hits the null value.
You can either use defaults in your database to remove the null instances (meaning every record has some form of data in it) or add error checking in your code that can recover from trying to access a null object.
If an entire column is missing you may not have limited your search criteria or loop length to the number of columns in the data table. This is most commonly done by forgetting that the lengths of these objects are zero based and so if there are 5 columns in the data table your loop should run from 0 to 4, not 5.

do a select statement for that record and use executeScalar to see if it returns 1 row or zero.

Looks fine in chrome on a mac

You can simply save the user with each role they have. The role would be another column in the log in table. Functions that have restricted access can check the assigned role. I think you were looking at how to give a user access to a database table which isn't what you need.
You mention you need to "create a profile/role for each specific user on my website". That makes it sound like every user will have a different role. If each user's role will be different why bother with roles anyway? Their user login credentials will set them apart from everyone else.