seeta's Q&A profile

• SQL Server how do you call storprocedure in sql reporting?

  hi there, im new to sql server reporting and which is the best way to call storproc from the report  design thanks   Hello, Here's the Books Online page that describes how to use Stored Procs with Report Designer: http://msdn2.microsoft.com/en-us/library/ms159260.aspx -Chris ...Show All

• Windows Forms Showing property values as dropdownlist

  Hi, is there a method to show a custom control property values as a dropdownlist (like ControlToValidate property) I know thet declaring an enum type property is a solution. Is there another Thanks Marco It doesnt need to be anywhere near this complicated. Try this instead: return new StandardValuesCollection((context.Instance as Control).Page.Controls); ...Show All

• Visual Studio 2008 (Pre-release) Security options reduced when hosted in IIS?

  When self-hosted, one can use ServiceSecuritySettings.SetUserNameAuthentication to specify a custom MembershipProvider or even custom UserNamePasswordTokenAuthenticator for validating users. Similarly, when self-hosted, one can use ServiceSecuritySettings.ThreadPrincipalMode with GenericThreadPrincipalMode to specify a custom RoleProvider or supply a custom ThreadPrincipalMode class. When hosted in IIS, however, these options don’t seem to be available. SecurityServiceSection, which is a nested BehaviorSection, doesn’t seem to have any code in it for specifying a custom UserNameTokenAuthenticator or even a MembershipProvider. I worked a lit ...Show All

• Visual C# How do I create a simple table in C#

  Hey, Iam designing a inventory software, and I need to make a table that shows the item number, description and price of each item. Iam not using any databases, just want to store all the info in 1 file. Whats the best way I can do this in C# I am not sure about your definition of 'table' ... whether that be a HTML Table, DataTable ... etc. But I would suggest using XML for data storage. If you could give more specifics on what you are having trouble with, I am sure more people could help. ...Show All

• SQL Server is this possible in SSIS?

  I got a OLE DB source pointing to 1 table and 1 flat file destination. currently this is how i export data from 1 table to 1 flat file. To make things easier, I was wondering whether i can have only 1 OLE DB source pointing to few tables pointing to few file destinations so I dun need to create 1 SIS project for each table data exporting. anyone can help me brohans wrote: great, my boss says he wants the individual packages which i just make to be used in creating 1 entire database......like program them in sequence so that the data gets into just nicely into tab ...Show All

• .NET Development "ExecuteReader requires an open and available connection. The connection's current state is open"

  I am trying insert records using oleDbCommand.ExecuteNonQuery. The records are bing inserted properly. But after couple of inserts, the program sits on the line right after the line for instantiating the command object ie when i click on break button from the IDE [after being waited long a time] , the second line [ retVal = m_OleDbCommand.ExecuteNonQuery();] is getting higlighted with green collor. m_OleDbCommand = new OleDbCommand (InsertCommand.ToUpper(), m_OleDbConnection,m_OleDbTransaction ); retVal = m_OleDbCommand.ExecuteNonQuery(); Then I just restart the application , so getting an error saying "ExecuteReader ...Show All

• Windows Forms Forms inside Splitcontainer

  Hi all, In my application "Main Form" I have a splitcontainer which has a treeview control on the left container... What I want to do is load forms inside my applicaition into the right container... Is this possible, and how can I do it Thanks Why not create UserControl custom controls rather than actual Form instances. If you must use a Form then you need to set the owner of the form as the main form and tell the form to have no border. Phil Wright http://www.componentfactory.com Free user interface controls for .NET2 ...Show All

• SQL Server Win CE 4.2 and Smart Dev Application question

  I'm a bit stuck with this one... hope someone can help. I'm trying to develop an application that will run on a pocket PC with Windows CE 4.2 I'm using .Net 2003 and the application is in VB.Net. I can run the application on the pocket pc fine (ie. form paints, buttons work) , until I need to connect to Sql DB on the server. When I try to create a connection object ( Dim dbconnection As New SqlClient.SqlConnection) I get an error stating .. "This application (test.exe) requires a newer version of .Net Compact Framework than the one installed on the device" .... "could not load System.Data.SqlClient.SqlConnecti ...Show All

• .NET Development .NET 1.1 & SQLEXPRESS

  I am trying to access a SQLEXPRESS database which is hosted on the same machine as the web application. When I try from within my web application to connect to the database I get SQL Server Access Denied. I am running Windows Server 2003, which I can't patch to Service pack 1, becuase it can't be done remotely our server is in a datacenter. I have the .net framework version V1.1.4322 installed and working OK. I have SQLEXPRESS CTP April installed, and all protocols are setup correctly, since I can access this database remotely no problems! I can even access it remotely  via an application I wrote in VB.Net 1.0 using running on a W ...Show All

• Windows Live Developer Forums Commercial Control - can we use v3 with what/where turned on?

  Dear Microsoft, The v1 Customer control isn't so great. As an alternate to v1 Commercial, can we use v3 with the what/where turned on It produces the same results (i.e. ad based model) and would encourage a higher level of adoption - as it's far easier to use than v1. Thanks, Jeff adaley wrote: Yes, the v1 commercial control is no longer supported and the v3 control is meant to replace it. Ok, with this being the case, how do I configure my VE v3 javascript to tell microsoft that this is my application calling it. I'd like to see a code sample of how I pass user information to microsoft telling them who is us ...Show All

• Software Development for Windows Vista Extending the WinWF Designer

  If one were to want to extend the WinWF designer by, say, adding a friendlier, knowledge-worker-oriented UI on top of it, what would be the recommended way of doing so I know I've read here and there that this is an expected scenario for WinWF, but I must be searching with the wrong keywords because I can't seem to find much information about how to do it. So far, the most viable solution I've come up with is to build a DSL that would transform domain information into WinWF XAML and code. I'm not at all unhappy with this route (I think DSLs rock), but I also want to be sure I'm not missing anything that might make this a whole lot easier ...Show All

• Visual Studio How to use Refactor.Rename in an Addin?

  Is there any way to use the Refactor.Rename functionality in an Addin or Macro   I can't find anything in the DTE model, and I can't seem to find any parameters documented to use it in an DTE.ExecuteCommand("Refactor.Rename").  The command IS in Tools/Options/Environment/Keyboard commands.  Using the global Find/Replace or the TextSelection find and replace just won't cut it. I'm using VS 2005. Sean Yeah, the find and replace won't cut it... example, if you have a class with a member varialbe named foo and a method with a parameter named foo, it will rename both.. the refactor rename covers t ...Show All

• Visual Studio Tools for Office XP themes in Word COM add-in

  Hi, Is it possible to add XP themes in a VB.net com add-in I know it’s possible in C#: http://support.microsoft.com/default.aspx scid=kb;en-us;830033#6 I can add the class to a separate C# project in my solution, but how do I use it in my VB.net add-in In the example they use a wrapper, but how is that done in vb.net The C# wrapper: using ( new EnableThemingInScope( true ) ) { Form1 form1 = new Form1(); form1.CreateControl(); }   Thanks Lars Hjort Assuming you are running at least .NET Fx 1.1 you can try an easier approach - just call System.Windows.Forms.Application.EnableVisualStyl ...Show All

• SQL Server Calculated Member not working

  Please could somebody help me to understand what is wrong with the following calculated member definition (tried many variations of this now, always the same problem) CREATE MEMBER CURRENTCUBE .[MEASURES].RatioVal AS [Measures].[Val] / SUM (([Tbl Acc Codes].[Tbl Acc Lvl1].&[OUR],[Tbl Acc Codes].[Tbl Acc Lvl2].&[CORE],[Tbl Acc Codes].[Tbl Acc Lvl3 - Lvl 3 Code].&[INCOME]),[Measures].[Val]), NON_EMPTY_BEHAVIOR = { [Val] }, VISIBLE = 1 ; All I want is to show in cube browser alongside Measures.Val is another member called RatioVal. RatioVal should be Val divided by the sum of Val with a lvl1 o ...Show All

• .NET Development Syntax for ordering by a column that contains a #

  I am using a OleDbCommand in C# 2.0. If I have a column called Record#, what is the proper syntax for sorting by this column I tried "SELECT * FROM MyTable ORDER BY Record#" but it does not work. However, when I rename the column to RecordNum, the above syntax works (using ORDER BY RecordNum). I believe it has something to do with either SQL or OLE thinking # is a representation of a date of some sort. I have also tried 'Record#' and \"Record#\" but they do not work either. The actual escape syntax is going to depend on your underlying data source. A common syntax is square brackets around whatever you want treated literally. So ...Show All