コード例 #1
0
 private void CompanyNametextBox_KeyDown(object sender, KeyEventArgs e)
 {
     if (e.KeyCode == Keys.Enter)
     {
         AddressrichTextBox.Focus();
         e.Handled = true;
     }
 }
コード例 #2
0
        private void saveButton_Click(object sender, EventArgs e)
        {
            if (companyCreated)
            {
                MessageBox.Show(@"Already a Company Created", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                CompanyNametextBox.Clear();
                AddressrichTextBox.Clear();
                return;
            }

            if (string.IsNullOrEmpty(CompanyNametextBox.Text))
            {
                MessageBox.Show(@"Please Enter Company Name", @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                CompanyNametextBox.Focus();
                return;
            }

            if (string.IsNullOrEmpty(AddressrichTextBox.Text))
            {
                MessageBox.Show(@"Please Enter Company Address", @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                CompanyNametextBox.Focus();
            }
            else
            {
                try
                {
                    con = new SqlConnection(cs.DBConn);
                    con.Open();
                    string query =
                        "INSERT INTO Companies (CompanyName,CompanyAddress,UserId) VALUES (@d1,@d2,@d3)" + "SELECT CONVERT(int, SCOPE_IDENTITY())";


                    cmd = new SqlCommand(query, con);

                    cmd.Parameters.AddWithValue("@d1", CompanyNametextBox.Text);
                    cmd.Parameters.AddWithValue("@d2", AddressrichTextBox.Text);
                    cmd.Parameters.AddWithValue("@d3", user_id);
                    currentCompanyId = (int)(cmd.ExecuteScalar());
                    con.Close();
                    MessageBox.Show(@"Company Registered successfully", @"Record", MessageBoxButtons.OK,
                                    MessageBoxIcon.Information);
                    CompanyNametextBox.Clear();
                    AddressrichTextBox.Clear();
                }

                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
        }