Renzo Ruiz's Q&A profile

• SQL Server SQL 2k5 connection to SQL 2k

  So I posted this question here... http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=325966&SiteID=1 but perhaps that was the wrong forum. I have a new SQL2005 instance that is not able to connect to my old SQL2000 instance. However, I have many other instances of each and all the OTHER 2k5 instances can connect to the 2k instance above, and the 2k5 instance above is able to connect to all the OTHER 2k instances. I have been searching and uninstalling/reinstalling for almost a week now, and I'm approaching a deadline for getting the production system migrated to 2k5. Any help would be greatly appreciated. flyonthew ...Show All

• .NET Development How to connect to internet using dialup

  I want to write a program to dial a number, authortize the password, and connect to internet. Would anyone help me If you use C# to connect to the internet, shouldn't OS prompt user to verify the connection automatically (just a guess, I haven't been using modems since year -97) Well, at least you shold ask the user first, othervise your program is considered as a dialer and soon blocked by malware scanners allaround the globe... ...Show All

• SQL Server Problem using dates in XMLtoFLFF Transformation

  I am having a bit of trouble transforming a XML (xs:date) type to the DBDATE in my FLFF. I believe the problem is because the SSIS DF (Metadeta) converts xs:date to DT_DBTIMESTAMP which becomes 01/01/2005 00:00:00 -- appending the time. So when I try to transform in my fixed length flat file, it throws a truncation error when the length is set to 10. (which is the length of date) Is it possible to (A) use some other xs format that changes DF Metadata to only use date and not DT_DBTIMESTAMP, or (B) is there a field type in the destination FLFF Connection that will allow a length of 10 without throwing a truncation err ...Show All

• Visual Studio Team System Check for true sentence

  I want to know how can I check a sentence like that on the code: if(isInt == true) I mean, I want to know if that sentence exist on the code... There is no way to determine if an assembly is part of the .NET Framework, without hardcoding the list of 'known' assemblies. Then the issue occurs in future releases when more assemblies are added, for example WinFx (Avalon, Indigo, Workflow, etc). ...Show All

• Visual FoxPro report temp file not found

  I need to create a simple report, nothing fancy. Just to preview some memo fields. This is the code I use. lcFile = "C:\VFP_Projects\Reports\MyReport.FRX" SET DIRECTORY TO "C:\VFP_Projects\TEMPORARYFILES\" CREATE REPORT (lcFile) FROM (ALIAS()) FIELDS memo1 The second line (set directory to) should be explained. I get an error that a temp file c:\\VFP_Projects\Data\...\000035e10062.tmp no found. Options are "Locate," "Ignore," "Cancel," etc. Naturally the file name changes every time I try to create a report. Thus the name above does not mean anything. The error messages comes up ever ...Show All

• Software Development for Windows Vista Workflow from XAML with Custom Activity

  Hi people! I'm trying to run the ideas/examples exposed in the article: Simplify Development With The Declarative Model Of Windows Workflow Foundation http://msdn.microsoft.com/msdnmag/issues/06/01/WindowsWorkflowFoundation/toc.asp In the article, the authors load the workflow dinamically from a xaml file. In the xaml file is a reference to an custom activity in the same assembly. I can't found the source code of the article.... Has anyone a running example like that My test example fails: <my:WriteLine Text="Hello, world from WinFX." xmlns:my=" http://schemas.example.org/MyStuff " /> show an error in the des ...Show All

• .NET Development Setting my controls properties using xmldocument class

  can you use the xmldocument class to create a xml document from scratch, or do you first need to use xmlwriter to create the file You can create a XmlDocument from the scratch. Use the Create methods to create XmlNodes and use the Append method to append the XmlNode to you document. Here is a little example: XmlDocument doc = new XmlDocument(); XmlElement myElement = doc.CreateElement( "MyElement" ); XmlAttribute myAttribute = doc.CreateAttribute( "MyAttribute" ); myElement.Attributes.Append( myAttribute ); doc.AppendChild( myElement ); doc.Save( "c:\\test.xml" ); ...Show All

• .NET Development Commenting out an element within a node

  I'm having a hard time figuring out how to comment out an element inside a node, working with XML in memory at runtime. I do not want to write anything to file. I basically have this inside an instance of XmlNode: <ParentElement>   <ChildElement1/>   <ChildElement2/> </ParentElement> and I want to end up with this: <ParentElement>   <ChildElement1/>   <!--ChildElement2/--> </ParentElement> (or this, doesn't matter which: <ParentElement>   <ChildElement1/>   <!--<ChildElement2/>--> </ParentElement> ) If I pull ChildElement2 into its ...Show All

• Visual Basic Visual Basic Compiler Error Hotfix

  Hi all i just want to know when is going to be released the fix for visual basic compiler error &H8013141e&   this is already reported in the microsoft productfeedback site. i think this is a very urgent patch that must be released asap and please do not repond that i should go back to vs.2003 because i have lots of code developed in VS 2005 to framework 2.0 ..   JSB PS: this error pisses me of, i need to restart VS.IDE every 5 minutes. i think this is too bad for a recent relesase product ( its full of Bugs ).   Hi, João, This is a good opportunity (in the ...Show All

• Smart Device Development convert sdf to xls

  How convert my sdf file on xls table Or how could read my sdf file on windows xp Thanks in order to convert SDF to XLS , u can used Push method from SQL CE to push the data from SQLCE -> SQL Server Dim rdaObj As New SqlCeRemoteDataAccess rdaObj.InternetUrl = "http://NB-039/Customer/sscesa20.dll" rdaObj.LocalConnectionString = "Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data Source=\My Documents\CustomerDB.sdf" rdaObj.Push("Customer", "Provider=sqloledb; Data Source=(local);Initial Catalog=Northwind;User Id=sa;Password=", RdaBatchOption.BatchingOn) rdaObj = Nothing Then using ADO.NET technology , u can used ...Show All

• Windows Forms Creating a Web Browser

  Does anybody know of any tutorials on creating a Web Browser using .Net and C# I have searched google with no real luck. I just want to put together a simple browser, nothing fancy... anybody have any ideas in how I could get started Take a look at <a href="http://www.istaysharp.net">IStaySharp.NET</a> and on <a href="http://www.codeproject.c ...Show All

• Visual Basic maskededit issue

  I am using VB 2003. I have a maskededit control, but its behaviour is funny. It is bound to a field in the a MSDE table. On the form, the maskededit displays nothing and yet when I check for its Text property, it has the correct database value. Is this a known issue, and any workarounds Please, can you mention this is web form or win form If that is customised control create by other people. Of course it is won't fits your need. ...Show All

• .NET Development count total rows in text file

  Hello all. I am using text files (using File stream) to store email addresses. I have four files which email addresses are stored in. I have a stream reader that reads through the text files (File stream). I have put a FOR LOOP that counts the text files ie. for ( int i=1;i<=4;i++) { FileStream fs=File.OpenRead(Server.MapPath("..\\")+"emails\\"+"test"+ i +".txt"); StreamReader sr= new StreamReader(fs); for ( int j=0;j<5;j++) { mailAdds=sr.ReadLine(); } } now what i want to do is that when reader reads throught the text files it should know how many rows are there in each text file. I have hard coded 5 here as I don't ...Show All

• Windows Forms Where is the best place to update a rows LastModified DateTime field before saving to database?

  Hi, Where is the best place to add code to a DataTable to update a LastModified DateTime field before saving the row to the database I've tried doing it in the RowUpdating event, but the row values have already been used to create the UpdateCommand parameters, so I have to do the following: e.Command.Parameters["p2" ].Value = DateTime .Now;   Doesn't look very good to me (especially the hard coded parameter name "p2"). There must be a better way BTW it's an Access database, and I'm using VS2005 RC, C#. Thanks, Ben I too would love an answer on this one. I have yet to find ...Show All

• Windows Forms property best way

  what is the right way to get a value in the following case   >>>  class NameBuilder  Private _name As String  sub new(byval initName as string)  Name = initName  end sub  Public Property Name() As String  Get  Return _name  End Get  Set(ByVal Value As String)  _name = Value  End Set  End Property  End class  now if I Set the property >&g ...Show All