🔒 Closed Pa Help po sa Windows Form

[Licht Bach]

Pa help sa C# program mga paps Windows Form using Visual Studio

Nagbigay lang kasi assignment wala kami background

Eto ung instruction
You do not have permission to view the full content of this post. Log in or register now.

Tas eto naman ung nagawa ko mga sir, nag eerror sya pag nirurun. Mali or kulang ata ung sa part ng pag connect ko sa database
You do not have permission to view the full content of this post. Log in or register now.

Patulong po ako mga sir kahit pa guide lang.

 

[Nehemiah]

Sa STI to ah, tama ba?

 

[Licht Bach]

Oo paps hahaha, baka pede patulong

Sa STI to ah, tama ba?

 

[Nehemiah]

Oo paps hahaha, baka pede patulong

Sge, hanapin ko my repo ako nito. Anong branch ka ba?

 

[PHC-LEIIKUN]

ano year to taga STI din ako java pa amin baka pwede maka hingi for future reference hehe ty!

 

[emer0722]

 class ClubRegistrationQuery
    {
        private SqlConnection sqlConnect;
        private SqlCommand sqlCommand;
        private SqlDataAdapter sqlAdapter;
        private SqlDataReader sqlReader;
        public DataTable dataTable;
        public BindingSource bindingSource;
        private string connectionString;
        public string _FirstName, _MiddleName, _LastName, _Gender, _Program;
        public int _Age;

        public ClubRegistrationQuery()
        {
            connectionString  = "Data Source=NATANAUAN\\SQLEXPRESS;Initial Catalog=ClubDB;Integrated Security=True";
            sqlConnect = new SqlConnection(connectionString);
            dataTable = new DataTable();
            bindingSource = new BindingSource();
        }
        public bool DisplayList()
        {
            string ViewClubMembers = ("select StudentID, FirstName, MiddleName, LastName, Age, Gender, Program from ClubMembers");
            sqlCommand = new SqlCommand(ViewClubMembers, sqlConnect);

            sqlConnect.Open();
            sqlAdapter = new SqlDataAdapter(sqlCommand);
            dataTable.Clear();
            sqlAdapter.Fill(dataTable);
            bindingSource.DataSource = dataTable;
            sqlConnect.Close();
            return true;
        }
        public bool RegisterStudent(int ID, long StudentID, string FirstName, string
            MiddleName, string LastName, int Age, string Gender, string Program)
        {

            string queryString = "INSERT INTO ClubMembers VALUES(@ID, @StudentID, @FirstName, @MiddleName, @LastName, @Age, @Gender, @Program)";
            sqlCommand = new SqlCommand(queryString, sqlConnect);
            sqlCommand.Parameters.Add("@ID", SqlDbType.Int).Value = ID;
            sqlCommand.Parameters.Add("@RegistrationID", SqlDbType.BigInt).Value = StudentID;
            sqlCommand.Parameters.Add("@StudentID", SqlDbType.VarChar).Value = StudentID;
            sqlCommand.Parameters.Add("@FirstName", SqlDbType.VarChar).Value = FirstName;
            sqlCommand.Parameters.Add("@MiddleName", SqlDbType.VarChar).Value = MiddleName;
            sqlCommand.Parameters.Add("@LastName", SqlDbType.VarChar).Value = LastName;
            sqlCommand.Parameters.Add("@Age", SqlDbType.Int).Value = Age;
            sqlCommand.Parameters.Add("@Gender", SqlDbType.VarChar).Value = Gender;
            sqlCommand.Parameters.Add("@Program", SqlDbType.VarChar).Value = Program;
            sqlConnect.Open();
            sqlCommand.ExecuteNonQuery();
            sqlConnect.Close();
            return true;
        }

sir try nyo po ito

di ko po sure dun sa ClassRegistrationQuery ay yung ClubRegistrationQuery.

private ClubRegistrationQuery clubRegistrationQuery;
        private int ID, Age, count;
        private string FirstName, MiddleName, LastName, Gender, Program;

        private void button3_Click(object sender, EventArgs e)
        {
            RefreshListofClubMembers();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            count = clubRegistrationQuery.dataTable.Rows.Count;
            clubRegistrationQuery.RegisterStudent(count, long.Parse(tbStudentID.Text), tbFirstName.Text, tbMiddleName.Text, tbLastName.Text, int.Parse(tbAge.Text), cbGender.Text, cbProgram.Text);
        }

        private long StudentId;
        private void frmClubRegistration_Load(object sender, EventArgs e)
        {
            clubRegistrationQuery = new ClubRegistrationQuery();
            RefreshListofClubMembers();
        }
        public void RefreshListofClubMembers()
        {
            clubRegistrationQuery.DisplayList();
            dataGridView1.DataSource = clubRegistrationQuery.bindingSource;
        }

then ito po try nyo sa Form1 nyo po