Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- using System;
- using System.Collections.Generic;
- using System.Text;
- using System.Data.SqlClient;
- using System.Data;
- using System.Windows.Forms;
- namespace SQLSelectInsertUpdateChuaFinal
- {
- class ClubRegistrationQuery : ClassRegistrationQuery
- {
- SqlConnection sqlConnection = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=C:\\Users\\ADMIN\\source\repos\\SQLSelectInsertUpdateChuaFinal\\SQLSelectInsertUpdateChuaFinal\\ClubDB.mdf;Integrated Security=True");
- DataTable dt = new DataTable();
- BindingSource bsource = new BindingSource();
- public bool DisplayList()
- {
- string ViewClubMembers = ("SELECT StudentId, FirstName, MiddleName, LastName, Age, Gender, Program * from ClubMembers");
- SqlDataAdapter sd = new SqlDataAdapter(ViewClubMembers, sqlConnection);
- dataTable.Clear();
- sqlAdapter.Fill(dataTable);
- bindingSource.DataSource = dataTable;
- return true;
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement