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!

Search results for query: *

  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...
  16. BoydMT

    Single User

    I need to put a database into single-user mode so I can run DBCC CHECKDB with repairs. This database is a distributor for replication. How can I do this? Thanks, Mark
  17. BoydMT

    SQL table corrupt

    Bill - I thought of this, but was concerned that it may cause even more of a problem. Maybe I'll give it a shot if DBCC CHECKDB doesn't help. Thanks, Mark
  18. BoydMT

    SQL table corrupt

    Thanks for the input. Yes, this database is a distributor for replication. I think i'll wait til the end of the business day, and run DBCC CHECKDB. Hopefully this will resolve it. Otherwise, I will try disabling, then re-enabling the replication. Thanks again, Mark
  19. BoydMT

    SQL table corrupt

    Thanks Robert. This returned table 'MSmerge_contents'. Have you ever dealt with table corruption in a system table like this? If so, any suggestions as to a possible solution? Mark
  20. BoydMT

    SQL table corrupt

    My backup software for a SQL7 database is failing with the following message: Table Corrupt: Object ID 734690461, Index ID 2. Keys out of order on page (1:78526), slots 145 and 146. How can I determine what table is actually corrupt? I am thinking about running DBCC CHECKDB. Can this cause...

Part and Inventory Search

Back
Top