Underlying (SQL Server) DataTypes for Columns in a DataSet?

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
 - sqlcommand I am trying to come up with a generic way of generating an insert statement widh command builer then additional parameter to the insert command so I can get the id of new records back. Once I get the inserrt command from sql command builder any changes I make do not get reflected when the intert command runs. i have to copy the information to a new sqlcommand and use it. If I query the commandtext it has been updated but the updated version does not run. Any ideas why the changes to not get updated. I am updating a sql 2005 server with this. The following code works but I am looking for a way to make the changes without needing a second sqlcommand private sub updrec() Dim cn As New SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind") Dim sql As String = "select CategoryId,CategoryName,Description from categories where CategoryID='105'" Dim sqlData As New SqlDataAdapter(sql, cn) Dim prm As SqlParameter Dim sqlBld As New SqlCommandBuilder(sqlData) Dim OsqlCmd As SqlCommand = sqlBld.GetInsertCommand cn.Open() Dim nSqlCmd As New SqlCommand OsqlCmd.CommandText += " set @CategoryID = SCOPE_IDENTITY()" prm = New SqlParameter("@CategoryID", SqlDbType.Int, 0, "CategoryID") prm.Direction = ParameterDirection.Output OsqlCmd.Parameters.Add(prm) nSqlCmd = OsqlCmd.Clone Dim sqlCmd As New SqlCommand(OsqlCmd.CommandText, cn) CopyParams(OsqlCmd, sqlcmd) ' sqlData.InsertCommand = sqlCmd sqlData.UpdateCommand = sqlBld.GetUpdateCommand sqlData.DeleteCommand = sqlBld.GetDeleteCommand TextBox2.Text = sqlData.InsertCommand.CommandText Dim myDs As New DataSet sqlData.Fill(myDs, "Categories") myDs.Tables(0).Rows(0).Item("Description") = "freddy" Dim mYrow As DataRow mYrow = myDs.Tables(0).NewRow mYrow.Item("categoryname") = "cat1" mYrow.Item("description") = "Desc1" myDs.Tables(0).Rows.Add(mYrow) mYrow = myDs.Tables(0).NewRow mYrow.Item("categoryname") = "cat1" mYrow.Item("description") = "Desc1" myDs.Tables(0).Rows.Add(mYrow) sqlData.Update(myDs, "Categories") 'myDs.GetChanges() end sub Private Sub CopyParams(ByVal oldCmd As SqlCommand, ByRef NewSqlCmd As SqlCommand) Dim oParam As SqlParameter Dim NPrm As SqlParameter For Each oParam In oldCmd.Parameters NPrm = New SqlParameter(oParam.ParameterName, oParam.SqlDbType, oParam.Size, oParam.SourceColumn) NPrm.Direction = oParam.Direction NewSqlCmd.Parameters.Add(NPrm) Next End Sub Thank You Tag: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142266
 - 2
 - xcopy deployment to sql server DTS package in restricted environme Hello. I'm an old VB6 programmer who would like to distribute an .exe with the simplest method possible, and that's not working. I have an application which updates rows on a SQL Server. If I run the .exe in my project's debug folder, it runs fine. If I run it from my project's release folder, I get a sqlClientPermission error when it tries to update data on the server. I don't have administrative rights to my PC, so I'm assuming I have to live with this or find someone with admin rights to grant me permission to run the release version of my application on my PC. If I run it copied to a folder on the network, I get the same error, but what I really need is for it to run in a DTS package on our SQL Server so it can be scheduled to run nightly. The release .exe gets the same error in the DTS package, and I'm not sure who needs to do what to get this to work. The debug.exe runs ok in the DTS package as long as my sps have dbo ownership. I'm not sure if I need to create a setup project and have the DBA install the .exe on the sql server, have some administrator (not our DBA) grant client access permissions to my .exe on the sql server, or some other set of magic tricks. Distributing applications used to be easy, but now it's harder and muddling through documentation on code access security is frying my brain. Please help me if you can. Thanks for all replies, -Beth Tag: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142260
 - 3
 - Fastest way to move XML document into and back out of CLR function Fastest way to move XML document into and back out of CLR function In SQL Server 2005 and Visual Studio 2005, what is the fastest way to pass an xml data type variable into a C# CLR function and retrieve it back out of the C# CLR function when the C# CLR function is done modifying it? I tried this but get deployment error becuase SQLServer2005/CLR dotn support System.Xml.XmlDocument: public partial class UserDefinedFunctions { [Microsoft.SqlServer.Server.SqlFunction] public static int InsertSomeNode(System.Xml.XmlDocument pDoc) { // return 1; } }; thorws error: Error 1 Column, parameter, or variable #1: Cannot find data type XmlDocument. InsertSomeNode Tag: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142253
 - 4
 - Generics? Hi I am fairly proficient in vb6 and vb.net but I am baffled by generics. What are generics about and can I make use of them in my winform vb.net database applications? Many Thanks Regards Tag: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142252
 - 5
 - ADO Net examples October 31, 2007 Hi all Can someone point me out to a site with some good examples of data file manipulation. Thank you Mike TI Tag: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142243
 - 6
 - Connections String Questions Oct 31, 2007 Hi all Sorry for repeating my previous posting. I am new to VB Net. Q1. Which provider should be preferred when defining a connection, Data provider for SQL server or Data provider for OLEDB. I intend to use SQL Express 2005. Q2. I have a database on my local PC (SQL Server Express) and the same database on a remote PC. I built a simple form with a grid. Now I want to define the connection string in such a way that I am able to use any one of the above two by changing the connection string definition on one place. How do I go about this. Thank you in advance. Mike TI Tag: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142241
 - 7
 - vs2008 Hi What are the advantage of vs2008 over vs2005? Thanks Regards Tag: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142239
 - 8
 - Elementary question on connection string Oct 30, 2007 Hi all Using VB.Net 2005 & SQL 2005. I tried to use a database on my local PC and a remote database. Now is there a way I can make the connection string flexible. I tried to change the connection string in the APP.CONFIG file however I was not successful. It would be nice if I am able to store the connection string in some kind of a text file. What I may be doing wrong. Mike TI. Tag: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142233
 - 9
 - is there anything like XmlDocument.ImportNode but for SQL Server XQuery? is there anything like XmlDocument.ImportNode but for SQL Server XQuery? Tag: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142232
 - 10
 - How is fastest way to construct an XML node then a bunch of slow xquery How is fastest way to construct an XML node then a bunch of slow xquery modify statements? This SQL Server 2005 logic is rather slow to simply add a new item to an xml document. Any way to do this all in one statement and faster for creating a new node without having to re-select to set the attribute values? set @currentItems.modify('insert <Item></Item> as first into (/Items/ParentItem[(@id=sql:variable("@parentItemID"))])[1]') set @currentItems.modify('insert (attribute id {sql:variable("@itemID")}, attribute length {sql:variable("@metadataLength")}, attribute activityDate {sql:variable("@activityDate_xml")}) into (/Items/ParentItem[(@id=sql:variable("@parentItemID"))]/Item)[1]') set @currentItems.modify('replace value of (/Items/ParentItem[(@id=sql:variable("@parentItemID"))]/@totalCount)[1] with ((/Items/ParentItem[(@id=sql:variable("@parentItemID"))]/@totalCount)[1] + 1)') set @currentItems.modify('replace value of (/Items/ParentItem[(@id=sql:variable("@parentItemID"))]/@lastModified)[1] with sql:variable("@lastModified_xml")') One idea is to do this in a CLR function that uses a simple string builder to create the node, but then it has to be reserialized and there is CLR overhead. Any ideas on how to make this faster? Tag: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142231
 - 11
 - FillSchema and stored procedure IF statements I'm trying to use FillSchema to get the results schema for a stored procedure that, simplified, does this: CREATE PROCEDURE SomeProc @Flag bit AS IF @Flag = 1 SELECT 'foo' = 'bar' SELECT TOP 5 'baz' = snafu FROM SomeTable GO If I then call objSQLCommand.CommandType = CommandType.StoredProcedure objSQLCommand.CommandText = "SomeProc" objDataAdapter.MissingSchemaAction = MissingSchemaAction.Add objDataAdapter.SelectCommand = objSQLCommand objDataAdapter.FillSchema(objDataSet, SchemaType.Source) objDataAdapter.Fill(objDataSet) with @Flag = 1, I get the correct dataset back: two tables, the first with one column called 'foo' and one row, the second with one column called 'baz' and 5 rows. However, if I call this code with @Flag = 0, what I get back are two tables, the first with two columns called 'foo' and 'baz' and 5 rows, and the second with one column called 'baz' and no rows at all. This seems to be because the FillSchema goes down into the IF @Flag branch in my stored procedure for schema information regardless of the value of @Flag and that then the DataAdapter.Fill is putting its one table of data into the first available table. My question is, what other options do I have for getting the schema information here? Can I change this behavior of FillSchema's? In this particular instance I could skip the FillSchema step entirely if I know that @Flag <> 1, but I'd really prefer a more general solution that would allow me to put more branches in my stored procedure if they're needed someday. Thanks, Caitlin Shaw Tag: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142229
 - 12
 - Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. We have a several vb.net apps, that were recently upgraded from Framework 1.1 to Framework 2.0. Randomly these apps have started throwing the error below, the line of code is a connection.open, the connection string has a timeout of 500, which should be plenty of time. All of the apps use the same data layer class (happens on the same line of code). It doesn't happen every time, it's just random and it happens on the connect open not when executing the command(an insert into a large table). Anyone have any suggetions? The Source was: .Net SqlClient Data Provider 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) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at PSXSTL.Digecenter.LookupDataReference.insertDB() in C:\$\Digecenter\PSXSTL.Digecenter\Archives\LookupDataReference.vb:line 558 Target Site: Void OnError(System.Data.SqlClient.SqlException, Boolean) Additional Info: Error occurred in PSXSTL.Digecenter.LookupDataReference/insertDB 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) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at PSXSTL.Digecenter.LookupDataReference.insertDB() in C:\$\Digecenter\PSXSTL.Digecenter\Archives\LookupDataReference.vb:line 558 For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Thanks in advance! Rick Tag: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142219
 - 13
 - User default schema Hi Using SQLServer2005, connecting via sql server authentication. In the Instance I created a database (MyDatabase) and a Login. In MyDatabase I created a schema (MySchema), Tables (attached to MySchema) and a User (based on the Login). I set the Login's default database to MyDatabase. I set the User as MySchema's owner. When I connect to the database via SMSE, I can successfully issue SQL statements without using the MySchema prefix on the Table names. If I connect to the database via C# and SqlClient (again using sql server authentication), and issue a query command (without a MySchema prefix) I get an error stating that my table object does not exist, (indicating that it is ignoring the default schema for the User). If I use the prefix the query runs fine. My mindset is that the default schema used by the connection should be that stated in SqlServer for the given user (in this case MySchema). However the observed behaviour is suggesting that I need to do more in order to ensure that MySchema is used as the User's default schema. So two questions: Am I understanding of this problem correct? How can I ensure that when I connect via ADO.NET that the connection will use the default schema attached to the user? Regards Aidan Tag: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142204
 - 14
 - Creating a new Access database file (.mdb) in .NET/C# I'm making changes to a small, portable, single-user database application I wrote a couple of years back built around a muli-table Access database and written in C# and .NET 1.1. Most of the changes are are minor, but one involves "subsetting" the database, that is, creating a new database file (.mdb) with a subset of the current database's rows. Read in a schema and some tables from one database / file, write them out to a brand new database / file. Right? Well, either I'm being incredibly dense, or this is an extremely non-trivial task. Since it's difficult for me to imagine that 'CREATE' support wouldn't be hidden _somewhere_ in .NET's OleDb support, I'm hoping that if I describe what I've tried someone will put me out of my misery with a few, well-chosen -- but helpful -- comments on my obtuseness. <grin?> Reading tables from the original database ("Filling") into DataTables in a DataSet is fairly straightforward, and the 'web abounds with examples of how to do this. Creating a new DataSet with a duplicate schema isn't hard, either: DataSet dsClone = dsOriginal.Clone(); followed by selected row-copies from the old to the new via DataViews: dsClone.Tables[tname].ImportRow( dv[i].Row ); Then you open a connection to the new database-to-be: OleDbConnection connDb = new OleDbConnection(); connDb.ConnectionString = DbConnString1 + filename + DbConnString2; connDb.Open(); Whoops! - If the file name doesn't already exist, you get an exception. - If the file exists but hasn't been Access-initialized, you get an exception ("wrong file structure" or something similar). So either there is a secret substring I need to include in my ConnectionString ("...Mode=Create;..." ?) to prepare the file for a CREATE-like operation, or the file structure has to be "built" / initialized prior to opening the Connection. There's got to be some step there that I'm overlooking. Hints would be appreciated. If I can't figure out how to do this, my fallbacks include: 1) Byte-copying the current .mdb file -- while it's open -- under a new name, opening ("connecting to") the new file, and then emptying some tables and chopping out rows from others (and maybe doing a compress-in-place on the result), 2) Adding an Empty-Db.mdb file ("...just the Schema, Ma'am") to the package that would only be used for subsetting the database, following the steps in option (1), or 3) Reverse-engineering the .mdb file structure and coding the creation of a new one "by hand". (No, I'm not serious -- or not entirely serious-- about this one, just frustrated enough to start thinking anlong those lines.) 4) Embedding a binary string containing a complete (but table-less) .mdb file into my applic... no, let's not go there. (But it _would_ be portable. <grin!>) Please, someone, point out to me that I've been repeatedly reading past an OleDbConnection.OpenNew() method that does exactly what I'm trying to do... or something along those lines! <grin> Frank McKenney -- "The most amazing achievement of the computer software industry is its continuing cancellation of the steady and staggering gains made by the computer hardware industry..." -- Henry Petroski -- Frank McKenney, McKenney Associates Richmond, Virginia / (804) 320-4887 Munged E-mail: frank uscore mckenney ayut minds pring dawt cahm (y'all) Tag: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142200
 - 15
 - How much of the functionality of SQL Server is mirrored in ADO.Net Ok, bear with me. This is a bit lengthy. This roughly explains a real-life legacy data structure problem Iâ??m having. Assume a SQL Server 2000 database with 2 tables, Table1 and Table2. Table1 has fields id1 (Integer, primary key, but NOT an identity field) and content (varchar 10). Table2 has fields id1 (integer), id2 (integer, identity field) and content (varchar 10). The primary key of Table2 is id1/id2. The 2 tables are joined by a relationship in which table1/id1 is the foreign key of table2/id1. Also the options are set to cascade updates and deletes. Now I go into SQL Server Enterprise Manager and: 1. Create a Table1 record with an id1 = 1 2. Create a Table2 record with an id1 = 1 3. I then go back into Table1 and change id1 to a value of 2. The change is immediately reflected in the Table2 record. Thatâ??s exactly what I expected and wanted. Now the big question â?? can I get ADO to do the same thing in memory? Now I create a Winforms app in VB/Dot Net 2.0. I add a dataset (xsd) to the project and drag tables 1 and 2 onto the designer simultaneously so that the relationship comes too. I then create a minimal class inheriting from the dataset so I can fill Tables 1 and 2 from the server. I add a pair of DataGridViews to the form to display Tables 1 and 2. If I update Table1, id1, update to the database and reload the data, the changes are reflected in Table2 as expected. What I cannot figure out is how to immediately show the changes in the Table2 grid without an update. In other words is there a way to make the system do this? Am I looking for something that does not exist? Tag: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142193
 - 16
 - Missing first record Using asp.net and .net framework 2 and SQL server 2000 I am using simple SELECT statement in SP to retrieve data and then bind to a datagrid but fail to pick up the first record in the dataset: invConn = New SqlConnection(ConfigurationManager.ConnectionStrings("Connectstring").ConnectionString) invConn.Open() invComm = New SqlCommand(zStrg, invConn) invComm.CommandType = Data.CommandType.StoredProcedure invComm.Parameters.AddWithValue("@ClCode", strClCode) iP = invComm.ExecuteReader iP.Read() dgPInv.DataSource = iP dgPInv.DataBind() iP.Close() invConn.Close() The SP is pulling back the full dataset but code above misses first rec. with thanks Tag: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142191
 - 17
 - DOWNLOAD CRACKED 2008's SOFTWARE: ARCHICAD 11,UNIGRAPHICS NX5,SOLIDWORKS 2008,XSTEEL 13,AUTOCAD 2008 Our team provide different types of services such as: - proffessional cracking of any kind of software (CAD,CAM,CAE,EDA,GIS,PCB,FEA,FEM,CNC,CFD,PDS,3D,Optics etc.) designed for any kind of operating systems(Windows 95/98/ME/2000/XP, Linux, FreeBSD, OS/2, MAC OS etc.) - producing keygens, licenses for different proctection systems (FlexLM, SentinelLM, ElanLM, CrypKey, etc.) - producing emulators for any kind of dongles (SentinelPro, SentinelSuperPro, Hasp4, Hardlock, WIBU, Guardant, etc.) - quality reverse engineering (decompilation of programs, algorithms reconstruction, etc.) - any other reverse engineering services... Also we have an excellent relationship with all our customers and we always happy to help them solve their problems. Our skills and experince will help you make a valuable conribution to your business. All soft we offer have been completely cracked and tested carefully by expert in corresponding field. All programs are full copies of originals (not demo, evaluation, trial or educational version) including English or multilanguage tutorial and crack or license file that makes program work as registered software from the house. Here is just a part of our software list.For getting the additional information, view our software list and ordering programs just visit our WEBSITE: http://www.x-softwares.com >> Contact e-mail: support@x-softwares.com Here is an example of the most popular offered latest software: 23.10.2007 Schrodinger Suite 2007 Intel VTune Performance Analyzer v9.0.030 Bentley Microstation GEOPAK Survey XM Edition v08.09.04.37 Delcam Powermill Pro 8009 CB1098013 SP1 Bentley Map XM v08.09.04.45 Bentley Microstation GEOPAK Site XM v08.09.04.37 UGS NX5 V5.0.2 MSC PATRAN V2007 FOR R1B LINUX IRIX,Win MSC FEA AFEA V2006 R1 GEOMAGIC STUDIO V9 SR3 GEOMAGIC QUALIFY V9 SR2 16.10.2007 GEOMAGIC ESHELL V8 CAD TRANSLATORS FOR CRANES NISA V15.1 SmartCode VNC Manager Enterprise v3.6.24.0 Siemens SIMATIC S7 SCL v5.3 SP2 Bentley Civil Extension for GEOPAK v08.08.02.81 Bentley Microstation GEOPAK Civil Engineering Suite XM v08.09.04.37 Bentley Microstation GEOPAK Suite v8.08.02.81 Bentley PowerCivil v08.09.04.37 for Powerdraft XM Bentley PowerSurvey v08.09.04.37 for Powerdraft XM PTC PRO ENGINEER WILDFIRE v3.0 M100 08.10.2007 ADAPT BUILDER ABI_V5.0 UGS SOLID EDGE V20 DIMSOLN COMBINED 3D V4.0.0 DIMSOLN FOUNDATION 3D V4.0.0 DIMSOLN MAT 3D V4.0.0 DIMSOLN SHAFT 3D V3.0.0 LEAPSOFT CONBOX V7.0.1 LEAPSOFT CONSPAN RATING V7.0.1 LEAPSOFT CONSYS V1.3.0 LEAPSOFT GEOMATH V7.0.0 LEAPSOFT RC-PIER V7.0.0 Reation Design Chemkin v4.11 CADRASTER PRO V8.0 FOR AUTOCAD 01.10.2007 TESSEL HYPERDOC V4.51 Pointwise Gridgen v16.0 ANSYS PRODUCTS V11 SP1 Mastcam X2 MR2 V11.2.35 BMW ETK v8.0 2007 OpenMind HyperMILL V9.5 incl SP4 HF 33658 Siemens Simatic WinCC Connectivity Pack v6.2 Mathworks Matlab R2007b GibbsCAM 2007 v8.5.3 SolidWorks 2008 NI LabVIEW v8.5 DSC Module Run Time System NI LabVIEW Embedded Development Module v2.5. NI LabVIEW v8.5 PDA Module 24.09.2007 MSC MD ADAMS 2007 R2 Synapticad Allproducts v12.09a Altera QUARTUS II v7.2 Altera QUARTUS II v7.2 Modelsim v6.1g Altera QUARTUS II DSP Builder v7.2 Altera QUARTUS II Megacore IP Library v7.2 Altera QUARTUS II The Nios II EDS v7.2 Synapticad Allproducts v12.08a Avanti Synopsys Hspice 2007.09 Xilinx PlanAhead v9.2.3 AWR Design Environment v7.51.3650 Cadence OrCad V16 PCB Designer Suite with PSpice 17.09.2007 Adobe Photoshop Elements v6.0 Adobe Premiere Elements v4.0 Digital Light and Color ColorMechanic Pro v2.0 for Photoshop Digital Light and Color Picture Window Pro v4.0 1.11 Digital Anarchy Backdrop Designer v1.2.2 for Photoshop INTERPOSER V1.6.1 FOR CINEMA4D REDGIANT MAGIC BULLET LOOKS V1.0 FOR AE&AVID&PREMIERE SIDEFX HOUDINI MASTER V9.0.747 LINUX GCC33 SIDEFX HOUDINI MASTER V9.0.747 AUTODESK MAX 2008 Avid NewsCutter XP v6.7.5 Avid Xpress Pro v5.7.5 MathMagic Pro Edition v3.6.0.36 for Adobe InDesign WONDERTOUCH PARTICLEILLUSION V3.02 10.09.2007 PAM STAMP 2G 2007(C)ESI Sigma Design ARRIS v9.2 Sigma Design BuildersCAD v9.1 VERO Visi Series v14 SP MULTiLANGUAGE Dassault Systemes DELMIA V5R16 MISSLER TOPSOLID V2007 Think3 ThinkiD DesignXpressions v2007.1.106.36 COADE CADWORX IP V2008 COADE CADWORX EQUIPMENT V2008 COADE CADWORX P AND ID PRO V2008 COADE CADWORX PLANT PRO V2008 COADE CADWORX STEEL PRO V2008 MATERIALISE MAGICS RP V11.1 02.09.2007 GRAITEC ADVANCE STEEL V7.1 SP2 GRAITEC ADVANCE CONCRETE V7.1 SP2 INVENSYS SIMSCI DYNSIM V4.2.3 PLANIT SOLID V4.1 INVENSYS SIMSCI HEXTRAN V9.1 GibbsCAM 2007 v8.5.27 ROBOBAT ROBOT OFFICE V20 NI LabVIEW v8.5 DSC Module NI LabVIEW v8.5 Real Time Module NI Motion v7.6 NI Multisim Analog Devices Edition v10.0.1 Stata v10.0 (c) StataCorp LP 25.08.2007 ArtiosCAD v7.2 (c) Esko nv CambridgeSoftware ChemOffice Ultra 2008 v11 PlanetPress Suite v6.0 Solidworks Video Tutorial Volume 2.3 MSC SOFY V2007 R1 DELCAM FEATURECAM V14 SCANVEC-AMIABLE FLEXISIGN PRO V8.1 R1 DELCAM ARTCAM JEWELSMITH V9.126 Algor DesignCheck v20.3 SP1 DELCAM ARTCAM PRO V9.126 Agenda Software v8.0 R3 MasterCAM X2 v11 SP1 Algor Pipe Pack V10 SP3 18.08.2007 AUTODESK AUTOCAD RASTER DESIGN V2008 WILCOX PC-DMIS V4.2 UGS NX V5.0.1.4 64BIT CSCC MASTERSERIES V2006.19 Autodsys AcceliCAD 2008 CD-adapco Star-CCM Plus v2.08 CD-adapco Star-Design v4.12 AUTODESK REVIT MEP V2008 GibbsCAM 2007 v8.5.22 MSC Marc 2007 R1 ICAM-CAM-POST V17 Minitab v15.1.1 Dolphin SMASH v5.9.2 Xilinx PlanAhead v9.2.2 Fintronic Super FinSim v9.2.3 SynaptiCAD AllProducts v12.04a 12.08.2007 LUMONIX PUPPETSHOP V3.41 FOR 3DS MAX DIRFIX Toon Boom Studio v4.0 LUMONIX SHADER FX V1.8 FOR 3DS MAX LUMONIX PUPPETSHOT V3.41 FOR 3DS MAX ILLUMINATE LABS TURTLE V4.0.0.8 FOR MAYA 32BIT& 64BIT EYEON FUSION V5.2 FINAL EYEON FUSION RENDERSLAVE V5.2 FINAL PHOTRON PRIMATTE V1.1.0 FOR FUSION 5.2 DigiEffects Fantazm v1.14 for Adobe After Effects POWER NURBS PRO AND POWER TRANSLATORS PRO V2.82 FOR 3DS MAX 9 FLUID MASK V3.0.2 AVEVA PDMS 11.6 Intergraph PDS 2007 SmartPlant CNC MACHINIST TOOLBOX V9.2 ABAQUS V6.7 (c) SIMULIA FOR win &Linux TRANSCENDATA CADFIX V7.1 Camtek PEPS v5.3.12 05.08.2007 CAMMAN v4.0.5 Bentley AutoPipe XM v09.00.00.08 Bentley Building Mechanical Systems XM v08.09.04.29 GibbsCAM 2007 v8.5.16 Insightful S-PLUS v8.0 FunctionBay RecurDyn v6.3 SP5 LUSAS FEA V14.03 GridPro v4.5 Bentley Microstation Architecture & Structural & Triforma XM v08.09.04.30 Bentley Microstation XM v8.09.04.51 SAP ECC5 DELCAM FEATURECAM INCL SOLID PLUGIN V13.3.0.13 SOFTPLAN V13.33 30.07.2007 Mathematica v6.01 for Windows &Linux SDS/2 Suite V7.025 (C) Data Design System AUTODESK REVIT ARCHITECTURE V2008 SP1 ADAPT BUILDER EX V3.1 ADAPT PT V8.0 SOFTTECH STRUDS V2007 Hampson Russell CE v8 R1.2 MSC Nastran v2007 R1 CHIEF ARCHITECT X1.V11 ROMEO V4.3.1 (c) INVENSYS SIMSC UGS NX I-DEAS V5 OPTIS OPTISWORKS STUDIO V2007 SOFTIMAGE ALIENBRAIN V8 24.07.2007 ALGOR Designcheck v20.2 SP1 Bentley Microstation GEOPAK Suite v8.08.02.73 Bentley Civil Extension For InRoads XM v8.09.01.42s Bentley InRoads Suite XM Edition v8.09.01.4 GibbsCAM 2007 v8.5.15 AWR Design Environment v7.51 AWR Testwave for AWRDE v2.04 ACTEL LIBERO IDE V8.0 SP1 Synplify Premier v8.8.0.4 with Identify v2.4.2 ZELAND PRODUCTS SUITE V12 19.07.2007 CoventorWare V2006.002 Mentor Graphics ModelSim SE6.3a Mentor Graphics QuestaSim v6.3a FLOMERICS FLOTHERM V7.1 Super-FinSim v9.1.12 DOWNSTREAM CAM350 V9.5.1 Actel Designer v8.0 AUTODESK MAYA UNLIMITED V8.5 SP1 RED GIANT KEY CORRECT PRO V1.0 FOR AE Flaming Pear Photography Pack v1.1 for Adobe Photoshop Avid Liquid v7.2 Adobe Photoshop Lightroom v1.1 HEADUS UVLAYOUT V1.20.2 12.07.2007 IMAGINEER SYSTEMS MOTOR V1.1.3 JoeAlter Shave And A Haircut For Maya 8.0 v4.5 v32 BINARY ALCHEMY ROYAL RENDER V5.7 Conoa Superpak v2.1 for After Effects SOFTWARESHIELD SYSTEM SDK V3.1.12.187 Avid NewsCutter XP v6.7.2 Avid Xpress Pro v5.7.2 Avid Studio Toolkit v5.6.4 DAZ 3D HEXAGON V2.2 PixelGenius Photokit Color v2.11 for Adobe Photoshop PixelGenius Photokit Sharpener v1.26 for Adobe Photoshop PixelGenius Photokit v1.26 for Adobe Photoshop 06.07.2007 TEKLA XSTEEL STRUCTURES V13 DASSAULT SYSTEMES CATIA V5R17 SP6 Simulia Abaqus v6.7 Mercedes Benz Navigations CD Audio 50 APS Europa MSC Adams 2007 R1 PROCAD 3DSMART V2007.1 CODEGEAR RAD STUDIO DELPHI V2007 PTC PRO ENGINEER WILDFIRE v3.0 M090 MSC EASY5 v2005 R1.4 Simulia Abaqus v6.7 29.06.2007 Falk Navigator 5 Kartenmaterial Europa 2007 MSC Dytran 2007 R1 Transmagic Plus v7.0 Route66 Navigate v7.0 Europa NI SoftMotion Controller v2.1 Medion GoPalPE.3.0A INVENSYS SIMSCI PROII V8.1 Rasterweq Software SmartCUT Pro v2.3.2.0 Cigraph ArchiTabula v1.97 For Archicad 11 Cigraph ArchiSketchy v1.97 For Archicad.11 Cigraph ArchiTime v1.97 For Archicad.11 22.06.2007 Route66 Navigate v7.0 Europa NI SoftMotion Controller v2.1 Graphisoft ArchiCAD v11 International Retail Readnfo GibbsCAM 2007 v8.5.13 Megatech MegaCAD 3D v2007 IMSIDesign TurboCAD Designer v14 CURIOUS WORLD MAPS V7.2F Bentley Microstation XM v8.09.04.44 Bentley Microstation Prerequisite Pack v8.09.04.01 Transmagic Plus v7.0 UNIGRAPHICS NX5 SURFWARE SURFCAM VELOCITY III SP1 14.06.2007 UGS FEMAP V9.3 ETA CAD Translator v1.200704 ETA VPG v3.2 WiNNT2K CSI SAFE PLUS DETAILER V8.1.0 AutoForm Master 4.1 Abaqus v6.7 VectorWorks V12.5.1 GibbsCAM 2007 v8.5.10 Malz Kassner CAD6 Industry v2007 Malz Kassner CAD6 Studio v2007 Dolphin SMASH v5.8.4 05.06.2007 SynaptiCAD AllProducts v12.01b Super FinSim v9.1.11 Depth Of Field Generator PRO v3.0.74 for Adobe Photoshop NI Circuit Design Suite Educational v10.0.1 NI Circuit Design Suite Pro v10.0.1 Dolphin SMASH v5.8.3 Aldec Active HDL v7.2 CST Studio Suite v2006B SP3 CD-Adapco Star-CD v4.02 Intel Thread Profiler v3.1.021 Intel Thread Checker v3.1.021 29.05.2007 SURFWARE SURFCAM VELOCITY III SP1 Bentley speedikon Architectural v08.00.00.25 for MicroStation XMS Bentley speedikon Industrial v08.00.00.25 for MicroStation XM PROTEUS ENGINEERING MAESTRO V8.7.6 PROTEUS ENGINEERING FASTSHIP V6.1.29 PTC PRO ENGINEER WILDFIRE v3.0 M080 Intel VTune Performance Analyzer v9.0.010 Intel VTune Performance Analyzer v9.0.969 Intel C Plus Plus Compiler v9.1.037 Intel Visual Fortran Compiler Pro v9.1.037 Carbon Coder v2.51 Rhozet Corporatio OPTIMAL SOLUTIONS SCULPTOR V2.1 20.05.2007 CSI ETABS NL V9.1.4 Solidworks 2007 SP0.0-SP3.1 Service Pack ALTAIR HYPERWORKS V8.0 SR1 AUTODESK PRODUCTSTREAM PRO V2008 Autodsys IntelliCAD v6.3 Pro Plus Edition NI DIAdem v10.2 NI LabWindows CVI FDS v8.1.1 NI Teststand v4.0 Eurosystems SmartCut Pro 6.1.13 CimatronE v8.0 FunctionBay RecurDyn v6.3 SP4 UGS TEAMCENTER VISUALIZATION V2005 13.05.2007 CADopia Professional 6.0 SP1 CADopia Intellicad 5 Standard SP1 v5.0.20.0 Ansoft Maxwell 2D & 3D 11.1 GEOMAGIC STUDIO V9 DHI MIKE NET V2007 DHI MIKE STORM V2007 PROKON STRUCTURES V2.2-LND LEAP SOFTWARE LEAP BRIDGE V6.0 MOLDFLOW DESIGN LINK V5.2 ADAPT BUILDER-EX V3.0 CEI ENSIGHT GOLD V8.2.4B 32BIT 04.05.2007 GibbsCAM 2007 v8.5.6-Lz0 SURFWARE SURFCAM VELOCITY III MSC PATRAN V2006 R1for IA64&IRIX&HPUX DASSAULT SYSTEMES CATIA V5R17 SP5 FOR 32 &64 BIT MOLDFLOW PLASTICS ADVISERS V7.3 ARRIBA Planen Kompakt v12.3.233 GGU-Footing v5.0 GGU-Retain v4.42 GGU-Slab v6.0 GGU-SS-Flow2D v8.03 GGU-Stability v8.08 26.04.2007 UGS Solid Edge v19 Update.5 AUTODESK ALIASSTUDIO V2008 ALLDATA v9.20.1002 GibbsCAM 2007 v8.5.2 Maple V11 Professional MAC OSX UB Autodesk Inventor Professional 2008 FLUENT Polyflow v3.11.0 E-ON VUE INFINITE V6.0.5 ALTAIR HYPERWORKS V8.0 X64 VectorWorks v12.5.0 R1 18.04.2007 UGS Jt Catia v5 Translator v4.0 EDS UNIGRAPHICS NX V5.0.25 OpenMind HyperCAD v2006.2.105.41 Dolphin SMASH v5.8.2 Dolphin SoC GDS v5.9.1p2 SynaptiCAD AllProducts v11.18a Agilent Genesys 2007 uper FinSim v9.1.0 Puppetshop v3.35 for 3ds Max Multimeios Fulldome v1.2.0.0 for Adobe After Effects NEWTEK LIGHTWAVE3D V9.2 10.04.2007 CSI SAP2000 11.0 NI DASYLab 9.0.2 THINK3 THINKDESIGN THINKID v2006.2 Think3 ThinkiD DesignXpressions v2006.2 105 41 Aveva Vantage PDMS v.11.6 SP3.5 DELCAM ARTCAM PRO 9.021 DELCAM ARTCAM INSIGNIA 4.019 Bentley Microstation XM v08.09.03.65 Autodesk 3ds Max 9 Extension 1: Productivity Booster Altair HyperWorks 8.0 Ansys Fluent 6.3 Win32 Ansys Fluent 6.3 x64 03.04.2007 Autodesk VIZ 2008 Autodesk AutoCAD Architecture 2008 Autodesk AutoCAD Electrical 2008 Autodesk AutoCAD Mechanical 2008 Autodesk AutoCAD 2008 Autodesk AutoCAD LT 2008 Adobe RoboHelp 6.0 Cedrat Flux 9.3.1 Sofistik Soficad 17.1 3D Home Architect Design Suite Deluxe 8.0 AutoDsys AcceliCAD 2007 v6.2.36.5 CADlink EngraveLab Expert 7.1 rev.1 Build 8 Comsol Multiphysics 3.3 x64 26.03.2007 Adobe LiveMotion 2.0 for Mac Altera Quartus II 7.0 Citrix Password Manager 4.5 Finale SongWriter 2007 Missler Topsolid 2006 Moldflow Products 2007 PTC InterComm Expert 5.2 VX CAD CAM 12.70 Xilinx ISE 9.1 Adobe Photoshop CS3 v10.0 19.03.2007 CSC Structural 7.02 Digital Element WorldBuilder Pro 3.55 MSC MD Nastran R2 Mathworks Matlab R2007a Nemetschek Allplan v2006.2 GibbsCAM 2006 v8.0.38 CD-adapco Star CD v4.02 CD-adapco Star-CCM Plus v2.04 InfoGraph InfoCAD v6.51 VX CAD CAM V12.70 Moldflow Plastics Insight v2007 PTC InterComm Expert v5.2 F000 Cenit FasTRIM LaserCUT v3R7GA Dicad Strakon v2007 incl SP2 Pointwise Gridgen v15 10 R1 13.03.2007 NI Vision v8.2.1 Development Module NI DIAdem v10.1 SP1 NI Vision Builder AI v3.0.1 NI LabVIEW SignalExpress v2.0 Intel C Plus Plus Compiler v9.1.047 GERBER ACCUMARK FAMILY V8.2.0.156 Solidworks Video Tutorials Series 1& Series 2 Siemens Sinutrain v6.3 Edition 3 UGS I-DEAS NX12M4 MSC SIMXPERT R1.1 MSC SIMOFFICE R1 MSC PATRAN 2006 R2 PATHTRACE EDGECAM V11.5 DASSAULT SYSTEMES CATIA V5R17 SP4 for SOLARIS ANSYS PRODUCTS LINUX V11 GibbsCAM 2006 v8.0.36 PTC Mathcad v14.0 SYSTAT v12.0 Genstat v9.2.153 05.03.2007 CATIA P3 V5R17 WITH SP4 UGS NASTRAN NX V4.1 FTI FORMING SUITE V5.0 CEDRAT FLUX V9.3.1 DASSAULT SYSTEMES CATIA V5R17 SP3 SOLARIS AEGIS CIRCUITCAM SUITE V6.0.2.2 BENTLEY STORMCAD XM V05.06.012.00 Smirtware DieShop v6.0 DieNC DieBuild v2.3 MSC PATRAN 2006 R1 Cadenas Partsolutions v8.1.04 Comsol Multiphysics v3.3a 24.02.2007 SynaptiCAD AllProducts v11.17 Altera QUARTUS II v7.0 Xilinx ISE v9.1 Super FinSim v9.0.2 Mentor Graphics PADS v2007 IAR Embedded Workbench for dsPIC v1.30A SynaptiCAD AllProducts v11.15d Xilinx EDK v8.2 Synplify v8.8 with Identify v2.6 Dolphin SMASH v5.8.1. Actel Designer v7.3 SPA SOFiSTiK SOFiCAD v17.1 GibbsCAM 2006 v8.0.33 15.02.2007 CAMTEK PEPS v5.3.11 FUJITSU MATERIALS EXPLORER V4.0 ULTRA TEXXRAY PROFESSIONAL V1.21 DATACAD V11 NI DIAdem INSIGHT v2.09 ILight FieldView v11.1 UGS NX2D V4.0.1 CADlink EngraveLab Expert 7.1 rev 1 Build 8 Spartan 2006 v1.0.2 Esteco modeFRONTiER v3.2.0 SUB100 CSC STRUCTURAL OFFICE V7.02 Autodsys AcceliCAD 2007 v6.2.36.5 Spring Technologies NCSimul v8.3 ANSYS DESIGNSPACE V11 VERO Visi Series v14 SP1 MIDAS GEN V7.02 07.02.2007 NI LabWindows CVI FDS v8.1 NI Vision v8.2.2 Acquisition Software NI LabView with Embedded Support v8.2.1 NI LabView Embedded Module for ADI Blackfin v2.0 NI Circuit Design Suite Pro v10.0 NI Circuit Design Suite Educational v10.0 Intel Fortran Compiler v9.1 041 Hampson Russell CE v8.R1 ALGOR Designcheck v19.3 SP2 Intel C Plus Plus Compiler v9.1.034 FTI FORMING SUITE V4.0.1 Rib Construction Suite v12.3.135 GRAPHITECH CIMAGRAPHI V8.07 FEM DESIGN V6.01.004 Delcam PowerMILL Pro PM7006 CB1084537 SP5 RagTime v6.0.1 Dolphin SMASH v5.8.0p1 Actel Designer v7.3 Adobe LiveMotion 2.0 for Mac 27.01.2007 AUTODESK BUILDING SYSTEMS V2007.1 Transmagic Catia V5 Read Inventor Add-In v2006 SP1 Transmagic Catia V4.Read Write Inventor Add-In v2006 SP1 MIDAS CIVIL V7.01 R2 COMSOL MULTIPHYSICS V3.3 ProgeCad 2007 v7.08 SPSS Clementine v10.1 Dolphin SMASH v5.8.0 Agilent IC-CAP 2006 SYNOPSYS Star-Hspice 2006.09 with sp1 GC-powerstation 7.1.4 Cinema Craft Encoder SP v2.70.02.12 Puppetshop v3.29 for 3ds Max 22.01.2007 AUTODESK MAYA UNLIMITED V8.5 Heyne Multimedia Drive v1.00 for Cinema4D 9.5 and 10 DDAG HairFX v1.6.0.66 for 3ds max 9 64bit Heyne Multimedia SplinePatch v1.10.2 for Cinema4D ALIAS STUDIOTOOLS V13.5 Adobe Flex Builder 2.0 Fujitsy Cache 7.5.0.85 IMSI CAD Symbols 2.0 Lectra DesignConcept 3D v3R1c NavisWorks JetStream 5.2.3 Rib Construction Suite v12.2.189 Serif PanoramaPlus 3.0 SPSS v15.0 15.01.2007 Delcam PowerMILL 7006 SP4 GibbsCAM 2006 v8.0.27 PCA SLAB V2.0 PCA BEAM V2.0 LEAP SOFTWARE RC-PIER V6.00 LEAP SOFTWARE CONSPAN RATING V6.00 Transmagic Plus v2006 SP1 Comsol Multiphysics V3.3 Lectra DesignConcept 3D v3R1c 10.01.2007 SOLIDWORKS V2007 SP 2.0 CSI CONCEPTS UNLIMITED V4 SP1 NL SIMULIA ABAQUS V6.6.3 InfoGraph InfoCAD v6.5 ESI PROCAST V2006 Sescoi WorkNC v18.17 FORMSYS MAXSURF V12.04 Tribon M3 BENTLEY TriForma v8.05.04.13 BENTLEY Architectural v8.05.04.07 BENTLEY Microstation XM Architectural v8.09.02.53 BENTLEY Microstation XM Triforma v8.09.02.66 04.01.2007 SPSS v15.0 SRAC COSMOSWORKS V2007 SRAC COSMOSM V2007 SRAC COSMOSFLOWORKS V2007 SRAC COSMOSMOTION V2007 SRAC COSMOS EMS II GibbsCAM 2006 v8.0.26 AUTODESK LUSTRE V2007 EXT1 Super FinSim v8.3.6 27.12.2006 SynaptiCAD AllProducts v11.13c ManiaBarco Ucam v8.1 FLOMERICS FLOTHERM V6.1 Xilinx PlanAhead v8.2.7 Cedrat FLUX922 Agilent EMDS 2006B Agilent GENESYS 2006 v10 FINAL JoeAlte Shave And A Haircut For Maya 8.0 v4.4v18 F-EDGE V1.0.3 FOR 3DSMAX3 TO 9 2D3 BOUJOU V4.0.1 AVID SOFTIMAGE XSI ADVANCED V6.0 20.12.2006 NI LabView Professional v8.2.1 NI LabVIEW v8.2.1 Embedded Development Module VisualCAM 2006 SR1 GibbsCAM 2006 v8.0.20 NI ECU Measurement and Calibration Toolkit v2.0.1 REALVIZ ImageModeler v4.03 MAGICS RSM ESHELL V4.0.0.28 Cadlink ProfileLab 2D 7.1 rev.1 Build 8 CURIOUS NATURAL EARTH NASA 1KM V5.1 FOR CURIOUS WORLD MAPS 6.1 AND 7.0 CURIOUS NATURAL EARTH PLANET OBSERVER 1KM V5.1 FOR CURIOUS WORLD MAPS.6.1 AND.7.0 12.12.2006 Cadlink SignLab Vinyl 7.1 Rev.1 Build.7 REIWORLD STAAD PRO v2006 BUILD 1002 InfoGraph InfoCAD v6.34 CGTECH VERICUT V6.0.3 DASSAULT SYSTEMES CATIA V5R17 SP2 LECTRA FORMARIS V5R1C1 BENTLEY Microstation Descartes XM v8.09.02.71 Cigraph Archiwall 2.0 For ArchiCAD v10 Cigraph ArchiTerra 3.0 For ArchiCAD v10 MATERIALISE MIMICS V10.01 This is not our complete software list. If you want to get access to our Software archive you should visit our website: http://www.x-softwares.com >> Contact e-mail: support@x-softwares.com *** Sent via Developersdex http://www.developersdex.com *** Tag: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142183
 - 18
 - Save mix data in database Hi EveryBody: What is the data type that I have to use when I want to save mix data in database for example photos,music,text fiel,doc file and movies ? any help will be appreciated regard's Husam Tag: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142181
 - 19
 - Get Query string from Dataset/Datatable Hello When i fetch data from database i do the following: DataSet ds = new DataSet(); OledbConnection con = new OledbConnection(ConnectionString); using ( OledbCommand cmd = con.CreateCommand()) { cmd.CommandText = "SELECT * FROM [tblCustomers] WHERE [CustomerName] LIKE 'A%';"; using ( OledbDataAdapter da = new OleDbDataAdapter(cmd)) { da.Fill(ds); ds.Tables[0].TableName = "tblCustomers"; } } The above just ment as an illustration. The DataSet ds now contain one table with the result of the query within the cmd. Now my question, is the cmd Query stored somewhere within the DataSet/Table? Kind regards Johnny E. Jensen Tag: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142179
 - 20
 - ANN: High performance of remoting ADO.NET objects cross desktop and smart devices 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 Tag: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142170
 - 21
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142168
 - 22
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142167
 - 23
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142165
 - 24
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142164
 - 25
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142162
- Next
 - 1
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142161
 - 2
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142155
 - 3
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142154
 - 4
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142146
 - 5
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142143
 - 6
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142128
 - 7
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142127
 - 8
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142122
 - 9
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142118
 - 10
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142116
 - 11
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142115
 - 12
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142114
 - 13
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142102
 - 14
 - 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> 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. ****************************************************************= ************************ On Error GoTo Error_Handling Dim cnn As New = Odbc.OdbcConnection <FONT=20 face=3DArial size=3D2>Dim cmd As New Odbc.OdbcCommand Dim rdr As Odbc.OdbcDataReader cnn.ConnectionString =3D "dsn=3D" &=20 accpac_companyid cnn.Open() <FONT=20 face=3DArial size=3D2>cmd.Connection =3D cnn cmd.CommandText =3D "select schedkey, scheddesc from cssktb = order by=20 schedkey" rdr =3D = cmd.ExecuteReader Do While rdr.Read    =20 combo.Items.Add(rdr("schedkey").ToString.Trim) Loop Error_Exit:     If Not IsNothing(rdr) Then         = rdr.Close() <FONT=20 face=3DArial size=3D2>       =20 cmd.Connection.Close()    =20     cmd.Dispose()         = cnn.Close() <FONT=20 face=3DArial size=3D2>       =20 cnn.Dispose()     = End=20 If     rdr =3D = Nothing <FONT=20 face=3DArial size=3D2>    cmd =3D Nothing     cnn =3D Nothing Exit=20 Sub Error_Handling:     Select Case Err.Number     Case Else         MsgBox("The following = error occured=20 in LoadSchedules()" & vbCrLf & Err.Description) <FONT=20 face=3DArial size=3D2>    End Select Resume = Error_Exit</DIV></BODY></HTML> ------=_NextPart_000_0006_01C8155A.951AF170-- Tag: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142100
 - 15
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142096
 - 16
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142093
 - 17
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142091
 - 18
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142087
 - 19
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142083
 - 20
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142079
 - 21
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142078
 - 22
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142074
 - 23
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142059
 - 24
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142050
 - 25
 - 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: Underlying (SQL Server) DataTypes for Columns in a DataSet? Tag: 142048

I have an application that allows the user to enter any number of (SQL
Server) select statements in a text box, execute the "script" and work with
the resulting data. Due to the multiple queries, I use a SqlDataAdapter.Fill
to get the dataset as opposed to a DataReader.

I need to use another library that requires the *SQL Server datatype*
specification (preferably as a string) for the columns in the DataSet. Since
I don't really know where the result columns are coming from, I can't just
inspect the database schema directly.

Any suggestions?

Top