How many users can use this at once? Could it be used at 4 registers and it track all the inventory as one?
@drpt3 күн бұрын
Hi! Yes, it's suitable for multiple users.
@WINMEB6 күн бұрын
Hi good day sayo idol.. Paano magmatch ng 2 exact or nearest values sa dalawang gridviews tapos kapag nakahanap na ng match ilalagay sa pangatlong gridview tapos idedelete na yung dalawang items na nahanap sa dalawang gridviews. Pwede gumawa ka ng video nyan idol gridview matching items. Maraming salamat at more power & success sayo idol..
@Sungjinwoo-xx4wd9 күн бұрын
ate ganto lang po akin pag tapos na 7/8 if tama naman lahat sinagot ko don sa ginawa ko huhuhu pa help po
@drpt9 күн бұрын
Hi! Paki-email sakin yung project mo para macheck ko. Thank you! 😊
@BustaJunixАй бұрын
Ma'am gandang gabi po. Gawa po kayo ng Daily Time Record.
@drptАй бұрын
Alriiight, this is noted. I'll make one during my free time.
@mermaidoasis8452Ай бұрын
Thank you so much for this video, I would like to ask you something please. Supposing we want to pass parameterers from DataGridView values, what can we do in order to display all records to the report? I tried the following without effect because I get only the last record of datagridview displayed in the report. So I wonder, if it's not the proper way to pass values from DataGridView to Crystal Report. I would appreciated it, to explain me or to suggest me another tutorial, for this purpose. Thank you so much in advanced. if (dtGridViews.Any()) { foreach (var dtGridV in dtGridViews) { for (int iR = 0; iR <= dtGridV.Rows.Count - 1; iR++) for (int iC = 0; iC <= dtGridV.Columns.Count - 1; iC++) { ColumnName = dtGridV.Columns[iC].Name; if (paramNames.Contains(ColumnName)) { if (dtGridV.Rows[iR].Cells[ColumnName].Value.GetType() == typeof(string)) { string str = dtGridV.Rows[iR].Cells[ColumnName].Value.ToString(); OrderReport.SetParameterValue(ColumnName, str); } } } } }
@drptАй бұрын
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#: kzbin.info/www/bejne/sJqzY4p8pb5rmdk Printing Datagridview Content/Data in Crystal Report Using C# and MySQL: kzbin.info/www/bejne/sIDJZ2lnh89ol5I C# - Displaying Multiple Tables in Crystal Report from DataGridView with MySQL Database: kzbin.info/www/bejne/Y4PGmaSDidSrfpY C# - Displaying Multiple Tables in Crystal Report Using Stored Procedures: kzbin.info/www/bejne/iqWroZ-XppqijtU
@mermaidoasis8452Ай бұрын
@@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.
@CATLOVER69428Ай бұрын
How do i flip the symbol vertically and horizontally?
@drptАй бұрын
Hi! Click Modify > Transform
@uyronmarcherhyssq.3772 ай бұрын
subsribe ka saakin sheeshable noice guide
@musicallyrics20223 ай бұрын
hello po maam. pwede po ba kayo gumawa ng code for quantity adding and decreasing po. pang inventory. with database po sana sqlserver 🙂
@drpt3 ай бұрын
This is noted! :)
@Aviation_6033 ай бұрын
Laking tulong po ng mga tutorial mo po🫶
@user-kd6ty3pr6r3 ай бұрын
Hello DRPT, how can I add charts in Crystal report?
@drpt3 ай бұрын
Hi! Simply right click on your report > Insert > Chart
@user-ui6cw7nk9u3 ай бұрын
Maam pwede po kayo gumawa ng code for displaying specific profile kapag naglalogin? For example pag si user 1 ang lalabas sa next form is Juan Delacruz pag si user 2 naman Pedro ang lalabas. With database. 😁
@drpt3 ай бұрын
Sure, sure. This is noted. 😊
@user-ui6cw7nk9u3 ай бұрын
@@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?
@BustaJunix3 ай бұрын
@DRPT, Napakaraming thank you po sa pag grant ng request ko po. Yung mga tutorials nyo po ay malaking tulong po sa akin pag self study ng programming.
@drpt3 ай бұрын
Walang anuman! Aral mabuti! 💕
@BustaJunix3 ай бұрын
@@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...
@BustaJunix3 ай бұрын
@@drpt ♥♥♥
@drpt3 ай бұрын
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");
@BustaJunix3 ай бұрын
@@drpt, Salamuch. ♥♥♥
@bijus30343 ай бұрын
Nice tutorial. Please share files as well
@BustaJunix3 ай бұрын
Wow!!! napakagaling nyo po talaga magturo. ❤️ ❤️ ❤️ Possible po kayo makagawa ng tutorial about Crystal Report na may Tatlo or Multiple Entries From DatagridView na nakadisplay with MySql Database? So... so... so... sorries po. MySql po kasi ang gamit ko. Salamuch!!!
@drpt3 ай бұрын
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. 😅
@BustaJunix3 ай бұрын
@drpt So... so... so... sorries po sa aking attitude. My bad. Kulit lang po.. Salamuch in advanced.
@drpt3 ай бұрын
No worries! Already posted. 😊
@BustaJunix3 ай бұрын
@@drpt, I am really happy kasi you granted my request. ♥♥♥
@PSGGuns4 ай бұрын
new subsr here, at nag babalik loob ako sa IT life :D Try 2d games po, do you have IG? or ibang socmed?
@drpt4 ай бұрын
Hello! Thanks for the idea! Will try it sooner. I have a facebook acc. 😊
@PSGGuns4 ай бұрын
@@drpt link ng fb account mo if possible?
@drpt4 ай бұрын
facebook.com/downits/ ☺
@BustaJunix5 ай бұрын
Merry Christmas and advance Happy New Year! Pwede po kayo gumawa ng video tutorial ng multiple datagridview to crystal report? 3 datagridviews in particular po? Salamuch...
@BustaJunix5 ай бұрын
Maraming salamat po sa mga tutorials mo. Paano po ipa display halimbawa ng 150.05 into words na "One Hundred Fifty and 05/100 pesos only" yun kasi ang ginagamit namin. Possible po ba yun? Salamat in Advance...
@drpt5 ай бұрын
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; }
@BustaJunix5 ай бұрын
@@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.
@drpt5 ай бұрын
@@BustaJunix no worries! Will do my best to upload a tutorial for that this week. :)
@BustaJunix5 ай бұрын
@@drpt Love it and waiting...
@AbrahamMorgado5 ай бұрын
Very informative, please choose one language and stick to it.
@drpt5 ай бұрын
Thank you! ♥️
@vikramm52855 ай бұрын
Superrrrr
@jerrykingaboy34265 ай бұрын
Good Job po Ma'am, baka may tutorial po kaya na yung crystal report mag load po try code gamit ang load crystal report using report engines, at saka pwede maka search sa crystal report.
@drpt5 ай бұрын
Hi! This is noted! 😊
@JvQuiamco5 ай бұрын
hello po mam paano po yung database pwede po ba sa Microsoft sql server instead na php admin?
@JvQuiamco5 ай бұрын
pwede po paturo paano iconnect yung database po using Microsoft sql server?
@drpt5 ай бұрын
Hi! I'll do my best to create a tutorial for that this this weekend. 😊
@arlancalagos76465 ай бұрын
Pano po pag multiple forms
@Mr.Nobody-xm3st5 ай бұрын
paano po i import yung database nya?
@drpt5 ай бұрын
Hi! I already attached the SQL file on Github. :)
@JvQuiamco5 ай бұрын
hello po mam paano po yung database pwede po ba sa Microsoft sql server instead na php admin? @@drpt
@drpt5 ай бұрын
Hi! Yes, pwede naman.
@JvQuiamco5 ай бұрын
yun pa rin po ba na database "dbpos" ang ilagay? how po mam hirap kase makahanap sa tutorial @@drpt
@jupiterdesuyo15306 ай бұрын
Ma'am gawa po kayo sana ng full tutorial nito 😢
@angius6 ай бұрын
You don't ever, _ever_ *_ever_* encrypt your passwords. You hash them. Always.
@drpt6 ай бұрын
Yes! 😊
@cp.jesusoliva6 ай бұрын
Thank you .
@drpt6 ай бұрын
No worries! <3
@user-iw3hk5bv8p6 ай бұрын
ate yung without form po sana hehe, thank you po
@drpt6 ай бұрын
Noted! I'll do it on the weekend. 😊
@user-ys5tz8ch4x6 ай бұрын
gumagana po ba ito pag naka server type na ung system.? nag try po kasi ako nagkakaerror po sya pag galing sa ibang pc ung picture hindi nababasa ng server
@markrichmondfirme53786 ай бұрын
thank you po sa tutorial❤
@drpt6 ай бұрын
No worries! ❤
@jiminarvie34587 ай бұрын
Ma'am ang ganda nmn po ng voice nyo, single po ba kayo
@drpt7 ай бұрын
Thank you po. Opo, yes po. HAHAHAHAHA.
@jiminarvie34587 ай бұрын
Wag mag expect masyado sa design huhuhu
@jamesvincentcaluag73467 ай бұрын
Thank you po, single po ba kayo? joke.
@stringers44417 ай бұрын
How about if mula sa database ang data maari po ba
@drpt7 ай бұрын
Yes, pwede. 😊
@stringers44416 ай бұрын
Hello po related topic lng po.. pwede po maka access ang ibang computer sa system ng windows form?
@drpt5 ай бұрын
Yes, gamit lang ng LAN. Hehe.
@stringers44415 ай бұрын
@@drpt hello po ... kung malayuan di na po pwede
@drpt5 ай бұрын
Ang windows form kasi, it is intended to run on individual computers.
@boolea8 ай бұрын
need more tutorial po
@drpt8 ай бұрын
Will do po. Thank you! ❤️
@Fadz-yg1fo8 ай бұрын
Hello Po maam share Po Yung code paano lag vb net Ms access database ?
@drpt8 ай бұрын
Hello! I have already placed the link in the description. :)
@Fadz-yg1fo8 ай бұрын
@@drpt thank you maam
@Fadz-yg1fo8 ай бұрын
Gumagawa Kasi kami ng POS SYSTEM FOR RESTAURANT. VB NET MS ACCESS DATABASE GAMIT NAMIN
@Fadz-yg1fo8 ай бұрын
Pwede paki demo by step?
@Fadz-yg1fo8 ай бұрын
Pwede ba kayo gumawa ng POS SYSTEM? VB NET MS ACCESS
@drpt8 ай бұрын
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-yg1fo8 ай бұрын
@@drpt walao code niya
@Fadz-yg1fo8 ай бұрын
Paano Naman pag vb Ms access database pos?
@drpt8 ай бұрын
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-yg1fo8 ай бұрын
@@drpt thank you sir
@Fadz-yg1fo8 ай бұрын
Hello Po ma'am ano language Po ito ? Pwede Po ba vb net ms access database?
@drpt8 ай бұрын
Hello! Yung example na binigay ko is for VB. Hehe.
@Fadz-yg1fo8 ай бұрын
@@drpt ma'am paano pa pag mag add stock in to stock out automatic siya mag sell vb net Ms access database ?
@hussinlim10 ай бұрын
Request ko po pano mag copy at move ng folder to folder using c#
@drpt10 ай бұрын
Alright, will do. :)
@annisasrianggraini11610 ай бұрын
Thank you
@drpt10 ай бұрын
You're welcome!
@okay1424510 ай бұрын
Hi mam gawa ka naman po about sa ,remember me in log in form with data base
How po yung pag clinick yung row sa datagrid view is ma rrevert po yung value niya sa mga text box po?
@josheanarevalo5548 Жыл бұрын
ate need help po asap need po namin ng system tom na po kami kasi mag prepresent sa gym sa marami pong tao pls po help, paano po pag yung mga text box ko ay sa ibang form po ganito po kasi ginawa ko, gumawa po ako ng form para sa pag add ng inventory doon po yung datagrid ko tapos sa loob po ng form gumawa po ako ng btnAddInventory which is gumawa rin po ako ng panibagong form para dito. Pag save ko po papasok sa datagrid ko sa ginawa kong form sa inventory and then galing po sa inventory form ko ipapasa nya naman sa panibagong form ko na documents form which is don po pwedeng ma filter yung date kung kelan nila ging inventory and pwede rin po nila isearch and items ang prob ko lang po is yung print paano ko po ito papaganahin.Thank you po ate sana po masagot