!This program cannot be run in DOS mode.
`.rsrc
@.reloc
~ 9s7
~ 9s7
~ 9s7
2 s7
~ 9s7
2 s7
~ 9s7
2 s7
~ 9s7
2 s7
2 s7
2 s7
~ 9s7
~ 9s7
~ 9s7
~ 9s7
~ 9s7
Y s7
~ 9s7
v4.0.30319
#Strings
Query10
Project_0
Query11
Query4_Click_1
ICollection`1
IList`1
label1
textBox1
Query1
Query12
ToInt32
label2
textBox2
Query2
label3
textBox3
Query3
label4
textBox4
Query4
label5
textBox5
Query5
HMACSHA256
label6
textBox6
Query6
label7
textBox7
Query7
Query8
Query9
<Module>
OLDMAID
OwnerThreadID
GetNumAI
DataBaseGUI
DIAMONDS
SPADES
HEARTS
value__
System.Data
mscorlib
System.Collections.Generic
Microsoft.VisualBasic
_isFinished
_cardsUsed
AddCard
DealCard
UserInterface
set_DataSource
set_AutoScaleMode
set_ColumnHeadersHeightSizeMode
DataGridViewColumnHeadersHeightSizeMode
DataTable
IDisposable
RuntimeTypeHandle
GetTypeFromHandle
Shuffle
Console
set_Name
ReadLine
WriteLine
set_Multiline
System.Core
get_Culture
set_Culture
resourceCulture
ButtonBase
TextBoxBase
Dispose
EditorBrowsableState
STAThreadAttribute
CompilerGeneratedAttribute
GuidAttribute
GeneratedCodeAttribute
DebuggerNonUserCodeAttribute
DebuggableAttribute
EditorBrowsableAttribute
ComVisibleAttribute
AssemblyTitleAttribute
AssemblyTrademarkAttribute
TargetFrameworkAttribute
ExtensionAttribute
AssemblyFileVersionAttribute
AssemblyConfigurationAttribute
AssemblyDescriptionAttribute
CompilationRelaxationsAttribute
AssemblyProductAttribute
AssemblyCopyrightAttribute
AssemblyCompanyAttribute
RuntimeCompatibilityAttribute
get_CardValue
set_CardValue
_value
Remove
EmptyReadOnlyDictionaryInter.exe
set_Size
set_AutoSize
set_ClientSize
ISupportInitialize
Padding
LateBinding
System.Runtime.Versioning
connectionString
HandToString
valueToString
suitToString
disposing
System.Drawing
set_RowHeadersWidth
Query10_Click
Query11_Click
Query1_Click
Query12_Click
Query2_Click
Query3_Click
Query5_Click
Query6_Click
Query7_Click
Query8_Click
Query9_Click
add_Click
thisVal
System.ComponentModel
LateCall
ContainerControl
Program
get_Item
set_Item
System
Random
resourceMan
Boolean
PlayAgain
set_Margin
set_Icon
Application
set_Location
System.Globalization
System.Reflection
ControlCollection
DbConnection
SqlConnection
get_ReadOnlyDiction
IndexOutOfRangeException
FormatException
System.Data.Common
Button
MethodInfo
CultureInfo
Bitmap
sender
get_ActiveBorder
get_ResourceManager
ComponentResourceManager
RangeWorker
EventHandler
System.CodeDom.Compiler
IContainer
_isUser
EmptyReadOnlyDictionaryInter
DbDataAdapter
SqlDataAdapter
Player
Randomizer
set_BackColor
set_UseVisualStyleBackColor
AsBstr
System.Diagnostics
DisplayHands
GetMethods
System.Runtime.InteropServices
Microsoft.VisualBasic.CompilerServices
System.Runtime.CompilerServices
System.Resources
Project_0.DataBaseGUI.resources
Project_0.Properties.Resources.resources
DebuggingModes
Project_0.Properties
EnableVisualStyles
PercentGroupSizes
EventArgs
Equals
get_Controls
System.Windows.Forms
set_AutoScaleDimensions
get_Chars
SystemColors
components
RemoveAt
Concat
GetObject
LateGet
CardsLeft
EndInit
BeginInit
get_CardSuit
set_CardSuit
thisSuit
SetCompatibleTextRenderingDefault
DialogResult
System.Data.SqlClient
InitializeComponent
LoadHint
get_Count
DiscardPairsAtStart
Convert
SuspendLayout
ResumeLayout
PerformLayout
get_Text
set_Text
DataGridView
dataGridView
set_TabIndex
MessageBox
TextBox
ToArray
CspKey
get_Assembly
Capacity
op_Equality
WrapNonExceptionThrows
Project 0
Copyright
2016
$8e21f76f-d2a0-482f-92f2-5f4684d169e3
1.0.0.0
.NETFramework,Version=v4.0
FrameworkDisplayName
.NET Framework 4A
3System.Resources.Tools.StronglyTypedResourceBuilder
16.0.0.0
lSystem.Resources.ResourceReader, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089#System.Resources.RuntimeResourceSet
fSystem.Drawing.Icon, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3aBj
QSystem.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Drawing.Icon
IconData
IconSize
System.Drawing.Size
System.Drawing.Size
height
Bh@2WQ!aZ
veyBEC10
h^ ]$ m
:U#^?F
K;"K1"&]
a(:bOq
~L]y7f[
KGP;>R
rvFnZ^
Wy~9? w
/`8|r6"
M'"rY
~lO$R$E
&4nR1H/
*g|189
|("Xl1H'
")EjqYb
IDATga0
E~q7ud
eSxtYK
CDPCzN
`'G` {
pYjV&i
rXOo"C
I)G4s>
Q^B/(T6mGE
0bOAwBKI
rT@V`t
s YnDO
v166v
^4E1xX=M
]7$;"9
^,Hb@E
,Qt-2P
xd-Y6
l||<$?c
}V@<5p@<5
@<5`@<5
@<5`@<5
F@<5p@<5
@<5 @<5p@<5
@<5`@<5
@<5`@<5
@<5`@<5
@<5P@<5
@<5P@<5
@<5`@<5
@<5Pytl
@<5 `\Tp
=Hbm<:3K
#>8Y\-
9$k5OM
I;/OAl(
J'.R5b(,
8?3U"\4
Q$86=@
;8o0CF"s
S o{VJQ
n1Z_.O
C1t"2J
f'913_%k
J*7C"+ s
S9H;!t
V2/2!['Q+
lP 7<f*%
)j5kOS
,W*= `&&
F+%v8E
O4>+)e
6nb|6q3-
/AEB9Iy~
d3VJ*~=G*kdx
ug3Kq643iV
PTf<_m
7h[FZ{
Gk;yYd
sa08&=G
{{9Oupr
%w{'O~|!>&S
_*{'O~|!>&S
Om|?2#S
Om|?2#S
8?Q z{;
873I#K
Wea?8*=G
YQ7873
%+%eh[
'7%]`+
]Q'M7-
/J@e|*V;
H+q:Z0)
Sa0801
Tm=8&=
Q-a:51
#k8(~W
lSystem.Resources.ResourceReader, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089#System.Resources.RuntimeResourceSet
hSystem.Drawing.Bitmap, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3aPADPAD1J
QSystem.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
System.Drawing.Bitmap
IDATx^l
Q8L;_"
!U]>s
7mnoi&
K=C es
4gccB(
z,{H{_rs
?~[7 `
c3H.Jef
5^mK<Y
h,jt_.T#
!eHk P
Q_ n$X_p
&U~.lL<
OUg]q
lAKBPM
qD opA
FG+ jn
<<;oNDR
@tIALNCyc
}sbK$o6w(
{ts,R|8
"q(n*vZN
Q}`[P
_ZKB b
ctd}(z
M#n?Vb
VGp)q4
rf\xzW
ck:oQE
Yd10Bl
44s(X2
KhP088r
q"=*As6
z938nD
xp@q\q
]{4fRu
0? =|c
y[:mJe
`5\DZo6!@
Fr~hC+
G +d42
/9k*\m
cdJsDl^
uU$?8#
P3h'Bv1@
:/De;y
HX?ZCr
|yMR2_Y
7d\(QiO
dbZ GV
a4,c}k
X\4t"|
xixLB&[
s>D~mU
<XM._
!|xE_4DQ
M.E9w#-
Zk)]67
U~8]O/T
&xTfVn
|m/=KJ-
qP]w{E
biRYuC
2x~`O'
7\1F#_^
+Qv50%
*?/ay~y
+_2nx
\/M6=y
ssg{e=
SXNQH~@
Wj^1Vz
:)k,cIy/
3<}[)S
"?}N0_
/SLn9l
[a=;l8
";^2U&d
{<qhxh
%T;TXa
`R^+X`
t:ay~V
g)$#Pu
/-`>hR
{H8cfWY
hL\N*7
AVt>.Cq{i
m.vU>|
sv_/'~
tkDL5NA
Z( LA{
fQP'l*
}) }]9
GcnyM8
{U+Z$O
{L)1XA
E3pU.iV
5 cI{t
)BA{_A'+)/
v<C/d(,-
6:pD20
!2"5xX
88WMiN
RPo4QL
05@@&A
/(.>U<
/^j=ig
'0,n[>
rCb.Q'
WzQDvd
/}/;<Q
ih|41>
hXht|e
)hPkt8
l6A<DFX
a55GNK
Esp9Tx
;{@x0l^
x2`qP r?b
ieNJ/k
>Mx{mo
k2,MnF
ZsiPCBT9
W%:|:y
>P!IB@
p'g4bt
\9mF*g
yNrJp.
W^mn$<
0=V7`-
D(KU7H
v1OX2R
+OW3KI!
ufNT&CC
=57kZ5
BUJ% jc
. Fa|R
#C[|:5P
Fb-1ap
n,il:a
9b{M/
r@vR#$
Zb&1+LI
;J2&Q#Q
<%T}wk
hD)n~C
-P~h00
6{Nf`$7
s|mnf/
Su=->'
DMVJbJ
o}X:H|
_qAl[(
_\m9c
5G^RTY
*F[S]cU
JvFUz{
kH3;>y
J]+tz.
hsiFDK3|
dkTksy
HYudeI
=|eh/G
Xb<zge
k\Y$W}
_nhPxU
._XXl#+w4
wLy|a@
iMVp[V
jI[mPm-
MR~ZC\
0j". 40 6"`:
6J:/GDz=
EK(^^ )1
z_"|cF
%&Vu$x
<lKB(>
MMs>^[
O}CbS 5
}V,&bE
? >xsj
%I3,_'K:
~ex9EN&
FzqUr;aH
/t1Z+q
okemZ(&i{
=-c@vb
S5'rRQ
L)HI;-b
Km{&mK
=N Xs~
wn|oV]H
YNh14?vh
W( xv^
q\@L@`^K
:6;x2'
Q"xm+lD
=bw =h^r
[|,SHP
Y#g41U6*
4>KLR@
TBEc`~
e`<O)@
qgmI]!
>k?~ 3
EP\_5P
54{ZS
O;N) h
g+mR4y
t6oG12(6
NB|It#
W?Oo&C
>uKp)
w% 2jHr
494~Ne]
f:2EM}%
#Nj6.sI
TWG[P---@
gdP0k&
&&_(AcjL
>[OtZtQ:|
Wnlosn
)K;~ry
"a;<1I
nvi Vu
54+HW
w>&Chm
ojhNkI
-ru<zi
j+Wz6C
ln3d3>t
CkLHXP
b^Xmq:
\<*9C^ZI^
FX_?Pq7dAA
qN76RhH
`llb%t
KWZ6Ov
J=<k/L{
#N53h7
2`Th!4
PW:VFBM
}_l~4-od^
%-ns*}g
[ek@k+
J_4v"%
Yf1'3dr
A6N5sJ%I
)n)d>
g&rE>7lY
j;(6X1
.X2Z'5
TuMx1L
7qPfpW
[;-2^qZ
oIQ@Axa
T>XS-?x"aX
u6GA4f
mn%/>x
p|;'mA
_q!k@fw/
<=l_*#W
k/0%#c
{N}>~K
+V>T;>
CRJH4-
s7;i@=_
2sBeU|
bu86C'
;ix//7
uggc74o
qb~aVp
,5>>/6h
N%m;E%E1
JllJmJ4
fZdx,hJ
xn50Vo
}VfL7o
U?Jb~w
hj6@)0
3)h3.5
jH4!5+
[P4Byw
+4XY}#c
OWppIzo
AVTUdJ
oF?\(F
Aw=~0jC4xW
x&$i@]
%hh%QT
<pN>4a
wb--<2A:
t.qEf/V(
|@I_A}
ru&rj!
?kehw~
RfYSbU
Ujp0WT
1-7w87
\TEtq8
HE ~%#
,JRPMwi`
)pQNlM
!(L%dTe
|Yzov9
?3mVLb
ce~xc4
Riiij)
)[~=\L]
Wo9%R9
>VGY5;<)p
70>T\
kHHyu7z
lYa4Ka5
N!zJqB
W]Vp`\w
UPMg69
dhN?dhO
7>j.ph~
F7d-XV
b/`Lj0
zUkP8>
Rd:)0r
+$eLx?p
H+#"wu
,WfA4N%
]Xh@$<
l{[)alc
G)(02&
S"i1 &
AOkqgD
!F=C!W
4x>s.q
YsF CQ
'_d&zG
C(-]c(<
s(\MH#B
}*u4{I
k=v3X=x
YJ}8+.Y$
h1BAH4
?F7w|a
d&*Rf9n
1lO-vG
X:a6BFC
I,C}f(U
H700SA6)
`/aH]1
Z0|}Rb
2lo7v`D
QIUG=>
R^zcBu
F! 3Gk
9>.\9b
HHmUzqT
,NiFiF+
@sihpn
=&Qvvg
CZ7emM~
g@+UR^
aa9a1[B
ZbpBl{
~X.l.Lj
z{_Ti.
q''Ed(
|8=MaM
zMy+"UE(z
74p*7
MBgz!RN
P;mD@V
RVX_/|
p8DTt~
7ZWl,F
OiHgY>
gxO <u
"&z&CC
1'N#lhrl
tt$_E8
!pD[S'
0JJe,0
Z[AC{"
$JN,XP
oEV"l|O
djm!K[
B/;^'5
nwXh\=
MkN%MG, tNF
pqDS\C
$Vt#>6
/%iJ;7
g+U"[w
aK.MY?j
#zw"2;
/`Dx
akC(G 7
98vAa.
k-nN:{
-6%&!e!
jtM]9p
V+E`ESp
2<=?5[Y
i#O\ny
+e:NH$
<sc=*&
~#R^{]
D3&Pm|;
Mr/U:j
<[lTH=
ap,J]V
M}edOq
Rb\LA!
ehh\^N
|_bzBAW
z'^:99
Y35A3D
5BQPTY
OqU6UG
G?L^46r
M]Vl):
)gfoHp
77P@jx[6B0|"
EYtrIP
`]zaHF
K[vDOM8
mL|l%G~%
X^ k!q
lu*zvN
3x2c;H
?^:tY<
>(]F{U
wNapCK:
@vtd$A
K-k[*&
EfK-/[j'
j]n^\h
rj]d61m$
ov]uB^
~^4zvo
dP`?cb
>M'F_>}
v.Z_{!
`P"ps%bl
Kj >0JS
"Jhu,ny
{ma2sN
J3fnXE
mcU!N
~a+cxv
ON|T|,g
zE"\3/J
I`m$P%@7#
ELg7%2V
,:m;3w3
4JO&8s
8K4wqZ
pde4.C+
% %;5m6
qFJART
<7:x]]qe
^s6N0(
dK"o>qz
?Ri:*(
"+TPj|M
gMX2}I
rVt*+r~
AkX=Uk
%p]AU3
IDATv^
|{R3_%'
-`LQp
qEtR5]
"v0$1*
n-scua
Kx\tMV3
fv_8@['6
yu,e]I
|k7m=c
(\m$~)
kdUZxb
&3} n?
25$UCi3
!Kg=fE
'uF"}"
mdI@jm
P3.Mog
bVU+(W
^K@c]#
>4 xv)Jo+
7y0u,R+
>lH~aN
Wl.L]a
Zw#Zh`
gyr1]
CptVzI
k}~T{V
5ec|,"jN
tv^ 0ch
f#F`,g
-b.#&gL
iL4[B0zq
]k(Csj
x\.aB
nu{^{m\
HAld@V
|p"],>e
=aLalL
c5NoP
%N%p0wy
7]M={C
pROl,6
%BV%zG
K{+F&t
ubK&z8
CtF>Sk
DfM;}A
Baw7lYdHE4
]yfcQ\z
> tRto
LA&xeJ
kDWYHtU
nXJK%
vgwisK
24uTFI
9s ';H
ncn;'.N
\+k`i8
kpSN)W
j/wOJg
N63:720pc
2+2q^x
yDh8ch
Tv|pvc
J@-G0y
,~io]U
(w?v=/]|
&D Nwg~R
gi.={%
\(4l(r!
Bl%7Q!
N&fY):
SGf@W9M
@iSiPG
Eo|=r/
-3!y6z
wfv3}
w|}"yc
Onw5>r
aF&YR.
|}["[}
XQ]-q3+
x&1I$` i C
+z >N3|
&:rb/o(Z
^[-c5"}z
gN%Nkq}
i]MOOe
oZx?(j
1?Yuhx
)MM*|l4#
n&^*B-
I0zF-&M
!\]e6 rd
BlN~6<y5:&
!1Ra-s'
;J h2#
<?e(T8
SD<z/R
E9N2_q
#fR A 0
rh')Z4
4.'=Kv|8
u;~Bd0[}an
Od!P)fiz
AUWE@!A
S2oMTS
P8 zU'
6-J{%XD
3DoY4h
(:sFt,.
I@AsEm9f
XAY|{$h6
EkwV^y
~5g%aJr"
]wN{sy
/Ea<b]
b(0E',
$3!He9
acve~:=
Uf3v]}H
LnN_|)
Z4r q
VoK)B[s
/ia,m[Xd.
IVHaBBP`
M_k5[
Pl0TUA
ACLje@I
>48}zo
3,(i^,}!N
o?:Fl+
P5$A f<
?={${d
J5gI<IP
{<k3n\
DqzI:]
' H;xXs
1Je)]+
e9;(SV6p
o[Ryi`a
ti,Mxa
TDj9No
'/4x70X+
[|Pn~^
^qoNVV};q~
JI-qK`?)!>
4YsR.T
4m=rBpcg
rm=+6Q
3["Sxj
ONTk+T
&`816fg
PtAL1z
iel{NT
_ri))+qP
C^fo{O
#O,{az
/Tid.$(
W[Rzm8+
v="_f^
Be-Aa5
hHTj%<
m8nKDm`
f=j%K,
:!m^fQ
=7l_nvwa
wlu(4l
K$@9(d
3?Ae`
{_JwQ:k
7<&h+}U
P:HSmK6Y
-N[mjO
^Y?uh`#Ot
ZD<E@R
lvynx;
C72D7/
h_8dPa
q Q|/|
Z\)( ~'
:,CcqT
5haRdM5
*F(48N()
\@lK2
4{qGfm<(K
8#:Z]k
)~*"S X
IH-:=
G?{MEq
a~#8hQ
[~0@lA
7[6O}v
OX?jx
T*@+1p
k$Apjo
>^y_q'
S6Aenfn&T
Q@U&>NA
XGC=NC
erIo]d
~?nV>]e
<."In-
gyKJ"o
tE7^! v
ZFETF8(
W/*3LK
quh}~E+q
+k("$E
@'-B/#
.uF=26
\(-.Y8p
93!,u?F*
ciwi1(
0NCS{r
3;J5\"n
8 t]?@
7gdY?5
pFZb T
%-avu]
R_drV.K
XeQM~vr
A1B)D@
T7Z@\"
`[k,)K
6Ntb^v
1&UjKO
8,[A(i
4YYqR_
^FJ8hT
t5z^wJ
QdB~Cv
|=*9r0
!+' tLrH
>SmSFY:
)#~N+H[pVJ
x94q%1
F7}5[FvS
0TjZc,
PaGl,F
}R'uq,
R:]Wi,
UR~j$7
(A12Qh
h.$sl-
'w%)#l
0kV(iV
jML&O'
yO%UNl
i8(*PZ
TIQcl=
OgtM7`
PnWkpdv
IA!VjK
(}H:nTG
='EBf=
l!u#l 1
-_:Ek4zw
44$fnQj
si7,Ui
H'W$85
$O+_+%
:(qw/z"
2fRPleu
tthyP5
DZ:<Yi,Hw
R(e->z}qD
!m'2Wa
,QwqnL_
h}cGWz
v?IX~9tV
hY `m#
HhL$n%
.,?X:R
M_7"VI
>N<_|o
6MV e.
E%]G |
g%x(q`
V!-t(-*
}Vf$Y5,
cs6]|,I_>|
TiV&hU
jg8aNC]Bq
K:4(a`
59V7P\
[~vCHX
,2>Gl/lTr
6EFjt,
FMfPnW
YI"AMYSnR
5g2hZ*
sd_CBa
nC*TM'
=z~N=~
w*'n-x
$TRnR1
#.;" s
- NQP/
q:cf~& }
x.a/`l
lKKIKH]
~gCCL
L+6b'Q
wHHt*~6
~/REVb
h|*JRV
c/`k4m
hiH@HK^C
_,C{.CY@
":kC:s
9*T&7
C:\Users\Administrator\Desktop\Client\Temp\gSemzToCqG\src\obj\Debug\EmptyReadOnlyDictionaryInter.pdb
_CorExeMain
mscoree.dll
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0">
<assemblyIdentity version="1.0.0.0" name="MyApplication.app"/>
<trustInfo xmlns="urn:schemas-microsoft-com:asm.v2">
<security>
<requestedPrivileges xmlns="urn:schemas-microsoft-com:asm.v3">
<requestedExecutionLevel level="asInvoker" uiAccess="false"/>
</requestedPrivileges>
</security>
</trustInfo>
</assembly>
',049AHRl
Invalid Suit.
Invalid card value.
The suit is not valid.
The value is not valid.
Data Source=mssql.cs.ksu.edu;Initial Catalog = joselopez44528; User ID = joselopez44528; Password= ksu10191947*
Invoke
526561644F6E6C7944696374696F6E
69735934785144
Project_0
Select * From Food.Category C
User must enter a term to search by
Select * From Food.Food F WHERE F.Discription LIKE '
User must enter FoodID
Select N.NutrientName, A.Amount, M.UnitMeasurement From Food.Amount A Inner join Food.Nutrient N ON N.NutrientID = A.NutrientID Inner Join Food.Measurement M ON M.MeasurementID = A.MeasurementID Where A.FoodID =
and A.Amount Is Not Null
User must enter CategoryID
Select C.CategoryName, F.Discription From Food.Category C Inner Join Food.FoodCategoryL L ON L.CategoryID = C.CategoryID Inner Join Food.Food F ON F.FoodID = L.FoodID Where C.CategoryID =
Group By CategoryName, Discription
SELECT C.CategoryName, DerivedTable.TotalFoods, DerivedTable.AverageCalories, RANK() OVER(ORDER BY DerivedTable.AverageCalories) [Rank] FROM (SELECT FCL.CategoryID, COUNT(FCL.FoodID), ROUND(SUM(A.Amount) / COUNT(FCL.FoodID), 2) FROM Food.Amount A INNER JOIN Food.FoodCategoryL FCL ON FCL.FoodID = A.FoodID WHERE A.NutrientID = 0GROUP BY FCL.CategoryID ) AS DerivedTable(CategoryID, TotalFoods, AverageCalories) INNER JOIN Food.Category C ON C.CategoryID = DerivedTable.CategoryID
User must enter NutrientID
User must enter rank
WITH FoodofCategory(FoodID, Discription, CategoryName) AS (SELECT FD.FoodID, FD.Discription, C.CategoryName FROM Food.Category C INNER JOIN Food.FoodCategoryL L ON L.CategoryID = C.CategoryID INNER JOIN Food.Food FD ON FD.FoodID = L.FoodID WHERE C.CategoryID =
GROUP BY FD.FoodID, FD.Discription, C.CategoryName ) SELECT TOP (
) F.CategoryName, F.Discription, A.Amount, M.UnitMeasurement FROM FoodofCategory F INNER JOIN Food.Amount A ON A.FoodID = F.FoodID INNER JOIN Food.Nutrient N ON N.NutrientID = A.NutrientID INNER JOIN Food.Measurement M ON M.MeasurementID = A.MeasurementID WHERE N.NutrientID =
ORDER BY A.Amount DESC
User must enter Low Value
User must enter High value
SELECT TOP(
) F.Discription AS 'FoodName', M.UnitMeasurement, N.NutrientName, A.Amount FROM FOOD.Nutrient N INNER JOIN FOOD.Amount A ON A.NutrientID = N.NutrientID INNER JOIN FOOD.Food F ON F.FoodID = A.FoodID INNER JOIN FOOD.Measurement M ON M.MeasurementID = A.MeasurementID WHERE M.MeasurementID = 0 AND A.Amount BETWEEN
Order BY A.Amount DESC
SELECT N.NutrientID, N.NutrientName, M.UnitMeasurement FROM Food.Amount A INNER JOIN Food.Measurement M ON M.MeasurementID = A.MeasurementID INNER JOIN Food.Nutrient N ON N.NutrientID = A.NutrientID GROUP BY N.NutrientID, N.NutrientName, M.UnitMeasurement
) F.FoodID, F.Discription, RANK() OVER(ORDER BY Amount.Total DESC) AS [RankOfFood] FROM ( SELECT TOP(
) A.FoodID, SUM(A.Amount) AS Total FROM Food.Amount A INNER JOIN Food.Measurement M ON M.MeasurementID = A.MeasurementID INNER JOIN Food.Nutrient N ON N.NutrientID = A.NutrientID GROUP BY A.FoodID ORDER BY Total DESC) AS Amount INNER JOIN Food.Food F ON F.FoodID = Amount.FoodID ORDER BY Amount.Total DESC
SELECT C.CategoryName, F.Discription, F.Name, N.NutrientName, M.UnitMeasurement FROM Food.Category C Inner join Food.FoodCategoryL FCL ON FCL.CategoryID = C.CategoryID Inner join Food.Food F ON F.FoodID = FCL.FoodID INNER JOIN Food.Amount A ON A.FoodID = F.FoodID INNER JOIN Food.Measurement M ON M.MeasurementID = A.MeasurementID INNER JOIN Food.Nutrient N ON N.NutrientID = A.NutrientID
User must enter Food name
UPDATE Food.Food SET Name ='
' WHERE FoodID =
SELECT * FROM Food.Food
User must enter Low value
User must enter nutrientID
WITH Calories(Discription, Amount) AS (SELECT F.Discription, A.Amount FROM FOOD.Amount A INNER JOIN FOOD.Measurement M ON M.MeasurementID = A.MeasurementID INNER JOIN FOOD.Food F ON F.FoodID = A.FoodID WHERE M.MeasurementID = 0 AND A.Amount BETWEEN
) SELECT TOP(
) CAL.Discription AS 'FoodName', CAL.Amount AS 'Calories', N.NutrientName, A.Amount FROM FOOD.Nutrient N INNER JOIN FOOD.Amount A ON A.NutrientID = N.NutrientID INNER JOIN FOOD.Food F ON F.FoodID = A.FoodID INNER JOIN FOOD.FoodCategoryL FCL ON FCL.FoodID = F.FoodID INNER JOIN FOOD.Category C ON C.CategoryID = FCL.CategoryID INNER JOIN FOOD.Measurement M ON M.MeasurementID = A.MeasurementID INNER JOIN Calories CAL ON CAL.Discription = F.Discription WHERE N.NutrientID =
AND A.Amount IS NOT NULL ORDER BY A.Amount DESC
Query1
Select Categories
Query2
Search by partial Discrp
Query3
Search Nutrients By FoodID
dataGridView
textBox1
label1
FoodID
label2
Query4
All Foods By Category
label3
CategoryID
textBox2
Query5
Category Report
textBox3
label4
NutrientID
Query6
Search by Category and Nutrient IDs
textBox4
label5
Number of Results
textBox5
textBox6
label6
Between
Query7
Foods in Calorie Range
Query8
Nutrients and there Measurments
Query9
Foods With Most Combined Nutrients
Query10
Select All Foods From Database
Query11
Set Name for Food
textBox7
Query12
Highest Nutrient Amount in Calorie Range
label7
Search by partial Discript:
$this.Icon
DataBaseGUI
5PH475NGB8YEF944ZFCI5A
GetType
Seentrusted.MyBinarySearchTree
No cards are left in the deck.
Input number of computer players (2 - 5):
Invalid input.
Invalid Input.
Do you want to play again? (Y/N)
Invalid Response.
Project_0.Properties.Resources
ReadOnlyDiction
$this.Icon
ReadOnlyDiction
VS_VERSION_INFO
VarFileInfo
Translation
StringFileInfo
000004b0
Comments
CompanyName
FileDescription
Project 0
FileVersion
1.0.0.0
InternalName
EmptyReadOnlyDictionaryInter.exe
LegalCopyright
Copyright
2016
LegalTrademarks
OriginalFilename
EmptyReadOnlyDictionaryInter.exe
ProductName
Project 0
ProductVersion
1.0.0.0
Assembly Version
1.0.0.0