private void Insert(CompanyUi companyUi) { try { // sqlConnection.Open(); commandString = @"INSERT INTO CompanyUi (Name) VALUES ('" + companyUi.Name + "')"; sqlCommand = new SqlCommand(commandString, sqlConnection); int isExecuted; isExecuted = sqlCommand.ExecuteNonQuery(); if (isExecuted > 0) { MessageBox.Show("Saved!!"); } else { MessageBox.Show("Not Saved!!"); } // sqlConnection.Close(); } catch (Exception exception) { MessageBox.Show(exception.Message); } }
private void CompanyUiButton_Click(object sender, EventArgs e) { CompanyUi companyUi = new CompanyUi(); companyUi.Name = companyUiTextBox.Text; Insert(companyUi); }
private void CompanyUi_Load(object sender, EventArgs e) { CompanyUi categoryUi = new CompanyUi(); categoryUi.Name = companyUiTextBox.Text; Show(categoryUi); }
private void Show(CompanyUi companyUi) { sqlConnection.Open(); // commandString = @"SELECT * FROM CompanyUi"; sqlCommand = new SqlCommand(commandString, sqlConnection); // SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand); DataTable dataTable = new DataTable(); sqlDataAdapter.Fill(dataTable); if (dataTable.Rows.Count > 0) { CompanyUiDataGridView.DataSource = dataTable; } // sqlConnection.Close(); }
private void CompanySetupButton_Click(object sender, EventArgs e) { CompanyUi companyUi = new CompanyUi(); companyUi.Show(); }