Niels R.'s Q&A profile

• SQL Server Getting field value in Select Statement

  I have problem getting the value of a field in a select statement to be stored in a variable when the select statement is stored in variable and executed thru exec sp_executeSQL. ex. Declare @Count as int, @SQL as varchar(500),              @DynamicWhereClause as varchar(100) /*    here i set the value of my dynamic WHERE clause. */ set @SQL = 'Select count(*) from table1 ' + @DynamicWhereClause exec sp_executesql @SQL I want to store the the value for Count(*) to @Count. Thanks, Lou Belaro You need to parameterize the SELECT statement and use it in the sp_e ...Show All

• Windows Forms Windows Media Player problems

  I am looking to use the Windows Media Player 9 ActiveX control in a C# program that I am developing.  After downloading the SDK, I am having problems getting the PIA to register with regasm and gacutil.  It would seem that the control is developed for the 1.0 framwork and not the 1.1!  I am amazed that I can't seem to find any& ...Show All

• Visual C# datagridview / cells and rows

  hi, i need help, how can i get the value from a particular dgvcell if i'll select the entire dgvrow and how to auto-select a row thats brilliant got it working now. super fast reply. Thanks! ...Show All

• SQL Server generate a strong name key file

  I am a Newbie to programming and databases and would like to create a simple program for doing full text searching on a SQL database. I have downloaded and installed Visual Basic 2005 Express, Web Developer 2005 Express, and SQL Server 2005 Express. I have watched several hours of video tutorials and done numerous tutorials. I feel I am making progress and having a lot of fun. My machine is running XP home edition. I have found the following resource that looks like a good place for me to start with creating a full text search program: “SQL Server 2005 Books Online Item Finder Sample http://msdn2.micros ...Show All

• Windows Forms DataGridView Calendar And Scheduler

  Hi,    Can anyone help me with the following    Using the new DataGridView in .NET 2.0, can the look be configured so that the days of the week are headers and the rows are subdivided into 30 min. time intervals much like Outlook allows you to schedule appointments.  I'd like the same look and feel.    As an option, I'd like to be able to add multiple "Customer" objects to any given cell and click on a single customer to bring up his history/appointments, etc...  For example, cell at location 5,4 may contain 4 "Customer" objects, and clicking on one of the objects in that cell woul ...Show All

• Smart Device Development Zooming only a part of the image.

  I am creating a application in which i am displaying a .jpg in a picture box.Now i want to give a functionality so that user can select a part of that image and zoom it on PDA screen. Is it Possible with CF Please help me out. thanks in advance. I doubt you can do this with a picture box, unless you first draw the bitmap with part of it zoomed, and then you may as well draw it directly in a paint handler. ...Show All

• Visual Studio Express Editions Lengthly download

  Is there a way I can purchase a CD of this program The download is way to large for me to download over a dial-up connection. Thanks yes, there is a CD version available (I've seen them listed in retailer catalogues) of at least some of the components. Might be cheaper though to ask a colleague/friend with DSL to download for you and burn a CD. CDs come with a sort of quickstart guide, I see them here for C#, VB, and Visual Web Developer for a very reasonable price. ...Show All

• Software Development for Windows Vista Designer fails to create Activity Binds for Web Service

  So I tried to invoke a very Simple ASMX Web Service from my Workflow. My ASMX Web Service has an int input and string return.   In designer I Add a reference to this webservice, and it recognises the input and (ReturnValue) as parameters in the proprty box. When I right click and 'Generate Handlers' it gnerates a single invokeSimpleWebService_Invoking method generated. There are no options for any other methods.   However the Workflow does not recognise the returned value.   Looking trhough the designer generated code I can see that an ActivityBind has been set up for the input parameter, but not for t ...Show All

• Windows Forms Saving a web page.

  Hi, i am trying to phares a web page to get information off of it.  this site i want to get must be lgged in.  but when i tried to use a webclient I wasnt logged in but when i use a ax_broswer1 ot works fine.  Is there a way i can save the webpage i navigate as a .html file in the programs direcory so then&n ...Show All

• SQL Server Excel 2003 and nonemptycrossjoin

  I am trying to utilize an Excel 2003 pivot table as a client tool to front end a project I am developing. I have created the cube in Analysis Services 2005 and it works fine when I run MDX against it directly. The problem that I am having is that Excel is not using nonemptycrossjoin in the pivot table. I have Teo Lachev's book "Applied Microsoft Analysis Services 2005' and I was looking for tips and found a note on p. 633 referring to a workaround ( http://blogs.msdn.com/bi_systems/articles/162852.aspx ). To simplify testing, I reduced the query down to the most essential dimensions on rows and a single non-calculated measure on co ...Show All

• Visual Basic DataTable is not defined

  Ok I'm first to admit that I'm no legend when it comes to .net programming. I'm slow to make the transition from VB6 - so I jump straight into a beta- maybe not the smartest thing to do. Anyway, I've got a smart device project - and I want to reference a datatable. I've added the reference to system.data but when I declare 'Dim NewTable As New DataTable'  for example, it tells me that this is not defined What am I doing wrong. I have another project with the same references and it knows about this datatable reference just dandy I'm using Beta 2. Apologies if this is a stupid question or it's in the wrong place. thanks Bruce ...Show All

• Visual C# The type or namespace name 'WinForms' does not exist

  D:\cis 524\example\WindowsApplication2\Form1.cs(2): The type or namespace name 'WinForms' does not exist in the class or namespace 'System' (are you missing an assembly reference ) About this error, what .dll reference should I need to add Thanks alot! There is no System.WinForms.dll in "Add Referece -->.Net". Where should it be whether my Visual Stuido has some problem How to handle it or I need to re-install VS Thanks ...Show All

• Visual C# Real time graphs

  Hi, I need to build a application that shows a realtime graphs (like bandwidth ones) Does any one knows any component or .... to do it easy.... Thanks As I needed a bar graph, I doing it using a table and images.... Like, My value is 89% so in a table with 100% of width I print an image with 89% of width did youo get it Hope it help.. ...Show All

• Windows Forms Adding new rows to DataGridView does not follow sort order

  Hi! I have a datagridview in which I add rows using the rows.add method. Grid is not bound to any datasource. The problem I have is that newly added rows are always added at the bottom of the grid, ignoring the selected sort order. Do I miss anything I wouldn't like to call .sort method again, since my grid may contain a lot of data and rows might be added every few milliseconds. Awesome. Thanks! -mark DataGridView Program Manager Microsoft This post is provided "as-is" ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Animating a leg

  hi all, I'm trying to create a simple animation of a leg. The leg would be made out of two parts and each part would be a mesh (could be just Mesh.Cylinder). I know how this should work in principle but when I have to calculate the matrices all goes wrong... Here's my idea: Given the angles of rotation for both parts rotate and position the upper part (which will maybe be someday connected to a torso) then rotate the lower part and connect it to the first one... Could someone give me a simple example of how to correctly multiply the matrices in order to achieve the desired result thank you, sa o ...Show All