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!

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

Recent content by BoydMT

  1. BoydMT

    Excel: Expand/Collapse with Data from Other Spreadsheet

    I have a spreadsheet containing summary-level data. The columns are as follows: "Department", "Budgeted Hours", "Actual Hours", "Variance", and "Expenses". I have a 2nd spreadsheet with detail-level data .. "Department", "Employee", "Work Date", "Hours". What I've been asked to do is display...
  2. BoydMT

    Set SelectedIndex of Datagrid DropDownList

    Thanks for the response. I think I resolved the issue by changing the datasource for the drop-down control. I don't believe I was setting the datasource correctly, therefore the control didn't have data to popoulate with. Thanks again, BoydMT
  3. BoydMT

    Set SelectedIndex of Datagrid DropDownList

    When 'Edit' is clicked, I want a drop-down list to display the value that is in the cell prior to clicking 'Edit'. I use the following code to do this: Private Sub dgProposals_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DataGridItemEventArgs) Handles...
  4. BoydMT

    Datagrid DropDown - OnSelectedIndexChanged

    Thanks. This seems to be what I'm looking for. One question, though. In the statement 'Dim DataSystem As CompanyDB = New CompanyDB', what exactly is CompanyDB? Do I need to import it somewhere? Thanks again, BoydMT
  5. BoydMT

    Datagrid DropDown - OnSelectedIndexChanged

    Thanks for the response. I've come across this example in the past, but am only familiar with VB.net, not C#. After working with my issue over the past few hours, I'm now able to query the table for the appropriate company type. My issue now is passing this value to the field in my datagrid...
  6. BoydMT

    Datagrid DropDown - OnSelectedIndexChanged

    I have a datagrid with a number of fields. Among them are [CompanyName] and [CompanyType]. In Edit mode, [CompanyName] is a drop-down list, and [CompanyType] remains a label. Whenever the value in [CompanyName] is changed, I need to search a table for the appropriate company type, and change...
  7. BoydMT

    Datagrid Drop-downs

    Siva - Thanks for the reply. I understand how to make a control a drop-down list when 'Edit' is clicked. What I can't figure out is how to populate another drop-down list based on what was selected from the first one. For example, Table1 has the following records: John Smith, ABC Corporation...
  8. BoydMT

    Datagrid Drop-downs

    My app is connected to 3 SQL tables (tblCompanies, tblContacts, and tblProposals). I've created a datagrid to maintain the data from tblProposals. This datagrid contains the following 4 fields: [CompanyName],[ContactName], [ContactTitle], and [ProposalID]. When the user clicks 'Edit', the...
  9. BoydMT

    Looping within a Stored Procedure

    As a VBA programmer, I've been creating loops within my code for years. However, I now want to do the same using SQL Server, but have heard to avoid them if at all possible. I have a table named 'tblFollowUp'. The table consists of 3 fields ([Name], [Date], [Comment]). An example of the data...
  10. BoydMT

    Schema script could not be propogated

    I have created a pull subscription from a SQL2k publication. When I attempt to synchronize thru Windows Synchronization, I receive the following error: 'The schema script '\\SQLServer1\E$\Program Files\Microsoft SQL Server\MSSQL\ReplData\unc\SQLServer1_DB1_Pub1\20031113142755\SomeTable_1.sch'...
  11. BoydMT

    SQL table corrupt

    Bensta - I use Veritas Backup Exec to back up my SQL Server. In order for the backup to complete successfully, I had to uncheck the options 'Consistency Check Before Backup' and 'Consistency Check After Backup'. This should backup your data without a problem, but you do want to eventually...
  12. BoydMT

    Multiple Syncs Running

    I am in the process of creating 3 Push Subscriptions from 1 Distributor/Publisher. Basically, I need all 4 SQL Servers to have the same data replicated between each other. Are there any known issues with setting up all 3 Replication Schedules to run at the same times during the day? I want to...
  13. BoydMT

    Single User

    Thanks mikeyb540. This is exactly what I was looking for. Mark
  14. BoydMT

    Single User

    James - Thanks for the code. I am trying to use your code for single user mode, and am getting the following error: Incorrect syntax near the keyword 'SET'. Any ideas? I am using SQL7. Thanks, Mark
  15. BoydMT

    Single User

    Thanks for the response. I don't think I was totally clear in my initial request. When I try putting the database in 'single user' mode, I receive an error message stating the option can't be changed while another user is in the database. I'm pretty sure there is no one else in this database...
See more

Part and Inventory Search

Back
Top