private void gunaButton5_Click(object sender, EventArgs e) { NewClient newClient = new NewClient(); DialogResult dialogResult = new DialogResult(); dialogResult = newClient.ShowDialog(); UpdateClients(); }
private void gunaButton1_Click(object sender, EventArgs e) { this.Hide(); NewClient newClient = new NewClient(); DialogResult dialogResult = new DialogResult(); dialogResult = newClient.ShowDialog(); this.Show(); }
private void gunaButton6_Click(object sender, EventArgs e) { connection = new SqlConnection(connectionString); connection.Open(); int index = 0; foreach (DataGridViewCell cell in AllDataGridView.SelectedCells) { index = cell.RowIndex; } string a = (AllDataGridView[0, index].Value.ToString()); string b = (AllDataGridView[1, index].Value.ToString()); string c = (AllDataGridView[2, index].Value.ToString()); string d = (AllDataGridView[3, index].Value.ToString()); string ee = (AllDataGridView[4, index].Value.ToString()); string f = (AllDataGridView[5, index].Value.ToString()); string g = (AllDataGridView[6, index].Value.ToString()); int h = Convert.ToInt32((AllDataGridView[8, index].Value)); int i = Convert.ToInt32((AllDataGridView[9, index].Value)); DateTime date = Convert.ToDateTime((AllDataGridView[7, index].Value)); int index1 = 0; foreach (DataGridViewCell cell in AllDataGridView.SelectedCells) { index1 = cell.RowIndex; } string query = $"select * from [user] join client on [User].ID_user=Client.Id_user"; AllDataGridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect; AllDataGridView.AllowUserToAddRows = false; using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); adapter = new SqlDataAdapter(query, connection); dataSet = new DataSet(); adapter.Fill(dataSet); AllDataGridView.DataSource = dataSet.Tables[0]; connection.Close(); } connection = new SqlConnection(connectionString); connection.Open(); string choose_id = (AllDataGridView[0, index1].Value.ToString()); UpdateClients(); NewClient newClient = new NewClient(Convert.ToInt32(choose_id), a, b, c, d, ee, f, g, date, h, i); DialogResult dialogResult = new DialogResult(); dialogResult = newClient.ShowDialog(); UpdateClients(); }