profileService with anything other than SQL

Let's say there is no SQL Server or SQL Express on the Web Server. How would one go about implementing the whole profile thing? You can supposedly use another source for a provider? Like an XML file or something like that. Has anyone sucessfully done this, or am I the only idiot trying this? I've been scowering Google for a few hours now and I'm no further along than I was 3 hours ago.

Profiles are part of the membership provider in the .net framework. What you need to do is write a custom membership provider.

Here's a good article on what your looking for

http://www.devx.com/asp/Article/29256

Here's my google search term

http://www.google.com/search?hl=en&q=Custom+Membership+Provider+%2B+ASP.net+2.0+%2B+XML

Thanks, but I've decided to go in another direction. I'm going to use cookies instead. They're just easier to use.

As advice, cookies are a dated way to handle things likes that, and you probably should look into newer methods.

What happens, if a user has created a profile, with information about theselves, or the way they like to use your website, and then they log on from a different computer...or clear their cookies?

I understand having to remember all my passwords for every site I visit, after I clear my cookies, but if that website lost all my settings, and personal / profile information just because I cleared my cookies, I'd be pissed.

Well then I would be forced to direct them top a web page picturing a straw, and suggest they suck it up. Mind you I'm not telling you to do that, I'm just suggesting one course of action with comedic twist.

Thanks for your input anyway.

Programatically set ImageUrl in ModalPopup

Hi I have a DataList that populates from an SQL datasource. One control in the DataList is an image whose ImageUrl i am currently setting as follows:

protected void dlItems_ItemDataBound(object sender, DataListItemEventArgs e)
 {
 Label lblItemID = (Label)e.Item.FindControl("lblItemID");
 Image imgItem = (Image)e.Item.FindControl("imgItem");
 imgItem.ImageUrl ="~/Images/Items/" + lblItemID.Text +".jpg";
 }

I want to be able to click the image and get a modal popup which displays a large view of the image. I have wrapped the image (imgItem) in a LinkButton. Heres the code:

<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">
<script runat="server">
 [System.Web.Services.WebMethod]
 [System.Web.Script.Services.ScriptMethod]
 public void SetLargeImagePath(int contextKey)
 {
 imgLargeImage.ImageUrl = "~/Images/Items/" + contextKey.ToString() + ".jpg";
 }
</script>
 <div>
 <asp:DataList ID="dlItems" runat="server" DataKeyField="pkiItemID" Width="100%" OnItemDataBound="dlItems_ItemDataBound">
 <ItemTemplate>
 <asp:Label ID="lblItemID" runat="server" Text='<%# Eval("pkiItemID")%>' Visible="False" CssClass="ItemText"></asp:Label>
 <asp:Label ID="bSpecialOfferLabel" runat="server" Text='<%# Eval("bSale")%>' Visible="False" CssClass="ItemText"></asp:Label>
 <table width="100%" class="Table">
 <tr>
 <td rowspan="6" valign="top">
 <asp:LinkButton ID="lnkImage" runat="server">
 <asp:Image ID="imgItem" runat="server" Width="150px" AlternateText="Click for a larger view" />
 </asp:LinkButton>
 <cc1:ModalPopupExtender ID="ModalPopupExtender" runat="server" TargetControlID="lnkImage" PopupControlID="pnlLargeImage"
 BackgroundCssClass="modalBackground"
 OkControlID="OkButton" DynamicControlID="Label1" DynamicContextKey='<%# Eval("pkiItemID")%>' DynamicServiceMethod="SetLargeImagePath" >
 </cc1:ModalPopupExtender>
 </td>
 <td style="width: 104px; padding-left: 5px;"><h2>Title:</h2></td>
 <td><asp:Label ID="szTitleLabel" runat="server" Text='<%# Eval("szTitle")%>' CssClass="ItemText"></asp:Label></td>
 <td style="width: 112px" rowspan="6" valign="middle">
  </td>
 </tr>
 <tr>
 <td style="width: 104px; padding-left: 5px;"><h2>Type:</h2></td>
 <td><asp:Label ID="szItemTypeLabel" runat="server" Text='<%# Eval("szItemType")%>' CssClass="ItemText"></asp:Label></td>
 </tr>
 <tr>
 <td style="width: 104px; padding-left: 5px;"><h2>Status:</h2></td>
 <td><asp:Label ID="szItemStatusLabel" runat="server" Text='<%# Eval("szItemStatus")%>' CssClass="ItemText"></asp:Label></td>
 </tr>
 <tr>
 <td style="width: 104px; padding-left: 5px;"><h2>Description:</h2></td>
 <td><asp:Label ID="szDescriptionLabel" runat="server" Text='<%# Eval("szDescription")%>' CssClass="ItemText"></asp:Label></td>
 </tr>
 <tr>
 <td style="width: 104px; padding-left: 5px;"><h2>Price:</h2></td>
 <td><asp:Label ID="mPriceLabel" runat="server" Text='<%# String.Format("{0:c}", Eval("mPrice"))%>' CssClass="ItemText"></asp:Label></td>
 </tr>
 <tr>
 <td style="width: 104px; padding-left: 5px;"><h2><asp:Label ID="mOfferPriceLabelStatic" runat="server" Text="Offer Price:"></asp:Label></h2></td>
 <td><asp:Label ID="mOfferPriceLabel" runat="server" Text='<%# String.Format("{0:c}", Eval("mSalePrice"))%>' CssClass="ItemText"></asp:Label></td>
 </tr>
 <tr>
 <td align="center" colspan="4">
 <asp:Button ID="btnAddToBasket" runat="server" CssClass="Button" Text="Add To Basket" />
 <asp:Button ID="btnBuyNow" runat="server" CssClass="Button" Text="Buy Now" /></td>
 </tr>
 </table>
 <br />
 </ItemTemplate>
 </asp:DataList>
 <asp:SqlDataSource ID="dlItemsDataSource" runat="server" CancelSelectOnNullParameter="False" ConnectionString="<%$ ConnectionStrings:ConnectionString%>" SelectCommand="spREAD_tblItems" SelectCommandType="StoredProcedure">
 <SelectParameters>
 <asp:Parameter Name="pkiItemID" Type="Int32" />
 <asp:Parameter DefaultValue="BRACELET" Name="fkiItemTypeShortText" Type="String" />
 <asp:Parameter DefaultValue="FORSALE" Name="fkiItemStatusShortText" Type="String" />
 <asp:Parameter DefaultValue="True" Name="bPublic" Type="Boolean" />
 <asp:Parameter Name="bSale" Type="Boolean" />
 <asp:Parameter Name="mPrice" Type="Decimal" />
 </SelectParameters>
 </asp:SqlDataSource>
 </div>
 <asp:Panel ID="pnlLargeImage" runat="server" Width="50%">
 <asp:Panel ID="pnlHeader" runat="server" Style="cursor: move;background-color:#DDDDDD;border:solid 1px Gray;color:Black" HorizontalAlign="Center" Width="100%">
 <div>
 <p>Larger view of item</p>
 </div>
 </asp:Panel>
 <div>
 <asp:Label ID="Label1" runat="server"></asp:Label>
 <asp:Image ID="imgLargeImage" runat="server" Width="200px" />
 <p style="text-align: center;">
 <asp:Button ID="OkButton" runat="server" Text="OK" />
 </p>
 </div>
 </asp:Panel>
</asp:Content>

This currently will load the ModalPopup and give Label1 the value of the pkiItemID, so i am successfully getting the item ID and passing it to the ModalPopup.

The problem is that the ImageURL is not being set. Oddly the SetLargeImagePath() method does not appear to run (breakpoints are ignored), although the Label1 value is being set??

Does anyone have any ideas how to get the image to appear in the ModalPopup?

Many thanks

Hi Assimalyst,

Assimalyst:

<script runat="server">
[System.Web.Services.WebMethod]
[System.Web.Script.Services.ScriptMethod]
public void SetLargeImagePath(int contextKey)
{
imgLargeImage.ImageUrl = "~/Images/Items/" + contextKey.ToString() + ".jpg";
}
</script>

Please contextKey should be a string type. For example, public void SetLargeImagePath(string contextKey){};

We suggest that you should use a debugging tool such as Web Development Helper or Fildder etc.

Assimalyst:

I want to be able to click the image and get a modal popup which displays a large view of the image.

Here is a sample which implement on the client side.

<%@. Page Language="C#" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><script runat="server"></script><html xmlns="http://www.w3.org/1999/xhtml" ><head runat="server"> <title>Change Picture</title> <style> .modalBackground { background-color:Gray; filter:alpha(opacity=70); opacity:0.7; } .modalPopup { background-color:#FFD9D5; border-width:3px; border-style:solid; border-color:Gray; padding:3px; width:250px; } </style></head><body> <form id="form1" runat="server"> <div> <asp:ScriptManager ID="ScriptManager1" runat="server"> </asp:ScriptManager><asp:Image ID="Image1" runat="server" ImageUrl="~/pic/upg_Business.jpg" imgUrl="../pic/upg_HomePremium.jpg" onclick="changePicture(event.srcElement.imgUrl)"/><asp:Image ID="Image2" runat="server" ImageUrl="~/pic/upg_HomeBasic.jpg" imgUrl="../pic/upg_Ultimate.jpg" onclick="changePicture(event.srcElement.imgUrl)"/> <asp:Panel ID="Panel1" runat="server" CssClass="modalPopup" Height="200px" Width="300px" style="display:none"> <asp:Image ID="Image3" runat="server" ImageUrl="~/pic/AJAX.gif"/> <asp:Button ID="Button2" runat="server" Text="Cancel" /> </asp:Panel> <ajaxToolkit:ModalPopupExtender ID="ModalPopupExtender1" runat="server" TargetControlID="Button1" PopupControlID="Panel1" CancelControlID="Button2"> </ajaxToolkit:ModalPopupExtender> <div style="display:none"> <asp:Button ID="Button1" runat="server" Text="Button" /> </div> <script type="text/javascript" language="javascript"> function changePicture(imgUrl){ $get("<%=Image3.ClientID%>").src = imgUrl; $get("<%=Button1.ClientID%>").click(); } </script> </div> </form></body></html>

I hope this help.

Best regards,

Jonathan

Programmatically Creating TabContainer and Adding Tabs

Plan - create a TabContainer via codebehind. Then read from a SQL DB (in this case NorthWind) and use the each CategoryName as a TabPanel.

Problem - Nothing displays. However, when I place TabContainer and TabPanel controls on the page during design, then run the code, I get the tabs with Category Names, but the first tab is the default name of the one I placed on the page during design.

Thoughts/suggestions?

Forgot to add the code (DUH):

Imports AjaxControlToolkit
Imports System.Data.SqlClient
Imports System.Configuration
Partial Class _Default
Inherits System.Web.UI.Page

Dim connectionString As String = "Data Source=MATT\SQLExpress;Initial Catalog=LucaSQL;Integrated Security=True;"
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If (Not Page.IsPostBack) Then
ReadCategories(connectionString)

End If
End Sub

Private Sub ReadCategories(ByVal connectionString As String)
Dim queryString As String = _
"SELECT CategoryID, CategoryName FROM dbo.Categories"

Using connection As New SqlConnection(connectionString)
Dim command As New SqlCommand(queryString, connection)
connection.Open()

Dim reader As SqlDataReader = command.ExecuteReader()
'Dim tc As New TabContainer

' Call Read before accessing data.
While reader.Read()
Dim CategoryName As String = reader("CategoryName")
Dim tab As New TabPanel
tab.HeaderText = CategoryName
tc.Tabs.Add(tab)

End While

' Call Close when done reading.
reader.Close()
End Using
End Sub
End Class

Hi,

In this case, you need to change its visibility with javascript. For example:

<%@. Page Language="C#" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"
<script runat="server"
 protected void Page_Load(object sender, EventArgs e)
 {
 for (int i = 0; i < 3; i++)
 {
 TabPanel tp = new TabPanel();
 tp.HeaderText = "tp" + i.ToString();
 tp.Controls.Add(new TextBox());
 TabContainer1.Tabs.Add(tp);
 }
 }
</script
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
 <title>Untitled Page</title>
<script type="text/javascript">
 function pageLoad()
 {
 $get("TabContainer1").style.visibility = "visible";
 }
 </script>
</head>
<body>
<form id="form1" runat="server">
<asp:scriptmanager ID="Scriptmanager1" runat="server"></asp:scriptmanager>
<div>
 <ajaxToolkit:TabContainer ID="TabContainer1" runat="server">
 </ajaxToolkit:TabContainer>
 <br />
 <br />
 <br />
 <br />
</div>
</form
</body>
</html>

Question...AJAX Code??

This code below is about AJAX. Where I need to put this code? .aspx? 

I'm trying to put in .aspx...But become error.. 

<% 

 Dim sql, conn, rs, x

response.expires=-1
sql="SELECT * FROM CUSTOMERS WHERE CUSTOMERID="
sql=sql & "'" & request.querystring("q") & "'"
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/db/northwind.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
rs.Open sql, conn
response.write("<table>")
do until rs.EOF
 for each x in rs.Fields
 response.write("<tr><td><b>" & x.name & "</b></td>")
 response.write("<td>" & x.value & "</td></tr>")
 next
 rs.MoveNext
loop
response.write("</table>")
%>

To be honest..I'm new generation about programming..So, help me please..

Hi,

I suggest you learn fromhttp://www.asp.net/ajax/.

Good luck!