Search:

It really depends on how you need to use the data (I'm always very data-driven, so how I'll use my data decides how I'll design).

The advantage of splitting stuff up into columns/fields means you...

Without knowing anything about the query or circumstances - I can only suggest working on fragmenting it into multiple smaller queries.

If you want to do something with an exception - even ignore it, you'll need a catch regardless of performance. (which basically is only a factor if an exception occurs)

Been a very long time since I've done any DTD, however I'd say your example XML looks wrong to me.
Is that taken from a real example/requirement or is it just something you put together to try and...

Divide the task into subtasks and solve them one at the time.

For example:
First - make sure you can postback when your checkbox is clicked (there's a property you can set on checkbox'es that'll...

Make the content from other pages into a UserControl instead of a full page.
That should make it easier to place within your update panel.

UserControls are good when you want to reuse the...

It's different whether you use C# or VB.NET.
If using C# it is \ if I remember right (can also use @before a string)
If using VB.NET an additional " will escape the following ".

Take a look at the example on MSDN:
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.sqldatasource.aspx

I've never done something similar to that, but my guess is that the reason your button is overwritten is that you use the same button variable


Dim NPB As Button

Therefore by assigning a new...

C# in asp.net works as C#.

So the problem is with the input.
My guess is that you enter the number in some sort of culture specific value, say using comma as decimal point instead of period, or...

I'm unsure of what result you want, but the ToString method should be able to do it.
Check out:
http://msdn.microsoft.com/en-us/library/dwhawy9k.aspx#DFormatString
and see if it helps.

If using SQL Server 2005 or higher, then the ROW_Number() can help you to avoid having to make the subqueries and MAX.
Just make something like
Row_Number() OVER (Partition By username Order By...

Have you tried connecting to the SQL server with SQL Management Studio?
It does not need to be installed on the server but can be installed on a client. It just needs to be able to connect to the...

Management Studio does not need to be installed on the server. It just needs to be able to connect to the server on the SQL Server port.

My guess without parsing the entire thing through - you have a problem with your parenthesis. You do have a lot of them.
Properly the OR is interpreted wrong due to them.

I would advice you to...

I've not read into a dataset as you're trying to do, so I can't help you there (right now), but ....

I would advice you to instead of reading in via datasets, to use the serialization and...

Depending on how harsly you want to do it in SQL Server, you can just kill all connections as you detach the database.

Otherwise - more "soft", depending on how people log in (if they log in via...

I'm unsure what you ask?


You can connect to a SQL Server instance using SQL Server Management studio, if there's an open connection to it (needs to be exposed via an IP / Port number and have...

Split the string on spaces and count the length of your resulting array.

You need a property in your usercontrol (.ascx) to set the value of your label.
Then call that property from your page (.aspx) using the ID you gave the usercontrol.

When you get the error you should also get a stack trace which indicates what line the exception was thrown from.

Without the trace/line numbers I can only venture a guess (without actually...

Sorry, but I don't do other peoples homework.
If you wanted hints or suggestions - a forum like this is the place to go. If you want others to do your work; it's not the correct place.

Well - from the error message I'd say it isn't the query which is your problem.
But try to run it directly on the server to verify the query is correct.

The error message seems to indicate you...

Which database system is it?

FYI - but you might also want to look at the TryParse of the number values, which means you do not manually have to enclose the "Parse" in a Try/Catch block.

It works (almost) like parse, except...