Answer Questions

• Greg1997 Adding New row to DataTable is very slow

  DataRow drNew = dsTranscript.Tables[ "TABLE1" ].NewRow(); drNew.BeginEdit(); drNew[ "col1" ] = "a"; drNew[ "col2" ] = "b"; drNew[ "col3" ] = "c"; drNew[ "col4" ] = "d"; drNew[ "col5" ] = "e"; drNew[ "col6" ] = "f"; drNew[ "col7" ] = "g"; drNew[ "col8" ] = "h"; drNew[ "col9" ] = "i"; drNew[ "col10" ] = "j"; drNew.EndEdit(); Tried both of these methods ... dsTranscript.Tables[ "TABLE1" ].BeginLoadData(); dsTranscript.Tables[" TABLE1 "].Rows.Add(drNew); and dsTranscript.Tables[ "TABLE1" ].Rows.InsertAt(drNew, dsTranscript.Tables[ "TRANSCRIPT_DATABASE_TABLE" ].Rows.Count); dsTranscript.Tables[ "TABLE1" ].EndLoadData(); The DataTable has about 15,000 rows.. but that ...Show All

• Todd at HCA refresh a sqldatasource ?

  Hi all, I've got a sqldatasource, a dropdowlist and a button on a web page. The button run a SQL stored procedure which creates a line in a table called Agents. The dropdownlist is bound thanks the datasource, but it's impossible to view the recently agent created (but the new value is well created in my table !) It seems that the datasource doesn't see the new value, but if I reload my page, the value can be selected. How can I force the refresh of my sqldatasource (hope is clear...) Thanks ! Yes, I should use Atlas. It could be the future of .net, as I heard. hi, when new row have inserted, the dropdownlist shall re-bind the datasource; add code in button click event like: protected Bu ...Show All

• Henny help understanding gacutil.exe and the dll path issue

  I have this code in a VS2003 setup Project mySetup.exe that registers the TranslatorHttpHandler.dll in the GAC: string strCmdLine; strCmdLine = @"/C C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\gacutil.exe -i TranslatorHttpHandler.dll" ; System.Diagnostics.Process.Start("CMD.exe",strCmdLine); Is this command going to look for the file TranslatorHttpHandler.dll in the same folder where mySetup.exe is runing. What I don t understand, even if I rename the TranslatorHttpHandler.dll to another name the registration (setup project) runs without a problem. Thanks a lot. I ll create a setup project then I only had an exe and i shipped the dll with it Thanks a lot. Why are you invo ...Show All

• Iker Garaizabal sending data through sockets..

  there is a server and a client.. i connected them using sockets.. i want the Remote "client" app. to draw when i move the mouse on the host"server" app.. i got the mouse position from the onMouseMove () but i dont know how to keep sending the coordinates to the client so it can paint.. thnx. Not realy.. mc[] is an int array in which i store the x,y of the mouse postion... but i want to send data the socket.send only takes byte[] .. so i convert the mc[] of integers into the xy[] of bytes.. though i know that what u said does have somthing to do with the problem im facing.. i cant figure out how to solve it.. this would be helpful if the send method would accept a string.. but it only accept byte[].. its either sockets prog ...Show All

• enric vives ODBCDataReader identified as a null

  I was trying some serialization of an ODBCDataReader object in C# when I ran into this problem. I'll put below the whole scenario. There is a particular class which has a public property which is an ODBCDataReader. One of the methods in the class updates this data reader. The problem occurs when I try to access the data reader object from another class. Even though the watches show that the object's hasRows as true, when I try to at least display it using a ToString(), it gives an error saying that the object reference is null. I'm extremely sure that the data reader is returned a not null value and I have used the data reader objects elsewhere without any problems. I think the porblem is in assigning the data reader as a public prop ...Show All

• Mike Southerland Architecting Web Services - Best Practices

  Folks - I am looking for a best practice to outline the following scenario. Articles, papers and so on would be great (of MSDN webcasts) Say i have an entity class, say called "Order" and that order class has some properties (OrderID, Currency, Amount) and one or two methods (say Validate()). This Order entity is returned from a WebMethod, and through another WebMethod you pass an updated version of this entity. On a client consuming this service (a .Net client for example) you call each of these methods. Ideally, some business logic is performed on the client - so when you set the currency on the Order class this should conform to the business rules of that property (say it must be one of three currencies and so on). Th ...Show All

• Abhishek Chadha How to store a string which contain Null Character?

  I need to send a string which contain the NULL (&H00) character through the serialport. I found that the System.Text.Encoding.ASCII.Getstring will stop when the byte value is equal to zero. Here is the coding Dim bvtAVP() as byte bvtAVP(0)=&H0 bvtAVP(1)=&H65 bvtAVP(2)=&H0 bvtAVP(3)=&H66 strAVP = System.Text.Encoding.ASCII.GetString(bytAVP, 0, bytAVP.Length) Please help me on this, thanks. Your byte array looks a lot like a Unicode string in BigEndian format. If all of your arrays look like this and only contain ASCII codes, just create a new Byte() array from the odd bytes... You can declare string variable like this string srtAVP . Try th ...Show All

• foobarX A New "Syntax error in INSERT INTO statement"

  Hello, I have this code in a windows form where it has a comboBox to choose one of three tables from "material" Access database, and the user has two options of adding or deleting a row. My three tables are Customer, Material and Accessories. The insertion and deletion of Customer works just fine, but when I try to add a new row to Material or Accessories a syntax error in INSERT INTO statement is shown. I tried everything I know or could think of. Please If you can help me I would appreciate it so much. Here is the code: =================================== private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e) { switch (comboBox1.SelectedIndex) { case 0: { customerAdd(); break; } case 1: { ma ...Show All

• mfindlay Remoting application error: "This function must be called in the default domain"

  I have a remoting application under the hood is mostly unmanaged code. We have created a managed wrapper ontop of our unmanaged classes. These classes then make a transition back into a managed context to do some additional work. These additional classes are written in C++/CLI and some of them have functions that look similair to this. const CMyClass& CTest::Test(USHORT n) { static const CMyClass dbEmpty; //We end up return ALOT of these so we want to only create it once if (someconition) { return CMyClass(aaa); } return dbEmtpy; } When we enter one of these function we will always hit the following assert in _atexit_m defined in msilexit.cpp (Entire function at the end of post). MANAGED_ASSERT(AppDomain::CurrentDomai ...Show All

• AFoxmore Problem reading no updated data.

  Hi all, I would like to know how to solve the following problem: I have the following command sequence: (I am working with ACCESS and ADO.NET) 1 - Update some fields from a table. 2 - Select this fieds from this table. Here is the problem, when I check "Select" results, some fields from the first rows have not been updated. If I insert a "wait" command between this two SQL commands, these fields are updated successfully. Is there any way to assure that "Select" command is executed just when "Update" has finished Regards. UPV Moldova. Can you posted a code snippet for that Best Regards Hi, Supposedly command execution ...Show All

• johnnygoodface Channel already registered

  Hi I have a .NET Remoting service running on a machine, and have created a Web service wrapper for the service. In the WebMethod, I have the following code: RemotingConfiguration .Configure(configFile, false ); string url = null ; WellKnownClientTypeEntry [] types = RemotingConfiguration .GetRegisteredWellKnownClientTypes(); if (types.Length > 0) { WellKnownClientTypeEntry type = types[0]; url = type.ObjectUrl; } if (url == null ) { return ; } _remoteCoverage = ( IRCService ) Activator .GetObject( typeof ( IRCService ), url);.... On the first request it works just fine. On the next, I get an exception saying the tcp channel is already registered. The remote object is configured as ...Show All

• Whoisit Difference between HashTable and NameValueCollection

  Hi all, can someone please explain the differences between these Did the NameValueCollection come in on C# 2.0 If so, then why if the HashTable performs more or less the same. Also, the HashTable has the ContainsValue() method, where as I can't see anything similar to this for the NameValueCollection. Thanks You should be using Dictionary in 2.0 and not Hastable or NameValueCollection. See this blog post about the performance of NameValueCollection vs. Hashtable: http://blogs.msdn.com/bclteam/archive/2006/09/05/741660.aspx None of them is new to .NET 2.0. They're in since .NET 1.0. ...Show All

• simonyee Transact SQL Query to return Sequence Number

  I want to display the sequence number Column for the Row Returned, row wise. i.e. select empname,emp_age from [table Name] sl_no empname empage 1 Adams 45 2 Borris 55 3 Cathy 33 how should we include this 'sl_no' column within a select query Please Help ! I wrote an article on how to find the identity value of a row during an insert: Retrieve Identity Column Value After Inserting Record in Database Table - SQL Server - Free ADO.NET Tutorials Hope this helps. Regards, Dave If u just want to query data from database. I think SELECT sl_no, empname, emmpage FROM [table name] will work. If u wana g ...Show All

• milkshake Warning: There are updated custom wrappers available for the following referenved components: Office.

    Hello everyone, I converted a vb.net 2002 project to vb.net 2005 and I continue to get the warning message: There are updated custom wrappers available for the following referenced components: Office . If I dbl-click on the message I get: One or more custom wrappers for COM components have been installed on your machine after you added references to those COM components.  These wrappers may provide additional capabilities not offered by the auto-generated wrappers currently in use. Do you want to replace the auto-generated wrappers with the custom wrappers   If I click YES then I get 102 ERRORS++. If I click NO then the project runs just fine but the warning shows in the IDE. Without turning ...Show All

• Anand Raman - MSFT Data type mismatch in criteria expression

  I have the lines of code below which caused error: Data type mismatch in criteria expression string staff_no = staffDataGridView.CurrentRow.Cells[0].Value.ToString(); OleDbCommand findStaffIDCommand = new OleDbCommand( "SELECT staff_id FROM staff WHERE staff_no = " + staff_no ); findStaffIDCommand.Connection = new OleDbConnection( Properties.Settings.Default.HPMConnectionString ); findStaffIDCommand.Connection.Open(); OleDbDataReader findStaffIDReader = findStaffIDCommand.ExecuteReader( CommandBehavior.SingleResult ); int staff_id = Convert.ToInt16( findStaffIDReader[0].ToString() ); MessageBox.Show( staff_id .ToString()); the blue-colored line is where the error occurred. in my ACCESS ...Show All