KillerKryptos's Q&A profile

• SQL Server Hierachy drill down stops at point

  I have the following scenario I have a Staff Parent child hierarchy and that links down to a division. A staf member is in charge of a division but we want the managers to drill down into the children and see which divisions they are in charge of etc. So here is what the data looks like Staff Lev1 | Staff Lev2 | Staff Lev3 | Staff Lev4 | Division | Value ------------|------- -------|--------------|-- ------------|----------- |--------- A | B | C | D | DivA | 1000 A | E | | DivB | 2000 the problem is, with drilling down though the staff hierarchy I can never see DivB, I can see the value associated to the Staff member E but when I try drill down it j ...Show All

• Windows Forms Version Number of ClickOnce application

  I want to display the version number of a Click Once application in my About box. Any ideas on the easiest way to get this It appears to be in the MyApp.exe.manifest file, but I'm wondering if there is a better/easier way I'm guessing there's nothing directly in the framework, as the app doesn't know how it's deployed, but I could be wrong. TIA, Bill So this won't work when I'm debugging the application in the design environment, but will work once I have deployed with ClickOnce and the user is running the application thanks Dan ...Show All

• Software Development for Windows Vista Regarding UI plug-in in Feb CTP for the Sample Filtters

  Dear all, We are trying to build the Sample Filters in the Feb Ctp wdk for Nup and Watermark.  But we are not able to find the UI plug-in that supports the Nup and Water mark. Please provide us the location of the UI-plugin in the WDK. And also please let us know the method to build and integrate the same. Thanks in advance for your timely help. Regards, Karthikeyan. Karthikeyan, My apologies for the delay in our response. The sample filter UI was not completely functional prior to the Windows Vista Beta 2 release. Please try again with the Beta 2 (or latest CTP) WDK. Thanks. -Daniel (Microsoft) ...Show All

• Visual Studio Express Editions trying to create a function library dll and access it from VBA

  Hi, I have some very cpu intensive functions built in VBA in excel, which for the sake of speed, I want to bring over into a dll and call from VBA. I've created a new Class Library in VB, copied the code over and tweaked it, so that it compiles and creates the dll, but when I try to call it fromVBA I get 'Run-time error '453': Can't find DLL entry point About in BMIP.dll". Have looked in all the help files, and I see that I need to create an export table in the dll to show which functions are accessible outside the dll, but all the examples in the help files are for C++ so I have no idea how to do it in VB. Any clues Sample VB code in a Class Library: Public Class Class1 Public ErrorMessage As String ...Show All

• SQL Server Replication between SQL Express 2005

  Hi All, I am trying to do a Replication between a network SQL Server Express Edition 2005 DB with a client SQL Server Express Edition 2005 DB. My question is 1. Can we do replicaiton between SQL Server Express Edition 2005. (No SQL SERVER present) 2. If yes can any of you provide me some guidance or some pointers on how to achieve it. Thanks Suresh Quick answer is no. Check out the following posting for more info. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=941980&SiteID=1 Gary ...Show All

• .NET Development How to retrieve a list of active sessions?

  I have an ASP.NET application and in Session_OnInit I popuplate an arraylist in my "Application" space which contains all IDs of users logged in. I want to do this: If an user log into my web application and another user is logged this the same account, I want that the last user that log in take a valid session so I want to invalidate the session of the "old" user. Is there a method to access the list of active sessions on web server and Invalidate a specific session to forced the logout of an user logged in ASP.NET web app specific questions should be asked in the forums at http://forums.asp.net . This forum is for questions related to web services. My best guess at an answer for ...Show All

• Microsoft ISV Community Center Forums VBA, Null value and data object not set?

  This issue is getting my nerves. In VBA, I can't just say, if MyObject = Null to determine whether the object is set or not. IsNull is pretty uesless since it will report false when the object is not set. VBA treats Null as a value, not an object that hasn't been initialized. Does anyone knows how to get around it Or maybe there is proper way to determin whether the object is initialized or not Like a simple code MyObject == Null in C# Hi, Try using Is Nothing for objects. If MyObject Is Nothing Then MsgBox "MyObject is nothing" End If ...Show All

• .NET Development WinForms app and socket connection

  Hi, I would like to get your opinion on this: I have WinForms app and at the main form I'm opening a socket connection to the server. This connection should stay open until the user closes the app. What's the best way to share the same socket with other forms that may opened from the main form A global variable at the main form will be a good idea Thanks. Ubercoder If you only ever want to have a single socket then statics are an option. Depending on your requirements I suggest looking into 3-tiered architectures (a heavy weight solution) or possibly a simple implementation the fascade pattern to decouple your logic from your UI. ...Show All

• Smart Device Development Problems with creating a fullscreen app

  I am wanting to create a fullscreen app and am having problems. I have seen the MSDN writup using SHFullScreen and SHInitDialog. And that works when the application is started. But if a person switches to another app such as the desktop then back to ours, the Commandbar along the top remains exposed. Setting the dialog as topmost window doesn't seem to help at all. It only restores itself by clicking on it. Any ideas Implement fullscreen using mfc like this: SHINITDLGINFO shidi; ZeroMemory(&shidi, sizeof(SHINITDLGINFO)); shidi.dwMask = SHIDIM_FLAGS; //if (aygshellUIModel == PocketPC) //{ shidi.dwFlags = SHIDIF_DONEBUTTON | SHIDIF_SIPDOWN | SHIDIF_SIZEDLGFULLSCREEN | SHIDIF_EMPTYMENU; // shid ...Show All

• SharePoint Products and Technologies Dependent columns in Sharepoint lists

  Hi there, I'm currently working on a project with Sharepoint 2007 and I need some help to deal with two issues. 1) I have a list that has dependent columns. I have a column "Department" (dropdown list) and a column "Section" (dropdown list). The requirement is that the set of values available in dropdown "Section" depends on the selected value of "Department". For example, if I select Department="DepA", the values available to Section should be A1, A2, A3. If I select Department="DepB", the values available to Section should be B1, B2. I would like to put this dependencies configured in another list (with columns Department and Section), somehow hidden. But I'm not figuring ...Show All

• Visual C# Looking for an equivalent of this code in C#

  javascript:alert("The true URL is:\t\t" + location.protocol + "//" + location.hostname + "/" + "\nIf this does not match the URL shown in your browser address bar, you are likely to be seeing a web page from a different web site! We recommend that you close you browser and empty your browser cache now."); I would like to get the equivalence of this code in c# so that I could integrate this into my application wherein it checks if the page is a spoof or not by looking at its url equivalent. Hope you could help me. Thanks. Ichi Could you explain it a little bit clearly. I am still a newbie in C# and if you could expound it a little clearly, it might help me good sir. I ...Show All

• SQL Server Question: Can i synchronize the mobile device which has a SQL Server CE database with the Access database on the desktop?

  Dear All, i have a question abt winCE 4.2 and SQL server CE. i am using VB.net of Visual Studio 2005 My platform is using a PDA with winCE 4.2 and SQL server CE. The Host program is using dbf files on desktop side. I got a problem of how to sync / read the sql CE data from a windows application. so, i wanna ask, 1. any method to access the data from winCE data by windows application or can i convert the sdf file to windows readable files or any others 2. Can i use a MDB to sync with SQL server CE can i synchronize the mobile device which has a SQL Server CE database with the Access database on the desktop last question, 3. is that windows CE .net 4.2 not support pocket access (cdb) anymore please help me out ...Show All

• SQL Server Having two issues with SQL Server 2005

  I'm having two problems and one of those problems is making me feel like something of an idiot. 1) How the heck do I access the Query Analyzer I have a stored procedure that I'd like to watch variables in during debugging and I've been told the Query Analyzer is the way to go. In 2005 you are supposed to be able to access it directly from Management Studio but I can't figure out where it is. 2) I am trying to run the Database Tuning Advisor, but when I choose a database and workload then click "Start Analysis" I get a Microsoft Visual C++ Runtime Library error. A message box appears and says: Runtime Error! Program c:Progr... R6031 -Attempt to initialize the CRT more than once. This indicates a bug in your ...Show All

• Windows Forms Loading same user control

  I have a scenario for an MDI C# application, in the parent form there will be a datagrid from which a user may select one or multiple records. I will have to grab only the selected specific record cell values and pass it on to anotgher child form. Based on the number of selection the destination form will dynamically genrate the selected values list and a text box comments field next to each value. I have created a user control that has two text boxes, one read only that displays the selected datagrid cell value and another text box which the user may use to write comments about that cell value. I want to load this user control depending upon the number of record selection from the datagrid, for example if five records are selected then I ...Show All

• Audio and Video Development Video Events

  How can I handle video events in the script For example, when new chapter started. Or when certain frame reached.       Bryan Kilian - MSFT wrote: It needs to be "scheduled_event", not "ScheduledEvent" in your AddEventListener Ok that was it - THANKS! But why Where in the spec does it define the name of the scheduled event parameter Table 8.3.1-1 just calls it "Scheduled". ...Show All