jongas's Q&A profile

• SQL Server New Query button -- always prompts for authentication

  Every time I click the "New Query" button, or drag a file into the editor, the system prompts me for authentication. This time and time again leads to executing commands on the wrong database, and the only workaround is basically to accept the necessity to hit the enter key when prompted for auth, and to always double-check which database you're about to execute your query against. If the user account you are authenticating as has access to multiple databases, then you always have to change the database after creating a new window. I am sure I'm not the only one very frustrated with this tool. Has anyone found a real workaround Chad, thanks for the answer.  However, it doesn't really hel ...Show All

• SQL Server Remote access to sql server

  Hi, I use a VS2005 application with a sql database. All is working well over a local network but I now want remote access to the system via the internet. Is this possible I have a fixed IP address & am wondering if I can just use the ip address as part of the connection string (And if so - how!) Maybe not rambling - but certainly brain dead!!! I've been looking at this article for hours and this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=576436&SiteID=1 I *think* I need to add a "mysettings" class and then use that to change the string, but I just can't grasp how to do it.. Help! ...Show All

• Windows Forms DataGridView Detail Row Saving

  Code snip: Me .BindingSourceDrivers.DataSource = MyDataSet.Tables( "Drivers" ) Me .BindingNavigatorDrivers.BindingSource = Me .BindingSourceDrivers Me .DataGridViewDrivers.DataSource = Me .BindingSourceDrivers MyDataSet.Relations.Add( "DriverToCars" , MyDataSet.Tables( "Drivers" ).Columns( "ID" ), MyDataSet.Tables( "DriverCars" ).Columns( "DriverID" ), True ) Me .DataGridViewDriverCars.DataSource = Me .BindingSourceDrivers Me .DataGridViewDriverCars.DataMember = "DriverToCars" Nevermind, I figured out something that seems to be working for now. If m_oForm.grdAddress.IsCurrentRowDirty() Then 'This unloads the changes into the dataTable, ...Show All

• Visual Basic Count down Timer

  Hi, I am new to VB but want to write a timer that counts down 3 min like an egg timer would, I would like this count down to be visdable. I have been searching for code but am not understanding timer concepts. Any one out there that can help Thanks David A simple timer countdown (180 seconds) Public Class Form1 Dim x As Integer Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Timer1.Interval = 1000 x = 180 Timer1.Start() End Sub Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick x = x - 1 Me.Text = x.ToString If x <= 0 Then Me.Text = "Finished" Timer ...Show All

• SQL Server How to assign a column's value to another column's default

  I got a table. i m using SQL 2005. tblMy -------- col1 varchar(10) NotNull col2 varchar(10) AllowNulls col3 varchar(10) AllowNulls Question: How to assign the col1's value to col3's default value. If user enters a data to col3 , its ok , but if don't SQL will automatically insert the value of col1 to col3. Happy Coding.... View may be solution to another problem, but not mine. But trigger is a good idea, i thought before , but im inexprienced on triggers. I'll try to learn as quick as i can. Thanks for your post. Happy Coding... ...Show All

• .NET Development AppDomain.Load assembly file not found exception ?

  Heya all, I'm currently developing an application that loads a dll that is dynamically compiled every now and then. To avoid restarting my application, I chose to use an appDomain so I can call AppDomain.Unload(appDomain); whenever the DLL is build again. So far I've got the following code: AppDomainSetup ads = new AppDomainSetup (); String fullPath = GetFullFileName(); //returns full filename ads.ApplicationBase = Path .GetDirectoryName( fullPath ); ads.PrivateBinPath = Path .GetDirectoryName( fullPath ); AppDomain ad = AppDomain .CreateDomain( "myName" , null , ads ); ad.Load( AssemblyName .GetAssemblyName( fullPath ) ); ///-> Throws FileNotFoundException! //do some stuff here (reflecti ...Show All

• Connected Services Framework Could not find the CSF-Administration-OU Organizational Unit in Active Directory

  I am trying to install CSF 3.0 on a machine joined to my domain. I choose Complete install, and leave the Optional Top Level OU box unchecked. I've also tried manually creating the CSF-Administration-OU in AD, but I get the same error. Am I supposed to have SSL Certs pre-installed before running CSF install This is from the MSI log: Property(C): SetCertificateList = SESSIONWEBSITECERTIFICATE,IDMWEBSITECERTIFICATE,PMWEBSITECERTIFICATE,PIWEBSITECERTIFICATE,SCWEBSITECERTIFICATE,NPWEBSITECERTIFICATE Property(C): DEBUG3a34 = 34 Property(C): DEBUG1a34 = 34 Property(C): SetSqlComboBoxSet = 1 Property(C): ORGDESC = CSFHOSTINGORGANIZATIONDESC Property(C): ERROR = No SSL Certificates in Certificate Store! Property(C): ERRORTRACE = &nbs ...Show All

• Visual Studio Express Editions variable size matrix

  I'd like to have a two-dimension matrix of double whose dimensions (number of rows and columns) are not pre-defined, but can vary following user's requirements... Is that possible How about Private ary(,) As Double Dim x As Integer = 3, y As Integer = 5 ReDim ary(x, y) Is this what you need ...Show All

• Visual Studio Team System Forum and Bug Reports

  I've seen it mentioned that I should put feature requests and bug reports on connect.microsoft.com to make sure they enter the system. I've also been posting them here in case other users or staff have any workarounds or anything to add. Also maybe it will pique the interest of a project manager or dev that may want to fast track it. :) Is this following the expected use of the forums Sideout wrote: Is this following the expected use of the forums I would certainly think so. The threads and discussions also lead to changes in the development process of DB Pro when the team see the need to do so to meet the customers needs. Nothing is better than real world problems related to the usage ...Show All

• Visual Basic Visual Basic - Passing data from a child to a parent form

  Please reply with Visual Basic solutions. I am clicking on a Panel in a child form (BW3) and creating a label giving me the mouse position on the panel. The mouse down event on the panel(BW3.Panel1) needs to also pass this variable onto the parent form(PARENT1)controls(txtwidth and txtheight) text boxes , which is part of a large data set that is going to be sent to a database. I am very new at OOP and class writing so please be gentle Looking forward to an early reply as this is a small part of a big project Dave If I understand correctly what you are trying to achieve I think the following will do the job. Just paste the whole code into a new project, replacing the Public Class For ...Show All

• Visual Studio Tools for Office F5 -> "File already exists"

  Hi, I'm new with VSTO development and been experiencing this really annoying issue. Everytime I hit F5, it launches the Excel document associated with the project. However once Excel launched, it often (not all the time but quite often) gives me the "File already exists" error message. I then must open the Excel file manually from File -> Open. Everything works then. Strange that it doesn't do this all the time, just occasionally. Any ideas Cheers, Victor Hmm didn't have time to try. But I found a 'workaround'. If I leave my original Excel file open, everytime I hit F5 from the Visual Studio it'll re-open the file but this time telling me the file is opened by another user (me) and if I want to open it as &q ...Show All

• Visual Studio Tools for Office NamedRange Binding

  is it possible to bind a NamedRange spanning over multiple columns to a collection or datatable having several columns or properties. From what I read till now the binding of a namedrange is only to 1 field. NamedRange.Databinding.Add("Value2",datasource,"1column") can anyone help Hi "sam" I believe a NamedRange can be bound only to a single field (column), yes. You can use a ListObject to bind to multiple columns. I'm having difficulty envisioning a scenario where you'd want to bind to multiple columns. But theoretically you should be able to change the binding of a NamedRange to a different column I think that would be your only possibility, outside ...Show All

• Software Development for Windows Vista Writing only selected frames in AVI?

  Greetings, I'm trying to pass to file writer filter only selected frames from a stream. I have written a transform-in-place filter that passes through only those frames that I need, but file writer writes the same frame several times (instead of writing it only once and waiting for the new frame to arrive). How can I invalidate frame once it has been written so that it won't be written again Thank you in advance, Murom I'm using AVI as a container only and write there frames I need for post-processing, trying to avoid any recompression. Is there a way to circumvent the limitation for AVI filters, or is it easier to employ MPEG-4 as a container Thanks very much - that was very helpful. Murom ...Show All

• Visual Studio Express Editions Creating reports from VB

  I'm completely new to Vb2005 and would like to know what reporting tool is best to use with VB and how to integrate the two to create reports that are printable and can be sent to either a word or pdf document Hi, There are currently 2 report creation tools available in VS2005. These are Crystal Reports and RDLC. Here's a FAQ Sheet to learn more about them: http://www.crystalreportsbook.com/SSRSandCR_Conclusion.asp I myself is using Crystal Reports, and yes they have an exporting to PDF, word and Excel. I preferred Crystal Reports over RDLC simply because I really liked the designing environment of Crystal. Its much friendlier to use. cheers, Paul June A. Domag ...Show All

• Visual Studio Express Editions Image Cropping

  Does Visual Basic all image cropping I would like to take a big image and allow in a UI (windows app) for the user to be able to click a certain thing and it would make a crop of a certain area (box) around that area. In a normal case we would have 50-100 cropped images that would come from this one large image. Thanks Here is a link to a sample program that I wrote a few years ago in VB.NET (2002) that should be convertable to VB2005. It does cropping from any location within an image starting from the MouseDown position and ending with the MouseUp position. It draws the dashed-line box too. Maybe it will give you the idea you need for your project. james aka:Trucker http://www.gotdotnet.com/Community/UserSampl ...Show All