hrubesh's Q&A profile

• SharePoint Products and Technologies Options for Updating Excel displayed thru Excel Web Access ?

  I'm developing a dashboard which contains some graphs surfaced through Excel Web Access. This works great. However, is there a way of updating the Excel data without going into Excel (e.g. via a synchronized SharePoint list or by using infoPath) so I have more control over the UI I'm really looked for a code free solution so I don't have to worry about maintenance and deployment issues in the future, and so power users can also use the same method for their own sites. I just found the appropriate answer in your blog: http://blogs.msdn.com/luisbeonservices/archive/2006/09/28/consuming-sharepoint-lists-in-excel-services.aspx . Are there plans to add this functionaity to Excel Services The environment th ...Show All

• .NET Development how can i connect to paradox database file(.db) using ado.net

  Hi , I am developing a windws application. the back end is sql server 2000 and (another application storing clients info in paradox format)paradox(.db).it also using bde ver 5.1. 1)What is the best way to connect to .db files(odbc/oledb/....) how 2)is it better to convert all .db file to sql and then connect (30 users are using the application that storing the info in .db format) 3)will i be able to update paradox files using ado.net 4)can i connect paradox via sql server 2000 then use that table in my application (the way we connect sql server 2000 via ms access) thanks odbc is connection is looking for the .net driver. I could not find the odbc driver on my machine. so tried o ...Show All

• SQL Server Advice required: Matrix report with a static column

  First off, I apologize if this is an elementary question. Thanks for your patience. I have a requirement to develop a report that shows by calendar day how much effort a resource has expended on what tasks. So, I have a stored procedure that returns data that looks like this: Resource calendarDay description etcHours effortHours ------------- ------------- ----------- ---------- ----------- Smith, John 2006-08-01 Requirements 20.00 8.00 Smith, John 2006-08-02 Requirements 20.00 8.00 Smith, John 2006-08-03 Design 80.00 8.00 Doe, Jane 2006-08-01 Requirements 5.00 4.00 Doe, Jane 2006-08-01 Design 30.00 4.00 And I've developed a matrix report that looks like this: ...Show All

• Visual C# Metafile serialization impossible ?

  Hi, I would like to serialize a class which includes an image property field. I have no problem saving a bitmap image. However, when using a metafile (*.emf format) the result is also converted to a bitmap. Could someone please point me in the right direction Thanks, Sylvain [ XmlElement ( "Image" )] public byte [] ImageByteArray { get { if (_image != null ) { TypeConverter imageConverter = TypeDescriptor .GetConverter(_image.GetType()); return ( byte [])imageConverter.ConvertTo(_image, typeof ( byte [])); } else return null ; } set { if ( value != null ) { //TypeConverter imageConverter = TypeDescriptor.GetConverter(typeof(Image)); //_image.GetType()); //_image = (Image)image ...Show All

• SQL Server Workgroup -> domain impersonation

  In the following scenario, I am getting the message 'Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection'. I am running a Windows Server 2003 with development environment and Sql Server Management Studio in a workgroup on a virtual PC. My SQL Server 2000 is running on a domain server. On the virtual Pc I have setup my user login and password to be the same as my domain login and password. Why is the Management Studio not using impersonation and allowing me to connect to the SQL server on the domain Hi, sorry but this was not my intention. I did not say, that he has to join the computer in the domain. In Windows 2003 Server (as there is also an option in Wind ...Show All

• Windows Forms MDIParent/MDIChild Problem

  Hi there! I have a problem with my MDIApplication. - I have a MainForm that is sat as a MdiParent. - MainForm is set as TopMost Form. - I call a MdiChild from MainForm. -MdiChild calls a Form with ShowDialog() I can't see my Form called from MdiChild. And I can't figure out what's the problem. Can somebody help me!!! Set the Child form's TopMost property also to true and show it like mdiChildForm.ShowDialog(this); telling it its PArent! I hope this will work just fine! Best regards, ...Show All

• Internet Explorer Development Problems Deploying the BHO (was: New MSDN BHO Article)

  I have built a BHO based on this article and it works great, but I cannot deploy it to machines that do not have Visual Studio 2005. It won't register and I have fixed all the errors that Dependency Walker showed. Has anyone else had problems deploying Murph Yes, I meant to say "Release" not "Retail." (Fixed above.) Old habits die hard. I would also be interested to know if anyone else is having trouble. I have deployed the BHO to a Windows XP SP2 Pro box without VS2005 and it worked for me--but there may be trouble if the target system isn't running the latest service pack. See http://channel9.msdn.com/ShowPost.aspx PostID=23261 . BTW, the best way to deploy is ...Show All

• Smart Device Development PocketPC Windows Media Player

  Hi, Not sure if this is the correct forum to post this question too. On my PocketPC I have Windows Media Player 10 for Pocket PC. On my laptop I have Media player 10. I wanted to run some of the Webcasts(.wmv files) that are available on the developers sites on my PocketPC. They all work fine on the laptop but when I use the media player to sync them to my PocketPC they will not sync. Get some type of media types do not match error. If I bypass using the laptop media player and just copy one onto the PocketPC it works, just audio not video though. Not sure if I can even run the same .wmv files on the PocketPC. Thought I could. Any help would be appreciated. Jeff This fo ...Show All

• Visual Studio Team System TFS Database(s) Best Practices?

  I was wondering if there are any best practices for maintaining the TFS databases. Can anyone point me to a document on this topic Or have any tips or real world recommendations Thanks! In terms of regular maintenance, they're not really any different than any other SQL Server database. We are a heavy user of tempdb since we use RCSI (Read Committed Snapshot Isolation) in some of our databases. In terms of database maintenance, you may want to check the "Administering TFS" pages at http://msdn2.microsoft.com/en-us/library/ms252466.aspx ...Show All

• Smart Device Development 600 x 800 screen in the device emulator possible?

  We have some devices. They have 8", 10" and 12" screens. The resolution of the screen I worked with in my last project had a 10" screen and a 600 by 800 resolution. How do you emulate this in the VS2005 device emulator. I've always used the Pocket PC emulator and that screen seems to be smaller than 600 x 800. Plus it's more tall, our screen is wide like a regular PC screen. The OS of our device is Windows CE 5.0 right now. Is it possible to emulate a 600x800 screen in the VS2005 device emulator I've also heard you can emulate the situation where our device connects to another node on a CAN network via a CAN interface or to a PC via the serial port. How would you do that We have brightness and contrast contro ...Show All

• Visual Studio 2008 (Pre-release) SQL 2005 XML data type DLINQ failure

  I'm creating a sample project using patient data is stored as an XML data type in an SQL 2005 server on a Windows 2003 SP1 server. I am able to get the data out and bind it to a grid, but when I attempt to SubmitChanges it fails with the following error "SQL Server does not handle comparison of NText, Text, Xml, or Image data types". The table has one column with an XML data type, and it fails regardless of whether or not that was the column modified. public partial class Form1 : Form { DataGridView _grid = new DataGridView (); PersonObjectsDataContext _dataContext = new PersonObjectsDataContext (); public Form1() { InitializeComponent(); ConfigureGrid(_grid); } private voi ...Show All

• Visual Studio Team System From Single Node to Dual Node with Clustered SQL Server

  I was wondering if somone has migrated TFS from a single server installation to a Dual Node installation with clustered SQL Server in the backend What kind of issues one should expect Also is a any document from microsoft that describes how to actually perform this migration Thanks Shahab While there isn't anything specifically for this exact scenario, there is MSDN Help documentation both on configuring TFS for use with a clustered SQL server in the data-tier (this should be present in the installation documentation), and documentation on moving from a single server installation to a dual server installation (see http://msdn2.microsoft.com/en-us/library/ms404854.aspx ). This topic assumes that as part of the move, you will ...Show All

• Visual Studio Tools for Office Errors loading add-ins created with VSTO SE

  Hi, I have a problem that was not there in VSTO V3. But now after installing VSTO SE Beta the addins that works in Office 2007 Beta2 CTP are no longer working in Office 2007 Beta2TR. Word Options Add-ins list it under inactive add-ins. In COM Add-ins it says under Load Behaviour " Not Loaded. A runtime error occurred during the loading of the COM add-in ". The errors is not displayed even though the " Show add-in user interface errors checkbox " is checked.   If the VSTO project is executed by clicking the debug button the addin work perfectly . The error only occurred when installed by double clicking the setup.exe in debug folder or by right clicking the Setup project in VSTO and installing it. This is true for addins created f ...Show All

• Visual C# I need to acces flash memory device

  Got an mp3 player (samsung yp z5 to be precise)I bought some time ago.Problem is its not connecting to my PC because I suspect there are some files inside it that have been erased.Is there anyway or some class I can use to view the remaining folders inside by force and maybe I can replace them.Could it be something to do with the Media Transfer Protocol.Being a novice I don't know where to start it will be a problem with the devices, or drivers, itself. If Windows can't seem to find them/remove them then there really wouldnt be a way of doing it in C# especially if they are hidden since it would make a call to Windows asking to get the hidden files and if Windows can't see them then I dont think C# would, ...Show All

• Visual Basic Simple thing needed PLEASE!!!!

  I want to either: Have a textbox a button and a picture box - User types somthing into the text box, If its one of the words in my i've put in the IF bit of my script then the picture changes to a different one, else it leaves it the same. Or Have some radio buttons / tick boxes. User clicks in a radio button / tick box and the picture in the picture box changes accordingly. BUT If there isn't a way to get the picture box to change pictures like that some text that changes would be OK as a second choice. Thanks in advance! to load an image into the picturebox: Me.thePictureBox.Image = Image.FromFile( "path\filename.ext") you can load it at any time you like, any picture y ...Show All