Search results for query: *

Hi all. I hope you can help me out here. I want to be able to create a new stored procedure on several databases that are remote. Click once is set up with no problems. I just want to create a new SP on the default instance on SQLExpress on the databases. I have been trying smo without much...

Hi all. I hope you will be able to help me out. I have a system running off a SQLExpress database on a clickonce type application. As well as updating the application I want to be able to check a version number on the DB and then run a .sql script for updating Stored Procedures or anything...

Hi all. I have a problem finding strings that do not exist in a column in a database. I am going to use linq but its more the 'way' of doing I am concerned with. I have strings like; MEAL GPST EXLEG EXLG ...etc I need to find records that does not have this list of strings in, so for example...

Hi all, I hope you can help. I have an object called tblTask (From linq query to the object) which has fields such as T3_1, T3_2, T3_3, T3_4. These are questions that need to be filled in by the user. I want to run a dynamic query to find out if any information is in that field or not. The...

HI all. I am a little stuck on a peocedure. I'm trying to move files once they have been imported into SQL Server. The first file moves correctly, then I get the above error. I know it's something to do with dispose or close but can't get my head around it. Here is the code so far, the main part...

Hi All, I hope someone can help me. I have some code and just need the calling AddressOf to be dynamic If view IsNot Nothing Then Dim filterer = New FiltersAdminvb(text.SelectedItem.ToString) view.Filter = New Predicate(Of Object)(AddressOf filterer.FilterSite)...

Hi, I'm just starting to look at Custom Controls after watching a MS video online. Video Training - WindowsClient.net I wondered if it's possible to get the name of the control that calls the OnEnter event that I am running. Public Class MyComboBoxAuto Inherits System.Windows.Forms.ComboBox...

Slightly confused on what is the best format of coding between Methods and properties. Here is some code, a shared property that I use instead of using a method with one argument. Public Shared WriteOnly Property GetComboList() As ComboBox Set(ByVal _ComboBox As ComboBox)...

Hi, I'm looking to change the connection string (To Sql Server) on the fly based on the computer name. Just a normal IF ELSE based on that. I want to leave the connection string settings in app.config if possible. I have looked everywhere to see if I can do this!! I have tried adding a new...