コード例 #1
0
        void showDetailBack()
        {
            try
            {
                // int check1 = 0;
                String connection = @"Data Source=DESKTOP-MV18312;Initial Catalog=SIU_database;Integrated Security=True";

                String queryString1 = "SELECT StudentID,FirstName,LastName,Batch,Stream,DateOfBirth,Sex,SchoolName,HomeAddress,TelephoneNumber,EmailAddress,AdmissionDate FROM StudentMainDetail where StudentID ='" + valueS1 + "'";
                using (SqlConnection connectionObj1 = new SqlConnection(
                           connection))
                {
                    SqlCommand command1 = new SqlCommand(
                        queryString1, connectionObj1);
                    connectionObj1.Open();
                    SqlDataReader reader = command1.ExecuteReader();
                    try
                    {
                        Console.WriteLine(reader);
                        while (reader.Read())
                        {
                            String t1  = (String)reader[0];
                            String t2  = (String)reader[1];
                            String t3  = (String)reader[2];
                            String t4  = (String)reader[3];
                            String t5  = (String)reader[4];
                            String t6  = (String)reader[5];
                            String t7  = (String)reader[6];
                            String t8  = (String)reader[7];
                            String t9  = (String)reader[8];
                            String t10 = (String)reader[9];
                            String t11 = (String)reader[10];
                            String t12 = (String)reader[11];


                            DetailOfAStudent detailOfStudent = new DetailOfAStudent(t1, t2, t3, t4, t5, t6, t7, t8, t9, t10, t11, t12);
                            detailOfStudent.Show();

                            this.Close();
                        }
                    }
                    finally
                    {
                        // Always call Close when done reading.
                        reader.Close();
                    }
                }

                //-----------------------------------------------------------------------------


                //connectionObj.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
コード例 #2
0
        private void dataGridViewByName_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            dataGridViewByName.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
            int             index1      = e.RowIndex;
            DataGridViewRow selectedRow = dataGridViewByName.Rows[index1];
            String          t1          = selectedRow.Cells[0].Value.ToString();
            String          t2          = selectedRow.Cells[1].Value.ToString();
            String          t3          = selectedRow.Cells[2].Value.ToString();
            String          t4          = selectedRow.Cells[3].Value.ToString();
            String          t5          = selectedRow.Cells[4].Value.ToString();
            String          t6          = selectedRow.Cells[5].Value.ToString();
            String          t7          = selectedRow.Cells[6].Value.ToString();
            String          t8          = selectedRow.Cells[7].Value.ToString();
            String          t9          = selectedRow.Cells[8].Value.ToString();
            String          t10         = selectedRow.Cells[9].Value.ToString();
            String          t11         = selectedRow.Cells[10].Value.ToString();
            String          t12         = selectedRow.Cells[11].Value.ToString();

            DetailOfAStudent detailOfStudent = new DetailOfAStudent(t1, t2, t3, t4, t5, t6, t7, t8, t9, t10, t11, t12);

            detailOfStudent.Show();
            this.Hide();
        }