예제 #1
0
        protected void cmdAdd_Click(object sender, EventArgs e)
        {
            clsCustomer DB = new clsCustomer();

            try
            {
                if (txtCustomerid.Text == null)
                {
                    lblResults.Text = "Please enter the customer number";
                    return;
                }
                if (txtCustomerName.Text == null)
                {
                    lblResults.Text = "Please enter the customer name";
                    return;
                }
                if (txtAddress.Text == null)
                {
                    lblResults.Text = "Please enter the location";
                    return;
                }

                int reccount = 0;
                reccount = DB.FindRecKount(txtCustomerid.Text);

                if (reccount > 0)
                {
                    lblResults.Text = "Record already exists!!!";
                    return;
                }

                DB.Add_rec(txtCustomerid.Text, txtCustomerName.Text, txtAddress.Text, txtTelephoneNo.Text);

                //public string Add_rec(String txtCustomerid, String txtCustomerName, String txtAddress,String txtTelephoneNo) Define the ADO.NET objects.
                //string connectionString =
                //connectionString = WebConfigurationManager.ConnectionStrings["FleetConnectionString"].ConnectionString;

                //string selectSQL = "SELECT * FROM tb_Customer ORDER BY convert(int,customerno)";
                //SqlConnection con = new SqlConnection(connectionString);
                //SqlCommand cmd = new SqlCommand(selectSQL, con);
                //SqlDataAdapter adapter = new SqlDataAdapter(cmd);

                // Fill the DataSet.
                DataSet ds = new DataSet();
                ds = DB.FindTable();
                //adapter.Fill(ds, "tb_Customer");
                // Perform the binding.
                GridView1.DataSource = ds;
                GridView1.DataBind();

                lblResults.Text = "Operation successful";

                txtCustomerid.Text   = "";
                txtCustomerName.Text = "";
                txtAddress.Text      = "";
                txtTelephoneNo.Text  = "";

                return;
            }
            catch (Exception err)
            {
                EventLog log = new EventLog();
                log.Source = "Micar System";
                log.WriteEntry(err.Message, EventLogEntryType.Error);
                return;
            }
            finally
            {
                //con.Close();
            }
        }