CARMCK's Q&A profile

• Visual Studio Express Editions Problem with DBNull values on form

  I am encountering a problem with a form comprised of several textboxes, comboboxes, and pictureboxes. I have a save button that when you click it, it saves the new record to the underlying datatable. However, the record will only save if every textbox, combobox, and picturebox has been given data (in other words, is not null - or DBNull). My problem is, not every record will necessarily need every control to have a value. In my dataset, all the controls allow DBNull values and for every textbox I have changed the NullValue property to "Nothing" as opposed to "Throw Exception". However, it will not let me do that for a textbox that is bound to a Double data type, a textbox that is bound to a DateTime data type, and for t ...Show All

• .NET Development assigning array values takes too long

  Using vb8 and sql server 2005, I am assigning two array values to a datatable and updating a dataset. Unfortunately, it is taking, so far, more than an hour to do this with about 650,000 records. I've done something similar with more fields and about 1.5 million records using vb6 and ado but that completed in 2 or 3 minutes. Below, I've listed the code. What am I doing wrong and how I can speed up this operation Dim ResultAdapter As New SqlDataAdapter ResultAdapter = New SqlDataAdapter(ResultCmd) Dim ResultSet As DataSet = New DataSet ResultAdapter.Fill(ResultSet) Dim FactorTable As DataTable = ResultSet.Tables.Add(FactorTableName) Dim DTCol As DataColumn = FactorTable.Columns.Add( _ " ...Show All

• Visual Studio Team System Problems with Reporting Services after restoring to a different server

  We had to restore our TFS to a different server, I have followed the Restore procedures on msdn: http://msdn2.microsoft.com/en-us/library/ms252516(VS.80).aspx . Team System is back up and operational however when I access the Reporting Services site I get the following error message: The report server installation is not initialized. (rsReportServerNotActivated) (rsRPCError) Get Online Help Thanks in advance! ___________________________ Sarah Cameron - InCycle Software Thanks, Mark! I only had the once instance, and it showed as initialized, but would not initialize. However, I deleted it and it came back green and health, and the report server now works! Thanks for taking the time to help ...Show All

• Windows Forms bringtofront()

  Hi, i get problem with main menu and children case ( true ): // //I need to bring the form to the front. //If it is minimised, how do i open it back to original //state. foreach ( Form F in this .MdiChildren) { if (F.Name == aForm.Name) { if (F.WindowState == FormWindowState .Minimized) { //code to open the form ( not maximise it ) } F.BringToFront(); break ; } } break ; and this is the whole logic part: public void AddForm( Form aForm) { switch (Forms.Contains(aForm.Name)) { case ( true ): foreach ( Form F in this .MdiChildren) { if (F.Name == aForm.Name) { if (F.WindowState == FormWindowState .Minimized ...Show All

• Visual Basic VB Control Arrays.

  Ok, there are many posts all over the net with possible solutions to this challenge, but none seem to suit my needs. in the 'good ol' days' (VB6 and Prior) you could simply copy/paste controls to a form and set Index properties to create an array of controls. These could then be manipulated individualy, for example: MyTextBox(1).Text ="I" MyTextBox(1).Text ="WOZ" MyTextBox(1).Text ="'ERE" But I can't find a simple solution to create an array of 132 picture boxes. I don't need anything fancy, just to be able to address each box individually using an index. Any help would be much appreciated, and keep my barber in business a bit longer! Thanks, MrMojo. In .net forget control arrays - they arent supported a ...Show All

• Windows Forms Package a DLL with clickonce

  I have an existing application that is distributed using clickonce and I want to create a new DLL file that will be included with the installation. The DLL has nothing todo with the app but the users that use this software need the DLL so I would like to distrubute it via this app. Any ideas I have created the DLL using a class.vb template. ...Show All

• Windows Forms How to Click a Button in another Application Programmatically in C#?

  I would like to invoke the button click event from one application to another application. Is there any to way to trigger the other application events from the main application. Please help. Thanks in advance. Hi Figo Fei, Thanks for the brief explanation about Remoting Overview. If possible, could you please provide me a bit of code snippet for triggering the command button’s click event of another application. Both applications have been written in C#.Net. So I think it’s easy to access other applications object. Thanks in advance. ...Show All

• SQL Server How to get a distinct dimension member through MDX?

  I have a process dimension that has 4 levels. Process Level Task Level Status Level Queue Level Here is an example of the data: Process A, Task A, Status A, Queue A Process A, Task A, Status B, Queue A Process A, Task A, Status C, Queue B Is there a way to use the Distinct function in MDX to a listing like: Queue A Queue B Instead of getting Queue A listed twice Thanks. Here is some previous discussion on the topic: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=525151&SiteID=1 Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All

• SQL Server dynamic sql

  I have the following query: DECLARE @ColumnName varchar ( 50 ) DECLARE @FilterValue varchar ( 255 ) DECLARE @ExactMatch bit SET @ColumnName = 'Title' SET @FilterValue = 'Hello' SET @ExactMatch = 1 IF ( @ExactMatch = 1 ) BEGIN SELECT Title FROM CorporateForms WHERE CASE @ColumnName WHEN N 'Title' THEN Title WHEN N 'CorporateFormTypeID' THEN CorporateFormTypeID END = @FilterValue ORDER BY Title END ELSE BEGIN SELECT Title FROM CorporateForms WHERE CASE @ColumnName WHEN N 'Title' THEN Title WHEN N 'CorporateFormTypeID' THEN CorporateFormTypeID END LIKE '%' + @FilterValue + '%' ORDER BY Title END In the database table, co ...Show All

• Windows Forms DataGridView maxes out at 140 rows

  Hi, My application has a DataGridView which I have extended. The extended DataGridView I found out only allows a maximum of 140 rows. I was looking for which property to modify to allow the DataGridView to grow without restrictions. Thanks in advance. Dwight there will always be a restriction at some point. Maybe you should consider doing some filter on the query. However at 140 records it should not max out. are you able to show us the code on how you are adding items to the datagridview ...Show All

• .NET Development winForm User Control and JavaScript

  Hi, I have created a simple user control( as win dll in .net, referred to 'Embedding WinForm controls in IE'). Now my problem is that I want to handle some events for my control on the wep page, for e.g. Let say my contol has a button in it, and I need to write the click event ( of the button) code on the client page itself ( Senario: Creating a so called ActiveX using .net and want to expose event handling to the users of the control) Now I used delegates to define event handling in my control. When I use this control in my Win Apps ( as a client) i am able to register the event and handle it. BUT, the problem comes when I am trying to embed it in my web page(a simple html file) using <Object> tag ( as we use to do it for ActiveX ea ...Show All

• SQL Server Table Partition Help

  I am trying to understand how table partitioning works. I have Database with 5 Filegroups. Database contains one Table which is partitioned. Filegroups Primary FG1 – used for Partition FG4 – used for Partition FG3 – used for Partition FGINDEX - used for Index There are no Primary Keys on my table but it does contain a clustered index (created on FGINDEX). When I insert records into my table, my partitioned Filegroup does not grow, however my Index filegroup does grows. However when I do a search on my partition it shows that my Partitioned Filegroup contains data. I have a feeling that all the data is being inserted in to my index filegroup (FGINDEX). Also if I change the alter the index into nonclustered my Data file group grow ...Show All

• Visual Studio Team System Team system does not recongnise ".js" page of my website when i try to record and run the script

  Hi, All One of my '.js' file does not get recognised when i try to run the script. this is what happens i have a '.js' file in my website and i have recorded the website in teamsystem and when i run back the script ..I get a error 404 page not Found ******This is the page i am not able to record "http://blrasp04/portal/js/ieupdate.js"******* Following is the error i get in the test results screen Warning: Test Run deployment issue: Failed to get the file for deployment item 'C:\Documents and Settings\jrajeev\My Documents\Visual Studio 2005\Projects\Portal\bin\Portal.dll': System.IO.FileNotFoundException: Could not find file 'C:\Documents and Settin ...Show All

• SQL Server how to add rows with Script Component?

  Why am I getting this design-time error from my script: 'Microsoft.SqlServer.Dts.Pipeline.ScriptBuffer.Protected Sub AddRow()' is not accessible in this context because it is 'Protected' Here's my script: ' Microsoft SQL Server Integration Services user script component ' This is your new script component in Microsoft Visual Basic .NET ' ScriptMain is the entrypoint class for script components Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper Imports Microsoft.SqlServer.Dts.Runtime.Wrapper Public Class ScriptMain Inherits UserComponent Public Overrides Sub Input0_ProcessInputRow( ByVal Row As Input0Buffer) Dim outp ...Show All

• SQL Server Qns on SQL Express Database

  Hi Is it possible to blank/null out all the data in a specific table in the database, executed in a button click event What do you mean Truncate Delete Update Probably truncate, as a table with all rows filled with blnaks/nulls make no sense to me. ...Show All