What database are you using? OLE is slow but may be your only choice.

Also use a reader (forward only cursor) instead of a DataTable, it's faster for this kind of scenario.

But, consider the...

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.

Hmm stinks of copyright theft. Tsk the ever more redundant web....

OMG, it took you over two years to improve by just 1% !!!!

Yep.

county
mutiny
tummy

spiritually

tendon
tenet
denote
toned

regulatory

revise
veers
sieve

navigation

I can help by saying wishful thinking is unlikely to get you very far. And neither will posting on the end of two year old threads.

I recommend you re-post in the correct Community Introduction...

(Holyl is now bald as a coot)

I think EXEC @tsql needs to be EXEC(@tsql) with parenthesis.

and getting the error:-
The name 'ALTER TABLE [] ADD []' is not a valid identifier.

To me this...

(Holly pulls his hair out ....) I see an important space disappeared in my second post! gah! ok use this:

Spot the difference:

--CORRECT CODE
SET @tsql = 'ALTER TABLE [' + @tablename + '] ADD...

The table must exist in the database.

Also you have now introduced spaces between the [ and the table name, you need to remove those, same for the column name unless you want lots of subtle bugs...

Here's a tip: amend the stored proc to select @tsql instead of EXEC(@tsl)


CREATE PROCEDURE sp_addcolumn
-- Add the parameters for the stored procedure here
@TABLE_NAME varchar(50) = 0, ...

Alter table can't take dynamic parameters. To do this you will have to concatenate the whole TSQL command as a string dynamically and then execute it. Also you don't need the COLUMN keyword.


...

Put your terms into Google, read the links and try it out. I put 'c# myql' into google and first hit was this...

We have that here too Jb (admittedly it's the exception to the rule) There's a great little private petrol station near me that fills your tank for you, but I rarely use it as their prices are higher...

Welcome to the crazeee world of browser incompatability :)

There is an ECMAScript standard (Ha ha ha ha laughs uncontrollably) which has been interpreted by browser creaters in a lot of different...

Google for programming blogs there's acres of material.

Steve Yegge (http://steve-yegge.blogspot.com) / Joel spolskey (http://joelonsoftware.com) and Jeff Atwood (http://codinghorror.com) are some...

You could wrap the C++ app as a plug-in.

Other than that... no not really.

Are you talking server-side ?

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...

:icon_eek: Is this a trick question?

What? I don't think so. I may be wrong but I can't be bothered to look it up.

What I do know is:

- The Data Protection Act is grossly misunderstood in the UK.

- You are obliged to provide...

No her body has been overtaken by a particularly nasty parasitic xenomorph from the lower quadrant of Andromeda, It's posting here to avert suspicion, but I know my LGM's :)

This is quite a coincidence, because I have ended up with a new keyboard by accident this weekend. Let me explain.

I don't very often have to work overtime on a project (thank goodness) But every...

It depends on who your asking, relatively speaking.

Why are the buses in Canada so weird ?

(I mean if Steven mistook the drawing for a retreating bus .... )

What bus? it looks more like a UFO to me :)

Why do we call it 'cracking' a window when it doesn't break?

Look into SqlLite (http://www.sqlite.org/) its free and simple and can be packaged with your app more easily.

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, '') +...

Aha, you are using a strongly typed DataTable.

You must be handling the DBNull somehow otherwise you would be getting an exception when populating the table.

Have you tried just == null ?

Hmm... well it works for me. You'll have to post some code or give more information.

Dont have the radio button in the control. Use a repeater to render radio button, user control pairs.

You need to compare the column value with System.DBNull.Value

So assuming a DataTable for example:


if( myDataTable.Rows[0]["someColumn"].Equals(System.DBNull.Value) )
{
//Handle...

Do you have a welcome thread? If so I can't find it.

I didn't, this thread originates from my birthday in 2007. But I didn't find it till the 30th of march that year.

A year passed and it got bumped again by Sullys Boo, for which I was super chuffed!