Hiverness's Q&A profile

• Visual Basic Reading CD Audio tracks out of access

  Hi. I would like to know if its possible to read CD audio tracks out of  Microsoft Access. I must create a playlist of about 40 tracks, 5 different tracks must be able to be selected at the same time and be listened to at the same time via earphones. I have no idea where to start, and how to go about please, please, please advice Thanx ...Show All

• Visual Studio forget my admin password

  im  forgot  my  admin  password There's a couple of options available to you.  Create a Windows user called 'Admin' and log on to that user (or run the VSS administrator program under that user using RunAs).  VSS will use the Windows user and you won't need the password.  At least that's the case if you have 'Use network name for automatic logon' set.  http://support.microsoft.com/kb/283618/en-us The other option is to force the password back to blank. by hacking um.dat with a hex editing tool.  Search the web and you'll find va ...Show All

• Visual C# VS 2005 Beta 2 - Visual Web Dev - set default language to C# from VB

  On Visual Studio 2005 Beta 2 - Visual Web Developer How do I set the default language to C#   It seems to default to VB.  The default language is based on the Profile you choose when you started VS 2005 the first time. If you choose the profile as VB.NET Developer then my default even the language selected for ASP.NET Projects would be VB.NET. You can go to Import/Export settings tab and Reset the profile. Next time the IDE starts you can select the C# Developer and the default for ASp.NET Projects will be C#. Regards, Saurabh Nandu www.MasterCSharp.com www.AksTech.com ...Show All

• SQL Server CLR Trigger

  Hi,       I want to call webservice in the Trigger.  How to call the webservice from CLR Triggers .If anybody knows teh detail let me know.   And i worked out  the following Example code for CLR Trigger. using System.Data; using System.Collections.Generic; using System.Text; using System.Data.Sql; using System.Data.SqlTypes; using System.Data.SqlServer; namespace CLR {     public class Class1     {         public static void InsertTrigger()         {  &nbs ...Show All

• SQL Server Foreach Loop Container in SSIS

  Could someone send me any links or information on how to loop through an ADO.NET dataset in SSIS I need step by step information please. Thank you, Shiva Here are BOL topics that might help http://msdn2.microsoft.com/en-us/library/ms187670.aspx http://msdn2.microsoft.com/en-us/library/ms141724.aspx http://msdn2.microsoft.com/en-us/library/ms140016.aspx Some other helpful links http://www.whiteknighttechnology.com/cs/blogs/brian_knight/archive/2006/03/03/126.aspx ...Show All

• .NET Development Reset XML Declaration using XmlWriter

  I am trying to use XmlWriter to create XML. I need to have the XML Declaration to be < xml version="1.0" encoding="ISO-8859-1" >. I tried to set the Encoding in the XmlWriterSettings to "ISO-8859-1". I see the Encoding changes to “ISO-8859-1” in the setting but no matter what I do the resulting XML Declaration always looks like < xml version="1.0" encoding="utf-16" >. I don’t know if this is a bug or a feature. Here is my code: StringBuilder^  sbXml = gcnew StringBuilder(); XmlWriterSettings^ pXmlSettings = gcnew XmlWriterSettings(); XmlWriter^   w = nullptr; pXmlSettings->Encoding = Encoding:: ...Show All

• Windows Forms ListView ColumnHeader.TextAlign can not be set other than Left for Col 1

  VB 2005 Beta 2. When editing the columns in the IDE properties page for a ListView control, I am not able to set the TextAlign property of ColumnHeader1 to anything other than "Left" - for example, "Center" or "Right".  It also does not work in code: ListView1.Columns(0).TextAlign = HorizontalAlignment.Center Has no affect. Does anyone know why this might be Thank you very much for the link.  Additionally, in this link there is a statement on how to implement a workaround for this particular requirement under the "Remarks" section.  I have tried that work-around and it certainly does work. ...Show All

• Architecture db design question. . .

  My boss and I are having a disagreement. In our schema (SQL 2000), we have SSN nullable indexed. A year ago, we took a job that allowed one of our clients to do some batch processing that updated their HR database personnel into our database. The driver on this was an employee number. If the employee number is found, data is updated, if not it is inserted. Everything worked fine when it was one branch office. Now our client merged two branches. The old branch had different employee numbers after the merge. Unfortunately, our client merged the branch's version of our database into the m ...Show All

• Windows Forms two tables in a access database

  I have two tables in a access database, let’s say t1 and t2, t1 is customer names and t2 is customer addresses, I would like to put the customer names(t1) in a listbox and when I click the name the address(t2) come up in another listbox for that customer. Hello please next time try to supply more info, like: Are u developer of VB or C#, or are you using databinding or not. but i will try to help anyway: Assuming u are using data binding (Typed datasets): Go to the dataset designer and drag t1 and t2 to the designer and you will see adapters created for u (below each table), lets assume t ...Show All

• Visual Studio Express Editions SQL Server 2005 Express Edition April CTP fails to install

  I have spent the last hour trying to find other cases of the same install error on the web, but w/o luck. Does anyone know how to fix the following. I have Windows XP SP2 with VS 2005 Beta 2 (April 2005). When trying to install the "SQL Server 2005 Express Edition April CTP" I'm getting an error at the end of the install. Here's some of the messages: The initial error dialog: "Microsoft SQL Server 2005 CTP Setup" (window title) Microsoft SQL Server 2005 CTP Setup was unable to install on your computer. Microsoft SQL Server 2005 CTP Setup has encountered a problem and will end. After clicking on the "What does this error report ...Show All

• SQL Server Sub report ocassionally forcing page break when printing

  Looking for help. I have a report based on a list with 3 embedded sub reports in the list, each a table. Here is the issue, if a sub report is going to spill into the next page and can fit into a single page, when the report print previews/prints the sub report is forced to a new page. If the sub report is long enough to cover 1+ pages, a new page is not forced and the report prints as it is supposed to. The issue is not the fit table on one page setting for table in the sub report as this is not selected. If this is confusing I can provided images via email. Bottom line is I want to make sure the sub-report will start printing where it belo ...Show All

• SQL Server Grant All function giving errors

  I'm migrating from 2000 to 2005, what is the best way to handle the following error: The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity The code is below: DECLARE @sp_name AS sysname; DECLARE syscursor CURSOR FOR   SELECT name FROM sysobjects   WHERE (xtype = 'P' or xtype='V') AND ((status & 0x80000000) = 0); OPEN syscursor; FETCH NEXT FROM syscursor INTO @sp_name; WHILE (@@FETCH_STATUS = 0) BEGIN   EXECUTE ('GRANT all ON ' + @sp_name + ' TO Public');   FETCH NEXT FROM syscursor INTO @sp_name; END CLOSE syscursor; DEA ...Show All

• SQL Server Oracle ODBC date range

  What is the Syntax I can say "SELECT * FROM Invoices WHERE INVOICE_DATE > sysdate", but not INVOICE_DATE > sysdate - 1 (in any of its variations -- (sysdate-1), trunc(sysdate-1), trunc(sysdate)-1, etc.) If using ODBC Access , I can say INVOICE_DATE > DATE()-180, but that syntax doesn't work with ODBC Oracle. On a less positive note, is this beta software The Import/Export wizard exports tables that cannot be re-imported. That's Microsoft SQL Server to Microsoft Access. Varchar(3)'s turn into Memos, and unless someone tells me differently, nothing will turn a Memo back into a Varchar(3). ...Show All

• Visual Basic On DataGrid click get DataSet row id

  I want to populate textboxes on a form whenever a user clicks on a row in a DataGrid. I currently have a DataGrid with columns; id, surname, and name ...... when the user clicks on a row, I get the value in the first column (id; autonumber) ...... and then populate the textboxes by looking for the values in the id-1 row of the DataSet. For example: if the user clicks on the row with id no.3..... i get that id and look for the values in row 2 of my DataSet. A problem arises when rows in the DataGrid are deleted...... there will be a gap in the ids...... therefore if id nos.6,7,8,9, and 10 are deleted, and the user clicks on id no.11........ t ...Show All

• Visual C++ Label text setting in MSVC++.NET

  Hi. I am very new to MSVC++. I don't know anything really. I would like to know how to access the text property of a label (and all of the properties for that matter), and to edit it. I am used to VB.NET, where is is as simple as 'label1.text', but that didn't work with C++. Uhhhh, could you elaborate on that I can't quite figure out what to do. I am getting more errors when I try that than I did before. I am obviously doing something wrong. As usual. Thanks, The Digital Pioneer ...Show All