Spangltk's Q&A profile

• Visual Basic datatable time intervals

  Hey everyone not sure if this is the right place to post this, it's actually an ASP.NET page but the code behind is done in VB.NET and the code behind is where my troubles lay so here it goes. Basically my problem involves using a data table to fill a gridview for export to Excel. I know how to export a gridview to excel already what I'm having trouble with is the data table behind the gridview, basically I've got a data table which is filled via SQL Server and all the data in it is time stamped, what I'm trying to do is manipulate that data table (actually it filters the data from one table to another) so that I can get the data in intervals every 1 minute or 2 minutes or 30 minutes etc. or closest to the interval as possible. When I set ...Show All

• SQL Server Help on global variable for insert statement

    I am new to DTS, but really enjoy it and was wondering if someone could help me with the following small vb app. I am using the following DTS insert statement to insert records into my table. I have multiple textboxes that needs to be filled and then inserted, none of them exept Nulls. How can I modify my code to insert those textboxes as well as run through the boxes and then check if they have nulls and NOT insert the ones that has nulls My form has 9 textboxes. Textbox1, 2, 3  Needs to insert values into the first column. Textbox4, 5, 6 into the second and then Texrbox7, 8, 9 into the last column. My question is how do I format the following line of code to do what I need oCustomTask1.SQLStateme ...Show All

• Windows Forms DataGridView row height

  Hi, I need to calculate the height of a datagridview row before it is created, but I can't figure out how to do it. I am trying to fill a datagridview with only as many rows as will fit. In order to do that I need to know how tall the rows are going to be. I guess I could create the first row and then measure it, but I figured there had to be a more elegant way to do it. Thanks in advance. Lee I tried that and it didn't seem to work. Using the default font, font size and other settings, I know that the row height should be 20 but the RowTemplate.Height shows 22. When I change the font size to a much larger font, the RowTemplate.Height stays at 22. Am I missing a step when I initialize the D ...Show All

• Visual Basic Textbox Caret Line, Col

  I'm trying to find the Line and Column of the caret. When I searched these forums earlier, I found a this Function: This is getting trickier... I don't believe that the code you had to start with worked at all... What I've found is that in Visual Studio 2003 the return value of the TextBox.Lines property is being calculated based on CRLF characters. It does not seem to count wrapping. So if one line of text (no returns) spans multiple lines in the control, the Lines property still returns 1. In VS05 this is not the case. If one sentence spans three lines the property returns 3. I'd say that original code was meant for VS05. You'll have to write an algorithm that uses the current position, the number of characters in each line, ...Show All

• Visual Studio 2008 (Pre-release) XAML Custom Classes & Collection Properties

  I am trying to define a custom class (hierarchy) to be used in XAML. I've just started with the root of my class hiearchy, and I'm running into problems. I'm not sure if I'm doing this the right away, so let me provide a bit of context. My root class inherits from ModelVisual3D (as well as my own interfaces), since it is meant to be inserted under a Viewport3D in a XAML file. I do nothing with UserControl. That didn't seem to accomplish what I wanted (i.e., add my root object in various place in a XAML 3D scene hiearchy), but I may be wrong. Anyway, I ran into problems when trying to add a collection property. My collection is based on KeyedCollection<>. It's exposed as a read-only property of my root object. However, the ...Show All

• Software Development for Windows Vista Cannot install June CTP Windows SDK

  I have downloaded the *.img file contning Image of the DVD with June CTP Windows SDK I followed all the instructions to uninstall May CTP SDK & WinFX I Installed Net 3.0 June and here's the problem: While trying to install Windows SDK I get this error : "Error 1330 A file that is required cannot be installed because the cabinet file F:\Setup\WinSDK-SDK_MDAC_BIN_common.0.cab as an invalid digital signature This may indicate the cabinet file is corrupt" I checked this file (Size is 2 438 462 / 2 439 168 on disc) - and this file does not contain the digital signature (neither have all the files named starting with WinSDK-SDK_MDAC*.*) I tryed to install MDAC2.8 SDK separetly so that Windows SDK Installer won't inst ...Show All

• Visual Basic Client/Server Application?

  Hi all, We currently have a VB6 DCOM client/server system with the following layers: Data Layer: Wraps around ADO2.8 Business Logic Layer: An ActiveX Exe running on a local or remote server Presentation Layer: The actual UI app found on all user machines We are now looking in to creating the new version in VS2005. We will not use the upgrade wizard but rewrite the whole system piece by piece. My question is: Do will still use the above setup for a .net application or is it different Do we need a data layer anymore Thanks, Ivan You will probably still want a data layer. Just how much of one depends on the complexity of your data sources. I've used the MS Enterprise Library i ...Show All

• Smart Device Development Setting the width of the vertical scrollbar of a DataGrid possible?

  Is there a way to set the width of the vertical scrollbar of a DataGrid in C# in NETCF (system.windows.forms.datagrid) I managed to change the width of the VSB by overriding the DataGrid Class. and setting (( VScrollBar )( this .VertScrollBar)).Width = 100; I haven't managed to alter the colors yet though. Edit: Unfortunately the VertScrollBar didn't exist in the compact framework. Edit 2: This solved the problem: VScrollBar v = (VScrollBar) typeof (DataGrid).GetField( "m_sbVert" , BindingFlags .NonPublic| BindingFlags .GetField| BindingFlags .Instance).GetValue( this ); v.Width = 70; You have to call it OnLoad. ...Show All

• Visual C# Inserting a List into a database

  If i have an ArrayList of items all with a different object value like Index(0) is "Hello" and Index(1) is "GoodMourning" how would i got about inserting that to a database...I want to insert the index and the value....the value being "hello" and "goodmourning" just to add, after executing the query, clear the parameters otherwise you will get an exception that there are more/less parameters than what is needed. cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); ...Show All

• Windows Forms Module based system, need advise

  Greetings, I'm new to Windows Forms and need your help/advise on the system that I'm trying to build. My plan is to build a system which would be responsible for managing dynamic modules. Basically system will not have business logic, instead users can download available modules and add them to the application. Each module should be have standard methods/functions which core application can execute. I already created interface called IModule which has all the methods that each module should implement. For example, each module will know how to open configuration screen, what is the current logged in user, etc. What I don't know is how to make sure that each module to implements that interface. Before loading module into the system I want to ...Show All

• Visual Studio How to catch .net 2003/5 solution tree drag and drop event

  I am using EnvDTE to build an addin for .net 2003/2005. I am trying to catch the drag and drop event of the solution tree for both file items and folders. From the EnvDTE module, I can't find anything which is really useful to do this. Also, found that IVsHierarchyDropDataTarget and IVsHierarchyDropDataSource interfaces in the VSIP provide support for drag and drop, but I have no idea to hook them up with the IDE's solution tree so that we could catch the event. Please help on this. Thanks very much. Ivan Hi Ed, I tested your sample code and my code again. I found that you are right that drag and drop a solution item to a project folder and drag and drop an item from one project to another pro ...Show All

• SQL Server SQL 2005 DW and BI Features comparison to SQL server 2000

  Dear all, I am developing a proposal to my company, which is a microsoft select client, for introducing SQL 2005 to a new BI project. The company already has SQL 2000. I would like to have a full tabular format of SQL 2005 DW and BI Features comparison to SQL server 2000 (SSIS, AS, RS). Most of feature enhancement paper has only tell what is new but not tell about what is already existed and how much it is improved (in quality and quantity). Yes, tabular format is more useful. I tried to search through microsoft.com, technet but still cannot find the relavent one. Would you please give me a web link Best regards, CJira Look at the appendices in the SQL Server 2005 Upgrade Technical ...Show All

• Windows Forms Bootstrapper problems

  Hello all, I've been trying to figure out this problem for a while... it should be extremely basic, but I've looked on the MSDN website and in a vb.net book, and still can't find the answer. I've download the .net bootstrapper, but i simply can't figure out (for the life of me) how to use it, or how to change application settings etc. How do i do this! Thanks so much! Sorry for such a dumb question -Robert Are you referring to the VS 2003 bootstrapper here http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnnetdep/html/vsredistdeploy1_1.asp VS 2005 has one built in. ...Show All

• Visual Studio Team System WebTest hangs on redirect.

  I have seen issue with my webtest being hung on redirect. Any idea why this is the case Any work around to the issue Thanks for your help in advance. Thanks, --Will I would like to get more information about this problem if it occurs again. By default there is no timeout for a request. You could set a timeout value on the request that is hanging to see which request in the redirect chain is hanging. Also, if you see this problem again, please note the status reported in the "Test Results" window for this test. Let me know if you see this problem again and we can follow up on it. Thanks, Rick ...Show All

• SQL Server Attribut Key Not Found Error

  I am creating a cube using two tables: Users : UserID PrimaryKey (Dimension) Sources: SourceID Primary Key (Fact & Dimension) When I deployed the cube I was getting the followong errors Warning 1 Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_Users, Column: UserID, Value: 1. Warning 2 Errors in the OLAP storage engine: The record was skipped because the attribute key was not found. Attribute: Users of Dimension: Users from Database: WorkFlowMonitor_3 4 5, Cube: Test, Measure Group: Sources, Partition: Sources, Record: 1. Error 3 Errors in the OLAP storage engine: An error occurred while processing the 'Sources' partition of the 'Sources' measure group for the 'Test' cube from the TestMonito ...Show All