Answer Questions

• ZachSaw Lock a record by SQL Command

  Hi! I develope my windows application using VB.NET & SQL Server 2000. How may I lock a record in a table while updating by a system user, to prevent other users update or delete that record (Imagine that my database contains a table named 'myTable'. There is a form in my program running on a network, to edit the data of table 'myTable'. A user is going to update a record of table 'myTable'. I want to lock this record as loading in the editio ...Show All

• MarkDer DataAdapter/CmdBuilder problems

  I have a simple MDB with one table. The first column is the primary key (number.) I'm having a heck of a time updating. Using the CommandBuilder, I get: myDataAdapter.InsertCommand.CommandText INSERT INTO NewTable001 (ID, Name, DataType, Value, Comments) VALUES ( ,  , , , ) but the OleDbException error is "Syntax error in INSERT INTO statement." Here's the code  to update the data (bound to DataGridView): m_Conn = New Ol ...Show All

• tyther Problems with DataReader!!

  Hi, can someone please help my, I have experienced some realy weird stuff. This datareader hasn't been closed, but when I try to run the program, I get an error message, stating. "INVALID ATTEMPT TO READ WHILE READER IS CLOSED" Is their anyone that can see something in my code that I'm missing. Thank you. Or any suggestions Try Dim myreader As OleDb.OleDbDataReader Dim mycomm As New OleDb.OleDbC ...Show All

• Pierce Blaylock How to determine properties of a file on a web site

  I have a requirement of downloading a file from a web site to the local machine. I do this using the WebClient.DownloadFile method (from within a Windows Form application). I need to add a check which will determine the modified date of the file on the web site and compare it with the date of the file on the local machine. If both of them do not match, only then download the file. Does anyone know how to determine the modified date propert ...Show All

• Tom Heinzmann VB. NET decompiler

  Hello All, Is there utility availble to decompile: That is given a compiled VB.NET .exe, the utility would generate the .vb file with the source code Thanks Prashant H. K. Thanks philippe and ThE_lOtUs . I will try the reflector and see how it works. Thanks again. Thanks James. I tried reflector, and also found this on the web: http://www.remotesoft.com/salamander/ This als ...Show All

• Ravindra N <input type= file name=** Generated at run time

    In a function i have created Multiple BROWSE butttons "<input value=""browse"" style=""button"" type=""file"" name=""btnBrowse" + CStr (nPageId) + """>" now in second Function i want to access the filenames How to do that ButtonNames are like btnBrowse32 btnBrowse33 btnBrowse34 ..etc   Regards Sarika   This question is better suited for the ASP.NET forums than here.  This forum is for general ...Show All

• JaleelP Lookup

  I have two tables Dossier and Rolhand I'am trying to get the newest date from table rolhand into dossier. <-- Text in Red I'am using virutal field, but i can't get it to work. Table: Dossier * DOS_ID     Rol_id           Rol_date ------ -+--------------+------------ 1            05dak-91    &nb ...Show All

• Ebenezer Tham Populate C# Datagrid with XLS file

  Hi All, How do I allow a user import an XLS file into a Datagrid on a form in C#. Also, what is the proper syntax to add Columns on the fly Thank you, Paul This isn't a SQL Express question. Moving to .NET Data forum. Mike Start here: How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET http://support.microsoft.com/default.aspx scid=kb;EN- ...Show All

• SATISD9X Process.GetProcess() Issue

  I'm facing trick problem. I'm using Process.GetProcess( ) method to get all the process which are running in server. This code causes the application termination. If i want to get what kind security permission i have to set . Can any one help Regards Hi You are right. I also tried with admin group it's working fine. Now, As a non-admin i want to execute it. is there any other way. My requirement is to count the number instances of runnin ...Show All

• Shilnet error : R2304: Operation name overloading-webservice

  hi.. here is de error R2304: Operation name overloading .. i also tried with messagetype attribute like [ WebMethod (MessageName = "xxxxx" )] ... eventhough it occurs.. need solution immd.. thanks in advance.. When generating a schema for the SOAP messages, WebService Framework uses the [WebMethod] name as a top-level element name (wrapper element) and as name of the wsdl:operation in service ...Show All

• Bradpatt System.Threading.ReaderWriterLock acting screwy!

  I've got a class that uses a System.Threading.ReaderWriterLock . Hard to tell without seeing the code that calls ReaderWriterLock.AcquireWriterLock(). -- Peter ______ http://www.peterRitchie.com/SortableValueType.snippet The AcquireWriter code is implemented like this: void AcquireWriter() { rwLock.AcquireWriteLock(...); Interlocked.Increment(ref myWriteLockCount); } Peter, turns out you were right, bug in my code that ac ...Show All

• nagarajuch Convert XML into Pdf Format Using MSXML 4.0 SP2

  Hello, I am genrating xml schema and XML document using dataset in VB.net enviorment.I used these files in Altova Style Vision Enterprise edition to genrate style sheets.I saved html,rtf ad pdf style sheets at my disk.Now I am getting multiple records from database and genrating new xml file.After genrating xml file using tranform method of stylesheet to get html file with this code and it working. 'inspectorODetail.Xslt is genrated using ...Show All

• Smalo Web service in VS 2005

  I am trying to debug a webservice by steping into a web method called from a web project. The strange thing is that sometimes it works but often it does not. When it does not work I get the following error when trying to step into a web method: Unable to automatically step into the server. The remote procedure could not be debugged. This usually indicaes that debugging has not been enabled on the server. See help for information. Here is h ...Show All

• Duncan Woods Best Practices for n-tier on .net 2

  Hello. I usually in asp.net 1.1 make my web application, then I created a class library in which one I put my objects like (persons, authors, books, etc). In another class library I put my Data Access Logic Layer, this one is used by the above class library.  and the object class library is used by the web application. How this should be done in asp.net 2.0 I tried to make a class library but I cant add a web.config to that classlibrary to ...Show All

• chiln1208 Data Access with Access Database

  I have an Access database and ASP.NET code to access it. I can read/write data just fine on the local machine via VisualStudio.NET but cannot write to the database when it is running on another server and I am running outside of VisualStudio.NET. I know this is a permissions issue. I can run Access on the same machine and write data. My connection string does not provide a user or password. I have defined two users for the database. I am writ ...Show All