Search results for query: *

Hello, I have a logon script that collects lots of data about the workstation and the user being logged on. This script dumps the data into a SQL 2005 Express database. I need to get Sharepoint set up to display the data from this database using the query I created. How can I set up a custom...

Hello, I have a Firebox X500 and 4 VPN clients configured. 2 VPN clients are not on a domain... just standalone workstations. They are able to connect and browse anything on the trusted network. The 2 I'm having problems with are members of the domain in the trusted network. When a user...

I have an ASP.NET page that I'm trying to use to change the password of the local Administrator account on remote machines. When I run this on my workstation it works, but when I post it to the intranet server and run it I get this error: System.Exception: Cannot create ActiveX component. at...

I'm trying to run a script using WMI that will list the Local User Accounts on a machine that I specify. Microsoft provided the following example but said it the LocalAccount property doesn't work on Windows 2000. If the query is "where LocalAccount=True" then how do I query a Win2K machine...

I have a repeater that has many rows in it and the user can modify the data using the controls in the repeater. The number of rows will differ for each user. For example, there could be 100 rows in the repeater and the user can click the Yes or No radiobutton to answer the question for that row...

Thanks, here's the code: UpdateDB(byval ID) Dim ConnectionString As String = Configur... Dim CommandText As String = "update tbl1 set bit_col='1' where id_col='" & ID & "'" Dim myConnection As New SqlConnection(ConnectionString) Dim myCommand As New...

I have a datagrid with a button in a column. Looks like this: ID | text | bit value | button When the button is clicked, I'd like to change the bit value for that record. I'm having a lot of trouble passing the number in the ID column to the event the button calls in the OnClick. I tried...

Thank you much, it worked perfect!

I'm trying to set an SQL trigger so that when I delete a record from one table it deletes the records in another table with the same ID as the record just deleted. I thought this would work but it doesn't: DELETE FROM Table2 WHERE ID=@@IDENTITY Can anyone help? Thanks!

I have an Identity (AutoNumber) column in SQL that I need to use in an UPDATE statement, but I can't figure out how to use it combined with other text. This has been simplified. Table1(ID, Col1) Code: INSERT INTO Table1 (Col1) Values ('temp'); UPDATE Table1 Set...

I have a select statement that narrows the records down to one (ex. A UserID). Something that I want out of that row is to set the variable strFirstName to the value in the "FirstName" column in my record. How do I do that? I am using Access XP and ASP.NET. I have also posted on...

I have a select statement that narrows the records down to one (ex. A UserID). Something that I want out of that row is to set the variable strFirstName to the value in the "FirstName" column in my record. How do I do that?

PS. I'm using ASP.NET

I can't seem to get a recordset set up. Can I use a DataReader? See the code marked with ">>>>>>". I get an OutOfRangeException error with this. Thanks for your help. Sub LoginBtn_Click(Sender As Object, E As EventArgs) Dim conn as OleDbConnection Dim cmd as...

I have a select statement that narrows the records down to one (ex. A UserID). Something that I want out of that row is to set the variable strFirstName to the value in the "FirstName" column in my record. How do I do that?

I have a problem with my SQL Insert statement which is the single quotes. INSERT INTO DOCS VALUES ('<a href=http://www.myserver.com/docs/&quot; & filename2 & &quot; target=new_window>&quot; & txtTitle.Text & &quot;</a>','next value',....) The problem is that if my filename2 is something like...