PsychicDave's Q&A profile

• SQL Server Advice on a database Replication

  Hi, I.m trying to find the best practice for my solution. This is the situation. My application has two databases and 2 client interface. One with a windows forms having a database (sql server 2000) running in an office (on a static IP but on a slow connection). the second one is an web application running on the net with an online database. Both these databases have to have same information. Users can add records to both databases independently but these databases should be synchronize at a point. I hope the situation is cleare. Is there a standard way of doing this. If some one knows good article of how this can be done pls fo ...Show All

• Visual Basic System.DllNotFound Exception

  I'm migrating from VB 6.0 to VB.NET 2003. There is a particular file abc.dll that I'm not able to add reference to, though its a dll file. When I try to reference it, the error is 'This is a not a valid assembly or COM component. Only assemblies with extension 'dll' and COM components can be referenced. Please make sure the file is accesible, and that it is a valid assembly or COM component' How can I reference this file If this is not being seen as a COM component you likely need to do a P/Invoke against it. In your old VB6 project, did you have a few ‘define function’ statements that reference ...Show All

• SQL Server OLEDB Datasources and parameters

  I have discovered some shortcomings in the way inline table valued function parameters are treated in the OLEDB datasource. You can select the user designed function ine the Generic Query Builder and test it with the required parameters. However when you attempt to set up the parameters for the result ing SQL Command Text you get and error message to the effect that the parameters cannot be retrieved from the datasource. Once again this is disappointing because Report Services seems to deal with the parameters perfectly well. Dick Campbell I've never had any problems using parameters in OLEDB Sources. H ...Show All

• Visual Studio Express Editions an unhandle excpetion

  Hi all , I have a problem , where I built an application (simple one which uses 2 forms and one data grid) every thing is OK on My computer , however when applying the app. to another system which has .Net framwork , I get the Msg "an unhandle excpetion", And I dont know why Any ideas Hi, Can you give us more details about your error If you have found answer for your post then please mark reply as answered by clicking on "Mark as Answer", so that forum member's will know that your post is being answered. You can always re-open the post by clicking on "Unmark as Answer". Th ...Show All

• Visual Studio Express Editions Button text different when running to when in IDE?

  Visual c# Express - a project developed in beta2 Text in buttons in the IDE is fine but when running the text is not quite right - it's as if the kerning has changed. So a button that says 'Test Comms' in the IDE says 'Test Comm' when running.  Looks like every button on the form is affected. Font is 8.25 pt Microsoft sans serif. Labels are ok as are datagridviewcolumn headings - it is just buttons that seem to be affected.  Used to be OK in beta 2 Any ideas Thanks Steve Is it a matter of the button size chopping of the last letter   I know many times the buttons in the IDE do not look the ...Show All

• SQL Server Get Sql Err Message 15422 when activating application role.

  Running VB 2005 Express Edition and Sql Server 2005 Express Edition (SQLX). Developing a desktop application which calls a local instance of ".\sqlexpress". This app needs to set data base options and add/del various table columns. When activating the application role, I get the following message: HariCari SQL Error/s 15422 - Application roles can only be activated at the ad hoc level. Anyone know what this message means I have searched SQL Server Books On-Line and been unable to find a list of Sql err numbers. Either I have missed the obvious or Books On-Line has missed the obvious. Thanks Gary Y ...Show All

• Visual C# The IDE often automatically changes the file subtype from "Form" to "Code" in the .csproj file

  The IDE often automatically changes the file subtype from "Form" to "Code" in the .csproj file, which renders the forms unviewable in design view until that change is undone.  Is there any way to prevent the IDE from doing this automatically Thanks, Wilfred look at this url http://lab.msdn.microsoft.com/ProductFeedback/viewFeedback.aspx FeedbackId=f39a46fc-5dac-4a55-81ef-e1d262fe0040 ...Show All

• SQL Server Committing a Stored Procedure

  hi there, I am connecting to a sql server express 2005 database which is located on another developers machine in the company. he has given me the username and password and i can read and write to this db using vs2005 no problems. i can also added new tables and everything through the management studio, but when i add stored procedures, it does not seem to commit to the database, when i click save it asks for a local destination but i want it to save onto the sql server. i can add stored procedures through vs 2005 no problems! this does not make sense Hi, yes it sure does. You don’t have to save the procs you have to execute ...Show All

• Software Development for Windows Vista Properties of custom activities

  Hi, My custom activity contains multiple properties and instead of showing them one by one in the property grid, i want to display a form to collect all the properties. So, when i drag and drop my custom activity, and when i select my custom property on the propertygrid, i should get a windows form. The values that i enter in this form should be available to my custom activity. Is this possible If yes, is there a sample that i can refer to Thanks Anandan. Look at the documentation on UITypeEditor in Visual Studio; you'll find plenty of samples. This is a common application of attributes foun ...Show All

• .NET Development Generic Types

  would anyone know how to implement a single class for different types. This's my class Class CClass       Public Sub New(TheTypeShouldBe  AS  What  )         ' So That i can define a generict List of  'ThisShouldBeTheType'         Dim myList as NewList(Of TheTypeShouldBe)       End Sub         End Class Many Thanks Hi, and overloaded functions DO NOT Work Please would anyone know how to let the ...Show All

• Visual Studio Express Editions Frequently asked questions

  Q: I do not have internet on the computer I want to install to, can I use Visual Studio Express Editions   Yes, download an image that you can burn to a CD and install on any computer without internet. Manual installation instructions here Q: Do I have to uninstall any previous versions of SQL Server 2005, Visual Studio 2005, and the .NET Framework 2.0   Only if they were community technology previews (CTP) or betas. If it is the released version you do not have to uninstall. More information here Q: Can I install multiple Express Editions on the same computer Yes. Q: Can I install Express Editions with Visual Studio 6. ...Show All

• Visual Studio Crystal Report Linked Image In Vb.Net

  Hi ppl, I have an application in vb.net using crystal report viewer i have used an bmp image(linked) from a path but when i change image the image does not reflect in the loaded application report i restarted the appn also Intrfestingly i did this in one of the samples of crystal report examples and it works fine there Is there some extra code or function i have to add Pls advice ppl! Mazen Nahdi I hope this helps you out I had the same problem when working with barcodes. I found a few things on the web and then took what I learned to create this below. http://www.ipdg3.com/sourcecoderesults.php optio ...Show All

• Visual Studio Reflecting over source code from macro

  Hi, I need to do macro which will check method arguments and will say for every argument whether it is constant (e.g. '5'), variable constant (Const A As Integer=5 'A is variable constant), variable, delegate type. E.g. : Const Constant As Integer = 5 Dim MyObject As Object Dim MyDelegate As Delegate = Create.Delegate(...) this.MyMethod(Constant, 10, MyObject, MyDelegate) and when I will run macro, macro will say : 1 argument of MyMethod is variable constant of type : integer 2 argument of MyMethod is constant 3 argument of MyMethod is variable of type : object 4 argument of MyMethod is variable of type : delegate How can I discover this inf ...Show All

• .NET Development Problem with Web Services and Updating datagrid on windows form.

  I have a simple web service that returns a dataset with one table in it. I've managed to show the data on a datagrid on a form with an update button. however, I would like the data to get updated every 5 min. I've setup a timer with Elapsed trigger to update the gride by calling the web service and refresh the grid. problem: my data grid does not even show up on the form when I use the timer. code: very simple see below. Private Timer1 As New System.Timers.Timer(10000) Dim sales As New org.mystore.www.BookstoreSales Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As   System.EventArgs) Handles MyBase .Load &n ...Show All

• Windows Forms procedure descriptions

  I am guessing this is simple but for the life of me I can't find any documentation or examples on how to do this. I am trying to add secriptions to my procedures and there arguments so that during design time they pop up as you are using the function. Just like when you use standard procedures from MS. I am coding in VB.NET 1.1  ...Show All