Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Simplify .NET SQL queries with the Data Access Application Block
- Although Microsoft's .NET Application Block is well documented, the practical tips and tricks that make it more usable on a day-to-day basis are harder to find. This article gathers some code that will make the Data Access Application Block easier to use in everyday .NET/SQL Server projects.Getting startedYou can download...
- Tags: .NET, Microsoft development tools, Databases, William Sempf MCP, CIBS, IWA, ExecuteNonQuery, ExecuteScalar method, ExecuteDataset, Data Access Application Block, ExecuteReader, SqlDataReader, SQL-query, DataSet dataSet, data access, ExecuteScalar, connString
- Technical articles 2003-07-15
Additional Resources
- Which dataset should you choose?
- DataReader is not DataSetThere is NO DataSet instance created in your first listing. Instead, SqlCommand.ExecuteReader returns an equivalent of forward-only, read-only server-side cursor which allows the client to quickly and efficiently process query results ONE ROW AT A TIME. This is fundamentally different from the purpose and characteristics of disconnected...
- Tags: DataReader, Dataset, pequod, programming
- Discussion threads 2005-06-28
- Binding Fields In VB. Net
- I want to work with Datasets in VB.Net without placing a dataset object on my form. In this case, I must programmatically bind the form objects (textbox, datagrid and combo box, checkbox,datetimepicker) to the dataset, and then be able to control the form data with navigating buttons. ...
- Tags: dataset, dfontahfru@..., Microsoft Visual Basic, programming
- Q&A 2005-01-28
- Use index for each column in dataset
- Hi all,I want to save, delete, and update a table with a dataset IN VB.NET 2005. But all that i find in the net are only example of dataset using with hard code column name.I need to use it with indexed column.Pls help,thanks
- Tags: Microsoft development tools, .NET, maria_angelica_ivo@...
- Discussion threads 2007-06-19
- Creating a Format From Raw Data or a SAS Dataset
- This paper demonstrates the creation of a format from raw data or a SAS dataset using the CNTLIN= option in PROC FORMAT. In order to create a format from a SAS dataset, the SAS dataset must have a few required variables. This paper will explain how to construct this dataset...
- Tags: SAS Institute
- White papers 2007-05-14
- Visual Studio Hacks: Generate Strongly Typed DataSets
- ADO .NET's DataSet objects provide powerful functionality when working with data. They allow the user to easily scroll, filter, search, and sort data, as well as work with hierarchical data and its relationships. However, the typical DataSet object is untyped, meaning it doesn't really know and understand what it is...
- Tags: Microsoft Visual Studio, O'Reilly Media Inc., Microsoft Development Tools, .Net, Application Servers, Middleware, Development Tools, Software Development, Software/Web Development, Enterprise Software, Software
- Book chapters 2005-03-09
- Skinny to Fat: In search of the "Ideal" Dataset
- With SAS, given a "Tall" table with numerous observations for a patient, it can be difficult to analyze data between rows. While creating a "Short" dataset with all observations for a patient in one row can be accomplished with PROC TRANSPOSE, in multivariable datasets the number of TRANSPOSE statements can...
- Tags: Patient, SAS Institute
- White papers 2007-05-14
- New DataSet Features in ADO.NET 2.0
- The ADO.Net 2.0 version of the DataSet and DataTable introduces numerous new features and enhancements to existing features. The main features include significantly improved performance due to a new index engine and the binary serialization format option, extensive capabilities available to a stand-alone DataTable, and mechanisms for exposing cached data...
- Tags: Microsoft ADO.NET, .Net, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- White papers 2004-11-01
- Efficient Coding With Strongly Typed DataSets
- This paper discusses the pros and cons of developing a Microsoft .NET Framework-based application using strongly typed DataSet objects. This paper begins by discussing what a typed DataSet is and how it extends the DataSet, DataTable, and DataRow classes. The paper concludes by explaining some of the tips and tricks...
- Tags: Paper, Microsoft Corp., .Net, Software Development, Software/Web Development
- White papers 2004-12-01
- Getting Your Random Sample in Proc SQL
- There are times when a user may desire or need to work with a subset of a very large dataset and therefore may need to obtain a random sample of the larger dataset. The SURVEYSELECT procedure, introduced in SAS/STAT with SAS Version 8, is a procedure which provides a variety...
- Tags: SAS Institute, Sample
- White papers 2006-02-28
- MSDN Webcast: Database Connectivity in InfoPath Through ADO.NET DataSet Support - Level 400
- The attendee of this webcast will learn how to use Microsoft Office InfoPath to design a form as a front-end to a Web Service that exposes ADO.Net DataSet structure. This webcast explains the InfoPath Data Adapter architecture, new Data Adapters in InfoPath 2003 SP-1, and talk about reasons for using...
- Tags: Microsoft Developer Network, Database, Webcast, Microsoft InfoPath, Microsoft ADO.NET, Groupware, Microsoft Office, Enterprise Software, Software, Office Suites
- Webcasts
- webservice dystopia
- I develop on .NET by day and PHP/mySQL by evening/weekend and have noticed that I can only get my .NET clients to interface with the simplest of SOAP web services - anything that requires a dataset - the PHP world doesn't work the same as the .NET world. I'm...
- Tags: dataset, JustAnotherTechie, Microsoft .NET, Microsoft IIS Server, Microsoft Visual Studio, PHP, php soap web services for .net clients.., programming, WSDL, XML
- Discussion threads 2005-05-27
- Hydrus DataSet Toolkit (exe)
- Automates Select/Insert/Update/Delete operations in .Net by generating SQL statements on-the-fly based on your strongly-typed DataSet object. Eliminates the need for DataAdapter code, or maintaining SQL statements of any kind. You limit query results via WhereConstraint objects which create the SQL statement predicates. The primary advantage of the Hydrus Software CommandBuilder...
- Tags: SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Software downloads 2006-06-13
- Centrality Based Visualization of Small World Graphs
- This case study attempts to visualize a real-world dataset consisting of 600 recently published information visualization papers and their references. This is done by first creating a global layout of the entire graph that preserves any cluster structure present. The paper then uses this layout as a basis to define...
- Tags: Visualization
- White papers 2008-03-07
- Typed and Untyped Datasets .net apps
- I need a beginners answer to the differences between Typed and Untyped datasets in VB.net.Thanks for the helpAn untyped datasetis one VB knows 'nothing about'. You have to 'hardcode' the table names column names etc.A typed dataset is generated from an xsd schema of the data, so it takes a...
- Tags: Jerry Holland
- Discussion threads 2007-02-08
- Query between tables In Dataset .NET
- I have a Query related to Dataset & DataTable in ASP.NET/VB.NET1) MyDataset is a dataset populated from Two diffrent XML file.2) Dataset having two tables table(0) is ResourceAllocation, And table(1) is Projects3) Table(“Project”) is a master table containing all the projects of company some fields are ProjectID,ProjectName,Dureation,Status4) Table(“ResourceAllocation”) is a table in which we...
- Tags: dataset, pramodsahu_4nov@..., programming, runtime
- Q&A 2005-09-16
- Contrasting the ADO.NET DataReader and DataSet
- The ADO 2.x recordset object is able to operate in either a connected or a disconnected mode. It can remain connected to the underlying database while traversing a forward only rowset or it can retrieve a rowset into a client-side, in-memory cursor and disconnect itself from the database. Instead of...
- Tags: Data Storage, Microsoft ADO.NET, .Net, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- White papers 2004-06-01
- copy table from dataset
- I need to copy table from a dataset then return saved copy into the original table.dim cpytbl as new datatablecpytbl = ds.table("name").copyentr processds.table.("name") = cpytbl this statement give an error "Property 'Item' is 'ReadOnly' "can you helpSeems to be a fundamental error hereWhy are you trying to do this?I can...
- Tags: sahaah@...
- Discussion threads 2007-02-25
- Collaborative Filtering on Skewed Datasets
- Many real life datasets have skewed distributions of events when the probability of observing few events far exceeds the others. This paper observed that in skewed datasets the state of the art collaborative filtering methods perform worse than a simple probabilistic model. The test bench includes a real ad click...
- Tags: Collaborative Filtering, Test Bench
- White papers 2008-05-21
- DataSet in C# Running as Windows Service
- My program has a Dataset that writes to a database when it receives information, it works fine. However, I want to convert the program into a Windows Service, which would mean the Dataset would have to be in the Service, and the Datagrid display GUI would have to be...
- Tags: C#, Dataset, GUI, Log, Microsoft Windows, netsecsvc, programming, typeof
- Q&A 2005-06-20
- << Previous
- page 1 of 1
- Next >>