ST1's Q&A profile

• SQL Server How to Control Sheet Name of Exported Excel Report?

  Is there a way to control the sheet name when a report is exported to Excel I have four matrices where a page break is made between each of them. Once exported to Excel, the resulting file has "Sheet1", "Sheet2", "Sheet3" and "Sheet4" as the names of its worksheets. Would it be possible to change it to a more user-friendly name This is not possible with RS 2000 or 2005 by itself. It's on our wishlist for a futu ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. .NET framework 2 & DX

  Hi, I have a DX application I've been working on for a while with .NET 1, however I want to upgrade to .NET 2 for generics and (does it have templates ), so will the upgrade affect the application at all Will I experience any problems What do managed dx9 2 and dx10 offer related to this. Will I need either as well, and what benefits and problems will there be in upgrading these in the middle of my project. Is it worth the upgrade thanks ag ...Show All

• SQL Server metadata refresh?

  What do you do to address this: [OLE DB Source [1]] Warning: The external metadata column collection is out of synchronization with the data source columns. The column "objectName1" needs to be updated in the external metadata column collection. A corollary question: what does right-clicking a package in Solution Explorer and clicking "Reload with Upgrade" do mruniqueid wrote: ...Show All

• Visual Basic Rendering

  What do you use to open up like a file (map for me) and then render something, do u use directx Depending on how do you plan to render your map; if it's just 2D bitmap, then GDI+ can do that already, and it's less complicated. -chris ...Show All

• Visual Studio Express Editions SQL and VB

  Hello I was wanderin say you create an app that has a sql database ... when you publish it and send it to a friend do they need to have sql database to connect to like i do in VB yea im a complet noob sorry and any sql intros would be great.. ty ty ty ty Yes, they need to have a database program installed ( almost certainly the same one ) and you also need to send scripts to build the actual tables/stored proc ...Show All

• SQL Server VB2005 can't connect to SQL Server 2000 file?

  Hi, everyone- When I try to add the MDF files of my Server 2000 database into C# Express (VS2005), it tells me that "An error has occured when connecting to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error 26)" Why is this happening I'm not even using SQL 2005! ...Show All

• Visual Basic Can i sell what i make

  can i sell what i make with visual basic 2005 beta 2 App will not be time restricted but the IDE will stop working I think. Also, the license says that the end user has to obtain the target from Microsoft which means that the .NET Framework Beta 2 may expire which means that your app also does not work. A good idea would be to change the date on ur machine to May 1th 2006 and see what happens - that will elimin ...Show All

• Visual Studio Express Editions Command object

  In Visual Basic.Net 2003 there were oleDbCommand objects which I used to create a select statement. I then created an oleDbDataReader in code. The command object then executed the reader object which I used to fill my comboBox with items. I did this so that I could update the items in the combobox from another form and so the comboBox would put the string in my database field and not the ID. My question is: I don't see the command object and ...Show All

• Visual Studio Express Editions form.showdialog problem

  i can get the OK message return when i press the OK Button in form frmChooseItems, also get the CANCEL message return when i press ESC If the focus on the control datagridview on frmChooseItems, when i press the enter, i cannot get the message "OK" return. I want to know how to : when i press the "Enter" on the datagridview on frmChooseItems, i can get the result sames as i press the OK Button. frmPI COD ...Show All

• SQL Server AdventureWorks db for 101 Samples

  I'm not sure if this should be asked here.  If it's the wrong place, let me know and I'll correct. I've just downloaded 101 Samples for Visual Studio 2005 .  But the data access samples require AdventureWorks database which is not included in the C# sample.  Who know where I can get this database   It is a SQL 2005 database, I think. Thanks! gaile- Thanks for your quick response. Specifically, from CreatingMaster ...Show All

• Visual Studio Express Editions Designer view won't work!

  When I try to switch to designer view I get an error report dialog::: "Microsoft (R) Visual Basic Compiler has encountered a problem and needs to close.  We are sorry for the inconvenience." After the error report dialog, I get a messagebox that says "More data is available" I can still compile projects and they work fine, but I can not view the designer. I have tried reinstalling Vb.net express but the error still occurs. ...Show All

• Architecture BlackBerry USB recognition

  Hi I want to write a program which will recognize a BlackBerry device connected to the PCs USB port.  I want to write this application in Windows Enviornment.  Can you please help me as to how I can go about listening for the USB device in Windows Enviornment in general   I would greatly appreciate if you could suggest me specifics on listening for BlackBerry device or general practices for any device Thanks in advance, v ...Show All

• SQL Server Help SVP: How to connect to external server and backup db with SSMSExpress

  Bonjour You'll have to be gentil with me, because until today I had never worked with MS SQL (I was developing with Access). Scenario & question: I have installed a phpBB forum running on MS SQL on my clients server. Since Saturday this forum just won't load anymore. I have tested the connection to the SQL database within Macromedia Dreamweaver and it's fine. I can view the table and the data contained in them. I would like to re-install php ...Show All

• Windows Forms Refreshing a Listbox

  Hello, I have a listbox that has its datasource property set to a custom collection I created.  The value and display members are assigned to properties that belong to the object contained in the custom collection. I want the additions and deletions  ...Show All

• Visual Studio Team System Single server install error in reportservice

  I'm doing a clean single server install. Everything goes smoothly until the installation script stops with the following message: vs70uimgr: DisplayMessage_START:Error 32000.The Commandline '"C:\Program Files\Microsoft Visual Studio 2005 Enterprise Server\BISIISDIR\uninstall\createds.exe" " http://GANDALF/ReportServer/ReportService.asmx " TfsReportDS "Data source=GANDALF;initial catalog=BisDWDB" "TNC\TFSSERVICE" "01000000d08c9ddf0115d1118c7a00c0 ...Show All