Type: Posts; User: Alsvha
Search took 0.04 seconds.
April 20th, 2011, 01:59 AM
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...
April 20th, 2011, 01:47 AM
Without knowing anything about the query or circumstances - I can only suggest working on fragmenting it into multiple smaller queries.
April 14th, 2011, 10:51 AM
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)
April 12th, 2011, 02:17 AM
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...
April 7th, 2011, 04:11 AM
Divide the task into subtasks and solve them one at the time.
First - make sure you can postback when your checkbox is clicked (there's a property you can set on checkbox'es that'll...
April 7th, 2011, 04:07 AM
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...
April 7th, 2011, 04:05 AM
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 ".
March 18th, 2011, 02:50 AM
Take a look at the example on MSDN:
March 16th, 2011, 02:07 AM
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...
March 14th, 2011, 05:24 AM
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...
March 10th, 2011, 03:38 AM
I'm unsure of what result you want, but the ToString method should be able to do it.
and see if it helps.
March 10th, 2011, 03:31 AM
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...
March 9th, 2011, 01:12 AM
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...
March 8th, 2011, 01:52 AM
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.
March 8th, 2011, 01:50 AM
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...
March 4th, 2011, 01:13 AM
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...
March 3rd, 2011, 11:52 PM
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...
March 3rd, 2011, 11:45 PM
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...
March 1st, 2011, 07:48 AM
Split the string on spaces and count the length of your resulting array.
March 1st, 2011, 07:45 AM
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.
February 23rd, 2011, 02:30 AM
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...
February 23rd, 2011, 02:24 AM
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.
February 23rd, 2011, 02:21 AM
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...
February 23rd, 2011, 02:19 AM
Which database system is it?
January 3rd, 2011, 01:55 AM
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...
Click Here to Expand Forum to Full Width