PHpatulong 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
-
Welcome to PHCorner Forums! Sign up for free to unlock full access and exclusive privileges, including:
- Asking questions about computer and mobile issues
- Discovering internet tips for your mobile network and computer
- Status
Visual Basic .NET for Beginners
You do not have permission to view the full content of this post. Log in or register now.
You do not have permission to view the full content of this post. Log in or register now.
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?
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
sa codes mo yan ..
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);
}C# ito .. hmm ganito nlng dba my delete ka ? pag delete mo ba delete lahat ? .. kng hindi kuha ka idea dun ^^
dun sa program.cs click mo then palitan mo yun nung splash name mo
- Status