Answer Questions

• Brad Corbett DateTime interpretation between ADO.Net and SQL Server

  In my application I write to a table in a database a DateTime field (which happens to be a primary key) by executing a SQL command, e.g. INSERT INTO MyTable (MyDateCol) VALUES ('8/22/2006 4:20:21 PM'). Then, I insert the same value into another table (in which that same field is a foreign key) by using ADO.Net's SqlAdapter->Update(), where in a DataTable in a DataSet I had stored that same System::DateTime object. I am getting a failure - foreign key constraint violation - when trying to do that last write. When inspecting the value of that field in the DataSet from within the debugger, the date looks like this: "22/8/2006 16:20:21" (same thing, just different representation). This is all on the same computer so the culture is the same ...Show All

• 0to60 SFTP c#

  I want to do SFTP using c#. how it can be done You could also try Rebex SFTP for .NET component Regards, Martin Vobr Are there any SFTP libraries built into any of the .NET Framework versions You could try edtFTPnet/PRO, our C#/.NET client that supports FTP,FTPS and SFTP. See http://www.enterprisedt.com/products/edtftpnetpro/overview.html and http://www.enterprisedt.com/products/edtftpnetpro/download.html for a trial download. regards Bruce Blackshaw Enterprise Distributed Technologies No, as SFTP is part of SSH family of protocols, and SSH is not implemented in .NET Framework. But why not use the third-party one ...Show All

• errpop Exception: An established connection was aborted by the software in your host machine

  I get following exception each time i try communicate: System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a send. ---> System.IO.IOException: Unable to write data to the transport connection: An established connection was aborted by the software in your host machine. ---> System.Net.Sockets.SocketException: An established connection was aborted by the software in your host machine I have very simple flow: 1. Send synchronized HTTP request 2. Call WEB service API in block mode 3. Send asynchronous HTTP request. The third request always fails no matter what i do. All requests are sent to same host though different servlets. Host machine is running Tomcat WEB service within J ...Show All

• GlenAtMotorola Table does not appear to update after UPDATE statement

  I am trying to update a table (asps) in MS access with the code below. However even though it complies and appears to execute, the table is not updated. Both ID and recID are double. I am working in ASP .NET C#. Any ideas Thanks private void Button1_Click( object sender, System.EventArgs e) { OleDbConnection conn = null ; conn = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0; Data Source=C:\\Inetpub\\wwwroot\\WEB\\afterschoolprograms.mdb"); string strEditCommand = "UPDATE asps SET "; strEditCommand += " NAME = "; strEditCommand += " WHERE ID = "; using (OleDbCommand cmd = new OleDbCommand(strEditCommand, conn)) { cmd.Parameters.Add( ...Show All

• Alvin Chen How to create an object relying on a Type structure?

  I am new to .NET, and many basics of it have not been grasped yet. Can you help me about this: //-------------------------------------- class A{}; A^ obj_sample = gcnew A();  // I am using C++/CLI //If I can get obj_sample=>GetType() as a Type structure, how can I use it to create another A Class instance on the condition that I am unaware of the Declarator of Class A //Though, I use Object^ myobject = Activator::CreateInstance(obj_sample->GetType()); //the myobject is Still a Object type one, but I need a A type one, otherwise the members defined in A class can not be accessed.(Compiler can not get through). // I know A^ myobject = (A)Activator::CreateInstance(obj_sample->GetType()); //should work, ...Show All

• mNilysg Bug? : Sgen breaks web-service serialization

  I am using the noaa weather web service and it works fine if I have not run sgen on the assembly. I have sgen disabled in the project settings and instead run it explicitly in the main build. I run sgen using the command: sgen /a:myassembly.dll /force /compiler:/keyfile:myassembly.snk This creates an [assembly_name].XmlSerializers.dll and when running the application again, the same call to the web-service fails with the following exception. This is internal to the web-service code so I'm stuck for what to do other than not run sgen: System.InvalidOperationException: There was an error generating the XML document. ---> System.ArgumentException: Item has already been added. Key in dictionary: 'myassembly.gov.weather.www.productType' ...Show All

• leclerc9 Getting System.Xml.XmlException and need help.

  About 6 weeks ago I wrote some code to serialize an object and put it into SQL Servers new XML datatype column. I was easily able to serialize and deserialize the object and the world was a wonderful place. After having done that TechEd 2006 showed up, and other business priorities surfaced, and I forgot about this code for a while. Yesterday however I returned to this code. I called the code to serialize my object, and happily watched it go into the database with no issues. COOL! Now I worked around to calling the deserialize code, and got an exception. Odd, since this worked like 6 weeks ago, and I have done very little to the object being serialized, and nothing to the code that performs the serialization. I checked the ...Show All

• ddseshu Strange problem with XmlReader/XmlWriter: "The process cannot access the file '...' because it is being used another process"

  Hello, I have a strange problem when using XmlReader/Writer. After writing the xml file and restarting the app I like to read the contents from that file. Writing the doc XmlTextWriter writer = null; try { XmlDocument doc = new XmlDocument(); writer = new XmlTextWriter(filename, null); ... doc.Save(writer); } catch (Exception ex) { ... } finally { if (writer != null) writer.Close(); } ... and reading the same file (after restarting the app) StreamReader sr = null; try { XmlDocument doc = new XmlDocument(); // *** THIS LINE CAUSES THE EXCEPTION *** FileStream fs = new FileStream(filename, FileMode.Open, FileAccess.Read); sr = new StreamReader(fs); doc.LoadXml(sr.ReadToEnd()); ... } catch (Exc ...Show All

• Hughsieman How to load datareader result into an arraylist?

  Hi. I need help to accomplish this task. I result from a stored procedure get pulled into the datareader. From the datareader, I need to load it into an arraylist for binding into a datagridview. The thing is, the data coming from the stored procedure can come back with different columns everytime (data is being pivot from the stored procedure). How can I accomplish this Thanks, Rick.. You could use oReader.getname(0) to get the name of each column (use a for loop up to oReader.FieldCount as the max), then add the columns programatically, then just set the data source to the reader, should work I think! Ross Perhaps use a DataTable instead of an ArrayList. DataTable has a Load method wit ...Show All

• pinoyz custom plugin questions!

  Hi there. I have no idea but had a sudden urge to ask about things like this, I guess its good for the knowledge! I have an app created in .NET 1.1 I *may* wish to implement plugin's with the application, so developers can create their own plugin's for the application. Question 1) If a plugin was created in .NET 2.0, will it still work with the .NET 1.1 application (obviously assuming they have both frameworks installed) Question 2) How would one go about creating plugin's for their application Question 3) Is it possible for this plugin to implement/"subscribe" to public events exposed by my application, so when I raise an event, any of the plugin's who have a subscription to the event, is notified Th ...Show All

• akilah suggestion for data manipulation code optimization..

  Hi, I am using Framework 1.1 There are some performance issues in my code... I have a datatable dtOrderSizeData that has following four columns in it. Market_key Customer_key Item_key Order_size I have to extract ordersize for each markets/customers/items. I have lookup tables for market, customer and item. Market look up table has 8 rows Customer look up table has 15 rows Item look up table has 44 rows In order to get ordersize for every market, strategy and item, I run a nested loop. For each(Market in MarketLookup) { Get Market_key For each(customer in customerlookup) { Get customer_key For each(Item in ItemLookupTable) { Get Item_key OrderSize = Filter dtOrderSizeData using market_key and customer_key and item_key to get the orders ...Show All

• VDimitris A problem in restarting the service of MSSQLSERVER

  I had the following problem in my application. I need to Restart MSSQLServer service before do the connection test. In some cases, I have to Restart the MSSQLSERVICE again after connection test. In the old version of MSDE2000, no problem occured at all. But in MSDE2000 SP3a, I got the following error when restart the MSSQLSERVICE for a 2nd time. But if I run the test program so as to execute RESTART and CONNECTIONTEST in pair each time, no error occured. Can somebody give some advice to avoid this problem Thank you! The error log says : 2007-01-11 10:30:26.45 server Using 'SSNETLIB.DLL' version '8.0.766'. 2007-01-11 10:30:26.46 spid5 Starting up database 'model'. 2007-01-11 10:30:26.51 server SQL server listening on ...Show All

• bikedoc1 Why Tables.Rows.Count is 0 even though rows are displayed in DataGrid

  1. I have a webforms application. 2. I am checking the number of rows is higher than 0 if (DataSet1.Tables(0).Rows.Count() > 0) 3. The value is always 0 even though I have retrieved rows from this DataTable into my DataGrid. Any Ideas Please help.. Perhaps you are using another table than this with the index 0 See what DataSet1.Tables.Count bring back... HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- I used the DataGrid component the cache the data. Am it worked just fine. I may have the answer, but I may be wrong. To me I see two places. One, should you use square brackets for the index search Also, it ...Show All

• NeroToxic CREATING DATABASE PROBLEMS

  hi! i am new and heres what i try to do: I want to do an internal database where user create accounts, log in and view the information of the account! if some knows what i mean please HELP! Leo To be honest: No General approach: * Think of the fields you will need in your database (Surname, Name, Age, password, ...) * Create a database with these fields (SQL server Express is free afaik and integrates perfectly into visualstudio) * Create methods which access that database information * Create a form which will display your data ok: i want that on the beginning you can either log in or create a new account. when you log in you can see the information yo ...Show All

• lou_1 Interop Timeout

  I am using a COM component in my .Net application. My application is a windows service. Basically its a multithreaded application. I am using tlbimport utility to create RCW for a COM component. My problem is, sometimes the RCW call takes time to return. Is there any way to specify the timeout for the RCW call so that I can break the call. I am using .Net framework 1.1. Any help would be appreciated. Thanks in advance. Cheers. Samir ...Show All