TheVisual's Q&A profile

• Windows Forms I really don’t know when it’s good practice to create a component class

  Another question pls, if we wanna create sql connection string, should we put it in the application scope (config file or application var) or should we create a component module(my sql connection string will be the same for many applications) I just don”t understand the component and class component part of .Net Thank you For config files, I m more used to asp.net web.config. Is the configuration file you mentioned similar to the asp.net one or does work differently for windows forms applications. I appreciate your explainations. ...Show All

• SQL Server Agent failures and custom alerting

  Hi I need to have a reliable alerting system for my merge replications I have setup on my MSSQL 2005 server. The problem is that the build-in alert system the 'agent failure' alert only triggers when 'all databases' for that specific alert is selected. There is no failure alert triggered when I select a database and force a failure. The 'agent succes' alert does never get triggered at all. I need an reliable succes and failure alert per database because I need to do specific actions per database. Can someone help me out here I'm thinking of building my own alerting system if the help here is insufficient. In that case I need to know in what tables to look. Maybe someone can give me some pointers Thanks anyway, Edward ...Show All

• Windows Forms String to Formula?

  I have a formula saved as a string, e.g "180/2+15" How can I process this formula to find the result (105) I would use the Microsoft Script Control to perform the calculations. Here is an example . ...Show All

• Windows Forms TableAdapter.Fill does not get new data inserted through ExecuteNonQuery

  I have a VB.NET app that has a Access backend and does the following sequence. Connection.open .......Connection is oledbconnection 1. Delete a bunch of rows that meet a certain criteria using ExecuteNonQuery 2. Insert a bunch of rows that meet a certain criteria using ExecuteNonQuery 3. Get the rows using a TableAdapter.Fill in a datatable. These are the rows that were inserted above. The Fill somehow DOES NOT GET ANY DATA . I did a couple of tricks that solve the problem. 1. Put a sleep(1000) in between steps 2 and 3. 2. Do a connection.close after step 2. However i do not want to close the connection. I have an open connection that i want to keep open during the entire application usage. Anyone know whats going on I checked that the Ex ...Show All

• Windows Live Developer Forums Windows Live error: 81000306

  Windows Live won't connect and gives me error: 81000306. I'm on a wireless HP Pavillion laptop, and don't have Norton or other security on here. I need a step by step on how to fix, because I'm not a techie. Can someone help Thanks. Ambrish Moving the thread doesn't exactly help us out. Thanks, tho! ...Show All

• SQL Server Code Snippets

  I am looking for a sample code to write a tool or a 3rd party tool that will enable me to get the same functionality as visual studio 2005 code snippets in SSMS. Paul I was able to use the templates, its just that I was hoping for similar style of code snippets that Visual Studio has, where I could right click and have some of common tsql scripts available while using a query window. But for now the templates look better than nothing. I am not sure where to put in a suggestions, but that would be my first to have code snippets like visual studio 2005 uses in ssms. Jurgen thanks for sending the like, but I am looking for more custom snippet storage not neccessarily code generation tools. But Thank you for the suggestion. Thanks ...Show All

• Visual C# Calendar

  Hey I'm trying to make a Calendar. I want to make my own DayOfWeek enum with danish weekdays and afterwards i want to use it with this call CultureInfo .CurrentUICulture.DateTimeFormat.GetDayName which take a System.DayOfWeek argument. I have maked my own public enum DayOfWeek { Mandag, Tirsdag, Onsdag, Torsdag, Fredag, Lordag, Sondag } How can I get this to work together. I'm so rry, but I still fail to understand your problem. I'm from Uruguay, and if I was to make a calendar, CultureInfo.CurrentUICulture.DateTimeFormat.GetDayName(DayOfWeek.Friday) would return "Viernes"... and that's pretty much what I would want. Can you help me understand what th ...Show All

• SQL Server crystal report deployment problem through web application

  we have been trying in vain to solve this problem for ages, hope someone can help. we have a vb.net 2003 asp app and crystal XI on our dev pc. when we deployed the app onto a web server, the reports just loaded as some html text. we got round it initially by installing the crystal module of visual studio on the web server, but now we have to deploy to a corporate server and this is not an option. we have followed all the instructions on the business objects website and copied the relevant crystal dlls into the bin folder of the dev environment before compilation but nothing seems to work. someone else must have had this problem Zhiwei ...Show All

• SQL Server Is this possible without using cursors?

  Hi! I have 2 tables: Person and Address Person (   PersonID int PK ) Adress (   AddresID int PK,   PersonID int FK,   Default  -- 1 if address is default for person ) so when I join those table it yelds (for example): p1  a1  1 p1  a2  0 p1  a3  0 p2  a4  1 p3  a5  0 p3  a6  0 Person may: - have one default addres and some non-default; - haven't default address; - have only default adres So proper result is: p1  a1          p1  a1 p2  a4    OR    p2  a4 p3  a5          p3  a6 I ...Show All

• Smart Device Development information regarding mobile start status

  hi all, I want to track the boot up of the mobile, i.e. after i switched off the mobile as soon as i start again, i want my appln to run. any help in achieving this i would very greatful. Thanx in advance thanx, i m trying to do the same. well i m using C#. If i place the call in the Main() function then also it should run right In my case wht i have done is: created the console appln that will create the database and i want this to be run continously. if any changes done in the filesystem i trace it and that details go into the database. but i m able to do this..... any help. ...Show All

• Visual Studio 2008 (Pre-release) creating complex lookless controls

  Hey, What would be the best practice for collecting events from the template controls for a lookless custom control. Say I have 3 text areas on the custom control whose text is bound to some properties. That part is easy enough to do, but say I want to know if any of these areas have lost focus, and which one lost the focus Since these controls that are holding the text are defined in the template I don't have an easy way of discriminating between them. I can handle previewlostfocus or whichever, but to determine which was the control that lost fous means to me I'm left with the rather unsatisfactory solution of relying that they have some identifier in their control name, or something of that nature. Is there any way of rerouting an even ...Show All

• Visual Studio 2008 (Pre-release) xbap database application

  Hello, does xbap allowed us to make database management applications where database located on different server, i have tried with database interaction with xbap but i got error like 'Request for the permission on type 'System.Data.SqlClient.SqlClientPermission'' failed. can anybody help me with this. regards, vijay prajapati Vijay, it is important to understand the difference between a client technology and a server technology. Comparing XBAPs with ASP.NET seems like comparing apples to wrenches. It would be more productive to discuss how the client component of ASP.NET i.e. HTML/Javascript fares in the same scenario. And there too, as I understand it, browsers do not allow you to make cross-domain requests willy ...Show All

• Windows Forms designer can't load form. Where is 'more information'?

  after going from beta2 to rc1, the designer all of a sudden cannot load my forms anymore. instead, i get the infamous window with the red top that says some errors may go away building the project, while other need code changes. needles to say: the file compiles fine, the form could be opened with the beta2 and vs2003 designers and obviously doing a rebuild doesn't help at all. now what the additional error message says; Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information. ok - great. now how do i retrieve the loader exception property. how can i fix this where can i find more info about whats going on   WM_THXADVANCE thomas woelfer http://www.die.de/blog ...Show All

• Visual C# How to Add forms dynamically...

  Hi... I want to add Forms dynamically...i'm developing an application which gets names of COM ports present on a PC. So for each COM port i want one seperate form & i want to do this dynamically. For getting COM present on my PC i am using this line...now in this i want to create seperate forms for each COM port with the names same as COM port names. In this i am getting all my comports names in the variable COMPORTNAME so with the same name i've to create a Form foreach (string COMPORTNAME in SerialPort.GetPortNames()) { //Here form should get created dynamically when i run my application } can anybody help me in this... Thanks, Vinay I ...Show All

• SQL Server Dynamic Security and Rool ups

  Hi I thought I had this dynamic security worked out but I guess not. this is on AS 2000. I have a Fact table - one of the columns is a companyid, this is joined to the company dimension. For security I have another table "empcompany" which lists all the users (ntusername) and the company codes they can access. I created a member property against the company code and used MDX similar to this: filter ([Companycode].[Companycode] .members , ([Companycode] .CurrentMember.Properties ( "ntusername" ) = username )) The problem is that when I join the "empcompany" table to either the fact or to the company dimension instead of getting 1000 rows I get 80000+ rows and my numbers are wrong. Mo ...Show All