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 strongm 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: *

  • Users: dstrange
  • Content: Threads
  • Order by date
  1. dstrange

    Open file from database listed in a Repeater

    Hello, I have a nested repeater that displays the title of saved documents from a database. How can I make the Linkbutton for each listed file title a hyperlink to open/save/cancel the file from the database? <asp:Repeater ID="repMenu1" runat="server"> <HeaderTemplate>...
  2. dstrange

    Gridview to populate off of calendar.selecteddate

    Hi, I'm trying to bind a calendar control's selected date to populate a gridview. I'm wondering if it has to do with date formatting? SelectCommand="SELECT * FROM [tblTest] WHERE ([ReportDate] = @ReportDate) ORDER BY [ReportDate]" <SelectParameters> <asp:ControlParameter...
  3. dstrange

    MaintainScrollPositionOnPostback

    This works great when a page hits a postback but is there a way for this option to work if I click a link on the page that reposts to the same url but with a querystring attached? Thanks in advance.
  4. dstrange

    MaintainScrollPositionOnPostback

    This works great when a page hits a postback but is there a way for this option to work if I click a link on the page that reposts to the same url but with a querystring attached? Thanks in advance.
  5. dstrange

    Remove all html tags within a string

    Does anyone have a vb function that will remove all html tages within a large string of data? I've tried some of the functions below but to no avail yet. Any help would be appreciated. Function RemoveHTML(ByVal strText As String) As String strText =...
  6. dstrange

    Sitemap with querystring

    Hi All, Currently I have a page titled test.aspx. Here's the sitemap info: <siteMapNode url="~/default.aspx" title="Home" > <siteMapNode url="~/test.aspx" title="test" > <siteMapNode url="~/test.aspx?archive=y" title="test archive" /> <siteMapNode...
  7. dstrange

    Get value of each selected row in DataGridView

    Hi all, I have a datagridview with multiselect on. How can I check all the rows and just return the 1 cells value for each selected row from a button click event? Thanks in advance
  8. dstrange

    FilterExpression by year of date

    Hello All, In code I'm trying to use a filterexpression on a datetime field only by the year. ex. datasource.FilterExpression = "year[postDate] = '2007'" In sql I can use: select * from tblTable where year(datefield) = '2007' and it works. Any ideas? Thanks in advance.
  9. dstrange

    Binding DetailsView from Gridview selection other than selectedvalue.

    Is this possible? I'd like to have my DetailsView based off of the selection of the Gridview from the value in the 3rd column. I'm used to doing this based off of the gridview.selectedvalue but I am not sure how to do it based of off another gridview column. Thanks in advance.
  10. dstrange

    Populate formview off of another formview

    Hello, I'm a asp.net newbie so be patient. I have 2 formviews that load at the same time. formview1 comes from tableA and formview2 comes from table2. They both share a common field. What I would like is for formview2 to load based off a value that is loaded in formview1. I know it involves...
  11. dstrange

    Views have changed to Tables? How can this happen?

    Received some errors from a client regarding some reports from a VB app that reads data from MySQL views and generates crystal reports. After receiving a backup I noticed that a lot of the views are now listed as Tables in the schema. Has anyone ever experienced this? Is there anything to look...
  12. dstrange

    Server Variable Suggestions

    Anyone have any initial my.ini server variable suggestions for improving db performance. We use a INNODB db at work containing 200 tables with 60 views and usually have between 3-5 users using an app writing to the db constantly. By default the ini file variables are setup like this...
  13. dstrange

    Updating MySql Tables. SELECT vs. UPDATE

    Hi, I have a MySQL db with a vb6 app that connects using ADODB. I've been getting some notices about multiple testers adding new/editing records in the same db but the information is getting crossed over to what another user was recording. So basically User A's saved info is getting put into...
  14. dstrange

    MySQL Foreign Keys and Indexes

    Hi, I'm kinda new to this so please be patient. I'm using MySQL Query Browser to setup some Foreign Keys and Indexes but I keep getting the dreaded 1452 error. What is the general rule of thumb for what should come first? Foreign Keys or Indexes? Also is it bad practice to have the same columns...
  15. dstrange

    Setting Listview Column Width

    Is there a way to set the width of a single column in a listview at runtime to a different size? I want a specific column width to change from 900 to 0 depending if the user has selected a checkbox or not. Thanks in advance.
  16. dstrange

    MySQL Backup Sizes

    Hello, I'm working with a mysql backup that was 175mb and after I restored it I made a new backup and the size of the file was now only 65mb. Anyone ever come across this before? I haven't changed anything in the database after the restore, I just did my own backup. The larger backup was passed...
  17. dstrange

    FoxPro to MySQL using vb6

    I have to convert around 100,000 records from FoxPro tables into Mysql. What would you recommend is the fastest way of doing this? I've taken over a project that as of right now run at over 10 hours for this and it seems way too unnecessary. Basically the setup is select the specific fields...
  18. dstrange

    Image dimensions for a form background

    Hi, maybe I'm missing something but what measurement are a form's width and height in. It's not pixels. I was trying to make an image background for my form using the height and width of the form for the height and width of the image. I thought it was in pixels but it is not. Anyone know what VB...
  19. dstrange

    Retrieve Gmail Address Book

    Hi I very new to C#, I got a small app working to send emails using my Gmail account. Is there a way I can connect to my Gmail address book and populate the addresses into a combo box? Much appreciated.
  20. dstrange

    Query with multiple data filters

    Hi, I need help with syntax but I dunno if what I want is possible. I need to retrieve the # of items sold and then broken down into; year to date, period to date , and total items sold. Can this be done with 1 query? SELECT count(id) as 'Total Items Sold'...

Part and Inventory Search

Back
Top