Programming Microsoft SQL Server 2000 with Microsoft Visual Basic .Net - P11

Tham khảo tài liệu programming microsoft sql server 2000 with microsoft visual basic .net - p11, công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả
Nội dung trích xuất từ tài liệu:
Programming Microsoft SQL Server 2000 with Microsoft Visual Basic .Net - P11 For m 2 r eappears aft er t he user replies t o t he prom pt , t he form shows t he fir st t wo t ext boxes wit h t heir prior v alues as well as t he fourt h t ex t box for display ing a colum n value. The specific value in t he bot t om t ext box is t he one m at ching r ow specified by t he user’s reply t o t he prom pt . Figu re 1 3 - 1 1 . Th e clien t a pp lica t ion form for t h e Se rvice 1 W e b ser vice in t h e Ta b leProce ssor folde r . The processing of t he r et ur n values fr om t he Colum nValues Web m et hod illust r at es a t ypical scenar io. A developer engineer s an applicat ion so t hat it can accom m odat e any of several scenarios. For exam ple, a client applicat ion m akes a select ion from t he t ot al set of colum n values t o show t he colum n value for j ust one r ow inst ead of t he whole set of colum n values as in Figure 13- 10. Figur e 13- 12 t r acks t he pr ocess fr om designat ing database and t able nam es t o capt uring t he r eply t o t he I nput Box prom pt t o showing t he specific colum n value t hat a user want s t o v iew. I n t he t op window, t he user designat es t hat t hey w ant result s fr om t he Cust om ers t able in t he Nor t hwind dat abase before click ing t he but t on labeled Get Colum n Value. The m iddle window shows t he user indicat ed t hat t he applicat ion should show t he colum n value for t he fift h row. By t he way, t he prom pt adj ust s aut om at ically t o show t he m axim um num ber of r ows. The applicat ion does t his by r unning t he RowCount Web m et hod when pr ocessing a request t o show a specific r ow value fr om t he fir st colum n. The bot t om window in t he figure rev eals BERGS as t he colum n v alue for t he fift h row in t he fir st colum n. You can easily confirm t his out com e for yourself by exam ining t he out put in Figur e 13- 10, which shows all t he colum n values for t he fir st colum n in t he Cust om ers t able from t he Nor t hwind dat abase.Please purchase PDF Split-Merge on www.verypdf.com to remove this watermark. Figu re 1 3 - 1 2 . Th e clien t applica t ion for t h e Se rvice 1 W e b ser vice in t h e Tab le Pr oce ssor folde r de m on st ra t ing h ow it h a nd le s a re qu e st t o sh ow a pa r t icu la r colu m n va lu e from t h e first colu m n of t h e Cu st om e rs t a ble in t h e N or t h w in d d at a ba se . The following list ing shows t he code behind For m 2 t hat m anages t he behavior of t he client applicat ion for t he Web service in t he TableProcessor folder . The list ing st ar t s wit h t he inst ant iat ion of aPlease purchase PDF Split-Merge on www.verypdf.com to remove this watermark. m odule- lev el v ar iable, x ws1, for t he proxy Web serv ice. Not ice how Visual Basic .NET sy st em at ically nam es t he second- level reference in t he pr oxy obj ect . The proxy for t he first Web service uses localhost as it s second nam e. The proxy for t he deployed ver sion used localhost 1 as it s second nam e. This pr oxy variable, which is t he t hird one in t he chapt er, has localhost 2 as it s second nam e. I n all t hr ee cases, t he fir st nam e for a pr oxy denot es t he client applicat ion’s pr oj ect — nam ely, XMLWebSer viceClient s. Also, t he nam e for t he prox y obj ect in each case r efer s t o t he .asm x file in t he Web service, which has t he nam e Service1 in all t hr ee inst ances. The body of t he list ing includes t hr ee event pr ocedures. One is a form Load event procedure. This ev ent pr ocedure m erely readies t he init ial look of t he for m . I n part icular , it m akes t he t hird and fourt h t ex t boxes, along wit h t heir m at ching labels, invisible. The applicat ion also includes a Click event procedure for each but t on on t he form . These event procedur es inv ok ...