Leon247's Q&A profile

• SQL Server Another Stored Procedure Question...

  Hi, Is it possible whithin a Stored Procedure send the table name as a parameter And some Columns to Ex.: CREATE Procedure Xpto @TableName as @ColumnName as @SomeValue as nvarchar(10) AS SELECT * FROM @TableName WHERE @ColumnName = @SomeValue Thanks JPP Hello... I would not use a table to hold values like this... Those information is already in the DB and there is no need to denormalize it. If there are propper indexes on those fields you want to evaluate you can wrtite a small view that extracts the data you need... By the way... Why is there no SQL Code button on the form ;) create view DocCount ...Show All

• SQL Server connection string

  In a VB6 app, I am using the following connection string to connect with a SQL Server 2005 database: strDbConn = "Provider=SQLOLEDB;Integrated Security=SSPI;" & _ "Persist Security Info=False;Database=" & strDbName & ";" & _ "AttachDBFileName=" & DbPath & ";" 'Data Source=.\mssqlserver;" I am getting the following error message: Error No. -2147467259 [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied All help appreciated. SQLNCLI is the Bative Client for SQLServer which ships with the Native Client from SQL Server. You can still use the S ...Show All

• Visual C# Arraylist Clear

  I have an object that is recursive.  Meaning that it contains an ArrayList that holds child instances of the same object (like a tree node.....). When I call the Clear method, will all the other children be released or should I call Clear on each of the children's array list Thanks, Bob > So after the top level clear, nothing references the children > and grandchildren (although they reference other non-node objects). > On the next GC, they will be released.  Is this right Yes.  Something is garbage collected if nothing references *it*.  It can reference as much as it likes ...Show All

• Visual Studio Express Editions Can you use assembly in VC++ Express?

  Just curious! I'm not a dinosaur or anything (only 23) but I did get started in programming way back in the dos/os2 days using C/C++, ASM, basic, and pascal. So, can you use any inline asm in Express Yes the compiler will compile inline asm as part of your C++ code. Take a look at http://msdn2.microsoft.com/en-us/library/45yd4tzz.aspx for more details. Thanks, Ayman Shoukry VC++ Team ...Show All

• Visual Studio Tools for Office What happens if I call CommandBar.Enabled when the menu is displayed?

  Hi; This is a continuation in my quest to enable/disable the menu when it is displayed. The message I can intercept comes after Word draws the menu. What happens if the menu is enabled/disabled after the menu drops down thanks - dave ...Show All

• Visual Basic How do I calculate the appropriate font size to fit a string within a given area?

  I'm working on an application that displays multiple buttons that resize themselves when their container size changes. I've added a handler (AddHandler MyButton.Paint, AddressOf PaintMyButton) In the PaintMyButton routine, I'd like to paint a text string on the button that fills the button face regardless of the size of the button. I'm using the e.Graphics.DrawString(). The problem is calculating the appropriate font size as the button size changes. Is there a function or (efficient) algorithm that will will return a font size appropriate for the rectangle. I'm envisioning something like ... Function CalcFontSize(FontName, Displa ...Show All

• .NET Development Certificate for WSE 3.o

  Hi, I am implementing WSE 3.0 on my project using mutual certificate security.  I created the server certificate & client certificate for the project using the makecert.exe.  My question is haw can I share those certificate with other developer on the team for then to use   Can I export them with the private key   Please advice! Thanks ...Show All

• Windows Forms BindingSource and ComboBox and not selecting anything

  I experimented using BindingSources and Comboboxes. One thing struck me: there does not seem to be a way to select 'nothing'. On databinding, the first item in the list is automatically selected. This can't even be undone, because the BindingSource.Position property cannot be set to -1, as you could do with the SelectedIndex property of a combobox. This results in the following very unpleasant behaviour: Suppose the user uses my combobox to select some values, f.e. 10, 20 and 30 and I don't want to allow the selection of any other values. Then, on binding, the value 10 will be selected. If a different value would be needed as the fi ...Show All

• .NET Development I got an error when I copied global.asax file from one project to another project

  Hi, I created a new .net project name consumerservice to where I copied the aspx files from another project named ceaconsumerservice Inadvertently, I also copied the global.asax file. When I tried to run an aspx file, i got a error below . Aspnet is trying to load the global.asax file (CeaconsumerService.Global) from the other project. How do I fix this Server Error in '/ConsumerService' Application. -------------------------------------------------------------------------------- Parser Error Description: An error occurred during the parsing of a resource required to service this request. Please review the following ...Show All

• SQL Server When the report is exported to excel, can we export the filters as well?

  Dear Anyone, We have reports in RS that displays the values used in the multi-select parameters in the page footer. When we export this report to excel, the list of selected parameter values did not get exported. Is this a limitation of RS export to excel or is there a way to export them Thanks, Joseph ...Show All

• Visual Studio Team System Build Succeeded, but no output.

  Hi, I'm just trying to build my simple web application with Team Build. I was managed to create new build type. But when I'm running the build project, I'm getting only 3 files (BuildLog.txt, ErrorsWarningsLog.txt, Mixed PlatformsDebug.txt) in my drop location. My build log says, 1 Warning, 0 error. What can be the problem Here is my build log: Build started 6/15/2006 10:33:38 AM. __________________________________________________ Project "d:\buildsample\Team Proj1\MyTestBld\BuildType\TFSBuild.proj" (EndToEndIteration target(s)): Target InitializeEndToEndIteration: UpdateBuildNumberDropLocation BuildNumb ...Show All

• Windows Forms Tabs Voluntarily Rearrange Themselves...

  I've heard of lots people with this problem, but I've never seen an official (or unofficial, for that matter) reason, work-around, or bug confirmation for it. My tabs in my application randomly rearrange themselves randomly in debug mode somewhere between F5'ing, saving, and closing/opening Visual Studio.  I can go into the collection in the tab properties and arrange them back the way they belong, but then 15 minutes, an hour, a day later, they've rearranged themselves again in some different order. I've noticed the first tab and the last tab never move...just the ones in between.  Sometimes it's only one tab that moves three, ...Show All

• .NET Development How to retrieve info (messages) from the SQL Execution

  Hello. First, I hope I'm posting in the right forum. I'm developing av .NET application using ADO.NET. Everytime you execute SQL Queries the database returns information like "(1 row(s) affected)" etc, but I haven't found a way to get this info from the ADO.NET tools - eg. the SqlDataReader or OdbcDataReader. I need this information to get data returned by STATISTICS IO and STATISTICS TIME (ref http://www.vbcity.com/forums/topic.asp tid=29686 ) so I can make a small benchmarking app. I know about execution plans etc but these isn't realtime. Any idea how to return the text (Messages) returned from the database Thanks for an ...Show All

• Visual Studio Express Editions user set connection string

  I am creating a program that will read MS Access Database information. I have all of the forms created and everything work fine. The only problem is that the databases are created by another application and in that application they have the ability to set the database in any location on the computer. What I would like to do is have the program check the default location of the database and if it doesn't find the databases, then I would like to give the user the ability to search for the database on their computer and or network. I would appreciate any suggestions on how I should go about doing this. Thanks in advanced. If the pr ...Show All

• Smart Device Development running a program inside emulator

  I am using Win CE emulator 5.0 after I build the application on VS.2005 I reach it from emulator by main menu-file sharing. Althought my project is win CE project I can not run it in the emulator how do you run your program in the emulator regards You need to compile your application for X86 CPU architecture. You can select the output type of the project in a drop down on the toolbar. Thanks, Vladimir ...Show All