473,320 Members | 2,000 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Dreamweaver 8, SQL and ASP.NET

3
Hey all, the new guy here.

I need some help, been at witts end for long while now. Im not very good with ASP/ASP.NET/SQL hell anytype of coding, more of a designer.

Anyway I am trying to create a search field on one page index.aspx and a results page on search_index.aspx. I have followed the following link, http://www.pixeldigest.com/aspsearch.html, to the letter and in my Dataset i manage to Test my connection successfully but it does not want to show the info in my browser, what can be the problem?

Pls dont ask me to use this or that programme, I cannot afford another application now and dont have the time to learn another app as it is. I know this can be done in DW8 with ASP or ASP.NEt and SQL. Below is the code for my search_index.aspx page

Expand|Select|Wrap|Line Numbers
  1.  <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
  2. <%@ Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>
  3. <MM:DataSet 
  4. id="DataSet1"
  5. runat="Server"
  6. IsStoredProcedure="false"
  7. ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_STRING_phone") %>'
  8. DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings("MM_CONNECTION_DATABASETYPE_phone") %>'
  9. CommandText='<%# ("SELECT name, surname, mobile, ext FROM contact WHERE name LIKE ?") %>'
  10. CurrentPage='<%# IIf((Request.QueryString("DataSet1_CurrentPage") <> Nothing), Request.QueryString("DataSet1_CurrentPage"), 0)            %>'
  11. PageSize="10"
  12. Debug="true"
  13. >
  14. <Parameters>
  15. <Parameter  Name="@contact"  Value='<%# IIf((Not Application("contact") Is Nothing), Application("contact"), "1") %>'  Type="VarChar"   /></Parameters></MM:DataSet>
  16. <MM:PageBind runat="server" PostBackBind="true" />
  17. <html>
  18. <head>
  19. <title>Intranet</title>
  20. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
  21. <link href="css/style.css" rel="stylesheet" type="text/css">
  22. <style type="text/css">
  23. <!--
  24. .style1 {
  25.     color: #FFFF00;
  26.     font-weight: bold;
  27. }
  28. -->
  29. </style>
  30. <script type="text/JavaScript">
  31. <!--
  32. function MM_swapImgRestore() { //v3.0
  33.   var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
  34. }
  35.  
  36. function MM_preloadImages() { //v3.0
  37.   var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
  38.     var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
  39.     if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
  40. }
  41.  
  42. function MM_findObj(n, d) { //v4.01
  43.   var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
  44.     d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  45.   if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  46.   for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  47.   if(!x && d.getElementById) x=d.getElementById(n); return x;
  48. }
  49.  
  50. function MM_swapImage() { //v3.0
  51.   var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
  52.    if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
  53. }
  54. //-->
  55. </script>
  56. </head>
  57. <body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="MM_preloadImages('images/em&amp;pbut_d.jpg','images/cmsbut_d.gif','images/em&amp;pbut_d.gif')">
  58. <table width="762" height="532" border="0" align="center" cellpadding="0" cellspacing="0" id="Table_01">
  59.     <tr>
  60.         <td>
  61.             <img src="images/index_01.jpg" width="762" height="228" alt=""></td>
  62.     </tr>
  63.     <tr>
  64.  
  65.     <td width="762" height="304" valign="top" bgcolor="#003366"> 
  66.         <table width="100%" height="241" border="0" cellpadding="5" cellspacing="2">
  67.           <tr> 
  68.             <td height="85" colspan="3"><p class="heading">Welcome to Smit Amandla Marine's INTRANET </p></td>
  69.           </tr>
  70.           <tr> 
  71.             <td width="46%" height="90" valign="top" bgcolor="#FFFF00" class="p">&nbsp;</td>
  72.             <td width="26%" valign="top" bgcolor="#FFFF00" class="p"><div align="center"><a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('cms','','images/cmsbut_d.gif',1)"><img src="images/cmsbut.gif" name="cms" width="103" height="103" border="0"></a></div></td>
  73.             <td width="28%" valign="top" bgcolor="#FFFF00" class="p"><div align="center"><a href="e-m&p/emp.html" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('emap','','images/em&pbut_d.gif',1)"><img src="images/em&pbut.gif" name="emap" width="103" height="103" border="0"></a></div></td>
  74.           </tr>
  75.           <tr> 
  76.             <td height="28" bgcolor="#0066FF">&nbsp;</td>
  77.             <td bgcolor="#0066FF" class="style1">Company Management System </td>
  78.             <td bgcolor="#0066FF" class="style1">Electronic Maintenance &amp; Purchasing </td>
  79.           </tr>
  80.           <tr>
  81.             <td height="28" valign="top" bgcolor="#0066FF"><table width="100%" height="139" border="1" cellpadding="0" cellspacing="0">
  82.               <tr>
  83.                 <td>              <ASP:Repeater runat="server" DataSource='<%# DataSet1.DefaultView %>'>
  84.               <ItemTemplate>
  85.                   <table width="100%" height="135" border="0" cellpadding="0" cellspacing="0">
  86.                     <tr>
  87.                       <td bgcolor="#999999" class="p">Name</td>
  88.                       <td bgcolor="#999999" class="p">Surname</td>
  89.                     </tr>
  90.                     <tr>
  91.                       <td class="p"><span class="p"><%# DataSet1.FieldValue("name", Container) %></span></td>
  92.                       <td class="p"><span class="p"><%# DataSet1.FieldValue("surname", Container) %></span></td>
  93.                       </tr>
  94.                     <tr>
  95.                       <td class="p"><span class="p">Extension</span></td>
  96.                       <td class="p"><span class="p">Mobile</span></td>
  97.                     </tr>
  98.                     <tr>
  99.                       <td class="p"><span class="p"><%# DataSet1.FieldValue("ext", Container) %></span></td>
  100.                       <td class="p"><span class="p"><%# DataSet1.FieldValue("mobile", Container) %></span></td>
  101.                     </tr>
  102.                   </table>
  103.                 </ItemTemplate>
  104.               </ASP:Repeater></td>
  105.  
Sep 27 '10 #1
4 1954
Frinavale
9,735 Expert Mod 8TB
Instead of using the DreamweaverCtrls version of a DataSet, try using the ASP.NET DataSet.

-Frinny
Sep 27 '10 #2
Wurn
3
Hey Frinny, thx for the reply and I'll have a look at the link.

To be honest I doubt if I'll be able to incorporate what is said into my webpage and get it to work. Surely what I have currently needs a slight adjustment and not need to be rewritten?
Sep 28 '10 #3
Frinavale
9,735 Expert Mod 8TB
I'm sorry but I've never used DreamweaverCtrls before.

I know that ASP.NET controls work in ASP.NET applications and I don't know anything about how DreamweaverCtrls work in ASP.NET applications (or how to use them...or anything about them really).

Since you are using an ASP.NET Repeater control to display the data, I recommend that you use the ASP.NET DataSet (or a DataTable within it) so that you can easily bind the controls.

Depending on the database you are connecting to, you could also consider using something like the SqlDataSource control which could make binding easier.

-Frinny
Sep 28 '10 #4
Wurn
3
Thx man, but still not making sense to me much. Like I said I'm not very good at coding.
Sep 29 '10 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: davidshook | last post by:
I am a begginer with not too much time on my hand. I do some html pages with Dreamweaver and with some minor Flash actionscript and I have a minor ability (with the help of lots of tutorials) to do...
11
by: jm | last post by:
Somebody on here recommended Dreamweaver with PHP. I am coming from (still using really) ASP and ASP.NET. PHP is more like ASP and not a whole lot like .net, but I wanted to know how Dreamweaver...
0
by: Gregory | last post by:
I am using OS X and Dreamweaver MX. I am trying to make a connection to the MySQL Server from within Dreamweaver using the Applications panel and clicking on the "+". A window opens asking for:...
3
by: Richard Lawson | last post by:
I am working on a site which is written in Dreamweaver. Is it possible to write pages in ASP inside of a Dreamweaver site? Rich
5
by: I.P. Freely | last post by:
Hi, I've been using Visual Studio.NET for a while to design WinForms and Console apps and love it. Recently I had to a WebForms app. Because I have no artistic skill whatsoever, I enlisted the...
0
by: Zorba.GR | last post by:
Macromedia Dreamweaver MX 2004 v7.0.1 Incl Keymaker, and Addons, other Workhouseboys Design The Transmitter Buttons v1.0 for Dreamweaver MX WebAssist WA eCommerce Suite v2.01 RETAIL for...
1
by: E. Wise | last post by:
I'm seeking some solid information on how I as a programmer can work with a Macromedia designer on my ASP .NET applications. Here's the specific scenario: Company has a intranet area that is...
4
by: Ian | last post by:
Hi there, Has anybody got any tips or recommendations for using Vs.Net and Dreamweaver 2004 together? I like to use dreamweaver as the layout tool as for me it just seems a little more...
171
by: tshad | last post by:
I am just trying to decide whether to split my code and uses code behind. I did it with one of my pages and found it was quite a bit of trouble. I know that most people (and books and articles)...
4
by: Adam Knight | last post by:
Hi all, I am using a dreamweaver template for a web app i am working on. Each time i update the template my page directives at the top of the associated pages gets removed. Anyone had...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.