为什么占用这么大的内存,要了24M内存,我用了四个MSHFlexGrid控件.
Private Sub Form_Load()
Dim Rec As ADODB.Recordset
'Sp1.Navigate "http://www.yzcc.com"
mnuTray.Visible = False
With Cn
' 建立非 DSN 连接
.ConnectionString = "DATABASE=music;SERVER=pop2000;DRIVER={SQL SERVER};UID=sa;PWD=sa;DNS='';"
'.ConnectionString = "Provider=microsoft.jet.oledb.4.0;data source=i:\user.mdb"
.ConnectionTimeout = 30
.Properties("Prompt") = adPromptNever
' This is the default prompting mode in ADO.
.Open
End With
Set Rs = Cn.Execute("select * from SClass")
i = 0
Do While Not Rs.EOF
Cb1.List(i) = Rs.Fields(1)
i = i + 1
Rs.MoveNext
Loop
Cb1.Text = Cb1.List(0)
i = 0
SqlStr = "select Nclass from NClass where abcd='" & Cb2.Text & "' And SCLassID=1"
Set Rs = Cn.Execute(SqlStr)
MSHFGd1.Clear
Set MSHFGd1.DataSource = Rs
SqlStr = "select name,specialid from Special where NClass='" & MSHFGd1.Text & "'"
Set Rs = Cn.Execute(SqlStr)
MSHFGd2.Clear
Set MSHFGd2.DataSource = Rs
MSHFGd2.Col = 1
SqlStr = "select musicname,wma from musiclist where specialid=" & MSHFGd2.Text
MSHFGd3.Clear
Set Rs = Cn.Execute(SqlStr)
Set MSHFGd3.DataSource = Rs
MSHFGd4.Clear
Set MSHFGd4.DataSource = Rs
Me.Caption = "MP3播放器--歌曲:" & MSHFGd4.Text
MSHFGd4.Col = 1
MP.Open ("http://music1.yzcc.com/" + MSHFGd4.Text)
End Sub