Hi guys Where do I find a list of database error type exceptions for SQLServer 2005? I'll know when its a database error a and log it in the eventviewer and send an email. I just want to distinguish between database errors and any other error. thanks
honeyman_can
Posts
-
recognising db errors -
Please help methanks bro, but i sorted it out now. first casted it to a 'real' number then used the 'round' function. and it worked. all trailing zeroes are now removed
-
Please help meIm returning ratios with rounded off to 3 decimals places, but when the rounding off function doesnt get rid of of the trailing 10 zeroes. How do I get rid of the trailing zeros because it shows in SQL reports. I have tried TRUNCNUM, ROUND, TRUNC. I just cant seem to get rid of those zeroes. Help would much be appreciated.
-
allowing access rights to log errors in eventviewerHi guys How does one change the registry keys to use the eventviewer/logger? thanks
-
reports viewer tool problems? Help!hi What is wrong with this ReportPath?: /Pages/ReportViewer.aspx?/IL_User/Weekly_ConversionAppRate When I view it from ReportServer it works, but not when I run it in reportviewer in asp.net 2.0 FYI: ReportServerUrl: http://ildevsvr02-v05/reportserver I get the following error: The path of the item "/Pages/ReportViewer.aspx?/IL_User/Weekly_ConversionAppRate" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath) thanks
-
invalid reportpath?Hi guys What is wrong with this ReportPath: /Pages/ReportViewer.aspx?Website+Reportingfvisits&rs:Command=Render FYI: ReportServerUrl: http://server/ReportServer/ I get the following error: The path of the item "/Pages/ReportViewer.aspx?Website+Reportingfvisits&rs:Command=Render" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath)
-
adding report in report viewer?Hi guys How you do add a report (rdl file) in a report viewer in asp.net 2.0?
-
How do you pass by reference in c#?hi guys! I'm a newbie to c# Method signature: public static string Translate(string translationCode, string culture, ref Dictionary> input) I want to pass a dictionary by reference and not the entire object. Is it correct to use 'ref' in the argument? Then how do I insert the dictionary when calling the method? thanks
-
accessing dictionary within another one?Hi guys! This is my method signature:public static string Translate(string translationCode, string culture, Dictionary> input) i would like to know how to access the value of the 'input' dictionary within the method? e.g. if(input.ContainsKey(culture)) { if(how do I check they 'key' of the inner dictionary?) { //use the value of the inner dictionary then how would i access the value of the inner dictionary } } I hope this makes sense. Thanks
-
Cache vs Application variableCan someone please me out? I got a translatable website where all the translations are currently stored in a DB. I have loaded them into a Dictionaries ect so I need to do is just access them. What are the implications or advantages of storing it in the cache and application variable respectively? I can't seem to see when is it appropriate to use either? Thanks in advance
-
struct-
-
structforgive me - I'm new to c# public struct lookupOjbect { string fieldvalue; public lookupOjbect (string fieldvalue) { this.fieldvalue = fieldvalue; } } lookupOjbect lookupObjectRow = new lookupOjbect(); When I want to assign a value to this object then 'fieldvalue' doesnt show with intellisense. e.g. lookupObjectRow.fieldvalue - doesnt show!
-
Do hashtables accept duplicate keys?I know dictionaries don't accept duplicate keys, but hashtables are inherent within dictionaries. If the answer is yes, then what data structure could I use?
-
Initializing dictionary with a struct? help plsSorry I didnt know about checking the checkbox, you solved my problem without looking at my code. Great!
-
Initializing dictionary with a struct? help plsHi guys what is wrong with this line? lookupObject is a struct. I just want to initialize the dictionary with the struct as value. public static Dictionary dicTextLookup = new Dictionary(); this is the error: "Error 1 Inconsistent accessibility: field type 'System.Collections.Generic.Dictionary' is less accessible than field 'dicTextLookup' C:\IL\TranslationController.cs 44" Thanks
-
alternative to structs?Could you please explain what you mean by this - "Use .NET 2.0 with generics". What generics are you talking about?
-
alternative to structs?What can I use instead of struct to store little info? I want create instances, put them in a dictionary, iterate and modify elements in the dictionary. I know every addition will involve a boxing operation, and every modification will involve an unboxing followed by a boxing operation. What is the best thing to do?
-
trygetvalue? Please helpstring translationText = ""; if(dicText.TryGetValue(translation[r].EntryCode, out translationText)) { dicText.Add(translation[r].EntryCode, translationText); } I don't get this method. As far as I understand it, it should do one lookup and if found then assign the related value of "translation[r].EntryCode" to translationText. Is this correct?
-
out value?// When a program often has to try keys that turn out not to // be in the dictionary, TryGetValue can be a more efficient // way to retrieve values. string value = ""; if (openWith.TryGetValue("tif", out value)) {Console.WriteLine("For key = \"tif\", value = {0}.", value);} else {Console.WriteLine("Key = \"tif\" is not found.");} What is value? value of the dictionary i.e. in this case openWith.value?
-
Hashtable vs. Dictionary (key values)Can a Hashtable accept two key values that are the same? if yes, then why can't a dictioanary accept two key values that are the same as it inherits from the hashtable class?