Skip to content
TheChatArchiveThe Chat Archive
gpt-4-0314· OpenAIAi2 WildChat-4.8M (AI2)

edit this code so that it contains a second dataviewgrid which contains displays this…

  1. User

    edit this code so that it contains a second dataviewgrid which contains displays this time a table from the SAME databse called tbl_user and contains columns username|password|fullname|email|address

    make sure it has the exact same functions as the first dataview grid and it also gives the same functions to 2 new buttons (button2 and button3) which as are equivlant to save button and button1 for the first dataview grid

    in conclusion i want to duplicate the dataviewgrid and its 2 buttons but this time for another table within the database code to be rewritten: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.OleDb; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; using System.IO;

    namespace ApplianceRental { public partial class AdminDashboardForm : Form { OleDbDataAdapter sda; OleDbCommandBuilder scb; DataTable dt; OleDbConnection con; string connectionString = $@“Provider=Microsoft.Jet.OLEDB.4.0;Data Source = { Path.Combine(Application.StartupPath, “db_users.mdb”) }”;

    public AdminDashboardForm() { InitializeComponent(); con = new OleDbConnection(connectionString); } private void AdminDashboardForm_Load(object sender, EventArgs e) { } private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { // Code logic for the event handler }

    private void saveButton_Click(object sender, EventArgs e) { using (OleDbCommand insertCommand = new OleDbCommand(“INSERT INTO ApplianceDBLIST ([Appliance], [Power Usage], [Typical Usage], [Estimated Annual Costs]) VALUES (?, ?, ?, ?)”, con), updateCommand = new OleDbCommand(“UPDATE ApplianceDBLIST SET [Appliance]=?, [Power Usage]=?, [Typical Usage]=?, [Estimated Annual Costs]=? WHERE ID=?”, con), deleteCommand = new OleDbCommand(“DELETE FROM ApplianceDBLIST WHERE ID=?”, con)) { sda.InsertCommand = insertCommand; insertCommand.Parameters.Add(“@Appliance”, OleDbType.VarWChar, 0, “Appliance”); insertCommand.Parameters.Add(“@Power_Usage”, OleDbType.VarWChar, 0, “Power Usage”); insertCommand.Parameters.Add(“@Typical_Usage”, OleDbType.VarWChar, 0, “Typical Usage”); insertCommand.Parameters.Add(“@Estimated_annual_costs”, OleDbType.VarWChar, 0, “Estimated Annual Costs”);

    sda.UpdateCommand = updateCommand; updateCommand.Parameters.Add(“@Appliance”, OleDbType.VarWChar, 0, “Appliance”); updateCommand.Parameters.Add(“@Power_Usage”, OleDbType.VarWChar, 0, “Power Usage”); updateCommand.Parameters.Add(“@Typical_Usage”, OleDbType.VarWChar, 0, “Typical Usage”); updateCommand.Parameters.Add(“@Estimated_annual_costs”, OleDbType.VarWChar, 0, “Estimated Annual Costs”); updateCommand.Parameters.Add(“@ID”, OleDbType.Integer, 0, “ID”); updateCommand.UpdatedRowSource = UpdateRowSource.None;

    sda.DeleteCommand = deleteCommand; deleteCommand.Parameters.Add(“@ID”, OleDbType.Integer, 0, “ID”); deleteCommand.UpdatedRowSource = UpdateRowSource.None;

    con.Open(); sda.Update(dt); con.Close();

    // Refresh the data after updating, to display updated data in DataGridView dt.Clear(); sda.Fill(dt); } }

    private void button1_Click(object sender, EventArgs e) { string query = “SELECT * FROM ApplianceDBLIST”; sda = new OleDbDataAdapter(query, con); OleDbCommandBuilder cmdBuilder = new OleDbCommandBuilder(sda);

    dt = new DataTable(); sda.Fill(dt); dataGridView1.DataSource = dt; }

    private void label7_Click(object sender, EventArgs e) {

    }

    private void label1_Click(object sender, EventArgs e) {

    } } }

  2. Assistant

    using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.OleDb; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; using System.IO;

    namespace ApplianceRental { public partial class AdminDashboardForm : Form { OleDbDataAdapter sda, sda2; OleDbCommandBuilder scb, scb2; DataTable dt, dt2; OleDbConnection con; string connectionString = $@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source = { Path.Combine(Application.StartupPath, “db_users.mdb”) }”;

        public AdminDashboardForm()
        {
            InitializeComponent();
            con = new OleDbConnection(connectionString);
        }
    
        private void AdminDashboardForm_Load(object sender, EventArgs e)
        {
        }
    
        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            // Code logic for the event handler
        }
    
        private void dataGridView2_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            // Code logic for the event handler
        }
    
        private void saveButton_Click(object sender, EventArgs e)
        {
            UpdateApplianceDBLIST();
        }
    
        private void button2_Click(object sender, EventArgs e)
        {
            UpdateTblUser();
        }
    
        private void button1_Click(object sender, EventArgs e)
        {
            LoadApplianceDBLIST();
        }
    
        private void button3_Click(object sender, EventArgs e)
        {
            LoadTblUser();
        }
    
        private void UpdateApplianceDBLIST()
        {
            using (OleDbCommand insertCommand = new OleDbCommand(“INSERT INTO ApplianceDBLIST ([Appliance], [Power Usage], [Typical Usage], [Estimated Annual Costs]) VALUES (?, ?, ?, ?)”, con),
            updateCommand = new OleDbCommand(“UPDATE ApplianceDBLIST SET [Appliance]=?, [Power Usage]=?, [Typical Usage]=?, [Estimated Annual Costs]=? WHERE ID=?”, con),
            deleteCommand = new OleDbCommand(“DELETE FROM ApplianceDBLIST WHERE ID=?”, con))
            {
                SetApplianceDBLISTCommands(insertCommand, updateCommand, deleteCommand);
    
                con.Open();
                sda.Update(dt);
                con.Close();
    
                // Refresh the data after updating, to display updated data in DataGridView
                dt.Clear();
                sda.Fill(dt);
            }
        }
    
        private void UpdateTblUser()
        {
            using (OleDbCommand insertCommand = new OleDbCommand(“INSERT INTO tbl_user ([username], [password], [fullname], [email], [address]) VALUES (?, ?, ?, ?, ?)”, con),
            updateCommand = new OleDbCommand(“UPDATE tbl_user SET [username]=?, [password]=?, [fullname]=?, [email]=?, [address]=? WHERE ID=?”, con),
            deleteCommand = new OleDbCommand(“DELETE FROM tbl_user WHERE ID=?”, con))
            {
                SetTblUserCommands(insertCommand, updateCommand, deleteCommand);
    
                con.Open();
                sda2.Update(dt2);
                con.Close();
    
                // Refresh the data after updating, to display updated data in DataGridView
                dt2.Clear();
                sda2.Fill(dt2);
            }
        }
    
        private void LoadApplianceDBLIST()
        {
            string query = "SELECT * FROM ApplianceDBLIST";
            sda = new OleDbDataAdapter(query, con);
            OleDbCommandBuilder cmdBuilder = new OleDbCommandBuilder(sda);
    
            dt = new DataTable();
            sda.Fill(dt);
            dataGridView1.DataSource = dt;
        }
    
        private void LoadTblUser()
        {
            string query = "SELECT * FROM tbl_user";
            sda2 = new OleDbDataAdapter(query, con);
            OleDbCommandBuilder cmdBuilder2 = new OleDbCommandBuilder(sda2);
    
            dt2 = new DataTable();
            sda2.Fill(dt2);
            dataGridView2.DataSource = dt2;
        }
    
        private void SetApplianceDBLISTCommands(OleDbCommand insertCommand, OleDbCommand updateCommand, OleDbCommand deleteCommand)
        {
            sda.InsertCommand = insertCommand;
            insertCommand.Parameters.Add(“@Appliance”, OleDbType.VarWChar, 0, “Appliance”);
            insertCommand.Parameters.Add(“@Power_Usage”, OleDbType.VarWChar, 0, “Power Usage”);
            insertCommand.Parameters.Add(“@Typical_Usage”, OleDbType.VarWChar, 0, “Typical Usage”);
            insertCommand.Parameters.Add(“@Estimated_annual_costs”, OleDbType.VarWChar, 0, “Estimated Annual Costs”);
    
            sda.UpdateCommand = updateCommand;
            updateCommand.Parameters.Add(“@Appliance”, OleDbType.VarWChar, 0, “Appliance”);
            updateCommand.Parameters.Add(“@Power_Usage”, OleDbType.VarWChar, 0, “Power Usage”);
            updateCommand.Parameters.Add(“@Typical_Usage”, OleDbType.VarWChar, 0, “Typical Usage”);
            updateCommand.Parameters.Add(“@Estimated_annual_costs”, OleDbType.VarWChar, 0, “Estimated Annual Costs”);
            updateCommand.Parameters.Add(“@ID”, OleDbType.Integer, 0, “ID”);
            updateCommand.UpdatedRowSource = UpdateRowSource.None;
    
            sda.DeleteCommand = deleteCommand;
            deleteCommand.Parameters.Add(“@ID”, OleDbType.Integer, 0, “ID”);
            deleteCommand.UpdatedRowSource = UpdateRowSource.None;
        }
    
        private void SetTblUserCommands(OleDbCommand insertCommand, OleDbCommand updateCommand, OleDbCommand deleteCommand)
        {
            sda2.InsertCommand = insertCommand;
            insertCommand.Parameters.Add(“@username”, OleDbType.VarWChar, 0, “username”);
            insertCommand.Parameters.Add(“@password”, OleDbType.VarWChar, 0, “password”);
            insertCommand.Parameters.Add(“@fullname”, OleDbType.VarWChar, 0, “fullname”);
            insertCommand.Parameters.Add(“@email”, OleDbType.VarWChar, 0, “email”);
            insertCommand.Parameters.Add(“@address”, OleDbType.VarWChar, 0, “address”);
    
            sda2.UpdateCommand = updateCommand;
            updateCommand.Parameters.Add(“@username”, OleDbType.VarWChar, 0, “username”);
            updateCommand.Parameters.Add(“@password”, OleDbType.VarWChar, 0, “password”);
            updateCommand.Parameters.Add(“@fullname”, OleDbType.VarWChar, 0, “fullname”);
            updateCommand.Parameters.Add(“@email”, OleDbType.VarWChar, 0, “email”);
            updateCommand.Parameters.Add(“@address”, OleDbType.VarWChar, 0, “address”);
            updateCommand.Parameters.Add(“@ID”, OleDbType.Integer, 0, “ID”);
            updateCommand.UpdatedRowSource = UpdateRowSource.None;
    
            sda2.DeleteCommand = deleteCommand;
            deleteCommand.Parameters.Add(“@ID”, OleDbType.Integer, 0, “ID”);
            deleteCommand.UpdatedRowSource = UpdateRowSource.None;
        }
    
        private void label7_Click(object sender, EventArgs e)
        {
    
        }
    
        private void label1_Click(object sender, EventArgs e)
        {
    
        }
    }
    

    }