Mary Lindholm's Q&A profile

• Visual C# Database Connection String

  I am new to C# and VS2005 and am creating a large project which connects to SQL Server using numerous table adapters. I would like to be able to organize my code so that when I am building the project in Debug mode the table adapters use a given connection string. Then when I'm building in Release mode, the table adapters use a different connection string. I am looking for solution that only takes a few lines of code. I am aware of ... #if DEBUG ...connection string #else ...another connection string #end However, the table adapters use the connection string which is part of the application settings a ...Show All

• .NET Development more socket questions

  i am working on a server application that acts as a proxy between multiple clients and another server.  the destination server has 1 to many ports open on which is listens for "transactions" from my proxy server.  the way i had envisioned the proxy server working is to check to see if a port is free on the destination server and execute the transaction (send, and wait for response).  if the port is "busy", check the next port.  if its available, execute the transaction. if not, check the next port... i'm running into a problem where: 1) if i don't bind the port and simply connect, then the proxy server thinks all of the ...Show All

• SQL Server SqlDeveloper/SqlExpress Conflict.

  Hi, Background: I'm on a Pentium 2.4 with 1024 mb Memory and 160 Gb harddrive, running XPPro with SP2. I started a project in VS2005Beta2 with Sql2005Beta. When the RTM versions came along I ungraded to VS2005Pro, and tried to upgrade the SqlDeveloper. This ran amuck, but I could still access my database, so after three attempts I gave up temporarily. When it looked as if I was actually going to finish my project, I decided to sort out my Sql. Still had the same problems, but found the Cleanup Utility, which did a great job of cleaning up the residual stuff in the registry. I downloaded SqlDeveloper, and ended up with file reference ...Show All

• .NET Development System.ComponentModel.Component.Process is NotInheritable?

  Obviously no, because this code is allowed: Public NotInheritable Class MyProcess Inherits Process End Class But, when I try this: Dim p As MyProcess = CType (Process.GetCurrentProcess, MyProcess) Allways produces this error: 'System.InvalidCastException' , casting not valid Could some one explain Why Thanks a lot! flashdata Process.GetCurrentProcess always returns an object of type Process, not of type MyProcess. There's no way that Process.GetCurrentProcess can know that you have a class inherited from Process and to create an object of ...Show All

• Visual Basic Weekend Rates

  Hi, I would like to be able to change the backcolor of a textbox to depict whether the current day is a weekday or weekend eg If current day is a weekday then TextBox1.BackColor = Color.Green else TextBox1.BackColor = Color.Red Can anyone tell me the best way to achieve the above Very Best Regards, Jae your syntax formatting is not correct and you must assign a value to your date: Private Sub Button10_Click( ByVal sender As System. Object , ByVal e As System.EventArgs) Dim d As DateTime=Now If (d.DayOfWeek = DayOfWeek.Saturday) Or (d.DayOfWeek = DayOfWeek.Sunday ) Then  & ...Show All

• .NET Development Problem with AutoNumber key column

  Hi, I'm using dataGridView in VS 2005 environment. And I observed that the AutoNumber key columns increments the number whenever I sort on the grid. Scenario to reproduce the problem is: -bind the grid with 'Employee' table.(EmployeeID column is Primary key and it's AutoNumber) -Sort on the gird. Observe: EmployeeID column displays different number at each time when we sort the grid. Any idea about this Any comment is appretiated. Thanks. Julia168 Could not reproduce. Tested against SQL Server Employees table and Microsoft Access Employees table. Perhaps you have so ...Show All

• .NET Development TableAdapters/XSD Schemas/XPath Query and the Update Function

  I am starting a new thread as I have not seen in other threads people using the same combination of technologies. I have been working on this problem for the last 2 weeks and am completely stumped!!!! Here is the scenario: I am having problems with SqlXmlAdapter.Update.  I am running Visual Basic Express 2005 and SQL Server Express 2005. Here is the code that does not work...  I hope this is enough to work with... ____________________________________________________________________________________________ Dim mvarConnection as String = "Provider=SQLOLEDB;Server=" & sqlServer & ";database=" & sqlDatabase & ";user ...Show All

• Visual Studio Express Editions How to connect two tracking bars and a data table?

  Hi! Me again, with my next "small" problem. I have a SQL database table, with two primary key coulums. In my application I would like to use two slide bars (each of them to be bind to one of the DB coulums), to select the data to be displayed on the form. Can someone help me on this issue Thanx! hi. Is your problem solved could you be more clear in your problem definition Thank you, Bhanu. ...Show All

• Windows Forms The property 'ClientID' on type 'System.Web.UI.Control' cannot be serialized

  I am trying to serialize a web control and get the following error:- The property 'ClientID' on type 'System.Web.UI.Control' cannot be serialized because it is decorated with declarative security permission attributes. Consider using imperative asserts or demands in the property accessors.  [Serializable] public class WebForm1 : System.Web.UI.Page {     protected System.Web.UI.WebControls.Label Label1 ...Show All

• Software Development for Windows Vista Vista Build 5342

  Hi. I'm running my AMD64 3300+ with XP Home. I've been MSN-invited to Beta test Vista and have d/l'd Vista_5342_64bit_Main_Staged_DVD_EN.iso at 3.56 Gb. When I click on the downloaded folder, it becomes a winrar archive that only extracts to a readme.txt folder that states "this disc contains a "UDF" file system and requires an operating system that supports the ISO-13346 'UDF' file system". As you might surmise, I can't install the program. I've tried burning it to a dvd but that doesn't help. Any suggestions will be greatly appreciated..thanx! Don't open it with WinRar. Either&nb ...Show All

• SQL Server Help: Append Parameters in ASP classic

  Hi, Please tell me what is wrong in the following code to get the RecordSet by calling the Stored Procedure . '============================================== Dim StaffRS, objComm, objParam1, objParam2, objParam3 'Set RecordSet, ADODB.Command Set StaffRs = Server .CreateObject("ADODB.RECORDSET") Set objComm = Server.CreateObject("ADODB.Command") objComm.ActiveConnection = conn 'conn was set earler objComm.CommandText = "GetStaffReport" 'Stored Procedure objComm.CommandType = adCmdStoredProc '**Error line** 'Append Parameters set objParam1 = objcomm.CreateParameter ("People_ID", adVarChar, adParamInpu ...Show All

• Visual C++ VC equivalent of dirent

  I'm porting some code from another environment which defined an dirent.h and had an dirent structure which was used with opendir/readdir/closedir functions...  What is the VC equivalent to these functions, as VC doesn't have the dirent.h, dirent struct and/or the opendir/readdir/closedir functions (or at least I'm not able to find them in the help or in the directories). Thanks, George >Anyway, there's no reason for a compiler to have dirent.h if it's not in the C standard. Its in X/Open; The Open Group Base Specifications Issue 6 IEEE Std 1003.1, 2004 Edition. http://www.opengroup.org/onlinepubs/009695399/nframe.html . ...Show All

• SQL Server SQL Server 2005, SQL Server 2000 Side-by-Side Installation on the same server

  I am planning on installing SQL Server 2005 first and then install SQL Server 2000 as a separate instance on the same server. Has anyone had any experience with this setup When I ran the SQL 2000 set up it didn't force me to create a new instance but I still did. I also installed the files on different directories c:\program files\ just in case. If you have any experience of ideas about this configuration, please let us know. Thanks. If you install SQL 2000 after SQL 2005, you can hit problems during installation. It's always better to install SQL 2000 first, then SQL 2005. If you don't have any problems, ...Show All

• SQL Server SmoApplication.EnumAvailableSqlServers does not list default instance if sqlexpress is in same machine

  Hi, I have installed sql server 2005 as default instance and sqlexpress in a machine named "mani" EnumAvailableSqlServers  does not list the default instance. It lists only "mani\SQLEXPRESS", but not the "mani".  But I can see both in SQL Server Management Studio Any idea fix it Regards mani This is a known problem, unfortunately this is not expected to be fixed until the next release.  This problem existed in SQL Server 2000 also.   Peter ...Show All

• .NET Development 'Attaching' to a web service is very slow on first time

  I have a project that uses a Web service via Web References (VS2005 and .NET 2) The line service = new webservicename.serviceclass(); where webservicebame = name of web service and service class is a public class of all the 'routines' that can be accessed. (Subsequent code uses this 'service' to actually call the web service) The first time the line of code is processed it takes over 50 seconds. Subsequent calls are instantaneous. (Rerunning the application subsequently can be instantaneous, although after a number of minutes (which can be as little as 10 and sometimes > 1hour the 50 second delay returns) The same code in V ...Show All