Bruce Stone's Q&A profile

• .NET Development How to use System.Net.Mail.SmtpClient via SSL and Authentication?

    Below is my code, and is just blocked there. There is no any error message. '=============================================>         Dim msg As String = "---"         Try             Dim strAddress As String = " xxx@xxxx.com "             Dim sm As New SmtpClient(Host, Port)             With sm               &nbs ...Show All

• Visual Studio Express Editions Transparent Gifs

  I'm trying to get some gifs I have to show in a picture box, and have them transparent... But for some reason they still have a white background. Anyone have any tips on how to get the background to be transparent It shows on the form transparent, but now when I run it :/ Thanks in advanced! Depending on who made the gifs and how they were made.... If all layers were merged.. you'll get a white background. In photoshop you have to be careful to say... Merge only the visible layers" of the result will be a loss of transparency. ...Show All

• .NET Development Oracle Stored Procedure Parameter Information

  Is there any way or method or trick to retrieve parameter information from an oracle procedure. I want to retirieve prameter information like its name, data type, size, direction, etc of any oracle procedure. DeriveParameters of CommandBuilder is failing to do this. I replied to this on the other thread you posted with the same question, so I'm going to lock this one. Other thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=453979&SiteID=1 Thanks, Sarah ...Show All

• .NET Development oracle varchar column truncated on executing stored procedure

  Hello everybody, I am using a stored procedure in oracle database to update the columns of a table.Following is the listing of the stored procedure: CREATE OR REPLACE PROCEDURE usp_Boundary_Update ( IDBoundary IN INTEGER, BoundaryValue VARCHAR2 ) IS BEGIN   UPDATE TBLCI_DM_BOUNDRIES SET BOUNDARY_VALUE = BoundaryValue WHERE ID_BOUNDARY = IDBoundary; END usp_Boundary_Update; I am trying to execute this procedure by using the .net provider for oracle.As I am trying to execute this,I get the following error message: TNS:Packet writer failure and the varchar field Boundaryvalue get only a partial string of what is passed to it. Followi ...Show All

• SQL Server What is faster: DataReader or DataSet or something else?

  Hi, I need to read 250,000 records and show this information. I am using DataReader and it takes 8 seconds. I need to raise it to 0.8 seconds atleast. What is faster: DataReader or DataSet or something else Thank's Alexei DataReader is much faster than DataSet. Actually DataSet is populated using DataReader object. I guess in your case the bottleneck is in the amount of data you transfer to client application. Try to reduce the row size you send to the client (don't select columns unless they are required). Another way is to show only portions of data as the user typically doesn't need to have the whole data list available. ...Show All

• Visual Studio Tools for Office .net COM Add-in for Excel - cannot find Extensibility Projects

  Hi I have installed Visual Studio Tools for Microsoft Office after installing vb.net and Microsoft Office 2003 respectively. I cannot find the Extensibility Projects folderin the Other Projects folder. Please would someone help. Thanks Murray  Hi Misha Thanks for the last response. The thing is that I want to sell my Add-In to users of Excel 2000 and onward. I would also like to try and target Excel 97 users if possible. So how do I create and Add-In to manipulate my VBA code that can be used in Excel 2000 and Excel 2003 (and at a stretch in Excel 97). It seems that I massive part of my market lies ...Show All

• SQL Server SQL 2005 CTP up to RTM

  I am installing SQL 2005 Developer Edition Sept CTP on the server which will hold production databases once the RTM is released.  Come November, do I need to backup the databases, uninstall CTP, install RTM version then restore the databases   I was told to basically expect our production deployment before November.  The developers basically are using the new features of Reporting Analysis, SQL Server etc.  I have mixed feelings about how to handle these type of deployments. Also, can someone point me to the newsgroup pertaining SQL2005.  I need some expert opinion on how to handle these. Thanks, Lito I would ...Show All

• .NET Development New Rows do not appear in SQL database

  Hi all, I am busy with a project that requires I store information in a database. I'm using VS2005 Express and SQL Server 2005 Express. My problem is no matter what I try I can't get inserted data to appear in my SQL database. I believe I have setup everything correctly, I have a DataSet (smsdataDataSet) and TableAdapter (smstableTableAdapter) setup, the code I am trying is listed below: smstableTableAdapter.InsertQuery(MyGuid, SMSMessage.SMSOrigin, SMSMessage.SMSMessage, null, "SMSMessage",DateTime.Now); smstableTableAdapter.Fill( smsdataDataSet.smstable) ; smsdataDataSet.smstable.AcceptChanges(); smstableTableAd ...Show All

• Visual Studio Team System Load Test Plugin build error

  Hi, I've been trying to implement one of Bill Barnett's custom Load Test Plugin as per Ed's blog. I keep getting the following error when I'm trying to build (either example) No overload for 'loadTest_Heartbeat' matches delegate 'System.EventHandler' Have I missed something I'm fairly familiar with the WebTest plugin styles, but I'm no C# developer. Thanks in advance It appears that the example in Ed's blog does indeed have a compiler error - I'll let him know. (He must have created this with a pre-release version of the product.) Try changing this line: loadTest.Heartbeat += new Eve ...Show All

• Smart Device Development Wifi Printing

  I need to connect to a Mobile Printer that has integreated Wifi. It will be a point to point connection. This will be configured on the device itself. Basically i will be creating a Stream of data to send to the printer, but how can i specify the to print to that IP Address, thanks for any help I solved it by creating the connection to the printer and preforming the printing inside the same method. Here is the full code for anyone who wants it Private Sub Button2_Click( ByVal sender As System. Object , ByVal e As System.EventArgs) Handles Button2.Click         Dim l_tcpClient As TcpClient & ...Show All

• .NET Development Are there other Frameworks for .NET Framework?

  Hi, I am looking for a step up/quick start way of developing an application in .NET.  I've come across the Mere Mortals for .NET framework (http://www.oakleafsd.com) and was wondering if anyone has used this and can recommend it or if there are others out there that are more highly recommended. Thanks. Your best quick start is to use a book or online tutorial.  VB.NET should be pretty easy to learn with some help from tutorials, C# isn't that much more difficult.  You can get the VB.NET Express Beta for free ( http://lab.msdn.microsoft.com/express/vbasic/default.aspx ).  MS also has a few good beginners guides and ...Show All

• Visual Studio Express Editions Installing new programs created in VBEE - Win 98, 2000 Xp etc

  Hello I am an experienced vb 6.0 developer but new to VBEE Besides the normal components and runtime files what else do I need to install a program developed in XP using VBEE to run in win 98 platform or 2000 Thanks Joe hi, all what you need is .net framework to make your program run in any platform, if you use sqlserver you will need sqlserver running on this system too hope this helps ...Show All

• Visual Studio Team System Adding a Document via API

  I want to add documents to the Documents sections of a TS Project. Is there a way to do this via an API I used the TS API to add/edit WorkItems, but havent found anything to add documents, and no I dont want to "Attach a document" to a work item.. Thanks Alistair Hi Alistair, There is no API in TFS to upload documents to SharePoint. TFS uses System.Net.WebClient to accomplish the task. Take a look at WebClient.UploadFile and WebClient.UploadData. -Dennis ...Show All

• Windows Forms Screen Refresh Problem

  I'm developing windows forms using VB.NET 2003 and whenever I run my application I have screen glitches. For example, If i drag a screen I developed it creates a window streak on the screen. I tested this problem out on another computer and I still have the same problem. I'm sure someone has encountered this problem. Does somebody have a solution  ...Show All

• Windows Forms how to get url from the control ??

  My control is deployed in <object>mydll/object>, in an aspx page. like http://localhost/myproject/default.aspx How can I get the above url (where this object is installed) from inside the mydll object  Thanks, varadhg I have two ways to get this url from the Smart Client here: -----------------------------------------------------------------------------------------------------------   One way is&n ...Show All