Posts by hericles

Your second example is much better. You were trying to fit too much data into inappropriate columns in your first post.
Now if you wanted to find all courses that were part of a particular meal you can use SQL to extract the data form the database by joining the tables.
Do you have a real example of what you are trying to do and so code to show how far you've got so far?

If you need each image to be in a div give the divs a CSS class that they share. For that CSS class set

display: inline-block;

This will your divs, and the images inside them, along the same line. Block level elements such as divs do not line up beside each other but stack down the page. Using display:line-block tells the divs to stop that and line up across the page.

They are just placeholders I used as I didn't know how you are extracting and storing the data before passing it to the label (dataTable, array, data reader, etc). Insert in there the data you are putting into the page.

You don't mention what control you are using to display the data but it sounds like you are outputting to a string, maybe a literal control. To make the data appear down the page (like a list) if you are placing string content on the page, you will just need to add a line break behind each piece of data.
E.g.

strData.Text = data1.ToString + "<br /> + data2.ToString + "<br />"

Is this what you are after?

Without knowing exactly what system you have used to create the drop down menu it should just be a case of setting the position to relative for the secondary list and setting a negative margin top that locates the menu in the correct position. If your menu had dynamic content (i.e. the number of links in the menu can change) this probably won't work as the height won't always be the same.

It sounds like the jQuery slider is something you might like. Check out an example here: http://tutorialzine.com/2011/01/how-to-make-auto-advancing-slideshows/

You'll need to post up some code. Without seeing whta you have done it is hard to give advice. The form load can call any other code it is told to, no button press required so you may have a fault in your logic.

You aren't linking the command object to the dataAdapter so your dataAdapter doesn't know what to do.

Dim temp As New SqlDataAdapter(cmd)

First thing to do would be to debug the code at the line comparing the two. Visually confirm they are the same.

Normally when someone asks for help on a large project we ask which part you are stuck on - we aren't going to do the whole project for you. There is nothing intrisically difficult about what you aim to do, it just has several component parts to it.
Do you know how to creat database tables? Handle user log in? Can you code SQL queries to select, insert and delete data? If yes, then you're pretty much good to go.
Once you get stuck on a specific problem we'll be here to help.

Use the float: left CSS command on the image.

Here is an example using the file upload HTML control handsome PHP

http://www.tizag.com/phpT/fileupload.php

This is a basic example of how you would connect to a database, set the command object and execute it:

http://www.java2s.com/Code/VB/Database-ADO.net/InsertdatausingSqlCommand.htm

Debug your code to catch an exception and see what the error actually is. That will help a lot.

You can change the location of the second image using position: relative and setting the left and top margins to the correct values so the images lie over each other (negative values are allowed). The z-index CSS attribute allows you to layer two elements over each other. The higher the z-index the more to the top the element is (i.e. a z-index of 10 will appear over an element with a z-index of 4).
So, if you had 2 images side by side on the page and wanted the right one over top of the left by 50px, the css would be

.firstImage {
   z-index: 50;
}
.secondImage {
   position: relative;
   margin-left: -50px;
   z-index: 100;
}

But, to fix the problem, remove the comma after user_pwd

Can you post up all of your code? Normally that error is accurate and so if it says the connection is closed it probably is.

Forget it... I didn't see there was this many pages. Ignore me:)

Its been a while since I've done that but the CSS should be:
background-attachment: fixed

In your post above where you said you still got the error you had renamed the command object to asccmd instead of acscmd.

Dim acscmd As New OleDb.OleDbCommand ' the oledbcommand
        acscmd.CommandText = strsql 'sets the sql string
        acscmd.Connection = acsconn 'sets the connection to use the oledbcommand
        acscmd.ExecuteNonQuery() ' execute oledb commands non query only
        acscmd.Dispose()

Copy that code and use it, you shouldn't get an error.

ARG!! beaten to it ;)

Maybe you have that cmd object declared elsewhere but from what you posted the name of the command object is wrong.

Dim acscmd As New OleDb.OleDbCommand ' the oledbcommand
 acscmd.CommandText = strsql 'sets the sql string
 acscmd.Connection = acsconn 'sets the connection to use the oledbcommand
 cmd.ExecuteNonQuery() ' execute oledb commands non query only

You declare and set parameters for acscmd but then call the executeNonQuery on cmd.

Has the database every been connected to and returned information or are you still in the building stage? Are you seeing any error messages?

The simplest way is to add a roles column to your database table (or create a separate table to hold this info) so when they log in you can extract which role they belong to.

Can you provide us with more info? This is really vague...

There is a little more to using a web service than dropping in a using statement. Is it a web service you are trying to connect to or a DLL component?
Using allows you to reference assemblies that may not be part of your default application (for example to use MySql databases you need to add a reference to the correct DLL and add the using mysql.data.client line).
If you are trying to connect to a web service it might pay to google a tutorial on how to do it.

You are missing the keyword COLUMN:

cmd = New SqlCommand("ALTER TABLE " + ddl_sub.Text + " ADD COLUMN " + txt_desc.Text + " varchar(50) ", con)

Personally I would use the repeater control but only because of the ability to style it using CSS. All of the controls you mentioned can do the job but I think a repeater would look best.

Considering C# is a web based language (C#.net) the answer is pretty obvious. Asp.Net can be coded in either VB.net or C# so if you know C# go right ahead and code in that.

You're missing the ' before the comma in this line:

sql += "'" + txtPostCode.getText()+ ", ";

Sometimes it just needs a new pair of eyes:)

Your problem lies in the fact that you check the user name and password, starting the timer and progress bar if they are correct, and then continue on to increment ctr and crr anyway. If the user name and password is accepted you want to step out of that code and move onto the next thing.
The easiest solution is to wrap the two code blocks in another if statement. If user name /password OK then continue else ctr increments.

IsolationLevel comes from System.Data I believe. Try adding that if you don't have it already.

If you have set it out OK it shouldn't shift when values appear. You can specify lengths, padding, etc for the controls so that the expected outputs can fit in them without them having to resize.

Can you post up your HTML and CSS so we have get a better understanding?

I'm not an expert with any of them (and haven't used Joomla at all) but it depends on what you want to use it for. Wordpress is good for blogs, article sites, stuff that has a lot of content served dynamically but doesn't require too many add-ons or e-commerce. Thats just my opinion - others will argue.
Drupal has a massive amount of plug-ins and modules, there's nothing you can't do. It is incredibly extensible but that can also be a curse. It is great for e-commerce and functionality similar to that but is almost always overkill for sites that are merely dynamic in nature and don't need specialized modules.
Just try updating it when you have extra modules added and you'll see what I mean.
Anyway, I hope that helps.

Im thinking the real problem is this line:

conn.BeginTransaction(sql)

BeginTransaction takes an isolation level as an argument i.e. an enumeration. You are trying to feed it a string. Try:

cmd.CommandText = sql
transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted) // or whatever isolation works for you

You can place divs side by side by using the CSS style display: inline-block; for each of them. This makes block elements act like inline elements (i.e. line up on the same line not under each other).

Any controls that you place on the page (the .aspx) that you want to use server side need to have an ID and the attribute runat="server". You can then access on the code-behind page by using its ID.
For example, if you had a text box :

<asp:Textbox id="textBox1" runat="server" />

It could be accessed with:

textBox1.Text = "Hello World"

If a control is clickable (such as a radio button, button, etc) you also need to specify the onCLick="someMethod()" in the .aspx page and then include the same method in the code behind. For a button it would be:

<asp:Button id="button1" runat="server" text="Click me" onCLick="button1_Click" />

code behind:
sub button1_Click(ByVal sender As Object, ByVal e As EventArgs) 
...
end sub

I hope that helps. The MSDN site is pretty useful when starting out (or at any other time...)

If you haven't disposed of the data source you could always use that to calculate the total. You can even do this before the button is pressed and store the total for later use.
Or this would probably work:

sum += CDbl(ListBox1.Items(x).Value) // or maybe .Text

You were getting the error because your code was returning a row view and not the value in the row (my VB.net is a little used these day so I maybe wrong).

There are javascript libraries that can detect if flash is installed in the browser. Find and use one of those. You can then detect if flash is there and use javascript to alter the CSS style of the div depending on the result (i.e. what you need to set the margin-top to).

You are setting result to 'Yes' which of course means the 'else' part of your if statement never gets called. Try:

result = MsgBox("Are You Sure You Want To Logout", MsgBoxStyle.YesNo, MsgBoxResult.Yes)

I think you would need to enter either the time the task was started and the time to complete or the calculated end time (as a time stamp) into a database. Then you could read the value whenever you needed to inform the player of the time remaining. I have the need to do this in one of my own projects (which is moving ahead very slowly) but I haven't got around to this part yet so I'll be interested in the responses.

Is the PHP file in the correct location? If you have altered the directory structure even a little then it would cause the file used in the require_once to not be found. Your folder structure needs to mimic the path shown in the error message.

Unfortunately the stack trace is of little value to us. Can you post up the code? Although if you debugged it and ran to the error you might get to understand where it is going wrong. From the error message something is null when it shouldn't be.

As long as your code isn't actually PHP post it up here and we'll have a look. If it is PHP you might want to try that forum.

Without seeing your code it really is hard to give good advice:)

You can use CSS to move the second one to the left:

<style>
sup {margin-left: -5px;} // or whatever suits
</style>

To JOIN a third table just add another 'JOIN tableName' and another 'ON...'

SELECT mm.stuid, mm.mark, sm.subname, sm.subtype, em.examname FROM subjectmaster AS sm JOIN markmaster AS mm ON sm.subid = mm.subid JOIN exammaster AS em  ON sm.examcode = em.examcode;

If it says the column name does not exist then it doesn't. Proper capitalization matters so you will need to check it is not lastName.

Doesn't really work that way, sorry. We'll help you with particular problems if you get stuck but we (I'm speaking generally I know) won't be too interested in doing the entire project for you.

The link didn't work for me. I guess you're saying that it only looks OK in IE. Is the layout that you see in the other browsers similar? Any chance of a screen shot?

Why are you trying to convert the value in txtEmpSearchLastName.Text to an int? I'm assuming it is a string. Change your code to:

cmd = "select * from staff where staff.LastName=" txtEmpSearchLastName.Text

You will need to break out the information into more tables. You will need one table for registered guests (an id, their name, contact info, etc) and another for bookings. The bookings table will have a booking id and a guest id which links to the guest table. Then a guest can have multiple bookings matched against their one guest id.
The guest wouldn't need to know this guest id, you guest table would need to contain enough info to accurately describe him (first and last name, dob, maybe cell phone or email,

Whenever you need to join tables you use the JOIN command and then specifiy which columns in the joined table form the linkage (are the same).
For your tablesto get stuid and subname the query would be:

SELECT mm.stuid, sm.subname FROM markmaster AS mm JOIN subjectmaster AS sm ON mm.subid = ms.subid;

The AS command lets you give shorter aliases to a table if you didn't already know. And you can specify a WHERE clause on the end if you need to. You should be able to add in the exammaster table from there, just use another JOIN and ON statement.