DalekDAW's Q&A profile

• Visual C# Create Excell sheets

  Here is my code (C#.NET) which opens Excell application and creates first sheet in order to write data to it : using System.Reflection; using System.Runtime.InteropServices; using Excel; Excel.Application excelApp = new Excel.ApplicationClass(); excelApp.Visible = true; Workbook book = excelApp.Workbooks.Add(XlWBATemplate.xlWBATWorksheet); Worksheet sheet = (Worksheet)book.Worksheets[1]; How can I create (and open) additional sheets in this Excell application There is next function which I assume adds sheet : object = book.Worksheets.Add(object Before, object After, object Count, object Type) Is this right command Which parameters it get and what object it return, give an example. Thanks This should be what ...Show All

• Visual Studio Team System Is there a way to edit/modified changeset?

  Hi all, Is it possible that we could update changeset using commandline/UI I remember somebody already post this but I couldn't find. Best Regards, You can update the comments but nothing else. The checkin notes, work items, and policy override are fixed once checked in. In the UI, there are several ways to get to the Changeset dialog: History, Diff, Label, Edit->Goto. Cmdline: 'tf changeset 1234'. Note: even though the dialog won't let you edit the work item links, you can always do it thru WIT. (bring up the associated work items & remove the link, or create a new work item and link it to an old changeset) ...Show All

• Visual Studio 2008 (Pre-release) ListBox shows (Collection)

  Hey all, I have a listbox that I am trying to display my data in but I am only seeing (collection). What does this mean Thanks, Dvl Lets say you have a collection of customer objects with firstname, lastname as properties you would do <ListBox ... ItemTemplate={StaticResource dt}> </ListBox> In the resources you would define <DataTemplate x:Key="dt"> <TextBlock Text="{Binding Path=fristname}"/> </DataTemplate> ...Show All

• SQL Server Report Server Windows Service stops running.

  I have a test server running both 2000 and 2005 Reporting Services. Each day I have to restart the Report Server Windows service for the 2005 Report Server. This is the error I get when I try to access the Report Manager The Report Server Windows service 'ReportServer$TSQL4' is not running. The service must be running to use Report Server. (rsReportServerServiceUnavailable) Get Online Help After I start the Report Server Windows service using the Report Services Configuration tool I can access the 2005 Report Manager without errors. The windows service start up type is set to automatic. I can not find why the 2005 version keeps going down. Couple things to check: 1. Windows Event Viewer Appl ...Show All

• Visual Studio Open a new Document

  Hello, I am tying to customize the DSL Tool with own code. The purpose is: when a user double-clicks on a shape another document is create and open to continue modelling... For instance, in a Shape class... public override void OnFieldDoubleClick( ShapeField field, DiagramPointEventArgs e) { //Method witch creates anoter store and serialize it as file in a //specified location CreateDiagram(); OpenDiagram(); // -> I don't know how to do!!! base .OnFieldDoubleClick(field,e); } I think this question is related with the <Language>DocData Class but i don't know how to retrieve it from the ShapeClass Can you give me an example Thank you very much! Rafa Cabedo. Please note ...Show All

• SQL Server How to create table from a view

  Dear all, Can I create a table from a view like Oracle The syntax is something like as the below. create table table1 as select * from view1; Thanks you can perform a bulk insert of a single row and then delete it select top 1 * into table1 from view1 delete from table1 or you can use something like this select top 1 * into table1 from view1 where 1 = 2 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Rants on XNA 1.0

  This is my first reaction when I installed and tried the 1.0 of XNA. To summarize my feeling: it's still 95% for XBox and no nearer to replace the old MDX 1.0. So I decided not to migrate from MDX to XNA though I want to do that very much. I feel like MDX 2 more; amen to MDX 2. The hardest issue for me is the content pipeline, which is very necessary, but the workflow is fixed and it assumes the contents are only built before the program runs. The helper functions wrapping D3DX can only be used with types in the content pipeline. I have to utilize the full content pipeline just for generating something dynamically, of course with significant performance cost. Or I have to write those D3DX utilities my self. Currently I don't have a good id ...Show All

• Windows Forms combobox

  Hello A problem! I am trying to do the tutorial about two tables (master/detail) lookup. but it will not work. Everytime when i changing a value on combobox (child table is updated corectly) but combobox (parent) datasource is updating also. like this combobox list at start 1 test (displaying item in combobox) 2 test2 3 test3 then when i change to "test2" the list will look like this: 1 test2 (displaying item in combobox) 2 test2 3 test3 someting is wrong here! please help. BonnieB wrote: Post the relevant code please. Hi I am doing the binding with designer so there is only code that designer i generating. ...Show All

• Visual Basic Calculations

  This is totally differetent from Access I have got a field's property set to money I need to divide that field by 2(sounds simple) but VB is haven a fit. I am used to me.text1= me.text2 / 2 its saying that / is not defined how do you divide and multiply in VBE Davids Learning You sound depressed, that's not a good thing. It is a learning curve, no doubt. Give it time and you'll get it. You've been getting away with murder back in the VB6 days. You probably got "the wrong idea" from doing that. Bite down and use Option Strict On on all your old projects. I'll pretty much guarantee it, you'll be a better programmer in two months. VB.NET is forcing you to become on ...Show All

• Visual C# Problems with Nullable DateTime Type.

  Hi all, I have a Class with a field called UpdatedDate that is of type DateTime. This field gets populated from teh database, but is possible (90% of the time that it is a NULL value in the database). I have the following statement that is throwing the following exception... Code: r ec.m_dtUpdatedDate = (!objSqlCeDataReader.IsDBNull((int)RecNspInspectionAnswer.Columns.UpdatedDate)) (DateTime)objSqlCeDataReader[(int)RecNspInspectionAnswer.Columns.UpdatedDate] : null; Exception Type of conditional expression cannot be determined because there is no implicit conversion between 'System.DateTime' and '<null>' But if I was to place a ' ' in that same line of code after the (DateTime) such as follows it works fine. rec.m_dtUpdatedDate = ...Show All

• SQL Server When Windows Firewall is ON, SQL Server does not get connected thru TCP

  I am using SQL Server 2005 Express + SP1 on a Windows Small Business Server(SBS) box. The SBS is connected to a client thru LAN. Following are what I gave as IP address and DNS on the server: IP: 192.168.16.2, subnet mask : 255.255.255.0, Preferred DNS server: 192.168.16.2, Default gateway and Alternate DNS Server blank On the client, I have, IP: 192.168.16.4, subnet mask : 255.255.255.0, Preferred DNS server, Default gateway and Alternate DNS Server blank I can ping and connect to either of the machines. If I do a sqlcmd -S "tcp:servername\INSTANCE,port", I get the following error message: HResult 0x80090304, Level 16, State 1 SQL Network Interfaces: The Local Security Authority canno ...Show All

• .NET Development Required field in a Web Service

  Hi, I have created a web service with a webMethod like this : ... public Test InsertTest ( Param param ) ... ... public class Param { [ XmlElement ( "PartNumber" )] public String PartNumber; This field should be mandatory when I generated my WSDL file. But I don't know how to do that. Thank you You do not need to delete the minOccurs and maxOccurs attributes from the element declaration to make sure that the element is required, you only need to make sure that minOccurs is > 0. XmlSerializer framework does not provide full explicit control over the minOccurs and maxOccurs attributes, so you cannot use Xml serializer attributes to set them t ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How to change Model indexbuffer

  I'm currently trying to change indexbuffer of a model with a SetData func, but it remains unchanged... My general task is to draw certains polygons of a model, what i must to to make it I found here topic about how to get vertexbuffer of a model, but i still can't set my indices... Any help would be appreciated :) " omg, there is no indexbuffer in modelcontent, so the only way to make what i want is to follow your advice and make custom draw calls using model class. but anyway i need to GET that indices first and i still cant find the way to make it :/" ModelContent.Meshes[].IndexBuffer Cheers, Leaf. ...Show All

• Windows Forms Text to Screen

  Hello, I need help figuring out how to write text directly to the screen. I've looked at the forums and the online help but still no luck. Any help would be appriciated. Hi, if you want to write the the screen device context you can use GetDC with a value of null to get the desktop device context, then you can draw onto that directly. The following code is an example of how to draw some red text directly onto the screen: using System; using System.Drawing; using System.Runtime.InteropServices; namespace ConsoleApplication1 { class Program { [DllImport("user32.dll")] static extern IntPtr GetDC(IntPtr hWnd); [DllImport("user32.dll")] static extern int ReleaseDC(IntPtr hWnd, IntPtr hDC); st ...Show All

• .NET Development Calling Asynchronous Process in Synchronous way?!

  Hi I have a middle tier library, which manage all the asynchronous calls (number of call depends on parameter value). This middle tier library will be call from a front end form (c#). In usual case, the calling statement in form will be returned immediately just after the call and I have to handle the call back method separately. I don't want to do that. The callback method will be handled in middle tier(this can be done). Also, what I want to do is, to return the calling statement, after finishing all the asynchronous call and the callback method in middle tier. I have put my problem and a temporary solution: MiddleTierMethod() { //say 15 aynch call for (int i = 0; i < 15; i++) { doAsynchCall(i); } //Blocking immed ...Show All