Badgeror's Q&A profile

• SQL Server How to connect SQL Server Mangement Console to Adventure Works

  This may not be correct request but I have SQL Server Management Studio Express.  How do I connect the Adventure Work Database to the console How do you use Access to connect to the SQL Server Express Thanks for your help. Mark's instruction is working. Alternatively, you can use the following script to attach AdventureWorks database if you install it using default settings. EXEC sp_attach_db @dbname = N'AdventureWorks', @filename1 = N'c:\Program Files\Microsoft SQL Server \MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf', @filename2 = N'c:\Program Files\Microsoft SQL Server \MSSQL.1\MSSQL ...Show All

• Visual Studio Why my form cannot release resources(such as memory)?

  Hey, I have a MDIParentWindow ,and I open a MDIChildWindow from it.This MDIChildWindow is using CrystalReportViewers to show some Crystal report documents.But I noticed after I closed this MDIChildWindow ,the system resources used by this MDIChildWindow were not released.If I open and close this MDIChildWindow again and again,it happenned everytime.Would you please tell me what's the problem Appreciate for any help. In MDIParentWindow I wrote the following code: AdvancedReport TodayReport = new AdvancedReport(DateTime.Today, DateTime.Today); if (TodayReport.CanBeShown) { TodayReport.MdiParent = this; To ...Show All

• Visual Studio Passing custom objects to t4 templates

  This question has been asked before but I have a new twist for you. Looking to pass my own custom objects to a t4 template by calling TextTemplateAction from within my own Action class. The problem is that TextTemplateAction.Configure() takes a StringDictionary for the template args. Are there any other ways to pass this along I've basically done the following 1. Set up a RecipeArgument based on my custom objects type. 2. Specified that my custom action (the one which calls TextTemplateAction) should receive this RecipeArgument. 3. Configured the template to import namespaces and set assembly references to the custom object a ...Show All

• SQL Server Can a Data Flow Task mimic Bulk Insert?

  Hi Guys, The way I understand a Data Flow Task is that it inserts the rows from the source to destination one by one. Is there a way to make it act like a bulk insert task We have been experiencing performance issues when inserting a lot of rows from one table to another. If there's no way to actually do it, can a bulk insert task functionality be scripted Coz what I need is a table to table insert, and the bulk insert task only accepts data files as sources. Thanks! Kervy What destination object are you using The OLEDB Destination and the SQL Server destination both enable bulk insert opti ...Show All

• .NET Development FtpWebRequest method=Create Directory problem with "#" in the directory name.

  When i try to create a directory on a server with FTPWEBREQUEST with a # character in the directory name it only creates the directory name up until the # character. For example if i try to create the directory "C# Express" only "C" gets created on the server. I if send "C++ Express" it creates "C++ Express" on the server. I'm going to check into other characters that are valid for a directory name but don't get created with FTPWEBREQUEST. lushdog I'll try that but my directory names are coming in through a dialog box so i'll have to rewrite some code to f ...Show All

• Visual Basic Application.ThreadException event troubles

  Could someone explain why this code will not trap unhandled exceptions.  This is in VS2005 and is a simple winforms app with a single form: Public Class Form1    Private Sub Form1_Load( ByVal sender As Object , ByVal e As System.EventArgs) Handles Me .Load       AddHandler System.Windows.Forms.Application.ThreadException, AddressOf ErrorHandler    End Sub    Public Sub ErrorHandler( ByVal sender As Object , ByVal e As System.Threading.ThreadExceptionEventArgs)       MessageBox.Show( "Unhandled Exception Caught ...Show All

• Visual Studio Express Editions insert filename into SQL Table

  Hi I'm just not getting this but how can you insert the filename into a table. I managed to upload a file from website to my hard drive but now what to save the filename to a field in the database. Can someone please help Here's the code for aspx file and following the code for aspx.vb file: <% @ Page Language ="VB" MasterPageFile ="~/MasterPage.master" AutoEventWireup ="false" CodeFile ="AddFoundImage.aspx.vb" Inherits ="MemberPages_AddFoundImage" title ="Untitled Page" %> < asp : Content ID ="Content1" ContentPlaceHolderI ...Show All

• Visual Basic String to Hexadecimal

  Hi folks! I need to be able to convert a string, including both text and numbers, to a hexadecimal value. Currently, I can convert numbers to hexadecimal, but it will not allow for text in any way: Dim MyHex As String MyHex = Hex(txtPassword.Text) MessageBox.Show(MyHex) Any ideas greatly appreciated! Tim Any change anybody knows how to convert a string, as previously, to REG_BINARY format Also have a similar problem with converting a string to REG_DWORD. Any ideas Tim ...Show All

• Visual Studio Tools for Office I think that is a Bug in Visual Studio 2005 (ActionsPane)

  Bug in Visual Studio 2005 (ActionsPane)  I am working in machine with visual studio 2005 beta and operating system XP professional and office 2003 with service pack 2. I have an error when I am adding controls in Actionspane in a word Document: this.ActionsPane.Controls.Ad(new DateTimePicker()); Because, I proved that in another machine with widows wp professional and office 2003 with service pack 1, and work correctly. The problem is that I don't know How I solving that. I read in some page Internet that i have format my machine but I don't want. Marcela Moreno System Engineer - ECI Banco de la Republica Fiduciaria y valores ...Show All

• SQL Server A QUERY THAT RUN ON DB2 THAT HAVE MORE PERFORMANCE THAN SQL SERVER 2000

  The execution time for this query on DB2 v8.0 DBMS one second but I execut e it on SQL SERVER 2000 is around 55 second so how i can incease the performance for SQL server SELECT ACC_KEY1,ACC_STATUS_LAST FROM PSSIG.CLNT_ACCOUNTS INNER JOIN PSSIG.CLNT_CUSTOMERS ON PSSIG.CLNT_ACCOUNTS.CSTMR_OID = PSSIG.CLNT_CUSTOMERS.CSTMR_OID WHERE (PSSIG.CLNT_CUSTOMERS.CSTMR_START_DT >= '1900-1-1 12:00:00') AND (PSSIG.CLNT_CUSTOMERS.CSTMR_END_DT <= '2106-12-31 12:00:00') AND (PSSIG.CLNT_ACCOUNTS.ACC_KEY1 >= '0000000000000') AND (PSSIG.CLNT_ACCOUNTS.ACC_KEY1 <= '9999999999999') AND (PSSIG.CLNT_ACCOUNTS.ACC_ ...Show All

• Smart Device Development Database Connectivity on Pocket PC 2003

  Hi !! I am facing a problem in my project. Pls Help... Project is: I want to build an application for a pocket Pc that could access a DB on a server that it connecxts through Wi-Fi The problem is: I have cradled the emulator(Pocket PC SE Emulator). In server explorer, I am easily able to connect to the database but when i run the code it gives "SQL Server does not exist". Through server explorer, I am even able to see the contents of the tables. But i am not able to realize what happens to the emulator. Please guide. An early response would be great. Since i am under pressure for a deadline. Thanks, Regards ...Show All

• Visual Basic Copy Protection Code??

  Does anyone have any idea how to copy protect the software that you write Does anyone have any simple ideas that might involve the use of a serial number or some kind of encryption Thanks! I guess I would like to try and use my own copy protection scheme. I realize that my software isn't going to be the next Windows so I don't want to spend any money on purchasing something OTS. Although it would be nice to add a little protection to the software that I spent time to develop... Thanks! ...Show All

• SQL Server Problem with simple subquery in SQL2005 AND SQL2000.

  When I use the simple query with a subquery shown below, this is the error message I get in SQL 2000 AND SQL 2005 "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression." And here is the query I use: SELECT docSections . SectionID , ( SELECT docSectionText . colText FROM docSectionText WHERE ( docSections . SectionID = docSectionText . SectionID ) AND ( docSectionText . colOrdinal = 1 )) AS SecTitle FROM docSections Can anyone please let me know what I do wrong here. Tha ...Show All

• Windows Search Technologies WDS 2.6 EID Encoding

  Hi out there- I would like to find out how to decode the mapi: url -- with the new funking data embedded into the unicode string. Hello pweyzen1, I have attached the scheme for decoding below. I hope this helps. Paul Nystrom - MSFT // // convert the string rep to the eid for it // void CEntryId::FromString(__in CString &strEIDU) { //----------- Decode with YEncode like algorythm ------- // decode using pseudo YENC encoding, everything is shifted up by 0x30 starting it at the '0' letter. // Things that wrap have an escape '!' followed by a 0x60 ...Show All

• Visual Studio Dundas charting in WinForms local mode

  Hello!  We're a small ISV that's doing quite a bit of reporting using the Windows Forms ReportViewer in Local mode. Dundas ( http://www.dundas.com ) makes some useful charting extensions to Reporting Services.  I believe their product is called "Dundas Chart for Reporting Services". We sent them an email inquiring as to whether these would work in Local mode.  Their reply was: "I am sorry but MS did not extend the custom report item functionality to local reports.  They also did not include custom renderers and other features to this method of reporting also." Here's our question:  Does Microsoft plan to add thi ...Show All