Dismiss Notice

REGISTRATION IS AFTER ADMIN ACTIVATION

DONATIONS WITH PAYPAL CLICK TO BUTTON

1 MONTH VIP - 5$; 3 MONTHS VIP - 10$; 6 MONTHS VIP - 20$; 1 YEAR VIP - 30$; 2 YEARS VIP - 50$; GOLD USER FOR LIFE VIP - 150$

DONATIONS WITH Bitcoin Address:3NRs3CK3fhXifrNYxHEZKpETDd9vNLMsMD

Dismiss Notice
The registration is approved by the Administrator. It takes about 1 day to approve your registration
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 get the data from table through ID or Name (SQL To LINQ)

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

  1. N0body
    Online

    N0bodyN0body is a Verified Member DelphiFan Administrator Staff Member DF Staff

    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 on the basis of ID and Name.
    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.
    Query Against ID;

    Code:
    string SQLQuery = "SELECT * FROM Customer WHERE ID = 3"; 
    Query Against Name;

    Code:
    string SQLQuery = "SELECT * FROM Customer WHERE Name = 'Maryam' "; 
    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;
    }      
    And showing query result in DataGridView:

    In LINQ we'll write the queries like that:
    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);
    Query Against ID;

    Code:
    var LINQuery =
    from Customer c in dc.Customers
    where c.ID == 3
    select c;
    Query Against Name;

    Code:
    var LINQuery =
    from Customer c in dc.Customers
    where c.Name.Equals("Maryam")
    select c;
    And showing query result in DataGridView:

    Code:
    dataGridView1.DataSource = LINQuery;
     
  2. adilbertofarramilo
    Offline

    adilbertofarramilo DF Member

Share This Page

Laws
Our website, law, laws, copyright and aims to be respectful of individual rights. Our site, as defined in the law of 5651 serves as a provider of space. According to the law, contrary to the law of site management has no obligation to monitor content. Therefore, our site has adopted the principle of fit and remove. Works are subject to copyright laws and is shared in a manner that violated their legal rights, or professional associations, rights holders who, adsdelphi@gmail.com I can reach us at e-mail address. Complaints considered to be infringing on the examination of the content will be removed from our site.
Donate Help To Us and Be VIP
DONATIONS WITH PAYPAL CLICK TO BUTTON
6 MONTHS VIP - 20$; 1 YEAR VIP - 30$; 2 YEARS VIP - 50$; GOLD USER FOR LIFE VIP - 150$
Social Block