Answer Questions

• Syed Hasnain Ali inline query vrs sqlcommand duration

  Hi, I am migrating a client-server application to a N-tier using webservices. Now client connect to the server using webservices which execute queries to a SQL Server 2000 database. The old application was using inline queries (" WHERE CustomerId = '" + customerId +"'";.... Now I am using SqlCommands but I have detected a real slow down in the performance, running a query that retrieves 7000 records for example it takes ...Show All

• joelm9898 Error: SQL Server does not exist or access denied

  I am a newbie so any help appreciated. the ASP.NET web application is on a seperate machine than the machine that runs the SQL Server. There are 3 SQL Servers running on machine that has my database. The 3 SQL Servers are: SQLM1\DevSQL SQLM1\DemoSQL SQLM1\QASQL where SQLM1 is the machine name & QASQL is the name of the SQL Server. The database that this application connects to is in SQLM1\QASQL. In the default.apx.vb, I have a connection str ...Show All

• Steve Christe XmlException: "Name cannot begin with the '.' character"

  Hello, My application loads XML file and updates its content. The steps are: 1. XmlDocument m_doc = new XmlDocument(); 2. m_doc.Load("c:\\inetpub\\wwwroot\\folder\\data.config"); 3. making updates to the file attributes 4. XmlTextWriter wrtr = new XmlTextWriter(filePath, Encoding.Unicode); 5. this.m_doc.WriteTo(wrtr); 6. wrtr.Flush(); 7. wrtr.Close(); After performing these stemps once, and trying to load again the file (step ...Show All

• Robert Schneider How to install Jscript in VS 2005?

  We want to evalute Jscript support in .Net 2.0, but after install C#/C++ options of Visual Studio 2005 Professional Edition, we can't run  sample code  in MSDN, using Microsoft.JScript; ... we got the fowlling error message: The type or namespace name 'JScript' does not exist in the namespace 'Microsoft' (are you missing an assembly reference ) Do we need to install J# or VB to support Jscript or other seperate package Thanks in a ...Show All

• Umberto Connecting to MSQL db

  Newby Here I am trying to set up a little form (on a Windows Form, using C#) I am trying to work it out, so for testing I created on the Form. 2 TextBox's and a Button What I want to happen, is someone types something in one text box, press submit, then the 2nd textbox will show the result from the MSQL table (mini Search Function) So far I have Added, under referenced System.Data.SqlClient then on the top of the form1.cs page (Code Section) I ...Show All

• splashup How to know when a file is locked by another process?

  Hi there! Is there a function to know when a file is locked/blocked by another process The only way I know is to open the file in exclusive mode, and it’s locked if it raises a error, but I don’t think that’s a good way. Thx Another, but a bit tricky solution is enumerate processes and file hanlde that keep your file. See sysinternals.com and their processExlorer. But u need to use pinvoke for this reason. But I think ...Show All

• Tvercel fuslogvw not working?

  I seem to be having trouble getting fuslogvw to show any binding information. I've got a problem with a Satellite resource which in .net 1.1 I'd normally use fuslogvw to help me, but in 2.0 its always blank. I've set it to log failed binds to disk and changed the custom location to the root of C: but still nothing. Any ideas Use custom path instead of default at log location.. Still no joy from websites If you've got ...Show All

• DmitryB Xml serialization--strange character in output

  I am experiencing a weird issue whereby I am serializing an object to an xml string to store in a database--so rather than serializing to a file I am storing the output in a MemoryStream and then converting the byte array to a string using the Utf8Encoding class. See below:   /// <summary> /// Performs custom serialization and deserialization of business objects. /// </summary> public sealed class ...Show All

• PedroSimao Database Or XMl Driven object

  I would like to create databas/XMl driven object. For example if I need a Address object, I will declare Name,City,State as properties in XMl(or DB).and at run time my application should be able to genereate Address object and should be able to link Property Object ( could be another xml driven object ).And also user should be able to Add/delete/modify properties and assign values to the properties and save the object state.   Can any ...Show All

• Dan appSettings, where do they save?

  I have a windows forms application. (Visual Studio 2005) A simple form with a button on it. Here is the code private void btnTestButton_Click(object sender, EventArgs e) { ConfigurationManager.AppSettings["TestSetting"] = "TestValue"; string res = ConfigurationManager.AppSettings["TestSetting"]; MessageBox.Show(res); } I step through the program in debugging mode. The MessageBox shows ...Show All

• TScott Where's the Web dev forum?

  Like the title says... where's the Web dev forum for us ASP.NET monkeys Is this a sign that Microsoft newsgroup forum may move to here   CommunityServer latest release also has a module to connect NNTP for newsgroup posting/reading.  Wonder why Telligent folks were putting effort in it, that it may be. I agree. The telligent folks have said that they run the as ...Show All

• Matt Lambert ADO.Net cannot connect to Access database

  I have a VB .Net Windows application that accesses an Access Database using ADO.Net OleDB .Net Data provider.  It works fine on user's PC who have MS Access installed. However, when I distribute this to a user who does not have MS Access installed, the program cannot open the connection.  It throws an exception with message: No error information available.  Ox800401F9. Are there additional files that I need to include in ...Show All

• Jack Davis strongly typed dataset

  Hi, The following line populates a datagrid using a strongly typed dataset. dsEmps is the .xsd file in the foreach line I would like to loop through each record I get an error on the foreach line and it says: specified cast is not valid I think this line has to be somehow casted employeeDetailsData.Employees.Rows EmpBusRule.EmpService.dsEmps employeeDetailsData; EmpBusRule.Employees br = new EmpBusRule.Employees(); employeeDetailsData = ...Show All

• ARMYVET Fatal error while running managed Directx game on .net 2.0

  The error goes as following: FatalExecutionEngineError was detected Message: The runtime has encountered a fatal error. The address of the error was at 0x79fce5c2, on thread 0xd34. The error code is 0xc0000005. This error may be a bug in the CLR or in the unsafe or non-verifiable portions of user code. Common sources of this bug include user marshaling errors for COM-interop or PInvoke, which may corrupt the stack. The source of this error is u ...Show All

• chris.p Enterprise Library 2006 Error when referenced from GAC

  I get an error when trying to execute this code referencing Microsoft.Practices.EnterpriseLibrary.Data from the GAC, but it works if I reference the assembly locally from the bin directory: Database db = DatabaseFactory .CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand( "storedproc" ); db.AddInParameter(dbCommand, "@ID" , DbType .Int32, "2" ); DataSet ds = db.ExecuteDataSet(dbComm ...Show All