StarCad's Q&A profile

• .NET Development Regular expressions: exclude a character from a set.

  Is there a way to exclude a specific character from a set like [A-Z] or [0-9] For example, suppose I want to exclude 'D' from [A-Z], I could write [A-CE-Z]. But that syntax doesn't suit my scenario very well. Isn't there any other syntax for this Hello Becko, In order to match A-Z excluding 'D' the correct expression is [A-CE-Z]. Likewise to match 0-9 excluding '5' the expression is [0-46-9]. If the [A-CE-Z] syntax does not suit your scenario very well, you could use two regular expressions instead. First match [A-Z] and then check the match.Value for the presence of "D" (with or the absence o ...Show All

• SQL Server Remote Connection to file-based Express DB

  Hi, This might be obvious - but if so I've missed it so far. Is it possible to connect remotely to an Express database used in a website which is created in the App_Data folder by VWDEE 2005 and attached by filename As far as I can tell these databases don't have a name and aren't mounted until an attempt is made to access them. I certainly can't see any sign of it in SQL Management Studio. Thanks, Dale Hi Dale, SQL Express only connects to local files; you can't connect as you suggest. Regards, Mike Wachal SQL Express team ...Show All

• .NET Development error: oledbexception nust declare the variable '@Eff_Date'

  Here is the code in my Load event after declaring cn, da and cm cn.ConnectionString = "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=matrix;Integrated Security=SSPI;" cm = New OleDbCommand("select * from lk_Feat", cn) cm.Connection = cn da.SelectCommand = cm cm = New OleDbCommand("UPDATE Lk_Feat SET Eff_Date=@Eff_Date , Exp_Date = @Exp_Date ......etc. .., cn) cm.Parameters.Add("@Eff_Date",System.Data.OleDb.OleDbType.Date,8, ''Eff_Date'') cm.Parameters.Add("@Exp_Date",System.Data.OleDb.OleDbType.Date,8, ''Exp_Date'') ........and all other f ...Show All

• SQL Server SUM problem in SSRS 2005 report

  I don't know how best to explain this but will try. In my SSRS 2005 report, i have one group in my table.  In that group, I have a field that for each company record in my dataset, this field value is repeated for each record. This is a transactions table so you'd expect several records in the dataset for each company..that's not the problem. example data from dataset: TransID     CompanyID      FeeGoal 1                1000               ...Show All

• Visual C# Generics and Polymorphism

  Hey Everyone I need a little help with Generics and I am hoping one of you will be able to help me. I am wondering if you can a List<baseclass> if I can add derived types to the list. For example: public class Shape { public string Name; } public class Triangle:Shape public class Circle:Shape List<Shape> shapes=new List<Shape>(); shapes.Add(new Triangle()); Would something like that work And would I be able to type cast it back out into its derived form Thanks MacKenzie Yes, your example it's perfectly valid including something like Triangle t = (Triangl ...Show All

• Visual Studio Tools for Office OPen Excel file to perform a VLOOKUP and close

  Hello VB Folks, and friends, I'd like to try to open an Excel spreadsheet which is a matrix table of fares. I need to perform a VLOOKUP on 2 parameters passed from 2 textboxes, or two lists. (one is coming from, and one is going to)... Then I need to close the file, and show the answer(result) in another textbox. Is this something that can be done without buying Visual Tools For Office Thanks...I hope this is enough description for all of you. If not, say the word...any word! Elgee, In a few minutes, I'm going to move this to the VSTO Forum. (Visual Studio Tools for Office) ...Show All

• Software Development for Windows Vista problem installing vista ctp 5308 - how to build a boot disk ?

  Hi, I have a clean build windows XP machine that I am trying to install Vista CTP 5308 onto. I have downloaded the image and manage to burn to DVD but having entered the product key I get an error message "The procedure entry point DecodePointer could not be located in dynamic link library KERNAL 32.DLL." Any ideas how to resolve this Alternatively I'd like to simply build a boot disk with the image and run from scratch... but I don't know how to build a boot disk from the downloaded image Can Nero or Roxio do this for me Thanks Phil I am having the exact same problem, I h ...Show All

• Visual Studio Express Editions Build Error with PostBuild script

  It seems that regardless of what command I put into the Post-Build property of my project I get the error: 'C:\Documents' is not recognized as an internal or external command, operable program or batch file. The system cannot find the path specified. I've tried even simple things like "echo hello." and I get the same result. echo hello. 'C:\Documents' is not recognized as an internal or external command, operable program or batch file. The system cannot find the path specified. As an experiment, I created a C:\Documents.bat file, and sure enough, it gets executed just fine. I also get the s ...Show All

• SQL Server SqlCeRemoteDataAccess Pull issue with ConnectionString

  I'm getting an error when attempting to pull some data from my SQL Server 2005 database. It throwing an exception on my strSQLConn string with the following message (please replace <MyServer> with my actual server name: Failure to open SQL Server with given connect string. [ connect string = Data Source=<MyServer>;Initial Catalog=MobileParts;Integrated Security=True ] string localstrSQLConn = @"Data Source='\Program Files\CreateMobileTest\MobileParts.sdf';Password='';Max Database Size=128;Default Lock Escalation =100;" ; string InternetUrl = @"http://<MyServer>/zTestWebSite ...Show All

• .NET Development SmtpClient and mail server

  I need to be able to find the mail server that is default on the user's computer. How do I get mail server if they are using outlook or outlook express I'm creating an asp.net 2 app and I cannot hard code the mail server IP and I cannot use localhost as the mail server will not be on the local machine. Any ideas regards, Mark I'm not sure what you mean by the "default" mail server. Are you referring to a particular account setup in Outlook If so, you will need to look into the Outlook SDKs or VSTO. ...Show All

• Windows Forms How do you catch the delete event on a datagrid

  Hi All, I have a datagrid that works. When the user presses the delete button on their keyboard it seems to delete the row from the grid. How do I know what has been deleted from the grid so that I can actually remove it from my actual data. Is there an event I catch or can I compare the data in the grid with my data source. Please help, Danny PS. I am using VB.NET 2003 (C# answers are fine) The Data Grid View FAQ here should answer your question - http://www.windowsforms.net/Default.aspx tabindex=5&tabid=60 From the FAQ - "When the user selects a row in the DataGridView and hits the delete key, the UserDeletingRow event fires." ...Show All

• Windows Forms Passing a string to my form

  I want to start my windows application (exe file) from command prompt and pass for example a name string to the exe. How and where do I retrieve that string in my form code  I thought that I could just get it from the EventArgs variable in the Form_Load eventhandler, but that doesn't work. Can anybody help me do it in the m ...Show All

• Visual C++ Tracking Reference (%), value, ref??

  For a while now I have been reading the documentation, for Visual C++ 2005, in an attempt to migrate from native code to managed. I find it hard to understand how to use the different types, and what the equvivalent in native code is. Look at this code: ref class rc{}; value class vc{}; f1(rc^ c1){} f2(rc^% c1){} is rc^ myrc = gcnew rc; equvivalent to rc * myrcN = new rc; in native code And is " Handle to Object on Managed Heap " the same as " Pointer to Object " What is the difference of ref and value If i want a object on managed heap do I use the "ref" keyword, and value keyword if I want it on ...Show All

• Visual Basic Visual Basic 2.0

  Greetings. I use Visual Basic 2.0 to teach my kids a bit of programming. I do have Visual Studio Express - but it won't run on all my school PC's - while VisBas2 is small and quick!! BUT it doesn't have any help files . . . . I want to keep showing these kids good coding but I haven't found anything as small and quick as VisBas2 . . . . with helpfiles! Any and all suggestions gratefully accepted! Cheers, David Hi all! One of the KPL guys here - glad it's working well for you! Ackworth, it's not required - we're happy to just know you're using KPL - but if your school is willing to tell us ...Show All

• .NET Development How does the CLR get loaded?

  Hello everyone, I have a general question in the context of .NET frame work. In Java, you invoke the Java runtime by specifying c:> Java XXX.class on the command line. This basically gets the java virtual machine running and it executes the XXX.class by converting it to native machine code. Isn't the CLR in .NET frame work same as the Java virtial machine. If that is the case how does the CLR get invoked, meaning when I run a Assembly(.exe) generated from lets say Visual basic .NET, I only run the Assembly on the command line. so on  the command line I would say c:>MyProgram.exe How does the CLR get invoked, so th ...Show All