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 derfloh 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. andyd273

    dynamically creating a web page

    Thanks for the tip. I'll give that a try (possibly next week, as its just about time to go home for the day) Much thanks
  2. andyd273

    dynamically creating a web page

    That sounds like a good idea, but for some odd reason I'm having trouble finding anywhere that tells how to do that. Also, does it make a difference on how you do it if its part of a sharepoint portal page?
  3. andyd273

    dynamically creating a web page

    Datagrid the first section of the table: /code dgCustomer = New DataGrid Dim newColumn As BoundColumn Dim btnColumnSelect As ButtonColumn dgCustomer.AllowPaging = False dgCustomer.HeaderStyle.Font.Bold = False dgCustomer.HeaderStyle.BackColor =...
  4. andyd273

    dynamically creating a web page

    Yeah, that describes it good.
  5. andyd273

    dynamically creating a web page

    Its the passing of information between webparts, especially webparts on seperate pages, that I dont know how to do. He basically wants the list of customers on the main page, and the fact sheet to show up on a second page. What is a good resource to looking up how to do this?
  6. andyd273

    dynamically creating a web page

    I have a web part that pulls information from a database, puts it into a table and displays in on the web page. My boss wants me to take the table with the information in it and put it into another web page. I'm using vb.net 2003 to do the writing, and I'm fairly new to this side of things, and...
  7. andyd273

    WSS & VB.Net: Webparts with buttons and triggers.

    I am creating a webpart that will take ultimately take user information and display it in another web part or in a new window. My problems are these: 1) I can't seem to figure out how to use a button to trigger an action in the web part. Basically, I want to make is so that I push a button and...
  8. andyd273

    Not registered as safe

    Try adding the dll to the GAC. I was unable to solve this problem until I found the GAC and figured out how to put stuff in there. basically, control panel->administrative tools->.net configuration 1.1->Assembly cache just browse to where the dll file is located and add it...
  9. andyd273

    Move instead of Delete

    ...they don't matter) and that seems to have fixed the error. also I set it to After Delete because it wasnt deleting with For Delete... Alter TRIGGER [tblCustomerComments_delete] ON [JL].[dbo].[tblCustomerComments] AFTER DELETE AS insert [JLDel].[dbo].[tblCustomerComments] select * from deleted
  10. andyd273

    Move instead of Delete

    ...something like: Create TRIGGER [deletecopy] ON [JL].[dbo].[tblCustomerComments] FOR DELETE AS insert [JLDel].[dbo].[tblCustomerComments] select * from deleted Which returns: Server: Msg 8101, Level 16, State 1, Procedure deletecopy, Line 4 An explicit value for the identity column in...
  11. andyd273

    Move instead of Delete

    I want to set up a system so that when a user tries to delete a record from the database it automatically moves the record to a mirror database, to act kind of like a recycle bin, so that in case someone accidently pushes the wrong button, we wont loose valuable information. I know I can use...
  12. andyd273

    Custom database connections without front page.

    I should add that I'm trying to connect to a SQL server 2000 database... which is on the same machine as the sharpoint server. Sharepoint is also using a sql database on this same server, just a different one from the customer database.
  13. andyd273

    Custom database connections without front page.

    ...Dim Ada As System.Data.SqlClient.SqlDataAdapter Dim conStr As String conStr = "server=poweredge1850;uid=****;pwd=****;initial catalog=jl" Con = New System.Data.SqlClient.SqlConnection(conStr) Ada = New System.Data.SqlClient.SqlDataAdapter("select * from...
  14. andyd273

    views, joins and comparing a table against itself

    incase this helps at all, (if not, ignore) here is the view structure: ALTER VIEW dbo.qrySearchFields AS SELECT dbo.tblCustomers.CustomerName, dbo.tblCustomerPhone.PhoneNum AS PhoneNumber, dbo.tblCustomerTypeLineItems.CustomerTypeID AS CustomerTypes...
  15. andyd273

    views, joins and comparing a table against itself

    OK, so I get the alias thing, but will that work in a view? I'm using the view to look up stuff in a VB6 program, so I just have to figure out how to rewrite it so that the program can write the sql statement for me to get what I want. The guy that origionally wrote it had customer type in a...
  16. andyd273

    views, joins and comparing a table against itself

    ...CustomerPhone) and tblCustomerTypeLineItems (CustomerTypeLineItemID, CustomerID, CustomerTypeID) so if I do a select on the view SELECT * FROM qrySearchFields WHERE CustomerTypeID = '33' returns 123,'Freds garage','5555554432',442,123,33 341,'Bills Automotive','5455553562',445,341,33...
  17. andyd273

    Linked Servers Trigger Proglems

    ...like: Create trigger subscription_insert on dbo.tblCustomerSubscriptions for insert as set xact_abort on insert into openquery(webdb, 'select * from tblCustomerSubscriptions') (CustomerSubscriptionID,SubscriptionID,CustomerID,SubscriptionDate,LabelName) select...
  18. andyd273

    Windows Authentication in VB6

    I have a VB6 program that was assigned to me to work on, and the guy that started creating it did a poor job designing how it worked. At the moment it uses a stored sql authentication username and password that is embedded in the VB6 code that is used by everybody, and then attempts to control...
  19. andyd273

    Help with filtering SQL results in the report

    hopefully the record selection formula editor can do what I want, but if there are other ways to do it, then that would be cool too :)
  20. andyd273

    Help with filtering SQL results in the report

    I'm going to look into that record selection, but for this report the counts and stuff arent what I'm looking for. basically I want to export the report into excel so I can then put it through our mailing program. here is a sample of what would be returned: DeVore Motors - Rex DeMoss OR...

Part and Inventory Search

Back
Top