CarmenM's Q&A profile

• Visual Studio Tools for Office Microsoft Office 12.0 Access Database Engine OLE DB Provider

  I am accessing Data from Excel 2007 that needs the above mentioned provider. But as installing Office 2007 on prod servers is not a good solution. so my question is that What minimum Office 2007 components will suffice to install the Microsoft Office 12.0 Access Database Engine OLE DB Provider on system, or did microsoft release any MDAC like compnents to install this. Thanks in advance... Atul Hi Atul This forum is dedicated to the VSTO technology. Your question doesn't fall under that category, so you're less likely to get an answer here than in a group dedicated to Office applications. Your best bet is probably the access programming newsgroup . Many of the regulars there have been invo ...Show All

• Visual C# Excel Cell data validation

  Can any one help me in figuring out how to validate the excel cell data Here is the scenario i have: When the user uploads the file, i am saving it to server and using OLEDB data provider to read the content. But i need to check the data in excel file if it's numeric and non-blank is there any better approach of validating this instead going each row and cell Thanks in advance SN ...Show All

• Visual C# Enum DataBinding (SelectedValue)

  Why is it that the Binding method ....Binding ( propertyname ,bs, datamember .... not working ..... datamember : of type short propertyname: SelectedValue I am using : combox.DataSource= Enum .GetValues( typeof (xxxtype )); where xxxtype is of enum type. Regards Alu Hi HellSing Use this. It works! ComboBox1.DataSource = System.Enum.GetValues(GetType(MyEnum)) Regards Kapalic ...Show All

• Visual Studio Express Editions How do I combine 2 xml files?

  I have two xml seperate xml files and would like to combine them together one after another. How can i be able to do that I know i need to first load both xml files out but than i don't know what's the code to combine the data together. Thank you very much The following code should get you started: Option Strict On Imports System.Xml Module Module1 Public Sub Main() Dim doc1 As New XmlDocument Dim doc2 As New XmlDocument doc1.Load( "D:\Temp\Temp.Xml" ) doc2.Load( "D:\Temp\Temp.Xml" ) Dim writer As New XmlTextWriter(Console.Out) doc1.WriteTo(writer) doc2.WriteTo(writer) writer.Flush() Stop End Sub 'Main E ...Show All

• Visual C# C# how to nest complex data

  Hi, I'm trying to set some properties where some are complex and I'm running into syntax issues that I can't figure out. My problem, I have a class called Item, it has properties such as Title, SubTitle, ReleaseDate and Principals. An Item can have multiple Principals, such as Actor, Director, etc. what I'v tried is ////outer class Item. . . private Principal principal = new Principal(); public List<Principal> Principals { get { return listOfPrincipals; } set { listOfPrincipals.Add((Principal)value); //above line cuases this error: //Error Cannot convert type 'System.Collections.Generic.List<Item.Principal>' to 'Item.Principal' } } //nested inner class Principal public class Principal { pr ...Show All

• .NET Development pls..help me to figure out the problem

  hi, when i tried to run the following code , the code keeps on running without creating the required table............... pls can anyone help me to figure out the problem........ waiting for your replies... int row_head = 3; int col_head = 3; TextBox [] columns1= new TextBox [5]; TextBox [] rows = new TextBox [2]; for ( int i = 0; i < 3; i++) columns1[ i ] = new TextBox (); for ( int i = 0; i < 2; i++) rows[ i ] = new TextBox (); columns1[0].Text = "col1" ; columns1[1].Text = "col2" ; columns1[2].Text = "col3" ; rows[0].Text = "rowh1" ; rows[1].Text = "rowh2" ; String [] description= new s ...Show All

• SQL Server my script not working when the name of a DB has - (the dash character)

  Hi, this script uses MSforEachDB to check all the SPs in all the databases and look for a keyword LockCookie . The script runs well except when there is a database with a dash - in ots name. ie: When in the script is replaced by a database whose name contains a dash - the dash and the rest of the database name after the dash is ignored. And I get the message for example: Could not locate entry in sysdatabases for database 'SharePoint_AdminContent_f5c0f71f'. No entry found with that name. Make sure that the name is entered correctly. Here is the script: exec sp_MSforeachDB ' use select ''LockCookie'' as searchedTxt, o.name AS ProcName ,Len(SubString(object_definition(o.object_id),1, PatIndex(''%LockCookie%'', object_definitio ...Show All

• Visual Studio Tools for Office invalid bookmark after requery

  hi experts, I try understanding and solving a bookmark error using access 2003 SP2 connected to oracle database via odbc and oci. The form interface is the following : Left-handed is a sort-, filter- and searcheable treeview-control which is filled using a recordset "rs_show". rs_show will get data after reading an complex oracle-view into recordset "rs_tv_base", optionally filtering and sorting by setting sort and filter-parameters and then opening with rs_tv_base.openrecordset .. .. set rs_show = rs_tv_base.openrecordset Right-handed is a detail-area composed by a tab-control which shows different aspects of data - i.e. connected business-partners, accounts of business-partners, account-positions etc. Each ...Show All

• Visual Studio Team System TSD3025: The following cross-database dependencies could not be verified:

  Hi, Why do I get this Warning message on a system SP that is the same on both my local (development) and imported (on-line) server I'm running the version, edition and service pack on both systems. Warning 1 TSD3025: The following cross-database dependencies could not be verified: [msdb].[dbo].[sp_send_dbmail], [msdb].[dbo].[sp_send_dbmail].[@profile_name], [msdb].[dbo].[sp_send_dbmail].[@recipients], [msdb].[dbo].[sp_send_dbmail].[@subject], [msdb].[dbo].[sp_send_dbmail].[@body], [msdb].[dbo].[sp_send_dbmail].[@query]. Your database application might fail at runtime when [dbo].[sp_CalMillSpeedPerformanceHourlyEMAIL] is executed. C:\Documents and Settings\donron\My Documents\Visual Studio 2005\Projects\CMC-SERV ...Show All

• Windows Live Developer Forums Message history option inactive

  I want to know if this feature is actually inactive, because in my messenger I was able to save all my conversations without a problem, but since yesterday, the history is not stored in the xml files and the Message history options are not active in MSN Messenger, I hope somebody could help me. Thank you Orco2 wrote: I want to know if this feature is actually inactive, because in my messenger I was able to save all my conversations without a problem, but since yesterday, the history is not stored in the xml files and the Message history options are not active in MSN Messenger, I hope somebody could help me. Thank you The other way is change the directory that storing MSN Messenger chat lo ...Show All

• SQL Server Advice on indexes

  I have a table (detail) with 4 columns and over 30 million rows . Say the columns are called ColA, ColB, ColC, ColD ColA and ColB form a foreign key as this table is a 'detail' table for another master table in the database (master). The master table uses these two columns as its primary key. To speed up joins between the two tables I have created an index over ColA and ColB I frequently need to join the two tables together and so most of my queries are of the form: SELECT master.*, detail.ColC, detail.ColD FROM master JOIN detail ON master.ColA = detail.ColA and master.ColB = detail.ColB WHERE master.ColA = @valA ORDER BY master.ColB, detail.ColC This could return up to 60000 rows for a specific value of @valA. This is usually a sub-q ...Show All

• .NET Development C# Programmatically Setting Permissions and Compressing a Folder (NTFS)

  Hello, I’m writing a C# windows form application and need some guidance on a couple of issues. First, my application needs to change the permissions on a folder. The application creates a local group and I need to give that group Full Control permissions to a folder on the file system. Would anyone know how to accomplish this Next, my application also needs to programmatically set the properties of a folder so that it’s compressed. Would anyone know how to accomplish this Thanks! You may want to look into the FileInfo and DirectoryInfo classes for the general interface to do such things as well as their Attributes property and SetAccessControl() methods for changing properties of the files/ ...Show All

• Visual Studio Team System Cant install TFS

  Hello I got an error on tfs setup. I will paste the last lines of both log files. === Verbose logging started: 02/12/2006 23:20:28 Build type: SHIP UNICODE 3.01.4000.1830 Calling process: E:\Documents and Settings\Administrator\Local Settings\Temp\SIT40817.tmp\setup.exe === MSI (c) (18:78) [23:20:28:703]: Resetting cached policy values MSI (c) (18:78) [23:20:28:703]: Machine policy value 'Debug' is 0 MSI (c) (18:78) [23:20:28:703]: ******* RunEngine: ******* Product: d:\software\utilidades\tfs\atdt\vs_setup.msi ******* Action: ******* CommandLine: ********** MSI (c) (18:78) [23:20:28:703]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (18:78) [23:20:31:703]: Failed to grab executi ...Show All

• Smart Device Development I/O Exception on Save/Load

  I am converting an application from eVC++ to VS2005 C++. I can build the solution, but when I try to Start Using Debug it breaks, and says: Reporting file I/O exception on Save/Load with 10sError = $2 Does anyone know what this means This project is for a pocket pc, so I guess its from the function for the serial connection, but I am not reading or writing anything relating to the serial port. ...Show All

• .NET Development Where is Sysem.ServiceModel?

  I just installed VS 2005 with version 2.0 of the framework. I'm attempting to work through a WCF example. I don't see the ServiceModel in the AddReference list. Is this a 2.0 or 3.0 component I don't think you need to install the SDK for that (at least I usually only download the tools packages and that's enough), so it's probably the orcas tools you want. FWIW, technically speaking the necessary assemblies should be available right after installing just the runtime, but you'd need to browse to find them when adding them as references. ...Show All