PDA

View Full Version : Looking to develope a program, need example


triplej
12-14-2009, 06:15 PM
I have developed a small program in Excel and looking to do this in dreamweaver CS4. What I am trying to do is to be able to save a page so the user can see the updates. What I am looking for is an example as to how to save the changes to a file of somesort so when the page is refreshed or latter looked at it will save the changes. I have the page in html but of course it wont save changes.

IS there a tutorial or a site that can explain this. I may have several html pages that require data to be saved. Yes, I am new to web stuff but not excel programming. I am also trying Web Developer 2010 to see if that will work but that is coming slow. I was hoping to have an UPDATE button on page that would save the changes to the page so it would be updated it was opened back up.

I was not sure where to put this thread as I am not sure Dreamweaver can do this or how. Its a shame, I have 2 years of programming in VB in excel to do my program and its all wasted now because it can not be simply converted and then saved as I was hoping for. I was very stupid to do this and now I am stuck. Looking for alittle help to get me started.

Thanks -

davidj
12-15-2009, 06:53 AM
you need a database and a scripting language

Normally i would suggest PHP and MYSQL and would point you to the tutorials on this site but as you are a VB programmer i think you may be better off with classic ASP or ASP.NET

Although this may smooth some of the steepness from the learning curve there is still a massive curve to tackle. (put your crampons on!!)

You will be learning a language and i dont have to tell you how difficult that can be when you begin. Your not going to deliver any web app within the week!

triplej
12-15-2009, 02:32 PM
I have been doing tutorials and been thinking of ways to do this for 2 years now.

I spent over 1000 hrs maybe so far in my Excel program, I kind of mastered that and now finding ways to get this on the net. I just learned Dreamweaver (a little bit) now I guess I need to learn visual web developer 2008 now???? I thought Dreamweaver would work.
I got 4-5 years now and still not online yet and yet to make any money.

But thanks for the reply.

triplej
12-21-2009, 02:16 PM
http://www.spreadsheetserver.com/demo/g/wf1.aspx?frm=snash5ijas2f3pnzzb5jbnmc

I actaully bought their conversion program and worked ncie but I am unable to save the forms I generate or should I say when someone fills them in. They has figured out a way to do it and this is exactly what I want to do, I could use their service for now but I dont even have the 2 dollars to do it. But I have a server at godaddy and time.

Can anyone see what they are doing and trying to explain this concept??

I would be very happy to figure this one out. Looks exactly like how I would want it with a login and they have login examples also.

Thanks -

triplej
12-23-2009, 06:29 PM
got this from the website that I am using to design my pages:

So there has to be an easy way to save my stuff??!!!!!
http://www.spreadsheetconverter.com/excel-asp-net.htm (http://www.spreadsheetconverter.com/excel-asp-net.htm)

Create your ASP & ASP.NET-pages using Excel

You can create perfect looking ASP.NET-page quickly. Design the page using Excel and create the ASP.NET-page in minutes.
Let a domain expert, who doesn't have to know anything about programming, design and create the Excel-spreadsheet including all necessary calculations. Then let SpreadsheetConverter generate the ASP-page or the ASPX-page. Either use the page as it is or open it in Visual Studio for further processing. You can add back-end integration, for example for saving and restoring the values to a database. The ASP.NET-page can either be stand-alone or part of a larger application.
SpreadsheetConverter produces better quality at a lower costs.
Benefits

Non-programmers - SpreadsheetConverter turns your business users' Microsoft Excel spreadsheets into scalable ASP.NET applications.
Perfect looking web pages: Inherits the formatting from Excel: font, size, font color, background color, borders, border types, images. The web page looks just like the Excel spreadsheet.
Flawless number formatting: If you set the format in Excel, all entered data is directly formatted. For example if the users enters 10 into a field with 2 decimals, it will be replaced by 10.00, and if the user enters 5 into a percentage field, it will be replaced by 5%.
Easy to use web pages: Create forms with dropdown menus, checkboxes, radio buttons, large text fields, list boxes in a breeze.
Excel isn't needed. Once the web page is create, Excel is not required. Your web server doesn't need Excel, and your users doesn't need Excel. Even if Excel is all around, not employees have it, and private persons seldom have it.
170 Excel functions: Currently all but a few advanced financial and statistical functions are supported.
Formulas protected: All calculations are done on the server, your formulas are totally hidden from the user.
Cost-effective $150 per developer.
No Risk - 30 day money back guarantee and 6 month email support.SpreadsheetConverter makes ASP and ASP.NET developers productive:

Free to distribute - You can make the calculator part of your program which you can resell. The only restrictions is that you are not allowed to use our library to create a competitor to SpreadsheetConverter.
Full source code - All self-contained. No library files.
Quick testing: Built-in edit-debug-compile-test cycle for IIS, so if you have IIS locally installed, you can see the result directly
Works on old Windows servers; Supports NT4, Windows 2000, Windows XP, Windows 2003. Does not require DOT.NET-framework
Minimum of debugging - The calculator will be better tested, since already thousands of users have tested our calculation engine.

triplej
12-24-2009, 01:34 AM
In this version, it asks in the code saving options as a Tip. If you scroll down just alittle you will see it. I tried a very simple excel file, converted it and saved the code as .aspx this time. usually I save as htm because this is the version I bought. This version only saves a few rows but may be better for me???


<%@ Page language="JScript" EnableViewState="false" %>
<html>
<head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"></meta>
<title>Book2</title><meta name="GENERATOR" content="SpreadsheetConverter to ASP & ASP.NET version 4.6.0 (build 1136)"></meta>
<!-- Parts of this page Copyright (C) 2002-2008 Framtidsforum I&M AB, Sweden --><script runat="server">
/* Run-time Library for server /
/*
Some important restrictions from the EULA regarding the run-time library
* Customers must keep the copyright notice
'Parts of this page Copyright (C) 2002-2008 Framtidsforum I&M AB, Sweden'
on all resulting source files.
* You have a royalty-free right to reproduce and distribute the
run-time library as an integral part of the source files partly
constructed using the Software. You are not permitted to expose,
either directly or indirectly, any API that allows programmatic
access to the run-time libraries.
* Your source files or software product(s) are targeted at end-users,
and are not a development tool. */

function myIsNaN(x){return(isNaN(x)||(typeof x=='number'&&!isFinite(x)));};function round(n,nd){if(isFinite(n)&&isFinite(nd)){var sign_n=(n<0)?-1:1;var abs_n=Math.abs(n);var factor=Math.pow(10,nd);return sign_n*Math.round(abs_n*factor)/factor;}else{return NaN;}};function eeparseFloat(str){str=String(str).replace(eedecreg ,".");var res=parseFloat(str);if(isNaN(res)){return 0;}else{return res;}};var near0RegExp=new RegExp("[.](.*0000000|.*9999999)");function eedisplayFloat(x){if(myIsNaN(x)){return Number.NaN;}else{var str=String(x);if(near0RegExp.test(str)){x=round(x, 8);str=String(x);}return str.replace(/\./g,eedec);}};
/* initialization */
var x = new Object;
var tmp;
function setReset() : void {
x.pA2C = 1;
x.pA4C = 1;
;
}
/* locale defs for server */
var eeisus=1;var eetrue="TRUE";var eefalse="FALSE";var eedec=".";var eeth=",";var eedecreg=new RegExp("\\.","g");var eethreg=new RegExp(",","g");var eecurrencyreg=new RegExp("[$]","g");var eepercentreg=new RegExp("%","g");
/* calc start */
function calc(data){var cA2C=data.pA2C;var cA4C=data.pA4C;var cA1A=(16);var cA3A=(13);var cA2H=(((cA2C)+(((2)*(cA1A)))));var cA4H=(((cA4C)+(((2)*(cA3A)))));data.pA2H=cA2H;data .pA4H=cA4H;};
function initArrays() : void {
;
}
function fromForm() : void {
tmp=pA2C.Value;x.pA2C=eeparseFloat(tmp);
tmp=pA4C.Value;x.pA4C=eeparseFloat(tmp);
}
function toForm() : void {

pA4H.Text=eedisplayFloat(x.pA4H);
pA4C.Value=eedisplayFloat(x.pA4C);
pA2H.Text=eedisplayFloat(x.pA2H);
pA2C.Value=eedisplayFloat(x.pA2C);
}
function docalc() : void {
calc(x);
}

var panel_to_show = "panel1";
function Page_Load() : void {
initArrays();
setReset();
/* TIP: Add code here to set attributes of x to override default values */
if (IsPostBack) {
/* not first time */
panel_to_show = Request("xl_sheet_no");
if (Request("xl_update_top") != undefined || Request("xl_update_bottom") != undefined || Request("xl_submit_top") != undefined || Request("xl_submit_bottom") != undefined) {
/* it wasn't a reset */
fromForm();
/* TIP: Add code here to read attributes from x if you want to save the */
/* values entered by the user */
}
};
docalc();
if (Request("xl_submit_top") != undefined || Request("xl_submit_bottom") != undefined) {
/* submit was pressed: save and redirect to confirmation page */
/* TIP: Add code here to read attributes from x if you want to save the */
/* values entered by the user and the calculated values. */
}
toForm();
}
</script>
<!-- SpreadsheetConverter Header start -->
<link rel="stylesheet" type="text/css" href="./styles.css"> </link>
<link rel="stylesheet" type="text/css" href="./styles_screen.css" media="screen"> </link>
<link rel="stylesheet" type="text/css" href="./styles_print.css" media="print"> </link>
<script language="javascript" type="text/javascript">
/* locale defs for client */
var eeisus=1;var eetrue="TRUE";var eefalse="FALSE";var eedec=".";var eeth=",";var eedecreg=new RegExp("\\.","g");var eethreg=new RegExp(",","g");var eecurrencyreg=new RegExp("[$]","g");var eepercentreg=new RegExp("%","g");
/* library for client */
function myIsNaN(x){return(isNaN(x)||(typeof x=='number'&&!isFinite(x)));};function round(n,nd){if(isFinite(n)&&isFinite(nd)){var sign_n=(n<0)?-1:1;var abs_n=Math.abs(n);var factor=Math.pow(10,nd);return sign_n*Math.round(abs_n*factor)/factor;}else{return NaN;}};function eeparseFloat(str){str=String(str).replace(eedecreg ,".");var res=parseFloat(str);if(isNaN(res)){return 0;}else{return res;}};var near0RegExp=new RegExp("[.](.*0000000|.*9999999)");function eedisplayFloat(x){if(myIsNaN(x)){return Number.NaN;}else{var str=String(x);if(near0RegExp.test(str)){x=round(x, 8);str=String(x);}return str.replace(/\./g,eedec);}};
</script>
<!-- SpreadsheetConverter Header end -->
</head><body onload='<%= (panel_to_show == "panel1")?"try{document.formc.pA2C.focus();document.formc.pA2 C.select();}catch(err){};":"" %>'>
<table id="_TRIAL_MSG" style='border-collapse:collapse' border="0" cellspacing="0" cellpadding="2" bgcolor="#FFFFFF">
<tr><td width="484" style='width:363pt;' class="ee900">
The page as a whole or parts of it is only allowed to be used for evaluating <a href='http://www.spreadsheetconverter.com/poweredby.htm' target='_blank'>SpreadsheetConverter</a> . All publishing on a webserver, for other purposes than evaluation, requires a license of <a href='http://www.spreadsheetconverter.com/poweredby.htm' target='_blank'>SpreadsheetConverter</a> .
</td></tr></table><br />
<!-- SpreadsheetConverter Body start -->
<form id="formc" name="formc" method="post" action="" runat="server"> <div style="display:none">


<input name="xl_sheet_no" id="xl_sheet_no" type="hidden"

value="<%= panel_to_show %>"

>
<input name="xl_postback" id="xl_postback" type="hidden" value="1">



</div>

<div class="eebuttonbar_top">
<input class="eebuttons" type="submit" value="Update" name="xl_update_top">
<input class="eebuttons" type="submit" value="Reset" name="xl_reset_top">
<input class="eebuttons" style="margin-left:30px" type="submit" value="Submit" name="xl_submit_top" >
<input class="eebuttons" type="button" value="Print" name="xl_print_top" onclick="window.print();">



</div>

<div id="panel1" style='display:<%= (panel_to_show == "panel1")?"block":"none" %>'>
<table width="576.00" style='border-collapse:collapse' border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF">
<col width="64.00" />
<col width="64.00" />
<col width="64.00" />
<col width="64.00" />
<col width="64.00" />
<col width="64.00" />
<col width="64.00" />
<col width="64.00" />
<col width="64.00" />
<tr style='height:13pt'>
<td class='ee100'>
<asp:Label id="pA1A" runat="server">16</asp:Label>
</td>
<td class='ee103'>
<asp:Label id="pA1B" runat="server">&nbsp;</asp:Label>
</td>
<td class='ee103'>
<asp:Label id="pA1C" runat="server">&nbsp;</asp:Label>
</td>
<td class='ee103'>
<asp:Label id="pA1D" runat="server">&nbsp;</asp:Label>
</td>
<td class='ee103'>
<asp:Label id="pA1E" runat="server">&nbsp;</asp:Label>
</td>
<td class='ee103'>
<asp:Label id="pA1F" runat="server">&nbsp;</asp:Label>
</td>
<td class='ee103'>
<asp:Label id="pA1G" runat="server">&nbsp;</asp:Label>
</td>
<td class='ee103'>
<asp:Label id="pA1H" runat="server">&nbsp;</asp:Label>
</td>
<td class='ee103'>
<asp:Label id="pA1I" runat="server">&nbsp;</asp:Label>
</td>
</tr>
<tr style='height:13pt'>
<td class='ee103'>
<asp:Label id="pA2A" runat="server">&nbsp;</asp:Label>
</td>
<td class='ee103'>
<asp:Label id="pA2B" runat="server">&nbsp;</asp:Label>
</td>
<td class='ee106'>
<input name="pA2C" id="pA2C" type="text" runat="server" onblur="this.value=eedisplayFloat(eeparseFloat(this.value) );" tabindex="1"
style=' width:100% '
class='ee107'>
</td>
<td class='ee108'>
<asp:Label id="pA2D" runat="server">2</asp:Label>
</td>
<td class='ee108'>
<asp:Label id="pA2E" runat="server">3</asp:Label>
</td>
<td class='ee108'>
<asp:Label id="pA2F" runat="server">4</asp:Label>
</td>
<td class='ee108'>
<asp:Label id="pA2G" runat="server">5</asp:Label>
</td>
<td class='ee110'>
<asp:Label id="pA2H" runat="server" />
</td>
<td class='ee103'>
<asp:Label id="pA2I" runat="server">&nbsp;</asp:Label>
</td>
</tr>
<tr style='height:13pt'>
<td class='ee100'>
<asp:Label id="pA3A" runat="server">13</asp:Label>
</td>
<td class='ee103' colspan="8">
<asp:Label id="pA3B" runat="server">&nbsp;</asp:Label>
</td>
</tr>
<tr style='height:13pt'>
<td class='ee103' colspan="2">
<asp:Label id="pA4A" runat="server">&nbsp;</asp:Label>
</td>
<td class='ee106'>
<input name="pA4C" id="pA4C" type="text" runat="server" onblur="this.value=eedisplayFloat(eeparseFloat(this.value) );" tabindex="2"
style=' width:100% '
class='ee107'>
</td>
<td class='ee108'>
<asp:Label id="pA4D" runat="server">2</asp:Label>
</td>
<td class='ee108'>
<asp:Label id="pA4E" runat="server">3</asp:Label>
</td>
<td class='ee108'>
<asp:Label id="pA4F" runat="server">4</asp:Label>
</td>
<td class='ee108'>
<asp:Label id="pA4G" runat="server">5</asp:Label>
</td>
<td class='ee110'>
<asp:Label id="pA4H" runat="server" />
</td>
<td class='ee103'>
<asp:Label id="pA4I" runat="server">&nbsp;</asp:Label>
</td>
</tr>
<tr style='height:204pt'>
<td class='ee103' colspan="9">
<asp:Label id="pA5A" runat="server">&nbsp;</asp:Label>
</td>
</tr>
</table>
<p></p>
</div>

<div class="eebuttonbar_bottom">
<input class="eebuttons" type="submit" value="Update" name="xl_update_bottom">
<input class="eebuttons" type="submit" value="Reset" name="xl_reset_bottom">
<input class="eebuttons" style="margin-left:30px" type="submit" value="Submit" name="xl_submit_bottom" >
<input class="eebuttons" type="button" value="Print" name="xl_print_bottom" onclick="window.print();">


<span style="margin-left:60px;"> <a href='http://www.spreadsheetconverter.com/excel-online-calculator.htm' target='_blank' tabindex='-1'>
<img style='vertical-align: bottom;' border='0' src='powered-by-spreadsheetconverter.png' width='50' height='46' alt='Create online calculators using Excel'></a>
</span>
</div>

<script language="javascript" type="text/javascript">
function reset_onclick(x){document.formc.reset();postcode() ;};function postcode(){};function eequerystring(){var querystring=document.location.search;if(querystrin g.length>0){variables=(querystring.substring(1)).split("&");var variable;var key;var value;for(var ii=0;ii<variables.length;ii++){variable=variables[ii].split("=");key=unescape(variable[0]);value=unescape(variable[1]);if(document.formc[key]!=null){document.formc[key].value=value;}}}}function initial_update(){postcode('');eequerystring();}
</script>
</form>
<!-- SpreadsheetConverter Body end -->

<noscript>The browser does not support JavaScript. The calculations created using <a href='http://www.spreadsheetconverter.com/poweredby.htm' target='_blank'>SpreadsheetConverter</a> will not work. Please access the web page using another browser.<p></p></noscript>
</body>
</html>