clint 2's Q&A profile

• Microsoft ISV Community Center Forums worksheet_change and data validation

  Hi there I have an Excel spreadsheet in which one column has data validation set. So the cells in this column have drop-down lists with the pre-set allowed values. Now I want the cell in the neighboring column to be set to some default value when the user selects an item from the drop-down list. This seemed like it would be easy, using the Worksheet_Change event handler. When a cell in the first column is changed, it initiates a function which sets the value in the neighboring column to some default value: Target.Offset(0,1).Value = "default". The problem is that it doesn't work when using the drop-down list. If the user types in the value manually, or if a cell in the first column is deleted, it DOES fil ...Show All

• SQL Server SSIS + SSAS => Fairly consistent hanging?

  I have an SSIS package that reprocesses part of my cube. I've tested that it works, and deployed it as a SQL Job to run regularly. Strangely, it seems that the SSAS server hangs fairly regularly and when the SSIS job starts to run, it'll be stuck for hours. Is this expected Should I be bumping our SSAS service nightly Are there tools available to monitor SSAS service health Had the same problem recently with SSIS and SSAS. Started when I added unprocessed measure groups to my cube. All of the sudden my SSIS tasks would hang with the "building processing schedule" message, and only one task would go at a time. I processed the all cube measure groups so that the only objects left unprocessed in ...Show All

• Visual Studio 2008 (Pre-release) Eliminating a control if it binds to null

  I have a series of controls in a Gridview cell that are in a StackPanel binding to various fields on the same object. If one of the controls binds to a field that is null, I would like that control to not get created and all the controls under it to shift up. I've tried two ways, but I'm not very excited about either one. 1. Created a CellTemplate with a DataTrigger that checked the data and set the Visibility to collapsed. This has the right look, but my data is pretty sparse and I would like to only create the controls I really need. 2. Create serveral CellTemplate's. One for each purmutation of controls, and use a template selector. This works great for 2 or 3 controls, but gets out of hand rather quickly as I have to create 2^n t ...Show All

• Windows Forms Problem with changing text in a label

  Hello people. I have a little problem. I am trying to change text in a label depending on what item is selected in a listBox. Here is my code so far: private : System::Void listBox2_SelectedIndexChanged(System::Object^ sender, System::EventArgs^ e) { if (listBox2->SelectedValue->Equals( "High Elves" )){ this ->label1->Text = L "19" ; } } Now i thought that this would work, but the text just stays as label1. Any ideas could it be something to do with this: private : System::Void listBox2_SelectedIndexChanged(System::Object^ sender, System::EventArgs^ e) { also, i still cannot get the text in the label to change. ...Show All

• SQL Server SQL Server Management Studio Error: Property QuotedIdentifierStatus is not available for UserDefinedFunction

  Get following error when trying to edit/script some (not all) of my table-valued functions from a SQL 2000 database. We can edit these functions from SQL 2000 query analyser but not from SQL 2005 Management studio. =================================== Property QuotedIdentifierStatus is not available for UserDefinedFunction '[dbo].[EMAStudentRegisterStats]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo) ------------------------------ For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyCannotBeRetrievedExceptionText&EvtI ...Show All

• Architecture Scheduling Job in a Web Farm

  Hello, I have a farm of .NET servers. The application also needs scheduled jobs - like sending reports / notifications periodically. The question is - what is the best way to schedule this job I want the same set of software to run on all machines - so that if in case one machine goes down, the other is able to run the scheduled job. The options I am considering: 1) making them SQL Server jobs ( which are failed over in a cluster), but these jobs need resources available on the .NET servers, and I donot think that opening a backward connectivity from DB to App would be the best way. 2) To have some kind of a lock in the database, and schedule the job on all the machines in windows scheduler. The one which wakes up first, gets the l ...Show All

• SQL Server select query from a stored proc when the values can be blank.

  Hi All, I think what am trying to do is quite basic. I have 3 paramaters@value1, @value2,@value3 being passed into a stored proc and each of these parameters can be blank. If one of them is blank and the rest of them have some valid values, then I should just exclude the column check for the value that is blank. For e.g if all my parameters being passed are non- empty then I would do this select * from tblName where column1 like @value1 and column2 like @value2 and column3 like @value3 else if I have one of the parameter being passed as empty, I should ignore that parameter like if@value1 is empty then my sql should be select * from tblName where column2 like @value2 and column3 like @value3 I don't want to do a dyanmi ...Show All

• .NET Development Using Internet From C#

  Is it possible to use some .NET library to download a file from the internet automatically to a specified directory Let's say I have an excel chart on my website, and I want to download it to C:// Also, I want to be able to do the same with a web page, i.e., I want to go to www.mywebpage.com/index.html and download index.html to a certain folder by using .NET. Will this take a lot of complicated code Can I just use a .NET library, or must I use Win32 API or something like that http:/ / msdn2.microsoft.com/ en-us/ library/ system.io.memorystream.aspx http:/ / msdn2.microsoft.com/ en-us/ library/ system.drawing.image.aspx There are a few ways to do so. One method would be to take out the image tags and then rereq ...Show All

• Internet Explorer Development Enabling script debugging in IE7

  Hi I cannot enable script debugging in IE7. I have clicked the checkbox to off on "disable script debugging" in the advanced options, but it just won't save the option! when I restart IE, the tick has reappeared again! Can anyone help or point me in the direction of someone who can Thanks Bex There must be an answer. Someone must know. It seems a lot of people have this same problem. ...Show All

• Windows Forms Newbie question: Common Binding Sources for several Forms?

  Hi, I'm coming from Delphi world and learning from scratch VB.NET Express 2005 with SQL Server Express 2005. I'd like to develop a small database app. where I have a main data grid, and when the user press a "view button" on the Navigation Bar, a dialog box opens with data detail from the selected row on the grid from the previous form. Is it possible to have common Data BindingSources used by the 2 forms, so my detail form is loaded automatically with the same table record the user selected from the grid in the previous form In Delphi there was the DataModule, where one can centralize datasets and data sources for all the application, and if 3 forms referred to the same data source, all data was in sync on ...Show All

• Windows Forms e.Graphics = picCapture.CreateGraphics();

  Hi, please take a look below private void pictureBox1_Paint(object sender, System.Windows.Forms.PaintEventArgs e) { e.Graphics = oldPicture.CreateGraphics(); } However, above scripts throw Exception "Property or indexer 'System.Windows.Forms.PaintEventArgs.Graphics' cannot be assigned to -- it is read only" How can I replace the graphics of pictureBox1 to picture1.CreateGraphics(); Go with John and use Graphics.CopyFromScreen method and pass the required parameters according to screen coordinates and save the the copied area to a Bitmap and load in the PictureBox. I hope this will help. Best regards, Rizwan aka RizwanSharp ...Show All

• SQL Server Can't launch executable from SQL Server Agent Job

  I'm trying to launch an .exe from SQL Server Agent Job and basically nothing happens. I created a job, with 1 step, type is Operating System (CmdExec), run as sql agent service account, and in the command box I typed "start notepad" (no quotes). The job owner is set to administrator. I manually start the job, it processes successfully yet notepad does not launch. I've tried with other .exe's and result is the same. Any advice Thanks! Thanks joeydj but xp_cmdshell is/was enabled and a proxy account with sysadmin permissions is setup for it as well. Can you answer the question: Should I be able to launch an .exe directly from SQL Server Agent Job ...Show All

• Windows Forms When CheckForIllegalCrossThreadCalls == true, does the framework inform of ALL the control access errors?

  Hello, When I set the Control.CheckForIllegalCrossThreadCalls to true, Visual Studio generates an exception each time I try to access a control from a thread other than the thread on which the control was created. However, in some cases this exception is not generated. For example, I am using the ComponentOne Chart ( www.componentone.com ), and I am able to update the graphs of the chart from another thread without Visual Studio generating an exception. However, in 1 case out of 10, an exception is still generated, by the control itself, although visual Studio does not inform me that I am accessing the control illegally from another thread. That is, is seems that the framework (Visual Studio) does not inform of ALL the illegal acc ...Show All

• Visual Studio Team System WebTestContext in LoadTest

  Hi all, I'm currently trying to load test a coded web test and I'm about ready to start pulling my hair out when accessing data from WebTestContext. I have a single web test scenario in a load test that does the following: request1 - log in a user (user id is auto-generated in the test constructor from a helper class method) extract request1 hidden fields yield return request1 request2 - perform operation 1 on web site as logged in user extract request2 hidden fields yield return request2 request3 - perform operation 2 on web site as logged in user extract request3 hidden fields yield return request3 request4 - you get the idea.... ... requestn - log user out Each request is designed to be run as the current logged in user and then log out ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. build 5600 x64 and Augst SDK AOK

  Finally got the dx10 ref. device back. One of the x64 DX10 sample failed to run ( I think it was skinmesh dx10) and generated a "STOP error" (that is after it detects no DX10 hw presents and prompted me) ...Show All