Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. stinkybee

    getting DropDownList Value from ListView InsertItemTemlate

    Is there a way to get the value from a DropDownList into the InsertParameters of a ListView SqlDataSource. I know that Bind() and Eval() don't work even though this works for other elements like TextBox. For example <asp:DropDownList ID="voucher_type_idDropDownList" runat="server"...
  2. stinkybee

    Convert Access SQL to SQL Server

    That's got it, apart from changing "false" to 0 Thanks Web Development Manager http://www.freemoneyoff.co.uk http://www.freemoneyresource.co.uk http://www.freemoneysurveys.co.uk
  3. stinkybee

    Convert Access SQL to SQL Server

    Thanks for the reply, hopefully that is a good starting point. I'll let you know if I manage to sort it. Web Development Manager http://www.freemoneyoff.co.uk http://www.freemoneyresource.co.uk http://www.freemoneysurveys.co.uk
  4. stinkybee

    Convert Access SQL to SQL Server

    I have been trying to convert my old access sql to sql server but after several hours have given up for now. Is there a tool to do this or failing that can someone convert this to SQL Server sql SELECT DISTINCT vouchers.ID as vid, vouchers.*, merchants.merchants_logo, merchants.merchants_id...
  5. stinkybee

    HTML5 Datalist not working

    Thanks for that, can't believe I didn't see it! Web Development Manager http://www.freemoneyoff.co.uk http://www.freemoneyresource.co.uk http://www.freemoneysurveys.co.uk
  6. stinkybee

    HTML5 Datalist not working

    Can anyone work out why my HTML5 Datalist is not working on this page Link but is on this test page Link The datalist options are being populated. If you look at the source you can see this, however, a dropdownlist is not appearing on the first page apart from for previous autocomplete...
  7. stinkybee

    Change order by in a selectcommand using parameters

    I am trying to change an ORDER BY in my SelectCommand of an AccessDataSource. I have tried using a QueryStringParameter to get a value and then add "ORDER BY @orderby DESC" but that doesn't work. I have also tried using a FilterExpression with a QueryStringParameter like this...
  8. stinkybee

    Display the value of a QueryStringParameter in my ListView

    This sounds as though it should be very simple but after hours of searching I cannot find an answer. All I need to do is display the value of a querystring from a QueryStringParameter in the ItemTemplate of my ListView. For example, I have this QueryStringParameter in my datasource...
  9. stinkybee

    inline conditional statement on Eval

    Thanks for the reply. Still couldn't get that to work but have made a workaround for now. In order to get the desired result I can display the string then add an asp:label that checks the length of the dataitem in the visible property: <%#Eval("code").ToString() %> <asp:Label runat="server"...
  10. stinkybee

    inline conditional statement on Eval

    I am trying to test a dataitem for an empty string and display "N/A" if the string is empty, otherwise display the string. For example, I have tried this: <%# Eval("code").ToString()=="" ? "N/A" : Eval("code") %> As suggested by numerous web searches. However, this does not work and produces...
  11. stinkybee

    Replace ’ characters from string

    For those that are interested I have managed to find a workaround solution by using IndexOf to find the position of the first two characters †then using Remove get rid of the those characters and the next one in the string. Then I use an Insert to put the apostrophe in the same place For...
  12. stinkybee

    Replace ’ characters from string

    That's the ® symbol so no go with that. Thanks for trying though. Web Development Manager http://www.freemoneyoff.co.uk http://www.freemoneyresource.co.uk http://www.freemoneysurveys.co.uk
  13. stinkybee

    Replace ’ characters from string

    Thanks for reply, this has perhaps got me on the right track. I can now replace the first two characters using unicode references with a regular expression or simple replace but the TM symbol is still not being replaced. For example, this does nothing new_text = Regex.Replace(new_text...
  14. stinkybee

    Replace ’ characters from string

    I'm reading a CSV file into a c# script and trying to replace certain characters that are causing problems. However, I can't seem to replace ’ which needs to be an apostrophe. I have tried stripping non-ascii characters with a regex but that leaves a ™ which I then cannot replace either...
  15. stinkybee

    Can't login to my admin section after clearing cookies

    Yes it is my site so I can see the code. This started after deleting cookies in IE and there has been no code changes. Web Development Manager http://www.freemoneyoff.co.uk http://www.freemoneysurveys.co.uk http://www.free-money-resource.com
  16. stinkybee

    Can't login to my admin section after clearing cookies

    I have an asp.net site that uses forms authentication to login to my admin backend. A few days ago I deleted my cookies in IE and now I cannot login. When I try it just stays on the login page. I have been searching for an answer to this for a couple of days but can't find anything. Any help...
  17. stinkybee

    Getting the ID of a deleted record within a ListView

    Thanks for the reply. It did lead me to find the answer which is e.Keys("recid") I'd been searching for a solution for hours before posting this question so not sure why I couldn't find this before. Anyway, thanks again for leading me in the right direction. Web Development Manager...
  18. stinkybee

    Getting the ID of a deleted record within a ListView

    I have a list view that has the usual Delete, Edit and Insert options. However, when deleting a record I need to get the id of the record that is being deleted so I can make further changes to my database. Can anyone supply some VB code that would allow me to do this. Thanks Web Development...
  19. stinkybee

    Conitional statements in listview with eval

    Thanks for the pointer. I was able to work it out from the link. There were a couple of issues but managed to do it by calling a function that set the style property of the containing div. <div class="review_button review_button_show" id="review_button<%# Eval("programmes_id")%>"...
  20. stinkybee

    Conitional statements in listview with eval

    Here's the code <asp:ListView ID="ListView2" runat="server" DataSourceID="AccessDataSource2"> <ItemTemplate> <asp:AccessDataSource id="AccessDataSource3" runat="server" DataFile="db/reviews.mdb" SelectCommand="SELECT * FROM programmes;"> </asp:AccessDataSource> <div...

Part and Inventory Search

Back
Top