Conrad Chan's Q&A profile

• Windows Forms How to allow edit of Multi-line text in a DataGridView cell

  Trying to figure out How to allow edit of Multi-line text in a DataGridView cell. I'd like something like the VS2005 IDE does when editing a text control's text property. Shift+enter opens a new line... See this post also... http://forums.microsoft.com/msdn/ShowPost.aspx PostID=71416 ...Show All

• Windows Forms Auto-updating applications - options?

  Hi, I was wondering if there are any other good solutions to auto-updating winforms applications out there. I can not use ClickOnce as I need to register COM components, need access to all system ressources, etc. Anyone knows of a good solution Thanks, Tom You don't need to register COM dlls in ClickOnce Deployment. ClickOnce has a great Registry Free COM interop support built in.. Look at the article by Dave Templin http://msdn.microsoft.com/msdnmag/issues/05/04/RegFreeCOM/ The article considers a VB6 COM DLL in the example.. but same can be applied to any COM dll. If you have other reas ...Show All

• SQL Server How do I get the value of a column in the last row of a 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 Define last row maybe this will do what you want but it is kind of dangerous because you might pick up the inserted row from another connection Select Max(CallID) from Calls Denis the ...Show All

• Visual Basic Set an environment variable

  Hi, I'm looking for the possibility to set an environment variable temporarily for an application that my VB-application starts. My VB-application look like this: Dim pExtApplication As New Process pExtApplication.StartInfo.FileName = "ExtApplication" pExtApplication.StartInfo.Arguments = "--help" pExtApplication.StartInfo.UseShellExecute = False pExtApplication.StartInfo.RedirectStandardOutput = True ' something like Environment.Set("CONFIGURE_SETTING", "NO_CHECKOUT") pExtApplication.Start() Info = pExtApplication.StandardOutput.ReadLine() pExtApplication.Wai ...Show All

• Visual C# delete blank rows in csv

  hello, I import a csv file into a mssql database. It seems that operates good. But there is a problem. The file includes blank rows in irregular order. How can I delete such rows thx dabro Hi, can you show your sqlString You can set your sqlString so that it take only non-zero value to account Abongs ...Show All

• .NET Development Create new Object from unregistered DLL

  Hi Guys(.and Girls..) ! I want to create a reference to a DLL (which is just copied into same Directory) as for example do_it.exe; No i want to call this dll from do_it.exe; I know the API(Public Class inside of the DLL with methods and properties..); How can i call this dll fromout of the executable without having this dll registered; If using createObject("<my_class>") ... is .net able to locate the dll ..or has it to be copied to a specific path Can i directly call the class (also if its inside a namespace).. plz give some hints or example if available.. thanks in advance max Is the dll u ...Show All

• SQL Server Upgrading MS SQL Server 7 SP4 Standard to 2005 Enterprise (Eval Edition)

  Hello, you all, I did all the stuff necessary for the upgrading (the Upgrade Advisor didn't say anything special), but the Setup says the following: " Name: Microsoft SQL Server 7.00.1063 Cause: The update is blocked. You can obtain more informations in the online help "Versions- and editionsupdates". Editions problem: The update is blocked because of rules for the editions update. " Is it possible that an upgrade is not possible with the evaluation edition Or can there be another cause Thanks in advance Oliver I believe that's correct: we don't allow upgrades to the eval edition - exce ...Show All

• SQL Server Merge replication failing after recreating the publication

  I am having a problem with merge replication after recreating a publication. It is a simple two-way replication between two servers allowing applications to update data at both ends, i.e. 1 publisher, 1 subscriber for all tables except some junk ones. The problem started after I did the following: 1) I dropped and recreated the publication to allow for some changes to the database schema. These caused problems so I dropped the subscription and publication and restored the databases at each end from backups taken before we started. 2) When I created the publication again, it wouldn't let me use the same name as it thought the publicatio ...Show All

• Visual Studio Release 2!

  So I got a marketing email for a new product called xCelsius from BusinessObjects, but I did not receive anything to tell me that Release 2 is available. I went to their website to see if there was an update as to the release time frame and instead found a download page. http://www.businessobjects.com/products/reporting/crystalreports/xi_release_2.asp Hello, Posted in another thread, but I am going to make this a sticky so it is more obvious. Keith - Business Objects ...Show All

• Visual Studio 2008 (Pre-release) Element Operators: First vs. Single

  After perusing the Standard Query Operators doc (available here ), I'm a bit curious about the differences between - [1.13.1] T First(IEnumerable<T> src, Func<T, bool> predicate) and - [1.13.5] T Single(IEnumerable<T> src, Func<T, bool> predicate). At first glance, they appear to be synonymous. Are they the same What motivated the decision to provide two methods which perform the same action Also, as an aside, why is Func<T, bool> preferred over the existing Predicate<T> for all of the query operators Predicate<T> is an established delegate and seems a bit more descriptive, but I can see the argumen ...Show All

• Visual Basic initialise settings variable

  Hey guys,                  In my application I have a setting that is an arraylist variable. I keep getting a Nullreference exception because it hasn't been initialised yet. So easy I initialise it but then it does that every single time I start up and the variable is emptied every single time when I want to be able to save it on exit and reload everytime. Is there anyway i can get some code to run on the first time the application is run to initialise it or even something that can tell whether it has been initialised already. Thanks in advan ...Show All

• Windows Forms DataAdapter.Update with stored procedure

  Hello all, I have the following DataTable and DataAdapter and Update command: //Create, configure and fill DataTable dtPeriods dtPeriods = new DataTable(); dcCol = dtPeriods.Columns.Add("Period_ID",typeof(System.Int32)); dtPeriods.PrimaryKey = new DataColumn[] {dcCol}; dcCol = dtPeriods.Columns.Add("Begin_Date",typeof(System.String)); dcCol = dtPeriods.Columns.Add("End_Date",typeof(System.String)); dsAccounts.Tables.Add(dtPeriods); Global.strSQL = @"SELECT Per ...Show All

• SQL Server create XML Schema Collection Using UTF-8 in SQL Server 2005

  How can I create XML Schema Collection using UTF-8 encoding I have an xml schema using UTF-8 encoding. When I using it in the "CREATE XML SCHEMA COLLECTION" statement, I got the following error message: .Net SqlClient Data Provider: Msg 9402, Level 16, State 1, Line 1 XML parsing: line 1, character 38, unable to switch the encoding I understand the SQL Server 2005 us UTF-16 for xml data. Does it mean I need to convert the schema to use UTF-16 manually thanks! for a 98% BLL programmer who sometimes work at the db layer... this wasn't obvious first. ...Show All

• Windows Forms Need help populating a DropDownList in and EditItemTemplate

  I have a dropdownlist that I have in an EditItemTemplate that I need to populate with a list of files in a directory on my web server. Currently, this is how I'm retrieving the file names: DirectoryInfo dir = new DirectoryInfo(@"e:\web\xxx\htdocs" + strPath); FileInfo[] bmpfiles = dir.GetFiles("*.*"); foreach ( FileInfo f in bmpfiles) { ddl.Items.Add(f.Name); lblMessage.Text += "Name is: " + f.Name + "<br>"; } From my web form I am calling this class, passing in a path (directory name), the DropDownList I want to add the items to, and then a Label to see the ...Show All

• Visual Studio Tools for Office I think that is a Bug in Visual Studio 2005 (ActionsPane)

  Bug in Visual Studio 2005 (ActionsPane)  I am working in machine with visual studio 2005 beta and operating system XP professional and office 2003 with service pack 2. I have an error when I am adding controls in Actionspane in a word Document: this.ActionsPane.Controls.Ad(new DateTimePicker()); Because, I proved that in another machine with widows wp professional and office 2003 with service pack 1, and work correctly. The problem is that I don't know How I solving that. I read in some page Internet that i have format my machine but I don't want. Marcela Moreno System Engineer - ECI Banco de la Republica Fiduciaria y valores ...Show All