Browse by Tags

All Tags » Data Access » General (RSS)

• Are server side cursors supported in .NET?

  No. In fact, there are no updateable cursors anywhere in .NET. All of the data access in .NET is based on this disconnected data model. In .NET you push data into a DataSet. The DataSet keeps track of the changes that are made to the data. Then the DataSet...

• How do I call a SQL stored procedure?

  You call stored procedures in basically the same manner as executing other SQL commands. When creating the SqlCommand, set the query string to be the name of the stored procedure, and then set the CommandType to be CommandType.StoredProcedure. SqlCommand...

• I don't have SQL Server. How do I work through the samples that use SQL Server?

  You can use MSDE, a SQL server compatible database engine that MS makes available for free. You can download and install MSDE from a whole variety of sources. Here is one source . MSDE also comes with Visual Studio .NET and the .NET Framework SDK. It...

• How do I specify this port in my connection string when I have SQL server running on a non-default port?

  The data source component of your connection string should contain the port right after the IP address (or name). It should be separated from the IP by a comma. data source=192.168.123.1, port_number; Take a look at the connectionstrings.com website for...

• Can I use MySQL with ADO.NET?

  Yes, MySQL can be used with ADO.NET. For more information, see the article Exploring MySQL in the Microsoft .NET Environment at mysql.com. Contributed from George Shepherd's Windows Forms FAQ

• How do I load a CSV file into a DataTable?

  Here's a sample that loads a comma separated values (CSV) file into a DataSet. using System; using System.Data; using System.Data.OleDb; using System.IO; public class Csv { public static DataSet GetDataSet( string filename ) { string connString =...