tag:blogger.com,1999:blog-29773717715322334432009-06-25T00:08:34.287-07:00MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.comBlogger28125tag:blogger.com,1999:blog-2977371771532233443.post-12881999892390176842009-06-22T00:29:00.000-07:002009-06-25T00:08:07.517-07:00

Custom Orange County Database Design1. Binding to ArrayList or HashTable you create in codeA. ArrayList: Binds one field, displays in order created1. Dim alAlpha As New ArrayList()2. alAlpha.Add("Larry")3. … With radiobuttonlistAlpha .DataSource = alAlpha .DataBind()4. End With5. …6. radiobuttonlistAlpha.SelectedItem.TextB. HashTable: Binds two fields (nice!), but displays

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com0tag:blogger.com,1999:blog-2977371771532233443.post-88384177639516114352008-08-24T02:06:00.000-07:002008-08-24T02:09:16.758-07:00

CSS XHTML compliant designs in Irvine, Orange County, CaliforniaThe W3C CSS Validation ServiceFinds errors and potential problems in Cascading Style Sheets.The W3C Markup Validation ServiceIf you wish to validate specific content such as RSS/Atom feeds or CSS stylesheetsCSS Standards Compliance in Internet Explorer 7Free CSS | CSS Gallery | A Gallery of W3C Standards CSS CompliantCSS Gallery is a

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com0tag:blogger.com,1999:blog-2977371771532233443.post-40236766306374014552008-01-27T11:50:00.000-08:002008-01-27T11:51:41.414-08:00

Web Design, Development, Search Engine Optimization and Programming1. Binding to ArrayList or HashTable you create in codeA. ArrayList: Binds one field, displays in order created1. Dim alAlpha As New ArrayList()2. alAlpha.Add("Larry")3. …With radiobuttonlistAlpha.DataSource = alAlpha.DataBind()4. End With5. …6. radiobuttonlistAlpha.SelectedItem.TextB. HashTable: Binds two fields (nice!), but

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com0tag:blogger.com,1999:blog-2977371771532233443.post-33200870218619073812008-01-20T17:05:00.000-08:002008-01-20T17:08:41.765-08:00

Huntington Beach, california web design and development in ASP.NET1. User ControlA. Like include files.B. Reusable chunks of code.C. End with .ascxD. Drag onto any pageE. Change the control…all the pages change.F. Change the location of the page…ouch..change the scr in the directive.2. Custom ControlA. Appear in toolbox…more complex…it’s a DLLB. Not this semester3. Add New Web User ControlA.

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com0tag:blogger.com,1999:blog-2977371771532233443.post-18698649177239850172008-01-13T09:20:00.000-08:002008-01-13T09:23:08.154-08:00

Data Reporting Crystal reports software Development in Irvine California1. Data ReportingA. Reports turn data into informationB. Crystal Reports is a popular report writer (banded reports)C. VS.NET provides Crystal “light” integrated into UI1. My best guess is Crystal version 8 with VS 2000a) Crystal 9 with VS 20032. Upgrades from the Business Objects web site.2. Note that Crystal is an option

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com0tag:blogger.com,1999:blog-2977371771532233443.post-54404432679703963862007-10-05T22:27:00.000-07:002007-10-05T22:31:11.714-07:00

Irvine web design california1. DataList…best of DataGrid and Data RepeaterA. Not restricted to Tabular Data like the grid.1. Template based like repeater ANDB. Edit in place like Grid.2. Key: Editing Templates in HTML ViewA. ItemTemplate: Required. The default layout1.

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com0tag:blogger.com,1999:blog-2977371771532233443.post-35050373983847719092007-09-21T17:34:00.000-07:002007-09-21T17:47:47.401-07:00

ASP.NET developers, Huntington Beach, CaliforniaUnderstanding The Data Repeater and Data List controls forA. Understanding the HTML templates under the surface.B. Bottom line…Data appears in a templateC. A template is just the html between the template tagsD. There are many “types of templates”E. Some for headers/footers, Some for data2. Displaying DataA. DataRepeater repeats a template you

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com0tag:blogger.com,1999:blog-2977371771532233443.post-22289036539801375712007-09-08T22:35:00.000-07:002007-09-21T17:48:13.077-07:00

ASP.NET California Irvine Developers1. Hyperlink Column: Grid . PropertyBuilder . HyperlinkA. Text Field: The field.value to display in the column1. (hint Text = Static text in column…all same)B. URL Field: The field.value to pass in the hyperlink.C. URL Format = PageName.aspx?Var={0} where 0 is the URL Field above1. Var will hold the value in {0}…2. How they hook together to jump to a detail a

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com0tag:blogger.com,1999:blog-2977371771532233443.post-67503802997696802152007-08-22T20:48:00.000-07:002007-09-21T17:48:44.845-07:00

ASP.NET Development CaliforniaDataGrid paging sorting1. Binding to the DataGrid: ToA. DataSet1. DataTable (in a dataset)2. DataView (sorted, filtered view of a DataTable)B. DataReader: Database specific2. AllowPaging:A. Adds paging controls and limits to 10 rows per pageB. BUT… you still have to write code to do paging3. AllowSorting:A. Turns on links to column headers so you can click on themB.

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com0tag:blogger.com,1999:blog-2977371771532233443.post-60569342253832890082007-08-20T15:13:00.000-07:002007-09-21T17:49:24.061-07:00

Freelancer and programmers California1. What is a SQL Server Stored Procedure ?A. A compiled set of commands stored on the database serverB. You give it a name…pass it parameters and it does the database manipulation.2. Question: Should all of your data access be done through stored procedures?A. Some companies…YES! They require it.B. New thinking: Maybe1. Simple selects, inserts, updates and

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com0tag:blogger.com,1999:blog-2977371771532233443.post-14559493730001512862007-08-18T18:18:00.000-07:002007-09-21T17:46:18.110-07:00

ASP.NET programmers Irvine California1. Two types of objectsA. Connection Dependent1. Connection, Command, DataAdapter, DataReaderB. Connection Independent1. DataSet, DataTable,DataView, DataRow2. Data Reader…a connection specific firehose to a consumerA. There is no client side caching of data as in a DataSet1. (it is implicitly created when you create a DataSet to fill the ds)B. Fastest way to

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com0tag:blogger.com,1999:blog-2977371771532233443.post-37691978525179709652007-08-09T18:09:00.000-07:002007-08-09T18:10:16.437-07:00

1. Data Controls vs Data ObjectsA. Data controls are wizards that create code for ADO.NET data objectsB. Data controls are found on the tool box. Data object you create in code.2. Data Controls are Microsoft tools to create the ADO.NET objects for you.A. No Code solution to data access1. Wizards

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com0tag:blogger.com,1999:blog-2977371771532233443.post-44684509589536056742007-07-29T22:34:00.000-07:002007-07-29T22:36:10.163-07:00

1. The ADO.NET objects (classes) …A. Base class is System.DataB. DataSet Object = to work with the data (once we have it).1. Independent from the connectiona) System.Data.DataSetC. Objects to access (connect to) data sources (ie databases)1. Generic Namespace: ODBCa)

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com0tag:blogger.com,1999:blog-2977371771532233443.post-46755811439069549512007-07-24T00:14:00.000-07:002007-07-24T00:15:17.350-07:00

1. Modes:A. Design: Write your codeB. Break: Step through code (F11)1. Can NOT change code during breakC. Run: Full speed… (F5)2. Note that these notes use the default keyboard setup.3. How to:A. Right click in Solution Explorer and set a start project and start page

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com0tag:blogger.com,1999:blog-2977371771532233443.post-88183886451045745022007-07-18T18:12:00.000-07:002007-07-18T18:13:33.214-07:00

1. Adding client side (ie java script) code to a ControlA. Example. “Are you Sure?” message box on Delete buttonB. lnkDelete.Attributes.Add("onClick", "return confirm('really delete ?')")1. Will not post back without an OK.C. This should go in the Page_Load.2. Validation Controls: writes client side java script for data validationA. Prior to .NET you wrote client side Java script1. And server

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com1tag:blogger.com,1999:blog-2977371771532233443.post-74595788738573687872007-07-16T00:02:00.000-07:002007-07-16T00:03:46.410-07:00

1. Events, Data Types, Procedures, Classes2. EventsA. Simple concept 1. 1. ASP.Net programming = place server controls on a Web Form then code for their events. Big change from old ASP.B. Simple concept 2.1. Event handling takes place at the server…NOT the browser2. Example…coding a command button click event triggers a postback so the server can deal with the event code.a) If multiple events

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com0tag:blogger.com,1999:blog-2977371771532233443.post-17124424602294732692007-07-14T00:40:00.000-07:002007-07-14T00:43:08.986-07:00

1. Using HTML to create Web sites.A. All static. Requires Web Master to continually update pagesB. Very difficult to deal with databases3. Using ASP: Active Server PagesA. The Web server can run script locally and then return HTML on the fly1. Good for working with databases2. But script language was very limitedB. Old ASP = one file a jumble of HTML, server side and client side code.1. ASP.Net

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com0tag:blogger.com,1999:blog-2977371771532233443.post-68092880450054389292007-07-11T13:03:00.001-07:002007-07-11T14:55:42.096-07:00

1. To Know .Net is to know the .NET FrameworkClass Libraries = Objects called in all languagesA. Think of boxes with functions in themB. {} = a namespace, just a box.2. What is a class?A. Think of a small box with a name1. You create a instance of that name and you get all the cool stuff in the boxB. There are thousands of classes.3. What is a Namespace: A box with other namespaces &/or classes

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com0tag:blogger.com,1999:blog-2977371771532233443.post-87903353126938405952007-07-11T12:56:00.000-07:002007-07-11T12:59:55.964-07:00

1. Getting More Help!A. On Line Help in VS is good! Use it!B. Our on line tutor:sledwith@saddleback.eduC. http://www.dotnetjunkies.com/search.aspx2. What is the .NET FrameworkA. Common Language Runtime (CLR)1. Previous: All languages had their own “runtime engine”a) VBrun…. MSVCRT (C++) etc2. Now: All .NET languages use the same runtime engine.B. .Net Framework Classes1. Previous: Each language

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com0tag:blogger.com,1999:blog-2977371771532233443.post-4175699158075894662007-07-11T12:54:00.000-07:002007-07-11T12:55:12.076-07:00

1. Create a New Web Project Assignment10A. Add Web Page DropBox.aspxB.C. Use Header user control from the previous assignment. Format as shown.1. Menu is not required.D. Select a folder with at least 5 files with at least 3 having .DOC extension.E. Bind a radiobuttonList as textfield=Name and the valuefield=pathF. Clicking on a radio button will download the selected file1. Response.redirect to

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com0tag:blogger.com,1999:blog-2977371771532233443.post-43904748248989949292007-07-11T12:51:00.000-07:002007-07-11T12:53:21.878-07:00

1. Create the Crystal Report PageA. You may need to modify your code to deal with a password.B. Print showing filtered selection from drop down list.2. Create the following Crystal Report using the Crystal Viewer:A. Invoices View grouped on Salesperson: Total on Extended PriceB. Executive Leading break format (wizard)C.D. Tips: use the wizard to format most of the report.1. Note the date,

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com0tag:blogger.com,1999:blog-2977371771532233443.post-22756827881922828492007-07-11T12:49:00.000-07:002007-07-11T12:50:43.283-07:00

Data RepeaterA. Printouts: HTML View and Code View for both Category and CatetoryDetails page.B. Printouts showing both workingA. Print Code, HTML, Template EditorB. Print Running both Normal and Edit.3. New Project Chap19A. Add a new Web Page ProductsC. Bind to Products Table as Shown1. Note formatting on Price.Unlike shown… use a table to make text boxes line up.4.5. Save = update or insert

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com0tag:blogger.com,1999:blog-2977371771532233443.post-82285160354919046352007-07-11T12:45:00.000-07:002007-07-11T12:48:03.760-07:00

A. When done all the data access “controls” should be replaced by Sharedprocedures in the DataHandler classA. Add Class module called DataSQL (not the DataHandler from the book)1. Store a connectstring in appSettings in Web.config2. Create a Shared Public Function “cs” to return the connectstring3. Create 2 Functions:a) GetDataReader that returns a data reader &b) GetDataSet that returns a data

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com0tag:blogger.com,1999:blog-2977371771532233443.post-54364046829935926262007-07-11T12:39:00.000-07:002007-07-11T12:40:26.774-07:00

A. Add Existing Item and use the Data.aspx from Assignment 4B. Place a label called lblError below the listbox.2. Edit the connect string and change add x to the end of the password (to make it fail).A. Check the web.config and confirm that customErrors mode="RemoteOnly"B. Run and Print default error page3. Edit the Web.Config file A. Change customErrors mode="On" and run again.B. Print the

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com0tag:blogger.com,1999:blog-2977371771532233443.post-9618521020677623512007-07-11T11:42:00.000-07:002007-07-11T12:37:15.719-07:00

A. Place two buttons on the form labeled “Data Adapter” and “Data Reader”B. Place a listbox on the formC. On the click of the Data Adaper - fill the list box with the Company Namesfrom the Northwind customers table1. Do NOT use data binding to do this…Must use a loopD. On the click of the Data Reader - fill the list box with the Company Namesfrom the Northwind customers table1. Do NOT use data

MJhttp://www.blogger.com/profile/06920201270055797655noreply@blogger.com0