What's new

Closed Help Visual basic 6.0 update

Status
Not open for further replies.

blitz04

Honorary Poster
Joined
Jul 8, 2015
Posts
477
Reaction
54
Points
157
Age
33
patulong po mga experts ng vb6 kasi ito yung may add,search,update,delete options ok na ako sa lahat except UPDATE kasi pag nag u update ako ng query sa isang section lahat ng information nababago mula sa id1 hangang sa sa dulo for example si id 1 papalitan ko ang age: 16 to 23 then lahat ng ages ng id 1 up to the last id eh naging 23 na din ang age pls help po TIA
 
ito po sir IMG_20151004_113406.jpg IMG_20151004_113422.jpg IMG_20151004_113443.jpg IMG_20151004_113455.jpg
 

Attachments

ito po yung database sirView attachment 33473
try mo mag update gamit ID pra yung ID lng sya mag base ..

ito UPDATE CODES KO KASO C#
Code:
private void btnUpdate_Click(object sender, EventArgs e)
        {
            if (txtSN.Text == "")
            {
                MessageBox.Show("Please input  supplier's name..");
            }
            else if (txtSA.Text == "")
            {
                MessageBox.Show("Please input address..");
            }
            if (txtCN.Text == "")
            {
                MessageBox.Show("Please input Contact #..");
            }
          
            else
            {
                DialogResult dialog = MessageBox.Show("Do you really want to Update?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (dialog == DialogResult.Yes)
                {
                    string constring = "datasource=localhost;port=3306;username=root;password=root;database=database2_db";
                    string Query = "update supplier_registration set SupplierID='" + this.lblID.Text + "',Supplier='" + this.txtSN.Text + "',Address='" + this.txtSA.Text + "',Email_address='" + this.txtEA.Text + "',Contact_number='" + this.txtCN.Text + "',Description='" + this.txtSD.Text + "'where SupplierID='" + this.lblID.Text + "';";
                    MySqlConnection MyConn = new MySqlConnection(constring);
                    MySqlCommand MyCommand = new MySqlCommand(Query, MyConn);
                    MySqlDataReader myReader;
                    try
                    {
                        MyConn.Open();
                        myReader = MyCommand.ExecuteReader();
                        if (MessageBox.Show("Successfully Update", "Success", MessageBoxButtons.OK, MessageBoxIcon.Asterisk) == DialogResult.OK)
                            while (myReader.Read())
                            {
                                string update = myReader.GetString("SupplierID");
                                lblID.Text = update;
                            }
                        MyConn.Close();
                    }

                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                }
            }
        }
    }
}
 
try mo mag update gamit ID pra yung ID lng sya mag base ..

ito UPDATE CODES KO KASO C#
Code:
private void btnUpdate_Click(object sender, EventArgs e)
        {
            if (txtSN.Text == "")
            {
                MessageBox.Show("Please input  supplier's name..");
            }
            else if (txtSA.Text == "")
            {
                MessageBox.Show("Please input address..");
            }
            if (txtCN.Text == "")
            {
                MessageBox.Show("Please input Contact #..");
            }
         
            else
            {
                DialogResult dialog = MessageBox.Show("Do you really want to Update?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (dialog == DialogResult.Yes)
                {
                    string constring = "datasource=localhost;port=3306;username=root;password=root;database=database2_db";
                    string Query = "update supplier_registration set SupplierID='" + this.lblID.Text + "',Supplier='" + this.txtSN.Text + "',Address='" + this.txtSA.Text + "',Email_address='" + this.txtEA.Text + "',Contact_number='" + this.txtCN.Text + "',Description='" + this.txtSD.Text + "'where SupplierID='" + this.lblID.Text + "';";
                    MySqlConnection MyConn = new MySqlConnection(constring);
                    MySqlCommand MyCommand = new MySqlCommand(Query, MyConn);
                    MySqlDataReader myReader;
                    try
                    {
                        MyConn.Open();
                        myReader = MyCommand.ExecuteReader();
                        if (MessageBox.Show("Successfully Update", "Success", MessageBoxButtons.OK, MessageBoxIcon.Asterisk) == DialogResult.OK)
                            while (myReader.Read())
                            {
                                string update = myReader.GetString("SupplierID");
                                lblID.Text = update;
                            }
                        MyConn.Close();
                    }

                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                }
            }
        }
    }
}

sir paano mag update gamit id?
 
sir paano mag update gamit id?
tingnan mo yung connection ko bali yung supplierID my lblID.text pra kng iclick ko yong iuupdate mlalagay yung ID nya sa lblID tpos dba sa dabase ang ID ee di magkakapareha kaya yun .. isa lng ang maupdate kc ung ID nya wlang kapareha .. sa ginawa mo kc wala kang binasehan kundi txtbox lng sa lahat kaya lahat din yun update sa database :)
 
pag nilagay ko po kasi yung text1.text which is id nag eeror invalid number of arguments sabi sir
 
pag nilagay ko po kasi yung text1.text which is id nag eeror invalid number of arguments sabi sir
tingnan mo ito ito yng connection ko sa database ko .
Code:
string constring = "datasource=localhost;port=3306;username=root;password=root;database=database2_db";
string Query = "update supplier_registration set SupplierID='" + this.lblID.Text + "',Supplier='" + this.txtSN.Text + "',Address='" + this.txtSA.Text + "',Email_address='" + this.txtEA.Text + "',Contact_number='" + this.txtCN.Text + "',Description='" + this.txtSD.Text + "'where SupplierID='" + this.lblID.Text + "';";
MySqlConnection MyConn = new MySqlConnection(constring);
MySqlCommand MyCommand = new MySqlCommand(Query, MyConn);
MySqlDataReader myReader;
try
{
MyConn.Open();
myReader = MyCommand.ExecuteReader();
if (MessageBox.Show("Successfully Update", "Success", MessageBoxButtons.OK, MessageBoxIcon.Asterisk) == DialogResult.OK)
while (myReader.Read())
{
string update = myReader.GetString("SupplierID");
lblID.Text = update;
}
MyConn.Close();
}

catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
 
medyo hirap ako i annalyze yang c++ sir wala pa kasi ako background ng c++ vb palang sir
 
oo bro cge try ko tignan bro ai oo nga pala c# pala nitype mo hehe sorry hirap ako ayaw din lumabas yung splash screen na nilagay ko
 
Status
Not open for further replies.

Similar threads

Back
Top