User Profile

Collapse

Profile Sidebar

Collapse
CharlieChilds
CharlieChilds
Last Activity: Apr 25 '10, 12:35 PM
Joined: Apr 9 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • CharlieChilds
    replied to DataList / PagedDataSource / DataTable - How to allow for filter Control Parameter?
    in ASP .NET
    Sorted

    Code:
    SqlConnection conn = new SqlConnection("Data Source=tcp:s02.winhost.com;Initial Catalog=DB_5890_maindb1;User ID=DB_5890_maindb1_user;Password=bootsie23000;Integrated Security=False;");
         SqlCommand cmd = new SqlCommand("SELECT [ProductCode], [ImgUrl], [Featuring], [Title] FROM [TableSG1] WHERE [ProdCategoryID] = @ProdCategoryID ORDER BY [Featuring]", conn);
         
         SqlParameter
    ...
    See more | Go to post

      Leave a comment:

    • CharlieChilds
      replied to DataList / PagedDataSource / DataTable - How to allow for filter Control Parameter?
      in ASP .NET
      Hi Frinavale,

      The error message is "must declare scaler variable @ProdCategoryID "
      I have made some progress in getting as far as the following: NB I have shortened the SELECT clause to include only one parameter.

      Code:
               string ddl = DropDownList1.SelectedItem.Value;
         SqlConnection conn = new SqlConnection("Data Source=tcp:s02.winhost.com;Initial Catalog=DB_5890_maindb1;User ID=DB_5890_maindb1_user;Password=bootsie23000;Integrated
      ...
      See more | Go to post

        Leave a comment:

      • CharlieChilds
        started a topic DataList / PagedDataSource / DataTable - How to allow for filter Control Parameter?
        in ASP .NET

        DataList / PagedDataSource / DataTable - How to allow for filter Control Parameter?

        Prior to adding paging using PagedDataSource I had dropdownlist and search box filters for my DataList. The guts of the code in aspx page for those parameters is below:

        Code:
            <asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [ProductCode], [ImgUrl], [ImageField], [Featuring], [ProdCategoryID],
        ...
        See more | Go to post
        • CharlieChilds
          replied to How to get text from a label in a DataList ItemTemplate ?
          in Visual Basic .NET
          Hi CroCrew,

          Thanks very much for your response.

          I don't see dataGrid in my tool box of VWD 2008 Express. I used datalist because I need to repeat images accross the page. I tried GridView first using different fields for image urls but then realised I had a problem with databinding to other field info per individual image.
          I am still not 100% sure that DataList can do all that I need but so far so good.
          ...
          See more | Go to post
          Last edited by Frinavale; Apr 27 '10, 08:09 PM. Reason: Please post code in [code] ... [/code] tags. Added code tags.

            Leave a comment:

          • CharlieChilds
            started a topic How to get text from a label in a DataList ItemTemplate ?
            in Visual Basic .NET

            How to get text from a label in a DataList ItemTemplate ?

            Hi,
            I use Visual Web Developer 2008 Express.
            I have Label1 in a DataList ItemTemplate. I wish to use a button to get the text from that label and add it to text in TextBox1 which is elsewhere on the page.

            I know how to do this from a standard label on a ASP.NET web page but cannot work out how to get the text from a label inside a DataList ItemTemplate.

            This is what I thought I should do:-
            ...
            See more | Go to post
            • CharlieChilds
              replied to Datalist pager - It thinks it works but it doesn't adjust page size
              in .NET
              Sorted - after much brain sapping - it was a combination of simple errors - me newbie - please forgive.
              See more | Go to post

                Leave a comment:

              • CharlieChilds
                replied to What makes a website Ajax Enabled?
                in ASP .NET
                SORTED - I am informed that Ajax is standard with VWD 2008
                See more | Go to post

                  Leave a comment:

                • CharlieChilds
                  started a topic What makes a website Ajax Enabled?
                  in ASP .NET

                  What makes a website Ajax Enabled?

                  Hi,
                  I use Visual Web Developer 2008 Express. I am following which uses VWD2005 and says to create an Ajax enabled website. There is no specifically named "Ajax enabled template" in VWD 2008 Express

                  I think I have created one by creating a new ASP.NET website and adding a ScriptManager and an UpdatePanel to the page and placing the content of the page inside the UpdatePanel ContentTemplate ..

                  I am trying to...
                  See more | Go to post
                  Last edited by Frinavale; Apr 13 '10, 03:01 PM. Reason: Moved from ASP Classica to ASP.NET
                  • CharlieChilds
                    started a topic Datalist pager - It thinks it works but it doesn't adjust page size
                    in .NET

                    Datalist pager - It thinks it works but it doesn't adjust page size

                    I am a newbie who has followed a tutorial re a datalist pager. The tutrial expects its students to be more experienced than me. ie it expects students to know what goes at the top of the code behind page ( "imports" in VB / "using" in C# ) and I think it expects students to adjust Visual Studio property / events without any guidence. I have managed most of the adjustments in VWD user interface properties window but it appears...
                    See more | Go to post
                    No activity results to display
                    Show More
                    Working...