ComputerWhiz's Q&A profile

• Visual Basic Progress Bar with unknown maximum value

  Hi, I have an application that writes data from PC to a 8052 microcontroller's Flash. It takes an accountable amount of time.I want to show a progress bar for the same but i cannt quantify the time(time it takes to complete writing all bytes to the falsh).I have an idea on progress bars with minimum and maximum limits known.I would like to know for unknown situation like my application Can anyone please give me kick start tips for the same. Regards, Swapna A progress bar by definition is showing progress and how would you expect to determine how much progress has been made without knowing what the end point is. You could use the marquee style which will show a progressbar control and have a bar moving back a forth showing something ...Show All

• Visual Studio Team System Can't do a data compare of 2 local DB's

  Hi I have run a data compare on two local DB's that both contain tables and data. One was created through a CTP7 project and the other was created in SQL Management studio. When we go through a data compare of these two no tables show up to compare. When one of the locals is compared to a DB on another server it works fine. We have tested the connections, they work, the two DB's have the same structure with different data. I am wondering if there are any issues when doing a data compare on two local DB's. We are running VS 2005 Suite, CTP7, SQL 2005 Developer Edition. Hi dakerson, I did a simple test by creating a sql2000 project. I imported pubs (remote) database into the project , and than I deploy ...Show All

• Software Development for Windows Vista Webservice Workflow with Dynamic SetState Activity

  I am writing a webservice workflow using Visual Studio 2005. I am trying to add in a Hold State in my workflow so that users can temporarily hold an approval process or something. I can use recursive composition to create an event so that the Hold State can be reached from any other state. The problem is --- how do I then return to the previous state before the Hold State I have tried to set the TargetStateName property within my workflow class (inherited from StateMachineWorkflowActivity) in a CodeActivity but I get a InvalidOperationException. It seems that I can't set the state within StateMachineWorkflowActivity while running. Thanks for any help. Hi Jimmy, I am a little unsure of where yo ...Show All

• SQL Server SQL Server Failover:

  I have to figure out a way to handle a failover in SQL Server 2005. I was reading a few articles about it. 1. Do I need to do anything in application layer to let a failover occur in SQL Server 2005 2. I have a web site that connects to a production server, the connection string is defined in web.config. If I implement Mirroring in SQL Server 2005, and when failover occurs, shouldn’t I change the connection string to point the application to the new server In mirroring in synchronous mode, you provide a connection string which names both servers. The primary will be attempted, and if that fails, the secondary will be contacted. Your app doesn't need to change to do a failover. ...Show All

• SQL Server Extremely Poor Performance - Identical DB's but very different performance

  Hello Everyone, I have a very complex performance issue with our production database. Here's the scenario. We have a production webserver server and a development web server. Both are running SQL Server 2000. I encounted various performance issues with the production server with a particular query. It would take approximately 22 seconds to return 100 rows, thats about 0.22 seconds per row. Note: I ran the query in single user mode. So I tested the query on the Development server by taking a backup (.dmp) of the database and moving it onto the dev server. I ran the same query and found that it ran in less than a second. I took a look at the query execution plan and I found that they we're the exact same in both cases. Then I too ...Show All

• Visual Studio Loader Lock Detected

  Hi i have a problem when i keep my program in run state after a few minutes it show the message Message: DLL 'C:\WINDOWS\assembly\GAC\CrystalDecisions.CrystalReports.Engine\9.1.3300.0__692fbea5521e1304\CrystalDecisions.CrystalReports.Engine.dll' is attempting managed execution inside OS Loader lock. Do not attempt to run managed code inside a DllMain or image initialization function since doing so can cause the application to hang. Currently, I run in VB.Net (VS2005) Thank you for your reply look at this post http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=149743&SiteID=1 and this post http://technicalsupport.businessobjects.com/cs/forums/ShowThread.aspx PostID=8607#8607 ...Show All

• SQL Server Update slow(5 Hrs, 14mil rows) on perm tables, however as part of SP using temp tables fast(45 mins 14mil rows)

  Greetings All ITEM1: Here is the statement :(Perm Tables) update jkk_AllLogic_Allocation1_Work set ExpAllocValue = a.ExpFinValue * (a.SalesFinValue / s.TotSalesValue) from jkk_AllLogic_Allocation1_Work a, jkk_SumOfSales2 s where a.ID = s.ID ITEM2 Here is the similar Statement(excerpt) from SP: /* Adjust Expense amount depending on sales ratio */ update #AllLogic_Allocation1 set ExpAllocValue = a.ExpFinValue * (a.SalesFinValue / s.TotSalesValue) from #AllLogic_Allocation1 a, #SumOfSales2 s where a.ID = s.ID The SP does a lot of things Update being the longest. QUESTION Why is ITEM1 taking 6 times longer to run than ITEM2. I am totally confus ...Show All

• SQL Server Strange SQL Server 2005 SP Issue

  We have a stored proc that accepts a date and uses that date in a filter. This procedure worked fine for a couple of weeks then started hanging. Basically, this date parameter is used in a where clause. Our workaround: when we declare a new variable, set it equal to the parameter, then use the declared variable - that fixes it. Take away the declared variable and use the parameter instead and the proc chokes. But the paremeter and the declare variable are both datetime typed. Weird. We are worried (partly because it worked without hanging for a while) that we are experiencing a larger issue. We are reporting off a database we denormalize and populate nightly with transactional data. A poor man's warehouse if you will, staging the da ...Show All

• Visual Studio Express Editions Inserting pictures into a RTB

  Thanks for the help but i want to be able to select a picture from a file to appear in the RTB, I would like to be able to insert picture from file like you can do in microsoft word, does eny 1 know how (im new to coding so im only learning) Dim MyImage As Image = Image . FromFile ( "ImagePath.bmp" ) My . Computer . Clipboard . SetImage ( MyImage ) Me . RichTextBox1 . Paste ( DataFormats . GetFormat ( DataFormats . Bitmap )) ...Show All

• SQL Server cannot convert between unicode and non-unicode

  I keep getting the error message below when attempting to import a text file (flat file) to an SQL Server Destination using SSIS. This database has recently been migrated from SQL Server 2000 (where I used a DTS Package that worked fine). I plan on doing further manipulation to the file after importing but have so far tried to keep one step at a time. I have tried using a smaller files and different tables but still get a similar response. I believe that the encoding of the text file is ANSI. If it is relevant the database collation is Latin1_General_CI_AS (the same as it was when 2000). Any help anyone can provide will be greatly appreciated!!! TITLE: Package Validation Error ------------------------------ Package Validation Error ...Show All

• Visual Studio Team System Navigating to code from the Test results

  When I run a unit test that fails, I get a stack trace in the Test Results Details window. Is there any way to navigate to the line of code that caused the error from this window It would be nice to be able to double click on a line and be taken to the code. Or maybe there's another way to do this Hello Geoff, Unfortunately, we could not implement this feature in VS2005 timeframe. However, we are definitely considering it for the next version of Visual Studio. Regards, Boris ...Show All

• SQL Server Sum on conditional Values

  Hi I have a table with Records for employees and evry record has a record type now i need to have a sum in the table footer or in a group for all employees of Amount Column when Record type is "E" and the conditions is if this employee by RecordType "D" the amount column is not 0 else then shuld be 0 is it posible with SSRS Thanks Jhknys Thanks all for the reply but what i am trying to do is get sum amount form records that have RecordType "E" but i want to check if thay have a amount in Record by Record Type D so i can just check the sum with this record is it posible Thanks Jhknys ...Show All

• Windows Forms How to make a control transparent

  Hi please tell me how to make a control like panel or label transparent so that it shows an image which is a background of the form that contains the controls thanks in advance You already have this code in VB. http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=2290716&SiteID=1 Please follow up with questions to your own post, in the thread that you started. If the answers that you are given are not helpful, then say so. ...Show All

• Visual Studio Express Editions Viewing Web Pages IN your Application

  I have 3 questions: 1) What is the Web Browser 2) How do I use the Web Browser 3) Can you give me any help Im not entirely sure but looking at the events of the WebBrowser control, there is a "ProgressChanged" event, which you can implement and use. According to the documentation, it states that when the event is fired, the CurrentProgress property will give you the number of bytes successfully downloaded and the MaximumProgress property will give you the total number of bytes available for downloading. Based on this, you can then create your own UI progress bar using these 2 properties I believe. http://msdn2.microsoft.com/en-us/library/system.windows.forms.w ...Show All

• .NET Development Update a access db's with VB express

  I have an access 2003 db's  but no of the methods of the help index can insert an element to the database. I've tried with data adapters. The dataset of the db's try to update but no can do. help   following the code Dim lect As IDataReader = Me .SistemasDataSet1.CreateDataReader sistemasDataSet.EstadisticasDataTable.Item(1).Rows.Add( "otros" ) 'sistemasdataset.tables("nombretabla o el indice de la tabla).row(i).colum("importe").tostring() + suma Me .EstadisticasTableAdapter.Insert( "joya" , "no ug" , "12 / 12 / 2006" , "tigre" ) other code on other button   Dim dt As New DataTable( "tblDemo" ) Dim coche As DataRow Dim i As Integer Dim j As Int ...Show All