Recent content by johnaregan

ok thanks ca8msm

Hi I am trying to insert into Northwind using bound paramters, the command returns the SQL Server error: Line 1: Incorrect syntax near '?'. Can anybody see what it is that I am doing wrong? I have seen similar code on the web. ... comm.CommandType = CommandType.Text; comm.CommandText =...

This relates to a problem I came across when using the tab key to move the focus around a page of text boxes. All textboxes have AutoPostBack set to true and the page also has SmartNavigation switched on. When you change a value in a text box and tab out, the page is posted back as expected. A...

Hi I do not know if this is at all possible but I would like to be able to copy rows from say an excel spreadsheet and insert them into a datagrid. The datagrid will then be submitted to bulk update a SQL Server table. Any pointers in the right direction would be greatly appreciated John

Zac thanks for link, this seems be the way to go John

zcolton, thanks for your reply I take it that LDAP only applies to Active Directory? ie. you cannot use it on Exchange Server to get at emails, Contacts etc. What I have is about 20 end users who keep their contact (other company's addresses, emails, telephone numbers) in their own personal...

zcolton We are using Windows 2000 server and Exchange 2000. John

Hi Can you get to the Contacts folder in end users mailboxes (stored in Exchange Server, not local PC's) using LDAP. If so can anyone give me any pointers as to how to do this. thanks in advance John

Hi Does anyone know how I can go through each Contacts folder in every Mailbox on the Exchange Server and export the contacts to one delimited file (I have administrator access). All of our mailboxes are stored on the Exchange server (ie. we do not use .pst files). I have read about command...

I've tried doing this but it does not work, it still opens the page in the same window as the excel document. John

Hi I am sending the output of an asp page to Excel using Response.ContentType = "application/vnd.ms-excel" so that the web page loads and displays as Excel in a browser. I have hyperlinks on the page which I want to use to open a new separate web browser. At the moment the link loads the next...

Hi Do you need to have the .NET framework installed on the PC that you are deploying to? I know that apps are compiled to byte code, but it seems silly if you also need to install .NET on all machines that you may be deploying to; if you compiled a program in C (not through .NET) then you dont...

Hi I have a varchar column holding numeric and text data. How would I be able to just extract the numeric data from this column? Thanks in advance John

saved me some work and thinking, have another star

pete the xsl in the message worked perfectly and it was the solution that I wanted. I was just refering to the search in tek-tips not returning anything, once again thanks for the link