Answer Questions

• Peter R Hawkes auto increment

  public class AddAnnouncement { public void _AddAnnouncement() { XmlDocument newAnnDoc = new XmlDocument (); newAnnDoc.Load( "~/App_Data/Announcement.xml" ); XmlNode newAnn = newAnnDoc.CreateNode( XmlNodeType .Element, "ann" , null ); XmlNode Id = newAnnDoc.CreateNode( XmlNodeType .Element, "annID" , null ); XmlNode Title = newAnnDoc.CreateNode( XmlNodeType .Element, "annTitle" , null ); XmlNode Body = newAnnDoc.CreateNode( XmlNodeType .Element, "annBody" , null ); XmlNode Date = newAnnDoc.CreateNode( XmlNodeType .Element, "annDate" , null ); XmlNode Priority = newAnnDoc.CreateNode( XmlNodeType .Element, "annPriority" , null ); XmlNode Sender = newAnnDoc.Creat ...Show All

• PaulVSTO Log writting Exception thrown by a WebService

  I have deployed a third part webservice on my webserver, this service throw its errors to the windows error viewer, but those error has never been wroten, the webservice shows this error: Cannot open log for source {0}. You may not have write access, I've checked out the Error log configuration in the error viewer and I've asigned full permission to the EVERYONE user group on the log file folder. the error still been appearing, I don’t understand why, if somebody had been working arround somthing like this and wants to gives me a hand on this will be nice. There is more to event log security than what you did. See http://support.microsoft.com/kb/323076 I would also contact the third party vendor an ...Show All

• Vedratna Compiling 2.0 applications with 3.0

  If I install .NET Framework 3.0 and build an application previously developed against .NET 2.0, do I need to deploy the 3.0 redistributable with my application even if I do not use and 3.0 classes Thanks! Michael As long as your application only relies on features in the .NET Framework 2.0, you do not need to redistribute the entire .NET 3.0 runtime with your application. I'd suggest testing your application on systems that only have 2.0 available before shipping to ensure that you didn't inadvertantly introduce any 3.0-specific dependencies in your application. Thanks! Aaron ...Show All

• Russ McDaniel ASP.NET EXCEL TO XML CONVERSION

  I am using asp.net and i need to convert an excel file into an xml file and send it as an dataset/datatable parameter to the server. the point is i want this to be done at the client side only. I just responded to this and Microsoft ignored my response :( http://msdn.microsoft.com/msdnmag/issues/02/01/UserCtrl/ the preceding URL contains information about creating user controls for web clients. Here is a quick rundown of what your application would look like: your web page would have the <object ... > reference as shown in the preceeding URL. You would pass the URL of the xls file as a <param ... object. Your control code would include a reference to Microsoft.Excel library. You will first have your contro ...Show All

• wakawaka54 Repeating Element Name Problem with xsd.exe

  Hi, i generated a dataset with xsd.exe by my xsd file. What i am trying to do is to fill the dataset and generate an xml as fallows (It is valid for my xsd): <root> <ELEMENT1> <ELEMENT2>11<ELEMENT2> <ELEMENT2>22<ELEMENT2> <ELEMENT2>33<ELEMENT2> .......... <ELEMENT1> <root> Anyway, with the datasate created. When i add an ELEMENT1 Row it always generates the xml like: <root> <ELEMENT1> <ELEMENT2>11<ELEMENT2> <ELEMENT1> <ELEMENT1> <ELEMENT2>22<ELEMENT2> <ELEMENT1> <ELEMENT1> <ELEMENT2>jhgkjhk<ELEMENT2> <ELEMENT1> <root> I think it is because ELEMENT2 is a ...Show All

• ThomasJaeger Invoke exe from web.

  Hi, I want to invoke the EXE from my Web application.Is it possible.How.Please help me. Thanks, justin(Navyajeevan) That's a very browser-specific question and has nothing to do with the CLR. I imagine you'll have to jump through several hoops to get a browser to start a program. Try posting your question at forums.asp.net or a IE newsgroup at www.microsoft.com/communities. Hi, Thanks for ur reply.How it possible.Explain me please...When i click the button that is in web then invoke the exe. Thanks. Hi, Thanks for ur reply.Its not working in web side.Please help me. Thanks Good question! My answer was of course on the server ...Show All

• Dinesh Kokate Update query in DeleteCommand

  Hello, I'd like to use an update query in an adapter's DeleteCommand. I want to set a boolean column to 'true' (to mark the row as 'deleted') but leave the row there. I've tried what looks right but it doesn't work: OleDbCommand delCommand = new OleDbCommand ( "UPDATE tbl SET Action = 1, Deleted = where Id = " , cn); delCommand.Parameters.Add( "Id" , OleDbType .Integer, 0, "Id" ); delCommand.Parameters.Add( "Deleted" , OleDbType .Boolean, 0, "Deleted" ); delCommand.Parameters[1].Value = true ; m_dbAdapter.DeleteCommand = delCommand; I get an error that states I'm missing a value for the 'Deleted' parameter. Has anyone done this before Thanks, Ken ...Show All

• RWF RijndaelManaged and Base64 - overflow characters after decryption.

  Hello fellow developers! I have a problem in two routines for encrypting and decrypting text files, it works fine except the decrypted file contains 3 extra characters " i ". Is there anyone out there that has experienced the same problem or has an idea for a solution I have tried using different PaddingMode settings but without getting closer to a solution. PaddingMode.None - Exception during encryption, "Length of the data to encrypt is invalid." PaddingMode.ANSIX923 - Ok but "i " at end of file. PaddingMode.ISO10126 - Ok but "i " at end of file. PaddingMode.PKCS7 - Ok but "i " at end of file. PaddingMode.Zeroz - Exception during decryption, "Invalid character in a Base-64 st ...Show All

• Ramachandra Binary serialization stream/buffering issue.

  Hi there. Take a look at the following bit of code. It's fairly simple. String Message = "Test" ; MemoryStream MemStream; Byte [] Buf; MemStream = new MemoryStream (); new BinaryFormatter ().Serialize(MemStream, Message); Buf = new Byte [MemStream.Length]; MemStream.Read(Buf, 0, ( Int32 )MemStream.Length); MemStream.Close(); Can anyone tell me why "Buf" only contains zeroes after this process is complete It should be filled with the serialized object data, not nulls. --JT http://zhaymusic.com/ Lucian Bargaoanu wrote: After Serialize you are at the end of the Stream, so actually you're not reading anything. Try MemStream ...Show All

• Manubhaskar How to Prefix an XML document?

  How to add prefix to all of the nodes in an XML document Following is my xml. < xml version="1.0" encoding="utf-16" > - < XYZ123 :NameRequester xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" d1p1:SID="20" d1p1:HID="21" d1p1:RID="22" xmlns:d1p1="http://tempuri.net/" xmlns="http://tempuri.net" xmlns:XYZ123="http://tempuri.net"> - <d1p1:NameBlock> - <d1p1:Test1> <d1p1:Name>Bob</d1p1:Name> <d1p1:HisName>Tom</d1p1:HisName> <d1p1:HerName>Marie</d1p1:HerName> </d1p1:Test1> <d1p1:OtherName>Sally</d1p1:OtherName> ...Show All

• nafi Getting processes by window caption

  I just want to know how to find instances of programs with a certain window caption, something similar to the system.diagnostics.process.getprocessesbyname command except to find processes by their window caption instead of process name. How would this be done Works a treat. Will bookmark the Global Hook for now as work well enough as it does. Cheers Again... How are you getting the captions Its usually done by passing the Hwnd....if you have the handle you can get the process. Take a look at this article Process Information and Notifications using WMI. You can use caption to get process name from window caption and then use system.diagnostics.p ...Show All

• Frankelman questions about Automatically Generating Commands (DbCommandBuilder )

  from http://msdn2.microsoft.com/en-us/library/tf579hcz.aspx When the SelectCommand property is dynamically specified at run time, such as through a query tool that takes a textual command from the user, you may not be able to specify the appropriate InsertCommand , UpdateCommand , or DeleteCommand at design time. If your DataTable maps to or is generated from a single database table , you can take advantage of the DbCommandBuilder object to automatically generate the DeleteCommand , InsertCommand , and UpdateCommand of the DbDataAdapter . I'm confused that if my selectcommand involves more than one table, these commands can not be generated automatically, is this true so during actual development, probabably our sel ...Show All

• rofu Trusted_Connection Problem with VS2005

  I'm sure this is a known problem, but I can't seem to find the fix. My VS2005 app connects to the SQL Server database through web services. If I connect with a connection string that uses userid and password, no problem. But, if I change that to use a Trusted_Connection instead, it won't work. This worked fine when the app was compiled under VS2003, but has not since migrating it to VS2005. Is there some setting I need to tweak somewhere In IIS maybe TIA, Putting a username/password in the web.config file, encrypted or not, is not an option. As I said, this worked just fine in VS2003 with a Trusted_Connection. Not doing anything different (other than installing VS2005 and migrating my existing VS2003 app to VS2005), this s ...Show All

• alibeau failed to connect to an oracle 8i database

  Hello everybody, I hope someone would be able to help me… I need to programmatically talk to an Oracle 8 database located in a remote server. I have installed the client oracle 8 + Toad into my computers (Windows XP) and I have no problem connecting to this database by using toad. Then I added the System.Data.oracleClient dll to my project, imported it and tried to connect via my application, and had the ORA-12560 error. I can’t open the connection. My connection string is : “BaseName. UNIV-PARIS.COM (from the names.default_domain in the sqlnet.ora file); user id= ; password=” Have you any idea of what my problem is Thanks you for your help, Susana Hel ...Show All

• frostit SourceTable and SourceField

  Hi I'm upgrading my code based on DAO to ADO.NET in VB2005 and got stuck looking for SourceTable and SourceField properties of DataTable fields. DAO.Recordset.Fields have .SourceTable and .SourceField properties which tell you the original table/field which provides the data in that particular field of the recordset. This is useful in my application where I am filtering users' queries to the database to see whether I want to allow them access to that particular bit of data.  Although I can imagine that there are maybe other solutions to security issues, I've already built a whole system around this method, and would like for simplicity's sake just upgrade it without changing the methodology. Can anyone advise where to g ...Show All