ASP.NET

3-May-08 4:25

The following example demonstrates how to use the Row property to access the properties of the data row during the ItemCreated event.

<br />
<br />
<![CDATA[<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default6.aspx.vb" Inherits="Default6" %>]]><br />
<br />
<![CDATA[<%@ import namespace="System.Data" %>]]><br />
<br />
<script runat="server"><br />
  <br />
  Sub EmployeeFormView_ItemCreated(ByVal sender As Object, ByVal e As EventArgs)<br />
  <br />
    ' Use the Row property to retrieve the data row from <br />
    ' the FormView control.<br />
    Dim row As FormViewRow = EmployeeFormView.Row<br />
    <br />
    ' Get the data item bound to the FormView control.<br />
    Dim rowView As DataRowView = CType(EmployeeFormView.DataItem, DataRowView)<br />
<br />
    ' Set the ToolTip property of the data row. <br />
    row.ToolTip = rowView("FirstName").ToString() & " " & _<br />
      rowView("LastName").ToString()<br />
  <br />
  End Sub<br />
    <br />
</script><br />
<br />
<html><br />
  <body><br />
    <form id="Form1" runat="server"><br />
        <br />
      <h3>FormView Row Example</h3><br />
                       <br />
      <asp:formview id="EmployeeFormView"><br />
        datasourceid="EmployeeSource"<br />
        allowpaging="True"<br />
        datakeynames="EmployeeID"<br />
        onitemcreated="EmployeeFormView_ItemCreated"  <br />
        runat="server"><br />
        <br />
        <itemtemplate><br />
        <br />
          <table><br />
            <tr><br />
              <td><br />
                <asp:image id="EmployeeImage"><br />
                  imageurl='<%# Eval("PhotoPath") %>'<br />
                  alternatetext='<%# Eval("LastName") %>' <br />
                  runat="server"/><br />
              </asp:image></td><br />
              <td><br />
                <h3><![CDATA[<%# Eval("FirstName") %>]]> <%# Eval("LastName") %></h3>      <br />
                <%# Eval("Title") %>        <br />
              </td><br />
            </tr><br />
          </table><br />
        <br />
        </itemtemplate><br />
          <br />
      </asp:formview><br />
          <br />
      <!-- This example uses Microsoft SQL Server and connects  --><br />
      <!-- to the Northwind sample database. Use an ASP.NET     --><br />
      <!-- expression to retrieve the connection string value   --><br />
      <!-- from the Web.config file.                            --><br />
      <asp:sqldatasource id="EmployeeSource"><br />
        selectcommand="SELECT [EmployeeID], [LastName], [FirstName], [Title], [PhotoPath] FROM [Employees]"<br />
        connectionstring="<%$ ConnectionStrings:NorthwindConnectionString %>" <br />
        runat="server"/><br />
            <br />
    </asp:sqldatasource></form><br />
  </body><br />
</html><br />
<br />
<br />

but when i run it an exception accured Object reference not set to an instance of an object.

i don't know what is problem

thanks

Christian Graus3-May-08 13:27

3-May-08 13:27

Do you have northwind set up ? Does that code point to the right connection string on your PC ?

Christian Graus

Please read this if you don't understand the answer I've given you

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

AmirAlilou3-May-08 20:07

3-May-08 20:07

Christian Graus wrote:
Do you have northwind set up ? Does that code point to the right connection string on your PC ?

yes i have it on my local SqlServer but whenever i run this sample an exception occured

AmirAlilou4-May-08 18:35

4-May-08 18:35

also i have coorect connection string but not working

AmirAlilou3-May-08 21:16

3-May-08 21:16

there are some serious problems in using FormView for example when we want to access server controls such as DropDownList, that located in FormView in the following Event

 <br />
Protected Sub FormView1_ModeChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles FormView1.ModeChanged<br />
        Dim ddl As DropDownList = CType(FormView1.Row.FindControl("DropDownList2"), DropDownList)<br />
        DropDownList1.Text = ddl.SelectedItem.Text    End Sub<br />

an exeption ocured for bolded line

Object reference not set to an instance of an object.

noticed that DropDownList2 located in FormView EditItemTemplate and DropDownList1 located out side of FormView Control

Christian Graus4-May-08 11:36

AJAX Control Toolkit - Accordion

4-May-08 11:36

You should never use 'as' without checking if the resultant variable is nothing first. That's what as is for.

I've never used a FormView, but from the questions I read here, it sounds like they suck.

If you get the exception in your data layer, then your connection string must be broken.

Yaniv___3-May-08 3:46

Yaniv___

3-May-08 3:46

Hi,
I working with Visual Studio 2005 and Ajax Control Toolkit ver. 1.0.20229.
I'm trying to set an accordion in my web application.

The problem is that when I put on design mode, instead of the accordion, I see an error message:
"Error creating control - Accordion1
Type 'AjaxControlToolkit.Accordion' does not have a public property named 'AccordionExtender'."
The code of course can not be compiled.

My source is that:

<br />
<cc1:Accordion ID="Accordion1" runat="server" Height="50px" Width="300px"><br />
                        <cc1:AccordionExtender ID="Accordion1_AccordionExtender" runat="server" Enabled="True"<br />
                            TargetControlID="Accordion1"><br />
                            <Panes><br />
                                <cc1:AccordionPane runat="server"></cc1:AccordionPane><br />
                            </Panes><br />
                        </cc1:AccordionExtender><br />
                    </cc1:Accordion><br />

Is there any one with an idea to solve this problem?
Thanks

Re: AJAX Control Toolkit - Accordion

Sam Xavier8-May-08 19:42

Sam Xavier

8-May-08 19:42

I think this was an issue with earlier version of Toolkit.
Try downloading the latest release and see what happens.
There is also a nice sample which gets installed in the Toolkit directory.
Try running this sample and see if Accordion control works properly here or not.

Best Regards,
Sam Xavier
www.componentone.com

Re: AJAX Control Toolkit - Accordion

Bit-Smacker4-Jun-08 6:48

Bit-Smacker

4-Jun-08 6:48

I'm having the same problem with VS2005Std.

I'm trying to dynamically generate accordion panels with codebehind, but when I change any property in the design view, the source editor automatically inserts an AccordionExtender block within the Accordion block, causing the error you described.

Before:

<cc1:Accordion ID="acc1" runat="server" Width="300px" FadeTransitions="true">
</cc1:Accordion>

After:

<cc1:Accordion ID="acc1" runat="server" Width="300px" FadeTransitions="true" ContentCssClass="content" HeaderCssClass="header">
    <cc1:AccordionExtender ID="acc1_AccordionExtender" runat="server" ContentCssClass="content"
        Enabled="True" FadeTransitions="True" HeaderCssClass="header" TargetControlID="acc1">
    </cc1:AccordionExtender>
</cc1:Accordion>

What is the reason for this and how can I work around it?

Form view in Asp.Net

kumarrpt3-May-08 1:34

kumarrpt

3-May-08 1:34

Hi i am using form view in ASP.net
when i bind using dataTable it displays only the first item and the remaining items does not appears.
Please help me what's wrong in this code which is written in button click event......
button_click()
{
ArrayList fileList = new ArrayList();
string strDirPath = Path.GetDirectoryName(Server.MapPath("./serverfiles/"));
String[] files = Directory.GetFiles(strDirPath);
DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add("File_List", typeof(string));
foreach (string str in files)
{
dr = dt.NewRow();
fileList.Add(Path.GetFileName(str).ToString());
dr[0] = Path.GetFileName(str).ToString();
dt.Rows.Add(dr);
}
FormView1.DataSource = new DataView(dt);
FormView1.DataBind();

}

For Form View
---------------
<HeaderTemplate>
<table border = "5" width="400">
<tr bgcolor ="#10cccc">
<td>
<b>File Name</b>
</td>
<td>
<b>To View</b>
</td>
<td>
<b>To Cancel</b>
</td></tr>
</HeaderTemplate>

<ItemTemplate>
<tr bgcolor = "#ffcccc">

<td><asp:Label ID = "lblFilelist" runat ="server" text=' <% # Bind("File_List") %>'>
</asp:Label></td>

<td><asp:Button ID="btnDownload" Text="Download" CommandName="Download" RunAt="server"/></td>

<td><asp:Button ID="btnDelete" Text="Delete" CommandName="Delete" RunAt="server"/></td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>

Re: Form view in Asp.Net

Christian Graus3-May-08 1:37

Re: relationship in sql???

3-May-08 1:37

kumarrpt wrote:
Path.GetFileName(str).ToString();

Why do people always insist on calling 'ToString' on strings ?

Have you stepped through to confirm there are more records going into the data source ?

You're binding to a label, is this how a formview words ? I'd expect a gridview or other data bound control.

relationship in sql???

mr.mohsen3-May-08 1:02

mr.mohsen

3-May-08 1:02

hi i have a database with some relationships between my tables. when a record has deleted in one table some records in another tables that have a relation with deleted record,wll be delete.
in my local system this work perform correctly,but the problem is that in server this word do not perform correctly and when a record deleted other records on another tables that have relation with deleted record do not deleted.
how can i do this work.tell me if you know it please.
i know that here is not suitable place for sql problem but here are exist more good programmers
thank you

nobody help you...
you have to help you yourself
and this is success way.

Christian Graus3-May-08 1:05

Re: relationship in sql???

3-May-08 1:05

mr.mohsen wrote:
i know that here is not suitable place for sql problem

That's true. Why did you ask in the wrong forum ?

You need to write a stored proc that deletes the related records. It never happens by itself.

Hesham Amin3-May-08 10:20

Hesham Amin

3-May-08 10:20

Christian Graus wrote:
You need to write a stored proc that deletes the related records. It never happens by itself.

What about foreign key constraints with on delete cascade specified?

Hesham A. Amin
My blog

Password Hashing

Brady Kelly3-May-08 0:37

Brady Kelly

3-May-08 0:37

Are there any caveats around using HashPasswordForStoringInConfigFile? Besides its daft name, I mean, why so narrow down a perfectly reusable method? I'm storing my passwords in a database, and now I have to write a damn comment telling people, "No, it isn't actually being hashed for the config file!"

Re: Password Hashing

Christian Graus3-May-08 1:16

3-May-08 1:16

I didn't know there were settings for this, but I'd never use them, if I want something, I'll use the built in hashing algorithms, but I wouldn't use a built in method that defines how they are used.

Re: Password Hashing

Brady Kelly3-May-08 2:12

Brady Kelly

3-May-08 2:12

Yes, I posted my question before really looking at that method, and it's somewhat less than confidence inspiring. I'm now using MD with salt, where that method doesn't use salt.

pdf file and exe

bigphish3-May-08 0:15

bigphish

3-May-08 0:15

I have a helpfile.pdf in my project.whenever clickinh the help button it will popup in a seperate window.i have given like this:

private void LinkButton1_Click(object sender, System.EventArgs e)<br />
		{<br />
			Response.Write("<script>window.open('help/ Helpfile.pdf?a=new','','left=0,top=0,width=860px,height=600px,toolbar=0,scrollbars=1,status=1')</script>");<br />
			<br />
		}

it is working fine, but when i am taking the msi(exe) of the project the help file is not coming..y this happening?

Thanx in advance.

Christian Graus3-May-08 1:06

3-May-08 1:06

You need to add your PDF to your MSI ?

bigphish3-May-08 1:20

bigphish

3-May-08 1:20

yes.i hav already added in my project. but cant able to see,that files whn running MSI.

Christian Graus3-May-08 1:32

3-May-08 1:32

OK - I don't know the first thing about making an MSI in VS, I use advanced installer. If it's in your project, then there must be another step to tell it to put it in the msi.

bigphish3-May-08 2:19

bigphish

3-May-08 2:19

for creating set up in vs:
go to
solution explorer>solution >newproject > add >select documentation files,primary output,content files as project output > run project in release mode > build solution .
ur msi is created in desired location.

jus written,may hav usefull 4 sme others.