Answer Questions

• John123 System.Data.SqlClient.ConnectionPool.CreateConnection

  Hi, I had make one Desktop application in VB.net, having 6 threads simultaneously running. And each thread connect to sql server and stored the value in DB at every one second. Now my problem is that when I start the application its working fine but after 20 to 30 minutes exception is occuring. Login failed for user 'sa'. Exception StackTrace: at System.Data.SqlClient.ConnectionPool.CreateConnection() at System.Data.SqlClient.ConnectionPool.PoolCreateRequest(Object state) can anybody help me - Hiren Do you actually need 6 threads running. If you are trying to store values in a database every second then I would think you could do this with a less complex solution than spinning out multiple threads. Also you want to ...Show All

• NoEgo PowerPoint DataSheet

  All I really need is to be pointed in the right direction if someone can find the time. I am researching a solution that can use data from a database to create a PowerPoint file with a graph and a datasheet. A user will go through a web application to select data criteria. When they make all of their selections, they would click to generate a multi-slide presentation. Each slide woudl contain a graph. I have run into a an example here and here but can't get any of them to work. Has anyone ever done something like this ...Show All

• Wil Burton Set Dropdown List Items to Hyperlinks

  I am using VB in Visual Studio 2005 and have a master page with a dropdown list and I would like to have particular pages loaded depending on what item in the dropdown list the user selects. It is not clear to me how I can make the items in a dropdown list hyperlinks. Thanks. As an asp.net question you may want to direct this question at the forums.asp.net They cover specific Web / ASP.NET issues. Thanks ... I'll do that. When I click on an item in the dropdown list I want to load a new web form (I call that a "page") into the ContentPlaceHolder on the master page. Hope this clears up the confusi ...Show All

• Andreas Jaeger Where is the Chart class?

  I'm trying to add a chart object to a Windows app form under Visual Studio 2005 Standard. I did this once a long time ago (VB6). I can't locate the correct reference that pulls in this class. It looks like I need the microsoft.office.tools.excel namespace, but none of the microsoft.office references seem to contain it. I'm begining to suspect that its not in the standard package. Anybody know where it is (or even if its in this package) There is not a .net Chart control included with vs 2005. You can use the sql server reporting services or the open source Zed Graph . Not to mention there are third party controls like Dundas Chart, and Graphics Server. Ken, Thanks for the tip on ZedGraph. It lo ...Show All

• Ashish Vyas How do I change/specify Webbrowser Control font?

  I am using the webbrowser control to display HTML formatted string in a VB.NET 2005 application. The default webbrowser text seems to be Times New Roman 12pt. Is there a property or other method to change the default font and size Thanks... No, no one replied. I'm still looking for an answer if anyone knows how to do this... The control defaults to Times New Roman 12pt. Thanks... Did you ever find out how to do this If so - how Thanks, ...Show All

• K Webber Code to Convert numbers to time

  I hope I am in the correct forum it is my first posting I have a database which has three fields for Hours Minutes and seconds these are just numbers and have no relation to time. I need in a report,code that will convert the numbers to time and add the seconds to minutes and add the minutes to hours. Thanks Bartley Bartley, I presume you can get the hours minutes & seconds values out of access So you should be able to build a string using the CDate method. I have no idea how to put it into a report, never used them How is the code entered into the report Thanks Bartley CDate(Hours + ":" + Minutes + ":" + Seconds) ...Show All

• Beth31 Sami language characters

  Is it possible to use the characters below that are not in the Ascii table when programming in VB 2005 A C3 81 E7 E7 00C1 LATIN CAPITAL LETTER A WITH ACUTE a C3 A1 E1 87 00E1 LATIN SMALL LETTER A WITH ACUTE C4 8C A1 A2 010C LATIN CAPITAL LETTER C WITH CARON C4 8D A2 B8 010D LATIN SMALL LETTER C WITH CARON C4 90 A3 B0 0110 LATIN CAPITAL LETTER D WITH STROKE C4 91 A4 B9 0111 LATIN SMALL LETTER D WITH STROKE C5 8A AF B1 014A LATIN CAPITAL LETTER ENG (Sami) C5 8B B1 BA 014B LATIN SMALL LETTER ENG (Sami) C5 A0 B2 B ...Show All

• a.d.m How to use an array or an arraylist insinde a structure?

  How can I use an array or an arraylist insinde a structure I'm having a NullReferenceException, because I didn't declare the array as New. But I don't know how to do it, because I allready declared the object that contains the array as New. Thanks, Lucas Another option is to use a property to expose the array object rather than accessing it directly. Private Structure ListTest Private TestList As ArrayList Private Const DefaultCapacity = 9 Public Property List() As ArrayList Get If TestList Is Nothing Then TestList = New ArrayList(DefaultCapacity) End If List = TestList End Get Set(ByVal value As ArrayList) TestList = v ...Show All

• Dreedle Creating Stored Procedures Via Server Explorer

  According to the book I have... it says: 1.  Expand the tree under Data Connections to show a SQL Server data connection that points to the Northwind database, then the Views node of SQL Server. 2. Right-click the Stored Procedures node and select New Stored Procedure.  There is no "new stored procedure" option when you right click..  There is only Refresh & Proporties...  One thing I did do prior to doing this is... I had VS2K3.NET Standard on this machine.  I installed VS2K3.NET Professional over it.  Can anyone tell me why I'm not seeing create stored procedure when I right click on the stored procedure node Thanks Shug in VS2K5.NET  I see the "Create Stored Proc" but can't ...Show All

• Kees_de_Waard Fade in code doesn't worked on mdi child form

  This form fade in code worked for non-mdi child form but doesn't worked on mdi child form. How will i make it work Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim i As Double For i = 0 To 1 Step 0.01 Me .Opacity = i Next Me .Opacity = 1 end sub Assuming Stephen's code is for form2 (the child). You have to wait until the fade-in is done to set the parent/child relationship. (May not look perfect.) Private Sub Timer1_Tick( ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles Timer1.Tick Me .Opacity += 0.05 If Me .Opacity >= 1 Then Me .MdiParent = Form1 Timer1.Enabled = Fal ...Show All

• Jason D. Camp Web Browser project

  I am working on a very simple browser, mainly for quick web surfing without the need of menus, favorites, and other fancy features seen in other browsers. The problem is, im quite new to this programming language, and i barely got anything out of what little time i had in Introduction to Computer Programming (using Visual Basic 6.0) before being pulled out of that class to make up a required credit. Im clueless as to how to get the WebBrowser object to respond to the input in the AddressBar, and display the site the user types. Any help on this would be really greatful. Thanks Hi Vashnik, I recently dealed with this project aswell and I believe I might be of some assistance. One suggestion might be to make the 'Go' button activate ...Show All

• Bernd Wechner updating totals

  I have a form which shows total sales from an Access database, via a SQL string, when it is loaded. My form also allows me to add additional sales, however, I am unable to update the total sales field without closing and reopening the form - could anyone help me please Happy Christmas. I am using VB2005. Thanks, I will get onto it and let you know. Yes, I assume wrongly that if i save the new input data (using the binding naviator i.e. add new). The total sales should automatically update to relect the added value of the new input. Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click ...Show All

• robinjam Progress Bars

  I am wanting to display a progress bar while my program is loading data from and access Db using the DataAdapter.Fill method. Does anyone know if this is possible thanks tattoo You can do this by creating a new backgound thread, and having the code to drive the animation run there. You can find information about threading in VB here: http://msdn.microsoft.com/msdnmag/issues/01/07/vbnet/ . -Scott the backgroundworker was introduced in .NET 2.0/VS2005. I guess you would have to just use a normal thread setting the IsBackground property to true as well. Are you sure that you even with the background worker process you are going to be able to ...Show All

• Smylie Internet

  Hi everyone, I have a HTML page with a script. The page have 2 textboxes, names exp1 and ans1. I want, through VB, to write some text in exp1, then to simulate the type of Enter in it, and finaly, to read the data in ans1 into a variable. Does anyone know how can I do it Thanks, Ofir. expr1.text="Google It" ans1.text = "Found IT" MyVariable = ans1.text I didn't find anything in Google!! And I want to use the script in the file from my application if you didn't understand!! The problem in rewriting it, is, that I don't know how this script works! I think it is safe to ...Show All

• Gloria123 FileSystemWatcher - Created events fires too early

  I have been playing with a FileSystemWatcher, to start processing files as soon as one arrives in a folder. Specifically, I'm looking for a zip file, then unzip it. However, when I try to unzip a file as soon as I get the Created event, the file has often not finished being written, and therefore I get an error when I try to unzip it. This time period is very short, a tight loop without pauses trying to open it for write will return OK in 3 loops. Question ======= How do I get FileSystemWatcher to raise an event when a file has FINISHED being written, instead of START being written The FileSystemWatcher component also has a "changed" event, in addition to its "created" e ...Show All