tonyl1956's Q&A profile

• SQL Server SQL Task - passing parameters

  Hello, I have a SQL task wich executes the following statement on a OLEDB connection (SQL 2005 DB): TRUNCATE TABLE DimTime GO DECLARE @CurrentDate AS Datetime DECLARE @EndDate AS Datetime SET @CurrentDate = '10-20-2003'; SET @EndDate = '10-20-2005'; while(@CurrentDate < @EndDate) begin INSERT INTO DimTime SELECT DATEPART(month, @CurrentDate) AS MonthNumberOfYear ,DATEPART(quarter, @CurrentDate) AS CalendarQuarter ,DATEPART(year, @CurrentDate) AS CalendarYear ,dbo.GetSemester(DATEPART(month, @CurrentDate)) as CalendarSemester ,DATEPART(quarter, @CurrentDate) AS FiscalQuarter ,DATEPART(year, @CurrentDate) AS FiscalYear ,d ...Show All

• Windows Forms Error Message of the day

  So my version of Whidbey just crashed no worries there .. but Fantastic error message.. I think it is trying to tell me something about my code. ;-)  See the end of this message for details on invoking  just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.Exception:  FINAL EXCEPTION ... ALL WENT WRONG    &n ...Show All

• Windows Forms Yes! Another DataGridViewComboBoxColumn Question!

  I'm sure everyone here is overjoyed!   Here's my problem. 1)I fire off a query and fill up a dataset, grab a datatable out of and bind it to a DataGridView object.  I'm not using any of the visual tools doing it all by hand. One of the columns in my dataset is an integer field called "status".  it has a value from 0-3. nothing fancy. I then fire off a second query and fill another datatable with textual values of what these statuses are.  examples: "low "priority" up to "high priority". with a range of 0 to 3 which corresponds to my integer value i have saved in my other table. I then create a DataGridV ...Show All

• Visual C# C#.net or VB.net

  I am beginner for .net programmer. Just want to know which one is better on marketing VB.net or C#.net I heard big companies more like c#.ner than vb.net thanks. Hi , I am beginner for .net programmer. Just want to know which one is better on marketing VB.net or C#.net I heard big companies more like c#.ner than vb.net thanks. ...Show All

• SQL Server SQL 2005 Database Mirroring - AD required?

  Hi, for SQL 2005 - to set up database mirroring, is it required to have Active Directory installed or to be part of a domain I am looking to use a workgroup with the SQL machines only and to not reference any domain and cannot find this information - is this possible This is primarily because the domain controller is Novell eDirectory. I am aware of Microsoft's SFN, but would like to not have to use it or any AD if at all possible. Thanks and Regards, James Has anyone answered this question I am also interested in using workgroup accounts opposed to AD accounts if possible. ...Show All

• Windows Forms Determine mouse XY coordinates for double-click

  The DoubleClick event for a DataGrid is just using the basic EventArgs and not MouseEventArgs. That makes it kinda difficult to determine <em>where</em> it happened since you don't have the coordinates to perform a HitTest check. My MouseUp event is already used to performed a full row selection, so what's a possible go step to solving this ...Show All

• Windows Forms read CSV or an easy way to convert to Access

  I have to import files into a database, and i have that capability but i would like to do some checks before this takes place, such as verify that the appropriate columns are present, verify that the number of rows are a certian number, make sure there are no blank rows all just to make sure the DTS import goes smoothly and if not i ...Show All

• SQL Server URL rending vs embedded reports

  Hello, We have an intranet app which is created by a group of developers. The app has buttons to invoke reports. They don't want to embed rdl files into Web app but want to render reports using the url and passing the required parameters. Since none of the people in our team is expert in Reporting Services I would appreciate some advice on the following: 1. Is the url rendering easier than using embedded reports when it comes to deploying and maintaining the reports 2. How about the security Firewalls etc How to impletement the security 3. Which account should these reports be run under e.g. local system account or domain accou ...Show All

• Visual Basic OleDbDataAdapter does not update

  Hi,  I am having a a problem geting a data adapter to update a recordset.  This is the steps.  I added a connection and an data adapter to a form.  The data source is a Access table.  The table has 8 columns.  I selected 2 of them and added a criteria to limit the number of rows selected.  I then generate a dataset.  In my code I call the .Fill method to populate the dataset.  I iterate through the table in the dataset modify one column of every row.  I have verified that there are modifications by looking at the rowstate property and there are modified rows.  I then call the .Upd ...Show All

• Visual C# Changing Item Height of ListView

  Hi, I'd like to change item list height of ListView. If we set DrawOwner property to ture, we can customize as we like. But I can't find Height propert for item list. Can I change or not Best Regards, ...Show All

• .NET Development Create a new database

  In VB 6 you could use the VisData application to create a new database for use on a local machine or on a remote server. What tool is available in Visual Studio 2005 to do the same thing. I have found the Server Explorer, but could not create a database as described in the online help that came with Visual Studio. Thanks for the help. Richard B. Oberholz Hi, Are you using SqlServer Express If so there is a management tool that's freely available. From there you can create your own databases. SqlServer Management Studio cheers, Paul June A. Domag ...Show All

• .NET Development .NET Framework & AIX

  Hi, Does anyone know if the .NET framework is available for aix   I know there is at least one other software package, mono, which works on unix but it doesn't offer an aix version.  Any help would be appreciated. Cheers Alistair The Microsoft .NET framework is only available for Windows.  However, you can download the Shared Source CLI , which is based on the v1 .NET framework and compiles on Windows, FreeBSD, and Mac OS X. -Shawn ...Show All

• Visual C# Permutation

  Once again, I know this isnt a math class, and I completely understand if no one would like to help me but I still have questions. Basically, I already know how to make a program that lists all the different combinations of a set of numbers. You know, like if I have 6 numbers. the combinations would be as follows: 0, 1 2, 3, 4, 6, 5 0 2 3 1 5 6, 0 5 3 2 1 6 and so forth. Basically, I need to know how to is, say if I have 3 numbers, and each number can be 1 - 9, how would I get all the different combinations with that range. Like as follows: 1, 0 , 1 1, 0, 2 1, 0 3, 1, 0, 4 and so forth. can someone help me. H ...Show All

• SQL Server I hate this

  I'm migrating a fu... dts to SSIS. That's fine. I've got a derived column task for stuff as cdbl(DTSSource("Col014") /100). But how the source plain file have a lot of columns suddenly I find this: Function Main() Fecha=Right(DTSSource("Col014"),2) & "-" & Mid(DTSSource("Col014"),5,2) & "-" & left(DTSSource("Col014"),4) If IsDate(Fecha) then DTSDestination("FechaOp") =Fecha Else DTSDestination("FechaOp")=null End IF Main = DTSTransformStat_OK End Function So that 'Derived Column' is useless at all for to encompass this rule unless t ...Show All

• Visual Basic Debugging: Not showing updated forms

  I have a problem with my application. On Design view I add elements to the form, e.g. buttons, textboxes or Code View e.g. editting codes etc. anything... and use the debugger, the objects and changes dont show up. It still stays the same as before, and i cant see any changes to my program. When I start a new project, everything is back to normal! Has anyone got an idea as to what has happened I'm using Visual Basic 2005 Express Edition thanks! Hi Mendi, If there are build errors in a project, you have the option of running with the last "good" version of the code. Is it possible this is hap ...Show All