Clayton Culver's Q&A profile

• Windows Forms Data bound items on a form automation and DataSet generation

  Hello, I use Visual Studio 2005 Professional with SQL Express 2005. When I create a form and add data bound control into it (i.e. DataGridView), the data binding wizard creates a new instance of the DataSet that I have in my application (which is also created by MSDataSetGenerator wizard). Then if I launch my application and have 5 open forms, I have 5 instances of the DataSet class associated with the same database. This consumes a lot of resources (system memory, sql server connections, etc.) How to make this automatically generated DataSet a signleton for all application forms And also, how to make singleton Connection object for all table adapters automatically generated for the DataSet I would like to do this using M ...Show All

• SQL Server Insufficient Memory Errors - 12GB RAM - 64-bit???

  hi, it was suggested to try this forum, so I am hopeful I can get some more ideas. Please see this link where i posted my issue: http://sqlforums.windowsitpro.com/web/forum/messageview.aspx catid=82&threadid=49973&enterthread=y Summary: I have just installed a brand new 64-bit system, with 64-bit SQL Server 2005 sp1, and 12GB of RAM. The same queries and processes that worked on SQL Server 2000 Std Edition successfully, are failing on SQL2k5 64-bit After migrating the databases and jobs, I am frequently getting this msg: 701:Insufficent memory to run this query Nothing else in the logs. I also made sure that the SQL Service account is granted Lock Pages in Memory - no help. First, I thought that SQL 2005 can take all ...Show All

• Visual C# Creating an instance of Abstract Class

  Iam analyzing the Source Code of ADO.NET, using Reflector... I notice that the DataColumn have internal Property called Storage from type DataStorage The Code Like This: internal DataStorage Storage { get { return this . storage ; } set { if ( this . storage != null ) { throw ExceptionBuilder . StorageChange (); } if ( value != null ) { if ( value . Table != null ) { throw ExceptionBuilder . SetForeignStorage (); } value . Table = this . Table ; } this . storage = value ; } } The DataStorage Class is an Internal Abstract Class and in the code above they define a property from type storage which is abstract c ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Microsoft's future policy for redistributing Xbox 360 games?

  Before I commit serious time and effort to the XNA framework, I'm wondering if anyone knows Microsoft plans for allowing us to redistribute our games for Xbox360. I'm an academic. Let's say I want to make some educational/simulation games that my students can use on the Xbox 360. Will I be able to provide them with a CD or download link in XBox live As far as I can tell so far, the only games I can write are for myself. There is no announced policy on distribution through Xbox live, so you probably shouldn't count on the availability of such a mechanism. In fact, I'd go so far to say that if you're going to be distributing the software to students (and running on school machines I'd imagine) you might ...Show All

• Visual Studio Tools for Office Vsot - Outlook - The macros in this project are disabled. How to enable macro in outlook

  I was testing my VBA codes in outlook. Everytime I run the code the following error would come up. The macros in this project are disabled. Please refer to the online help or documentation of the host application to determine how to enable macros. I tried uninstalling Outlook and reinstalling. It doesn't help. How do I enable the macros in outlook. Macros in word works fine. Help thanks Which Outlook Version XP and 2003 should be: Tools->Macros->Security: set to medium so you get asked if you want to activate macros. -- SvenC ...Show All

• SQL Server Excel as Frontend to SSAS 2005 Cube

  Hi, there, I am working on Excel as a front-end to a SSAS2005 cube. I intended to create a simple add-in that allows users to write back to the cube. Users will first retrieve data from the cube to pivot table and write back to the cube from the pivot table. I can find some sample source based on adodb and AS2000 but not adomd .net and SSAS2005. For the time being, information on SSAS2005 write-back from Excel seems very little. Not much references that I can refer to. Anyone can shed some light on this I would appreciate it if you can provide me some sample source in VBA using adomd .net or others that can demonstrate the write-back to a SSAS2005 cube. It would be great if the sample will be based on the AdventureWorksDW cube. Th ...Show All

• Visual Studio SqlDataSource wizard showing SQL with wrong syntax

  I've set the quoted identifier stuff in all the locations I can think of and yet SqlDataSource wizard still shows the SQL as SELECT [col1], [col2] from [table]. This syntax doesn't work for us. How does it determine what syntax to use if it's not using things like DataSourceInformation Thanks Reggie (MySQL) Closing this thread, this forum is about programming the Visual Studio APIs, not SQL development (and I am not sure about the best forum to move this to). Craig ...Show All

• Software Development for Windows Vista Stack Overflow in the rule designer

  Hi All, I'm trying to use my properties in the rule designer but I can't get it work. When I write a new rule (for exemple : this.myproperty1 == 0), I've got the error: myproperty1 isn't a field of foo.Workflow1. Ok so I change the x:Class attribute of my workflow into Namespace.MySequentialWorkflow (the true type of my custom workflow) But now when a click on the button "new rule..", there is an infinite loop and the program crashes on a stack overflow. Is it the expected behavior I'm using the beta 2.2 (the installation of the RC1 always fails..) AntoineF Is this still a issue I tried it on the RTM bits and was not able to repro the error. Basically I tried x:Class="NameSpace.WFClas ...Show All

• Visual C# DataGridView.Rows.Add... problem!

  I am facing a problem with adding new row to an existing unbounded DataGridView which contains two columns; the first one is DataGridViewLinkColumn type and the second one is DataGridViewTextBoxColumn type. But I always having an empty cell inside the DataGridViewLinkCell, I am using the following code: DataGridViewLinkCell aLinkCell = new DataGridViewLinkCell(); aLinkCell.Value = "Something"; MyDataGridView.Rows.Add(new object[] { aLinkCell, "Something" }); Thanks in advance. You just need to set the text private void Form1_Load( object sender, EventArgs e) { DataGridViewLinkColumn lc = new DataGridViewLinkColumn(); DataGridViewTextBoxCol ...Show All

• Visual Studio Express Editions How do i make an installer?

  I've made my very first application in Visual C# Express Edition 2005 , i made a text editor!               So I finished my app but now i want to make an installer to be able to run it on other computers, i found the option to "publish" it, so i did that, and it create something that looked like an installer along with other files.  I sent those files to a friend to see if it would install on his computer but it wouldn't, so my question is, Is that the only kind of installer i can make through Visual C# Express Edition 2005             Any ideas how to make a good installer, i found in the documentation t ...Show All

• Windows Search Technologies search bar

  Looking for help deleteing my search bar history. Any help would be appriciated. jhelm24, When you say "search bar" history are you referring to the search box on the task bar that says "Search Desktop" inside If so, do the following: Put your cursor in the search box so that it brings up the Windows Desktop Results window. Click on the little Windows icon in the bottom left corner of the window and then select "Clear Search History". If you want to prevent history from being saved going forward do the following: Right click on the magnifying glass in the system tray and select Desktop Search Options. Select Deskbar in the navigation pane on the left side of the ...Show All

• SQL Server toggleItem problem

  Hi everyone!!! I have a custom authentication where I render a report and then using Response.BinaryWrite to show it. My problem is that these reports have a lot of toggle item, and when I try to expand one of this toggle item, my page is redirected to http://serverName/ReportServer/folder/report and start showing my report from my server. How I could expand my toggles without redirecting to my server Best regards. Pedro ...Show All

• SQL Server Validating a Source File

  I'm totally new to SSIS and need some direction. I'ved worked with the Import/Export wizard to create a package that imports a text file into a SQL Server table. However, I'm told the format of the text file changes over time and that's not good. I need to program in a format validation check on the source file before it gets imported. If it changes, I'm suppose to throw an alert or something. Let's say the file has the columns: field1 (string[10]), field2 (date), field3 (integer), field4 (decimal). I did some testing and tried to change the data to a longer string in field1, and SSIS recognizes that and errors out. How do I get it to send the bad record to an bad record file Do I just set a destination file connection for bad records ...Show All

• SQL Server Hide some columns in Matrix but not in subtotal

  Hi all, I would like a matrix that look like this: 2006/01 2006/02 2006/03 Total % % % % Amount Amount Class. BU1 98,82% 78,53% 88,12% 88,49% € 217.763.099,50 € 207.328.766,75 BU2 64,98% 32,53% 92,19% 63,23% 5.093.781.522,65 € € 287.731.766,75 BU3 74,71% 45,78% 78,69% 66,39% € 847.871.349,50 € 819.123.124,75 I want detailed subtotals but I don't want the "Amount" and "Amount Class." values in the details of my Matrix. I've not found other w ...Show All

• SQL Server RAISERROR in CLR Routines

  When I use the following code to execute a RAISERROR from within a CLR Routine (Stored Procedure), and I call this CLR stored procedure from T-SQL within a TRY/CATCH block, the error is not caught in the CATCH block. Why is this happening try { SqlContext .Pipe.ExecuteAndSend(cmd); } catch { } When you say the error is not caught in the catch block - what do you mean with that, or rather how can you say that the error is not caught in the catch block as the catch block is empty If you - for example - where to execute a proc from SQL Management Studio (SSMS) whose command was something like so: RAISERROR('Something went wrong', 16, 1), you should see in SSMS something like this: &q ...Show All