Paul Becker's Q&A profile

• SQL Server Newbie - Querying SQL Server Express 2005 database from Excel

  Sorry if this is a stupid question, but I created a database using SQl Server Express 2005 and I would like to query one of its tables from an Excel spreadsheet. Here's what I want to do in pseudo code. cell A2.value = select OLIGO_ID from table OLIGO where SEQUENCE = 'content of cell D2, a string' In other words, I want to search the database for a string that is in a cell and retrieve its associated ID number into another cell. I need to do this on many cells. Any help is appreciated. Thanks. I guess you can do that with VBA. As far as SQL is concerned I do something like that t ...Show All

• Windows Forms Graphics question

  Ok my problem is with Graphics class //------------------------------------------------------------------------------------------------ private void Form1_Paint(object sender, PaintEventArgs e) { Graphics g = e.Graphics; g.DrawLine(new Pen(Color.Black), new Point(30, 30), new Point(30, 100)); g.Dispose(); } you see i declare Graphics g=e.Graphics where 'e' is the PaintEventArgs and then draw a line //---------------------------------------------------------------------------------------------- private void button1_Click_1(object sender, EventArgs e) { Graphics g = CreateGraphics(); g.DrawLine ...Show All

• Visual Studio Express Editions creating a new project

  I cant creat a new project on c++ express edition because when i try it just says "Automation server can't creat object" can anyone help. Hi, did you have any further versions of Visual Studio Express installed on your PC this often produces problems. Here is how to uninstall if you did have previous Versions installed: http://lab.msdn.microsoft.com/vs2005/uninstall/preRTMuninstall/default.aspx you also may report problems to the msdn product feedback center . ...Show All

• Visual Basic Use string value as variable name

  How do I use a value of a string as a public variable name/object that I can then change.... dim var1 as integer dim var2 as integer dim var3 as integer...ect... Dim vroot as string = "var" Dim i as integer = 1 Do var + i.tostring 'this returns "var1" 'now how do i use this var1 returned value to act like a variable i=i+1 loop until i = 15 Also how would i do this with objects....say i had a series of labels named label1, labe2, label3...ect... to call these through a "label + i.tostring + .text" script also...... Catch my drift....is this possible Thanks! For the issue with variable names, here is ...Show All

• SQL Server Cannot connect to SQL2005

  Hi, This is the error I am getting - HELP A connection was successfully established with the server, but an error occured during the login process(provider: TCP Provider - error 0 an existing connection was forcibily closed by the remote host. (Microsoft SQL server error: 10054). I have checked the error code 10054 - at this link http://support.microsoft.com/default.aspx scid=kb;en-us;Q303120 it says it applies to SQL2000 Regards Sahil    For a faster response I suggest you post this to the  SQL Server Data Access   forum. Dan ...Show All

• SQL Server Automate partition creation

  Hi, Is there any example out there on how to automate the creation of time based partitions As an example, I would like to create 1 partition for each quarter and when a new quarter start have a new partition automatically added with the same attributes than the previous one. I would also have the oldest 4 partitions automatically deleted as soon as the total number of partitions reaches 13. Any thoughts or links Thanks, Philippe Hi Philippe, The Project REAL Analysis Services Technical Drilldown discusses one implementation of such automation: http://www.microsoft.com/technet/prodtechn ...Show All

• SQL Server Inserting multiple nodes as type xml in SQL

  Hello, I'm working with SQLXML for the first time and need help! I am working with a customer who passes a CSV from an old accounting system, from which I use XSL to transpose it to a more logical xml document, each row of the CSV matches an item node. <data>     <purchase>          ...          <order>          <OrderID>1</OrderID>              <item>             ...Show All

• Visual C++ SOS:VC2005 B2 Express VC++ Directories Problem

  I downloaded and installed VC2005 B2 Express, I can't set "VC++ Directories". screenshot: http://member.netease.com/~lilong/temp/VS2005ExOpt.jpg is this bug this is a BIG PROBLEM!!   NNTP User wrote: ... 1. Create a directory "PlatformSDK" under "%ProgramFiles%\Microsoft Visual Studio 8\VC" 2. Copy the "bin", "include" and "lib" directory from the PSDK-installation into this directory. Then you do not need to change any config file. ... Thank you very much. I just encountered the same problem and found this thread. ...Show All

• Visual Studio Team System TF86001: Team Foundation was unable to load the Office AddIn

  After dealing with the daunting install process and getting it right, now I'm able to create projects and work with most of the items, however I found a new issue while trying to open any of the Excel sheets included in the default project team solution structure from WSS and I get that error, funny thing is that this only happens with XL files, since I can open Word and Project files with no issues Here's what I'm running on: Server: Windows Server 2003 sp1, SQL 2005 Sep CTP (data, analysis and reporting services), VSTS Server Foundation beta3, WSS sp2 Client: Windows Server 2003 sp1, Office 2003 Pro sp2, VS2005 Release Candidate, VS ...Show All

• Visual Basic Checking for a previous instance

  To check for a previous instance of your apllication (App.PrevInstance in VB6) the help file for '05 suggests you check the "Make Single Instance Application" box in the project's properties and then add an event handler for "Me.StartupNextInstance."   This is great if you're using the application framework and starting the project with a form (I don't think a "Sub Main" has a 'me' object does it ).  Anyway, I'm not using the application framework therefore the "Make Single Instance Application" checkbox is greyed out so presumably the StartupNextInstance event will not be firing.  Now what ...Show All

• Visual Studio Express Editions Class Library can't access System.Windows

  I'm trying to create a new Class Library for a custom control. The base code is as follows: Imports System.ComponentModel Public Class DynamicCheckedListBox Inherits System.w... End Class When I try to type System.Windows.CheckedListBox, Intellisense shows no entry for Windows. The list displayed includes "WeakReference", "XML", but no Windows option. In my other projects, this works fine. Yesterday I had a similar problem wherein System.Windows was acceptable, but there was no entry for CheckedListBox. Somehow along the way, it showed up on the list, as I tried creating a new project. ...Show All

• Windows Forms Need help on Update commandtext

  Hi, I am very new to VB.net Please help! I am writing a form that is connected to sql database. I have the add, delete buttons working fine, but not for the edit which updates the record. here is the code for btnSave which used for both add and edit: '******** SetButtonsAfterEdit() lockBoxes() mbmSupplier.EndCurrentEdit() daSupplier.Update(DsSupplier1) DsSupplier1.AcceptChanges() ********* But when I click save after updating the textboxes, I received an error message saying that the update commandtext is not initialized, so I click on the property window and select the commandtext and use the build query ...Show All

• Visual Studio Team System Why is the timeout attribute ignored in Visual Studio

  Using the [ Timeout (1000)] in a testmethod does not have any affect in Visual Studio. However, if the test is run from the command promt using mstest.exe it works as expected. Hello, Are you using the RTM version of Visual Studio The timeout attribute should work inside Visual Studio, you can verify this by creating a test project and adding the following code: [ TestMethod ] [ Timeout (1000)] public void TestMethod1() { System.Threading. Thread .Sleep(5000); } The test will timeout as expected Thanks, David [MSFT] Visual Studio eDT ...Show All

• Visual Studio 2008 (Pre-release) Modal "something" in browser app

  (I know this is a bit off topic…) I want to make my own modal dialog using a CustomControl or Popup with buttons. But how can I stop program execution and wait for a button to be pressed I mean something like this: public class MyOwnDialog: CustomControl { public static DialogResult OpenDialog(string question) { //Add control to window, and hook op buttons. //But how do I wait for button clicks } } Usage: private void OnDeleteCustomer(object sender, ExecutedRoutedEventArgs e) { if (MyOwnDialog.OpenDialog(“Delete customer ”) == DialogResult.Ok) { … } } Hope someone can come with an example or point me to a helpful webpage ...Show All

• .NET Development SignedXML, Multiple Signature(s)

  Hi. How to carry or have multiple signatures for the Referenced docs in a single XML file The case is, referenced docs should be signed by more than one person. It seems not tidy enough to have multiple xml files for the signatures instead of multiple signatures in one xml file. Though this is my assumption, would appreciate the input as to "one and only one Signature element could be in a SignedXML". Thanks in advance! I'm using SignedXML to add multiple x509 signatures to an xml document. I can verify all signatures by taking the last signature and checking it and them removing ...Show All