CraigZ's Q&A profile

• Visual Studio Tools for Office How to set a Custom Color?

  Hi everybody, I' ve got a custom control in my project. No I need a custom color. I have got the RGB values but I dont know how to implement. This isn't the right place to post, but its a office project so well you know. Thanks for the help ! int r, b, g; Color.FromArgb(r, g, b);   ...Show All

• SQL Server Looping through an excel spreadsheet

  Being new to SSIS I wish to loop through a series of excel spreadsheets and within each workbook loop through each sheet. I am aware of the For Each container but how can the each sheet in the workbook be referenced Steve Here is the draft of a revised BOL topic, copied into plain text because the HTML can't be copied neatly. How to: Loop through Excel Files and Tables Introduction The procedures in th ...Show All

• Visual Studio 2008 (Pre-release) DLinq Database Creation

  Hello everybody! Just some suggestions: 1) I'd like that .CreateDatabase() method from DataContext creates the Indexes by something like class attributes thus I would not need to do nothing on the Database IDE I think that database it's only to store objects and I prefer to parse manually objects also because can it have custom constraints. It has some plans in these scenario for next version 2) I'd like also of the DataContext ...Show All

• Architecture Lookup table architecture

  I come across the situation where there are many lookup tables with simple look up table structure in general. In database design I am anticipating each table with type and status looup along with some more lookups. In total if I have 250 data tables, it will take 500 lookup tables which will have 1500 DAL stored procedures and 1500 ins/upd/del triggers. I came across a way to simplfy this architecture by putting code and codeoption tables using ...Show All

• Windows Forms ToolStripMenuItem keyboard shortcuts swallow ListView/TreeView label edit shortcuts

  When the user enters label editing mode for a TreeView or ListView control, I would expect that keyboard shortcuts such as Ctrl-X, Del etc would be handled by the label edit control. This was the case with the beta 2 framework. However the behaviour of the 2.0 release framework seems to have changed in this area. It now seems that if the TreeView or ListView's parent form has a menu strip or context menu strip, then any key presses are first ...Show All

• Windows Forms Datgridview / C# problem

  Hi, I have classes: public class role { string _roleName; ... public string RoleName { ... } } public class person { int _age; string _firtstname; string _lastname; role _role; public role Role { ... } } I try bind properties to datagridview but (person) Role.RoleName doesn't work. Example: person p = new person(); p.FirstName="Niko"; p.LastName="Jalkanen"; role r=new role; r.RoleName="It-Designer"; p.Role=r; dataGridViewTextBoxColumn1.DataPro ...Show All

• Visual C# reading/editing html file

  Hello, I am trying to read in an html file, and replace a custom tag with a string that will be generated from the application. I am guessing the way to do this has changed with .NET 2.0, as the books I have refer to FileInfo objects that are not being accepted by Visual C# Express. I would appreciate it if somebody could provide me with some sample code, or point me to some references on the web. Thank you Jon, ...Show All

• Visual C++ Getting the contents of a standard old fashion text string into a dialog textbox.

  A quick howto question. I need to get the contents of a standard old fashion text string into a dialog textbox. Here is a code example from Form1.h... ... public : Form1( void ) { char test[132]; InitializeComponent(); // //TODO: Add the constructor code here // strcpy(test,someglobalstring ); FileInText->Text = test; //This gives a compiler error, How do I make it work //FileInText is the textbox... FileInText->Text = ...Show All

• Windows Forms How to do query if a property/method is supported by the object?

  Thanks Add the System.Reflection namespace, then use <object>.GetType().GetProperties() and .GetMethods() to retrieve PropertyInfo and MethodInfo information. There are binding options to help you get what you want. Steve ...Show All

• Visual Basic VB filling a list box with data

  I have a listbox and in the form load I need to add code that will fill it up with items in my dataset listbox = dataadapter.fill(dataset) is not working DataAdapter.fill returns an integer. You probably want something like:      dataadapter.fill(dataset)      listBox.DataSource = dataset.Tables("Table")      listBox1.DisplayMember = "<fieldNa ...Show All

• Visual Studio Express Editions Build/Version text formatting?

  I'm experimenting with splash screens. The default splash screen item from VB Express has a label for version information. What are the formatting options/syntax possibilities for that label when specifying the build information of your application I'm confused as to why the revision information is ignored. Look at the code for the splash screen: you can format anything any which way you like. The sp ...Show All

• SQL Server Bulk Insert from Mapped Network Drive

  Hi, I am trying to perform bulk insert using mapped network drive, but getting following error: Server: Msg 4861, Level 16, State 1, Line 1 Could not bulk insert because file ' F:\Download\MVY.b45 ' could not be opened. Operating system error code 5(Access is denied.). F is mapped network drive pointing to my SQL Database Server. While searching, i got the following link but not able to relate with my problem: http://support.microsoft.c ...Show All

• SQL Server How do I create a variable in a view

  Hello, We have a need to create a variable within a View. We tried declaring our variable like we would in a stored procedure, but that doesn't seem to work. What is the proper way to do this Thank you. Kay Hi, you can’t create a variable in a view. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Basic Version checking routine. Looking for input.

  Good Morning!      This is my current routine to go out to a website and retrive the current verison avalible or my application. It works to some degree. Issues: 1: I get  a minorBuild in the verison at:       Dim version1 As New Version(VerMajor, VerMinor, VerBuild, VerRevision) 2: There has to be an easier method to accomplish this.. -----sample code--- Private Sub CheckForUpda ...Show All

• .NET Development retrieve email from pop server

  can any one help me to know lf there is in c# methods or class for retrieve the email from pop server ,now i can retrive email but whith down level (using the bases commands whitch difficult); Folloging blogpost could be also helpful: http://blog.rebex.net/news/archive/2007/05/14/howto-download-emails-from-gmail-account-in-csharp.aspx ...Show All