mikael sandberg's Q&A profile

• SQL Server Custom assembly : Retrieving data from from configuration file.

  Hi all, my problem is that: I do read informations (e.g. connectionString) from configuration file by one custom assembly. My environment is RS2005, VS.NET 2005 Prof.Edition, WIN2003 Server SP1, .NET Framework 2.0.50727 The scenario is that: A text box into my report require a function contained into MyCustom.dll. This code do read information from MyCustom.dll.config. This file contains: < xml version="1.0" encoding="utf-8" > <configuration> <connectionStrings> <add name="IS2009cfg" connectionString="data source=servername\instancename;initial catalog=dbname;user id=xx;passwor ...Show All

• Windows Forms Visual Studio .NET framework version

  I have VS.NET and have just installed framework version 1.1.  When I create a new project now, it is still creating the project with framework version 1.0.  In the Help/About dialog of VS it is still reporting framework version 1.0.  How do I update VS to use framework 1.1. Also, how do I update an existing project to framework 1.1  - t ...Show All

• Visual Studio Team System SchemaCompare and DataCompare features

  will SchemaCompare and DataCompare features work same as 3rd parties tools (like red gate, ApexSQL, DB Ghost... products) or will be different In other terms this product will be a complementary or a substitute tool Thank you All schema compare tools are in essence the same; they take one schema of a database and compare it against another. So in that aspect we are the same. However the beauty with our (VSTS DB Pro Schema Compare) is that we have a fully integrated comparison tool with the rest of the VSTS DB Pro feature set to enable a well round change management scenario. Our product allows, for example,  ...Show All

• SQL Server backup schedule

  SQL server 2005 is installed but can not schedule a backup job. In the maintenance plan when selecting a new maintenance plan or maintenance plan wizard an error is produced which is: 'Agent XPs' component is turned off as part of the security configuration for this server. I can see that the SQL Server Agent (Agent XPs is disabled). When trying to start this by right clicking on it in object explorer, the error message is 'unable to start service SQLAgent$SQL2005 on server serverName'. Service Logon failure How can I scedule a back up job on this server Any thoughts please "Service Logon Failure& ...Show All

• Visual C# ReportViewer Caching?

  I've created a multiview with two views. The first view has two date parameter fields and a submit button. When the dates are populated and the button pressed, the ObjectDatasource gets the data from a stored procedure and populates the reportviewer in the second view. After this first execution, the report keeps displaying the same data whatever dates I put in as parameters. The code to get the data from the object data source is not being executed after the first time. And I ran Profiler..the stored procedure isn't being executed. I have EnableCaching = False on the ObjectDataSource. I would like the report to be populated with ...Show All

• SQL Server Best Practice for storing Blog text

    Hi.. I am working on creating a blog for my site(not yet ready). Here's the idea -- I will have an 'Add a blog' page where it has a textarea and a submit button. I will write the blog in this textarea and hit submit. It will be added to the database and I will retrieve it in the actual blog page and bind it to a datalist.  The blogtext even has the <br><font> tags etc... but then i'll hv to reframe the keywords with [keyword] I guess.. Is this the correct practice Is storing blogtext in a SQL db a good idea.. Is there a better way of doing the same Thanks.   Su ...Show All

• Software Development for Windows Vista Workflow Designer

  I have a question about the workflow designer is there's anyway to embded this designer into asp.net pages if yes please tell me how I have some examples you can download from my blog - http://www.masteringbiztalk.com/blogs/jon/PermaLink,guid,a423e010-647b-4a32-8dfe-071bf6f43705.aspx is one where I use it for workflow monitoring. Here is one where you can also see an example of hosting it in a web browser as a control - http://www.masteringbiztalk.com/blogs/jon/PermaLink,guid,28601754-c305-4597-a0a6-48f32be1eddb.aspx ...Show All

• Visual Basic Referencing an Access MDB

  I am trying to get data from an Access 2000 database (mdb file).  I have a table called "Settings" with a single row: Index = 1, and Version = some number (like 0.24 or 0.31). I want to assign the Version number from this table to a variable.  SQL would look something like:  SELECT Version FROM Settings WHERE index=1; Does anyone know how to do that Thanks in advance! Nick Thanks DMan!  A little fiddling around, and I think I have it working! Nick ...Show All

• Visual C# byte question

  ok i understnad that in a byte type cant be stored a value between 1 and 255 or more i dont really know exactly.. but a byte should bet stored as 1001011100100111100 or thats the machine code You're showing a binary number which is far too big to hold a byte. The representation of a number is totally different to what it contains, in that you can represent the same number many ways, and the value is the same. Why are you asking this ...Show All

• Windows Forms Datagrid.Select ?

  Ok...I tried to do this....:     Private Sub DataGrid1_MouseDown(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles DataGrid1.MouseDown             Me.DataGrid1.Select(1)     End Sub but the row dose not get selected ....is it because i have a datagridstyle Thanks, Trey Hi, Try with...........  Private Sub dgData_CurrentCellChanged( ...Show All

• Visual C# NullReferenceException when running DLLImported function

  I have a vb.net chunk of code that works fine when I call the wrapper function that looks like this: <DllImport(".\analysis.dll", EntryPoint:="levels_analysis", CharSet:=CharSet. Ansi )> _     Private Shared Function levels_analysis( _          <MarshalAs(UnmanagedType.VBByRefStr)> ByRef in_string As String , _         <MarshalAs(UnmanagedType.I1)> ByVal in_string_indicator As Char , _         <MarshalAs(UnmanagedType.I4)> ByVal in_string_format As Integer , _    ...Show All

• Visual Basic Exception handling doesn't catch errors

  I seem to be missing a fundamental point regarding exception handling. My understanding is that when an error occurs, it can be caught by Catch without abnormally terminating the program. Mine will always abnormally terminate when an error occurs. An example is below. When the connection fails to open, the application breaks instead of executing the Catch block. Why Try cnSQL.Open() xMainMenu.ShowDialog() Me .Close() cnSQL.Close() Catch exc As Exception MessageBox.Show("Error Connecting to Database: " & exc.Message) intLoginAttempts += 1 MsgBox("Login Failed, " & maxLoginAttempts - int ...Show All

• Software Development for Windows Vista Lab 10 Problem: Activity Condition cannot be set

  I dropped an IfElseBranch on the designer, then in the property grid, I select condition to be RuleCOnditionReference. In the expanded properties of the condition, we're supposed to set the condition name and expression. But the sample gives an error when trying click the ... next to 'ConditionName' property: "Value cannot be null. Paramater name: activity." Anyone knows why this happend and how to fix it Vihang, please, you are one of the most knowledgable experts on WWF on this board. Thanks, Alan I managed to patch the code in the Lab10 exercise to get around the problem that the origin ...Show All

• Windows Forms Closing Application

  Hello Everyone and thanks for your help in advance. I have written a Windows application that is triggered by Windows Scheduler each evening. Basically, the program starts a thread, parses some text files, and then loads data to a SQL Server database. However, since Windows scheduler needs to run it each evening, I need to the application to close at the end of the thread. However, I am not exactly sure how to accomplish this and determine if everything has completed. Any help on this topic would be greatly appreciated. Thanks. define a integer variable =0 as a flag, once the thread start, set the fla ...Show All

• .NET Development help !!!! my database returs always old value's

  hello , my name is jonathan maes , i am a student , for a work i make a invetary program in C# express edition , i work with - Acces database - databindings now what's my problem , well when i delete a record from my database en i restart my program , and i visualise the values he shows the value what i trough away , can somebody help me my excusses for my bad english you can mail me to maes.jonathan@gmail.com maes_jonathan@hotmail.com thanks all to you it works , you all are the best i buy you all a drink when you are once in belgium ...Show All