FrustratedDataAdmin's Q&A profile

• Windows Forms System ShutDown...

  Hi, In my program I need after doing some job to be able to shut down the system. So I wrote that code: public event SessionEndedEventHandler ShutDown; ............ ............ this.ShutDown += new SessionEndedEventHandler(OnShuttingDown); ............ ............ protected virtual void OnShutDown(SessionEndedEventArgs e) {    if(ShutDown!=null)          ShutDown(this,e); } void ShuttingDown(object sender, SessionEndedEvent ...Show All

• SQL Server Working around Temp tables in Reporting services.

  I have been working for days to translate a report out of an old system and in SQL reporting services. Getting the basic code down to get the required data was easy, however getting it to work in reporting services has turned into a nightmare. Why, because I have been told that SQL reporting services does not allow temporary tables...HUH! Ok, so how am I supposed to take three data queries and munge them together into a report. Here is the query that does work, can anyone give me an idea of how to make this work given the limitations I have run up against. I have already thought of using a store procedure, but we have ruled t ...Show All

• SQL Server internal star join strategy

  All major DB vendors have included some special support, in the query execution engine, for handling queries executed against star schemas. SQL Server has had the Star Join. But there isn't any clear documentation of what this star join's internal strategy is. Does anybody know if the star join strategy used by SQL Server is based on the cross-product of the filtered dimensions Does anybody know what are the details of this query execution strategy on SQL Server 2005 Alex ...Show All

• .NET Development XmlWriter namespace exceptions

  Hello, I want to send an XML stream over the network, compliant to the XMPP specification (RFC 3920). Therefore I'd like to send this XML document node: <stream:stream        from='example.com'        id='someid'        xmlns='jabber:client'        xmlns:stream='http://etherx.jabber.org/streams'        version='1.0'> I tried to use this code: streamWriter = XmlWriter.Create(networkStream, writerSettings); streamWriter.WriteStartElement("stream", "stream", "jabber:client"); streamWrit ...Show All

• Visual Studio Team System Frequent incorrect build results - projects skipped that are out of date

  I have a solution with 17 C# projects - two .EXEs and the rest DLLs, including a number of unit test projects. I can't begin to relate how often I run into problems due to incorrect build outcomes - one or more projects were not built even though clearly out of date. I see this sort of thing when running tests from the test manager (which sometimes completely refuses to even try to build anything and just complains that it can't find the output file of the build that it never initiated) as well as other scenarios that should cause a build.  I've checked that all the appropriate dependencies between the projects are specified in the ...Show All

• Visual C# Well Done !!!

  Well Done Microsoft!!! I think The graphics class is the most iritaiting class of all, when u need an object of it you have to do 30 other things to get an graphics object, no offence but if u wanted to make the hardest thing to draw something u really done it, and i`m not talking about Paint Event Why didn`t let the constructor of the graphics class public (maybe u did have your reasons, mabe it was the only way, but heck man u are the MICRSOFT) Anyway, Thanks for the best Language of all A "graphics class" is context sensitive in Windows. Which graphics class would you like The printer, a textbox control, the form, the de ...Show All

• Visual C# C# and MS SQL 2005

  I have 1 table "Uplate"with atributes: UplateID:int Datum:datatime Iznos:int Opis: nvarchar On win-form I have 2 DataTimePickers: dtPoc and dtKraj and in them I select begining and end date. I want to sum Iznos between these 2 dates. So I added query in the UplateTableAdapter: UpitUplate(@Parameter1,@Parametr2): SELECT SUM(Iznos) FROM Uplate WHERE Datum>=@Parameter1 AND Datum<=@Parameter2 and in the main application I call this query like this: int ZbirU = 0; dtPoc.Format = DateTimePickerFormat.Custom; dtKraj.Format = DateTimePickerFormat.Custom; ZbirU= (int)UplateTableAdapter.UpitUplate(dtPoc.Value, dtK ...Show All

• Windows Forms search and display results within a data grid

  Hi, Wondering if someone can help, have form, data grid, dataadapter and dataset in place, can update, amend,fill,view etc from datagrid. However I can't figure out how to search one column, from underlying table, and return results either on screen or to a printable output, Any advise or assistance would be greatly appreciated, Thanks, Clint Actually, I believe I'm looking for something like a SQL query, the db that serves my app in MS Access 2000, I run one table with about a dozen columns, would like to be able to search one of the columns, If I can do that as a query then yes I believe so, ...Show All

• Visual C# Binary.Write in C#

  My impression was that I could use Binary.Write for data other than byte arrays by giving the variable as a single argument of BinaryWrite. But when I do it with a short integer, it gets padded with two null bytes. I don't want this, since what I am generating is a sound file. Is there a way to do this Do you mean "BinaryWriter.Write(...)" That should only write two bytes if you pass it a 16 bit integer. Can you post some sample code that doesn't work ...Show All

• Visual Studio Team System Team Foundation Server MSSCCI Provider Beta 2 Now Available (Feb 20, 20006)

  The Team Foundation Server MSSCCI Provider Beta 2 is now available here . IMPORTANT:   Beta 2 is not strongly signed, so you'll need to disable strong name validation as mentioned in the README.  You can find details at http://blogs.msdn.com/buckh/archive/2006/02/21/536260.aspx . New in this beta: Support for Visual Studio 2003 and Fox Pro in addition to the already supported VB6 and VC6. Integrated Checkin - you can now associate/resolve bugs and specify checkin notes with your checkin Improved performance - opening controlled solutions, get, checkout, checkin, and compare/diff are much faster M ...Show All

• SQL Server Encrypted value shown as '??????' in a column of type varchar

  Dear All, I inserted a record in table on DB created on SQLServer 2005 and found out that the one of the column values is shown as ' ' instead of showing the encrypted value that I sent with the insert statement.3 ............................ Can anyone tell me how to get rid of this Thanks and regards, Z Z. Thanks for your reply. Actually I'm using only one-way encryption and seen these ' ' through SQL Server Management Studio by directly viewing the table contents. ...Show All

• .NET Development .net applications don't run

  Hi everyone! I've got strange problem. For nearly six months I write .net applications in C#. Everything's ok until now. I'm trying to launch my (not only) applications and nothing happens. If it is console applications there is no error message or anything else that could tell me that something went wrong. I just can see prompt again. If it is windows application there is no reaction. In Task Manager I can see my app in process list for a second and then it disappears. I tried to uninstall and install again .net Framework 2.0, but it didn't help. If I run ASP.NET pages via IIS everything's ok. Please, help! Th ...Show All

• .NET Development Null For SqlDBType.Int32 Problem

  Hi! I've field in database of type integer and accepts null. Similarly I declared parameter in stored procedure for insertion. But when I add parameters to command object in C# Express specifically for mentioned above field as SqlDBType.Int, I get error saying parameter can't convert string to integer. When I changed parameter SqlDB type to Nvarchar everything worked fine. It wasted my whole day as I was thinking that I'm doing everything correctly. All the parameters' order and thier types were matching. Container               FieldName      ...Show All

• Windows Forms Mouse Events in a user control

  Is there a way for my user control to receive mouse events instead of its constituent controls  I have a user control to which i added couple of labels with dock property set to top and fill. My user control never gets the MouseEnter or MouseLeave events. Any ideas on this  Thanks. I've already tried that. I also tried to register to  ...Show All

• Visual Studio 2008 (Pre-release) CLS Compliant ?

  In Feb CTP, I find this: public Collection< ToolBar > ToolBarTray. ToolBars { get ; } It seems WPF DLLs will not be CLS Compliant Thanks! I remember that Generics are not part of CLS. Did it changed recently Or my knowledge on it is wrong from the beginning Thanks! ...Show All