Search results for query: *

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

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?

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 =...

Yeah, that describes it good.

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?

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

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

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

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

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

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

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.

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

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

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

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

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

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

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 :)

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