ASP.NET Discussion Boards

First Prev Next

Re: ConnectionString Problem!!!

Guffa2-Nov-06 14:08

Guffa

2-Nov-06 14:08

What error message do you get?

---
b { font-weight: normal; }

Re: ConnectionString Problem!!!

immori3-Nov-06 18:51

immori

3-Nov-06 18:51

error message is : Login Faild!
the problem is I can connect from my pc , but when I upload the site it`s impossible...!

Re: ConnectionString Problem!!!

Guffa4-Nov-06 2:24

Guffa

4-Nov-06 2:24

Where is the database server located?

---
b { font-weight: normal; }

Error Type: Either BOF or EOF is True

Skanless2-Nov-06 11:25

Skanless

2-Nov-06 11:25

I am not sure why I am getting this error if I have included: "IF NOT GOSSearchRS.BOF AND GOSSearchRS.EOF THEN". I hate to include the whole code but it may prove necessasry to get a response. It runs OK when I submit an empty value but if I search for something that's not in the database I get the error. See Error and Source Code Below.

Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/gregstore/GregStoreMPSearchPage.asp, line 117

Source Code:


<%
'Get Search Phrase
SearchFor = TRIM( Request( "searchfor" ) )

'Open database connection
Set dbCon = Server.CreateObject( "ADODB.Connection" )
dbCon.Open "GregStore"

%>

<HTML>
<HEAD><TITLE>Welcome to Greg's Online Store - Search </TITLE></HEAD>

<body link ="#ff4040" vtext="lightred" bgcolor="White">
<center>

<table width=640 border=0 cellspacing=0 cellpadding=0>

<tr>
<td bgcolor="lightblue">
<img src="belizeflag.gif">

<font size="5"><b>Welcome to Greg's Online Store!!</b>
</td>

<td align = right valign = "bottom">
<a href="cart.asp">Shopping Cart </a>
|
<a href = "account.asp"> Account </a>
</td>
</tr>

<tr>
<td colspan=2>
<hr width = "640" >
</td>
</tr>
</table>

<table width = 640 border=0 bgcolor="Azure" cellpadding=0 cellspacing=0>
<tr> <td valign = "top">

<table border=0 cellpadding=0 cellspacing=0>
<tr> <td valign = "bottom" bgcolor= "pink">
<img src="search.gif" vspace=0 border=0></td>
</tr>
<tr>
<td>

<table width = "200" border=1 cellpadding=4 cellspacing=0 bgcolor="lightyellow">
<tr>
<td>
<FORM METHOD="POST" ACTION = "GregStoreMPSearchPage.asp">
<input name = "searchfor" size="15">
<input type = "submit" value = "Search">
</form>
</td>
</tr>

</table>
</td>
</tr>
<tr>
<td>   </td>
</tr>
<tr>
<td valign="bottom">
<img src = "Categories.gif" vspace=0 border=0></td>
</tr>
<tr>
<td>
<table width="200" cellpadding=4 cellspacing=0 bgcolor="lightyellow" border=1>

<tr>
<td>
<font size="3"><b>



</b></font>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td><td valign="top">
<%

'Get The curent Page

pg = TRIM(Request( "pg" ))
IF pg = "" THEN pg = 1

SET GOSSearchRS = Server.CreateObject( "ADODB.Recordset" )
GOSSearchRS.ActiveConnection = dbCon
GOSSearchRS.CursorType = adOpenStatic
GOSSearchRS.PageSize = 5

'SQL Query String

sqlString = "SELECT product_id, product_picture, product_name, product_briefdesc " &_
"FROM Products " &_
"WHERE product_status = 1 " &_
"AND (product_name LIKE '%" & SearchFor & "%' " &_
"OR product_briefdesc LIKE '%" & SearchFor &"%' ) " &_
"ORDER BY product_name "

GOSSearchRS.OPEN sqlString
GOSSearchRS.AbsolutePage = pg

IF NOT GOSSearchRS.BOF AND GOSSearchRS.EOF THEN

%>

<table width="350" cellpadding=5 cellspacing=0 border=0>

<tr>
<td colspan=2>
<font size="3" color="darkblue">
<b>Search Results:</b>
</font>
</td>
</tr>

<% WHILE NOT GOSSearchRS.EOF AND rowCount < GOSSearchRS.PageSize
rowCount = rowCount + 1 %>

<tr>
<td>
<% IF GOSSearchRS( "product_picture" ) <> "?????" THEN %>
<IMG SRC = "<%=GOSSearchRS( "product_picture" ) %>"
HSPACE=4 VSPACE=4 BORDER=4 align="center">
<% END IF %>
</td>
<td>
<a href="GregStoreProduct.asp?pid=<%=GOSSearchRS( "product_id" )%>" >
<b><%=GOSSearchRS( "product_name" )%></b></a>
<br><%=GOSSearchRS( "product_briefdesc" )%>
<br><a href= "GregStoreProduct.asp?pid=<%=GOSSearchRS( "product_id" )%>" >
get more information</a>
</td>
</tr>
<tr>
<td colspan=2 align="center">
 
</td>
</tr>

<%
GOSSearchRS.MoveNext
WEND
%>
</table>
<%
IF GOSSearchRS.PageCount > 1 THEN
%>
<font color = "darkgreen">
<b>Go to Page: </b>
<%
FOR i = 1 to GOSSearchRS.PageCount
IF i <> cINT( pg ) THEN
%>
<a href="GregStoreMPSearchPage.asp?searchfor=<%=Server.URLEncode( searchfor )%>&pg=<%=i%>">
<%=i%></a>  

<%ELSE%>

<b><%=i%></b>  

<% End IF %>

<% Next %>

</font>

<% End IF %>

<% else %>

<table width="350" cellpadding=5 cellspacing=0 border=0>

<tr>
<td>

<font face="Arial" color="darkblue">
<b>No Product Matched your search Terms </b>
</font>
</td>
</tr>
</table>

<% End IF %>
</td></tr>
</table>
<hr width=640>

Copyright © 2006 Dominguez-Burns Inc.

</center>
</body>
</HTML>

Greg

Coding makes the world go round!!!

Re: Error Type: Either BOF or EOF is True

Akhilesh Yadav2-Nov-06 23:31

Akhilesh Yadav

2-Nov-06 23:31

why you want to put this condition

IF NOT GOSSearchRS.BOF AND GOSSearchRS.EOF THEN

This condition reads if recordset is not BOF and recordset is EOF then
do the execution. If recordset is already EOF the from where u will get the new record.

try this

IF NOT GOSSearchRS.EOF THEN

cheers,
Akhilesh Yadav

HTTP Module and Application path

Ponzano Paolo2-Nov-06 10:10

Ponzano Paolo

2-Nov-06 10:10

Hello,
I've written an HTTPModule that process HttpContext.Response's data, I need to open an .xml file that's located into application's path (where there's web.config)... for now I've written "C:\\InetPub\\......" but I want to better the code....... how I obtain that???

Thanks
Bests

Paolo

Re: HTTP Module and Application path

Akhilesh Yadav2-Nov-06 23:34

Akhilesh Yadav

2-Nov-06 23:34

use virtual path.

on putting "../" you go to parent folder of the current directory

cheers,
Akhilesh Yadav

Postback result in new window?

pahlsson2-Nov-06 9:41

pahlsson

2-Nov-06 9:41

Hi!

What a want to do is to have a LinkButton, or Button on a page, and when I press the button I want to open a new Window (javascript I suppose Smile | :)

and print the result of the postback in the new window, i.e. anything generated from the LinkButton.Click should be written in the new window.

Thanks!

/ N

Re: Postback result in new window?

Britney S. Morales2-Nov-06 11:58

Britney S. Morales

2-Nov-06 11:58

the result must to be a Session Var

On html Code ( page 1)

<br />
page.registerstartupscript("str",str)<br />

OnLinkButtonClick

<br />
dim str as string = "<script language=javascript>window.open('page2.aspx',target='_blank')</script>"<br />

OnLoad (Page 2)

<br />
label1.Text = --SessionVar--;<br />

keep Learning and you never will be out of date...

SQL Server 2005 Looping

nature02762-Nov-06 9:37

nature0276

2-Nov-06 9:37

I am C# developer. I need to learn about SSIS looping.
I have to go through each database and each table
and create text file of each table.

Any help

Sanjeev

Multiple SiteMapProviders

nlindley72-Nov-06 9:20

nlindley7

2-Nov-06 9:20

The index page on a website i'm designing contains a menu for, well, navigation. My question is what is the best route to dynamically set the menu's SiteMapProvider to the correct provider based on a users login credentials.

Nathan Lindley

Asp.net User controls

mcd24242-Nov-06 8:32

mcd2424

2-Nov-06 8:32

Hi

I have built 2 .net user controls and placed them both on the same page. One control (headlinedisplay.ascx) displays headlines from a webservice and the other displays the full article of a headline when you click on a headline links in the first usercontrol(articleDisplay.ascx).

I am displaying the headlines from headlinedisplay by progamatically creating asp/html controls. The problem I have is that when I click on a headline(linkbutton) and the Articleclick event fires to render the article the headlines in the headlinedisplay user control dissapear becuase of the post back. I think this happens because the controls were created dynamically and I need to redraw them. (If I through the data into a datalist this doesnt happen but leads to other problems so i cant really use that as a solution)

Does anybody know of away around this?

thanks for your help,

Re: Asp.net User controls

Guffa2-Nov-06 8:43

Guffa

2-Nov-06 8:43

There is no way around it. If you create controls dynamically, you have to create them every time the page is created.

---
b { font-weight: normal; }

Re: Asp.net User controls

mcd24242-Nov-06 8:46

mcd2424

2-Nov-06 8:46

Guffa,

thanks for the reply. I kind of figured that. I guess I will store the response from the webservice in a session vaiable and then just redisplay the headlines on postback.

Add nodes to SiteMapPath

shapper2-Nov-06 7:46

shapper

2-Nov-06 7:46

Hello,

I want to add nodes to Asp.Net 2.0 SiteMapPath in my runtime code.

I did as follows:

' Create site map path node collection
Dim siteMapPathNodeCollection As SiteMapNodeCollection

' Add node
siteMapPathNodeCollection.Add(New SiteMapNode(...))

My problem is I am ask to insert a 'provider' in SiteMapNode. I don't get it.

I have a data view with various rows and 2 columns 'Title' and 'Url'.
All I want is add these rows values to my site map path.

I was trying to loop through each row in my dataview but I am getting this problem with the provider.

Can someone sugest me how to do this?

Thanks,
Miguel

Re: Get XML node value

Elina Blank2-Nov-06 7:46

Elina Blank

2-Nov-06 7:46

Take a look at this:

XmlAttributeCollection attrColl = myElement.Attributes;<br />
<br />
        // Show the collection by iterating over it.<br />
        Console.WriteLine("Display all the attributes in the collection...");<br />
        for (int i = 0; i < attrColl.Count; i++)<br />
        {<br />
            Console.Write("{0} = ", attrColl[i].Name);<br />
            Console.Write("{0}", attrColl[i].Value);<br />
            Console.WriteLine();<br />
        }

It is in C#, but I am sure, you can translate it to VB

Sincerely,
Elina

Life is great!!!
Enjoy every moment of it! Blush | :O

Opensource Groups? Source Code? Recommended Books/Sites? Please Help!

Luke Armstrong2-Nov-06 6:14

Luke Armstrong

2-Nov-06 6:14

I am a web developer currently teaching myself ASP.NET 2.0 (in c#) with MySQL (rare combination, but still viable?). Getting ASP.NET & MySQL to work together at first was difficult, but now I understand the basics most code catered towards MS SQL can be altered to work with MySQL.

I mainly create bespoke content management systems for clients, so even though my knowledge is quite weak I am still putting it to regular use and constantly learning new things. I keep coming up against silly bugs/problems, or am having to write an awful lot of code (sometimes snippets twice) because I am not clued up on the best practices as I am essentially just making it up as I go along.

The tutorials and articles here are generally useful, but can sometimes be written crudely as they will only serve one purpose and no point in confusing someone by overcomplicating the methods. Alot of resources out there are catered towards 1.0 and 1.1 - when an awful lot changed in 2.0.

When I was learning PHP it was a great help to find opensource projects to delve into (even ones not classed as opensource still were of help because the code is always available). But with ASP.NET, practically everything is closed source (.dll's) and/or you have to pay a high price to see the source code.

Could anyone please recommend me any books worth getting, or offer any advice on how to find better online resources, or perhaps point me in the direction of some opensource projects I can look at - or towards some opensource groups I could collaborate with.

Thanks

Re: Opensource Groups? Source Code? Recommended Books/Sites? Please Help!

Luke Armstrong2-Nov-06 12:37

Luke Armstrong

2-Nov-06 12:37

no?

.net 2.0 Custom Web Services in SharePoint 2003

braber2-Nov-06 5:31

braber

2-Nov-06 5:31

Hello everyone,

Thanks in advance for any responses.

I had a question about developing a custom web service written in .net 2.0 for Windows SharePoint Services (i.e. running in _vti_bin or _Layouts directories). I can write a custom web service in .net 1.1, however, I am having an issue with the discovery of the wsdl for the 2.0 web service. I believe it has to do with the differences between 1.1 and 2.0 web project compilations. There is a great article for writing custom web services for sharepoint on msdn http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_sp2003_ta/html/odc_writingcustomwebservicesforsppt.asp

however, I need one in .net 2.0, any help would be greatly appreciated...

Brandon

braber

Go through XML nodes

shapper2-Nov-06 4:30

shapper

2-Nov-06 4:30

Hello,

I have an Asp.Net 2.0 Web.Sitemap file as follows:

...
<siteMap
xmlns = "http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" >
<siteMapNode>
<siteMapNode
url = "~/default.aspx"
description = "Jaqueline Roxo Atelier"
title = "Página Inicial"
footer = "true" />
...

I want to loop through all 'siteMapNode' nodes and check if 'footer' attribute is true.
If 'footer' is true I want to add the 'url' and 'title' values to a data table or to a data view.

Is this possible?
Can someone suggest a way to do this?

Thanks,
Miguel

Re: Go through XML nodes

braber2-Nov-06 5:37

braber

2-Nov-06 5:37

Yes, this is possible, look into the XmlDocument, XmlNode, XmlNodeList classes, then look for simple xpath queries... something like (//sitemapnode[@footer='true']/) of just query all sitemapnodes and then look for the attribute in the XmlNode...

Brandon

braber

Intercepting Keystrokes

Marc Paliotti2-Nov-06 4:08

Marc Paliotti

2-Nov-06 4:08

Is it possible to intercept keystrokes in asp.net? i have someone who wants a specific button that wants to be the enter button to fire that event. I know in vb.net for windows applications that you can basically choose which button you want. If someone out there has something, it would be very useful.

Re: Intercepting Keystrokes

Tad McClellan2-Nov-06 4:28