spar108r's Q&A profile

• Windows Forms Need samples of datagridview visual basic 2005

  I need samples of Datagridview with updating cell and with combobox in cell and giving the datasource to the datagrid in code without use dataset Thanks yes i know i can dowload samples from http://www.windowsforms.net/Samples/download.aspx PageId=1&ItemId=220&tabindex=4 but in this sample use dataset for datasource i search samples with code for the datasource ...Show All

• Windows Forms TextBox validation

  Hello all, I can't seem to find an answer to this question, although there are many similar questions. I want to perform validation in a TextBox (on a Windows Form) which is bound to a DataTable. In my case the validation itself is simple. I can hook the event handler for the 'Validating' event, and I can determine if the text is valid or not. However, when I set the 'e.Cancel' property to true, the bound DataTable still gets a 'ColumnChanged' event. It seems that setting the Cancel property to true doesn't really cancel anything. How can I prevent invalid TextBox entries from getting to the bound DataTable Thanks, Ken I think setting e.cancel=true just prevent the focus from leaving th ...Show All

• Visual Studio Unable to create SourceSafe Object

  I'm currently using VSS2005. I did register ssapi.dll by "regsvr32 ssapi.dll"; however, I got error: "could not create object named "SourceSafe" from vbscript below. Please help. Set oVSSDatabase = WScript.CreateObject( "SourceSafe" ) oVSSDatabase.Open ( "C:\VSSData\srcsafe.ini" ) Set oVSSItem = oVSSDatabase.VSSItem( "$/Test/testingfile.cs" ) oVSSItem.Parent.LocalSpec = "C:\Projects" oVSSItem.Get VssItem is an object. Are you talking about return code from VssItem.Get function Get() doesn't have any return code - it gets the file locally if the local file doesn't exist or if it's different than database's version. If you need to know beforehand if Get will do anything you'll have to ...Show All

• Windows Forms embedding files in an installer

  Hello. You help is very much appreciated. I am building installer for my win App that among other things, it executes an external program(binary) called stunnel. stunnel reads some configuration information from a couple of plain text files. I DO NOT  want these text files to be visible to the user, but at the same time, they need to be accessible to stunnel(which expects plain text files). My question: How can I hide the text files from the user, but enable access to stunnel Can it all be embedded inside an executable (if it is possible,will stunnel  have plain texts file to read ). Thanks a lot Roy   Moved to the Setup & Deployment ...Show All

• Visual Studio Getting the physical page total during Print Preview in local ReportViewer

  Hi all, Thanks for your time in advance.  I'm trying to get the physical page total in local ReportViewer print preview, as it's not always the same as the logical page total and I have my own page navigation control. Is this possible Cheers, Jeremy ...Show All

• SQL Server An inconsistency was detected during an internal operation

  I am getting the following error: Msg 5242, Level 22, State 1, Line 1 An inconsistency was detected during an internal operation in database 'Finance'(ID:5) on page (1:361249). Please contact technical support. Reference number 3. It is caused by the following simple query: "SELECT DISTINCT GainStd FROM vPriceParamStdDiscrete WHERE GainStd IS NOT NULL ORDER BY GainStd" Could anyone offer any tip for fixing this problem Thanks in advance! hz DIdi you try to run DBCC CHECKDB for the appropiate database HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Happy New Year and Christmas everybody! Another question:

  Can i alter a table included in a Publication I am having problems with that. Mahesh Dudgikar wrote: You can change the compat from 80 to 90 and then use alter table. However once the publication compatibility is set to 90, you cannot go back to 80. 1. Is compatibility level defined separately for DATABASE and for PUBLICATION 2. If not: I have tried to change the compatibility level for unpublished database (both upgrading and downgrading), and it succeeded. Does publication lock downgrading of compatibility level of the database Thanks in advance! ...Show All

• Visual Studio Tools for Office Dynamically installing/loading and uninstalling/unloading Word's Addins

  Hi, This is my first post and not sure the querries is appropriate. sorry if it is not. Is it possible for a C# / VB.NET program to install Word 2007 addins and uninstall the addins when Word exit I would like my program to launch Word / Powerpoint and customised their Ribbon UI and reset the UI back to default when they exit. Can such a program be developed using VSTO or COM Addins. Any help /pointer would be greatly appreciated. The way Ribbon customization works is that each customization is associated with a particular COM add-in. The COM add-in needs to implement IRibbonExtensibility interface to plug its own Ribbon customization. The convenience of this model is, unlike CommandBars customizat ...Show All

• Visual Studio Express Editions Some controls in the toolbox are disabled

  Hi, I have developed some WinForms Controls for my apps, which I have also added to the toolbox in Visual C# Express 2005. In the first days it works great: I can drag&drop my controls on my forms. But now all of my controls are disabled and grey for some reason. I am still using WinForms, I am still using the same project or a new project, but I can't use my control any longer. I know there are several controls disabled, which are not usable on WinForms (like ASP.NET controls). But why are my own WinForms controls disabled Is this a bug or did I something wrong Thanks Jorg I have my DLL on two machines installed. On both machines is the behaviour the same: All of my con ...Show All

• Visual Studio Tools for Office Help embedding Excel documents into a Word Document

  Hi there Can someone tell me how to or direct me to an appropriate tutorial that can show me how I can, programmatically, insert an excel 2003 sheet into a word 2003 document by using the VSTO EG: Document a = WordDocument Document b = ExcelSheet a.Section(n).Insert(b, DisplayAsIcon) I have hunted for advice on this but cannot find it anywhere. I am using VS.NET 2005 and am not fussed on a C# or VB.NET solution I just need to be able to insert the document. Thanks! Hi Cindy I'm afraid I haven't heard anything back at all Do you know of a way that in which this can be done Regards Andrew ...Show All

• Visual Studio 2008 (Pre-release) Many-to-many relations query

  I have two tables (Customers, Departments) and an association table (Customers_Departments). I would like to create an asp.net gridview related to a Customer and with an entry foreach department with a checbox which indicates if the Customer belongs to the Department. Which is the best and more efficient query to fill the gridview Any help appreciated, thanks Here is how you could write it: var q = from d in db.Departments join cd in db.CustomersDepartments on d.Guid equals cd.DepartmentGuid into cds select new { Department = d, Assigned = cds.Any(cd => cd.CustomerGuid == customerGuid) }; Or you could just compute the ...Show All

• Windows Forms How to pass variables between forms

  Hi, I have a login form and the main form of my program, I would like to pass the username that the user typed in the login form to the main form, could somebody help me with this please. Thank you in advance. Hi, This link may answer your question: http://themightycoder.spaces.live.com/blog/cns!EBFBA22CD769E10B!144.entry   Quote: Access a value in one form i.e. the value contained in a text box and use that in another form, possibly to set a label in the original form.  So below is a small fully functioning example (copy and build at will) which shows a form, Form1, with a button and a label.  When the button is clicked it opens up an instance of Form2 which has a textbox. ...Show All

• .NET Development Detecting remove lock event on file

  I have the following problem: We have to write an application that acts on changes on files. For example editing a word - file. We achieve this using the FileSystemWatcher from .NET 2.0.  When the word-file is saved the events correctly trigger, but the files are locked, which causes our action to fail, but this is not the problem. But when the user closes the word-application. The application release the lock,but  we can't seem to catch this event so we could run our actions then.   Does anybody has as solution Thx, gert The problem here is that we have a 3,5 Terra drive full of files that multiple users can edit. If we start a thread that listens for every file that ...Show All

• SQL Server Flat File Source Problem...

  I have a weird thing happening. I have an .csv file. When I try to load it into a table, I can do it easily in DTS 2000. But when I am trying to do it in SSIS 2005 with exactly the same settings (like Text qualifier, row delimiter etc.), I am getting an error: "The last row in the sampled data is incomplete. The column or the row delimiter may be missing or the text is qualified incorrectly." I looked at the file and it looks complete to me. What could be the problem P.S. DTS 2000 is on 32-bit Windows, and SSIS 2005 is on 64-bit Windows 2003 . Could that we a problem The format is: Delimited The text qualifier is: <none> The Header row delimiter is: {CR}{LF} Under columns: The Row deli ...Show All

• Visual Basic Custom DataGridViewCell

  Hello! I wanna to build a custom DataGridView where it's cells are made by a user control for this , iam facing a problem in building the custom column and custom cell from which class this custom cell ,which is a user control , must inherits by the way this contol contains 3 labels and 3 textboxes please i wanna your help urgently... There's an example in the help files on customizing the DataGridView cells: How to: Customize Cells and Columns in the Windows Forms DataGridView Control by Extending Their Behavior and Appearance http://msdn2.microsoft.com/en-us/library/7fb61s43.aspx Or, one which implements a masked edit box: http://msdn2.microsoft.com/en-us/library/ms18099 ...Show All