Klgsx's Q&A profile

• SQL Server Save query results for Word Mail merge

  Real beginner question, I have an ASP.net web app for a little ordering system. I want to be able to easily save the results of a SQL query someplace so that I can use Word to do a mail merge to produce Avery Address labels. Seems to me this should be very simple and yet I'm lost between the worlds of VB.net 2005, ASP.net 2.0, SQL2005, VBA, Office2003. If anyone knows off the top of their head I'd really appreciate it, its really easy using Access however I already have the dBase created in SQL and really don't want ot have to back-pedal.... Thanks, Rick Thanks I figured that out and so I guess I can merely drop a query into a temporary table on the dbase and then use the mail merge wizard...... Of course I was real ...Show All

• Visual C# How to create variables and configuration settings for C# Windows Project

  I need to store configuration details like Database Connection String, and other config details in a single location so that I can access it from any .cs file of the prj. How is it possible Thru some particular xml file or a text file PLZ reply asap as its urgent Sounds like this may be a task for the a User Settings action . The settings file, which is written in Xml, is used for such purposes like reading in a value, either for the user or the application .... See Using Settings in C# . / Using My.Settings in Visual Basic 2005 ...Show All

• SQL Server How I Imported my SQL Database Entities into my SQL Compact Database

  Hello: I am still working on my project, but figured I would share my findings with the community, on how I imported my SQL Server database tables into a new SQL Compact Edition database. Unfortunately, I haven't figured a workaround to the IDENTITY_INSERT issue, but other than that, I will proceed. 1) I downloaded and played with the tool presented in the article " Generate SQL Insert statements for your SQL Server 2000 Database " I made the following modifications . (my modification can be found here ) a) Disable scripting dependencies b) Add a filter for objects to script c) Prompt for each table from which to export data 2) From the scripts output by this tool, I had to (which I may integrate into the tool later. ...Show All

• Visual Studio Express Editions Changing Application Form Skin

  I am using Visual Basic 2005 Express Edition. I just wanna know if there is a way that I can change my form skin application. I am using Microsoft Windows XP operating system with the "LUNA" theme. In my application I want to use the "ROYALE" theme which installed on my PC. Is there any way that I can use the "ROYALE" theme without affecting my OS Can you please suggest me an idea about this. Since we can only use the "ROYALE" theme if we change the OS theme into "ROYALE", how can I apply theme into my application without changing the OS theme Thanks;) hi! if you want to skin your .net 2005 application, try the skinning component skinen ...Show All

• Smart Device Development cant find kbdui.lib!!!!

  can anyone please tell me where to get kbdui.lib !! Can you please explain what you are trying to do The only kbdui.lib I know is a Windows CE Core OS component (part of GWES). This lib is shipped as part of the Windows CE OS with Platform Builder. Michael ...Show All

• Visual Studio Express Editions How do I run a script such as calling the ipconfig.exe and place the output in a text box in a application Gui form?

  I was wondering how to run or call command line executables such ipconfig.exe and ping.exe and place them into a form. I want the output from the ipconfig.exe to redirect back into a textbox in my visual basic express edition application form. Thanks!!!! I would agree that there are better ways of doing ipconfig and ping functionality but I was answering the how to run or call command line executables such ipconfig.exe and ping.exe Which is using process.start and capturing the output. THis can be applied to any command line executable - ie. capturing the output from say the VB Compiler. But if it was simply to handling some of the networking methods, using the inbuilt framework functionality would be more effi ...Show All

• .NET Development Side by Side Execution

  Hello, Please can you confirm whether the following statement is true: If a .Net 1.1 application runs on a machine with both 1.1 and 2.0 runtimes installed, the application will try to run in the 2.0 runtime. In other words, if you don't configure an application to target a specific runtime, it will use the latest runtime installed on the machine. Thanks in advance. any application will use the framewrk it ws built with bcz its code by .net runtime is fixed .. if u run any appli of .net 2.0 in 1.1 u need to configur tht .same for 1.1 ...Show All

• SQL Server Can not remotely connect to instance of sql server 2000

  I had a big problem on connecting sqlserver remotely from other machines on the network ..... From any computer in the network i wanna to register the instance of the sqlserver from the enterprise manager ..... the server instance doesn't appear within the available sqlserver list (the servername which equal to my machine is the only one that appear) ..... when i manualy write the servername\alias manually and i choose the connection type and then i write sqlserver username and password and then finish he give a message to me that access denied or sql server doesn't exist ... !! by the way from the local machine i registered the local instance of sqlserver successfully and successfully i access the Databases ..... To be noted: ...Show All

• Visual Studio Tools for Office Outlook COM Shim to run Managed Addin Code

  In the interest of simplifying CAS maintenance, it's been suggested we use a COM shim for our addin. The COM shim would load in IDTExtensibility2, copy down any updated or added libraries, instantiate a CLR, and then call the managed code. It's not clear whether the delegates would be assigned under COM or IL. I can think of three questions -- First, does this approach bypass the strict CAS requirements of a managed-code Addin Do all the dependencies have to be individually registered as fulltrust for this to work In other words, does this approach allow us to load any managed assemblies we want without having to deal with CAS And, second, what APIs would be used from the managed code Obviously we're working outside of IStar ...Show All

• SQL Server how to write this sql

  I have table T1 with fields T1.ID, T1.CheckBoxCol The T2 tabel has the same ID as T2.ID and T2.CheckBox1, T2.CheckBox2, T2. CheckBox3 Now, I need to check T1 and if T1.CheckBoxCol=1 then set T2.CheckBox1=1 else if T1.CheckBoxCol=2 then set T2.CheckBox2=1 else if T1.CheckBoxCol=3 then set T2.CheckBox3=1 for each T1.ID How can I do this Hello, try the following syntax.... update Test2 set CheckBoxCol1 = Case T1 . TID when 1 then 1 when 2 then 1 when 3 then 1 when 4 then 1 else 0 end , CheckBoxCol2 = Case T1 . TID when 1 then 1 when 2 then 1 when 3 then 1 when 4 then 1 else 0 end , CheckBoxCol3 = Case T1 . TID ...Show All

• Software Development for Windows Vista CreateProcess does not return a value

  Hi, I encountered a weird phenomenon while trying to run a program on Vista. When the program reach CreateProcess, the function is being called but it doesn’t return any value, the program never exits this function. To make this problem weirder, sometimes, although very rarely, like after reinstallation of the OS, the application does work (The process is created and the function returns a value), I couldn’t find the reason why something it does work. As far as I know, CreateProcess should always return a value (Success or Failure), but in this case it doesn't return anything, just stuck inside the function. The Windows version is: Windows Vista RC2 Build 5744. The program which calls CreateProcess is wr ...Show All

• Visual C# Controling Controls from other Forms

  Hello! I have to Windows Forms - Main.cs and Menu.cs I would like to control the richTextBox control from the Menu.cs Windows Form. The richTextBox control is located on Main.cs. How can I do that: For example how can I execute the "copy" method of the richTextBox which is on Main.cs from Menu.cs. Please help! Thx Matt When you create the form its create a partial class for that now go to the form right click on its Initialize() and go to defination at the end of file there will declaration of all controls you can find your richtext box there now modify it to be static. ...Show All

• Microsoft ISV Community Center Forums VBA Code to save Excel w Name including cell data

  I need to develop a way to save an Excel spreadsheet to automoatically name the saved xls with the string data from cell B2 (client name), plus the now date and time (using the 12 hour clock). I've tried putting a command button on the template spreadsheet using the code below, and different variations as I find something else under the help section, but everything errors. The B2 spot is always where a client name will be. And the date/time factors are always unique so there's no overwriting. I don't want to necessarily go through the save routine, just straight save with the unique file name. I'm able to do it easily from my VB Express 2005 created form (in my program). With a button click, I save form data to a text file, the client's ...Show All

• Visual C# class inheritance

  hi, i am not sure where to post this, so i will post it here and wait to be directed. i have a problem with inheritance which leads me to believe that i am doing something fundamentally wrong. i have 2 classes: public class division { public string divisionName; } public class team { public string teamName; public division division; } these 2 classes are base. if i inherit both classes: public class superDivision : division {} public class superTeam : team{} i face the problem that superTeam.division returns me a base.division object. doesn't seem too bad, but the problem comes when i store a list of teams in the base.division. these teams are the base.team. so when i access them through ...Show All

• SQL Server Unable to instal SQL express for BCM in Outlook 2007

  I'm trying to install BCM into Outlook 2007. I'm able to get the Office package working and updated to TR2. However when it starts the install of BCM the first step is to install SQL Express. I get two error messages indicating failure to install and it refers me to the SQL log. Here's a copy of the most recent SQL install log. I've removed and reinstalled everything many times but the same error message persists on install of BCM. I've also tried to directly install SQL Express and get the same error. Any ideas Thanks, Rusty. Microsoft SQL Server 2005 Setup beginning at Wed Nov 15 00:27:13 2006 Process ID : 4188 c:\3da083fe7dc1cc4beb3920c6f8aa\setup.exe Version: 2005.90.2047.0 Running: LoadResourcesAction at: 2006/10/15 0:27:13 C ...Show All