PeterVrenken's Q&A profile

• SQL Server using select statement

  i need a solution for my simple question is it possible to use stored procedure with output parameter in select query i am having stored proc "a_proc @input, @output" i need to get the output parameter in the select statement of the other stored proc here's my example declare @OP as datetime select a,b,c, (exec a_proc tablex.Data1,@OP output) as [MY field name], d,e,f from tablex where 'conditions' but its here giving error .. how to use this stored procedure which returning me a variable and i need assign that O/P value to the fields in the select statement pls its urgent!! Thanks in advance May refer to the kBA http://support.microsoft.com/kb/262499 for a relevant in ...Show All

• Visual Studio 2008 (Pre-release) Disabling binding based on visibility

  I have an ItemsControl with a binding on ItemsSource and I was wondering what is the easiest way to enable/disable that binding based on visibility property of that control. I don't want the control to be updated when it is invisible. Right you are. I should have said re-assign. My experience was that I could not tweak (I think I was trying to swap out the converter or something) a binding and re-apply it. ...Show All

• Internet Explorer Development How to inject STYLE into a page (a final word)

  Is it a supported scenario to inject a style tag into the body like this <div id="injectionDiv">&nbsp;</div> <script type="text/javascript"> document.getElementById("injectionDiv").innerHTML='<style type="text/css">.myClass{background-color:green;}</style><div class="myClass">&nbsp;</div>'; </script> If so, then why isn't the style applied One more thing. If you simply must inject a fully formed STYLE tag using a scoped innerHTML string as described above, avoid relative paths to resources such as background images. Until temporary elements are appended to the document, IE uses the context of the top-level document ...Show All

• .NET Development How to notify user in voice before send a Fax

  I want to send a Fax to some one by programming. And her Fax device is set as manual answer, I want to notify her by voice, I mean that play a .wav file. I found the way to send fax. But I can't find the function to notify by voice in Fax Service Extended COM. Could help me ...Show All

• Visual Studio Express Editions Making a textbox into an array and reading from each point in the array

  I'm trying to build a name generator, that takes a letter from one point in an array, (Which originally comes from a textbox), and changes that letter to some other character. So for instance, if i put the name "Sam" in textbox one and clicked the "Generate" button, the out put, (Which has random keyboard typings of each letter, like S as "Ess" or "$") would go to textbox 2. So basically i want to build a name generator for The "Leet" or "L33t" Language. What i need to know is: 1.How to assign the Data of Textbox1 to a String array 2. How to read from each point in this array and 3. How to set the output to go to a certain point in an array for textbox2. Any help would be greatly ...Show All

• Visual C# DataGridView - KeyDown and KeyPress events

  I need prevent emergence signs from numeric keypad in cells of DataGridView and rerout their entry at textBox1. This code is solve the task in textbox controls, but at DataGridView no prevent entry at cell, nor from them does pass-off. Does anybody know how to solve this private void dataGridViewOrders_KeyDown (object sender, KeyEventArgs e) { if ((e.KeyCode >= Keys.NumPad0 && e.KeyCode <= Keys.NumPad9) || e.KeyCode == Keys.Add || e.KeyCode == Keys.Divide || e.KeyCode == Keys.Multiply || e.KeyCode == Keys.Subtract || e.KeyCode == Keys.Decimal) { // Determine whether the keystroke is a backspace. if (e.KeyCode != Keys.Back) { // Set the flag to true and evaluate in KeyPress event. flag = true; } } } private void dataGridView ...Show All

• Visual Studio CR 9 Chart doesnt show in ASP.Net 2005

  Hi, I designed a chart with Crystal Reports 9 and added it to an ASP. NET 2005 page but at the time you try to see it, just doesnt show, the CR tool bar appears but the image containing the chart apers crossed out, however when the chart is exported to word or excel it appers perfectly, what’s going on Can anybody help me ...Show All

• Smart Device Development CE 5.0 Emulator with ActiveSync capabilities

  It there an easy solution to be able to use ActiveSync from the Windows CE 5.0 Emulator I downloaded the Emulator and I fount that I need to download the Platform Builder 5.0 to build a proper image for my needs with a special configuration that I've read in the help file of the Emulator. I tried to install the Platform Builder 5.0, but I always get the following message: *** This installation package could not be opened. Verify that the package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Installer package. *** I tried it with several Operating System's setting. I also tried it with a WMware image, but every time I've got the same error message. I downloaded Windows Installer ...Show All

• SQL Server Autoexist when queying

  Hi all, I think it's a simple question but i can't seem to get it right: I have a parent child dimension, with key Object, and an attribute Type. Every Object has a type, consider this example Object Type -------------------- Top Model Child 1 Portfolio Child 2 PortFolio When i run this query: select time.month.members on 0, objects.object.members * objects.[type].members on 1 from [Dream2007] I get this on Axis 0: Top Model Top Portfolio Child 1 Model Child 1 Portfolio Child 2 Model Child 2 Portfolio How can i het the following result with only the existing combinations : Top Model Child 1 Portfolio Child 2 PortFolio I tried non empty, but that doesn't work because they can be null. I ...Show All

• Visual Studio Error on a Help File Build

  Hello, I received the following error when building a help file on a project: Error: Unresolved assembly reference: System.Windows.Forms (System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=969db8053d3322ac) required by apiregedit The project is building fine and I don't see any broken references. Thanks in advance for your help :) Bob Hanson hi, I am really new bee for sandcastle and I have exactly same problem, can anyone of you explain this in more detail thanks in advance :) regards, rashmi ...Show All

• Microsoft ISV Community Center Forums making the previous ws active in excel

  Hi, I'm copying cells on one worksheet and paste them into another ws. After being paste I once again want my macro to view the first ws. How can I do this Maybe this example explain it better: Activesheet.select x = selection ' x = should be the activesheet copy bla bla bla Sheets("2").Select Paste bla bla bla Sheets("x").Select Any ideas \Jonas Hi If you mean worksheet then the below is what you need, if you mean workbook the principle is similar Dim ws As Worksheet Set ws = ActiveSheet ws.Activate ...Show All

• Visual Studio Express Editions Inherits:-

  I've been dealing with a single form form1 only so far, and now that i want to be able to be directed to another form once i click on a button, say form2. Is inherit the way of doing so What should i do Yap, i do it the way you instructed, the form 2 appears. But if i want that once the form2 appears, the form1 dissapear rigth way. I tried with form1.close(), it didnt work at all. ...Show All

• SQL Server Report in Calendar/schedule layout

  Is it possible to produce a report which is displayed as a calendar, similar to outlook im using rs2000 with no option of an upgrade to 2005 any help would be appreciated! Never mind. I didn't realize how relatively easy it would be to make a calendar report using the Matrix control in RS2005. I'm up and running. ...Show All

• SQL Server Assigning extra information to all database table fields

  I'm an experienced desktop app programmer, but fairly new to database programming. I'm working with C#/SQL right now. I understand the concept of a lookup table, as in storing a two-character state (such as CA) in a field in one table, and then being able to get the full state name (such as California) from a second table: Table: Address AddressID int <PK> StateCode char(2) <FK> ... Table: State StateCode char(2) <PK> StateName varchar(25) My question: is there some similar way to be able to provide just about every field of every table with a means of holding common, extra information For instance, let's say I wanted to store, say, an extended name and some special code with every field in th ...Show All

• Visual Studio Team System Microsoft.WebApplication.targets project wasn't installed out the box

  I just had my first build finally running (hurray, hurray). But among the other reasons it failed because it couldn't find imported project. The error was: "The imported project "C:\Program Files\MSBuild\Microsoft\VisualStudio\v8.0\WebApplications\Microsoft.WebApplication.targets" was not found" I checked that folder and it has TeamBuild, ReportingServices and CodeAnalysis folders with relevant targets but no WebAplications folder and targets. What's the problem My build includes Web Application Projects (which was upgraded from Web Site). I know that Web Application project is rather recent patch for Visual Studio so I guess there might be pathces for the TFS Build as well... Not ha ...Show All