greeny_1984: Well that would just exhibit the same behaviour as whats currently happening. But you're on the right track.

Image buttons are rendered as type="submit" which means when you press the...

Stored procedures need to be created using the CREATE PROCEDURE statement and then executed (F5 or the green play button in the toolbar). They are compiled and stored in the database itself. If you...

I managed a couple of months over Christmas, but am smokin' again. Thinking I will never quit now. One more smoker in the world... again.

Yep.

It's late and I'm a little blurry. But from what I can see in your query I think this: tDocumentsA.user_id = tUsers.contact_id should be: tDocumentsA.user_id = tUsers.id (the same for all document...

It's just a preference. I like things to be as loosley coupled as possible. I prefer to bind to collections of objects, rather than strongly typed datasets. Like most things it depends on what your...

Oops perhaps you are doinf a Forms project not a web project.

I have started a forms project and I can't get the binding source to use the new query either yet. I am too tired at the moment.
...

The query has the single column you want 'Expr1' bind the textbox to that.

I am not very knowledgeable with BindingSources I am afraid, I don't like them. I prefer to have simple business objects....

SELECT Name + '\n' + Street + '\n' + ZipCode +'\n' + City
FROM Customers
WHERE (CustomerID = @1)


This assumes none of the columns allow NULLS. Otherwise you will need to use ISNULL(name, '') +...

Oops we posted at same time. When restoring you will have to tweek some options: 1. the name for the database (cos it doesn't exist on the new server yet) just type it in the drop down box. And 2....

Right click the database -> Tasks -> Back Up...

More info here (quite a way down it looks at SSMSEE in depth) Just CTRL + F for 'Backup'.
...

Do a complete backup, copy the file to the other server and restore it there.

Or you can detach the database, copy the .mdf and .ldf files zip them up and copy them over to the new server, unzipp...

MS Access !! yuck !! You didn't say you were using Access, and as this is a MS SQL Forum I used TSQL.

Ok just for you I have recreated everything in Access and tweaked the SQL. Basically removed...

That works. Also there is TSQL's ISNULL function.


SELECT
ISNULL(FirstColumn, '') + ' ' + ISNULL(SecondColumn, '') AS ResultColumn
FROM
mytable

Excellent. Please mark thread solved :)

Fee Fi Fo Fum I smell the blood of a Tsql Cursor, be he slow or be he slower, I'll grind his bones with my set theory mower.

Sorry I'm on a personal crusade against cursors :)

I offer my own...

ViewState is held in a hidden field within the rendered webpage, session state is held in the memory of the webserver. Each session has a unique id called a sessionid. The sessionid is given to the...

Hmm re-reading your post that may not be quite what you want, you want lowest quote regardless of vendor I think.

select
q.[ID],
q.item,
v.[name],
mq.minprice,
v.phone#,
v.fax# ...

Firstly just join the quote_tb to the vendor_tb. That gives the vendor details for ALL quotes.

Then use GROUP BY (to merge up all the repeating colums (ID, item, name, phone#, fax#) and the...

This is due to windows integrated authentication (NTLM), although you are logged into Windows those credentials are not necessarily automatically passed on when required it certain circumstances....

httpd.exe *IS* Apache. End the process in task manager and then try starting Apache again.

Type netstat -a -n -b at a command prompt this should list listening ports and what executable is listening on it (thats what the b switch does, mine shows inetinfo listening on TCP:80 which is IIS)...

Wow! well how you can read 15 hours of ASP.NET getting started and surmise that merely changing the file extension of an HTML page is all that's required seems improbable.

But what the hey. Ok you...

The problem is you haven't researched ASP.NET properly.

Use Google (or your favourite search engine) to search tutorials like this:

http://www.sitepoint.com/article/getting-started-asp-net

Only one application/service can listen for a given protocol on a given port at a time, what on your computer do you have other than Apache that might be serviceing HTTP on port 80 ? IIS for example.

I think something else you have installed is listening on port 80, browse http://localhost what do you see ?

I can't understand why you can't get web controls to appear on the page. Can you post some code?

p.s. Do you know about the empty data template?

I've replied in your other thread.

How are you 'Browsing' your ASP.NET app ?

You don't need IIS if you have Visual Studio 2005 Express Edition (any edition 2005+) It includes a web server. When you run the app from VS (F5 to debug, or Ctrl+F5 to run without debugger) it...

Well that's what 90% if the software world is using. Hell I'm still maintaining Framework 1.1 projects.

Back in the time of classic ASP, one day I found myself conactenating <tr> <td> tags in a...

Why would you not use the web controls?

Look at the System.Web.UI.HtmlControls namespace there's HtmlTable objects and HtmlTabkleRow and HtmlTableCell, just foreach your DataTable into HtmlTable...

chuckle,

People don't use code tags. Browsers miss-implement standards and have bugs.

Can you get all the people involved together to fix this problem? How much of your precious life do you...

kings should have used code tags, which would also solve the problem.

select TOP 10 somecolumn FROM blah...

He he, I didn't have a C++ teacher! I do know what labels are but I don't think I've used one for years let alone used one in C++ which is why I was stumped. I should have STFW ;)

So far your friend is right then!

Ooh that's so cruel.

What is 'start:' I'm no c/c++ expert but that doesn't look like valid syntax to me.

Also you need to prefix cout with std:: or put a...

Yes that's right. xampp is for Xp/Apache/MySql/Php I can't remember what the extra p is for, possibly PhpMyAdmin for administering MySql with a GUI.

You don't need IIS for SQL Server to work.

If you use Visual Web Developer 2005/2008 Express Edition, they have there own embedded IIS web server called WebDev.exe that runs automatically when you...

Well UI Design is not specific to any platform really. But what about this?

http://msdn2.microsoft.com/en-us/library/aa350483.aspx

How about this?

http://www.developerfusion.co.uk/show/2084/

Do I get a dollar for my research fee please ?