Melissa H.'s Q&A profile

• SQL Server Cross-tab query in SQL Server

  I have a table with results from several inspection tests. The Pass/Fail parameter in the cross-tab output would be Pass if all tests for that serial number are Pass, and Fail if any of the results for that serial number are Fail. How would I create a cross-tab query in SQL Server Table for input to cross-tab query: [Inspection Data] SerialNumber ParamName Result Pass/Fail 001 Test1 3.43 Pass 001 Test2 3.27 Pass 001 Test3 2.97 Pass 002 Test1 2.88 Pass 002 Test2 3.01 Pass 002 Test3 4.22 Fail 003 Test1 3.11 Pass 003 Test2 2.91 Pass 003 Test3 3.28 Pass Cross-tab Query Out ...Show All

• Visual C# create duty times from the DateTimePicker

  I have a DateTimePicker which shows a date only dd/mm/yyyy and I have 6 DateTimePickers shows the times like the follwoing: Today_Date_Is = 09/03/2006 Date_Morning_Start = 06:00:00 Date_Morning_End = 13:59:59 Date_Evening_Start = 14:00:00 Date_Evening_End = 21:59:59 Date_Night_Start = 22:00:00 Date_Night_End = 05:59:59 So how can I create a date time to use in the SQl statement Hello Jassim Rahma wrote: So how can I create a date time to use in the SQl statement This depends on how will you pass the date in your Sql statement. 1-If you'll pass it as a test, simply convert it to text using ToString() method, and beware of injection attacks in your code. 2- If you want to pass it ...Show All

• Windows Forms Application Open Twice, Error on Load

  I have a weird scenario in one of my clients. When I open the application there is an exception, see details in the end. Then I close that window, and open the application again this time the application is loaded with no exception. Do you have any Idea. ps I have another client he has no problems at all. Details: PLATFORM VERSION INFO Windows : 5.2.3790.65536 (Win32NT) Common Language Runtime : 2.0.50727.42 System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200) mscorwks.dll : 2.0.50727.42 (RTM.050727-4200) dfdll.dll : 2.0.50727.42 (RTM.050727-4200) dfshim.dll : 2.0.50727.42 (RTM.050727-4200) SOURCES Deployment url : file:///C:/Documents%20and%20Settings/Administrator/Start%20Menu/Programs/Softwear%20Suit%20Lt ...Show All

• Visual Studio No OLE DB Providers

  Hello   I'm having a problem when I want to make a new report on my PC. When I'm asked to choose the data for my new report, I double click on "OLE DB (ADO)" to choose the provider and to configure the connection. But the list with the Providers stays empty. When I try this on my Laptop, I get a list with providers. We work with Microsoft SQL Server 2000 but I also installed the 2005 version that was dilivered with the VS2005 on my pc. (but I dit that also on my Laptop) When trying to solve the problem, I reinstalled the mdac of Microsoft SQL Server 2000. Repared the installation of Visual Studio and reinstalled the Crystal reports in Visual Studio. When I create a report on my laptop and open it on my pc, there ...Show All

• SQL Server analysis Backup problem

  Hi guys, Im having problem in backing up my Analysis Database...Below is the error... "The semaphore period timeout has expired" Anybody who encountered this problem...Please let me know... thanks, Larry If you see this problem persisting please report it at Connect ( http://connect.microsoft.com/sql ) Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. ...Show All

• Visual Studio 2008 (Pre-release) DLINQ - "Column referenced is not in scope: "

  Hi Guys, I get this error when ever I walk over a table in the object model with out projecting it and then perform a select. IE This query works. var myQuery = from student in Data .Students                          where student.ID == studentID                          select new                          {             ...Show All

• Software Development for Windows Vista 2PC using MSDTC behaves differently on one/two computers

  Hi, I have the following problem... I start a transaction within one process proc1 (by creating a new TransactionScope) and enlist a custom IEnlistmentNotification implementation. Then, using .NET remoting, I call a method on a remote object (another process proc2 ) and pass the current Transaction to it. This method creates a new (nested) TransactionScope using the passed Transaction and enlists another custom IEnlistmentNotification implementation. After completing bot scopes I can observe different behavior depending on whether the 2 processes run on a single computer or on two different computers. (1) on one comp: The Prepare() method of the proc1 is called and in parallel Prepare() of proc2 is called as well. (this is also my desired ...Show All

• .NET Development 8 byte Guid’s with .NET

  Hello folks, is there a possibility in .NET to generate 8 byte Guid’s Or do i have to generate them on my own Thx for your replies. Kris Hi, the first reason ist the security. They must not be predictable. The second reason is, that, with for example a range from A to Z and 0 to 9 and 20 digits i have a bigger range (more combinations) than with auto increment from database. I think so at least.. and my database table will have many records. Greeting from Germany, Kris ...Show All

• .NET Development Rename table in database....?

  I have access database with one table caled Table1. I draged the table to form2 an VB made dataset,bindingsource,... Is there a way to change the name of the Table1 in the database in code There is Alter Table command but I couldn't find rename or something like that. Please help. Jet DDL does not support the renaming of a Table. I believe that this can only be accomplished through the COM DAO (and possibly ADOX) library. ...Show All

• Visual Basic Printing in VB.NET

  Does anyone know how to print i vb I have information some textbox on a form which i want to send to the printer. you cant use a streamreader on a textbox, streamreader reads streams/IO not a UI control. so what you would need to do is replace fileToPrint as System.IO.StreamReader with: Dim textToPrint as String then here: fileToPrint = New System.IO.StreamReader(TextBox1.Text) should be: fileToPrint = Me.TextBox1.Text then in your printpage event, change the code to this: While count < linesPerPage line = Me.textToPrint If line Is Nothing Then Exit While End If yPos = topMargin + count * printFont.GetHeight(e.Graphics) e.Gr ...Show All

• Visual Studio 2008 (Pre-release) Issues with generating .net 2.0 client for consuming a WCF service

  hi all, I have created a WCF service and specified message contracts for defining how a request should be sent when invoking a WCF method and also the response. I am using a Windows Service to host the WCF service. The service runs fine and there are no issues with that. The problem is when I try to generate the proxy class (.Net 2.0 client), I am getting a warning as shown below Warning: This web reference does not conform to WS-I Basic Profile v1.1. R2710: The operations in a wsdl:binding in a DESCRIPTION MUST result in wire signatures that are different from one another. An end oint that supports multiple operations must unambiguously identify the operation being invoked based on the input message that it r ceives ...Show All

• Windows Search Technologies What's the Difference between WDS 2.6.6 and WDS 3.0.0 versions??

  Hi, I saw WDS 2.6.6 released after WDS 3.0.0 version, so basically the 2.6.6 is newer. Also wds 3 in the earlier stages was without gui, but now both ver 2 n 3 looks identical, except for the fact the the option to use search companion is absent in the preferences in ver 3.0.0. I'm curious to know whats the difference and which one should I use WDS 3.0.0 or WDS 2.6.6 in my win xp desktop pc Anyway, atleast to know what differentiates them and what is the future of ver 2 will be really appreciated thanks.. Your requests are not falling on deaf ears. We are working on putting together a document that explains all this. We should be done within a few weeks. cheers, Ed ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. AccessViolationExcpetion

  I have a really weird and annoying error appearing. Basically, I'm following the Hazy Mind engine tutorials for XNA, and I can't get post processing working correctly. I get this error occouring An unhandled exception of type 'System.AccessViolationException' occurred in Microsoft.Xna.Framework.dll Additional information: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. This does not always happen in the same place though, if I turn off code optimisation, it happens in the line above. I have run Windows Memory Diagnostic and my memory seems fine. Here is the code public void ResolveAndRender(GraphicsDevice myDevice) { myDevice.ResolveRenderTarget(0); myDevice.SetRenderTa ...Show All

• Visual Studio 2008 (Pre-release) GridSplitter in Style causes NullReferenceException

  The following produces a NullReferenceException; however, if you remove the style and place the contents of the ControlTemplate in the window it works fine. Any ideas on what I'm doing wrong Thanks Doesn't work: <Window     xmlns=" http://schemas.microsoft.com/winfx/2006/xaml/presentation "     xmlns:x=" http://schemas.microsoft.com/winfx/2006/xaml "     Title="Test" Height="300" Width="800">  <Window.Style>   <Style BasedOn="{StaticResource {x:Type Window}}"       TargetType="Window"  >    <Setter Property="Template">     <Setter.Value>      <ControlTemplate TargetTy ...Show All

• .NET Development invoke through command prompt

  Hi, Im new to this, need to know how to execute commands on DOS prompt using C# apps. any info would be appreciated. thanks. abhi See Process class in System.Diagnostics: Here is a quick example: Process.Start("cmd"); You can also add paramter to it like: Process.Start("shutdown", "-r"); You can also See ProcessInfo class for more control over all this. Best Regards, Rizwan aka RizwanSharp ...Show All