C# (CSharp) SQLDataReader Examples

Programming Language: C# (CSharp)

Class/Type: SQLDataReader

Examples at hotexamples.com: 3

SqlDataReader is a class provided by the System.Data.SqlClient namespace of the .NET Framework. It is used to read data from a SQL Server database by providing a read-only and forward-only stream of records from the database.

Example 1: Reading data from a SQL Server database using SqlDataReader

using System.Data.SqlClient;

class Program
{
    static void Main(string[] args)
    {
        string connectionString = "Data Source=server_name;Initial Catalog=database_name;Integrated Security=True";
        string query = "SELECT * FROM customers";

        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            SqlCommand command = new SqlCommand(query, connection);
            connection.Open();
            SqlDataReader reader = command.ExecuteReader();
            
            while (reader.Read())
            {
                Console.WriteLine(reader["customer_name"].ToString());
            }
            
            reader.Close();
        }
    }
}

In this example, we create a SqlConnection object using the connection string to connect to a SQL Server database. We then create a SqlCommand object with the SQL query and execute it using the ExecuteReader method to get a SqlDataReader object. We then iterate through the SqlDataReader object to get the data from the database and write it to the console.

Example 2: Reading data from a stored procedure using SqlDataReader

using System.Data;
using System.Data.SqlClient;

class Program
{
    static void Main(string[] args)
    {
        string connectionString = "Data Source=server_name;Initial Catalog=database_name;Integrated Security=True";
        string storedProcedure = "get_customers";
        
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            SqlCommand command = new SqlCommand(storedProcedure, connection);
            command.CommandType = CommandType.StoredProcedure;
            connection.Open();
            SqlDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                Console.WriteLine(reader["customer_name"].ToString());
            }

            reader.Close();
        }
    }
}

In this example, we create a SqlConnection object and a SqlCommand object with the name of the stored procedure. We set the CommandType of the SqlCommand object to CommandType.StoredProcedure and execute it using the ExecuteReader method to get a SqlDataReader object. We then iterate through the SqlDataReader object to get the data from the stored procedure and write it to the console. The package library for SqlDataReader is System.Data.SqlClient.

C# (CSharp) SQLDataReader - 3 examples found. These are the top rated real world C# (CSharp) examples of SQLDataReader extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

Read(2)

GetInt(1)

GetString(1)

ReadAllRows(1)

Example #1

Show file

File: SearchController.cs Project: bikramaditya/RPAWeb

        private void rebuildLucene(String indexPath)
        {
            Analyzer    analyzer = new StandardAnalyzer(Lucene.Net.Util.Version.LUCENE_30);
            Directory   luceneIndexDirectory;
            IndexWriter writer;

            luceneIndexDirectory = FSDirectory.Open(indexPath);

            writer = new IndexWriter(luceneIndexDirectory, analyzer, true, new IndexWriter.MaxFieldLength(500));

            IEnumerable <RPAResult> dataToIndex;
            ISQLReader dataReader = new SQLDataReader();

            dataToIndex = dataReader.ReadAllRows();

            foreach (var sampleDataFileRow in dataToIndex)
            {
                Document doc = new Document();
                doc.Add(new Field("ID", sampleDataFileRow.ID.ToString(), Field.Store.YES, Field.Index.ANALYZED));
                doc.Add(new Field("KeyWords", sampleDataFileRow.KeyWords.ToString(), Field.Store.YES, Field.Index.ANALYZED));
                doc.Add(new Field("ScriptID", sampleDataFileRow.ScriptID.ToString(), Field.Store.YES, Field.Index.ANALYZED));
                doc.Add(new Field("ScriptText", sampleDataFileRow.ScriptText, Field.Store.YES, Field.Index.ANALYZED));
                doc.Add(new Field("UserConfirmationMsg", sampleDataFileRow.UserConfirmationMsg, Field.Store.YES, Field.Index.ANALYZED));
                writer.AddDocument(doc);
            }
            writer.Optimize();
            writer.Commit();
            writer.Dispose();
        }

Example #2

Show file

    protected static object ReadList(SQLDataReader dr)
    {
        List <User> retVal = new List <User>();

        while (dr.Read())
        {
            User temp = new User();
            temp.Prop1 = dr.GetString("Prop1");
            temp.Prop2 = dr.GetInt("Prop2");
            retVal.Add(temp);
        }
        return(retVal);
    }

Example #3

Show file

        private static List <Product> InitializeCollectionOld(string tableName)
        {
            List <Product> list = new();

            OpenDataBaseConnection();

            SQLCommand    = new SqlCommand($"SELECT * FROM {tableName}", SQLConnection);
            SQLDataReader = SQLCommand.ExecuteReader();

            while (SQLDataReader.Read())
            {
                list.Add(new Product
                {
                    Id    = Convert.ToInt32(SQLDataReader["id"]),
                    Name  = SQLDataReader["name"].ToString(),
                    Price = Convert.ToDecimal(SQLDataReader["price"])
                });
            }

            CloseDataBaseConnection();
            return(list);
        }