Stephan Aiche's Q&A profile

• Visual Basic Writing to database

  Hi, As a new user to vb.net... I desided to follow the basic instructions cearfully. I have managed to find my way through the database programming using the odbc class. And I was successfully able to populate records from the database to listviews, treeviews, comboboxs and all sort of controls. Now I am working on phase 2 of my project whitch is writing back to database.... but unfortanilty I did not find a good illustration of how to do that using odbc data adapters. I am trying to send data from textboxs an listviews...  Can anyone help me with a syntax to follow Thanks in advance Hello, The following page on MSDN shows how t ...Show All

• SQL Server Combining text data rows

  I am working with a database derived from text documents. One of the tables (TEXT001) contains the text of the documents with each paragraph of each document assigned to its own row with a paragraph number in a SectionNo column. I want the entire text of each document in a single row with its own unique number (so that I can do a full text search with SQL Server 2005 that will search and return the entire document as a result). How do I combine the rows with the same DocumentID into a single row of text data This will put the entire text content of each document in its own row. TEXT001 table as it is Documen ...Show All

• SQL Server Log Files getting TOOO big with Nightly Restore Database, Need help.

  Hi, I have a website that displays customer data inside an SQL (Version 8) database. Everynight I download the latest version of their back office database (another SQL database) and restore it as a temp DB. Then I selectively copy the tables I want, overwriting last nights version of the data. My problem is that my log file grows really big and really fast. I am using the DTS copy data feature to copy the tables between databases. I have tried the limit database option, but it just compalins that there isn't enough space to do the job. I would appreciate any help anyone could offer. Please help! Michael Use simple recover ...Show All

• Smart Device Development Opening Windows media palyer

  Hi, The problem is i should be able to open windows media palyer programatically through a button when i click on the button.Is there any built in function available in C#...i am trying this in C# .NET CF 2.0. can any ine help me out... Thanks for reading.. can u help me in..how can we pass a url for this media player to play a file if we open it like that... thanks for ur help..it worked ( System.Diagnostics.Process.Start("\\Windows\\wmplayer.exe", "");) ...Show All

• Visual Studio CrystalReport (Could not load Assembly) Visual Studio 2005

  I have an application in Visual Studio 2005, the crystal report gives the following error 'Could not load file or assembly, "CrystalDecisions.Windows.Forms" Version = 10.2, Culture=neutral, PublicKeyToken = 692.... or one of its dependencies. The system cannot find the file specified.' I have to deploy this app and I need help. It runs on the development machine without error. But on different machine then the error will come and the report would not display. the following are the reference that are added. CrystalDecisions.CrystalReports.Engine; CrystalDecisions.Enterprise.Framework; CrystalDecisions.Enterprise.I ...Show All

• Visual C# System.Data.SqlClient.SqlException System error

  why i am getting this error ! An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll Additional information: System error. this is the code: SQLconn = new SqlConnection("Server=KOBNA\\SQLEXPRESS;Database=shefa;User ID=sa;Password=111111;Trusted_Connection=False"); int new_patient_id = 0; string insertCmd = "insert into persons (PERSON_NAME, ID_TYPE, ID_NUMBER, NATIONALITY, GENDER, DATE_OF_BIRTH, BLOOD_GROUP, COMPANY, PROFESSION, MARITAL_STATUS, OLD_FILE_NO, PERSON_IS_VIP, ADDRESS_FLAT, ADDRESS_BUILDING, ADDRESS_ROAD, ADDRESS_BLOCK, ADDRESS_ARE ...Show All

• SQL Server cube design issue

  Hi. I have two modules that have several dimensions in common but at the same time each has its own dimensions. is it best to design 2 cubes or one combining both thanks in advance Christina It really depends ;) In many cases one will find useful to create a single cube with 2 measure groups. Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights ...Show All

• SQL Server How do I get the value of a column in the last row of my table?

  With out using @@identity or count(*) how do i retrieve a value in a column in the last row of my table. here is the situation. ASP.net project has several sessions open. a user needs to get the value of a column in the last row inserted in a particular table. Select CallID from Calls where 'it is the last row inserted' thanks in advance. you can email me at ! cbmorton!@!gmail.com ! Chris Morton Hard to get the last row in a relational database. Last means many things: last inserted, last in clustered index, last in another sort, last in a particular index, last in the data page. Does you ...Show All

• Architecture Windows Zip

  Hi Is it possible to use the windows zip function on the command line I want to incorporate this into my program. I know there is an add on for win zip but was wondering if its possible to do with the windows own version... Cheers Hi! You mean using Compressed Folders I think it's possible if use Shell API, because Compressed Folders incorporated into Windows shell. ...Show All

• Windows Forms How to use DataGrids in a Windows app

  I'm trying to use the datagrid in a windows app that's basically a bunch of master-detail forms. My biggest problem is that I've never used winforms before since I've always worked in ASP.NET. Everything is different and more difficult here. I can't add comboboxes as easily to a datagrid column and I can't work with unbound datagrids. I'm sure this is& ...Show All

• .NET Development WebBrowser control in a Windows Service

  Hi, I need some help with the WebBrowser control. I'm writing a Windows service in .Net 2005 to monitor the up/down state of servers. One of the things I need to do is to check on the availability of URLs. So I added a WebBrowser control to the design frame of the form, and ran the service, and I simply get nothing from the WebBrowser control. I think this is due to the fact that there is no user environment associated with a service, and the WebBrowser needs a user environment. Is there some way I can either add a user environment to the serivce, or an alternative way to check for the availability of a URL Thanks!!! ...Show All

• Microsoft ISV Community Center Forums my buddy

  I love the buddy program. I think it is a great idea. I love microsoft products, and with the help of my buddy, I am learning more about my microsoft software. I have one problem. Even though I have tryed and she has tryed, I can't get her to show up on my instant messenger list, so I can talk to her in my messenger. We are still working on that one. But, my buddie is perfect for me. When I have a question, she is very helpfull and friendly, and she trys really a lot, to help me with my software. How long did it take for your buddy to contact you the first time I signed on to the program about 1 1/2 weeks ag ...Show All

• Visual Studio Express Editions A question about MSND Express: how can I launch manually

  You know when you install MSDN Library for Visual Studio 2003, there is a shortcut for the MSDN Library, and you can launch the program from the "All Programs", but when I install the MSDN Express Edtion with Visual C# 2005 Express Edition, there isn't such shortcut, and everytime when I want to read something in the library, I have to first launch the VC# program and then press F1, I think it's troublesome. So is there any method to launch the MSDN Express individually, either use command line or use something else.   Thanks in advance! Hi cssin, You can launch MSDN Express individually.  If you go to Start->R ...Show All

• Visual Studio Outlook Addin beta1 would not start Visual Studio 2005 released

  Hi, I could use some help. I am new at this. I installed the Outlook addin beta for VS 2005 it shows up for new project but on selection gives this message: Could not load type ‘Microsoft.VisualStudio.CommonIDE.TEmplateWizard.IWizard’ from assembly ‘Microsoft.VisualStudio.CommonIDE, Version 8.0.0.0, Culture=neutral, PublicKey Token=b03f5f11d50a3a’. Please help Thanks  Thanks, Yes I only have VS Pro. Is there a way to get the office templates for it Thanks for your help! ...Show All

• SQL Server installing SQLDMO 2005

  This article describes how to install SQLDMO 2000. http://support.microsoft.com/ kbid=326613 Anyone know the procedure for SQL 2005 If you want to redist DMO with your application you need to include the Microsoft SQL Server 2005 Backward Compatibility Components MSI. The SP1 CTP is available here: http://www.microsoft.com/downloads/details.aspx FamilyID=ae94bb12-c839-4b4f-a71b-412fb3a0500e&DisplayLang=en RTM is available here: http://www.microsoft.com/downloads/details.aspx FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&DisplayLang=en DMO is installed as part of this MSI. ...Show All