1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. Donation with Paypal!!!

    Go to your paypal account and send directly donation to [email protected]

    1 month - 10 $ - Standart VIP

    6 months - 20 $- Standart VIP

    1 year - 30 $- Standart VIP

    2 years - 50 $- Standart VIP

    Gold member for life - 150 $- Standart VIP

    High Vip (Standart VIP include) group please send PM or email to [email protected] for info

    After Donation please send email to [email protected]

  3. Donation Ways 2020


    Paysend
  4. Telegram
Dismiss Notice

Donation with Paypal!!!

Go to your paypal account and send directly donation to [email protected]

1 month - 10 $ - Standart VIP

6 months - 20 $- Standart VIP

1 year - 30 $- Standart VIP

2 years - 50 $- Standart VIP

Gold member for life - 150 $- Standart VIP

High Vip (Standart VIP include) group please send PM or email to [email protected] for info

After Donation please send email to [email protected]

Dismiss Notice
For open hidden message no need write thanks, thank etc. Enough is click to like button on right side of thread.

How to select all data from table (SQL To LINQ)

Discussion in 'Delphi Programming' started by AdminDF, Apr 18, 2013.

  1. AdminDF
    Online

    AdminDFAdminDF is a Verified Member Delphifan Staff Member DF Staff

    How to select all data from table (SQL To LINQ):
    The following code snippet shows you how you can query direct to SQL Server and in its comparison how you can query using LINQ and get all data.
    This is the connection string which let you connect to the server:

                  Data Source = "Your Server Name"
                  Initial Catalog = "The name of your database"
                  Integrated Security = "true" for getting your credentials automatic to your current login account in windows, in this way you don't have to use user id and password while establishing connection with SQL server.

    Code:
    public static string conString = @"Data Source =  MOAVIA_OSAMA-PC\SQLEXPRESS;Initial Catalog = MyFirst ; Integrated Security = true";
    In SQL we write the following query to select all data from a particular table, here we are selecting data from table Customer which contains ID, Name and Address columns in it.

    Code:
     string SQLQuery = "SELECT * FROM Customer";
    Now, we would execute this query and return all table from database to store in table. The following GetDataTable() function execute the query and returns the data in table:

    Code:
    public static DataTable GetDataTable(string query)
    {
                        
      SqlConnection SQLCon = new SqlConnection(conString);
      SqlCommand cmd = new SqlCommand(query, SQLCon);
      DataTable table = new DataTable();
      SqlDataAdapter da = new SqlDataAdapter(cmd);
    
      da.Fill(table); // and filling the table against the query
              
      return table;
    
    }
    In the following statement we executed the query and store/show the data in DataGridView:

    Code:
    dataGridView1.DataSource = getDataTable(SQLQuery);
    Result In DataGridView:

    [​IMG]

    Now In LINQ:

    The following is the class generated when you add "Linq to SQL classes" to project, which takes an argument of connection string:

    Code:
    DataClasses1DataContext dc = new DataClasses1DataContext(conString);
    The following query also selects all data from table Customer:

    Code:
    var LINQuery =
             from Customer c in dc.Customers
             select c;
    In the following statement we executed the query and store/show the data in DataGridView:

    Code:
    dataGridView1.DataSource = LINQuery;
     

Share This Page