hello po, tanong lang po, kasalukuyan po na sinusundan ko ang tutorial sa http://www.vbtutor.net/index.php/visual-basic-2013-lesson-33-working-databases-introduction/ tapos po, idadadownload ko na ung sql server, kaso ang daming choices, alin po dun ang dapat ko idownload? http://www.microsoft.com/en-us/download/details.aspx?id=29062 eto link
Symbianize Forum
Most of our features and services are available only to members, so we encourage you to login or register a new account. Registration is free, fast and simple. You only need to provide a valid email. Being a member you'll gain access to all member forums and features, post a message to ask question or provide answer, and share or find resources related to mobile phones, tablets, computers, game consoles, and multimedia.
All that and more, so what are you waiting for, click the register button and join us now! Ito ang website na ginawa ng pinoy para sa pinoy!
VB.NET Programming Corner!
- Thread starter ericgmejia
- Start date
- Replies 12,720
- Views 654,534
- Messages
- 879
- Reaction score
- 3
- Points
- 28
You can choose
SQLEXPRWT - Express with Tools (with LocalDB) Includes the database engine and SQL Server Management Studio Express)
Or choose the complete one.
SQLEXPRADV - Express with Advanced Services (contains the database engine, Express Tools, Reporting Services, and Full Text Search)
Anticipate mo din kung 32 or 64 bit ang machine mo.
- - - Updated - - -
Anong ginagawa ng system na to?
You can choose
SQLEXPRWT - Express with Tools (with LocalDB) Includes the database engine and SQL Server Management Studio Express)
Or choose the complete one.
SQLEXPRADV - Express with Advanced Services (contains the database engine, Express Tools, Reporting Services, and Full Text Search)
Anticipate mo din kung 32 or 64 bit ang machine mo.
- - - Updated - - -
Anong ginagawa ng system na to?
cafe timer sir please help
- Messages
- 879
- Reaction score
- 3
- Points
- 28
Medyo malabo kasi matulungan ka, lalo pa't walang proper naming convention sa mga controls.
ano po nid nyo ? full screenshot ng program ko ?
dpat kasi pag nag equal sha sa 1 mag + sha sa amount ng 5. kaso tuloy tuloy ang add nia. -.-
Last edited:
- Messages
- 879
- Reaction score
- 3
- Points
- 28
pano po mag send ? :3Whole program, if pwede.
- Messages
- 879
- Reaction score
- 3
- Points
- 28
Attach mo lang, Go Advanced, may makikita kang attachment button
wala nalabas dun sa attachment button e
Last edited:
- Messages
- 879
- Reaction score
- 3
- Points
- 28
eto email ko, [email protected]
- - - Updated - - -
send mo na lang sa yahoomail ko, wag sa FB, hindi ko ma-oopen dun.
- - - Updated - - -
send mo na lang sa yahoomail ko, wag sa FB, hindi ko ma-oopen dun.
- Messages
- 780
- Reaction score
- 0
- Points
- 26
Sir Eric Help PO sa SQL Format
ganito yan sir eric
Sample Table
ID--CustomerName--Amount(Debit)--Terms
1--Kevin---1000--30
2--Kevin---2000--60
30 days and below is Current
31 to 60 Days is 30Days
gusto q po kasi magaya yung nasa Excel nila
example
Customer Name -- Amount -- Current -- 30Days
Kevin -- 3000 -- 1000 -- 2000
yung kaya q lang po gawin eh.. yung
kevin - 3000 >>> the rest hindi q na po maiHiwalay hehe
- - - Updated - - -
ganito yan sir eric
Sample Table
ID--CustomerName--Amount(Debit)--Terms
1--Kevin---1000--30
2--Kevin---2000--60
30 days and below is Current
31 to 60 Days is 30Days
gusto q po kasi magaya yung nasa Excel nila
example
Customer Name -- Amount -- Current -- 30Days
Kevin -- 3000 -- 1000 -- 2000
yung kaya q lang po gawin eh.. yung
kevin - 3000 >>> the rest hindi q na po maiHiwalay hehe
- - - Updated - - -
Code:
SELECT tblcustomer.CustomerID,
tblcustomer.CompanyName,
Sum ( tblTransaction.debit / 100 ) - Sum ( tblTransaction.Credit / 100 ) AS Total
FROM dbmars.tblcustomer
INNER JOIN dbmars.tbltransaction ON tblcustomer.CustomerID = tbltransaction.CustomerID
GROUP BY tblcustomer.CustomerID,
tblcustomer.CompanyName
Last edited:
- Messages
- 58
- Reaction score
- 0
- Points
- 26
pa.help po mga sir, bago lang po ako sa visual studio 2010........may ginawa po akong project which is DJ Sampler effects, ang problema ko po is hindi ko alam kung paano mag.load and save ng audio files in picturebox para ma.play. sana po mga sir matulungan ninyo ako..
Last edited:
- Messages
- 50
- Reaction score
- 1
- Points
- 26
sali ko dito...
- Messages
- 879
- Reaction score
- 3
- Points
- 28
Anyare po ?DD
Pasensya, hindi ko ma-fix ang problem mo.
Nahirapan kasi ako initindihin ang project mo.
Next time na lang.
- Messages
- 339
- Reaction score
- 1
- Points
- 28
Help naman po. Ano po ba yung common procedure sa stocks receiving ng inventory system? especially po yung sa payment. Thanks.
- Messages
- 255
- Reaction score
- 2
- Points
- 28
Hello po sir Eric,
I need a suggestion from an expert like you,
Pa help naman in terms sa database, I'm developing patient information management system using vb.net
There are 2 kind of patient like Inpatient(For patient admitting) and Outpatient (for checkup only), so I decide to make 2 tables.
Balak ko po sanang gawing isa pero i'm not sure if tama ba ang gagawin ko, below are my sample databases.
Nalilito kasi ako kasi ang inpatient type sa table ko is merong attribute na admissionID but sa outpatient is wala, okay lang ba imerge as 1 table nalang?
INPATIENT PAYMENT DATABASE
OUTPATIENT PAYMENT DATABASE
I need a suggestion from an expert like you,
Pa help naman in terms sa database, I'm developing patient information management system using vb.net
There are 2 kind of patient like Inpatient(For patient admitting) and Outpatient (for checkup only), so I decide to make 2 tables.
Balak ko po sanang gawing isa pero i'm not sure if tama ba ang gagawin ko, below are my sample databases.
Nalilito kasi ako kasi ang inpatient type sa table ko is merong attribute na admissionID but sa outpatient is wala, okay lang ba imerge as 1 table nalang?
INPATIENT PAYMENT DATABASE
OUTPATIENT PAYMENT DATABASE
ahmm sa tingin ko... hindi maganda kung imemerge mo sila, yung effieciency bababa, ahm i redesign mo po yung database mo po.. try mo po gumawa ng 3 table, 1 para sa transaction, 1 para sa inpatient, 1 outpatient, then mag declare ka ng foreign key na patient id, then sa code i test mo kung anung yung patient type, if patient type = inpatient, iaccess mo ang table ng inpatient, vice versa para sa outpatient tas itest mo yung yung patient id para ibigay niya sayo yung mga details ng patient
- Messages
- 879
- Reaction score
- 3
- Points
- 28
Medyo kulang pa sa Normalization ang table.
Well I suggest, isang table na lang para sa mga patients, lagyan mo na lang ng PatientType (In-Patient / Out-Patient).
Then, gawa ka pa ng isang table (tblAdmission), dun mo lang ilagay ang mga patients na nagpa-admit.
pwede lagyan ng fields na, AdmissionID (PK) PatientID (FK), AdmissionDate, RoomID, etc...
Sinagot ko lang muna yung tanong, as I've said, normalization is needed.
Last edited:
Similar threads
