Silver's Q&A profile

• SQL Server Help with Report Filter on bit field

  I have this filter for my report table : expression                         operator         Value =Cstr(Fields!work.Value)         =                        'True' My report's table isn't returning data, but in preview but if I run the dataset, there is clearly some valid records tha contain 'true' for the f ...Show All

• SQL Server SQL Agent Job Creation: SQLAgentAdmin

  We are using SQL Accounts to access our JUNE CTP Standard build of SQL2005. (We are cross domains that don't trust each other, and will never will as we are migrating to ActiveX). We setup a new account: dbo_<dbname>  gave it DBO access to the database that it is running on. We need to create some jobs (that are scripted from the original server) to run in SQL Agent. Per the documentation: for sp_add_job We granted this account: dbo_<dbname> the database role of: SQLAgentUserRole inside the msdb database.  When running the script we get the following error message:   Msg 229, Level 14, State 5, Line 13 SELECT p ...Show All

• Visual C# GetModuleHandle(null) equivalent in C#

  Currently I'm using DLLImport for the method: GetModuleHandle( null ) I would prefer moving away from it. Does .NET have an equivalent There's a method: RuntimeTypeHandle.GetModuleHandle () but that's not it, or is it What do you then do with the handle you obtain .NET doesn't have a direct equivalent but there may be other ways to accomplish the end result. ...Show All

• Visual Basic Calling a sub while reading an array?

  I'm not the most sophisticated programmer, so you'll have to forgive me as I may be approaching this totally incorrectly. One of the programs I'm working on now deals with Morse Code and different methods to output data to the user in Morse Code...example, PC beeps or with wav files. The concept is this: User selects output method, user selects demonstration and clicks play. The demonstration directly corresponds to a specific file. Read in the file when the user clicks play and then sound the file one character at a time (including spaces) via the output method chosen by the user. I've got almost everything working but I'm ha ...Show All

• SQL Server Network access SQLExpress

  I am  trying to access a SQLExpress database on another computer on my LAN.  Using Windows Authentication. I don't really want to go to Mixed Mode authentication as I understand it involves a registry tweak and creating a new user. I am a novice at this. Getting the following error on running the connection code below: SQLException was unhandled "Login failed for user 'D37YKC1S\Guest'." No doubt it is a security problem but I am not sure how to get around it.  Any help appreciated. Connection code: Dim conn As New SqlClient.SqlConnection conn.ConnectionString = "Server=D37YKC1S\SQLEXPRESS;Inte ...Show All

• .NET Development Most of things require much lesser code in .NET. Some things NOT!!!

  Hi! Intro | After a few years dealing with .NET I can say that I'm very pleased with the fact that I have been working with Microsoft Development tools in my carreer. And this includes starting from GW-Basic, moving to VB5 and 6 and now 7 and 8 and a little C#. Less Code | Most of things require much lesser code to implement. The code is almost completely managed and there are much fewer chances of using third part components or WIN32 API to get things done. However | There are some other things however that require more code than before. And the question is why For instance, to detect if the user clicked on the X button of a window to clos ...Show All

• Visual Basic Is "Visual Studio Tools for Office" necessary

  Without "Visual Studio Tools for Office" is there ANY way to access the data (both read and write) in an Excel workbook from VB.NET 2005 You don't need VSTO to work with Excel workbooks. If you add a reference to the Microsoft Excel X.0 object library (of 11.0 for Office 2003, 10.0 if you are using Office XP), you can automate excel. Please not the the 'Microsoft Office Excel X.0 Object Library' is COM reference, so you should select the 'COM' tab when you add the reference to your project. Also not that the computer you'll be running the code on must have Microsoft Excel installed. ...Show All

• Visual C# Raise event from IE hosted windows user control and catch it in the Web Form that’s hosting the control

  Hi. I have a web app that uses a IE hosted windows user control. I would like that, somehow, lounch an external event from that hosted control that I could catch in my web form’s code behind. If possible, please send me a small sample project ( bozesan_mihai82@yahoo.com ). But, of course, I would appreciate any suggestions! Thanks in advance! Hi! Launch event from client side to catch in the server side You need to post back web request. I'm not sure this is the best way, but I think it's good to create button on web form (hidden button) and from your control push this button. ...Show All

• SQL Server Is there any way to 'undo' an update query?

  I guess I am in big trouble now. I have updated a table by querying in SQL Query Analyzer and one of table columns was all set to wrong data (of course it was because of my mistake in query sentence).   I am wondering if there is any way to recover this table Unfortunately my database was not backuped after this table was created. I am wondering what the log file is for. Maybe can there any way to retrieve a table's old status by using the log table   Any help OK. I guess I gotta do all annoying import job again to make the table. Anyway, thanks a lot, Greg. I appreciate ...Show All

• Smart Device Development What's better, designer or code?

  Hi I'm developing an app that will have perhaps 6 or 7 different screens that can be chosen from a menu. My question is should I create all the forms graphically using the form designer, or should I create them all in code What would be better, not only in terms of speed but also the size of the finished application - is there a right or wrong way Many thanks Mark Forms are created "in code" whatever with or without designers. Designers do not use any magic to create forms, they just generate code for you which you would have to type anyway. So, unless your goal is to slow down developme ...Show All

• Visual Studio Team System Team Build - Build Directory?

  I'm a little confused as to why the new build type wizard asks for a build directory.  You have to specify a workspace and since that specifies a local directory I would have thought that the build would just occur in that directory.  Why not just build in place Thanks Marcel for explaining our design and for the feedback. We could have asked users to define a dedicated workspace for build machine. This has few limitations - accidental deletion of this workspace will break builds, no way to check the workspace before using for build. Our design allow you to create a workspace on your dev ...Show All

• .NET Development code access security

  I have an application where the BR is completely based on plugins that run inside a framework I have developed. (This is in a Windows program).  Most of these plugins are written by myself, but the option is open for others to create their own plugins.  A plugin must inherit from one or more of my classes.  Basically I want to do 2 things in my framework. 1. Catch all exceptions that get thrown by plugins, and unload these plugins if they become troublesome to the system. 2.  Prevent these plugins from creating new threads. Number 2 is the most important issue and the thing that has eluded me most in my searches.&nb ...Show All

• SQL Server Cannot insert explicit value for identity column

  I am writing a program to import data across from one database to another. I need to be able to make it use the current ID numbers or else the relations will be broken. I keep getting: Cannot insert explicit value for identity column in table 'mytable' when IDENTITY_INSERT is set to OFF. I have opened up SQL Server Management Studio created a new query with: SET IDENTITY_INSERT [BMSSUNRISE] . [dbo] . [SystemInventory] ON GO this results in success but the program still fails, I have tested the Insert SQL statement in the SQL Studio tool and included the above line in front of it and it works. MY QUESTION, how do I get ...Show All

• Visual C++ Question/problem regarding to templates in C++

  <chen_k@discussions.microsoft.com> wrote in message news:ec3f6398-4924-45d1-bef9-a371e8ab7911@discussions.microsoft.com > I wrote a template class that represents objects list. This is its > header: > template< class T, char* filename > > class obj_list > { [snip] > }; > When I want to create an object of the type of this class, by writing > this line: > obj_list<user_info,"user_list.dat"> users > I get this error message: > c:\my documents\tel_op3\tel_op3\info_dlg.h(19) : error C2964: invalid > expression as template parameter   For ...Show All

• Smart Device Development Pocket PC 2003 to WM 5.0 Compatibility Problems: CCeDocListDocTemplate

  Hello all, I am currently using the CCeDocListDocTemplate class, however, I'm having problems with it on a Dell Axim 51, which uses Windows Mobile 5.0. When the widget is used, it displays the list of files in a mangled format. The format appears to be the first character of the filename followed by the creation date of the file: So for a file named "survey.srv" it would show up as: "s11/12/17". This works fine on the Dell Axim 50, which does not use Mobile 5.0. Are there any known issues with this Should I be using something else for the Dell Axim 51 Here's the relevant snippet of code: CString m_strDefaultFolder = CString(_T("All Folders" ...Show All