byronfromwesleyan's Q&A profile

• .NET Development Serialize/Persisting SystemColor

  Hi Whats the best way to persist/serialize system colors. I want the user of my application to be able to set colors of certain elements of the application. If they choose a standard color such as Colors.Red I can save this as the RGB value so I know what to reload and use next time the application is run. But if they set an application element to say for example SystemColors.Control how do I save this so that its always the Control property of SystemColors and is robust for any future changes to this class. Thanks Steve I just checked, Color is always serialized as string via Settings class. So, SystemColors.Control gets serialized as "Control" and can automatically be deserializ ...Show All

• Windows Forms text box issue

  I happened on a textbox issue that may be of interest. In this case, I have a number of textboxes vertically aligned that contail $ amounts. Generally want the text right aligned so that the decimal points line up but since I don't like editing with right alignment, I use the Enter event to change the alignment and then use the leave event to put it back Private Sub Cost_Enter(..) Cost.TextAlign = HorizontalAlignment.Left If Cost.TextLength <> 0 Then If Cost.Text.StartsWith("$") Then Cost.Text = Cost.Text.Substring(1, Cost.TextLength -1) End if End if End Sub Private Sub Cost_Leave Cost.TextAlign = HorizontalAlignment.Right Cost.Text = Format(m_dlsCost, "Curre ...Show All

• Internet Explorer Development Unable to type in text box

  This is probably a common problem and an annoying one at that. While using ie7 the user is unable to type in the comment box. Any ideas maybe changing some settings such as phishing filter etc etc will help I know its lame but it makes mozilla look good right about now. Hi Robert, Can you provide more details Are you saying that you have an existing web site with comments enables and that a user cannot post comments when using IE7, but can if they're using IE6 If so, I would look at the code underlying the website and see if anything in the site's design would be targeting IE specifically, such as a web hack or other version detection mechanism, especially if the site is designed to use a strict docty ...Show All

• .NET Development relationship

  DataTable catTable = catDS.Tables["Categories"]; DataTable prodTable = catDS.Tables["Products"]; // Create a relation between the Categories and Products tables. DataRelation relation = catDS.Relations.Add("CatProdRel", catTable.Columns["CategoryID"], prodTable.Columns["CategoryID"]); // Create DataViews for the Categories and Products tables. DataView catView = new DataView(catTable, "", "CategoryName", DataViewRowState.CurrentRows); DataView prodView; // Iterate through the Categories table. foreach (DataRowView catDRV in catView) { Console.WriteLine(catDRV["CategoryName"]); // Create a DataView of the child produ ...Show All

• SQL Server currency format

  I have a field from curency format. I want its' decimal seperator to be ',' (comma) , and thousand seperator to be '.' (dot). Also I want two digits after the decimal. For example 24.350.045,23 How can I do this ...Show All

• Visual Studio CRChart from Three D Graphics....

  Does anyone have a clear explenation of how the CRChart from Three D Graphics works I am only trying to change the title of a chart in runtime, but it is not clear to me how it is done with these macros, and/or in code. Anyone Hello, thanks for your reply. I didn't actually answer my question, I have read everything I can find on the Internet about CRChart, so I understand that it can do alot of things. Which I find very interesting, and I hope to use it in my charts. But, I didn't really understand how I could do it in code. I've seen the code examples on the Three D Graphics website, but it didn't make much sense to me. All I could find was a small code example that I couldn't get to work, and a lot of ...Show All

• SQL Server String character literal in c#

  when i execute in sql this works fine: xp_cmdshell 'dtexec /f "D:\SSISProject\Integration Services Project1\ArchiveMainMultiTables.dtsx" /Conn TahoeDB;"Provider=SQLNCLI.1;Data Source=SE413695\AASQL2005;Initial Catalog=TestDB;Provider=SQLNCLI.1;Integrated Security=SSPI;"' but when i execute in C# i get this value string connect = @"TahoeDB;""Data Source=SE413695\AASQL2005;Initial Catalog=TestDB;Provider=SQLNCLI.1;Integrated Security=SSPI;"""; xp_cmdshell 'dtexec /f \"D:\\SSISProject\\Integration Services Project1\\ArchiveMainMultiTables.dtsx\" /Conn \"TahoeDB;\"Data Source=SE413695\\AASQL2005;Initial Catalog=TestDB;Provider=SQLNCLI.1;Integrated Security= ...Show All

• Visual Studio Express Editions It's one small step for you, one giant leap for me.

  My first User Control, would value any opinions on how I've done and was it worth it . It can be downloaded here. Insert link still not working http://freespace.virgin.net/viking.rover/PaintBox.zip Whoisit wrote: My first User Control, would value any opinions on how I've done and was it worth it . It can be downloaded here. Insert link still not working http://freespace.virgin.net/viking.rover/PaintBox.zip Hi, All i see is a DLL file in the ZIP file. If that's it how do you use it How about some documentation I know very little about dll files. Regards, S_DS ...Show All

• SQL Server using Output clause and return timestamp and return value

  I am trying to bring my stored proc's into the 21st century with try catch and the output clause. In the past I have returned info like the new timestamp, the new identity (if an insert sproc), username with output params and a return value as well. I have checked if error is a concurrency violation(I check if @@rowcount is 0 and if so my return value is a special number.) I have used the old goto method for trapping errors committing or rolling back the transaction. Now I want to use the try,catch with transactions. This is easy enough but how do I do what I had done before I get an error returning the new timestamp in the Output clause (tstamp is my timestamp field -- so I am using inserted.tstamp). Plus how do I check for co ...Show All

• SQL Server Clustering failure on install

  Hi, Where can I post issues with SQL 2005 clustering. Is there any prereq that needs to be followed before installing SQL 2005 on a windows cluster Thanks Hi Thanks while actually installing i get this error message I have checked the windows scheduling and it is started. setup failed to start on the remote machine. Check the task scheduler event log on the reote machine Why I am getting this error ...Show All

• Visual Basic create key/value pair for filename/path_filename to use in combobox.

  What is the best way to create a key value pair for a filename and filepath with filename. 1. Obtain files within a directory for a known suffix (eg. html) 2. Set variable to filename only using GetFileName() 3 Add filename to Listbox, ComboBox, etc. 4. When user selects FileName, use value (path and filename c:/xxx/xxx/filename to use as argument for Process.Start(PathFileName) Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load For Each filePath In IO.Directory.GetFiles(path, "*.html", IO.SearchOption.AllDirectories) Dim fileName As String = System.IO.Path. GetFileName ( filePath ) ListBox1.Items.Add( filePath ) Next filePath End Sub Priv ...Show All

• Visual Basic How to drop down items in listview or datagrid?

  I want listview and datagrid can drop down item like combobox. Please help me. Adding Combobox to a cell in a datagrid http://www.vbdotnetheaven.com/Code/Jul2003/2134.asp http://www.knowdotnet.com/articles/kdngrid.html http://www.csharphelp.com/archives/archive151.html Using 2005 and the datagridview cell type specifically for a combobox is there and well documented. ...Show All

• Windows Forms Hello, every one, wanner a suggestion

  I've develop a application(Using C#), and now i want add a new function, this function is burning CD. This is a new domain for me, Somebody can give me some suggestion to start this. I think there are some questions, 1) how to check CD (or dvd) Driver, 2) is there a disk in it and is disk a empty one 3) what's the type of this disk,(CD or DVD). i am do some preparations for this:) thanks. Probably the best start is working with Ahead Nero using their SDK: http://ww2.nero.com/nero7/enu/SDK_API.html But you need Nero installed for your application to work. Windows XP/2003 has a built-in functionality for CD/DVD burning, but I can't find documentations about the available APIs. If you found one, please post i ...Show All

• SQL Server help ! multiple fields using "IN" condition....

  Hi All, I am trying to do something like this Select * from Table 1 where (field1, field2, field3) IN (select field1, field2, field3 from table2 where fieldx = 'rt') This can be done in oracle. Is there any equivalent in SQL Server Can anybody please help ! Thanks. PN It cannot be done using IN, but instead by using EXISTS:     SELECT * FROM Table1 WHERE     EXISTS     (         SELECT *         FROM Table2         WHERE             Table2.fieldx = 'rt'   &n ...Show All

• Visual Studio Tools for Office Newbie: Excel / Web Service calls / Background Process / Timer

  I'm a VSTO newbie attempting to put together a VSTO proof of concept but am running into, what is for me, some showstopper problems that I can't believe haven't been solved by others or are not really problems cause I'm doing it all wrong... The POC is to call a a webservice at say 5 second intervals and populate lists in the Excel sheet with the data returned. An important aspect of the requirements is the the user can work on the spreadsheet whilst data is being updated and so some form of background process is required for the potentially slow webservice calls. I've managed to get this working using a System.Windows.Forms.Timer instance and the BackgroundWorker component, happily updating the lists on the sheet (flickering away ni ...Show All