Avi29's Q&A profile

• Visual Basic Problem in VB Designer

  Hello all. Hope you can help me with this, i've been searching the forums for the past hour with something the same, however haven't found anything. I know lots of you have had problems with the form designer giving errors and refusing to show the actual form, mostly because of some transition in software i take it (i aren't a Full time programmer, its just a hobby.) My problem is similar, vb refuses to show me my form and now i have even more problems. the last thing i did before this happened was try to add an imagebox to the form. Heres a few errors i get: every label i have is no longer declared event 'load' cannot be found - My other problem is, i managed to close the designer window during this problem and i cant remember how to get ...Show All

• SQL Server online index rebuild Problem

  Hi Please advice whether i have to do update stats after i do online index rebuild I use Alter index with (options as below) ONLINE =  ON SORT_IN_TEMPDB =  ON STATISTICS_NORECOMPUTE =OFF Should i be doing update stats after this online index rebuild After doing online index rebuild when  clients connecting to DB the Response time has increased .. During Online INDEX REBUILD page file usage rises from 3 Gb to 10 GB and stays at 10 Gb even after online index rebuild i have no idea on this  .. pls Advice ...I Need help.......................... Thanks in advance Pagefile is increased, then check the memory settings on SQL Server. Also if there ...Show All

• Visual Basic Desktop Background

  I need a program that changes the desktop background(stretched), by using the pictures in a certain folder(let's say it is C:\), and the pictures will be links(*.lnk). Anyone can help You might find this article useful http://www.devcity.net/Articles/119/1/vb2005_wallpaper.aspx Shout if you cannot get it working. Richard ...Show All

• SQL Server File System Task - Move File with Dynamic Destination Path

  I am having an issue with the File System Task. I was wondering if there is a way to 'Move File' with the File System Task inside of a For Each Loop container but to dynamically set the Destination path variable. Currently, this is what I have: FileDestinationPath variable - set to C:\TestFiles FileSourcePath variable - set to C:\TestFiles FileNameAndLocation variable - set to blank For Each Loop Container – Iterates through a folder C:\TestFiles that has .txt files in it with dates in the file name. Ex: Test_09142006.txt. Sets the file path (fully qualified) to the Variable Mapping FileNameAndLocation. Script Task (within For Each Loop, first step) – Sets the FileDestinationPath to the correct dated fol ...Show All

• .NET Development convert string to type

  Hello, lets say I have a class named Myclass in my program and I want to create an instance of this class during runtime but I know only name of the class. So I need first to convert string "Myclass" to type Myclass and then create an instance of class My class. How can I do that I know that I can use Gettype method to convert string to type but how do I then create instance of that type and call its methods and/or access methods Thanks You can either - Cast it to an instance of your object (if you know the type at design time) - Use reflection to get the methods/properties from the object and invoke them - Use the power of Visual Basic and use late binding (Option Strict Off) Best regards ...Show All

• Visual Studio Client side report designer

  I thought I heard something about a client side application that allows to you create/edit reports, outside of VS Alternatively, is there something out there I can integrate w/ my WinForms applications that would allow my users to create and edit their reports Hi TimRaml, Report Builder is the application you've probably heard about. We ship this with SQL Server Reporting Services. You can learn about this more at http://msdn2.microsoft.com/en-us/library/ms155933.aspx Also, we don't have tools to let end users create/edit reports in WinForms applications. One day we'll consider this. Thanks -Shamez ...Show All

• SQL Server Notification task fails to notify operator

  Hi, I have setup 2 instances of SQL 2k5, sp1 with hotfix build 2153 on one server. On the default instance I have setup a backup to back up system databases. Within the job flow I have included the "notify operator task" which notifies me when it reaches that task and completes the job successfully. However, on the named instance, the job that I have setup to backup the system databases, fails to email and notify the operator when it tries to execute that step "notify operator task"! Interestingly enough, i had setup notification to email me if this job fails, and So I do get an email that this job failed. It reports failure because ti could not execute the simple notify operator thru email task. I a ...Show All

• Visual Studio 2008 (Pre-release) Possible to install WPF on dotnetframework july cpt?

  Hi! Is it possible to install WPF (later version) on XP SP2 that has .net framework july cpt I cannot upgrade .net framework since I am using other products that require this version. Is it otherwise possible to download older versions of WPF/Visual studio exensions for wpf I can't find anything on the download pages. Thanks for your help! the following link may help you to get the older versions http://msdn2.microsoft.com/en-us/windowsvista/aa904955.aspx ...Show All

• SQL Server DTS to VB

  Can someone help me please. I am having issues with the following code. This is the first time I am doing this, so it is Brand new to me. Sorry if I look and sound like an idiot. I am having issues with 'DTS.OleDBProperties' cannot be indexed because it has no default property at the following line :oConnection.ConnectionProperties I used DTS wizard to create my vb code and I am following this page: http://msdn2.microsoft.com/en-us/library/aa176248(SQL.80).aspx Can someone please guide me in the right direction. Option Explicit Public goPackageOld As New DTS.Package Public goPackage As DTS.Package2 Private Sub Main() set goPackage = goPackageOld goPackage.Name = "Test" goPackage.Description = "Casier" ...Show All

• Windows Live Developer Forums Single Sign On into AdCenter

  Hi, I was wondering if AdCenter has plans to support Single Sign on If so what would be the time frame Thx Gautam ...Show All

• SQL Server Report gets refreshed automatically

  Hi, I created a report using SQL 2000 Reporting Services. I have 3 input fields viz., Start Date, End Date and Configuration Item. First 2 are textboxes and the last one is a dropdown. I also have a button 'View Report' clicking which the report page will be refreshed. When I deploy the Reports in report manager, when I give the Start Date then the End date, before I could select a value from the Dropdown, the report page is getting refreshed automatically before I click View Report button. i.e., the report gets refreshed on lifting the focus from the End date textbox. Why does this happen Note that I have not set the Auto refresh property for this report. The most likely reason the report is being refreshed is because the " ...Show All

• Visual Studio Express Editions NotifyIcon shows up double

  Hello, As shown here: http://jorijn.qweet.nl/screenshots/SnapShot-9112006-234734.png The notifyicon shows up double when i call my own class. Below is the code: http://paste.qweet.nl/4 Hope that someone can help me on this. Regards. Jorijn This issue is documented in Product Feedback , claiming this was a bug in .NET 1.0 and can't be fixed because it would break compatibility. Hmm, astonishing hard to believe. Anyhoo, the workaround they suggest is simple enough, set the NotifyIcon's Visible property to false in the Dispose() method. Since that code is located in the designer file, I'd try the FormClosing event instead. Let us know if that works, there have been a lot of questions about this problem. ...Show All

• Visual Studio 2008 (Pre-release) .NET 3.0 overwrite LINQ?

  Hi All, Sorry if this is a stupid question but I am a bit confused over what is what with all the CTP's etc flying around. A while back I installed the May CTP of LINQ etc and I have written a prototype model layer for my app. I next wanted to create a prototype UI using WPF/XAML but the support in my VS install appears to be broken so I thought I would install the .NET 3.0 framework that has just been released and then install the latest orcas CTP. This is where I ran into problems - when I goto install the .net framework it informs me that I must unistall previous CTP copies. This is fine but I am a bit concerned that if I uninstall the prev CTP I will no longer have DLINQ support. Am I correct in this assumption Wha ...Show All

• Visual Basic BackGroundWorker and the RunWorkerCompletedEventArgs

  I'm using the BackGroundWorker to do some file copying, and everything seems to work except none of the arguments in RunWorkerCompletedEventArgs are getting set. If I cancel the operation, the worker.CancelationPending property is set to true, so I can detect the cancelation while I'm in the midst of copying files and I can back out of the operation, but when I get the RunWorkerCompleted event, the arguments do not indicate that the operation was canceled. I could define a global boolean for when the Cancel button is pushed, but I wonder if I could be missing any error messages in the EventArgs. Am I missing something about how the BackGroundWorker functions, or is there some property for the BackGroundWorker that needs to set I've ...Show All

• SQL Server import from Access to SQL, not knowing the table format

  I need to import few tables from MS Access to MS SQL but the table structure in Access is always different, as I would like the destination table in SQL to be. Therefore I would like that a table would be created in SQL at runtime, according to the structure the Access table accessed has. i'm not sure about this, but i think you can use the script task to determine the access table schema.  then, you could use this schema information to dynamically create the sql server table. ...Show All