Answer Questions

• NetWave Problem with Datetime type in MS Access

  When I want to find the records between a date range, there is a column 'Saledate' which type is Datetime, I always use below way to do that: Select * from Table1 where SaleDate >= #1/1/2001# and SaleDate <= #1/1/2002# It works fine in MS Access UI. But it doesn't work in my C# program. My program like:   private System.Data.OleDb.OleDbCommand oleDbSelectCommand1;   private System.Data.OleDb.OleDbCommand oleDbInsertComm ...Show All

• Yuval Rakavy Design Question

  We have a situation where 25,000 clients will need to 'check-in' to our servers every hour. Checking in will require passing a unique ID that is verified against a back-end SQL Server database. I am relatively new to remoting, so I have a few design questions. We plan on using network load balancing, so the final design needs to take this into account. We also cannot guarantee all clients will have open firewalls, so making it port 80 friendl ...Show All

• simmy Multiple Inserts into Sql Server.

  Is there any way to insert multiple rows into sql server table in single query or single round trip to the server Thanks. Yes...as no one has mentioned, use a cursor: USE pubs GO DECLARE get_price CURSOR FOR SELECT price FROM titles OPEN get_price FETCH NEXT FROM get_price WHILE @@FETCH_STATUS = 0 FETCH NEXT FROM get_price CLOSE get_price DEALLOCATE get_price Adamus AOA! Try sending Added/Modified rows ...Show All

• wfoster3 Removing \t\n stuff from XML

  Hi all, im building a super cool Reporting Server in ASP.NEt that parses XML docs and generates sql to run and return results. And i must say, all you MSD's will be impressed. However i need some help still. My Xml sturcture is (very) basically like this ... <query> <sql> My SQL HERE </sql> </query> i Preserve the format in the sql block and so when i pull the sql text from the XML doc i get so ...Show All

• BatchBoy Never trust a tickcount

  Hi, For those who use tickcount for any calculation on your application... DO NOT USE IT. Simply, for some idiot reason the tickcount returns an integer, so if you have a server that runs all the time or if you have a multiprocessor environment the tickcount overflows and returns 0! But for my surprise if you use Tickcount.ToString() actually returns the string version of a 64bit value, so is not 0!!! Funny when you are trying to debug ...Show All

• Jared B Component Planning with MS Visio

  Hello All, I just bought MS Visio 2003 and I heard it was an awesome tool for component/object planning.  Is there a tutorial out there that can show me the typical drawing scheme for component/object planning Thanks in advance, Ok, The plus sign represents a Public item and the minus sign represents a Private item, so those members listed in each objects all had minus signs preceeding them as Private but the methods had plus si ...Show All

• BN25 [VB.net] Add a TimeStamp

  Hi! I already asked something about Accessing an Access-Database in following Thread : http://forums.microsoft.com/msdn/ShowPost.aspx PostID=119542 That works! But now, I've got another question. I want to add a Timestamp into an Access-Database. For that, I tried following code : Dim insertsql As String = "INSERT INTO t_Personal(TIMESTAMP) VALUES(@TIMESTAMP) Try   Dim myconn As OleDbConnection   myconn = New OleDbConnect ...Show All

• JasonWHowell Provider error while reading DBF file

  Dear All, I am newbie in dbf manipulations .currently I have downloaded foxpro driver from the site . but when I am tying to open my DBF file it gives me error like "The Provider could not determine the Decimal value . For Example,the row was just created the default for the Decimal column was not available,and the consumer had not yet set a new Decimal value" I am using the following code snippet to open .DBF file:- ...Show All

• Radhakrishnan Consuming a java web service

  hi there: I m trying to consume a java web service and I cant I tryed adding a web reference and creating a proxy using wsdl.exe but no success so far I need to add parameters such as username and password, but i dont know wher I really need to get this going so i d appreciate any pointers Regards Andrea look into NetworkCredential. Do you have proxy ...Show All

• David Jeavons Type Fidelity and Web Services

  The company I'm a part of recently released a new verison of our distributed information processing system and while designing the thing I was presented with a few challenges that I'm now able to look back on and wonder if I did the right thing. The biggest design issue I had was wether or not it needed to be based on .NET Remoting or take the web servies approach. While I definitely would have liked taking the web services approach in partners ...Show All

• balves how to retrive all added handlers?

  Hello, I am pretty new to .net and hope you don't tease me :) say i have: addhandler textbox1.onchange, addressof validator1 addhandler textbox1.onchange, addressof validator2 ... how do i programmatically get to the list of all validators for textbox1 in othe parts of the program I don't have the VB syntax, but a delegate (which is what events are) has a GetInvocationList method, that returns a list of all me ...Show All

• josh.the.ripper system.objectdisposedexception

  Hi, I have a multithreaded application that crashes with the following msg in event log ... EventType clr20r3, P1 smartserver2005.exe, P2 1.0.0.0, P3 43f6cc52, P4 system, P5 2.0.0.0, P6 4333ae87, P7 3ad8, P8 a5, P9 system.objectdisposedexception, P10 NIL. I have provided try catch block in all routines in the code & still the appl crashes with the above msg. Note that crash is not consistent for a particular se ...Show All

• FransRudolf Serializing an XML document

  I'm fairly new to C#, so maybe this is simple, but I couldn't find any answer to this anywhere. I am trying to write something that will take an XML document of unknown structure and wrap it in a mesage wrapper and send it to another program. I figured it was easiest to just use the XML serialization stuff to do this, but I can't figure out how to get this to work with the XML document. This is a simplified version of what I am trying to do: ...Show All

• funk101 AssemblyVersion

  Hi all! Despite I have my assemblyversion set to "1.0.5.*" no change to the build number is made every time I build the project. Any ideas to correct this situation Thanks in advance, Ramiro I know, this is the reason I'm using "1.0.5.*". What I want is that the IDE change for me the revision number every time I build the solution. But it is supposed (as of the documentation says) that in every buil ...Show All

• testvoid Grouping XML Elements

  I am new to XML and am not sure how to sovle this issue. I have an XML file that contains the following: <TRADE> <ABC>xxxxx</ABC> <ABC type="U"/> <XYZ /> <XYZ year="06"/> <XYZ month="02"/> <XYZ day="15"/> </TRADE>   I basically want to group the elements as such: <ABC type="U">xxxxx</ABC> <XYZ year="06" month="02" day="15"/> &nb ...Show All