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();
}
