esandall's Q&A profile

• SQL Server How to deny permission to modify report's datasource property

  How to deny permission to modify report's datasource property but still allow user to create, delete, and view report The two available task are View reports and Manage reports. However, I don't want a user to be able to specify a custom datasource on the Properties tab of a report. Is that possible ...Show All

• SQL Server Merge join with empty inputs

  Hi all, Does anyone have suggestions for ways to deal with the chance that a merge join might receive empty inputs I've noticed that when this happens the transformation seems to hang. I changed the MaxBuffersPerInput to zero and this seems to cure the problem but I'm not sure it's the best way to deal with it. Would it be a good idea to test the row counts with a conditional split before such a join Cheers, Andrew ...Show All

• Visual C# error:No value given for one or more required parameters.

  I am using C#.net to write a program. I have an update to update the database when the user changes the cooment. All values that I have assign to the datarow as data in it. Here is the code: foreach ( DataRow dr in _dsComment.Tables[0].Rows) { if (dr[ "CommentId" ].ToString() == strId) { dr[ "OrdNo" ] = _Order; dr[ "Comment" ] = frmN.Comment; dr[ "Date" ] = System. DateTime .Now.ToShortDateString(); dr[ "Name" ] = UserName; } ...Show All

• SQL Server Indexed View issue w/ Duplicate Key Error on an update to an underlying table

  This is the error: Server: Msg 2601, Level 14, State 3, Line 1 Cannot insert duplicate key row in object 'CandViewONLYIndexed' with unique index 'CI_Cand_Indexed'. The statement has been terminated. OK ... let see if I can explain this coherently - lol for simplicity lets say my updatable view(UV) consists of 3 underlying table (A,B &C) The index, being 2 fields, on the UV consists of one uniqueidentifier from table A and one fr ...Show All

• Visual Studio Express Editions What is the current build of beta 2?

  Hello, What is the current build of beta 2 I have beta2.050215-4400, is that the most recent one. Where in Microsoft site I can find numbers of latest builds, to be up to date Regards,ProJester. There has since been the release of the July CTP. You can see the latest version posted at http://lab.msdn.microsoft.com/vs2005/get/default.aspx on the right-hand side. ...Show All

• Windows Live Developer Forums Windows Live Messenger Problem

  I was Invited to be a Windows Live Messenger BETA tester. So I installed it and opened it up. When I tried to talk to one of my contacts there was an error, and it closed Windows Live Messenger. So I open it up again, and try and chat, and it happens again. And this happens every time I try. I've uninstalled it, re-installed, repaired it tons of times. Can anyone help me -FrdBed I have a similar probl ...Show All

• Windows Forms BackgroundImage and Stretch with transparent child controls.

  Trying to build a nice transparent alpha blended UI over top of a background image that is part of a form.  Now, I'm not quite sure what is causing my problem, perhaps ambient properties or just a bug somewhere but the following is ha ...Show All

• Windows Forms MaskedTextBox / TextBox (maximum number of chars event) ?

  Hello, I have several forms that use TextBoxes/MakedText boxes for the user input. Both of them only accept a maximum number of chars. Now when I reach the "end" of the text box I need to move to the next one. My question is, is there any event, that handles this Or I have to extend the text box and create a new Event Thanks in advance for any help. Regards Luis de Sousa ...Show All

• Software Development for Windows Vista workflow designer

  Hi All, I wonder whether it is possible to host the workflow designer in my app.  I thought it would be cool if I can have the workflow designer as my app's GUI. Thanks, DK Yes you can. I just saw a video with Scott Woodgate & team demonstrating the designer hosted in a winforms application ...Show All

• Visual Studio Express Editions Avalon

  Hi, Is it possible to create Avalon applications with the Visual C# Express Edition If so, how do I set this up I installed it and the winfx sdk as per the instructions, and I don't see an Avalon template. Hi, I have installed VS 2005 Beta2 along with WinFX SDK. But I could not see any avalon template in IDE. Do I need to set anything Thanks in advance Surya ...Show All

• SQL Server Flat File and uneven number of columns

  Please leave feedback for Microsoft regarding this problem at https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx FeedbackID=126493 Ok I'm sure it just me, SSIS has been great so far....but how can you import a straight CSV file with and uneven column count. For example: (assume CR LF row delimiter) The,Quick,Brown,Fox,Jumps Hello,World This,is,a,test "Normally" I'd expect this | Col1 | | C ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. rendering meshes

  hi! i've made a mesh picture_1: http://toomaniac.com/kopi/blender/object_mode _solid .gif even on actually flat faces there are a lot of triangles i.e. many different faces picture_2: http://toomaniac.com/kopi/blender/edit_mode.gif when i view the mesh in the meshview - that one that comes with the sdk - it looks like that picture_3: http://toomaniac.com/kopi/blender/directx.gif and when i load the mesh to my device it looks ...Show All

• SQL Server SSIS - Add a new SQL Server Mobile Destination

  Hi, I try to add a new SQLMOBILE Connection. In the "ADD SSIS Connection  Manager" I select the type of connection to add to the package. (SQLMOBILE) Then in the "SQL Server Mobile Connection Manager Editor" I browse and I try to find my mobile device, but i don't find it. Obviously, I Find my shared folder "Qtek2020i My Documents", but i can't to connect to the device by "SQL Server Mobile Connection Manager Editor". The error message is: ...Show All

• Windows Forms DataFormatString in GridView

  I wonder if someone else is suffering the same problem. I found DataFormatString in GridView not work very well when I try to display currency. In VS 2005 Beta version, it works fine, but after I use stardard version, it never display correct. For example: integer 3 always display like 3.0000 but in the beta version, it display like $3.00 which is what I would like. By the way, I assigned datasource, dataadapter and sqlcommand manually, everythi ...Show All

• Visual Studio Tools for Office building solution containing VSTO on CruiseControl.NET?

  I'm trying to build a .NET 2.0 solution containing VSTO on CruiseControl.NET 1.0. I have the .NET 2.0 SDK installed and regular .NET projects build fine using msbuild. .NET 1.1 solutions with VSTO for VS2003 build fine as well. The 2.0 VSTO project fails because a number of files are missing. Fair enough, but there doesn't seem to be a VSTO SDK I could install. The VSTO runtime does not contain all the files required to build and I cannot inst ...Show All