d3v310p3r's Q&A profile

• SQL Server Triggers

  Hi, i an new here. I just started with Sql Server 2005 Express. But my problem is not in technical issues, but programming. Now, to problem. I have few tables, Meas, Analog, Discrete, Acc and Terminal. Meas is main, have some field of it's own, one primary index key, and on foreign key. Foreign key is coming from Terminal table. Terminal table is stand alone, cause it has no other connections to any other table in this model. Analog, Discrete and Acc have almoust same columns. This tables have no primary index, but foreign keys from Meas table. They exclude each other. Example, meas data with key 1 is in analog table, but not in discrete ...Show All

• SQL Server Trouble calculating YTD

  I'm trying to create a YearToDate calculated measure that gives me YTD sales.  However, when I add the following calculated member:   Sum(YTD([Measures].[Sales])) with "Measures" as the parent, I get the following error when I try to use the calculated measure: "The YTD function exects a member expression for the argument.  A string or numeric expression was used" I'm using SQL 2005.  Any suggestions Trent thanks for ur suggestion boss but in that its not speicifed as to how should we calculate. i want to calcute the measures using function and i want the output in MTD , QTD,YTD ...Show All

• .NET Development Inserting complex xml into SQL database

  I have an class that looks something like this: public class MyData {   string [] MyList; } When I XML-serialize the class, it looks like this: <MyData>   <MyList>    <string>first string</string>    <string>second string</string>    <string>third string</string>   </MyList> </MyData> I'd like to be able to do a DataSet.ReadXml() and read that XML into a dataset (for subsequent insertion into a database), but when I call ReadXml(), it just puts "first string" in the "MyList" column. Is there any way to ...Show All

• Visual C# Referencing Value Variables

  I want to do something where I can take any variable, reference type (no problem) or value, and have a reference to the data, rather than just the data (in the case of value variables). Example:             //create three objects for reference             object obj1, obj2, obj3;             //create two value variables and one reference variable             int i;             string s;       ...Show All

• .NET Development File in the memory

  I have an executable file in memory.(just a piece of memory, with executable file data). How could I execute it using .net. And work with this amount of memory just like with a simple file. It's pity, that writing to file is the only way... (obviously, this is the easyest way :) Thanks for your help. ...Show All

• SQL Server Cannot Open User Default Database (error 4064)

  Hi, SQL Server 2005 installed on my computer. i was trying to make a login page with VS.2005 pro. But i got some errors on Website Administration Tool. Whatsoever, i registered a database (aspnetdb) . Then, i think i made my default database to aspnetdb. Something went wrong and i decided to delete aspnetdb and start whole procces from the begining and i did it. AAANDD WHOOOLA. I got this error: Cannot Open User Default Database, Login Failed Microsoft SQL Server, Error 4064 Is there anyway to change my default database to "master" again Or simply will i uninstall all the sql server 2005 ( f you say uninstall, answer this:: Will be any pro ...Show All

• Visual Studio Express Editions Installation Problems

  I installed SQL Express on my laptop (Thinkpad), and tried to install SQL Server Management Studio Express. Since the later failed, I tried to uninstall the server. I found several entries in the Add or Remove Programs, so I uninstalled them in alphabetical order. When I came to Microsoft SQL server VSS Writer, I received a Fatal Error, apparently because the installation folder had been removed by a former uninstall. I tried to reinstall SQL Express, but received the message "The application failed to initialize properly (0xc0000034). The usual solution for such registry problems – Backup everything, reinstall Windows, and sp ...Show All

• .NET Development Discard changes made to datatable columns of a Dataset?

  Hello, I have a windows form with several text boxes. OnLoad, I use a DataAdapter which calls a SQL sproc to retrieve it's info. The sproc returns has 3 select statements so when all is said and done, the dataset ends up with 3 tables. (table, table1 and table2) Next I use databindings.add for each of the textboxes and bind them to the appropriate column in the appropriate tables. The textboxes are readonly by default and I have an Edit button that allows them to be edited. When the edit button is clicked, a Save and a Cancel button are enabled. I have the Save portion of this working as well. The problem I have is when a User en ...Show All

• Visual Basic Installing VS 2005 keeps on asking ' Please insert the disk: Visual studio 2005'

  The installation process for Visual Studio 2005 prompts ' Please insert the disk: Visual Studio 2005' everytime when I try to install VS2005. This is what I did: * Downloaded VS 2005 from the MSDN members download site.    File name: en_vs_2005_pro_dvd.iso (size=2,825,748 KB) * Used MagicISO tool to unpack the files   * Used Nero 6 to write the extracted files to the DVD * Created a brand new Virtual PC with Windows XP + SP2 * Start the install process in the VPC by clicking on the setup.exe    in \vs on the dvd * Select the default installation options * Installation starts for a long time and then pr ...Show All

• Visual Studio Express Editions Choose Toolbox items, adding to toolbox, which dll?

  This must be a simple question: I have created a classlibrary with some components. Now when I select 'Tools, Choose Toolbox items..' and select 'Browse' to find my library, should I use the dll in the 'bin' folder or the one in the 'obj' folder Also, I assume, I should use the 'Debug' version. Right Yep, select the one located in the Bin folder. If you're component is compiled as Debug, choose the Debug version, otherwise, choose the Retail version. ...Show All

• Visual Studio Team System Q: How do you Filter system generated cs files(such as class.designer.cs) in FxCop?

  Anyone tried using FxCop that is capable of disregarding system generated code (cs files such as class.designer.cs) You can suppress individual violations within the generated code, however, there is no way to ignore all generated code. Although, Code Analysis in Visual Studio does shutdown noise on members marked with CompilerGeneratedAttribute and GeneratedCodeAttribute. What exact violations are you trying to ignore I ask this, because at the moment we are starting to work with other teams within Microsoft to clean up warnings within generated code.   ...Show All

• SQL Server Unhandled Exception in Management Studio

  At work we run a large SQL Server 2000 database that is usually administered using Enterprise Manager. I recently started playing around with SQL Server 2005 Management Studio and have been encountering an interesting problem. Whenever I browse tables/views in the Summary window, and then select a table/view (by hitting enter or double clicking) Management Studio encounteres an unhandled exception (below). Oddly, this behaviour only occurs when the Summary window is in "Details" view. When in "List" view it works without any problems. Also, I don't encounter this behaviour with all the tables/views - Management Studio can access some without ...Show All

• Visual Basic KeyASCII

  Can someone help me on how to declare the keyASCII in VB2005 Private Sub Textbox1_KeyPress( ByVal sender As Object , ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles Textbox1.KeyPress 'The following properties must be set thusly: ' Textbox1.Multiline = True ' Textbox1.AcceptsReturn = True If e.KeyChar = Chr(Keys.Enter) Then ' Code to be executed goes here. e.Handled = True End If End Sub See System.Windows.Forms.Keys in the objectbrowser ...Show All

• Visual Studio Express Editions Hey Help me please

  Thanks to traxer_x I got what I was missing without the tear down and with out putting 60 pages of code over the internet but I am sorry for my mood swings I had so much going on I just needed to step away from the problems of life and focus on the task at hand.  I apologize guys but that I know isn't enough. Thanks anyway for your help I would start by trying to create a link list first. Search on the web for a linked list and you can find some implementations. I am sorry but the forums are designed for specific questions and not for general how to or homework help. Please try starting yourself ...Show All

• Visual C# Can't zip nested folders

  Hi people ! does anyone here used the java.util.zip package I need to zip a series of nested folders  similar to this MyProjects/MicrosoftProjects/MyProgram/bin/Debug/MyProgram.dll however the ZipOutput stream requires a file,in this case MyProgram.dll.Does anyone have a workaroud regading the above issue I keeping hitting the FileNotFoundException as i specifed the sourcestream at MyProjects/ regards Wilson   bmann225 wrote: Hi people ! does anyone here used the java.util.zip package I need to zip a series of nested folders  similar to this MyProjects/MicrosoftProjects/MyProgram/bin/Debug/MyProgram.dll however t ...Show All