C# Simple Inventory - Subtracting Quantity of Items Connected to the Database

* Connecting MySql to C# - • Connecting MySql to C#
* C# - Load Data Into DataGridView From MySQL Database - • C# - Load Data Into Da...
* C# - INSERT, UPDATE and DELETE with MySQL Database - • C# - INSERT, UPDATE an...

[@malikahsan6648]

Thanks , your video more help me , Allah Blessed for you. 💓💓💓

[@joszxchua]

How po yung pag clinick yung row sa datagrid view is ma rrevert po yung value niya sa mga text box po?

[@aaronmarkmanuel6982]

Ano po pwede kung milktea shop tas per ingredients ng milktea na inorder e mababawas sa stocks??

[@anacletocorbeta3846]

try ko lang po magbigay ng idea,
per Table natin may primary key then may naka set na name gawa ka nalang ng textbox for name
Ex. txtbox1 = productname represented by primary key
txtbox2 = sell
bawat select mo kay textbox 1, ilalagay mo naman kay textbox2 kung ilan ang nabawas para madeduct din don sa table nya.
command type nya update din...

[@anacletocorbeta3846]

ex.
Database (MilkteaTable)
Primarykey 1 --> Productname = Sago; productprice = 15; ProductQuantity = 50
sa Form mo meron namang
Textbox1 = Productname
Textbox2=Productprice
Button= sell
everytime na e run mo na ang input mo is product name lang, bale display nlang si textbox2 at si button sell naman ang taga update

[@lifebest4404]

C# button click to offline mysql database data how to sync online server how

[@ma.aliciaebo437]

Ma'am saan po galing yung idmed na variable?

[@drpt]

Hi! Dineclare ko sya sa taas as a public variable since more than one function ang nagcacall sa kanya. Sorry, saglit ko lang sya naipakita kaya hindi pansinin. Hehe.

[@mjanedelossantos]

Ma'am pwedi po ba yan sa simple php lang at xamp?

[@Fadz-yg1fo]

Pwede ba kayo gumawa ng POS SYSTEM? VB NET MS ACCESS

[@drpt]

Hi! I'm going to upload a sample of a Point of Sale (POS) system. Kaso mysql and C# ang gamit. Maybe you can use it as a reference.

[@Fadz-yg1fo]

@@drpt walao code niya

[@mjanedelossantos]

Pwedi kaya ito sa simple database namin na php at sql lang po?

[@drpt]

No po. Magkaiba po kasi ang C# and PHP. 😅

[@Redstrawberry0621]

Thank you ma'am❤️, okay lang Po ba na kahit xammp gamit ko?

[@drpt]

Yes.

[@corneliollagas5378]

Hello ma'am this tutorial is very helpful, thanks ma'am, may tanong lang Po Ako eh pano Naman Po I ensert yung sales mo Doon sa sales table after sabtracting remaining stocks qty sa sales qty Po ma'am, thank you so much in advance ma'am
Remaining stocks - sales
After that sales must be insert into sales table and display it.

[@drpt]

Hello! Add ka lang ng INSERT command after ng UPDATE command. 😊

[@loyd7654]

what if yung quantity ay nasa kabilang table

[@Code_with_Iphie]

The method get data is not displaying on my visual studio.

[@anacletocorbeta3846]

Getdata() = its a procedure (Function)
If you don't have it in your project it will not work...
For you to refresh all data in your datagridview you will call that procedure/function which is the getdata()

[@anacletocorbeta3846]

You can create that "getdata" actually in your project whether in module or in your form

[@caramantigue4275]

Maam paano po yung datetimepicker ma save sa database po?

[@drpt]

Set mo lang din as DateTime yung nasa database mo. 😊

[@shamim9455]

Can i share a project with u??

[@drpt]

Sure.

[@shamim9455]

@@drpt give your email

[@shamim9455]

@@drpt plz give mail id

[@drpt]

@@shamim9455 [e-mail]

[@jupiterdesuyo1530]

Ma'am gawa po kayo sana ng full tutorial nito 😢

[@vincentsamante1311]

Hello po maam, ask ko lang po pano po kung decimal yong quantity, may ginawa kasi kami na POS system tas example sa nail or pako po, per kilo po kasi yon tas 1/4 lang bibilhin ng customer 0.25 po yon nag eeror po kasi sa string namin
sana po masagot huhuhu

[@drpt]

Hello! Make sure na nakadeclare as double yung variable. :))
For example:
double var_stocks = 0;
double var_sell = 0;
double result = 0;
var_stocks = Convert.ToDouble(txtQty.Text);
var_sell = Convert.ToDouble(txtSold.Text);

[@vincentsamante1311]

@@drpt sige po try ko po, nagtataka nga ako bat sa price okay naman pero sa quantity hindi hahahhaah
May fb page kapo maam? para ma sent ko yong screenshot if ever ayaw padin huhuhh ito nalang talag problema namin para kasi sa thesis namin to tas need ma deploy ngayng monday huhuh

[@vincentsamante1311]

@@drpt na try ko na po di padin huhhu

[@drpt]

@@vincentsamante1311 Sa database mo nakadouble din sya?

[@drpt]

Alright, wait I'll create an fb page para na rin sa iba pang may questions. Hehe.

[@sherwinntinao5851]

mam pwede po ako mag req kung paano po gumawa ng inventory for monitoring ng item

[@drpt]

Hello! Meron pa tayong ibang tutorials. Kung yung mismong core ang kailangan mo like Insert, Update and Delete, meron na po tayo. :)
* Connecting MySql to C# - ruclips.net/video/wtgFal1ofdM/видео.html
* C# - Load Data Into DataGridView From MySQL Database - ruclips.net/video/zSwWcteetvE/видео.html
* C# - INSERT, UPDATE and DELETE with MySQL Database - ruclips.net/video/yfSSSCmy-3s/видео.html

[@Redstrawberry0621]

Ma'am pwede Po ako mag request ulit🙉, gusto kopo mag add ikaw Ng another form para Naman sa pag select Ng product name, qty and price?

[@drpt]

What exactly? Opening new windows forms?

[@Redstrawberry0621]

@@drpt no ma'am , don Po sa form nayon magseselect Ng Product name, qty etc. Tas andun Po Yung sell button. Thank you 🥺

[@hardcarry6211]

pwede po ba mahingi uploaded na file po neto? thank you po!

[@drpt]

Sure. drive.google.com/file/d/1Nm9nUCId8wUzjrW2PbTnZNkigfWeXw8n/view?usp=sharing

[@Fadz-yg1fo]

Paano Naman pag vb Ms access database pos?

[@drpt]

Try this example.
Private Sub btnSubtract_Click()

'Declare ka lang ng variables
Dim num1 As Double
Dim num2 As Double
Dim result As Double
If IsNumeric(Me.num1.Value) And IsNumeric(Me.num2.Value) Then
num1 = CDbl(Me.txtnum1.Value)
num2 = CDbl(Me.txtnum2.Value)
result = num1 - num2
' Database part
Dim db As Database
Set db = CurrentDb

' Create a new record in your database table
Dim rs As DAO.Recordset
Set rs = db.OpenRecordset("table_name", dbOpenDynaset)
' Adding of new record :))
rs.AddNew
rs!SubtractionResult = result
rs.Update
rs.Close
Set rs = Nothing
Set db = Nothing
MsgBox "Result: " & result, vbInformation, "Subtraction Result"
Else
MsgBox "Error.", vbExclamation, "Error"
End If
End Sub

[@Fadz-yg1fo]

@@drpt thank you sir

[@Fadz-yg1fo]

Hello Po ma'am ano language Po ito ? Pwede Po ba vb net ms access database?

[@drpt]

Hello! Yung example na binigay ko is for VB. Hehe.

[@Fadz-yg1fo]

@@drpt ma'am paano pa pag mag add stock in to stock out automatic siya mag sell vb net Ms access database ?