StefanWimmer's Q&A profile

• Visual Basic Databases and Textboxes

  Part A How do I link textboxes to individual database records when the database has say fifty rows and fifty columns. The idea being to display and maintain a database with textboxes on a form that stand independent of each other that point to a specific spot in the database. Part B Once this is possible then .. To be able to manage this data based on years meaning... I would like to have this basic setup but I am able to have the database represent a set of data for a particular year and I would be able to choose to display data based on the year. Please, if anyone knows .. respond asap.. Thanks Shihan Hi, when i come across this page ,i am also in need of similar sort of th ...Show All

• SQL Server Distribution Calculation

  Hi Can someone please tell me how I can take a set of sales orders and generate a table or set of data that show the percentage of sales per product which are in different sales ranges eg Socks - Beige 50% Orders are above $100 20% Orders are above $90 and less than 100 30% Orders are above $60 and less than 90 Many thanks for your time TV Thankyou very much Louis If I want this distribution per store do i just add the following to it select StoreID, count(*), sum(case when value >= 100 then 1.0 else 0 end) / count(*) * 100 as [100Up], sum(case when value < 100 and value >= 90 then 1.0 else 0 end) / count(*) * 100 ...Show All

• Visual Basic I need help on opening a file on the computer

  I want to click a button and it will open a program in the Start Menu then it opens All Programs and then it will open a file in the all programs folder that worked great but what if i wanted to open a finished and published visual basic application, when i right click it there is no target path also i do not know it's value because it is not a .exe ...Show All

• Windows Forms Invalid cross-thread operations and CheckForIllegalCrossThreadCalls=false

  I am developing an application in C# .NET2 and I'm finding some issues with cross-thread operations on GUI controls. The controls are a mix of Panel, TextBox and Label and these are all being accessed by threads other than the thread that created the control. Of course, when debugging with Visual Studio 2005 these operations are highlighted by the appearance of InvalidOperationException. I could just switch off these exceptions with CheckForIllegalCrossThreadCalls=false, but that doesn't feel like the right thing to do. Could someone please tell me why cross-thread access of GUI controls can be such a problem Cathy. Hi Cathy! The Control class (and its inherited classes like TextBox or ...Show All

• .NET Development Does anybody know where to find WebDav for c# examples or tutorials?

  The title pretty much explains it. I want to know how to program in WebDav but don't know much about it at all. If anybody knows where to find some documentation, examples, or tutorials that would be great or you can just post what you have learned here that's fine too. hope these links serve your purpose.. http://www.webdav.org/ http://search.microsoft.com/results.aspx mkt=en-US&setlang=en-US&q=WebDAV+C%23 ...Show All

• SQL Server Distributor cannot connect to subscriber

  I am setting up my 2005 Replication system... publisher = 2005 sp1 Subscriber = 2005 sp1 I created a publication for a single table. Then I created the subscription to another 2005 server. Had to add it as a subscriber in the wizard. Told it to do the snapshot right away. Everything seems fine right up to the point where it tries to connect to the subscriber... I get a cannot connect error. I have tried all kinds of security context and accounts for the sql agent to run under but nothing seems to work. I cannot even get a linked server to work. I have the subscriber setup to accept remote connections. I am not sure where to look at next... I never had this issue in 2000. Can you try the fo ...Show All

• SQL Server How to add columns at run-time?

  I have a table: column1 column2 column3 column4 data data data data data data data data I want to create more columns at runtime, what should I do desired output: column1 column2 column7 column3 column4 column5 column6 data data data data data data data data data data data data data data The number of columns to be added is random. Please help. Adam Tappis - IMGroup wrote: You could look into using nested tables. You'd have to predefine the number of columns at each level. I haven't tried it myself but I think it fits your requirements. I get an error when I do this. The data comes from 2-3 datatables. And I ca ...Show All

• Visual Studio 2008 (Pre-release) Question on WCFHelpSep15 MembershipAndRoleProvider sample

  Hi, just started on wcf and trying to run the sample as posted in title.  Problem is I can't seem to properly install the x509 certificate required for this sample to work.  I ran the setup.bat included and used the serviceCertificate but got the following error when running the client: Inner Exception: The X.509 certificate CN=localhost chain building failed.  The certificate that was used has a trust chain that cannot be verified.  Replace the certificate or chagne the certificateValidationMode.  A certificate chain processed, but terminated in a root certificate which is not trusted by the trust provider. I am running on win server 2003, client server on same machine, server on iis.  How can I correct ...Show All

• SQL Server Error - Cannot open the datafile

  Hi there, I have written a program that loads a package ( SomePackage.dtsx ) from the physical drive and executes that. The package does nothing but imports data from a csv file to the Sql server 2005 . But I can see that the package is failing continuously. I meant the package.Execute() method is returning a DTSExecResult . Failure . I investigated the Package.Errors property that contains the error collection and found that there are two DTSError objects into the collection. The first one’s description says that Cannot open the datafile "D:\SOME.csv". And the later one’s is component "SOURCE FLAT FILE COMPONENT" (1) failed the pre-execute phase and returned error cod ...Show All

• Visual Studio Life without source safe?

  I have used source safe in the past and it was very helpful. I don't have a copy of it in the place i work right now. It's going to be a while before we get that in. I just want to know that if 2 developers work on the same project (saved at a shared location) and ALWAYS work in different forms. Will this cause any problems Thanks for your time!! VSS 2005 uses the same diff/merge engine as TFS...and it also supports 3rd-party merge tools using the exact same syntax as seen here: http://blogs.msdn.com/jmanning/articles/535573.aspx ...Show All

• Visual Studio Team System Problems with Source Control

  Hi guys, we try to use SC and we are no real experienced team. Hopefully somebody can help us with following problem. Everybody uses SC in our dev-team. But from time to time we get the following message from SC when we download latest version: The solution <My Solution> has been modified outside the environment Press Reload to load the updated Solution from disk Press Ignore to ignore the external changes The changes will be used the next time you open the solution. Another Problem: SC seems to have problems to recognize that there are new versions avail. We right click on a folder in SC and select get latest version. We get the "All files are up to date" message. But when I check the files in the SC-direct ...Show All

• Visual Studio 2008 (Pre-release) UserControl cannot be created using Assembly.CreateInstance

  If you create a UserControl in a CustomControlLibrary and an application loads the assembly that owns the UserControl using Assembly.Load the UserControl cannot be instantiated Note that I just used VS to create the UserControl, did not add or remove anything..... // both of these will fail ConstructorInfo construct = Type.GetConstructor( new Type [0]); Object = construct.Invoke( new object [0]); Object = Type.Assembly.CreateInstance(Type.FullName); The Error: InnerException = {"The component 'CustomControlLibrary1.UserControl1' does not have a resource identified by the URI '/CustomControlLibrary1;component/usercontrol1.xaml'."} How does one work around this Note that the assembly ...Show All

• Visual Basic java in webbrowser

  hello, is there any way to enable runnin java script in my browser - and if it is how can i handle them thnx; I'm unable to reproduce this problem. I've created a site, which has javascript (menus) and it works fine with the webbrowser control in .NET 2.0   Are you sure the website you are browsing does not have a problem with their javascript   I am using IE7 Beta 3 (and tried on IE 6) and it works fine for me.   can you give us the website you are using where you are stating that the JS does not work Any errors ...Show All

• Visual C++ How can I use a Timer without having the .NET framework?

  Hi, I have an app that requires a certain function to be called every X milisseconds. I have searched for timers on MSDN, but the ones I've found are all based on the .NET framework. Is there any other way I would rather use only native Windows API. Thanks in advance, Pedro d'Aquino ...Show All

• Visual Studio Team System Recorded script fails in the Login page and then passes in the Next dependent requests while replaying an web test

  when i try to rerun my recorded script this is what happens : suppose i have recorded a web page which has a 'Login page', 'home page',' services page' and a' logout' first when i record the script my login is working and i will be able to go to the login page - home page - services page - logout .. while i replay the same i will not be able to login to the login page coz i get a error "user name or password is wrong" ...but the next page ( services page ) i script will pass on the when i goes through the other dependent URL i.e Services page and logout page also when i try to paste the URl direclty in Internet Explorer (Services page or the home page or logout page) i go to the Login screen ...Show All