Gabi's Q&A profile

• SQL Server UDF 10x slower than select query it contains

  I have a table valued UDF with only one SELECT query. It selects from a View, and has a couple of joins and calls another UDF in the WHERE clause. When I run the Select query itself it's duration is around 120, but when I have it wrapped in a UDF, it's around 1200! ALTER FUNCTION [dbo].[fnGetiii] ( bla bla bla ) RETURNS @ItemTable TABLE ( a varchar(2), b bigint, c smallmoney, d varchar(50), e varchar(50), f int, g varchar(50), h datetime, i int, j int, k int ) AS BEGIN INSERT INTO @ItemTable (a,b,c,d,e,f,g,h,i,j,k) SELECT vat.a AS a, vat.b AS b, vat.c AS c, vat.d AS d, vat.e AS e, vat.f AS f, vat.g AS g, vat.h AS h, vat.i AS i, v ...Show All

• Visual Basic How to write a sub for several checkboxes at once

  Hello, I am brand new to visual basic, so please excuse me if this is an easy question. I have a form with several checkboxes. I want to make it so that if any checkbox is checked, its label goes from gray to black. I have figured out how to do it for one checkbox, but I can't figure out how to handle many at the same time. Here is what I have so far: Private Sub sidingStyle1Include_cb_CheckedChanged( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles sidingStyle1Include_cb.CheckedChanged If (Style1Include_cb.Checked = True ) Then Style1Include_cb.ForeColor = Color.Black ' If CheckBox is u ...Show All

• Visual C# How to get the display information from a website?

  How to get the display information from a website For example, when i click a button, the system will get the fixed deposit rate from a certain bank website. How can i get the value that display on the website Can anyone help to solve my problem Hi You wanna to access the information that resides on a diffrent web server. Try to search a web service if the Bank have, and acces the information to display on your page. Or Try to get the page through System.Net.WebClient ... and parse the page to extract your information and then display that. Or If you are stronger in Java Scripting or any web scr ...Show All

• Windows Forms WebBrowser control hangs on Window.Close()

  At first, I enjoyed the new webbrowser control but then I noticed that the args provided by the events NewWindow3 and BeforeNavigate of the axWebBrowser had not been implemented in the new control. Arg. Good news, the guys from Microsoft gave us the a workaround recently in C# and said they will publish a sample soon on MSDN. In the mean time, here is some VB.net code inspired from Microsoft's C# that will give you 2 new events and the args people like me were crying for. NavigatingExtended gives you the following args: - Url as string - Frame as string - Headers as string - Postdata as string - PostdataByte () as byte - Ca ...Show All

• Visual Basic skins

  Do you guys know some sites where I can get custom skins for vb.net and how to use them Do you mean skins for VB itself, or for your apps Either way, I don't think they exist. To do skinning, you need to write the code yourself. WPF will allow some skinning through XAML, which will be easier, but you'll still need to do it yourself. ...Show All

• .NET Development TableAdapters and partial classes

  Jay, that's an excellent idea... I tried that, and it's not working. I have a project named "NorthwindDataSetTableAdapters". I created a TableAdapter named "CustomersTableAdapter" The generated code has the following: <code> <System.Diagnostics.DebuggerNonUserCodeAttribute()> _ Private ReadOnly Property Adapter () As System.Data.SqlClient.SqlDataAdapter Get If (Me._adapter Is Nothing) Then Me.InitAdapter End If Return Me._adapter End Get End Property </code> I created a partial class hanging off the CustomersTableAdapt ...Show All

• Windows Forms Install from CD

  Is it posible to install an application from a CD (with a project setup) and then make it to update itself with clickonce I saw a property "Instalation URL" I've put there a UNC to a msi, I've installed my app from there then I publish the next revision on a site It's not working. How can I do that Sorin,   You could try the following if you would like to install something to the GAC and update via ClickOnce. Create an msi that installs the needed assemblies to the GAC.   Create a bootstrapper package that will run the msi before installing your ClickOnce application. See http://www.gotdotnet.com/Workspaces/Worksp ...Show All

• Windows Forms Command Line Agrument in Click Once Deployment

  Hai to all, I am currently doing Click Once deployment for my Application which has a command line argument. I will select the check box labeled Allow URL parameters to be passed to application . I will get the URL String by having " AppDomain.CurrentDomain.SetupInformation.ActivationArguments.ActivationData(0) " It works Fine, when i launch the Application using Browser( online ). But the Problrm is when i access the same appliaction in offline (by click the icon in the start menu i didnt get the Command line Agrument. Please Help me to over come this problem. My using Project-> Properties->Publish to publish my Application ...Show All

• Visual C++ Returning a string from unmanaged to managed code

  Lets say you have a unmanaged function with the following prototype: bool f1(char *szOutString); This function returns a string of a defined max length. Now I want to build a managed function (c++/cli) which calls it. I remember from from Managed Extentions that I could use StringBuilder class for this purpose. However this does not work: StringBuilder ^str; f1(str); How is this achived Thanks in advance. I did it the same way. Other folks on the forum might be able to suggest other ways if possible. Thanks,   Ayman Shoukry   VC++ Team ...Show All

• Smart Device Development How to detect when Scrollbar from my DataGrid changes ?

  Hi, Im doing some kind of Datalogger, and in a certain part of the app I need to detect when somebody changes the position of the scrollbar of a Datagrid Many thx in advance, Hi cgMarcos, Try this code (you can also find this snippet in the public newsgroups): foreach ( Control c in dataGrid1.Controls )                         {                                 Ty ...Show All

• Visual C# Dispose Method Error

  Hi guys I need help. on the following code: protected override void Dispose( bool disposing) { if (disposing && (components != null )) { components.Dispose(); } base .Dispose(disposing); } I am receiving an error like this: Error 1 'Web.Form1.Dispose(bool)': no suitable method found to override Can anyone please help I don't believe that a web form impliments IDisposable, you'd need to add that to the class, and then I doubt the framework would call it. ...Show All

• SQL Server Cannot complete Install of Express

  Product: Microsoft SQL Server Native Client -- Error 1706. An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'. Logged as MsiInstaller in App Log. The install fails with this and two other items in the bos that shows successful install items SQL Server Database Services Workstation Components, Books Online, Development Tools Installed 2 necessary programs; Windows Installer 3.1 and .NET framework 2.0 redistr. Any Ideas The advice given above worked great for me. I tried to install SQL server 2005 express bu ...Show All

• SQL Server Data Comparison Question

  I am not sure if this is the correct forum for my question but I will give it a shot. I want to be able to create a dataset from an ODBC datasource and compare it to existing data in my SQL DB. If there are changes (inserts/updates/deletes) I want to raise seperate events for each row state. Is this possible to do with SSIS/DTS or am I on the wrong track with what I am trying to do Have a look at this and see if its any help: http://www.sqlis.com/default.aspx 311 -Jamie ...Show All

• Visual Studio Team System The application for project is not installed (project types .rptproj and .dwproj)

  It used to work, but then... Visual Studio 2005 was hummin' and I had a number of BI projects in both Report Services and Analysis Services. I wanted to add source control and decided to install the Team Suite and I did something wrong. I just don't know what it was. In the end, I deinstalled every Visual Studio 2005 (including, of course,the Team stuff)and SQL Server 2005 application, and reinstalled old faithful Visual Studio 2005, but nothing has worked. I'm missing the Business Intelligence project templates completely and I'm guessing that if I had them, I wouldn't get either of the following 2 messages when I try to open existing ...Show All

• Visual Studio Keeping separate models in step

  Following on from the discussion of using rules and events in an earlier posting to keep external artifacts in step with a model ( http://forums.microsoft.com/msdn/ShowPost.aspx PostID=69577 ), I have a related question about keeping separate models in step. Suppose you have two model files, one representing the business layer of an app and the other representing the UI layer. The UI layer is dependent on the business layer.  Presumably you could use events to keep the UI model in step with the business model. However, there are various drawbacks with this, such as having to code undo/redo behaviour yourself. Is it possible to load bo ...Show All