sweetCoder's Q&A profile

• Windows Forms Switch connectionstring for TableAdapter

  TableAdapter is great. But, each TableAdapter needs itself connectionstring. Now, I need to switch Sql Server database, do I need to reset connectionsstring for my more than 50 TableAdapters Is there a better way to do it Thanks I still don't understand why you said connectionString in app.config doesn't work for TableAdapter. Why do you think it doesn't work I use it all in my project. In my TableAdapter, I specify the connection as "Dev_ConnectionString". This is excatly what I've put inside the connection property. However, it's actually pointed to a string inside the app.config. Why is i ...Show All

• Smart Device Development Progress bar control

  Hi, I would like to implement Progress bar in my PPC Apps to show the send status. I 've to send datas from PPC to server side SQL database . If i'm sending 10 records, i want to show it either as Sending record1 of record10 Sending record2 of record10.....so on. OR Using Progress bar . How to do it Thanks! There is a sample on http://msdn.microsoft.com/vstudio/tour/vs2005_guided_tour/VS2005pro/Smart_Client/Pickers.htm see if that helps. Thanks Amit ...Show All

• SQL Server How to configure data source/Oledb-ado connections from outside the package?

  Hi All, Another requirement has cropped up with regard to picking up connection settings for data sources from an external File. My source and target are both in SQL Server. What i need is that if my source or target changes I should just change my external file and same should reflect in my package. How can I accomplish it Please suggest some solution. Thanks in advance. Regards, Aman Anand Thanks for the reply Thiru. I saw your message just now. But, you confirmed what I tried sometime back in my Package before seeing your reply. Anyway thanks again. Regards, Aman ...Show All

• SQL Server find primary and foreign keys

    I have a DB with 100 tables. I was wondering if anybody knows a quick way to list primary and foreign key with the column name for all the tables. Your help would make my life a lot easier   thanks Please use the INFORMATION_SCHEMA views instead of accesing system tables or using undocumented columns. The view INFORMATION_SCHEMA.KEY_COLUMN_USAGE will give the information you are looking for. ...Show All

• Windows Forms multiple PrintPreviewControl problems in C#

  When the mouse is moved over PrintPreviewControl, how to change the cursor only when it is on the document that is displayed in the control. It should remain at default state outside the document. When two pages are displayed in the PrintPreviewControl, how to identify which page is clicked Also, how to display the vertical scroll bar of PrintPreviewControl pro ...Show All

• Visual Studio Express Editions creating dll's

  hey i am designing a program and i was wondering if it is possible to create a dll in Visual Basic Express Edition well, maybe I should rephrase that. I'm designing a program where when you click a button it opens a text editor(already have that made). Someone told me that to reference the program in the code you need to create a dll(is this true ) Shak, Normally there is a path variable which includes that directory. When I open a command window, and enter: c:\>path it will display the path information for the system: C:\>path PATH=e:\Program Files\DirectX 9.0 SDK (October 2005)\Ut ...Show All

• Visual C# VB.net verses C#. Which is used more. Which more popular

  Does someone have any data on which language is used more and what the percentages might be of developers developing in Visual Studio    Is C# used more or VB.net   Is there a future trend   Is one gaining in popularity over the other Any information on this would be appreciated.  Does MS prefer one over the other I am a VB.net developer, contemplating a move to C#. I've moved this thread over to the C# forums, where I believe you'll get more help. Thanks, Robert McIntyre Visual Studio Product Team ...Show All

• Visual C# How to pass reference parameter to unmanaged dll

  Hi I have a function in unmanaged(VC++) dll which is accepting a refernce parameter void check(UInt32& c) { c=20; } I want to call this function from my managed code(C#) so i used the following code class Program { [DllImport("samp.dll")] public static extern void check(ref UInt32 c); static void Main(string[] args) { UInt32 s = 0; check(ref s); Console.WriteLine(s.ToString ()); Console.ReadLine(); } } but it shows me the error"Unable to find an entry point named 'check' in DLL 'samp.dll'." is there any way to call a unmanaged dll's function(which has reference parameter) from managed code without using DLL import if ...Show All

• SQL Server Order by clause in View doesn't order.

  I have created view by jaoining two table and have order by clause. The sql generated is as follows SELECT TOP (100) PERCENT dbo.UWYearDetail.*, dbo.UWYearGroup.* FROM dbo.UWYearDetail INNER JOIN dbo.UWYearGroup ON dbo.UWYearDetail.UWYearGroupId = dbo.UWYearGroup.UWYearGroupId ORDER BY dbo.UWYearDetail.PlanVersionId, dbo.UWYearGroup.UWFinancialPlanSegmentId, dbo.UWYearGroup.UWYear, dbo.UWYearGroup.MandDFlag, dbo.UWYearGroup.EarningsMethod, dbo.UWYearGroup.EffectiveMonth If I run sql the results are displayed in proper order but the view only order by first item in order by clause. Has somebody expe ...Show All

• Visual Studio How to get remote access web service installed and working?

  I am using the GA version and I am unable to get the VSS web service to work properly. When I go into server admin and try to enable Internet for VSS it tells me that IIS isn't installed, etc. I have run aspnet_regiis -i (didn't need to as it was already installed properly) and have even created a virtual directory pointing to the web service folder in the VSS directory. At this point I am able to access the web service remotely however I don't understand why the configuration keeps failing. I have used Vault from SourceGear and it works like a charm right out of the box with VS 2005. Any help would be appreciated as I would like to con ...Show All

• Architecture Dependency between Business and DAL - Problems with unit testing

  We just started to reorganize our code and are separating the DAL from the Business. We have also started playing with unit testing, but we've come up with a few problems. 1) Unit testing the DAL. Yes, we've noticed that this is not a trivial task, and are looking at using the com+ / service enterprise approch. The quuestion is: Are there any help for adding rollback option built into the Team Systems 2) Unit testing the Business. Quite a few of our business class depends quite heavily on the data access layer. The problem occurs when we create an instance of a business class, it requires a lot of DAL access. Typically today this acces ...Show All

• Visual Studio 2008 (Pre-release) How to Get click event in my code behind file

  Hi I am using the following code to custmize my button. How can I get the Click event for this button in my code behind file Thanks Viswanand < Page x:Class = " AvalonApplication7.Page1 " xmlns = " http://schemas.microsoft.com/winfx/avalon/2005 " xmlns:x = " http://schemas.microsoft.com/winfx/xaml/2005 " Title = " Page1 " > < Page.Resources > < Style x:Key = " ButtonStyler " TargetType = " {x:Type Button} " > < Setter Property = " Background " Value = " RadialGradient #fedbb7 #feb873 " /> < Setter Property = " Height " Value = " 30 " /> < Setter Property = " Margin " Val ...Show All

• Visual Studio Execution session has expired

  I have a web page that uses ReportViewer web control to connect to a remote SQL 2005 report server to display reports. Once the report has been displayed, I am not able to export, refresh or navigate to the next page using the reportviewer toolbar. I get the following error: Execution session has expired Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Exception: Execution session has expired Source Error: An unhandled exception was generated ...Show All

• Visual Studio Express Editions Using VB Express with a limited account

  I've installed this (it required admin privileges) and then tried to register on my limited account and it refuses to accept the key although it quite happily did on the admin account. When I run it on the limited account it tells me that I have 28 days left before it expires. Does this mean I can to only use VB Express as a superuser Seems a bit daft considering that Microsoft are currently trying to discourage lazy developers from requiring admin access. Hopefully someone can enlighten me. hi, i guess the 28 days left is for registeration, in your help  menu click register product vb express is ...Show All

• Visual Basic cybercafe

  I am now creating my cybercafe software for my final years project May i know that how can i shutdown, restart, or log off the user/customer pc after payment by using admin pc . Hi, You can use the shutdown command to shutdown/restart a remote host provided that you have administrator access on the remote host, and it is running Windows XP or above. There's a logoff command as well. Otherwise, you'll have to call some Win32 APIs which should be easy to find if you look just a little harder in MSDN documentation or Google. ...Show All