NeederOfVBHelp's Q&A profile

• Internet Explorer Development IE7 Icon

  I installed IE7 and after 2 days of installment, the IE7 icon on the desktop became a generic icon as well as some of my other programs under the program tab. Why is this happening Those anyone know I have tried everything, spend hours trying to fix it. Anyone I actually was able to correct the problem. I went into settings / control panel / Display / Settings and Adjusted the color quality to 32 bits. So if anyone is having problems such as this, try the steps. Hope that this helps out anybody that is going thru the same problem I did. vkrakenv ...Show All

• SQL Server Proc with bad performance

  Hello, I'm trying to rewrite the following proc for better performance. Which approach would be the best way CREATE PROCEDURE dbo.upTest(@ProvID int, @GewID int) AS IF @ProvID IS NULL AND @GewID IS NULL SELECT ProvID, Prov, GewID FROM dbo.Alg_Geo_Prov ELSE IF NOT @ProvID IS NULL SELECT ProvID, Prov, GewID FROM dbo.Alg_Geo_Prov WHERE ProvID = @ProvID ELSE IF NOT @GewID IS NULL SELECT ProvID, Prov, GewID FROM dbo.Alg_Geo_Prov WHERE GewID = @GewID ELSE SELECT ProvID, Prov, GewID FROM dbo.Alg_Geo_Prov WHERE (ProvID = @ProvID) AND (GewID = @GewID) GO Many thanks! Worf I rearranged your query as there was a problem when either ...Show All

• Windows Forms Question on ClickOnce Deployment

  I want to create a ClickOnce appliaction to replace my windows control hosted in IE. We have hundreds of customers and they way it works now is that they download a package from our website and install the software on there web server. I would like to be able to have the ClickOnce application on our customers web servers, but from what I have been reading to create the ClickOnce (using VS 2005) you have to set the publish location, which I would not know. It seems that what I want to do, which is have a customer download the ClickOnce application and subsequent upgardes to their web server so that their users can install the application from that web server is not possible or at least I have not found any documentation on that. Ca ...Show All

• Visual Basic Cross-thread Exception with UserControl Initialized from BackGroundWorker

  I have a Windows Form with 3 variables declared as my own User Controls, a BackGroundWorker, 1 panel and 3 buttons Dim uc1 As DocumentTab Dim uc2 As HomeScreen Dim uc3 As StylePage These User controls are initialized from the BackGroundWorker.DoWork(). uc1 = New DocumentTab uc2 = New HomeScreen uc3 = New StylePage The Click Events of the buttons calls this method to add the specified user control to the panel. Keep in mind that this method is always executed from the UI Thread. Private Sub AddControlToTab( ByVal cCTL As Control, ByVal Panel As Control) Panel.SuspendLayout() Panel.Controls.Clear() With cCTL .BackColor = System.Drawing.Color.Transparent . ...Show All

• SQL Server Execute As error

  I have a stored procedure that needs to run with elevated privliges, so I tried setting it to run as one of the db owners. When a regular user tries to execute the SP, I get the error Cannot execute as the database principal because the principal "joejoe" does not exist, this type of principal cannot be impersonated, or you do not have permission. What do I need to set up so a user can be impersonated Did you try as SELF It should work like you want. mpswaim is a user, who is the db_owner group, right You really shouldn't need impersonation for this procedure to work anyhow, since all users have rights to sysprocesses. Here is the script I used to reproduce the situation. I created the users without login for e ...Show All

• Windows Forms Hide caption bar without empty form text?

  I'm creating a login screen for my application, and I want to hide the caption bar of a form, but I don't want to set empty string for the form text, because it will be strange to customer that a task in the taskbar without a name. Does anyone have ideas about it Thank you very much! If you have the forms border style set to "none" just type in "Login" or something similar for the forms text. Leaving it blank like you said obviously will make the user think " " but I don't see why you wouldn't type something in. ...Show All

• SQL Server MCDBA or MCTS

  For my last 3 years I have work with the SQL 2000 as a database analysis. Now I want to get a certification to prepare me to look for a better job. Which certification is more valuable in today job marker MCTS or MCDBA. That would be easy. MCTS - SQL Server, MCITP - Database Administrator, or MCITP - Database Developer. Why MCDBA is a SQL Server 2000 certification. MCTS - SQL Server is the Microsoft Certfied Technical Specialist - SQL Server which is for SQL Server 2005. After attaining your MCTS in SQL Server (70-431), you can take two exams to get the MCITP (Microsoft Certified IT Professional) Database Administrator (70-443 and 70-444) or you can take two exams (70-441 and 70-442) to get your MCITP - Database Developer. The ...Show All

• SQL Server Using FreeTextTable Conditionally

  Hello all! I have a stored procedure that accepts a parameter @SearchTerm that may be null. In my WHERE clause, I check for all records where @SearchTerm is null, or are LIKE '%' + @SearchTerm + '%' when not null: SELECT (some records) FROM (some tables) WHERE @SearchTerm IS NULL OR (some fields are LIKE '%' + @SearchTerm + '%'); I am trying to use FTS with a FreeTextTable to make our search ability more robust: SELECT (some records) FROM (some tables) JOIN FreeTextTable(tableName, columns, @SearchTerm) ft ON ft.[KEY] = tableName.[KEY] However, because @SearchTerm can be null, meaning the user is not filtering our records by a search, doing a JOIN to a FreeTextTable throws an error (cannot have null as search string). Ple ...Show All

• Visual Studio Express Editions Adding datatable to dataset

  Hey to one and all I made procedure in VS express to create tables in my access 2003 database. With the help of the dataset wizard, i made a dataset call "Customer_Dataset". The tables i created in my access 2003 database, i would like to add these to "customer_Dataset" without using the wizard. I tried doing the following programmatically.. Dim ordersTable As DataTable = Customer_Dataset.Tables.Add( "Orders" ) Dim pkOrderID As DataColumn = ordersTable.Columns.Add( _ "OrderID" , Type.GetType( "System.Int32" )) ordersTable.Columns.Add( "OrderQuantity" , Type.GetType( "System.Int32" )) ordersTable.Columns.Add( "CompanyName" , Type.Ge ...Show All

• Visual Basic COM Object BeginInvokes at Program Close?

  We're writing a program where we have a COM object that is created and used several times through the runtime of the program. I'm finding, though, that I get this bizzare error after closing the program. I've verified that this error comes after an Application.Exit() call, and the stack trace doesn't involve any of our code, so I have no idea how to diagnose this (if I could just supress it, I'd be fine, since the program can finish closing after I hit F5 when the exception comes up in the debugger). The only handlers attached to the COM object are done through Handles statements on methods. Is it better practice to manually do it on COM objects through AddHandler and RemoveHandler ...Show All

• Software Development for Windows Vista Getting an overview of a Dynamic format change and it's application to a filter derived from CTransformFilter

  Hi I'm trying to do a transform filter derived from CTransformFilter. It does everything should be doing except handling dynamic format changes like when used in a DVD graph with a codec that defaults to 720x480 and then switches to 720x576. As a renderer i use VMR9 in YUV mixing mode and my transform filter doesn't not have any preference towards the YUV format for now. So the goal of the filter would be to have anything relating to the format handling working exactly as if no transform filter was in between and thus letting the codec and VMR9 workout the connection and simply having the transform jacked in between. For performance reasons i choose not to go with CTransInPlace filter. So what I need are some pointers on how ...Show All

• Visual Studio Submitting doc errors?

  As I struggle through the VS2005 documentation, I find numerous errors. Is there an easy (= 1-click) way to report these I want to see them fixed, but don't have time to go through a long procedure to submit them. Yes and very soon with MSDN Wiki. Please see beta announcement at - http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=658907&SiteID=1 Anand.. ...Show All

• Software Development for Windows Vista The UAC Nightmare

  I'm beginning to reach the conclusion that the current implementation of the UAC in Vista is, IMO, a nightmare that creates more problems than it solves. If Microsoft wants developers - and users - to embrace the UAC (instead of just turning it off altogether) then it better come forward with a LOT MORE information and support than it is currently providing! If it doesn't, I will begin to suspect Microsoft only added the UAC so it can tell Windows users 'well, we added the option to secure Windows - you're the ones turning it off' and therefore wash its corporate hands. I would really hate to see this happening. To name just a few of the problems the UAC brings to us developers: 1 - Applications that require Admin privileges are bloc ...Show All

• .NET Development OLEDB Excel provider - select data from the first sheet

  Hello, I'm using connection string to connect to excel sheet. something like: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1""" after it I use sql select statement. the FROM clause contains the sheet name in the workbook. can I avoid using this name, and just select data from the first sheet Thanks. What would be the main reason for this I do not think provider allows using indexes for the spreadsheet names and you would definitely need to pass the name in your SQL, but if you use GetOleDbSchema you could get list of the spreadsheets inside of the workbook. The only thing is that I do not believe that GetOleDbSchema guarant ...Show All

• .NET Development Sending acknowledgement Message back to the Client using MSMQ

  Hi all, I am receiving message from the client(mobile) through MSMQ. Once the Message is received am trying to send an Acknowledgement for an Message received. Its working well but during some scenario when the message is send during non availability of the GPRS Connection I am getting an error as “System.NullReferenceException: Object reference not set to an instance of an object ” . The error occurs when the ResponseQueue.send is executed. Have anyone comes across this error while working with MSMQ. Give me your suggestions to overcome this. Thanks in Advance Regards Biju S Melayil ...Show All