csdcomp's Q&A profile

• Visual Studio Tools for Office Document-level VSTO in Access 2007

  Will there be the possibility to create document-level add-ins for Access, just like it is possible for Word and Excel documents I would like to do this to replace some VBA-based Access-applications that need an upgrade, so now it seems the right time to convert them to a .NET based solution. What is planned is listed here: http://www.microsoft.com/downloads/details.aspx familyid=68978824-CA55-4208-A55E-5C4858183B31&displaylang=en COM-Addins (application level) are planned, but not at the database level. However, you should be able to use application level events to make your special tools available only when a particular database is opened. Another possibility would be to write the entire f ...Show All

• .NET Development Please help -> Invalid uri: the hostname could not be parsed

  I have this problem in some machines acessing a webservice from a VB app that uses a VB.Net wrapper class. The app works fine in others machines. But in someones I get this error when I try to consume the webservice : invalid uri: the hostname could not be parsed Thanks in advance. Hi Nathan, The problem is ok now. What was it : my .Net Class have properties like : proxyAdress, proxyUser and proxyPass. When working under a Proxy all was ok but without a proxy I had an error. Cause : whithout a proxy the VB6 app was setting the ProxyAddress with an empty string ( proxyAdress = "" ) and for some reason the .Net class was receiving something diferent and trynig to set an incorr ...Show All

• Internet Explorer Development block a website with bho give an error

  Hi all i m develop a application in vc++ using ATL/BHO name websapher to block a website from childrens. it work greate but some time it give me error and close the explorer. please help me to make this usefull. my code is: STDMETHODIMP CBlocker::SetSite(IUnknown* pUnkSite) { if (pUnkSite != NULL) { // Cache the pointer to IWebBrowser2. HRESULT hr = pUnkSite->QueryInterface(IID_IWebBrowser2, (void **)&m_spWebBrowser); if (SUCCEEDED(hr)) { // Register to sink events from DWebBrowserEvents2. hr = DispEventAdvise(m_spWebBrowser); if (SUCCEEDED(hr)) { m_fAdvised = TRUE; } } } else { // Unregister event sink. if (m_fAdvised) { DispEventUnadvise(m_ ...Show All

• SQL Server SQL Server - using a cursor to find and sum login/logout times

  Hi all, New to using cursors and i was after some help. We have a trace running to find instances of certain sp's, these basically tell us when someone logs in and someone logs out (1 row per event). Importing into a table basically gives me process, user, datetime e.g. 'login', user1, 2007-02-15 10:21:35.590 'login', user2, 2007-02-15 10:21:36.100 'logout', user1, 2007-02-15 10:22:45.100 'login', user3, 2007-02-15 10:23:23.100 'logout', user2, 2007-02-15 10:27:54.436 'logout', user3, 2007-02-15 10:30:03.237 What i need to do is to basically get to the point where we have user, total time in system' e.g. user1, 1min 10secs (close!) user2, 6mins 18secs user3, 6mins 40secs any help much appreciated. ...Show All

• Visual Studio Express Editions using button to build/execute AccessDB query, return data to datagrid?

  I'm using VB Express and have an Access 2003 db on a Dell Dimension 3000 using Windows XP with 512 MB RAM. I'm trying to set up a windows form application (form1) that will allow the user to choose a particular sales agent (combobox1, populated by a query that fetches all lastName and AgtCode from db named production, table named agents) and a specific week (combobox2, using a query of production.time to populate it with DISTINCT week). Once the user has chosen AgtCode and week, they can click on a button that will execute a query built around their selections to return all sales data for the selected agent and time period (querying production.salesdata) into a datagrid at the bottom of the windows form. However, I have no idea h ...Show All

• Visual Basic Can VB.NET application send msg to MSN or yahoo messenger ???

  Hi All          How to write a VB.NET application that allowed us to send msg to MSN Messenger or Yahoo Messenger Hi ....       Thx for the URL link ... it is freeware to used .... and how abt yahoo messenger any alternative way to send msg to yahoo messenger ...Show All

• SQL Server Invoice Detail

  Hi I have a invoice that displays the company name in a rectangle on top then it has a list in the list it has details tables my problem is that the invoice detail goes on the next page I need to have the company name as well on the second page I cant put it in the same table as the detail because I have a few tables in the detail so it is actually no header is it possible to have Repeated the Company name information on the next page Thanks A bit of a hack, but how about just creating another rectangle with visibility property =IIF(Globals!PageNumber.Value > 2) Not sure if that will work though since the body does not know about page numbers. Did you try Chris Hays's fix http:// ...Show All

• .NET Development sequence do not increment

  how can i increment a sequence if a data is already in a database. Whats wrong with my code When a new book is added it doesnt give error BUT the sequence is not incremented if a same booktitle is entered. I have three columns(author, booktitle, sequence). Sequence should increment if book with same title is added. But with my codes it doesnt. Protected Sub save_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles save.Click Dim DBConn As New Data.SqlClient.SqlConnection("DATA SOURCE = xxx;Initial Catalog= xxx;Integrated Security=True") Dim myDataAdapter As New Data.SqlClient.SqlDataAdapter myDataAdapter.SelectCommand = New Data.SqlClient.SqlCommand("Select * from books", DBConn ...Show All

• Software Development for Windows Vista Shell Namespace Extension inconsistencies in Windows Vista

  Hello all ! I'm developing a Shell NSE for Windows 2000/XP and Vista, and I've come across a strange problem. The interface IShellFolder provides two functions, CreateViewObject and GetUIObjectOf. According to the documentation, the first function is used to obtain a IShellView pointer to the view object that presents the items of the folder. It is, also, used to get other interfaces, such as IContextMenu, IDataObject etc. for the folder object itself. The latter function is used to obtain similar interfaces for items contained within the folder. However, I've noticed that in Windows XP SP2, the CreateViewObject is not queried at all for IContextMenu or IDataObject when it comes to the folder object. All these interfaces are queried throug ...Show All

• Windows Forms MDI Form

  In my application, i have an MDI application and all the forms that are being displayed are derived from "System.Windows.Forms.Form" ... in this case i were unable to bring the windows to the from simply clicking on the body of the form... I even used the onclick event to bring to the front. That works fine however on clicking on Tabs->TabPages or any other panel over the windows,it does not generate the click event for the form .. is there any simple method to bring the form to the front try Again... hmm public void OpenClient( int clientId) { bool foundForm = false ; for ( int g = 0; g < this .MdiChildren.Length; g++) { if ( this .MdiChildren != null ) { Form f ...Show All

• Windows Live Developer Forums v3 gives an error; v2 does not

  When I call CampaignManagement.GetCampaigns(..) and reference to v3 wsdls, I catch this error: "There is an error in XML document (1, 552)." If I change all the references to v2, it's smooth sailing. The context of the call itself is some of the very first I wrote and has worked countless times before. Why do you think there is a difference and what do you advise -Tal Hello, This issue has been verified: there is a current compatibilty issue involving nullable primitives and DotNet Framework 1.1. Our V3 WSDLs use Nullable primitives (a feature fully supported by DotNet Framework 2.0 and greater but not 1.1) this explains why developers using the older DotNet Framework 1.1 experience this ...Show All

• SQL Server Create the package on the server, and execute through sql server agent

  Hi, Some of you guys seem to be gurus with the new Integration Services technology, so I hope someone can lend me some advice, as I haven't worked much with integration before. Ok, here we go. What I want to do is select some data from my database and export the result to a flat file (really a .csv file with values delimited by semicolons). Sounds like a simple thing to do Well, I'm sure it is when you know how to do it :) I know I could manage the same thing by writing a C# class that creates that .csv file, but the decision has been made to use Integration Services for these kind of operations. I created an SSIS project in Business Intelligence Development Studio, and created a package (I defined the task flow etc.). By choosing ...Show All

• Visual Studio 2008 (Pre-release) How to improve DrawingBrush texture

  Hi all. These are my first days in 3D programming, so bear with me. I'm using WPF to display a 3D view of a geographical map of a site. The map is 2D vector art (so not a bitmap), and was exported as a DrawingGroup resource from Expression Graphic Designer (so as a XAML file). I apply this drawing as a DrawingBrush'ed material to a 3D plane. When the camera is close to this plane (like in a physical camera position), individual pixels of the texture get clearly visible (the closer, the more annoyingly clear). I understand vectorial textures are pixelated at some point, so I partitioned the 3D face up in a number of smaller triangles, hoping closer faces became finer textured. Yet this didn't seem to help. Do you have any ideas how I ca ...Show All

• Visual Studio Team System Updating default 'MSF for Agile' banner on project home page

  Hi all, I am attempting to update the banner on my TFS Project Portal Home Page. I have successfully customized the project template to our requirements but would like to update the home page banner. Note I am not trying to update the banners displayed on the Process Guidance pages, but the banner on the project Home page. I have already made a number of changes to the default SPS Site, saved it as a template and loaded this new template so it is used with my new project template. I expected to be able to also do this with Frontpage simply by uploading some new images, however when I attempt to upload the new gif files into the sites 'images' directory I get the following error: 'Server error: The Web site that is referenced ...Show All

• SQL Server Handling flat files that do not exist

  Hello, I have a package that contains 22 data flow tasks, one for each flat file that I need to process and import. I decided against making each import a seperate package because I am loading the package in an external application and calling it from there. Now, everything works beautifully when all my text files are exported from a datasource beyond my control. I have an application that processes a series of files encoded using EBCDIC and I am not always gauranteed that all the flat files will be exported. (There may have not been any data for the day.) I am looking for suggestions on how to handle files that do not exist. I have tried making a package level error handler (Script task) that checks the error code ("System:: ...Show All