BLiTZWiNG's Q&A profile

• SQL Server yyyymmdd text data into a datetime field in SQL Server?

  Hello, I have an Excel spreadsheet that contains 100,000 + rows of data. Two of the columns in the spreadsheet are date fields that are sent over in the yyyymmdd format (no separators such as "-" or "/"). I tried converting these fields into dates using the Data Conversion task in SSIS. This doesn't work as it appears that SSIS cannot map a string in the format of yyyymmdd to a valid date. In lieu of this, I have added a Script Component to my transformation which can take the string and convert it to a date value using some Substring() calls on the source yyyymmdd string. A few questions for the group ... 1. Is this there a more efficient or "better" way of performing this transformation 2. I can ...Show All

• Visual Studio Source control integration... impossible?

  Hi all, We are trying to find a way to monitor and react whenever our developers do a checkout from source control and we want to run a macro when they do. There doesn't seem to be any way to do this. Can anyone suggest how Yes, this fits with my understanding. I could not find a way of hooking to source control events in macros and even if we "upgrade" to an addin then I wasn't confident that we would have the hooks we needed. In the end I decided to keep a list of files that are under source control but not checked out (using the open document event) and on every key press see if the key is in one of these documents so might result in an implicit checkout or might imply ...Show All

• Windows Forms refresh image problem

  in my button click i have some codes like this for uploading photo to my page ; file is uploading correctly; but i want that after file uploaded succesfully!! label message it must put this photo to my image1 control; Boolean fileOK = false ; String path = Server.MapPath( "~/UploadedImages/" ); if (FileUpload1.HasFile) { String fileExtension = System.IO. Path .GetExtension(FileUpload1.FileName).ToLower(); String [] allowedExtensions = { ".gif" , ".png" , ".jpeg" , ".jpg" }; for ( int i = 0; i < allowedExtensions.Length; i++) { if (fileExtension == allowedExtensions ) { fileOK = true ; } } } if (fileOK) { ...Show All

• Smart Device Development DSP Plugins for Windows Media Player Mobile(smartphone)

  Hi, I am trying to making a DSP Plugin for Windows Media Player Mobile. I am using Visual Studio 2005, DirectX SDK, Windows Media Player SDK, Smartphone Emulator and Windows Mobile 5.0 SDK. I am able to deploy my plugin to Emulator. but i am not getting effect of that plugin in Windows Media Player Mobile. Same Plugin is giving me good effects on Desktop Windows Media Player. May be problem is the register of that plugin in Windows Media Player Mobile. If anyone has idea to that, Please reply me. amit.pshah@wipro.com Hoping for a positive response. Thank you in advance. Amit P Shah. ...Show All

• .NET Development How do I author XSD for Importing Xhtml elements? (compound xml document definitions)

  G'day, I'm trying to create an XSD with a reference to an external xsd (xhtml or one of the flavours of html). At the end of the day I would like VS2005 IDE to have intellisense on the elements that refer to xhtml, so when I'm typing in the instructions element in the *.xml document I get the same intellisense that you get during a normal editing of a html page (source) would. As you can see by the example *xml bellow, I've stuffed something up. Would any one point me in the correct direction I'm obviously also using xslt to generate html documents from this xsd/xml documents. Are there any "dangers" of designing the xsd to reference html elements when you want to just output the contents of the <instructions> ...Show All

• SQL Server Post 2005 SP2 install, no script component can be edited.

  Anyone starting to see "Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)" after installing SQL Server 2005 SP2 on x86 machines   Second, how can it be fixed After installing SP2, the script component editor will not edit script components created in pre SP2 releases. (I also have Visual Studio 2005 SP1 installed). The script TASK editor will start, but when attempting to open a script COMPONENT in the VSA editor, a script component created for pre-SP2 packages, the following error dialog occurs. Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio) This same error dialog has occurred on multiple computers, none of them are running Vista (rather Windows XP SP2). All of the pre-existen ...Show All

• Windows Forms How can i copy the highlighted text from the CURRENT active window to the clipboard using c#?

  It's probably very simple but I would appreciate the knowing what the method should be, cheers. Under the proverb "give a man a fish..." I give you a hint: TextBoxBase.Copy Method ...Show All

• Windows Forms Load Data Set

  When I try to load a dataset I get 0 rows loaded and no error messages. It should be returning 2 rows. Can you see what I am doing wrong This is how I call it: Dim tblDates = dsStaffHoursWorked.tblDates mTableFill.subTblDatesFill(tblDates, dfEndDate, dlEndDate) ---------This is sub procedure that is called. Public Sub subTblDatesFill( ByVal tblDates As System.Data.DataTable, ByVal FirstEndDate As Date , _ ByVal EndDate As Date ) Try Dim Conn = "csStaffHoursWorked" Dim strSQL = "select distinct enddate from dbo.tblStaffHours where EndDate between '" + _ FirstEndDate + "' and '" + EndDate + "' order by enddate asc" Dim da As New S ...Show All

• SQL Server connecting to remote server

  Hi friends we've C# app that connects a sql server 2005. we've new requests from client that when users go offsite they still want use our app and connect to sql server. my question is how can we connect to sql server remotely is it using TCP/IP protocol if so how do we do that Thanks for ur help. Thank you very much for ur replies Hong. still need some clarification as am not fully aware how DNS works . currently in our connections string we specify our sql server name as "mallu" and other info like database etc.,(btw we use enterprise library for data access) are you saying that once we open port on our server and allow remote connects abv connection string just works i mean say if we our server is in new ze ...Show All

• Visual Studio Express Editions Newbie needs answers about parsing a fixed width textfiles

  Ok the problem is that i need to parse a fixed width textfile with about 15,000 lines , do some math on the data and output the numbers to something that i can make auto update a  couple of lines on a webpage, im not even sure this is possible, heres an example of the textfile. 2006111420061114053948000010304472028280000001 2006111420061114053951000020304472025400000001 the fields go like this, date 1, date 2, time, seq#, station id#,  id#, weight, shift i need to break it up, discard some of the fields , add a decimal point to the weight column and do some math in the sequence colum and weight columns. so far all i can get it to do is spit a jumbled mess into a text file, any help would be greatly appreciated. thanks in ...Show All

• Visual Studio Team System Can exceptions have additional properties?

  The implication of the ImplementStandardExceptionConstructors rule is that exceptions shouldn't really have additional properties; which seems bad. (This started on this earlier thread; http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=135027&SiteID=1 ) Is that really the recommendation If no, then this rule is too aggressive to have a 95% certainty and nothing under the "When to Exclude Messages" section. If yes, then the only difference between all the exceptions is their type name All exceptions classes could really be instantiated out of a single boiler-plate template where you just fill in the new name. In this case, it's a pit I need to write 50 lines of C#. You could imagine it just be: class MyNewExceptio ...Show All

• Software Development for Windows Vista Directshow Error : Classfactory Cannot Supply Requested Class

  I have created a custom Directshow source filter. This filter works fine in GraphEdt (I can use intelliconnect to render the output pin with no problems at all). But when I try to replicate this inside of a C++ application I get the following error. Error 0x80040111 :Classfactory Cannot Supply Requested Class. I have no problems chaining other custom filters together in the app. and I have tried to explicitly chain the GraphEdt filters together (using DirectConnect) yet I still cannot get the source filter to work in my custom app. Any help on this issue would be greatly appriciated. My immediate guess is that your c++ code is loading the wrong filter. Failing that, try putting a brea ...Show All

• SQL Server Need example of a "Hash" function.....

  Many articles on sql server security make reference to Hash functions. Do you know of a simple example of a hash function that I could show to others For example, would taking the first eight bytes of the mathematical "sin" of a number be a good function I don't know. Or is a hash "function" actually an involved algorithm, so the "simple" formula I was looking for really doesn't exist. TIA, Barkingdog In SQL Server 2005 we have a new builtin to calculate hash functions: HashBytes. For more details on this builtin I recommend consulting BOL ( http://msdn2.microsoft.com/en-us/library/ms174415.aspx ), but here is a short example: SELECT HashBytes ...Show All

• Connected Services Framework Difference between OH-SBE in 2.5 Vs 3.0?

  Urgently need this information how different is OH-SBE between CSF version 2.5 Vs 3.0. What all we should take care if we work with 2.5 as compared to 3.0. hello, we have developed using oh sbe 2.5 and we are passing to 3.0. Reading development guide is not clear how to configure oh sbe using the configuration tool. There are few lines about it and we don't understand which are the actions to execute for configuring sbe. For example using oh sbe 2.5 we map an order (using productid and action) with a template manifest to pass to session. Really i don't understand how to associate a template manifest to an order using oh sbe 3.0. it seems that we can associate template manifest in system configura ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. I like that... maybe with a list?

  Hi: Are there any tutorials regarding applying any effects to sprites or textures For example I want to apply 'motion blur' based on the sprites velocity vector. Do I need to write some kind of custom shader or does the XNA framework have this included Any help greatly appreciated! Regards: John I like that idea. For example you could have a list of, say, the last 5 draw positions, and update the list in your update() loop. In your draw() loop, you go down the line from oldest to newest, least opaque to most opaque. Each time you update, just add the most recent sprite position to the list, and remove the last position. Does that sound about right I'm guessing it would look kinda like when you turn &qu ...Show All