Advertisement
RockField64

ClubRegistrationQuery

Jan 21st, 2022
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 1.08 KB | None | 0 0
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Text;
  4. using System.Data.SqlClient;
  5. using System.Data;
  6. using System.Windows.Forms;
  7.  
  8. namespace SQLSelectInsertUpdateChuaFinal
  9. {
  10.             class ClubRegistrationQuery : ClassRegistrationQuery
  11.         {
  12.             SqlConnection sqlConnection = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=C:\\Users\\ADMIN\\source\repos\\SQLSelectInsertUpdateChuaFinal\\SQLSelectInsertUpdateChuaFinal\\ClubDB.mdf;Integrated Security=True");
  13.             DataTable dt = new DataTable();
  14.             BindingSource bsource = new BindingSource();
  15.  
  16.             public bool DisplayList()
  17.             {
  18.                 string ViewClubMembers = ("SELECT StudentId, FirstName, MiddleName, LastName, Age, Gender, Program * from ClubMembers");
  19.                 SqlDataAdapter sd = new SqlDataAdapter(ViewClubMembers, sqlConnection);
  20.                 dataTable.Clear();
  21.                 sqlAdapter.Fill(dataTable);
  22.                 bindingSource.DataSource = dataTable;
  23.                 return true;
  24.             }
  25.         }
  26. }
  27.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement