Other Stuff

Other Stuff

Spring 2012

Downloading Crystal Reports for Visual Studio 2010 - Bo

Go to the following link http://www.businessobjects.com/jump/xi/crvs2010/default.asp

Click on START YOUR FREE DOWNLOAD.

Choose from the list of available downloads.

I used the first download (SAP Crystal Reports, version for Visual Studio 2010 - Standard).

Save the file to a location where you can easily file it (I saved it to the desktop).

Run the installation file.

Follow the prompts on screen to download Crystal Reports.

Once you have installed Crystal Reports open Visual Studio and verify that it installed correctly.

Spring 2011

Backup your project - Jordan

Just go to www.DropBox.com

-create an account

-start uploading you files!

Adding a percentage column to a GANTT Chart in Microsoft Visio - Ainslee

1. Complete GANTT Chart

2. Right-click the Duration column

3. Select insert column

4. Select % column

Put in amount completed

Spring 2010

How to code a print function on you webpage in JavaScript - Calvin

<h3><a href="JavaScript:window.print();">Print this page</a></h3>

Another way to log in to the CIS Server - Calvin

1. Type http://uam-cis1.uamont.edu/ in the address box at the top of the screen.

2. Click on the link that has the class your assignment is for (Senior Project).

3. Click on your name.

4. Go to where the tabs are and on the right side of them, there is a button that says Page. Click on it.

5. Select the Edit with Microsoft Expression Web 2 option.

6. When the Internet Security Explorer message box comes up, click Allow.

7. There should be a login box that appears. When it does, type in the username and password that you were issued at the beginning of the class and you should get in.

If your Crystal Report is requiring a password to view while running the program - Joe

1. Stop debugging.

2. Open the rpt and click Main Report View at the bottom of the screen.

3. When the pop-up appears, browse for your database in the textbox titled Database Name.

4. Once you find it, double click it and then click ok in the pop-up.

Masked Textboxes - Joe

Using a masked textbox is a simple solution for formatting a phone number (999)-000-0000, currency $999,999.00, dates 00/00/0000, and many other types of formatting that may require tons of coding for validation.

This can be accomplished by dragging a Masked Textbox onto the form, opening the Mask property, and choosing the format that fits your need.

How to log on to the CIS Server - Calvin

1. Click on a Web Browser (Internet Explorer or Mozilla Firefox)

2. Go to the UAM Homepage, if you are not already there.

3. Click on Favorites in the menu bar.

4. Click on UAM-CIS

5. Click on the link that has the class your assignment is for (Senior Project).

6. Click on your name.

7. Go to where the tabs are and on the right side of them, there is a button that says Page. Click on it.

8. Select the Edit with Microsoft Expression Web 2 option.

9. When the Internet Security Explorer message box comes up, click Allow.

10. There should be a login box that appears. When it does, type in the username and password that you were issued at the beginning of the class and you should get in.

Spring 2009

View multiple Crystal reports on one form - Michael

There is a simple and easy way to make it so you don’t have to have a form for each report you want to view. The first thing you do is make a form and put the Crystal Report Viewer on that page then you bring up the code for the Form Load Procedure. This is where all the magic happens. Inside the form load procedure you will need to make a evaluate statement. Here is the one that I used:

private void frmReportViewer_Load(object sender, EventArgs e)

{

switch (Global.ReportName) this is pulled from the report from.

{

case "HoursPos":

crystalReportViewer1.ReportSource = new EmpSumReportHours(); Name of the report you created

break;

case "AmtVen":

crystalReportViewer1.ReportSource = new AmoOwdVen();

break;

case "EmpList":

crystalReportViewer1.ReportSource = new EmployeeList();

break;

case "CustList":

crystalReportViewer1.ReportSource = new CustomerDetailReport();

break;

Fall 2008

Add Music- Ronald

Add this to your html files and save the mp3 file in the same folder as

the html file- <bgsound src="gos.mp3">

To add files to server- Ronald

Get your CIS server username and password for administrator. Go to uam-cis1.uamont.edu. Select senior project and go to your name. At top of page, select internet option, go to programs, and select the option that says HTML Editor. Push down the drop down and select FrontPage. This will send you to FrontPage. Enter your username and password. Once logged in, go to file, import, file, and browse, and then select your file.

Add a enter button type such as “Click here” - Ronald

Add this to your html file

< a href="officialsite.html" class="linklist">Click Here</a></li>

Create Splash Screen - Ronald

Go under GIF program and create the animated gif and place it into your program <p><img src="images/spin1.gif" width="361" height="361" /></p>

Add a login in box-Add to the html file

<h1>Login</h1>

<table>

<tr><th colspan = "2"><br /><h3>Login</h3></th></tr>

<tr><td><label for="login2">Password:</label></td>

<tr><th colspan="2"><input type="button" value="Login"

onclick="Login(this.form)" class="style1" /></th></tr>

</table>

</form>

Then you need to create a JavaScript file. Add this at the top part of page

Add this in the js file

function Login(form) {

var done=0;

var username = form.username.value;

username=username.toLowerCase();

var password = form.password.value;

password=password.toLowerCase();

if (username=="ron" && password=="hotboy") { window.location="loginsite.html";

done=1; }

if (done==0) { alert("Invalid login!"); }

}

How to add music to HTML - Donald

- Make sure the computer have some type of media player such as Windows Media Player or Real Player.

- Find the file you would like to use.

- Convert your file to “MP3”.

- Place the file in the same location as your web files

- When coding use this tag, <bgsound src="yourfilename.gif" />

To open your website in Visual Basic - Donald

- Open VB and go to open, select website. Choose the section that applies to you. Mostly you will choose remote site. Enter the web site completely such as :

http://uam-cis1.uamont.edu/srproject/minnieweatherd

Fall 2007

Using Crystal Reports - Miranda

Always run the system on the same computer you built the reports. If the drive changes you are likely to encounter a load failure. You must go in and correct the file path if you change computers.

Websites for free counters to use on your webpages - Miranda

http://www.freestatscounter.com/

http://rawhits.com/http://rawhits.com/

Database load code for C# - Miranda

private void frmDatabase_Load(object sender, EventArgs e)

{// TODO: This line of code loads data into the'mMABooks03DataSet.Customers'

table. You can move, or remove it, as needed.

this.customersTableAdapter.Fill(this.mMABooks03DataSet.Customers);

}

Sites for embedding media players into websites - Miranda

http://www.tizag.com/htmlT/music-code.php

http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_15777&sliceId=1

http://an-archos.com/anarchy-media-player/

http://www.finetune.com/

http://www.daniweb.com/code/snippet144.html

Link a piece of music on the webpage - Kevin

Put it in a <blockquote>command. You can use any msuic file exteinsion: mp3, .wav, .mid, etc.

An example, if you want to put Michael Jackson's Thriller on the page, this is how you do it:

<a href="thriller.mid">"Thriller"</a>

</blockquote>

Make sure in the <a href=" ">the file name must be exactly like the song with the correct extension. You can rename it but make sure it has the right music file extension.

Webpage for fonts of all kinds and cool custom graphics - Denard

www.flamingtext.com

Two Steps to install audio greeting - Denard

1. Copy the coding into the HEAD of your HTML document
2. Create a separate file called "AudioGreeting.js" and put this code into it. -->

<HEAD>

</script>

</HEAD>

<BODY>

var d = new Date()
var h = d.getHours()

//You can record your own audio greeting and customize the greeting time and message
if (h < 12) document.write('<bgsound SRC="Goodmorning.wav" AUTOSTART=true LOOP=1>'+'Good morning!')
else if (h < 17) document.write('<bgsound SRC="Goodafternoon.wav" AUTOSTART=true LOOP=1>'+'Good afternoon!')
else if (h < 24) document.write('<bgsound SRC="Goodevening.wav" AUTOSTART=true LOOP=1>'+'Good evening!')

Validation code for save button in C# - Miranda

{

this.Validate();

this.puppiesBindingSource.EndEdit();

this.puppiesTableAdapter.Update(this.puppy_Palace1DataSet.Puppies);

}

Spring 2007

How to insert text for a header or footer in a crystal report - Josh

First, you will need to have a crystal report generated.
In the design view, place your cursor in the white area at the top of the report (for a header) or at the bottom of the report (for a footer).
Right-click in the white area and select “Insert Text Object.”
Drag the text box to the area you wish for it to be located.
Once you release the drag, a blinking cursor will appear and you may begin typing.
Once you have finished typing, click outside the textbox to de-select it. If your text is longer than the textbox itself, simply click on the textbox once and resize the textbox via one of the six points of resizing.
It is a good rule-of-thumb to preview your report to ensure that all the text inside the textbox will be correct and visible upon printing of the report.

How to insert an audio clip in Microsoft Publisher - Josh

Click the “Background Sound” icon on the Web page tools menu.
In the following pop-up box, go to the audio portion and click the Browse button. From here, choose which audio sound from the appropriate storage medium and click OK.
You can then choose looping format of the audio clip.
Once you have the clip how you want it, click OK.

Spring 2006

Code that allows you to user a combo box to filter info in an exception report - Trey

private void cboClass_SelectedIndexChanged(object sender, System.EventArgs e)

{

//Filters information in report depending on value selected

if (cboClass.SelectedIndex.ToString() == "0")

{

viewer.SelectionFormula

= "{student.Class} = '1'";

viewer.RefreshReport();

}

if (cboClass.SelectedIndex.ToString() == "1")

{

viewer.SelectionFormula

= "{student.Class} = '2'";

viewer.RefreshReport();

}

if (cboClass.SelectedIndex.ToString() == "2")

{

viewer.SelectionFormula

= "{student.Class} = '3'";

viewer.RefreshReport();

}

if (cboClass.SelectedIndex.ToString() == "3")

{

viewer.SelectionFormula

= "{student.Class} = '4'";

viewer.RefreshReport();

Code that sets up the binding manager in C# - Trey

private BindingManagerBase studentBindingManager;

private void frmEditStudent_Load(object sender, System.EventArgs e)

{

//Sets Binding Manager and starting position

studentBindingManager = this.BindingContext[studentDataSet1, "Student"];

oleDbDataAdapter1.Fill(studentDataSet1);

studentBindingManager.Position = 0;

}

Code to open a website on the web or located on your computer using a link label using C# - Trey

private void linkLabel1_LinkClicked(object sender, System.Windows.Forms.LinkLabelLinkClickedEventArgs e)

{

//Goes to website and sets the hyperlink as visited

System.Diagnostics.Process.Start("IExplore", "F:/Senior Project/Web Page/WebPage.htm" );

linkLabel1.LinkVisited = true;

}

Here's a web site I found; I thought you might enjoy this site - Shannon

http://javascript.internet.com/

This website allows you to convert code from programs in C# to Vb.Net or from Vb.Net to C# - Candis

http://www.developerfusion.co.uk/utilities/convertcsharptovb.aspx

Display system logo on a Gantt Chart – Samantha and Candis

File à Page Setup à Header (tab) à Center (tab) à Insert Picture (icon) à Find logo and click Insert à OK

Print a Gantt Chart on ONE Page - Willie

After inputting data into the Gantt chart, click on Report in the task bar.
In the left hand box that will open, click on Print current view as a report.
Select One page.
At the bottom of the box, click on Print Preview or Print.

Spring 2005

To edit your webpage on the CIS server - Kevin

Go to cis.uamont.edu

Click on the Senior Project link

Click on your name

When your page displays, click on FILE/Edit with Microsoft Front Page

Enter your CIS server user name and password in the dialog box

Edit your webpage.

A website that features all kind of clocks and calendars - www.dynamicdrive.com - Justin

Fall 2004

How to connect your web page to the server: - Andi

type your senior project address in the address bar. ex. http://cis.uamont.edu/srproject/reed/home.htm

on the menu bar click the edit in frontpage button.

Frontpage will open; make sure the folders option is open.

Copy your files into the folder that contains your link.

Webpage that was very helpful with beginning in Dreamweaver - Andi

http://www.trainingtools.com/online/dreamweaver4/

Spring 2004

Cosme

When saving your project files make sure that you save them under the same folder, or save them at the same location. If you don’t you will have problems opening your project.

When creating your project make sure that you name everything accordingly. Label every button, label, text box, Ado, data boxes, etc. If you name everything accordingly, when you code it will be easier to remember what you named everything.

When creating your web page make sure that your pictures are saved in an image folder or somewhere like it. This will help open your pictures in your web page. Especially, if you use Microsoft FrontPage.

Here is a useful web site. - Kiki

www.developerfusion.com/vb/27

Print just the screen shot not the entire screen – Chris S.

When trying to capture screen shots of only one window, use Alt + PrintScreen instead of PrintScreen. Using the Alt along with PrintScreen only takes a snapshot of the active window, and not the whole screen. You can then goto Paint or any word processor that supports images and paste the image.

HOW TO LOG ON TO THE CIS SERVER - Kathy

Click Start

Click Log off

When the log off windows screen appears

Click Log off

Press Ctrl-Alt-Delete when the screen appears

When Log On screen appears:

1) Type in User Name and Password that was given to you by Mrs. Marsh

2) Click the drop down arrow and select CIS

3) Click ok

Data Source Name (DSN) ADO Connection set up by Administrator – Dr. Roiger

SQL Server or Access Databases

Connecting to a DSN with open access (situation in class)