Video

I'll do it next. 😊

Walang anuman! Aral mabuti! 💕

Hi! Yes, it's suitable for multiple users.

Hi! Paki-email sakin yung project mo para macheck ko. Thank you! 😊

Alriiight, this is noted. I'll make one during my free time.

Hi! If you want to display all the records on Crystal Report, maybe one of these tutorials may help. Creating SAP Crystal Report in C#: czcams.com/video/ziP2WFpY8cw/video.html Printing Datagridview Content/Data in Crystal Report Using C# and MySQL: czcams.com/video/zOf661Rj5a0/video.html C# - Displaying Multiple Tables in Crystal Report from DataGridView with MySQL Database: czcams.com/video/-RchqMToxH4/video.html C# - Displaying Multiple Tables in Crystal Report Using Stored Procedures: czcams.com/video/TtHplaq5oXs/video.html

@@drpt thank you I did my dear. I created a subreport with the data of the datagridView through a dataset and I load it as a subreport to my main report. Thank you so much.

Hi! Click Modify > Transform

This is noted! :)

Hi! Simply right click on your report > Insert > Chart

Sure, sure. This is noted. 😊

@@drpt hi maam, question lang done developing the attendance system with database, then pano po sya iinstall sa ibang computer? And ano ano po ang need gawin para matransfer pati yung database?

Walang anuman! Aral mabuti! 💕

@@drpt, Ma'am another concern Pwede po ba gamitin ang WriteXmlSchema sa tatlong datagrideviews? Yung tutorial mo na "Printing Datagridview Content/Data in Crystal Report Using C# and MySQL" ang code ko po. Pwede ma merge ba yun tatlong xml files? May tatlong tables po ako to display sa respective datagridview for a specific record. Yung datagridview1 ay may laman na course. Yung datagridview2 ay may laman na work experience at ang pangatlong which is datagridview3 ay may laman na training attended. Sori po sa aking kakulitan. My Bad...

@@drpt ♥♥♥

Hello! Yes, modify this part. Path ng xml files mo. DataTable dataTable1 = ReadXmlFile("path/to/xmlcourse.xml"); DataTable dataTable2 = ReadXmlFile("path/to/xmlworkexpi.xml"); DataTable dataTable3 = ReadXmlFile("path/to/xmltrainingsattended.xml");

@@drpt, Salamuch. ♥♥♥

Hi! Yes, it's possible. Actually, I'm currently working on the tutorial for that. Sorry for the delays. I've just been a little busy lang. 😅

@drpt So... so... so... sorries po sa aking attitude. My bad. Kulit lang po.. Salamuch in advanced.

No worries! Already posted. 😊

@@drpt, I am really happy kasi you granted my request. ♥♥♥

Hello! Thanks for the idea! Will try it sooner. I have a facebook acc. 😊

@@drpt link ng fb account mo if possible?

facebook.com/downits/ ☺

Hi! Just simply add this function para sa fraction na tinutukoy mo. Merry Christmas! 🎅 String ConvertToDecimals(String num) { String converted = null; for (int i = 0; i < num.Length; i++) { String digits = num[i].ToString(); if (digits.Equals("0")) { converted += "Zero "; } else { converted += ones(digits) + " "; } } if (!String.IsNullOrEmpty(converted)) { converted = $"{converted} {num}/100"; } return converted; }

@@drpt Salamuch ng marami sa reply. may isang concern pa po ako pwede po ba yung tatlong datagridview to crystal report? Masakit na ang ulo ko for figuring out papano ma e display yung tatlong datagridview sa crystal report using yung tutorial mo about datagridview to crystal report. Advance Happy New year from Mindanao.

@@BustaJunix no worries! Will do my best to upload a tutorial for that this week. :)

@@drpt Love it and waiting...

Thank you! ♥️

Hi! This is noted! 😊

pwede po paturo paano iconnect yung database po using Microsoft sql server?

Hi! I'll do my best to create a tutorial for that this this weekend. 😊

Hi! I already attached the SQL file on Github. :)

hello po mam paano po yung database pwede po ba sa Microsoft sql server instead na php admin? @@drpt

Hi! Yes, pwede naman.

yun pa rin po ba na database "dbpos" ang ilagay? how po mam hirap kase makahanap sa tutorial @@drpt

Yes! 😊

No worries! <3

Noted! I'll do it on the weekend. 😊

No worries! ❤

Thank you po. Opo, yes po. HAHAHAHAHA.

Yes, pwede. 😊

Hello po related topic lng po.. pwede po maka access ang ibang computer sa system ng windows form?

Yes, gamit lang ng LAN. Hehe.

@@drpt hello po ... kung malayuan di na po pwede

Ang windows form kasi, it is intended to run on individual computers.

Will do po. Thank you! ❤️

Hello! I have already placed the link in the description. :)

@@drpt thank you maam

Gumagawa Kasi kami ng POS SYSTEM FOR RESTAURANT. VB NET MS ACCESS DATABASE GAMIT NAMIN

Pwede paki demo by step?

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.

@@drpt walao code niya

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

@@drpt thank you sir

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

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

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

Alright, will do. :)

You're welcome!

Sure! Thank you sa suggestion! 😊

drive.google.com/file/d/1sHSZWs1gucml4MVB87C78326ADQIHhyl/view?usp=drive_link

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