DavidThi808's Q&A profile

• SQL Server Is it possible to read Flat File data from a Variable?

  Hi, I'm relatively new to SSIS and I've been tinkering with the XML and Flat File sources. I noticed that in the XML source it is possible to tell SSIS to read the XML data from a variable. I didn't see a similar option for the Flat File source. Does anyone know if it is possible to read flat file data from a variable when using the Flat File source Thanks, -dhideal The disk cost may be less than the cost or marshalling data in memory. I have seen similar situations where it has been cheaper to stage data through files, because that way you can use the pipeline which ideally only works on a buffer full of data at one time (not quite true, but the point is there). Therefore you don't have ...Show All

• .NET Development mapping issue with sql executenonquery method

  hi i get following exception when i execute my procedure "No mapping exists from object type System.Data.SqlClient.SqlParameter to a known managed provider native type." code is as follow: dim cmd as dbCommand cmd = dbComely.GetStoredProcCommand( "sp_insertStockTaking" ) Me .strStockTakingId.Value = Me .txtStockTakingId.Text.Trim() Me .strStockTakingId.ParameterName = "@strStockTakingId" cmd.Parameters.Add( Me .strStockTakingId) Me .strRowCnt.Value = strRowCnt Me .strRowCnt.ParameterName = "@strRowCnt" cmd.Parameters.Add( Me .strRowCnt) Me .strBranchID.Value = Me .txtBranchId.Text.Trim() Me .strBranchID.ParameterName = "@strBranchID&quo ...Show All

• Visual Studio Express Editions Themes?

  Hi, How can i change a theme form... kidwidahair wrote: What are you referring to as a 'theme form' Steve Or, Has anyone a program which can create Skins for App And how can i bind in my form in Visual Basic 2005 Express Edition ...Show All

• SQL Server Export to MS Excel carriage returns

  I have a report which has multiple fields in the same column of a table. So that it formats correctly, on the stored procedure side I inserted char(10) + char(13). This allows the next field to correctly carriage return on the report. The report looks great. But once the report is exported to MS Excel, it appears to add in extra carriage returns. This can be cleaned up by going record by record and back-spacing over the carriage returns. Is there any other work around for this Just curious. Thank you for your help. T.J. I haven't found one as yet. The other minor annoyance is that when you open the exported report in excel the cells with carriage returns all have the same row height and hence ...Show All

• Visual Basic Go to next record in a form

  Hi I have a form where i get some data from a sql DB I have made the connection and so on in code I see one record in my form, now i want to make one(two) button with Next record , is theres some one there can just show me some of the code i have made this in vbscript on a internet page, now i shall cout the records an son on but how to make this button to work i don't know Regards Alvin If you are using a binding source on your form then: Me . TestBindingSource . MoveNext () An easy way to implement data navigation is by dropping a BindingNavigator control on your form...this will give you a menustrip with position, first, next, previous, last and new buttons already configured ...Show All

• Visual Studio 2008 (Pre-release) What is the difference between WCF and WebService?

  as the title. Could any one show me the tips or give a link to an article Thanx! WCF is built to interoperate with Web Services that support certain WS-* specifications. WCF includes a number of features such as: secure and reliable exchange, a typed programming model including rich serialization facilities, queued and transacted exchanges, integration with other programming models such as MSMQ, COM+, ASP.NET Web Services, WSE, and other functions. Essentially, you can probably think of WCF as Web Services on steroids. The same interoperability that Web Services provide, but with a ton of other functionality all under a unified programming model. I encourage you to check out some of the material posted on our communi ...Show All

• Visual Basic My.Computer.Network.Downloadfile requires proxy authentication

  Hi All, I've written a small app that during it's course of operation, downloads files using http. Sometimes when I run the app it works fine and then other times a web exception is raised stating that proxy authentication is required. Please can somebody tell me how I can set the downloadfile method to use proxy information Regards Andrew I'm using this overload of the downloadfile method My .Computer.Network.DownloadFile(address, destination, username , password , showUI , timeout, overwrite ) and this doesn't work!! ...Show All

• SQL Server How to read sql tasks and so on from a package programmatically??

  Hi everyone, Once I've accesed to package by means of LoadFromSqlServer method how to read its Sql Tasks, for example I'm trying with the Executables property but unsuccessfully results: pkg.Executables.Item(0) Thanks in advance, Enric, You'll want to cast the executable from the package's executable collection to Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, then you'll have access to the properties you are trying to set. ~Patrik ...Show All

• Visual Basic Finding no. of array elements.

  Is there any function/sub available in VB which return the no. of array elements e.g. x ( i_max ) when i_max = 9 => return value 9. If not then what's the shortest way of writing this kind of function I had some ideas but they are a bit too long for this job. Thx for any help. I don't understand your pseudo function, but if it's purpose is getting the number of elements in an array it's superfluous as you'll see here: Any array is compatible with the System.Array class, so the number of array elements is provided by the int Array.Length property, beware of multi-dimensional or jagged arrays, in which you have to get the length of the appriopriate rank (dimension). If this legacy VB statement is still ...Show All

• Visual C# Parsing from scientific notation

  Hi Im trying to read in values from a file containing numbers that are a mix of "normal" doubles (i.e. 3.23124) and numbers written in scientific notation (i.e. -12e3). I guess this has something to do with the format of the string. Im trying to feed the values into a custum struct called Matrix, which takes doubles... The code I'm using is:   if (numberOfRows>0 && numberOfColumns>0) { Matrix M = new Matrix (numberOfRows,numberOfColumns); fs.Position = 0; int i=0; while ((line = reader.ReadLine()) != null ) { string [] split = line.Split( new Char [] { ' ' }); for ( int j =0; j<split.Length; j++) M[i,j]= Double .Parse(split[ i ]); i++; } fs.Close(); r ...Show All

• Windows Forms Use of the deploymentProvider property in ClickOnce application manifest

  MSDN states that the deploymentProvider property is mandatory for updateable clickonce applications. I wonder why this is the case, as the codebase attribute of the deploymentProvider property always points to itself. eg, my deployment manifest is located at http://localhost/ClickOnce/test.application inside this file, I have the following tag: <deploymentProvider codebase="http://localhost/ClickOnce/test.application" /> If I generate the deployment manifest without the deploymentProvider property (and updateEnabled set), I get an error while launching the clickOnce application. This is indeed what could be expected when reading the documentation, but it is something I do not understand. Why is the property mandatory, even if it simp ...Show All

• Visual Basic vb.net 2003 simple access mdb example? Anywhere?

  I bought vb.net back in 2003 and tried working with it for a few days - then uninstalled in disgust and went back to VB6. I've just decided its time to try out .net again for some database work with an existing access database. I've just spent the entire night searching for an example of just simply opening an access database from a local disk and stuffing some data into a combobox - with absolutely no success. The samples that (didn't ) come with vb.net don't seem to be accessable on the MS site any more. It keeps throwing me VB2005 upgrade "opportunities", SQL server stuff, and other unrelated things. WHen I did finally find the 2003 "quickstart" examples, the link goes crazy and locks up IE, showing a path with ...Show All

• SQL Server SQL Server developer edition failsinstall fails - sqlsui.rll could not be loaded

  I'm attempting to install sql server developers edition on windows server 2003. When I start the install I get a message to upgrade to sp2 or higher after the install is completed. Then I get the following: Execution cannot continue as the language dependent resource file c:\DOCUME~1\MTIDMA~1\LOCALS~1\Temp\1\SqlSetup\Bin\Resources\1033\sqlsui.RLL could not be loaded. Any ideas This is a new one on me. Thanks, Matt ...Show All

• Windows Forms copy file from a server using internet

  Hi I need a program that copys x number of files from a server using internet. files that need to bee copyed is in a list and the program are going tru the list one by one. program is checking if a file is local if found -> do not copy. if file not found locally do copy from a server. Where can I get some more information for this problem. hi Maybe this came out wrong (no response) but Can anyone point me a direction, maybe what DLL supports this kind of traffic on internet, wininet.dll ...Show All

• .NET Development Parsing double value from a string

  Hi all, I need to parse a string which is in the following format (example): -0.0004 USD/Tonnes Basically, it will be a double value, might be preceded by the negative (-) sign and followed by <Currency>/<Unit of Measure> . The result should be just the double value (with the sign if its there), as in the above example, it should translate to -0.0004 I wanted to know if there is an easy way of doing it in C#, like using the Double.Parse() or the string.Format() methods (I tried them both but couldn't get them to work) Or do I have to parse the string character-by-character to get the required result Thanks in advance, MadMonk P.S.: Apologies if its a silly question, I'm still a newbie in .NET ...Show All