Recent content by niall29

Hi All, This one I thought would be easy but I can't get it to work. I am tring to call a stored procedure on DB A which then has to look up values on DB B. Is it possible for a stored procedure to query a different database without giving direct select access to any database. It seems if you...

Hi All, This one I thought would be easy but I can't get it to work. I am tring to call a stored procedure on DB A which then has to look up values on DB B. Is it possible for a stored procedure to query a different database without giving direct select access to any database. It seems if you...

That definitely sounds like a way round it and thank you but do you know how I can make it that the app that does the encrytion automatically runs after install. As anything that needs user input is always counted as a vulnerability

Hi, I had very little to no issues, I opened the old solutions in VS2005 it did most if it found any for me. It also backs up tyour original if you need to go back. Things that I ran into were having to change Configuration. to ConfigurationManager. (I can't remember if that was exactly it but...

Hi all, I hope someone can help, here is a summary of my problem; I have an VB 2005 app that runs once a day which connects to a Class 4 Db. In the app I have an App.config file which has the connectionstring and necessary passwords it needs to run. I have code that encrypts the Appsettings in...

Ok Thanks for your help and I suppose I will try to go the code way Question Do you know how I can call ddl that is in the GridView. I don't see it in my list of controls.

Now thats a problem, I used the new wizards that tie the data to a control without having to type code. I was trying to get away from typing loads of code and I was told that the wizard is alot better than the older wizards

Yes I have a try catch during the whole update part and it walks right threw.

I have walked through on the debugger and it never errors out. It runs through smoothly except when the page reopens it has the error. I have to admit I have not been using ASP.NET long so maybe I am missing something.

I am using the update feature in a gridview in ASP.NET 2005 I am passing parameters to a Stored procedure which seems to work, but when the page is loading up again I get the error Input string was not in a correct format. Description: An unhandled exception occurred during the execution of...

I just noticed that I should have used a table.(I Think) Any guidance would be highly appreciated.......

I am fairly new to ASP.NET (actually pretty new to web development) Any way, what I have is a webpage with a ascx at the top for a header, a treeview going down the left hand side of employees, what I am trying to do is when you pick one the employees in the tree their details will show up in on...

Thanks everyone for your responses especially gmmastros for the code

I am trying to run a query sorted by date on a table where the date column was set up Varchar 8 but my problem is someone put some dates in the UK way (dd/mm/yyyy) while the rest of the dates are US (mm/dd/yyyy) so now when I try to sort by date it can't. Does anyone know how I could built a...

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load btnSearch.Attributes.Add("onclick", "window.open('Search.aspx', 'null,width=130, height=160, channelmode=no, url=no, location=no, titlebar=0, status=0, directories=0...