Answer Questions

• Horea Soanca Parameterized SQL query for a GridView or DetailsView in Visual Studio 2005 Web Developer

  I'm using Visual Studio 2005 Web Developer with a SQL DB. I'm building a basic ASP.NET 2.0 website that allows entering, editing and viewing records stored in a SQL DB table. The website will be used in a local network and hence Windows authentication is being used. WHAT I DID: I dragged a GridView control from the toolbox menu and configured the Data Source so that the GridView displays ALL records from the SQL table. WHAT I'M TRYING TO DO: My goal is it to display the data records in the GridView depending on the respective user's Windows login credentials, so that only specific records are being displayed. I assume I have to use a parameterized query with the parameter being the Windows Login credentials. However, I don't kn ...Show All

• shafiqm dataset throwing arithmetic exception

  I have a function that is throwing an arithmetic exception when I try to store a 10 digit number. I checked the database, the field is set to bigint and I can enter the number manually without any problems. I also tested the stored procedure I use to insert the data and it too will accept the number without any problems. However, when I use the data table's add row method I get an arithmetic exception. The field in the dataset is set to System.Int64. I am lost as to what may be causing this. Any help would be greatly appreciated. thanks, Luis Here is the source code I'm using. Basically I get a DirectoryInfo or FileInfo object and pass some of the values to a database table in memory Private Sub AddFileTo ...Show All

• NickNotYet How to close a TCP connection?

  I used netstat /a and found the socket port I need is already used by a trivial application. How do I write a C# program to programmingatically close down the socket port Any idea is greatly welcome. I will grade your answer. Please help. THanks thanks for the reply. but i don't see how is that relevant to my question. Well , i haven’t done that, but it sounds interesting, so i looked for it on the internet, and found this: http://www.csharphelp.com/archives3/archive486.html i didn't read all the article, but has a lot about sockets connections, i hope it helps you ...by the way, if you find the solution you are looking for, reply the message so we can all ...Show All

• Ted Rob replacing Thread.Sleep and Thread.Resume

  hrm... second post. dunno what happened to the first. how might I go about replacing the functionality of Thread.Sleep and Thread.Resume Using Suspend/Resume is bad design when you're trying to syncrhonize between threads. It does not look that's what you're really doing here, though. You're just trying to suspend the thread's execution temporarily so that you can capture information about its call stack. I think this may be the only way you can really do this, in fact, if the thread you are capturing is running arbitrary code. I would modify the code to use a try/finally block, however. There is a pragma you can use to override the warning the compiler makes, though I don't remember what it is off-hand. ...Show All

• Michael Herman - Parallelspace How to use xslt to read multiple (directory full) xml files and generate one output file.

  G'day, I've got an Vb.2005 windows forms xml based application that generates and consumes XML files. So far I've uses XSLT files to transform those xml files in a one xml file to one output file senario. XSLT is painful to write, but eventually I get a solution. I'm completely stuck on how to use multiple xml files, ( for example all the files in a directory) to then generate one output file via xslt. I know I've got to use the Select="Document( )" and or some variables but I can't seem to get a good example that doesn't rely on another xml file to provide the paths to those documents. Eg. Nunit 2.2 has an xml results file formated the following way, and I want to read the results of my nightly unit tests results and p ...Show All

• DtD exception streamwriter.writeline

  Hi all, i dont know why this exception occurs can some body throw light tia sahridhayan i checked the following, but still error occurs 1. i checked whether the string value is null or empty string, if so i add a default "NO message" 2. i am doing a concatenation of System.Environment.NewLine inside my logger code is below. wSW.Write(message + System. Environment .NewLine); Message: Server was unable to process request. ---> System.ArguementOutofRangeException Count cannot be less than zero. Parameter name: count at System.String.CopyTo(Int32 sourceIndex,Char[] destination,Int32 destinationIndex,Int32 Count) at System.IO.StreamWriter.WriteLine(String value) at SI.Logger.Web ...Show All

• sql server2000 How to add a SOAP header to a SOAP meesage?

  Hi From a VB.NET client i call a (non .NET) webservice using a given WSDL file. To this message i want to add an Header element with a certain value. I got some example code in JAVA, but do not know hwer and how to inplement, // Construct the header QName headerName = new QName(" http://ech.client.nl/vendor ", "Vendor"); SOAPHeaderElement headerElement = new SOAPHeaderElement(headerName); headerElement.setValue("ECH Gui"); headerElement.setMustUnderstand(true); try { Message message = arg0.getCurrentMessage(); message.getSOAPHeader().addChildElement(headerElement); } catch The headerelement must have th ...Show All

• Aleniko29139 Webservice: "The ASP.NET process identity does not have read permissions to the global assembly cache."

  I'm uncertain what the best forum is for this - I also posted this in the ASP forum. I am developing a distributed application with a client-side java calling a webservice serving a static binary database. The application works well with the VS2005 Development server on XP Pro SP2. However when I publish it to an IIS v5 environment, it fails with these errors.   3.)    .aspnet_wp.exe (PID: 3988) stopped unexpectedly 2.)  Failed to execute the request because the ASP.NET process identity does not have read permissions to the global assembly cache. Error: 0x80131902 1.) Failed to initialize the AppDomain:/LM/W3SVC/1/Root Exception: System.Configuration.ConfigurationErrorsException Message: Exception ...Show All

• NickNotYet Deleting a single row from related tables

  Hi, I have 3 related tables. First one is the parent and the other two are children of the first one. Ican navigate through parent and its children using DataGridViews and relations. When I delete a single row from my parent table I want to delete only its children not all the deleted rows in child tables. When I use DataTable.GetChanges() and try to iterate through its rows checking if the row's foreign key matches to the parent row's primary key I have an exception saying "you can not access a property of any 'deleted' row" which forces me to delete all deleted rows from each child table. How can I get the deleted rows that belong to my parent row Thanks for any help. Not a professional solution but I must a ...Show All

• Alex Yakhnin - MSFT Getting xsi:nil’s on array items which are null instances

  Hello, i have two DTO-classes (Data Transfer Objects) A and B. Class A contains a member which is an array of Class B instances. I have to pass class A to an Java-WebService. The Encoding of the Java-WebService is RpcEncoded. So my WebService-Client has SoapRpcMethodAttribute’s on each method. This works so far. The problem is, when i have null references in the array (~of Class B instances), i always get for them xsi:nil’s in my SOAP-message like you can see below - never mind what Attributes i set on the property in Class A (the name of the property is "infos"). These are the relevant lines of the SOAP-message: .. <infos href="#id2" /> .. <soapenc:Array id="id2" soapenc:arrayType="tns:B[5]"> <Item xsi:nil="true" /> ...Show All

• P Cause Keep transaction in nested Web Services

  Is it possible to have transactions when calling a Web Service, which in turns call another Web Service I have only seen transactions when calling one single Web Service. How could this be configured Do I need some more settings Best regards Niklas Engfelt You can use System.Transactions for that. Wrap your services calls into a: using (TransactionScope tx = new TransactionScope()) { .... } ...Show All

• Bigteddy MSHTML problems.

  I wrote a program that crawls a particular webpage using mshtml.dll and interop.shdocvw.dll. It creates a web browser object and then navigates through a couple pages. It works on my computer and most other newer computers that I try it on, but on some computers it crashes near where it uses the web browser object. It crashes on a computer that is running XP, .NET 2.0, and IE 6.029. All of those specs are the same as on my dev computer (which it works on). I also include the shdocvw.dll with the program when I give it to people to try. Does anyone have any idea what is missing which is causing it to crash Copy the mshtml.dll in same location where exe resides. In your machine the dll is GAC, but not in a ...Show All

• lucerias System.Configuration.ApplicationSettings with DataContracts

  Hi all, is it possible to use ApplicationSettings together with data contracts If yes, how to configure the data contract serializer for the settings class Ciao ThomasD Do you want to use the datacontract serializer to store your settings locally (and replace the default typeconverter.To/FromString or the XmlSerializer) or do you want to pass the settings class over the wire Best regards, Johan Stenberg I've got an own provider, which persists the data in ADAM. Several clients may share a "central" configuration. In order to be prepared for versioning issues I want to use data contracts for my settings and therefore need to use the data contract serializer. ...Show All

• Always Learning Multiple assemblies -- Single version

  Hi, I have several assemblies that I need kept separate. I would however like to have all of them share the same version number. I already tried "sharing" a file with AssemblyInfo in it between them but that worked badly. Any ideas Using team foundation here I tried exactly what you suggested. As soon as I add the 'common' file to any of my projects they copy it to the local folder. That behavior surprised me so I double checked, unless I was missing something that's how it behaves. Even worse, we're using team system, and as far as I could tell there is no way to 'share' a file the same way we shared one on VSS. I dunno, it might be quirk/feature of your source control system.... Doesn't that &quo ...Show All

• giancolaj DateTime.TryParse generates an Exception

  Hi, few days ago I had to reinstall my machine but, after it, I started to have problems with the DateTime.TryParse method: it throws an exception of type IndexOutOfRangeException.. This simple example: private void TestParseDate( string strDate) { DateTime date ; bool b = DateTime .TryParse(strDate, out date); // here the Exception is throwed } generates: System.IndexOutOfRangeException was unhandled by user code Message="Index was outside the bounds of the array." Source="mscorlib" StackTrace: at System.Globalization.DateTimeFormatInfo.InsertHash(TokenHashValue[] hashTable, String str, TokenType tokenType, Int32 tokenValue) at System.Globalization.DateTimeFormatInfo.CreateTokenHashTable() ...Show All