friggityfraggity's Q&A profile

• Windows Forms Setting propertygrid attributes at runtime

  I've been looking for a very simple, straight forward C# example of how to set propertygrid attributes at runtime.  It's the readonly attribute that I'm mainly concerned with.  All of the examples I've come across are just way to confusing for my little brain.  Basically, I want to turn the readonly bit on or off for a particular property depending on what another property value is set to.  So, if property a == x then property b should be readonly. Any and all help will be greatly appreciated. I have done this by implementing ICustomTypeDescriptor on the component and return the desired PropertyDescriptorCollection with the altered attributes (Browsable, etc.) I don't know ho ...Show All

• SQL Server "Cross Mirroring" - any good?

  Hi I’m about to move all our databases from an old lousy server to a brand new HP setup. I have 8 databases (total of approx 100Gb) and I get 2 BL25p servers and SAN access for them. Now, I want high availability and I like the idea of mirroring the databases for achieving that. On the other hand I don’t like the idea of the mirror server doing almost nothing while the principal gets the entire load – seems like a waste of good resources. But is this really the situation or mirror server also be loaded, just for being the mirror Now, if the main load is on the principal would I then benefit from distributing the databases on both servers, so both servers would act like principal and mirror What I mean is that server 1 could be prin ...Show All

• Visual C# onl Simple If Statement Question

  Is there a better way to avoid an exception than the following If statement   I have a button that invokes this code.  I don't want an error to occur if they leave the txtPennies.Text blank or with some other unexpected input.  I made the If statement say if the text was blank, just return, but what if I wanted the If statement to go though all of the lines of code   { int intLeftOver; if (txtPennies.Text == "" )  //Is there a better way return ; intLeftOver = int .Parse(txtPennies.Text); lblDollars.Text = (intLeftOver / 100).ToString (); intLeftOver = intLeftOver % 100; lblQuarters.Text = (intLeftOver / 25).ToString(); intLeftOver = intLeftOver % 25; lblDimes.Text = (in ...Show All

• SQL Server How to find Dependent/Referenced Objects of a Stored Procedure?

  Hi Frens, Could anybody tell me how can I find all the database objects that are used in /referenced by/called by/dependent on a given stored procedure In other words, I am looking for something like a stored procedure or a function that takes as input the name of a stored procedure and outputs all the names of the tables, functions, procedures, cursors and etc. database objects that are used in that procedure. Could you please give me suggestions or possible answers for this Thanks a lot for your time. Regards, -Ram. THANKS! Nice! i like the cte! i guess my real problem is that the sysdepends is not accurate or up-to-date. is there an easy way to rebuild it without dropping and creating every object s ...Show All

• SQL Server Maintanance Plan

  in the beginning i could create such plans without any problem, but since the workstations run's inside domain it doesn't work either with sa nor with system admin. any idea how i can solve that issue below you find the details of the exception i get. thanks in advance, =================================== Exception has been thrown by the target of an invocation. (mscorlib) ------------------------------ Program Location: at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes metho ...Show All

• Windows Live Developer Forums Max zoom out or zoom in parameters?

  Is there a way to set the max zoom-put or zoom in MAP parameters Unfortunately, e.view.zoomLevel only returns the current zoom level. So if you use an onstartzoom it gives you the current zoom prior to clicking... onendzoom gives you zoom after the click. So it's doesn't tell you which way your going. :( If we knew the ID of the button zoom element or something maybe we could at something to it... If you use a cuztom zoom in and zoomout button this isn't a problem and you can get seemless zoom control. That may be what I have to do in my own project. ...Show All

• Visual Basic Any good tutorial link for SQL Reporting Services

  Any good tutorial link for SQL Reporting Services preferably in free movie format. Am a newbie WalangAlam, Video: 1. TechNet Support WebCast: An introduction to Microsoft SQL Server 2000 Reporting Services http://support.microsoft.com/kb/834838/ 2. TechNet Support WebCast: Microsoft SQL Server 2000 Reporting Services Service Pack 2 http://support.microsoft.com/kb/895617 3. TechNet Support WebCast: Upgrading to SQL Server 2005 Reporting Services http://support.microsoft.com/default.aspx/kb/913930 4. MSDN Support WebCast: Installing Microsoft SQL Server Reporting Services http://support.microsoft.com/kb/883676 MSDN articles and samples: 1. SQL Server Reporting Services: http ...Show All

• Visual Basic Command Button - Delete Key

  I have a command button named "cmdRemove" When I click that button, it removes one value from my current ComboBox value list. My question is: Is there any way to substitue a key for that button. So instead of clicking button, I can click "Delete key" and that will do the same as clicking my "cmdremove" button. so you want when the focus is on the cmdRemove button, if a delete key has been pressed to invoke the button ...ok...doesnt make much sense but ok :-) implement the keydown event then....   private sub cmdRemove_KeyDown(byval sender as object, byval e as KeyEventArgs) handles cmdRemove.KeyDown    if e.KeyData = System.Windows.Forms.Keys.Delete then  & ...Show All

• Visual Studio Team System Add Related Work Item fields question

  We are using the "Add Related Work Item" feature for creating a Bug from a Test. This is being done by right-clicking on the Test work item and selectiong the "Add Related Work Item" option. What we want to do is specify how field data gets copied from the Test WIT to the Bug WIT. It looks like a few of the built-in fields get copied automatically (maybe by reference name ). But I would like to customize this behavior. For example, we would like the Title of the Test WIT to flow to a custom field in the Bug WIT - instead of the Title field. And, we also want other custom fields from the Test WIT to flow to other fields in the Bug WIT. Is there any way to accomplish this I messed around with the WIT elements and attributes in ...Show All

• SQL Server Installing two instances of Report server

  Can we install two instances of report server on the same machine . We want to use the same hardware for two different methods of custom authentication. Both the server applications would then talk to the same database. cvajre, Here's a step by step way of implementing 2 reporting instances. http://bloggingabout.net/blogs/mglaser/archive/2006/12/18/multiple-reporting-services-instances-on-one-machine.aspx Ham ...Show All

• Visual Studio Report Viewer shows error then loads the report

  Hi I m working with client side reports (rdlc). When I load a report, report viewer displays following error: "An error occured during local report processing. Failed to load " After displaying this error for a few seconds, the report is shown correctly. Now I cant understand why this error occurs. Can anyone help me resolving the problem. Thanx in advance. I have been having this same problem, with the error message "Report processing has been cancelled" showing for a few seconds and then the report loading without any noticeable problems. I noticed that when I run the program through Visual Studio 2005 this doesn't happen, it's just when I run the .exe on its own. Have you ...Show All

• SQL Server update statement

  Newbie Question: Im trying to update a table column to a new value and I receive an error, here is my statement: USE PD51_Data; GO UPDATE CASENUMBERS SET CaseNumTypeID = 130 WHERE CaseNumTypeID = 101 AND CaseNumber BETWEEN 199999 AND 600001; GO I receive this error Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '9368----' to data type int. What did I forget   Waldrop wrote: I am guessing that the WHERE clause that you want is something more like: WHERE CaseNumTypeID = 101   AND isnumeric (caseNumber) = 1   AND convert (integer, CaseNumber) BETWEEN 199999 AND 600001 This rewrite will still throw errors and ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Single letter prefix before a variable

  I was wondering if anyone can point me towards some information on having a single letter prefix before AND after a variable name. Is that a standard practice I have come across this in a number of different programs, yet still a bit unclear why they are used. Any info would be appreciated. Some examples of what I have seen: aFireball.Value.Source mWizard = new Sprite.... rotation_angle += .03M; My opinion: Java and C# have published standards - I see no reason to deviate from them, given the benefit of everyone working the same way. In some ways having these standards is a godsend - it is far easier to agree to all conform to 'the standard' than get 20 developers from different ba ...Show All

• Windows Search Technologies WDS 3.0 Not working - indexed files = 0, srchadmin.dll problem

  Hi, I have folowing issue with WDS 3.0 and I'm not able to find solution anywhere. WDS is not indexing any files. The problem will be propably connected with file types, because when I try to open FileTypes tab in Indexing Options/Advanced Options I receive only message: An exception occured while trying to run "shell32.dll,Control_RunDLL "srchadmin.dll"" . In event log than can be found following messages: "The update cannot be started because the content sources cannot be accessed. Fix the errors and try the update again. Context: Windows Application, SystemIndex Catalog" and the second one: "The content source <d:\dokumenty\> cannot be accessed. Context: Windows Application, SystemIndex Catalog Details: The system cannot fi ...Show All

• Visual Studio Express Editions C# equivalent for the Delphi "Set of"

  Hi all what's the C# equivalent for the Delphi Set of (set = a collection of values of the same ordinal type) private ANumb: integer; // declare the set _MySet : set of 0..127; // add to set if not (ANumb in _MySet) then _MySet := _MySet + [ANumb]; // remove from the set if (ANumb in _MySet) then _MySet := _MySet - [ANumb]; How to translate the above thanks in advance for any help! from what I've seen with a quick google, its to instantiate a variable/collection with a certain length Integer I believe cannot be "set" as it has its own min/max values but you can assign a value to an Int: int theNumber = 1; to create an array of string, for example, with a specified length: ...Show All