ASP.NET

Re: mimic following ADO Recordset object Property/methods/events in ADO.NET

3-May-08 17:29

Member 4357460 wrote:
Need urgent HELP!!!!!

A good first step is to ask in the right forum.

ADO.NET is disconnected, it works differently to ADO.

I'm sure there are books on this, and article, too.

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 )

Member 43574603-May-08 18:41

Member 4357460

3-May-08 18:41

Yes I agree...with you..

but my current project demands the simulation of ADO Recordset object Property/methods/events in ADO.NET...

I need wrapper class...

thanks

Re: mimic following ADO Recordset object Property/methods/events in ADO.NET

Christian Graus4-May-08 11:32

Escaping Text in a GridView for SQLServer databases

4-May-08 11:32

Why does it require that ? You really can't have it, and because ADO.NET is disconnected, trying to simulate the connectedness of ADO is going to result in a LOT of database traffic.

Tom Harper3-May-08 10:16

Tom Harper

3-May-08 10:16

I am trying to come up with a way to use Uri.EscapeDataString() and Uri.UnescapeDataString() in a templated GridView so I can put tags into text that is uploaded into a SQlServer table, so that the formatted text can be put into a label on a web form. By escaping the data, I do not want to have ValidateRequest="false" set on the page header. I am trying to keep sqlInjection attacks from possibly happening on a database editing form.

My goal on this page is to drop one of the html editors onto the page to make the textbox become a word-like editor so the client can format data to be displayed on the website.

Thanks for any suggestions

Tom

Problem with converting type

Saba023-May-08 9:21

Saba02

3-May-08 9:21

Hi all,

I have this fuction in my class that named Insert:

public void Insert(int Productid, <big>double Price</big>, int Quantity,string Productname, string Productimageurl)<br />
       {<br />
            int itemindex = itemindexofid(Productid);<br />
           <br />
           if (itemindex == -1)<br />
           {<br />
               cartitem newitem = new cartitem();<br />
               newitem.Productname = Productname;<br />
               newitem.Productid = Productid;<br />
               newitem.Quantity = Quantity;<br />
               newitem.Price = Price;<br />
               newitem.Productimageurl = Productimageurl;<br />
               items.Add(newitem);<br />
           }<br />
           else<br />
           {<br />
               items[itemindex].Quantity += 1;<br />
           }<br />
           lastupdate = DateTime.Now;<br />
       }

Now i want use this function as bellow:

protected void btnAddToCart_Click(object sender, ImageClickEventArgs e)<br />
    {<br />
        <big>string Price = double.Parse(((Label)DataList1.Controls[0].FindControl("PriceLabel")).Text).ToString("0.00");</big><br />
        string ProductName = ((Label)DataList1.Controls[0].FindControl("Book_NameLabel")).Text;<br />
        string PictureURL = ((Label)DataList1.Controls[0].FindControl("picLabel")).Text;<br />
        int ProductID = Convert.ToInt32(Request.QueryString["idLabel"]);<br />
        if (Profile.cart == null)<br />
        {<br />
            Profile.cart = new ShopCart.wroxshoppingcart();<br />
        }<br />
        Profile.cart.Insert(ProductID, Price,1,ProductName,PictureURL);<br />
        Server.Transfer("ItemIndex.aspx");    <br />
}

I have problem with Price,i convert price to string ,then i want send price that be converted to string to function, that the type of price in my function is double.
How i can do this work?

thank you

Hoda

Hesham Amin3-May-08 10:14

Hesham Amin

3-May-08 10:14

Why did you convert it to string in the first place?
You can replace this line:
string Price = double.Parse(((Label)DataList1.Controls[0].FindControl("PriceLabel")).Text).ToString("0.00");
with this:
double Price = double.Parse(((Label)DataList1.Controls[0].FindControl("PriceLabel")).Text);

Hesham A. Amin
My blog

Sunset Towers3-May-08 10:35

Sunset Towers

3-May-08 10:35

To build a little on hspc reply

double d = 0;
bool DoubleParseSuccessful;
try
{
    DoubleParseSuccessful = double.TryParse(double.Parse(((Label)DataList1.Controls[0].FindControl("PriceLabel")).Text).ToString("0.00"), out d);
}
catch (FormatException Fex)
{
    DoubleParseSuccessful = false;
}
if (DoubleParseSuccesful == false)
{
    //Do something here
}

This will prevent your application from crashing if someone posts false data back to the server by changing the PriceLabel.

Christian Graus3-May-08 13:28

3-May-08 13:28

Why not just call tryparse, and not bother with converting back and forth ?

Blue_Boy3-May-08 13:38

Blue_Boy

3-May-08 13:38

...<br />
Profile.cart.Insert(ProductID, Convert.ToDouble(Price),1,ProductName,PictureURL);<br />
...

I Love T-SQL

Don't torture yourself,let the life to do it for you.

Webcontrol not displaying treeview [modified]

Saba024-May-08 6:32

Saba02

4-May-08 6:32

Thank you very much for your responses Smile | :)

Hoda

Sunset Towers3-May-08 8:25

Sunset Towers

3-May-08 8:25

I am trying to create an advanced treeview control that has some added control features. My problem is that the treeview does not display. I can add other controls such as a textbox and it displays with out any problems, so I'm assuming it has something to do with the treeview control itself. Here is the code I'm using.

After some further testing I have noticed that the problem is not in the rendering but with in VS2008. I can not edit the nodes within VS2008. It tells me that the object is null. So that is where the probem is.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace AdvancedWebTreeView
{

    [ToolboxData("<{0}:AdvancedWebTreeView runat=server></{0}:AdvancedWebTreeView>")]
    public class AdvancedWebTreeView : Panel
    {

        public AdvancedWebTreeView()
        {
            if (ViewState["AdvancedTreeView"] == null)
            {
                p_AdvancedTreeView = new TreeView();
                p_AdvancedTreeView.Attributes.CssStyle[HtmlTextWriterStyle.Position] = "absolute";
                p_AdvancedTreeView.Attributes.CssStyle[HtmlTextWriterStyle.Top] = "0px";
                p_AdvancedTreeView.Attributes.CssStyle[HtmlTextWriterStyle.Left] = "0px";
                p_AdvancedTreeView.Attributes.CssStyle[HtmlTextWriterStyle.Height] = "100px";
                p_AdvancedTreeView.Attributes.CssStyle[HtmlTextWriterStyle.Width] = "100px";
                ViewState["AdvancedTreeView"] = p_AdvancedTreeView;
                this.Controls.Add(p_AdvancedTreeView);
            }
            else
            {
                p_AdvancedTreeView = (TreeView)ViewState["AdvancedTreeView"];
                this.Controls.Add(p_AdvancedTreeView);
            }
        }

        private TreeView p_AdvancedTreeView;

        [Category("Internal Controls")]       
        public TreeView AdvancedTreeView
        {
            get
            {
                return p_AdvancedTreeView;
            }
        }

        protected override void RenderContents(HtmlTextWriter output)
        {
            this.CreateChildControls();            
            this.RenderChildren(output);
        }
    }
}

modified on Saturday, May 3, 2008 3:02 PM

FormView ItemCreated problem

AmirAlilou3-May-08 4:25

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 ?

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