Ӧ
COMPUTER APPLICATIONS
1999 19 6 Vol.19 No.6 1999



ǰDBGridϵͳ⼰
ε
ժҪʵʹVB5.0ʵϸDBGridеһϵͳ⣬Ҫʹ֮оĸԴķ
ؼʡVBDBGridColRowǩ¼
1VBʮȫʮ
żӲķչ˶ƳҪϵͳ˻档ڵڶ˻УVisual BasicΪVB˵ѧõ֮һرǶڷǼרҵߣVBǳʵá߿Բ˽ĶֱVBƽ棬VBĲȽϷ㡣
ԣVBʹ÷Χܹ㡣ǣVBҲһЩ⣬д󣬱߾ͷһͽ߼õĹ
2ķֺ
ǰʱ俪һϵͳFORTRANԱ˼㲿֣VB档ϵͳݣЩݵԱʽСFORTRANҪļʽȽϸԣϵͳʹ˷ǰʽDBGridUserData洢ݡϵͳıǸǰȷģɾлУϵͳֻ¼ӳ򣺱ݸı󣬶ڴ洢ݵݽиµ¼UnboundWriteDataʹжȡݵ¼ӹUnboundReadData¼ӳǴVB5.0е⿽ȻԼӸĶá·ΪD:\VB5\samples\Misc\UnBndGrd\Unbndgrd.vbpǣʹһʱ󣬷⣬£
 ÿԪݸıԺѹƵԪжش壨簴ϽǵĹرհťALT+F4˳ٴμظôʱ޸ĹĵԪûиı䡣
 ֣DBGridжһʾҪڱһݣƿ󣬸ı䴦ֱֵԭֵDBGridȽϴһʾ꣬ҪܿȫݣDBGridһݣƿ뵥Ԫֵδı䣬˵ԪͬеĵһеԪֵֵڴһؾ޸һУ϶⣬ǰ޸ĵУ򲻻⡣һʼ޸һУʹʱҲ⣬ǳûзǳȷĹԡ
٢⾭ͬʱ֣ͬӰ죬ʹ⸴ӻ
3Դо
ڳĴõVB5.0Ĵ룬ֻǸıһСִ룬ܵĴ٣ĿԱȽСʱļ飬޸Ĳִû⣬ܿܳ⿼ǲܵVBǣ߸Դ
һýҪڶԷǰDBGrid¼UnboundWriteDataļ˽ⲻġǰDBGridһ鴢еݣһԪݶӦһֵÿDBGridؼеԪ޸ģҰѹƶкUnboundWriteData¼ͼƶͬһеĲͬʱܼUnboundWriteData¼ڴ¼У޸ġĽ취Ƚϼ򵥣ֻҪDBGridChange¼м´뼴ɣֵΪUserDataDBGridؼΪDBGrid1
Dim I As Integer,J As Integer
I= DBGrid1.Col ȡк
J=DBGrid1.Row ȡк
UserData(I,J)=DBGrid1.TextֵǰԪӦ鵥Ԫ
ڶȽ鷳ʼʱΪһһпеĵطǲܻǵһӦϸ飬ûзִκ⡣һгжϳDebugڲ鿴ֵ֣ıĵԪӦ鵥ԪֵѾı䣬ֵһǱʾֵûб䣬һʾһֵǲǸı䵥ԪݺDBGridûüˢ±ǣڳм룬ÿԪ޸ĺǿˢ±DBGridAfterColEdit¼мһд룺
DBGrid1.Refresh ˢDBGrid1
кһˣһʾıݣһеֵҲ䣡ʱΪˣ˺մáֱһΣõһȽϴ飬һʾ꣬йһǰֳˣֻǴһݲǳڵһУҲǳһУǳкŵʾ1ϣкͬνʾDBGridвùֱӿԿ
෽飬յóۣVB⡣VBҲͬ⡣VBУDBGridÿһԪضλкţRowкţColǩBookmarkкCol𣬴0αšкźͱǩ׻кܴġкűʾĳʾʱʾекţһʾекΪ0ƣֱпɼһСкǿԱ仯ģҶûʾûкŵġĳеıǩʾеźţʾûʾġĵһеıǩΪ0һеıǩΪ1
ͳVBϵͳʱһеBookmarkֵΪ0رǵһֱ޸һʱһеBookmarkֵһԾͳ⡣ŪRowBookmarkҲͿΪγǰᵽˡ
ڿһִĻݿһʾÿ޸һкȼUnboundReadData¼̣Ȼ󼤷UnboundWriteDataʱ̣ϵͳͰֵһУUserDataѸı䣬ûˢ£ԭݣͳڵĵһһʾ꣬ÿ޸һкǰĹһǹһǣѾˢ£ԿǸıĵһУڵĵڶ
4Ľ
߾ʵ½취ڳмжϵBookmarkΪ0ʱ޸ǵһлһУBooleanͱLastrowʾжϵĽֵӦԪҪڸ¼мӵĴ£
ڴּ´룺
Private Lastrow As Boolean䶨жǷΪһеĲ
Private mTotalRows&䶨DBGird1
DBGrid1AfterColEdit¼м´룺
If Lastrow Then
DBGrid1.RefreshˢDBGrid1
DBGrid1.Scroll 0, DBGrid1.VisibleRows¹ܿһ
Lastrow = FalseΪѾƵ,԰LastrowΪFalse
End If
DBGrid1Change¼м´룺
Dim i As Integer, j As Integer
i = DBGrid1.Colк
j = DBGrid1.Row к
If DBGrid1.Bookmark = 0 Then
If j > 0 ThenBookmarkΪ0кŴ0һһ
Userdata(i, mTotalRows& - 1) = DBGrid1.TextֵһеӦ
Lastrow = True
Else һ
UserData(i, DBGrid1.Bookmark) = DBGrid1.TextֵһеӦ
End If
ElseBookmark0
UserData(i, DBGrid1.Bookmark) = DBGrid1.TextֵĶӦԪ
End If
5ʵ֤
ʵĻϣ⣬о⣬⡣õЧĳɹֲVBϵͳȱݣΪԺʹͬʱṩ˼뷽ͽ·
߼飺˶ʿоҪо򣺳ơӻ
εġڡ
ߵλϺѧľϵϺ200331
ո:1998-12-25
