ANN: High performance of remoting ADO.NET objects cross desktop and smart devices

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - DAtaset comparision ?? Dear all, What is the best way to compare 2 dataset ? What I mean by that is not comparing that its teh same object but allso that rows data values in both . In other words I need an effeective way which tells me if records between 2 dataset are the same or different thnaks for help regards serge Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142168
  - 2
    - there seems to be some overhead between SQL Server 2005 and a CLR function written in C#. Why is this? there seems to be some overhead between SQL Server 2005 and a CLR function written in C#. Why is this? I have a simple wraper around System.Diagnostics.Stopwatch.GetTimestamp() : public partial class UserDefinedFunctions { [Microsoft.SqlServer.Server.SqlFunction] public static long GetTimestampF() { return System.Diagnostics.Stopwatch.GetTimestamp(); } }; but if i run this it is hardly accurate. the time of getting from sql server to a CLR function seems to be relatively slow for nanosecond calculations: DECLARE @before bigint DECLARE @after bigint SET @before = dbo.GetTimestampF() -- do something SET @after = dbo.GetTimestampF() SELECT @after - @before as nanoseconds is there nyway to elimitate this overhead so that dbo.GetTimestampF() executes as fast for TSQL as it is to call GetTimestampF() in C#? If i call my GetTimestampF() on c# it executes fast enough for the nanosecond results to be accurate Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142167
  - 3
    - Problem in copying SQLite file in C# code I have a little Windows application written in C# with a SQLite back- end. I'm using the System.Data.SQLite provider. One of the features the application provides is a database back-up, which just basically copies the S3DB file to a specified location. See the code below: //------------------------------------------------ System.IO.File.Copy(srcPath, destPath, true); //------------------------------------------------ The file is copied without any problems, but when the application attempts to access the original S3DB file again, the following exception is thrown: -------------------------------------------------- System.Data.SQLite.SQLiteException was unhandled Message="Unable to open the database file" Source="System.Data.SQLite" ErrorCode=-2147467259 StackTrace: ...etc... -------------------------------------------------- If I shut the application down and then start it up again, I can access the database again with no problems. Suspicious of what the File.Copy() method might be doing behind the scenes, I tried using the following approach instead to hopefully ensure that the files were being released: //------------------------------------------------ using (FileStream fsSrc = new FileStream(srcPath, FileMode.Open)) { //Get the source length once so we don't have to keep retrieving it later int srcLen = (int)fsSrc.Length; //Create the destination file (this will overwrite the destination file if it already exists) using (FileStream fsDest = File.Create(destPath, srcLen)) { //Buffer the contents of the source file Byte[] buffer = new Byte[srcLen]; fsSrc.Read(buffer, 0, srcLen); //Write buffered contents to the new file fsDest.Write(buffer, 0, srcLen); } } //------------------------------------------------ Unfortunately, the same problem occurs. I even tried executing the code in its own thread, but with the same results. Any ideas why this is happening and how to fix it? Thank you. Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142165
  - 4
    - databinding I have a checkbox (along with textboxes) that I am trying to use as a databound control to an integer field on a database. I am using Format and Parse with the checkbox to write -1 to the database if the checkbox is unchecked and 0 if checked. I am finding that the Dataset and Database are not updated if I change the checkstate of the checkbox and when I change the checkstate of the textbox, the other controls (textboxes) will not allow focus. The code I have written is below. Any suggestions would be appreciated. // chbActive System.Windows.Forms.Binding chkBoxBinding = new System.Windows.Forms.Binding("CheckState", this.tblEmployeeBindingSource, "inActive", true); chkBoxBinding.Format += new System.Windows.Forms.ConvertEventHandler(IntegerToCheckState); chkBoxBinding.Parse += new System.Windows.Forms.ConvertEventHandler(CheckStateToInteger); this.chbActive.DataBindings.Add(chkBoxBinding); this.chbActive.CheckStateChanged += new System.EventHandler(this.chbActive_CheckStateChanged); //this handles integer to checkstate private void IntegerToCheckState(object sender, ConvertEventArgs cevent) { // the method converts only to CheckState inActive is 0 if false if ((int)cevent.Value == 0) { chbActive.CheckState = CheckState.Checked; } else { chbActive.CheckState = CheckState.Unchecked; } } private void CheckStateToInteger(object sender, ConvertEventArgs cevent) { // if Active is checked then they are active and inActive should be 0 if (chbActive.CheckState == CheckState.Checked) { cevent.Value = 0; } else { cevent.Value = -1; } } Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142164
  - 5
    - Confusing Error related to MappingSource? I'm trying to force LINQ to SQL to do some inheritance modeled around the "Table per Concrete Class" methodology as opposed to the normal "Table per Class Hierarchy" model it officially supports. To do this, I omitted all the properties of the inheritance relationship (Discriminator information and such) and provided the proper Table attribute to associate my derived class with its own table by addint a new partial class implementation manually. So what I end up with is a base class that has all the columns in it, and two derived classes that inherit from it in the designer, and have no additional properties. Then in another file, I declare both derived classes just to supply the Table attribute, providing each derived class' table name. The problem I run into is this error message: "Data member 'Int32 DocNum' of type '(my base class)' is not part of the mapping for type '(my derived class)'. Is the member above the root of an inheritance hierarchy?" Now I've checked the contents of the MappingSource. I retrieved context.Mapping.GetMetaType(GetType(<my derived class>)).DataMembers and was able to verify in the debug window that the DocNum property was defined in that MetaType information, and the DeclaringType matched <my derived class>, so I don't know what it's complaining about. Is there any way to make this work? Any explanation what this error is complaining about? I did notice that if I create a property in my derived class that shadows the base class DocNum property, then that property doesn't have the error any more (the next property does). But the point is not to have to re-declare all the properties in all me derived classes again. Why doesn't it pick up the base class' attributes, even though the mapping info makes it look like it did? Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142162
  - 6
    - How do I (cleanly) dispose of a row in DataGridView DataError even (Reposted from Winforms forum. Not sure where this belongs.) I'm writing a Winforms project in VB/Dot Net 2.0 and I'm having some trouble handling the DataError event. The grid is bound to a filtered binding source. Add is enabled. Part of the primary key is set by one of the cells in the grid which is in combobox mode. My main concern is duplicate keys. The combobox cell is the only problem. The other row fields are either hidden or easy-to-validate text entry boxes (handled in RowValidating). What I want to do in DataError is give the user the choice of remaining in the row to fix it (e.cancel = true) or just dispose of the changes/additions. If it is an existing row, virtually anything seems to work fine (such as <bindingsource.ResetBindings, or nothing for that matter.) What gives me trouble is a newly added row (I'm even sure 'new' is the right term, but it is newly added. By the time it gets to DataError, the row's IsNewRow property = False). Any attempt to get rid of the new row by any means seems to get me into some sort of infinite loop back to DataError, with errors like 'Index <number> does not have a value'. Am I even trying to handle the error in the right place? Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142161
  - 7
    - Inconsistent dat paremeter in query I am using the same code to query different databases, one SQL 2005 and the other SQL 2000. The query contains a date paremeter @Date... Me.SqlSelectCommand1.Parameters.AddRange(New System.Data.SqlClient.SqlParameter() {New System.Data.SqlClient.SqlParameter("@Date", System.Data.SqlDbType.DateTime, 8, "Date")}) The code was written using VS2003 (.Net 1.1) and is now executing on .Net 2.0. SQL Profiler displays the generated query for SQL 2000 as... exec sp_executesql N'SELECT FunctionID, Name, Date, Description FROM vwTicketedFunctions WHERE (Date >= @Date) AND (OnSaleDate <= @Date) ORDER BY StartTime', N'@Date datetime', @Date = 'Oct 26 2007 12:00:00:000AM' and the generated query for SQL 2005 as ... exec sp_executesql N'SELECT FunctionID, Name, Date, Description FROM vwTicketedFunctions WHERE (Date >= @Date) AND (OnSaleDate <= @Date) ORDER BY StartTime',N'@Date datetime',@Date=''2007-10-26 00:00:00:000'' Note that the date paremeter formats are different. My problem is that the SQL 2000 query parses Ok but the SQL 2005 generates the error: Line 2: Incorrect syntax near '2007'. Note also that regional setting is English(Australia). Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142155
  - 8
    - web service for accessing db? hi, is web service good solution for accesing (havily) database (remote or not)? that looks slow, any other methods for secure connection? SOme of coworkers wants to use web service because they don't want expose connection string. thanks fro advise Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142154
  - 9
    - Null Dates in Dataset Using C# 2.0 & SQL Server 2000, have a stored procedure that return 0, 1, or more rows. At least one of the columns is a date and it may null. I have created an XSD of the output from the stored proc. The entry for the nullable date column is "<xs:element name="Sent_Dttm" minOccurs="0" type="xs:dateTime" nillable="true"></xs:element>". I copied the XSD to the C# 2.0 windows app I am developing and it nicely generates a strongly typed dataset. The problem is I get an error when attempting to access this column in the dataset when the value is null: [System.Diagnostics.DebuggerNonUserCodeAttribute()] public System.DateTime Sent_Dttm { get { try { return ((System.DateTime)(this[this.tableOwizCommDoc.Sent_DttmColumn])); } catch (System.InvalidCastException e) { throw new System.Data.StrongTypingException("The value for column \'Sent_Dttm\' in table \'OwizCommDoc\' is DBNull.", e); } } set { this[this.tableOwizCommDoc.Sent_DttmColumn] = value; } } Checking the properties of this field, I noticed that the "NullValue" property has a value of "(throw exception)' Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142146
  - 10
    - Jobsite for SALE JOBSITE FOR SALE For Details Contact: Netxure@gmail.com FEATURE LIST Job Seeker Features =B7 This Job site contains Advanced features of Dice and Monster =B7 Search jobs by location, date range, categories, Job type and keywords. =B7 View all jobs posted by a specific employer =B7 Find out how often your resume was viewed by interested employers. =B7 Set up job notification agents to automatically get matching jobs by email everyday. =B7 Submit your resume to any registered employer from your account with one click. =B7 Add Jobs to Inbox for later viewing. =B7 Apply to multiple Jobs with one click. =B7 Post 'Private' resumes =B7 Make resume searchable or unsearchable =B7 Update your profile at any time. =B7 Subscribe/unsubscribe to the mailing list from your account. =B7 Email a specific job to a friend. =B7 Retrieve forgotten passwords by automated email. =B7 Save time with the easy-to-use and clean user interface. Employment Features =B7 Search resumes by date range, geographic location, industry, Job type and keywords. =B7 Advanced Talent Search to find Jobseekers thru skill search. =B7 Role Based / Position Based Search for easy search process =B7 Add, edit and delete jobs from your account on the fly. =B7 Find out how often each posting has been viewed by job seekers. =B7 Build your company profile and upload a company image or logo. =B7 Professional display of job searches and resume details make for easy reading. =B7 Sign-up for multiple resume notification agents to automatically receive matching resumes by email everyday. =B7 Resumes sent to employer are saved in private inbox for viewing at a later time. =B7 Save time with flexible and powerful resume search interface. =B7 Ability to display resume details in a 'printer friendly format' without any images/colors for easy printing. =B7 Ability to easily sign-up online for Memberships, Job packages, job postings or resume database access. =B7 Automatically receive automated emails notifying of expiring jobs or expiring memberships to give the chance to renew online Administration Features =B7 Broadcast e-mails to job seekers and/or employers who signed up for the mailing list. =B7 Add, edit, and delete jobs on the fly. =B7 Add, edit, and delete employers on the fly. =B7 Add, edit, and delete job seekers on the fly. =B7 Add, edit, and delete job categories on the fly. =B7 Print mailing list of job seekers and employers in the database along with their contact information. =B7 Get general statistics summary including the number of registered job seekers, registered employers, pending job orders, active jobs, active resumes in the database and searched keywords and categories statistics. =B7 Control job expiry dates. =B7 Control resumes expiry dates. =B7 Define featured Jobs to be displayed on homepage =B7 Define featured employers to be displayed on homepage, with direct link to employer's job listing. Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142143
  - 11
    - Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable. Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable. I get this error when I try to run a SQL Server Project with a CLR stored Procedure in it. The target DB is SQL Server 2005 and im using VS 2005. I simply create a new SQL Server Project which creates a Test.sql, i then simply added a Stored Procedure to it called the default name StoredProcedure1.cs and put a break point in my simple StoredProcedure1.cs and hit F5 and i got this error: Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable. Do i need to do something on the server so that I can debug this? Any walk through on how to configure this sql server 2005 to have this RPC so i can debug my CLR stored procedures in this way? e.g. step over, step into, run to cursor etc. Is this CLR debugging feature complete and tested yet? if so is there any walk through on creating simple CLR helloworld in vs2005 and then executing it in sql server 2005 but catching a break point in the StoredProcedure1.CS code? I would like to debug these StoredProcedure1.cs as while sql server executes it is why. so as of now my current error when i try this is: Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable. Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142128
  - 12
    - datatable vs custom List<MyClass> Let's say I want a read-only copy of a simple query that joins 2 tables. When I compare a DataTable (adapter.fill) and a custom List + DataReader, I see that the custom sol'n is about 6x faster and takes 5x less memory. For my test I read about 100K rows and then bind to a grid so the timing takes into account both getting the data and binding the data. From profiling the app I see one thing that really stands out - the internal DataTable routine to build the (default?) index takes up most of the time - it clearly is doing linear scans of a red-black tree and the hit count for traversing parts of the tree ending up in the 100's of millions. Can I give the DataTable some hint (via a property) to tell it not to perform this extra work? In the end I may go w/ a custom sol'n but I first want to check if the built in classes can solve my problem. btw, this is .net 2.0, c#, and I'm just setting the datasource w/out any other binding code. thanks, Paul. Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142127
  - 13
    - very strange behavior of the method GetChanges(...) from the DataSet class Hello ! i'm using a typed DataSet called myDs. This dataset has 2 Tables, Table1 and Table2. i have created a DataSet like this: myDs dsOld = new myDs(); //here i populate the 2 tables ...... //and then call the method to get the added rows myDs dsNew = (myDs)dsOld.GetChanges(DataRowState.Added); at this point on dsNew i have only the added rows of Table1 instead Table2 is set to null.So, the method returns only the rows of 1 table (Table1). i have debugged the code and i see that the both tables of the dataset dsOld are full of rows that have the rowstate = added. somebody can explain me whats the problem ? it's seem like a bug E. Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142122
  - 14
    - Access vs vb.net/ado.net Hi What are the advantages of writing an app in vb.net/ado.net as opposed to MS Access? I need this to sell the idea to the management. Many Thanks Regards Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142118
  - 15
    - Why is SQLFreeStmt within the transaction using parameterized inse I am using ODBC.NET to perform mulitple parameterized inserts into a database. The performance has been terrible. Upon research into the ODBC trace log, it appears the a SQLFreeStmt is being executed by ODBC upon every ExecuteNonQuery that I am issuing. This is causing a huge amount of overhead, especially when working with thousands of inserts. When coding against the ODBC API (outside of .NET), I only issue the SQLFreeStmt upon committing the data, and it is very quick (as expected). Of course, I need to figure this out in .NET, as this is our platform. Here is basically what I am doing in .NET: 1) Open OdbcConnection 2) Begin Transaction 3) Create OdbcCommand and assign to transaction 4) Create parameter collection 5) Loop through all records, assign values to parms, and perform parameterized inserts 6) Commit transaction 7) Close transaction. Any ideas on what I can do to stop these SQLFreeStmts from being issued would be greatly appreciated! Thanks in advance!!! Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142116
  - 16
    - how to insert record in a dataSet into another database table hi, pls can someone help me out. its very urgent i get the solution today. i have a webservice that i use to retrieve new record from a database, also there is a client application (window form) that calls this service which returns the record in a dataset. now i need to insert the record in this dataset into another database table on a different server.how do i do these.i 've tried so many things and also implement a suggestion on a thread about inserting from one db into another but its not working. am using MySql5.1 community edition,IIS 5.o and Visual studio.Net2003 to develop and test. pls someone help me. i need a simple code to do this. Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142115
  - 17
    - how to insert record in a dataset into another database hi, how do i insert a record inside a dataset into another database table on a different server. i use a web service to retrieve the record and store in it into a dataset.i have a client application (a window form) that calls this web service and return the dataset. now i need to insert this record into another database table. am using MySql server and Odbc. pls somebody help me out. i have tried the suggestion on the thead about inserting from one db into another but its not working. Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142114
  - 18
    - Copy database schema from Access to SQL Server Hi all, I'm trying to write an application that takes an Access database as template to customize a new or existing SQL Server database. When something in the template database is changed, I want to apply these changes to the SQL database. For example if new columns are added to a table or constraints are changed, the application parses each Access table and relation and whatever and applies this to the SQL Server database. The data in the tables is irrelevant, only the schema is important. I have to apply default values, check contraints (I think it's validation rules in Access), maximum column lengths, ... How can I accomplish this? Do I have to loop through the Access tables and relations and create a DDL SQL statement for each? What if the column/contraint already existed? Seems complicated, maybe there is an easier solution. I'm using Visual Studio 2005 and C# 2.0, so this should be the way to go. Thanks in advance. Regards, Hannes Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142102
  - 19
    - Memory keeps creaping up...why? This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C8155A.951AF170 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have a simple subroutine (see below) which reads a table and populates = the items of a combobox. As the subroutine is executed, I'm watching = the taskmanager and the memory in use increases; however, once I get to = the Error_Exit: logic and start to close and dispose my memory = variables, the memory is not released and does not decrease in the task = manager. Why is that? Eventually, my program is giving me = "Insufficient memory" errors. *************************************************************************= *************** On Error GoTo Error_Handling Dim cnn As New Odbc.OdbcConnection Dim cmd As New Odbc.OdbcCommand Dim rdr As Odbc.OdbcDataReader cnn.ConnectionString =3D "dsn=3D" & accpac_companyid cnn.Open() cmd.Connection =3D cnn cmd.CommandText =3D "select schedkey, scheddesc from cssktb order by = schedkey" rdr =3D cmd.ExecuteReader Do While rdr.Read combo.Items.Add(rdr("schedkey").ToString.Trim) Loop Error_Exit: If Not IsNothing(rdr) Then rdr.Close() cmd.Connection.Close() cmd.Dispose() cnn.Close() cnn.Dispose() End If rdr =3D Nothing cmd =3D Nothing cnn =3D Nothing Exit Sub Error_Handling: Select Case Err.Number Case Else MsgBox("The following error occured in LoadSchedules()" & vbCrLf = & Err.Description) End Select Resume Error_Exit ------=_NextPart_000_0006_01C8155A.951AF170 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.6000.16544" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV> <P><FONT face=3DArial size=3D2>I have a simple subroutine (see = below) which=20 reads a table and populates the items of a combobox.  As the = subroutine is=20 executed, I'm watching the taskmanager and the memory in use increases; = however,=20 once I get to the Error_Exit: logic and start to close and dispose my = memory=20 variables, the memory is not released and does not decrease in the task=20 manager.  Why is that?  Eventually, my program is giving me=20 "Insufficient memory" errors.</FONT></P> <P><FONT face=3DArial=20 size=3D2>****************************************************************= ************************</FONT></P> <P><FONT face=3DArial size=3D2>On Error GoTo Error_Handling</FONT></P> <P><FONT face=3DArial size=3D2>Dim cnn As New = Odbc.OdbcConnection<BR></FONT><FONT=20 face=3DArial size=3D2>Dim cmd As New Odbc.OdbcCommand<BR></FONT><FONT = face=3DArial=20 size=3D2>Dim rdr As Odbc.OdbcDataReader</FONT></P> <P><FONT face=3DArial size=3D2>cnn.ConnectionString =3D "dsn=3D" &=20 accpac_companyid<BR></FONT><FONT face=3DArial = size=3D2>cnn.Open()<BR></FONT><FONT=20 face=3DArial size=3D2>cmd.Connection =3D cnn<BR></FONT><FONT = face=3DArial=20 size=3D2>cmd.CommandText =3D "select schedkey, scheddesc from cssktb = order by=20 schedkey"<BR></FONT><FONT face=3DArial size=3D2>rdr =3D = cmd.ExecuteReader</FONT></P> <P><FONT face=3DArial size=3D2>Do While rdr.Read<BR></FONT><FONT = face=3DArial=20 size=3D2>   =20 combo.Items.Add(rdr("schedkey").ToString.Trim)<BR></FONT><FONT = face=3DArial=20 size=3D2>Loop</FONT></P> <P><FONT face=3DArial size=3D2>Error_Exit:<BR></FONT><FONT face=3DArial=20 size=3D2>    If Not IsNothing(rdr) Then<BR></FONT><FONT = face=3DArial=20 size=3D2>        = rdr.Close()<BR></FONT><FONT=20 face=3DArial size=3D2>       =20 cmd.Connection.Close()<BR></FONT><FONT face=3DArial = size=3D2>   =20     cmd.Dispose()<BR></FONT><FONT face=3DArial=20 size=3D2>        = cnn.Close()<BR></FONT><FONT=20 face=3DArial size=3D2>       =20 cnn.Dispose()<BR></FONT><FONT face=3DArial size=3D2>    = End=20 If</FONT></P> <P><FONT face=3DArial size=3D2>    rdr =3D = Nothing<BR></FONT><FONT=20 face=3DArial size=3D2>    cmd =3D Nothing<BR></FONT><FONT = face=3DArial=20 size=3D2>    cnn =3D Nothing<BR></FONT><FONT face=3DArial = size=3D2>Exit=20 Sub</FONT></P> <P><FONT face=3DArial size=3D2>Error_Handling:<BR></FONT><FONT = face=3DArial=20 size=3D2>    Select Case Err.Number<BR></FONT><FONT = face=3DArial=20 size=3D2>    Case Else<BR></FONT><FONT face=3DArial=20 size=3D2>        MsgBox("The following = error occured=20 in LoadSchedules()" & vbCrLf & Err.Description)<BR></FONT><FONT=20 face=3DArial size=3D2>    End Select</FONT></P> <P><FONT face=3DArial size=3D2>Resume = Error_Exit</FONT></P></DIV></BODY></HTML> ------=_NextPart_000_0006_01C8155A.951AF170-- Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142100
  - 20
    - Sybase AsaClient and DbProviderFactories Hello all, My team is trying to use the iAnywhere.Sybase.Asaclient (middle part might be spelled incorrect) in our C# project with a DbProviderFactory class to generate new code. However when we try to create a new factory with DbProviderFactory factory = DbProviderFactories.GetFactory("iAnywhere.Sybase.Asaclient). This returns an ArgumentException to us. Is there something special we need to install or do to be able to use Asaclient objects with the ADO.NET factories? Thanks in advance Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142096
  - 21
    - Decimal data type wont work! I have a SQL Express db with a table field defined as data type decimal(18,0). When I type in .785 in the table field it rounds it to 1. Any ideas why???? Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142093
  - 22
    - Question about finding records using Stored Procedures I have a table called Customer. I have a locator screen which is composed of a grid and a couple of search boxes. The user is going to choose which customer records to display in the grid. The choices are LastName or firstName or any part of them, Social Security Number, Status (Active,Inactive, etc.) and office. Now the user can choose to find all customers who are active and from a certain office or they could find all the customers whose last name starts with S and is active and from a particular office. In the past, I looked at each search field and built a where clause which was then passed to a select statement to retrieve the correct records. I am not happy doing this and want to switch to stored procedures. When the user clicks the 'Find' button after filling in some search fields, I will create an empty customer object and fill in the fields that are in the search screen and this past this object to the server. On the server, I will parse the object and figure out which fields have values in them meaning that they are to be part of the search critieria. Once I have done that, then I will call the appropriate Find method for the cusotmer. That is my dilemma. Do I have the followng in my code? FindCustomerBySocSecNo(string socsecno) FindCustomerByLastName(string lastname) FindCustomerByOffice(string office) FindCustomerByStatus(string status) FindCustomerByStatusAndOffice(string office,string status) FindCustomerByLastNameStatusAndOffice() etc. etc. etc. This seems like a lot of work to do. Bill Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142091
  - 23
    - Question about SUM query I have a "transaction" table with 2 columns, TransTypeId and TransAmt. Example: TransTypeId TransAmt A 100 A 200 B 100 C 50 B 100 A 100 I am trying to do a SUM of all the TransTypeId A and B. The result should be 600. I WANT TO GET ONLY THIS 1 VALUE BACK. But, the result of the query is returning... A 400 B 200 It's not summing it as a "group", but per "TransTypeId". Any ideas why? Here's the raw query... ( SELECT SUM(Transactions.TransAmt) AS Expr1, Enroll.ProgramId, Enroll.EnrollId FROM Transactions INNER JOIN Enroll ON Transactions.EnrollId = Enroll.EnrollId GROUP BY Enroll.ProgramId, Enroll.EnrollId, Transactions.TransTypeId HAVING (Enroll.ProgramId = @ProgramId) AND (Enroll.EnrollId = @EnrollId) AND (Transactions.TransTypeId = 1 OR Transactions.TransTypeId = 2 OR Transactions.TransTypeId = 3) Thanks! Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142087
  - 24
    - i have a problem . please help me Hello, I am writing ASP.NET application using SQL Server 2005 Express Edition. my connection string is : "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\DB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"; I used connection strings syntax from www.connectionstrings.com. this app work in IIS very well but when i upload it on the host i reiceve this error : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) please help me if you can ? *** Sent via Developersdex http://www.developersdex.com *** Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142083
  - 25
    - How sluggish is a big xml file in combination with datasets? Hello, I am currently working on a project which will run in an environment, where the size of the database is very limited. That's why I thought about relying in some parts entirely on xml files (and datasets) as an DB replacement. I.E.: DataSet myDataSetToRead = new DataSet(); myDataSetToRead.ReadXmlSchema("c:\\abcd.xsd"); myDataSetToRead.ReadXml("c:\\abc.xml"); dostuff with the dataset data etc. Now, I will doing this only for the little used parts application, where maybe 5 users at once will use it. I know that this approach is slow compared to a real DB, but, what are the other limitations? Is there a size limit? I mean, will it somehow break after the file reaches 50 MB? And how much slower will it be, compared to a DB? 10 times slower? More? Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142079
- Next
  - 1
    - Install SQL Server 2005 Express With ClickOnce? Is it possible to install SQL Server 2005 Express on a machine that restricts installs by using ClickOnce? For example, I can't install new applications on my machine at work unless I use ClickOnce to do so. I want to be able to use SQL Server 2005 Express in my applications and move away from MS Access. Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142078
  - 2
    - Ajax enabled page Oct 20, 2007 01:00pm Hi all When you create an Ajax enabled web site, the application creates the default page with a "Script Manager". I created a Master Page. I then created a "Home" page with reference to this master page. As I wanted this Home Page to come first I added the following code to the default page Server.Transfer("Home.aspx", True) My questions are: 1. To ensure that Microsoft Ajax toolkit works, does the default page with the "Script Manager" has to be the first page. 2. Can I give the reference of the Master Page on the "Default Page" so that I get the template I require. Then the "Default Page" can be my first page. Thank you in advance. Mike TI Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142074
  - 3
    - Obtaining column properties in .NET Hi all, I want to obtain column properties using C# and the System.Data namespace. Using DbDataReader.GetSchemaTable() or DataAdapter.Columns I only retrieve properties like DataColumn.MaxLength or DataColumn.AllowDbNull in a correct fashion. But if I want properties like DefaultValue or certain column validation rules, I fail. Does anyone know how to obtain these values? If so, please post some sample code or links. Thank you very much in advance. Regards, Hannes Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142059
  - 4
    - HP Desktop for sale! Hi, I have an unused HP Pavilion with the fallowing specs: # Processor: AMD Athlon 64 X2 4000+ (2.1GHz, 2000MT/s System Bus) # Memory: 2048MB PC2-5300 DDR2 SDRAM memory (2x1GB) (expandable to 8 GB (4 x 2 GB) (64-bit OS)/ 4 GB (4 x 1 GB) (32-bit OS)) # Hard Drive:320GB 7200RPM SATA 3G (3.0 Gb/sec) hard drive # Optical Drive: 16X DVD(+/-)R/RW 12X RAM (+/-)R DL LightScribe SATA drive # Expandable Drive Bay: HP Pocket Media Drive bay # Video Graphics: Integrated graphics # Network Interface: Integrated 10/100BaseT network interface # Sound: High Definition 8-channel audio # Fax/Modem: 56K bps data/fax modem # Operating System: Genuine Windows Vista® Home Premium This is "used" but basically brand new (it has literally been on for no more than 6 total hours..) is only 1 month old.. PRICE: $425 OBO Email- pbdude911@yahoo.com Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142050
  - 5
    - Fatloss computer program I have been using this computer program for a couple weeks now and i am very pleased with the results so far. its a software fatloss program, if your looking for a diet/weightloss plan i reccomend you check this place out first: http://fatloss9.50webs.com Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142048
  - 6
    - Watch NFL Games Online Watch NFL Games Online! For every one who wants to watch the games online because they dont live in the teams town or are at work i found a site that has basically every game covered. Its perfect if you have afford a monthly $70 direct tv nfl access subscription. they got a bunch of channels The sites http://nflonline.wizhoo.com Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142047
  - 7
    - ReadXML error I'm using DataSet.ReadXML method to populate the dataset with data from XML file. If one of the values contains apostrophe (for instance: It's something) then an error occures: System.Xml.XmlException: Invalid character in the given encoding. Is this a bug or what? I wouldn't want to parse an XML created by another program which is using the same ADO.NET for creating the file. On that side apostrophe is allowed. Thank you vovan Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142046
  - 8
    - vs 20028 when?? Hi When is vs2008 due out? Many Thanks Regards Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142040
  - 9
    - Reading a XLS file with a embeded combo Hi, I=B4m trying to read a xls file which one colum has a combo to select the value. The value is linked to the cell below the combo, however in certain columns the ado.net returns null value instead of the value selected. Is there anything I=B4m missing? I remember the bug in ADO when reading columns with multiple formats. Thanks, Ezequiel Naftali Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142039
  - 10
    - Data Type 'Image' is missing from the development environment for Please disregard my previous post for the same problem. the posting was incomplete. I'm trying to update the data in a DataGridView control. The underlying data are from SQL Server CE database. There is an image field in the DataGridView control when U give the save command, I get the following message. "@p5 : Byte array truncation to a length of 8000." Parameter corresponds to the image field. In the parameter, it is displayed as a Binary. However, I cannot see the type 'Image' in the list of data types. -- test Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142037
  - 11
    - ComboBox loads slow I am noticing that it seems to take windows a long ass time to paint a ComboBox control that has say, 32000 items in its dropdown. Yes, I know that's a lot. However, I have a VB6.0 application that uses DAO to access an Access database, and it can load up a 32000 item combobox in a fraction of the time it takes .net 2.0. Why is this? Also, it seems like setting the .DataSource property takes a while, but the bulk of the wait time is when the control gets drawn on the screen. Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142030
  - 12
    - Filtering DataSet with Multiple Tables I have a DataSet with 3 tables. I need to be able to filter the parent table and get all records from the 3rd level table that correspond with it. I have relations set up between the parent and first child and also the first child and it's child tables. However, when I filter the top level table, it doesn't appear to filter the other tables. How can I do this? Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142029
  - 13
    - How do I merge tables in ado.net Hi, I'm fairly new to ado.net and I'm not sure I'm doing this in the best way... I retrieve two tables from two different databases and place them in a dataset. Both tables have a column which relates them. The relation type is one to many. I use a custom procedure to "merge" the two tables into a third before I display the third table in a datagrid. The procedure creates a new table and iterates through the two tables using a relation object and GetChildRows. Is this how it should be done or is there a built in function that can do the work for me? Regards Pete Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142027
  - 14
    - QueriesTableAdapter does not appear in toolbox. Why not? I created a stored procedure called AddOrder which does an 'insert' statement. It appeared in the Server Explorer of Visual Studio. Then I dragged it to the Dataset Designer. This makes a QueriesTableAdapter, which I do find in the diagram when I "Edit Dataset in Designer". The problem is that this QueriesTableAdapter does not appear in the ToolBox, so I cannot drag it on to forms. Is there any reason why it doesn't show up in the toolbox? Is there some way to drag it to the form? Thanks, HA Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142018
  - 15
    - SQLBulkCopyOptions with Default values Hello. I'm changing my code which copies data from memory to a SQL Server from using a data adapter's update method to using the writeToServer method of the SQLBulkCopy object. The update method of the data adapter worked fine, but I expect the SQLBulkCopy to perform better. The problem is I'm getting an error message that one of the fields doesn't allow null values. With the data adapter, I didn't explicitly have to set the fields to anything, as the fields have a default value of zero defined on the server. I'm using the SQLBulkCopyOption KeepIdentity and even tried using (Not SqlBulkCopyOptions.KeepNulls), but still get the error. Does SQLBulkCopy not recognize default values unless the field value is explicitly set to null? That's the next thing I'm going to try, and if it doesn't work, I'm going back to using the data adapter. Thanks for any information you can provide. Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142012
  - 16
    - dbType 'Image' not available in the data adaptor window for CE How come there is no dbType='Image' available in the data adaptor parameter types? Please find the atta -- test Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142011
  - 17
    - Cross network Access db connection problem Hi I wonder if you can help me. I've got an asp.net (version 1.1) intranet application that connects across a network to an access backend db. The backend db is on a directory where everyone (including the ASP.Net account) has full access (not sure if that's the right way to go about things but it works). However my application now needs access to some information from another network access db, which is on a directory where everyone (including the ASP.Net account) has read & execute rights. When I try and open a connection I get the "you can't do this because the db is already opened exclusively by another user" message. I can't, and don't want to, change the directory rights to the second db and it's in constant use so I can't kick people out. Is there any way around this? Thanks for your help in advance. Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142008
  - 18
    - adapter.Update question ?? Dear all, I have an application sQL statement which call an SQL view. The return dataset from the View is bind to a WinForm datagriview control. From this datcontrol, data can be edited and updated. What I woul like to get is that this modification goes back to the View at SQL server side which will then update proper table. The call method which will get that modification back is done as follow : =====> public static Boolean UpdateAlarm(string ConnectionString,DataSet dsSource) { //Connection definition using (SqlConnection sqlConnection = new SqlConnection(ConnectionString)) { // Request Definition using (SqlCommand sqlcommand = new SqlCommand()) { sqlcommand.Connection = sqlConnection; sqlcommand.CommandType = System.Data.CommandType.Text; sqlcommand.CommandText = "Select * from v_Current_Alarm"; try { sqlConnection.Open(); SqlDataAdapter adapter = new SqlDataAdapter(sqlcommand); adapter.Update(dsSource,dsSource.Tables[0].TableName); sqlConnection.Close(); } <=== What is strange from that is that if I Watch the dsSource object, modification are seen inside Rows.ItemArray, but the RowsState is set to "Unchanged" Then my Update function of Adapter seems to not modiy anything on the back end database. Any ideas what I do wrong ? regards serge Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142006
  - 19
    - Stored procedure name in config file? Hi all, I'm building a Web Service to INSERT records into an Oracle DB. For this I'm using a DataSet (.xsd) with a QueriesTableAdapter, to call a stored procedure for inserts in the Oracle DB. The connection string is stored in a configuration file (Web.Config) like so: <connectionStrings> <add name="conn_oracle" connectionString="Provider=MSDAORA;Data Source=mydb;Password=mypwd;User ID=myuser" providerName="System.Data.OleDb" /> </connectionStrings> The name of the stored procedure is set in a wizard when you create the QueriesTableAdapter and it's then stored in the CommandText property. I would like to make this name configurable by storing in the configuration file too, like so: <appSettings> <add key="insert_command" value="myInsertStoredProcedureName"/> </appSettings> Is a there a way to get this value at run-time and use it in the query? Gustaf Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 142003
  - 20
    - Timeout expired on Insert Hi, We have a huge table having around 29579242 Rows.The table is huge and there is no clustered index on the table. There are a couple of non-clustered indexes. We have started experiencing these errors. We increased the command timeout to 120 (2 minutes) but the error isstill occuring on Insert. Data is being inserted 1 row at a time and is not transactional. Any ideas? Thanks Sandhya With the Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 141997
  - 21
    - How to Provide Unique Key Values During DataContext.SubmitChanges I am using Visual Studio 2008 Beta 2 and investigating various aspects of LINQ. I used the LINQ to SQL designer to derive a new DataContext class with some entity classes, and am overriding the behavior of SubmitChanges and implementing the Insert partial method for a particular entity class's insert operation. I'm doing this because I'm dealing with a black-box SDK that updates data in the database according to its own business rules, but I'd like to be able to access this SDK via LINQ. So I've constructed entity classes in the designer based on the tables accessed by the SDK, and am only going through the SDK on updates and inserts. The problem is, this SDK is not row-based. It does not update the database until an object and all its children have been provided (which is important when inserting a write-once object). The data does, however, have the notion of a primary key (as do the SQL tables underlying the data). So DataContext wants values in there after every insert I guess. My first question is, if I don't call ExecuteDynamicInsert and instead perform the update through the SDK, how to I provide a unique key value back to the DataContext? Right now, if I add multiple rows in a single SubmitChanges operation, I receive an exception: System.Data.Linq.DuplicateKeyException I assume this is because the primary key values in the entity class instances were left as null and I see no way to fill them in from the derived DataContext methods (the primary key property is read-only, and the internal storage for the property is private). My next question is, is there a way to implement a system where the primary key values are not known until all the Insert and Update operations are complete (at the end of SubmitChanges). Right now the error is happening as soon as the second Insert operation completes (the first duplicate empty key is noticed). I have considered implementing some entity class partial method like OnValidate to provide a dummy unique key in there (by directly setting the private member variable), then at the end of SubmitChanges, turning off ObjectTrackingEnabled and providing the actual key values, but I suspect the framework won't like me changing ObjectTrackingEnabled after the initial query. Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 141996
  - 22
    - stored procedure times out after 10 minutes Hello. Can anyone help with this one? I've written an app that queries data on two linked servers (sql server 2000). The stored procedure runs fine when I 'exec' it in management studio, but it times out when launched from VB2005. The funny thing is it worked last week - I'm just not sure what has changed since then. Here's (some of) my vb source Dim Conn As New System.Data.SqlClient.SqlConnection(My.Settings.ModelstockConnString) Dim Cmd As New System.Data.SqlClient.SqlCommand Dim sqlstr As String Cmd.CommandTimeout = 600 Cmd.CommandType = Data.CommandType.Text Conn.Open() Cmd.Connection = Conn Dim dr As System.Data.SqlClient.SqlDataReader = Nothing Dim dtms As New System.Data.DataTable sqlstr = "exec MWLBringToModelstockQuery '" & DataGridView1.Rows(0).Cells("cCustNo").ToString.Trim & "'" Cmd.CommandText = sqlstr dtms.Load(Cmd.ExecuteReader) Here's my connection string Data Source=TESTSERVER;Initial Catalog=TESTDB;Integrated Security=True Here's my SP: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER procedure [dbo].[MWLBringToModelstockQuery] ( @custno nchar(10), @itemno nchar(20) = '', @storeno nchar(10) = '' ) as Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 141991
  - 23
    - "@p5 : Byte array truncation to a length of 8000." I'm trying to update the data in a DataGridView control. The underlying data are from SQL Server CE database. There is an image field in the DataGridView control when U give the save command, I get the following message. "@p5 : Byte array truncation to a length of 8000." Parameter corresponds to the image field. In the parameter, it is displayed as a Binary. -- test Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 141989
  - 24
    - UTF32 and XML Datatype This is a multi-part message in MIME format. ------=_NextPart_000_0013_01C80FFA.4DA1A920 Content-Type: text/plain; charset="Utf-8" Content-Transfer-Encoding: quoted-printable I need to add a UTF32 xml file to an XML datatype (basically I want = unicode characters in there) is it possible? When I do=20 SqlParameter x =3D new SqlParameter("@xmlX", SqlDbType.Xml); (i = tried Text or Ntext in vain !!) testclass t =3D new testclass(); t.Age =3D 32; t.FirstName =3D "=DB=9D =DA=AE=DA=85=D9=B1=D9=8F=D8=B5=D8=9F =DB=9E"; t.LastName =3D "Silver"; t.Locality =3D "USA"; XMLSerializer<testclass> _serializer =3D new = XMLSerializer<testclass>(); x.Value =3D _serializer.Serialize(t); (This gives me a UTF-32 XML = file) cmd.Parameters.Add(x); cmd.ExecuteNonQuery(); I get an error : XML parsing: line 1, character 39, unrecognized = encoding. Evan ------=_NextPart_000_0013_01C80FFA.4DA1A920 Content-Type: text/html; charset="Utf-8" Content-Transfer-Encoding: quoted-printable =EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8"> <META content=3D"MSHTML 6.00.6000.16544" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>I need to add a UTF32 xml file to an = XML datatype=20 (basically I want unicode characters in there)</FONT></DIV> <DIV><FONT face=3DArial size=3D2>is it possible?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>When I do </FONT></DIV> <BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px"> <DIV><FONT face=3DArial size=3D2>SqlParameter x =3D new = SqlParameter("@xmlX",=20 SqlDbType.Xml);   (i tried Text or Ntext in vain = !!)</FONT></DIV> <DIV><FONT face=3DArial size=3D2>testclass t =3D new = testclass();</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>t.Age =3D 32;</FONT></DIV> <DIV><FONT face=3DArial size=3D2>t.FirstName =3D "=DB=9D = =DA=AE=DA=85=D9=B1=D9=8F=D8=B5=D8=9F =DB=9E";</FONT></DIV> <DIV><FONT face=3DArial size=3D2>t.LastName =3D "Silver";</FONT></DIV> <DIV><FONT face=3DArial size=3D2>t.Locality =3D "USA";</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV dir=3Dltr><FONT face=3DArial = size=3D2>XMLSerializer<testclass>=20 _serializer =3D new XMLSerializer<testclass>();</FONT></DIV> <DIV dir=3Dltr><FONT face=3DArial size=3D2>x.Value =3D = _serializer.Serialize(t); =20 (This gives me a UTF-32 XML file)</FONT></DIV> <DIV dir=3Dltr><FONT face=3DArial = size=3D2>cmd.Parameters.Add(x);</FONT></DIV> <DIV dir=3Dltr><FONT face=3DArial=20 size=3D2>cmd.ExecuteNonQuery();</FONT></DIV></BLOCKQUOTE> <P><FONT face=3DArial size=3D2>I get an error : </FONT><FONT = face=3DArial size=3D2>XML=20 parsing: line 1, character 39, unrecognized encoding.</FONT></P> <P><FONT face=3DArial size=3D2>Evan</FONT></P></BODY></HTML> ------=_NextPart_000_0013_01C80FFA.4DA1A920-- Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 141983
  - 25
    - The DataTable / DataSet size Hi, We do ADO.NEt programming only on the time-to time basis, so we don't have the real deep experience in this matter. Every where in MSDN or other documentation I can read that DataTable/DataSet is designated to keeping disconnected data from a database. So far, so good. But I have never seen any recommendation about how (or when) to control the size of these objects. For example letâ??s say we have a table that can be small at the beginning and we keep this small amount of records in a disconnected DataTable object. After several months the size of the table in a SQL database can grow to several-docents of thousand records. How should the client side application respond to this change, or, when we should start to worry about the size of fetched data? I know it depends from available memory and so onâ?¦. But anyway, what is your typical size of DataTable object (MBs, number of recordsâ?¦). Thanks, Lubomir Tag: ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Tag: 141962

Hi, All:

UDAParts has updated .NET versions of SocketProAdapter at www.udaparts.com
for supporting binary remoting .NET ADO.NET objects, DataSet, DataTable and
DataReader.

Key features and improvements over MS technologies are:

1. Bi-directional remoting DataSet, DataTable and DataReader across desktop
and smart devices.

2. Bi-directional remoting DataSet, DataTable and DataReader across
different .NET runtime versions (1.0, 1.1, 2.0, .....).

3. Significantly faster (1 - 6 times) than MS .NET remoting and MS WCF.

4. Significantly reduce transaction latency without using worker threads.

5. Consume significantly less memory and much smaller footprint.

6. 100% open source code (C++/CLI and C#) for your reviewing. It is highly
extensible.

7. Secure through SSL/TLS.

8. Built-in real-time notification,

9. Integrated or user defined authentication.

10. Built-in online compression.

......

Samples for VB.NET and C# are available at
..\udaparts\SocketPro\samples\RAdo after you downloading latest version
(4.8.2.19) of SocketPro

Soon, UDAParts will provide a short article for describing remoting ADO.NET
objects through SocketPro using batching, asynchrony and parallel
computation.

www.udaparts.com

Top