scuudz's Q&A profile

• Visual Studio Tools for Office formulae in Excel

  Using VB.net(VS2003) and Excel 9.0 object library, if you want to assign a formula to the cells in a column, can you assign it to the entire column, e.g. xlSheet.Range("A").Formula = "whatever" Or do you have to bypass row 1 if it contains headers: xlSheet.Range ("A" & 2, "A" & rowct.ToString).Formula = "whatever" Or do you have to assign the formula to a specific cell and then copy-and-paste it down the column xlSheet("A1").Formula... etc Thank you in advance. Again, this is a question better asked of the experts in the excel.programming newsgroup :-) They'll know the most efficient way to approach a task of this nature. http://msdn.microsoft.com/newsgroups/defa ...Show All

• Smart Device Development Running an .exe created in vb.net 2003

  I have the windows mobile 5.0 msfp emulator and I would like to know how to run a file myfile.exe in the emulator.. the file I created in vb.net 2003... the emulator is connected properly but every time I tried to run the file it tells me TypeLoad Exception could not load type system.windows.form from assembly system.windows.forms, version=1.0.5000.0 .. What else do I need... thanx :) An .NET CF 1.0 application sould run on the emulator. Most likely your application is not a .NET CF 1.0 application. This exception usually occurs when you try to run a desktop application on your device. Make sure you selected the 'Smart Device Application' template when creating the project in VB.NET 2003. ...Show All

• Visual Studio Express Editions Sensing a system shutdown

  Hi, does anyone know how to make an app do something at shutdown (when the shutdown options menu pops up) Private Sub Form1_FormClosing( ByVal sender As Object , ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles Me .FormClosing If e.CloseReason = CloseReason.WindowsShutDown Then ' Your code here End If End Sub ...Show All

• .NET Development problem with delegation and downloading file from remote server

  Hi all, i'm developing an application which have to list files in a shared folder (remote from my server and not in the same domain) and download the selected files from the list to the client I've used the TransmitFile() method but it have some problem with Windows Server 2003 (remote server with the shared folder) but IIS tell me "Web Application not available" I try with Response.WriteFile(), Response.Redirect() and Server.Transfer() but all this method give me this exeptions "Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack" with no inner exception ...help please!! Does that help: http://support.microsoft.com/default ...Show All

• SQL Server Best way to generate script

  Hi! I have to make a program that copy a database structure. Right now i'm using SMO but it take a lot of time just to copy all tables. Here is what i'm doing: ServeurLocal.SetDefaultInitFields( GetType (Table), "IsSystemObject" ) For Each uneTable In BDConfig.Tables If Not uneTable.IsSystemObject Then NouvelleBD.ExecuteNonQuery(uneTable.Script) End If Next We have over 700 tables and it take me more than 5 min to copy all the tables and i haven't copy all the view and stored proc yet. The problem seems that i execute one by one each script. So i was wondering is there a way to stock all the script in some kind of object and then when the FOR is done execute this big script. Is it possible to create a ...Show All

• SQL Server Oracle OLEDB and dates not matching

  I have a ssas2005 cube built from data in an oracle data warehouse. The Time dimension has begin week dates as a key and joins to the fact table Week Begin Date field. Both are built in the dsv using named queries. The cube built fine until we changed the provider to the Oracle provider for OLEDB. Now the cube build is giving an error : "The attribute key cannot be found: Table: Fact_x0020_Service_x0020_Level, Column: WEEK_BEGIN_DATE, Value: 7/3/2005." on the first record. The dates look the same and the properties look the same. I tried converting the dates to character in the queries and the cube builds - but I have a lot of data missing. We changed the provider because of internal rounding problems throwing the numbers off. Wh ...Show All

• Visual C# Partial class inheriting from another partial class?

  Okay, lets suppose I have three pages - customsearch.aspx This is my main ASP.NET page. Lets suppose it has an asp:Literal called 'warningMsg' - searchtemplate.aspx.cs This is a 'base' class which defines some functionality and methods I want in all 'search' pages. It extends the 'Page' class, obviously. - customsearch.aspx.cs This extends the 'SearchTemplate' class, overriding a few selected methods and adding any custom ones I need. So first off, I do all of this using 1.1 style code behind: (only relevant code shown) - searchtemplate.aspx.cs [code] public class SearchTemplate : System.Web.UI.Page { public Literal warningMsg; //other controls here void Page_Load(Object sender, EventArgs e) { warningMsg.Text = "Page Load ...Show All

• Visual Studio 2008 (Pre-release) Access child elements inside an animation

  Hi, i do the following code inside a Styletrigger: < BeginStoryboard > < Storyboard > < DoubleAnimation To = " 360 " Storyboard.TargetProperty = " (Grid.Children)[0].(Image.Width) " Duration = " 0:0:1 " /> </ Storyboard > </ BeginStoryboard > which raises this exception at runtime: "Value cannot be null.Parameter name: dp" Does anyone knows how to avoid this create a style something like this( you might want to provide CenterX and CenterY for RotateTransform) < Style x:Key = " img " TargetType = " {x:Type Image} " > < Style.Triggers > < EventTrigger RoutedE ...Show All

• SharePoint Products and Technologies SHAREPOINT INSTALLATION ERROR

  Hi, I tried to install sharepoint 3.0 in win 2k3 sp1 with all Req hardware.While installing the setup files are extracted properly.But when i run the configuration wizard,i encounter an error, Failed To Start database service MSSQL$Microsoft##SSEE.Repair this product by selecting it from theAdd/RemovePrograms menu. At this particular step the installation terminates.... I have tried by 1.Uninstalling all related programs and reinstalling 2. repairing the sharepoint package. 3.Even using regedit to remove the installation files of MSSQl ..... Guys plz provide me a solution coz i got fiddled with this installation.....Suggest me what i have to do . i even tried with command line util ...Show All

• Visual Studio Tools for Office Reading an Excel range into Object(,) - 1 based?

  Hi, I've been using something I learned (probably here), but don't really understand what's going on. I read ranges into a variable with the following: Dim mValues As Object (,) = _ CType (Globals.Sheet1.Range(Cell(r1, c1), Cell(r2,c2)).Value, Object (,)) Where I use "Cell" to save typing: Private Shared Function Cell( ByVal Row As Integer , ByVal Column As Integer ) _ As Excel.Range Return CType (Globals.sheet1.Cells.Item(Row, Column), Excel.Range) End Function This works tremendously faster than reading in values cell by cell. When I do this, however, mValues becomes a 1-based array. First, I don't understand what's going on that would make that happen. Second, I didn't think you c ...Show All

• Visual C# Moving from procedural to OO

  I have been coding in C for upwards of 4 years now and a friend of mine has brought to my attention that a lot of employers now want their programmers to use OO instead of procedural. I have gotten a book on Java and 2 on C# (one on the basics and one on network programming), but I must say this OO thing isn't really catching with me. I am still in high school, so I don't have much time on my hands, but do any of you have any good resources on how to relate OO to procedural, or to just make it a bit understandable Thanks its not always necessary but make it meaning and short and sweet. like if we have a private member (variable) called "name" then the property should be "TheName" or "Name". The choice ...Show All

• SQL Server The Value expression

  The Value expression for the textbox ‘Name’ uses an aggregate expression without a scope. A scope is required for all aggregates used outside of a data region unless the report contains exactly one data set....what does this mean...this an error that I have when i try and build my report i get this error for some reason...how do i fix this No, you can use multiple datasets. But when you do, you need to disambiguate which dataset the field reference is from, when that field is used outside of a data region. Ian ...Show All

• Visual Basic how can I delete SQL DB by VB?

  Hello everybody, I’m new to Visual Basic 2005. just learning now. I want to delete MS SQL Database while its running. see my codes. Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Dim SQLConn As New SqlConnection( "Integrated Security=SSPI;Initial Catalog=JJpack;Data Source=(local);User Id=sa" ) SQLConn.Open() Dim SQLda As New SqlDataAdapter( "select * from countrymaster" , SQLConn) Dim SQLDS As New DataSet SQLda.Fill(SQLDS) ComboBox1.DataSource = SQLDS.Tables(0) ComboBox1.DisplayMember = "Name" ComboBox1.ValueMember = "CountryID" SQLda = Nothing ...Show All

• SQL Server Convert tick-by-tick stock price time series data grouped as high, low, open and close prices

  I am working on a stock price analysis project. Stock prices are stored in SQL Server as tick by tick data (that means in a high frequency) and need to be grouped by minutes in order to display them as as high, low, open and close prices in a candlestick or similar chart. The fields in the table are: Time (for every stock price tick) Price (stock price) Symbol (of the stock) A sample time series would look like this: 11:45:01 $22.11 MSFT 11:45:02 $22.10 MSFT 11:45:04 $22.25 MSFT ... ... ... 11:45:58 $22.45 MSFT 11:46:03 $22.22 MSFT 11:46:08 $22.25 MSFT ... ... ... 11:46:59 $22.45 MSFT The result of the SQL query should be: Symbol Time Open High Low Close ...Show All

• Visual Basic Email

  I am trying to email a VB.net form after the form has been published and filled out. Can anyone help take a look at this in the time being: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=616274&SiteID=1 http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1045420&SiteID=1 ...Show All