Tutorial C# Sharp - Learn to program with performing exercises C# Sharp

Tutorial C# Sharp

Learn to program with performing exercises C# Sharp

Database query - Tutorial C# Sharp
Tutorial C# Sharp4,85581245

Database query - Tutorial C# Sharp


Lesson 10:

Access to relational databases


Exercise 10.2:

Database query


Objetive:

Create a program to display the data about books which your previous prorgram has stored.


Source Code:


using System;
using System.Data.SQLite;
namespace ReadSQL
{
    class Program
    {
        static void Main(string[] args)
        {

            SQLiteConnection conexion = new SQLiteConnection
            ("Data Source=ejemplo01.sqlite;" +
            " Version=3; New=False; Compress=True;");

            conexion.Open();

            string consulta = "select * from books";
            SQLiteCommand cmd = new SQLiteCommand(consulta, conexion);
            SQLiteDataReader datos = cmd.ExecuteReader();

            while (datos.Read())
            {
                string name = Convert.ToString(datos[0]);
                string autor = Convert.ToString(datos[1]);
                string genre = Convert.ToString(datos[2]);
                string summary = Convert.ToString(datos[3]);

                System.Console.WriteLine("Name: {0}," +
                " Autor: {1}, Genre: {2}, Summary: {3}",
                name, autor, genre, summary);
            }

            conexion.Close();
        }
    }
}
Exercisey 10.2






Privacy Policy:



Google uses associated advertising companies to serve ads when it visits our website. These companies may use the information they obtain from your visits to this and other websites (not including your name, address, email address, or phone number) to provide you with announcements about products and services that interest you. If you would like to learn more about this practice and know your options to prevent these companies from using this information. Click in... Privacy and Terms of Google.

Cookies

This site uses Google cookies to provide its services, to personalize advertisements and to analyze traffic. Google receives information about your use of this website. More information in... Privacy and Terms of Google.