GDavids - SAO's Q&A profile

• Visual Studio Express Editions Need help with "Saving Data to a Database"

  Hi, I have VBExpress and Access with WinXP. I started a new project, created a new datasource by connecting to the "Northwind traders" database. From the datasource window I selected the Employee node and set the control type to "Detail". I then dragged the Employees node to my form1 and got a bindingnavigator and several textboxes. When I click on "Add New" and "Save" without entering any data, I get an error which indicates that Null values are not allowed in some of the fields. I have been trying to insert validation code but it is obvious that I know not what I am doing! What is the "Best Practice" method of dealing with this issue Thank ...Show All

• Windows Forms I have to inserting the picturebox in particular DatagridviewCell

  Hi to all I am facing the problem to adding the picturebox control in datagridviewcell in vb.net 2005 please any help me, how to add the picturebox control in datagridview. If any solution please send the information to following email id, plz plz plz plz help me. irshad.don@gmail.com The following post might be useful http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1076886&SiteID=1 ...Show All

• SQL Server Role Playing Dimensions

  What is the proper way to include the date dimension table into your DSV if you plan on using multiple role-playing dimensions It seems if you can use this dimension as a role playing dimension, and assign the "join" using the Dimension Usage tab, then it doesn't need to be joined to the fact table in the DSV... is that correct Or should you add the Date Dim table to the DSV and join it to every date-specific fact foreign keys I see three possibilities for the DSV: 1) Include the Date Dim table but not join to any other table in the DSV 2) Include the Date Dim table and join to at least one fact foreign key 3) Include the Date Dim table and join to all fact foreign keys for dates in the DSV Which method would be th ...Show All

• .NET Development Cannot create channel sink to connect to URL

  Problem Description I am trying to code a simple proof of concept app (zip code available) based samples from various programming examples and texts. 1. A PC WinForm (.NET 2.0) client synchronously calls a HelloWorld() WebService method (http, wse 3.0). This works. 2. The same WinForm PC client can also call a different HelloWorld() method exposed in a separate Console Server app using .NET 2.0 Remoting; IpcChannel. This also works. 3. Finally (this is the purpose of the exercise), the PC client calls a wrapper HelloEcho() method in the WebService. The WebService method (with no changes) calls the Colsole Server’s HelloWorld() via .NET Remoting / IpcChannel. The third chain (client via http to WS vi ...Show All

• Visual Studio Express Editions MouseDown on a Panel, Steals the MouseUp Event, and Stops ANY Enter\Leave Events of that control.

  Just like the title says, On a panel, when I mousedown, and move the mouse outside of the panel's range, and release the mouse on a different panel, the sender for the mousedown, and mouseup are identical, and they shouldn't be. Also, the mousedown event stops the enter & leave events, at least of that control, I need to get this to work right so that I can easily inventory system w/ inventory slots, that when dragged to and from each other, will change its' value in an array, the only alternate way I currently know of, is to use locations instead of senders, hopefully, it will not come to this. P.S. Sorry for the quadruple or greater than threads a page or 2 back, it kept saying that an error occured, so I kept clicking it :) ...Show All

• Visual Studio 2008 (Pre-release) Compiling the EDM map in Jan Orcas CTP

  As the EDM designer is not part of the Jan Orcas CTP, what do I do in order to generate my EDM map fro the msl, csdl and ssdl files respectively I.e, the EDM designer where using (if I remember correctly) a custom MSBUILD task - does that still exist and where can I find it Niels So do you already have the ssdl, csdl, and msl files and do you need to produce an Objectlayer file(C# or VB code file of the objects based on the Csdl description) If this is the case then you can review the following post for how to do this: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=967337&SiteID=1 If this is not the case can you please obtain the version number of System.Data.Entity.dll on your system ...Show All

• Visual C# Username / password with WebRequest?

  Hi, I am looking to have a program which connects to a webpage that requires a username and password, and then downloads a file from this site once it connects. Is it possible to pass username and password credentials using the WebRequest class If so, what methods would I be using to accomplish this Thanks so much, Yaron Yaron wrote: Hi, Thank you for your responses. I have looked at the help and have come up with code that looks like this: WebRequest request = WebRequest.Create("https://login.cwbc.com/login"); request.Method = "POST"; string postData = "usr_name=SOME_NAME&usr_password=SOME_PASSWORD&HiddenURI=https://www.cwbc.com/Partner/Log ...Show All

• Visual C# Application settings lost upon new assembly

  Hi all, I'm facing the same problem as issued in this topic . I tried the solution with ApplicationSettingsBase.Upgrade() but it doesn't work out. First of all I need to put System.Configuration in front of it, I don't know if this really matters. Second my intellisense only offers me .Equals, .ReferenceEquals and .Synchronized but no Upgrade. My application is working correctly, I assigned settings using the Settings designer and I use them using Properties.Settings.Default. ... To be honnest I've been reading a bit here and there but I miss the total picture, I do not see where I mess up. All help is appreciated. Thanks a lot for the response Dan! I still have to try it ...Show All

• SQL Server Last recompilation date of the procedure / view

  Hi, Kindly let me know How will we find the last recompilation date of the procedure / view in sql server. Regards, S.Balavenkatesh perhaps what you seek is in: select refdate, crdate from sysobjects or select create_date, modify_date from sys.system_objects -- 2005 Dave   ...Show All

• Visual Studio Tools for Office Probing path for C# Assemblies

  Hi, I am referencing few C# assemblies in VSTO application. While deploying the VSTO application through msi project client wants to have the assemblies in a separate folder other than the main VSTO application (the excel file for our case). But since all the referred assemblies are not found within the application folder it's giving error saying the assemblies are not found. Can I set the probing path for those C# assemblies from my VSTO application Thanks The short answer is that you can't change the probing path for the solution, because the probing path is part of the appdomain setup, and you can't change that after the appdomain has been created. From .NET v2.0, an appdomain's binding context can't be modified after assemb ...Show All

• Visual C++ How to trap all exceptions?

  Due to bugs in my code, users experience crashes. When this happens, they get a window saying "<MyApp> has encountered an error and must close", and offers to send a report to MS. I want to have my pgm get control when one of these errors (such as an access violation) occurs, so I can create and store my own report. How can I do this I tried _set_se_translator (complied with /EHa), but this did not work, at least when I run the pgm in the debugger. If I run the pgm without the debugger, I get a JIT debugger dialog. Ben Anderson MSFT wrote: I recommend subclassing CWinApp and overriding Run() as follows: CMyApp::Run() { try { return CWinApp::Run(); } catch ( ...Show All

• Windows Forms HOWTO : Partial Click Once Deployment

  Hello, Let me explain my current situation. I have an application (Portal.exe) that is used by all the users in my company. This exe is used to load one or more applications. (DLL), depending on the user his rights. Some users can load only one application, others can load 2 or more. The applications that the user can load are listed in the menu of the main application (Portal.exe). This menu is loaded dynamically based on a webservice and the user his credentials. If the user selects an application from the menu, the corresponding dll is loaded into the exe and forms into that dll are shown to the user. On disks this looks like this: Root\Portal.exe Root\Applications\Application1\Application1.dll Root\Applications\Application2\Ap ...Show All

• Visual Studio Team System FXCop looks for references.. Why..???

  Hi, We are trying to run fxcop on our application, but then it asks for all the references used by that dll throwing the CA0058 error. Why is this so. Aren't we supposed to be doing static analysis of the code that we wrote Then why the need to check all the references. I understand I can fix this issue by pointing to all references, but I still would like to know y its needed Thanks for your assistance, Regards, Ramya You are right, we only analyze the code that you wrote, however, we still need to know about base classes, attributes, parameters, return types, etc that live in other assemblies. Without this information, we couldn't make security judgements (as base class' could be applied ...Show All

• SQL Server SID after restore from sql2k onto sql 2005

  Hi, We have 15 databases which need to be restored each night from a sql 2000 database server over to a sql 2005 database server. Currently we do this between two sql 2000 servers and have a script to "fix" orphaned logins, we've now bought a 64bit sql 2005 server and need to do the same. The script shown below is what we currently use but this now fails with... Invalid object name 'master..sysxlogins'. [SQLSTATE 42S02] (Error 208). The step failed. Is there a simple solution that I can employ to to transfer the logins over between different sql servers Dave DECLARE @DomainName VARCHAR(255) DECLARE @RoleName VARCHAR(255) DECLARE @UserName VARCHAR(255) DECLARE @LoginName VARCHAR(255) SET @DomainName = 'mydomain' SET @RoleN ...Show All

• Internet Explorer Development Calling ActiveX function from Javascript

  Hi, From what I've heard, you're supposed to be able to call an embedded activex function or set one of its properties from the javascript in an html/asp page as long as the function or property is declared as public in the code. I have an activex control embedded in an html page with the object tag: <object ID="gis" classid="clsid:C9905EA4-468A-46c0-BCF4-49A547B3A2E6"> Then I try to call a public function of the control like this: <script> function showbox() { gis.ShowMBox(); } <script> All the function does is show a messagebox. I have an html button that calls the javascript function like this: <input type=button value="SetDoc" onclick="showbox()" ...Show All