Jose Rocco's Q&A profile

• SQL Server Beginner question Searching table

  I have a stored procedure that takes 5 parameters. Based on what parameters are passed i want to return a result set to the calling code. Not all of the parameters are required so there will be some combinations on the entered parameters. Do i need to dynamic build the query with the IF statements to check if the input parameter is NULL or not Thanks You can use the isnull function like so: -- Using the northwind database in sql server 2k declare @categoryname varchar(100) declare @categoryID varchar(100) --set @categoryname = 'Produce' set @CategoryID = 4 select * from categories  where is ...Show All

• Visual C# Read-only wrappers for derived classes

  Can anyone point me to a good method for implementing read-only wrappers around a derived class rather than, for example, a simple collection What I mean is that I have class A which inherits from class B. B is not abstract, so can and will be instantiated on its own. I need to be able to create read-only versions of A and B. The only way I've come up is to have a class ReadOnlyB : B, blocking writes and forwarding reads. That's fine. But for A, if I implement a class ReadOnlyA : A, it has to override not just the members of A, but those of B as well - not nice, especially in a hierarchy 3 or 4 deep. Got to be a better way Thanks. Dou ...Show All

• Smart Device Development Making a telephone dial in Pocket PC 2003 SE using C# 2.0

  Hi. How can I make a telephone dial in Pocket PC 2003SE Phone Edition In Pocket PC 2005, the Microsoft.WindowsMobile.Telephony.Phone -class is used to start a dial. But when creating Pocket PC 2003 project, i cannot add a reference to that namespace. Can someone provide me some examples how to start a dial in PPC2003 And another question, is there a way to programmatically determine (using C# or P/Invoke) if the Pocket PC is a Phone Edition device Antti Karhu On phone devices prior to WM5.0 you can P/Invoke the phoneMakeCall API method there is an example here:- http://mobilizedsoftware.com/blog/archi ...Show All

• SQL Server How can i pass GUID as sqlreport input paramater?

  Hi, How can I pass GUID as sqlreport Input parameter I get the following error - "Failed to convert parameter value from a String to a Guid. (System.Data)" I also tried passing guid within the curly braces but of now use. Please help! Ashu Try creating a ReportParameter object and then storing the GUID, as a string, inside this parameter. Example: Microsoft.Reporting.Winforms.ReportParameter tempParameter = new Microsoft.Reporting.Winforms.ReportParameter(); tempParameter = new Microsoft.Reporting.Winforms.ReportParameter("ID", GUID.ToString()); Finally, pass this ReportParameter object to ...Show All

• Architecture Are interfaces for behavioral overloading only?

  This question comes from the new approaches being suggested when designing services with WCF and even ASMX 2. The approach is one that uses interfaces (or abstract classes) to focus on the method signatures and avoid diving directly into implementation when desiging services. This looks like a half-way contract first approach that is meant to help developers focus on what makes a service reusable (strong typing, message orientation, explicit method naming, etc...). Ok now my question is does this then take the concept of interface inheritance and cloudy it some. I personally favor the idea but I have a hard time convincing the OO guys tha ...Show All

• Windows Forms Visual Styles documentation

  I would like to the use the XP Visual styles (UxTheme.dll) for custom controls and can't find any documentation that tells me about the contents of the dll.  I've found bootstrap documentation and the Genghis code, that help me access what's available to buttons, but I'm unable guess what else is there (menu, listview, ...).  I've looked inside the&nbs ...Show All

• SQL Server RowGuid

  Hi What impact is there in setting a unqiueidentifier primary key to be a row guid How does this impact performance How does this impact data file size Does it impact anything else Thanks Hi, I guess you don’t want to open up taht religious discussion, right There were many, many, many discussions already about this out there which can be find googling / MSNning around: http://www.google.de/search hl=de&q=GUID+Primary+Key&meta = There are really many opinions out there, for me (for my personal opinion) you should avoid them, as long as you don’t really need the ...Show All

• .NET Development OnLoad or some initialization for webservices

  I expose a few webmethods. I wish to pre-initialize data BEFORE anyone calls the webmethods. Some initialization needs to be done, some stuff thrown in cache, etc. In a Windows app, I have OnLoad, in a website I have Application_Start in the Global.asax but what can one do when JUST webmethods. Is there some other 'place' I can initialize my data BEFORE any webmethods are called you do know that IIS and .Net may re-cycle your app many times a day I do not think your code will be run at all untill a request comes in. so perhaps you are looking at this the wrong way ...Show All

• Windows Forms ADO.net Connection Error

      I am unable to register a SQL Server in Studio.net. I am SA on my SQL Server. However, when I attempt to register the server I get a DBNETLib (Connection Open) error.  I need this to do some ADO.net with my Windows Form.      I don't see how it can be permissions. I have Enterprise Manager installed and can h ...Show All

• Visual Studio Team System VSTS Methodology Template for Extreme Programming

  Hi,   **** INITIAL VERSION OF TEMPLATE AVAILABLE NOW ***** I've setup a project to develop a VSTS Methodology Template for Extreme Programming http://workspaces.gotdotnet.com/bsdagile  Any offers of help or info about similar projects gratefully received. Will I've already downloaded the MSF for Agile Software Development - Beta 2 PT which is later than the one supplied with Beta II (April 05) as well as the VSTS Extensibility Kit Beta 2. Is there anything more that I should look at The problems I have at present are: 1. Resolving the licence / copyright issues regarding exporting the MSF Agile MethodologyTemplate, adapting ...Show All

• Visual Basic Help needed for beginner

  I am writing a program, of which part is to copy all files, folders and subfolders from a provided source location to destination. When I run the code as shown below, if there are more than 2 subfolders in depth, or the source is on a CD then I recieve the following error: "An unhandled exception of type 'System.UnauthorizedAccessException' occurred in mscorlib.dll." "Additional information: Access to the path 'C:\New Folder\Autorun.inf' is denied" I do have NTFS permissions to the folder and I am the local admin. Does anyone know why this is happening   strsrc is D:\ (a win2k cd) and strdest is C:\new folder. I hope some ...Show All

• Visual C# call constructor of base class

  hi! What's the correct syntax to call the constructor of the base class of a class Take a look at the following example. I want myClass1 to have a parameter-less contstructor which will call the constructor of myClass2 passing a hard-coded parameter value. What should I write in place of the question marks public class myClass1: myClass2 {     public myClass1     {            } } public class myClass2 P {     public myClass2 ( int myParam)     {     } }   Hi, You would need the contructor to also ...Show All

• Windows Forms sending FTP command to get file list

    hello When recieving a File list from a remote server, is there any way to differentiate files from directories in the list. If not, what would be the best way This is the code I'm using: Public Function GetFileList( ByVal sMask As String ) As String () Dim cSocket As Socket Dim bytes As Int32 Dim seperator As Char = ControlChars.Lf Dim mess() As String Dim sItem As String Dim str As String m_sMes = "" 'Check to see if you are logged on to the FTP server. If ( Not (m_bLoggedIn)) Then Login() End If   cSocket = CreateDataSocket() 'Send an FTP comman ...Show All

• Windows Forms Thread::Sleep question

  Hello, I've got a question about the Thread::Sleep command. I have a code which goes like so: private: System::Void button2_Click(System::Object^  sender, System::EventArgs^  e)          {              System::ComponentModel::ComponentResourceManager^  resources = gcnew System::ComponentModel::ComponentResourceManager(Form1::typeid);              this->pictureBox5->BackgroundImage = (cli::safe_cast<System::Drawing::Image^  >(resources->GetObject(L"Spin2")));   & ...Show All

• Visual Studio Visual Studio/VSS Problems

  Dear Frenz, Can anyone solve my issues, Kindly help. VISUAL STUDIO/VISUAL SOURCE SAFE ISSUES Below are the scenarios we identified from VSS: Sometimes when we open Project from Visual Basic (located in VSS), it is showing “ Failed to load project ” Error. After modifying the code in Visual Basic, If we try to check-in multiple forms at-a-time, It checks-in the forms perfectly. After checking-in, it is allowing us to edit the form again. When we close the VB and open the application again, it is working fine. This happens only when we try to check-in multiple forms. The ASP pages are not checking-in some ...Show All