Comments by Andy Lanng (Top 200 by date)

It's not easy to post HTML directly into these forums because HTML is also used in formatting. Try constructing the demo in https://jsfiddle.net/ so we can see the whole thing, then post your unique jsfiddle url here

Oh wait! did I misread that yesterday? You're using ReactJS, node React for NodeJS. Sorry, this answer is not suitable for your current issue.

believe it or not, me too :) I'm pretty fascinated by React at the moment.
There's a link on that page to "Demo Source" which is a complete component that used the library. The "Demo" is pretty simple to debug with any browsers dev tools, so you can see it in action.

could you set this up on https://jsfiddle.net/ (or something similar) so we can see you're code and styles in action please. You haven't told us what styles or libraries you are using here

OOK - ok, but he should background it ^_^
Nah, your right. Maybe someone will find the link useful looking at this post

There's not a lot we can tell from your code snippet. If your issue was a logic problem then a code snippet is handy, but for html design it's more tricky. We have no idea what your css says or how the styles are set in the snippert. You will need to show us the issue.
Try looking at https://jsfiddle.net/ where you can add your code, recreate the issue and ask for help in an area that we can look at and try our fixes. I think everyone here trusts jsfiddle so you can feel free to post a link here.
I hope that helps

Whoa, slow down there.
This isn't that kind of forum. Usually we answer questions like: "I tried this, expected this, but got this exception".
I suggest you take a look at some of the articles here on how to setup a form, how to read from a database, how to query a database and build your program in small steps. If you get stuck then let us know:
1: What are you trying to do
2: what you expect the result to be
3: What went wrong
We'll be glad to help when you have a more specific issue
Here's a good place to start: https://www.codeproject.com/Articles/4416/Beginners-guide-to-accessing-SQL-Server-through-C

I don't have time to code it code it for you, but I suggest you keep track of when your specific device is connected, then when a device is removed and none of the connected devices are your device then disconnect it.

The events fire for each usb port. it's up to you to decide what to do when you device is connected or not

The JSON is at most 875 chars long, including the spacing. The 2345 number seems to indicate that this is not the full JSON.

What do you mean "the code below fails"? Do you get an error message? what line fails?

Me too! I tried many different ways to get the result you saw but I never got anything other than 419404 seconds (116:30:04). As the immutable Griff says, your input data can't be the data you have shown us.

It would work if you are running as a user that has already logged on to that server, either via a mapped drive or any other "explorer" style method.
I'd tell you to use sFTP if the machine isn't local or use a mapped drive if it is.
You can run scripts to map a drive, then have your app run that script when the drive isn't mapped for the user it runs as

Betty Crocker Chocolate Chip Cookie Mix 17.5 OZ XD

It looks like your adding the controls dynamically. If so, can you show us the code you use to generate the labels, please.

you may have a point there. I haven't used the forums before so it might be a good idea for me to start ^_^

Thanks for your input. I'm sure that this is a great answer for someones question. Are you sure that you meant to post it as a solution to mine?

Whoops yes. Made the same mistake in my clr function too

Usually we use our own internal guid. The issue is around a Sync-Service that isn't aware of our Id so has to use it's own primary key: the itemcode >_<
Ok - I tried several approaches:
Custom Routing: This used to work (was always complex), but in later versions of .Net it has become untenable. It's far too much to introduce to our project.
CatchAll route: "items/{*itemcode}" would be fine but be do have url paths after the itemcode ("items/{itemcode}/bom"). We could change the order of items but we even have the complication of "items/{itemcode}/{bomitemcode}" which breaks that option in our case too.
Base64 encoding: This is the only case that would work for us. Any 'non-url' encoding would suit, but my team didn't like the idea (they're an odd bunch, but I do have to keep them on-board)
The solution we are going with is to not have the itemcode in the url at all. We will use our sync service post (add only), patch (update only) and put (add/update). Frankly I don't like having a "put" that doesn't 'put' a url in, and I don't see the point of having separate httpmethods anyway, but again: Need to keep the guys on-side.

Thanks for everyone's help. Some really good suggestions here that I'm sure someone will find helpful ^_^

Encoding is easy enough ("/" becomes "%2f"), but keeping it encoded through IIS and MVC Routing isn't :S

Not a bad shout. I'm going to keep that in my back pocket :)
I'm gonna try to crack into the RouteCollection to see if I can invent some middleware that can cope with encoding data in the url first. I'll post my results

from C# EncodeDataUrl(url) will encode "/" to "%2f"
First issue is that IIS decodes it. Using Url rewrite I have fixed that but then Routing decodes it too.
Double encoding is a pretty poor solution as it would open up all kinds of shenanigan vulnerabilities.
The issue isn't encoding, but how IIS and MVC decode.

Where is row_number used here? You've stopped making sense. It's usually at this point that we ask you to talk to your tutor because there appears to be some misunderstanding of the basic principle

XD

No, without the joins you cannot get the null values

Pretty sure this is the same assignment me see this time every year. I don't think changing the structure is a thing they can do
The joins are wrong but so is the data if that's the expected result [2,B,ddd,null] would not have null.

yup - I missed the data - I see it now
What result do you get from the query in "What I have Tried"?

What is the data? what is your output from the current query? what is the problem?

^_^

This is included in my current solution (although I do use decimal).
I need a single solution that can take care of tax globally. One solution for all.

Florida is no different. My client is.

starting with the price + tax. I need to get the price. If I know the tax (i.e. 8%) then to get the price only I need to divide it by 1.08.
The issue is that when there is a limit to how much the 1% tax applies to, the total tax % will be somewhere between 7 & 8 %

Thankfully no shipping ^_^

first:
2500 + 8% = 2700
so
2700 / 1.08 = 2500, which is what I wrote
second :
so 5400 of the total was the 5000 charged at 8%. That means that 5400 of the 10000 has been accounted for.
this leaves 4600 to be accounted for in the next tax bracket

I like that idea ^_^

sounds like a connectivity issue. I'm guessing the sql server is on a different machine? if it happens again, try pinging the sql server from the iis server

No idea. Why not show us the error?

agreed

Ooh - didn't see that one. Looks perf ^_^
Thanks

Oh thanks. Didn't look at the first link on google at all!

Ah - Then my response won't help but neither can I :S

Best of luck ^_^

ooh - thing is: the number of options (flags) is anywhere between 10 and 60 (hence bigints). Does this still stand up for performance pivoting so many columns?

huh. Cool. The more you know... ^_^
Thx

Both of your solutions are correct. Try looking at the char value. Isolate the space char in the string you have in your example and try ASCII(theChar). You can use that value in your replace "Replace(Char(32),'')" for example

Oh - I see where you got it from now ^_^

Viola - updated below

tbh I wrote this 3 years ago. 2017 didn't exist (the year or the vs version :Þ)
I'll take a look, see if i remember what it does and correct it in 2017.
->
Looks like it worked for the op

Please don't put codeblocks around every segment of text

How to inhibit access on one direction? Take away their backstage passes ^_^
One Direction

Click "continue".

You want a script, or instructions of how to do one-off import via the wizard?

It's always something simple I just don't see >_<
Ta that worked ^_^

You need to look at the code behind. This is the example.aspx file. look at the example.asp.cs file!

look on line 90 of the example.aspx.cs file

Try to avoid including any avoid "secret" information in your posts. You never no what someone might piece together

Yes. He gave you the link!

Do you want both ints or just the non-zero?

Please don't shout. I have changed your question to the correct case.

It doesn't like the parameter with a space. Change both [@sap code] to @sap_code

In the U.K. There is no official cheque format. As long as it has the minimum detail you can shave it on a cow, though banks do have the right to refuse bovine tender. Find a blank cheque, find what the minimum requirements are then make a report, document or form that looks like that

Not really. Either is a good solution. Store it in a DataTable or DataSet if you like. I doubt you'll have any concerns with such variable type in a client only app.
Sounds like you have a sound plan now. Good luck ^_^

I get that it's win forms. To cache permissions you just load them all into memory, any way you want. If it's client/ server you can do it server side, if it's client only then just load them in the client.
If you want to load them per form the you will need a way to select out of the db all the permissions for that form at once. That way you're not hitting the database as often

Can you show us your whole code, please. Most likely the issue is when and how you disable the ddl

Yeah - That's kinda the conclusion I got to. The images are supposed to be high-res (dunno why they chose jpg!). Space doesn't have to be an issue. Just adds to the cost.

Thanks for getting back to me ^_^

A: you didn't read my current solution
B: your answer offers me no more information than I gave
C: jpeg has compression levels. You can easily achieve much higher in a zip. Also, each zip file contains hundreds of images to better ratios are likely. Try 80% compression ratio
Sorry to sound harsh but you really didn't answer my question of how to return the stream from ZipArchiveEntry.open() before disposing of the archive

Ahh. Iot was set. Hmm wasn't clear until I saw the home page. Ta 😄

You can't use code behind 2d arrays in JavaScript because they are very paranoid and might get scared.

On a serious note: what are you talking about?

Oic. The signal id in unique! Nice 👍

Q: How many Prolog programmers does it take to screw in a light bulb?
A: NO!

Get it? or does it need explaining; much like your question?

OMG: You can't post 465 lines of SQL with a 33 word explanation. Nobody would be willing (nor able, probably) to unwrap all that!

Either add a TON more explanation of what the script does, in the question description or in comments in the script, with example data, or break the script down to exactly where the problem lies. I'd suggest doing both or you will get no attention on this.

Use the "Improve Question" button to add a LOT more detail!

I have no idea what you are asking. Please try to rephrase the question

see OP's response

You have to reply to peoples comments so that they will get a notification. Use the reply button on their comment

Doesn't instagram remove EXIF? most of these images are posted there :S

Sorry - updated to clarify #^_^#

Sorry - didn't make this clear - the image is published by, and is of an item owned by my client, not just any shiny thing

Updated. I can't be specific about the nature of the business

Please phrase your question in the form of a question ^_^

Looks fine to me. No error

The date is correct (in milliseconds) but can I see the full json text or is that it?
Looks like the json is getting mangled somehow
You should still be able to parse the date out of it, but it would be better to solve the issue.

I have updated the solution. Sorry I don't have time to fully test >_<

Without changing the routine, it was the only choice. Well done for getting through it and thanks for accepting my disappointing answer 😊

Ooh - you use another cool array feature called "map".
like this:
$scope.Products = JSON.parse(response.data.d).map(d=>new ProductClass(d));
How cool is that!

This mostly came up in the chat on the last question (your link): Basically if the dates cross midnight then that is a whole day, so 11pm - 9am is 1 day but 11am - 9pm isn't

Do you know how to debug the script?

There are several errors that you need to be able to find. In Chrome and IE you can press F12 to get the debug window up. You can see errors in the script and even step through it with break points to check the values.

For Firefox you need an extension called FireBug, but it works pretty much the same as the other two

I think the best way is to cast them as dates, i.e. let d = new Date(p.date).

I would use a class and constructor to format the object after it has been deserialized. Look at the new jsFiddle for how to do it: jsFiddle.

Note how I convert my test to a string. This is just to simulate the data you will get from your json. I convert it to a date type in the constructor as you should

Make sure that you populate $scope.Products as soon as you have the data.

It may be that your angular app isn't triggering a refresh. There are ways to trigger one

I have a function in my example called getTestProducts(12). That populates $scope.allProducts. This is never used for anything other than to refresh $scope.Products.
If you copy my code and populate $scope.allProducts from your ajax call, then it'll all work as mine

It doesn't reset the filter because you are wiping over the original list each time. Check my fiddle. See how I do it.
1: take a copy of the first set (allProducts) - never change the first set.
2: use the second set (Products) to construct a new set (newArray)
3: change the second set (Products) to point at the new set instead of the origonal

whoops - fixed it
https://jsfiddle.net/bxrwnb7z/1/

Hi :)

PS: to add code you can update the question. Just please add an "UPDATE" note to your changes ^_^

try the new fiddle: https://jsfiddle.net/bxrwnb7z/1/
Let me know if this works for you

Yes the browser does make a difference. I think it's the load order when building the dom. My JSFiddle doesn't work in my version of IE

Wait - maybe we're getting our wires crossed:
Are there two different products with the same ID? then how to you identify that they are different. I thought that behavior was desired. If I'm still wrong then please let me know

Visual Cobol for Visual Studio (V 2.3)? ha ha - that's prolly the same guys :)
If you have one then don't worry about PE.
I don't understand why you want your C# code in COBOL code, tho. Create a C# class library project and add your C# code there. Reference the classes in your COBOL then just call the methods

I understand your problem. The JS Fiddle works correctly for me. I cannot see the problem you are having. I cannot recreate the problem you are having. I cannot see what you see. I cannot help if I don't see the issue.

What Browser are you using (name and version)?
Do you have any other scripts running?
What environment are you running from (IIS, Appache, just opening the html file in a browser)?

I cannot help until I can recreate the issue!

Look at my jsFiddle. I took your code and I cannot make it create two rows with the same ID. There must be something else going on outside of what you have shown me

It has nothing to do with the inserts

Very high praise indeed. I'm glad that you feel more confident in your understanding :)

Oh, I don't see it ?
Can you post the link plz ^_^

Well, I've fixed that up as best as I can: https://jsfiddle.net/x4j6s99d/6/
At the end you're trying to access the innerHtml of a textbox? There is no inner html

No. The issue here is that a timespan has no reference to when it starts or finishes. between 11pm and 9am there are 10 hours. 10 hours is the only detail stored in a timespan. It's the exact same object as 11am to 9pm the same day

You would need to compare the dates as a part of the equation. For I full answer I'll need you to post a new question :S

note this line in your code:
span.innerHTML = '<button id="btn" onclick="getdata()">GET</button>';
change it to
span.innerHTML = '<button id="btn">GET</button>';
add the code snippet below

No problem. I have posted a second solution.

You should look into jQuery. It makes things like dynamic forms (and document manipulation in general) a whole lot easier, and there is more help out there for it nowadays

ah - i see. Ok - next solution

Huh? I just did

Either that or add a Where not exists (select * from t where id = @id).

the command command.ExecuteNonQuery(); returns an int of how many rows were inserted. If this is zero then it already existed. It's a bit longer winded in code but cuts down on sql calls

Also, why is your script link in such an odd place? have you tried moving it to a document.addEventListener("DOMContentLoaded",function(){...});? it may solve all your issues

What browser are you using? JsFiddle works fine in Chrome and Firefox. Not at all in IE. That might give us a clue.

What do you mean "next time"? take me through the process one step at a time

5* comment!

Question updated

I see you're quite new to this forum, so please take these notes kindly
Please don't post large amounts of code in comments. It loses all formatting and can flood the discussion.
Use the "Improve Question" button that appears below your original question to add details such as code blocks
When replying to someones comments, use the "Reply" button next to their name in their comment. This way they get a notification that you have responded and can reply back.

Thanks ^_^

Oh good. I was worried I sounded a bit flippant. I'm glad it helped :)

Can you add the source back in and make sure you "paste as source". Looks like the tags have been wiped out

Nice one ^_^
Well done !

I have told you clearly exactly where your mistake is and clearly and exactly how to fix it.

Anything you want to happen after the successful ajax call, put in the success function
Anything you want to happen after an unsuccessful ajax call, put in the error function

Anything you want to happen after other success for error, add to both functions.

Well, as you can see from the jsfiddle, the code you posted is sound. Perhaps it doesn't run? Try debugging it in chrome or firebug. If you're unsure how to use those then try putting an alert in there.
If you find that it doesn't even run and need further help, post more of the code and markup so we can see the larger scope

I think you're doing it wrong :S
In my code, I have no more than 1 controller per page. I have directives for controls I use. I have one for Invoices which are repeatedly rendered, another for my signalr management, and yet another for my file upload. Controllers are specific to a page (or segment) but Directives are specific to a single control which can be reused in many controllers.

If you insist on not using a controller for your file-upload script, then you will have to include it in the page controller and specify the elements with selectors.

then var result = json1.Insert(json1.indexOf("}"),", message-Table: " + json2)

You may need to play around with the string, but it's just string manipulation. Look at the result and adjust accordingly. meet me half way!

Update the column contents:
Update "table"
Set "column" = "0" where "column"="00:00"
Best would be to use case tho

Well I guess you could try some direct string manipulation : Solution 2

Why do you want to avoid using a directive? That's exactly what they are for.
The "why" might help us find a better solution for you

Don't use pivot. What you want is not a function of pivot.

I think your best option is to use pivot :
Using PIVOT and UNPIVOT[^]

You can use try block

If you can: please translate your comments to english. Sorry, but I only speak tech :P

I can run this thru google translate if need be

..:Your English is better than most English ppl I know

Oh, Are you a French speaker? I'm not btw

Perfect - I will look into this first thing.

Thanks for your help

PS: it is now 21:30 here. What it your timezone by comparison (I'm GTM DS). I don't want to leave you hanging as we can work together to solve this in the most simple way ^_^

Oh so many. could you make my life easier and give me a script for:
creating the tables and relations. You can do that via sql mgmt studio
plus give me some sample data to fill the tables. Just so I can recreate the example you have given

I can give advice without, but it'll take me a while to set up examples. I don't think giving you abstract explanations will be very helpful.

If you think otherwise, then I can post a revise, but it's quite late and you will only get a response tomorrow (10-12 hours) either way.

I have subbed to this feed. I can solve this. I wont leave you alone!

I'm bad at php, but with the non-coded line breaks, it looks like much of your code was lost in an html conversion.

If I'm wrong then ignore my post; else please use the "Improve Question" link above and make sure you encase your html / php in code tags (links above)

For eg - If I add a br like then you dont see the code, just the effect (i wrote

< br / >

but without 'pre' tags))
The way to show your code is to add the start and end tag called 'pre'

Anyway. In case I'm wrong I'll end my comment here, or here, or at the end, or trolllll ^_^

Phonegaps was not in your question. No that probs wont work

But wait - even the JS fallback? It has the regex you need, doesn't it?

Oh. One more thing... What tool did you use to create the procedure. It is extremely inefficient. It might be quick now it is is sooo un-scalable for larger datasets

Yus - As CHill says, post the code here where you can. Great for the Schema image, but if we want to test then it's best to let us copy/paste. Everyone here is here voluntarily and making us type more than we need to discourages interaction.

If you want perfect interaction then you could even post a script to create the tables, relations and test data. More work for you but it's one persons extra mile verses everyone else's extra mile. Besides, hopefully you know how to script that from your existing database. It's easier for your you, 1 person, than it is for all of us to each try the same. ^_^

PS: welcome. We're here to help :Þ

What should it be? In order to do what?

If you're posting to a web service then the users auth carries through. If you want to post anon then you seed to set anon and auth (if auth is a thing).

Basically: we need more information on the problem. please explain further

Great reference. I remember this from ComSci. It is the basis for a basic compiler too, but that's just how I remember the course.
5'ed for ref.

if you an place a bespoke client on the client machine then, well, the answer is right there

This is correct: No way to specify download location client side. This detail is handles by the browser only, as per [the] browser specs.

OP gone again? that's why so few solutions highlight O_o

extra credit: based on the send state: ["forehand", "backhand", "lob",...], limit the resend. should take two more lines (ignoring syntax) to achieve, but not limited to

Misread is understandable. Misunderstood is an issue. Admitting either is admirable. further understanding is learn-able and achievable. Buy Coke
Oh s*&t got into slogans again :P

PS: I think the OP is no longer here

Ooh. that might be it. But then the OP would see a form change. The OP didn't mention that, but that is where I fail and House finds fault (2M points if you get the reference)

PS: you can "discover" the form state on a button click, but with (asp?) it's easier to submit. This is why, as an ASP developer myself, I never use ASP.Net!

I wrote the word "that" on a board
I guy called That wrote the word "that" on a board:
"I saw that 'that' that That wrote".
Now the word has lost all meaning to me

not true. it reads from the first cell on each row. read the code again (I too hate ints in code and always have the knee jerk reaction that that is where the flaw is).
BTW: how many "that"'s can you fit into a sentence in a row (hint: the record is 15)

ur my guurd. I hate seeing static ints, but here it's fine.
The issue must be in when the function is called.

Button1 click does not update the form. it acts on it. I feel that the issue is that buton1 does not submit the form so (asp?) server side does not see the change. Can you confirm this?

Just read up. news to me. 5* on you comment

I was nervous about posting this here. Ok - Ill remove

Sir, you have dashed all my plans in one sentence *cries*

I put an optional delay of n% on words over m letters. words over 3 syllables are a lot rarer than I thought so t barely matters. I put gave too much attention to a problem that doesn't really exist

No problem. I remember when I first came across this.

Don't forget to accept the answers so people can find the solution for similar issues (and so we can get those lovely points ^_^)

Doesn't even work for "everyone" with full access

Checked the new folder and child folders. Both MSSQL user and Network Services user propagated with full access rights :/
I'm gonna dig into the error and see if it'll tell me which user it's actually trying to use

No Luck with Netwrok Servies user either

Ha ha - my user ID is not MSSQL$LOCAL2016
I used Configure File System Permissions for Database Engine Access[^] which told me to set uo the instance user ID. I will try "NETWORK SERVICES" suggested my your link, but VS just crashed... again. 2015 seems to do that once or twice a day. Time for the 2017 move, me thinks.

Can you be a little more precise?

This is not an appropriate question.

We will not do your work / assignments for you. If you have a specific issue then we can offer help and suggestions. You should also take advantage of your teacher / tutors. They want you to learn something specific from this task so they are the best people to ask for guidance.

Show me what you have and I might be able to help

I may have missed 3 letters but that was all from memory. Sheesh I need a break

What sql language? T-SQL, P-SQL, MySQL...

a few questions.
Is this T-Sql (mssql) or some other sql?
what data do you have and what do you expect.
I would like to know so I can try to write a solution that fits. With t-sql it should be very simple

It's entirely up to you. I just wanted to let you know that I don't use one and the reasons why. I don't want to appear to advocate for any preference as any approach could be fit what whatever approach you need it for.
In other words: You do you ^_^

Full disclosure: I do it as Griff suggests (although I do it client side).
The issue here is that the regex gives you a YES or NO answer. My passwords have instructions next to them (a list of: "Must contain at least one Upper Case", etc) that I highlight in red if not passed. It gives better feedback to the user.

ah no worries. It's just a joke between Griff and I. I post 0.0001% as often as Griff so I tease him for out posting me, which is inevitable ^_^

Np - it looks like Griff got in mere seconds before me,... again >_<

cool will do. ta ^_^

a few questions:
What was the error? What did it say?
Are you sure that auditTemplate.AuditTemplateQuestion is an array at the time the filter runs?
Thanks

Yeah, we even have a licence with them. I went there before google.
I must be missing something. I just checked it out again and cannot find the controls to eg: change the data x axis etc

Hi, thanks for the reply.
I was actually looking for a solution that allows my customers to create custom reports via the portal

Oh, PS: I will accept this solution if none other is posted by the end of the day

To use interope, yes. To use solution #2, no. Interope is faster than openXml for large datasets

Sounds like the problem may lie elsewhere. Post a new question to get attention. I'm not very good with Crystal so I can offer very limited help :S

updated

"I am missing something here" me too...
So the tags table has a column for productid. This is the foreign key. The product id must exist in the products table.
You insert a product, get the inserted product id and include that in the tags to insert.
If you follow those steps then you will not get the error. What are you missing?
Maybe post your code?

Oh Wait!!
dang, I don't use that on the production server. It still needs licence!
Hang on - I have an OpenXml solution. will post

Hmm - shudda been built in.
Grap the dll, wherever it was downloaded to and paste it in to the bin folder of your service

Ah! Seems so simple now #^_^#

In that case I think there must be some sort of race condition. Look at the second query: You set r to be the result of the ExecuteCommand, yet it only has a value after you submit changes. There is no await or async style code I can see on your end.
Try adding Thread.Sleep(100); in place of db.SubmitChanges(). If that works then there is some (odd) race condition.

Try writing it like this (pseudo code):
int r;
using (db){
..r = ExecuteCommand("text");
}
if(r>0)
..do stuff

That way you know r will have returned because it must complete the query before disposing of the context.

The syntax looks fine (although I question your table structure, but that's outside the scope of your question).
Have you tried changing the where clauses into joins?
It must be that data that's wrong. It looks like one of your answers might be null? That would cause any comparison with the '=' operand to return true.

You say you simplified this query for our benefit. Can you simplify your data for the same reason? If so, test the query again yourself. If you still get wrong answers then please post the whole query and the test data.

Is this just a really cut down version of your code?
If not then why not use the L2S object insert method?

Good points and nice cleanup - Thanks RD ^_^

NP ^_^
Please take a look at Solution 3. Learning to use the debugger in invaluable!

have you tried linqpad? I hear good things but I have not tried it myself. At least, not it's current iteration.

The first line of the message is telling you that you have linked angular scripts more than once. This is not great, but angular should be able to handle this and only load once.
I would suggest ensuring that you have only one of each script linked.
The next error suggests an issue in the loading of the FileUploader script. I can't tell you any more without seeing the code

Ah, what you're doing above will insert into the first column unless you specify the columns
insert into tbl_seat(col_id, col_2, col3, ...)
values (@is,@A1,@A2, ...)

If the id column is an identity column then why are you inserting an id?

Start the loop or timer in the Hub constructor. It will start once (because your hub should be a singleton) and wont stop. Consider this intended behavior. I would choose a timer personally, but it shouldn't matter.

The Hub stores each connection on connect and removes them on disconnect. If you broadcast to Clients.Clients then only the connected clients get receive the event because all other connections don't exist :Þ

yeah, pretty much. I wouldn't do it that way but I see no problem with it :~)

Your timer interval is 6 seconds. There's no point creating 1 per connection because they'd be firing constantly. Just have 1 timer that broadcasts to everyone who happens to be connected.

Your question is VERY hard to read. I think the answer is 'yes' but without ANY detail I can't be more specific

err... you... but... aaahhhg - so many things wrong!

The hub is, or at least should be a singleton. You can't create a timer per connection this way.

Without knowing more about your system, I suggest you keep the timer running and broadcast what you need constantly. Don't turn off the timer for everyone just because one person has disconnected.

This also means that you should start the timer in the constructor rather that when someone connects. That way pain lies

Oic! So you save the img to a server path, add that path to the db, then when you delete from db you also want to delete source file. Gotcha ;Þ

replace (path) for (strname) then put that line where you want to delete the file.

I suggest you do it after writing it to the database. You haven't posted that section of code so I cannot rewrite it for you