vze2dytt's Q&A profile

• SQL Server Number of charts vary with respect to a parameter

  Hi I have a situation similar to this example - The X Axis represents the Date and the Y Axis represents the number of vehicles sold and the data i need to represent is the type of each vehicle(Line Graph). Hence there should be one graph for each Vehicle type. Is it possible to generate as many Chart Objects in the rdl file dynamically. I tried representing all the lines in a single chart but the since the sales value is varied as an example for a particular vehicle type it shall vary from 10000 to 1000000 and for another it varies from 10 to 100. So one vehicle type gets represented clearly and the other looks like a straight line. ...Show All

• .NET Development Problem using @@IDENTITY when connecting to Access XP HELP project deadline looming! VB.Net Visual Studio 2005

  Hi i have read loads of other threads. But none solved this problem. I want to return the correct identity after a bindingsource.addnew command. So i do a tableapdater.update. It always returns 0! after the update call. Maybe the connection.closes. I use this inline in a function called New Estimate. Private Function EstimateNoNewID() As Integer Dim newId As Integer = 0 Dim idCMD As New OleDb.OleDbCommand( "SELECT @@IDENTITY FROM Estimates" , EstimatesTableAdapter.Connection) newId = CInt (idCMD.ExecuteScalar()) EstimatesTableAdapter.Connection.Close() Return newId 'i ...Show All

• SQL Server SQL Server wont start (after ALTER DATABASE for model db)

  I ran an ALTER DATABASE on my model to move the data and log files. The command ran ok, I have physically moved the files, but SQL wont start now - the error is "... terminated with service-specific error 1814". Anyone know what I can do Whats the detailed error message in the event log HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Permission problems: Need help with CLR credentials

  Hi everyone.... I have made a CLR stored procedure which goes to a shared folder on a remote computer. I am having permission problems when executing the stored procedure. (In case anyone is wondering, I am using the .NET SYSTEM.IO class) I have done the following: CREATE CREDENTIAL myuser WITH IDENTITY = 'mydomain\myuser', SECRET = 'some56*Z'; CREATE LOGIN sam WITH PASSWORD = 'meowPw!a3'; ALTER LOGIN sam WITH CREDENTIAL = myuser; ...(other SQL so that SAM can execute the SP) Now, I login to SQL Server using the new login, and when I try to execute the CLR stored procedure, I get "unknown username or bad password.& ...Show All

• Windows Forms Show a txt file in a Textbox

  How can I show a text file in a textbox I mean for example if I have a textbox in my program and I have a txt file in my computer and in the txt file writes "Hello" . I want a person to see "Hello" in my program's textbox when he/she opens my program. Like this:          private void Hello()         {             textBox1.Text = "Loading..." ;             Application .DoEvents(); &nb ...Show All

• Visual Studio Express Editions fatal error LNK1104:cannot open file 'user32.lib'

  hallo, i got this error after building my source code: fatal error LNK1104:cannot open file 'user32.lib' i've seen a similar thread but i still can't solve the problem. I folowed all the instructions from the video on installing the PSDK. What can i do Pliz help!! 1. Have you installed the Microsoft Platform SDK 2. Have you added "...\Microsoft Platform SDK\Lib" to the list of Lib directories under Tools->Options->VC++ directories->Library files ...Show All

• Windows Forms How to Print all controls on Windows.Form

  I have a Windows.Form which contains a lot of UI controls ( textbox, custom-made controls, grid).  Is there a way to print all the contents of this Form I need a solution for print preview and print. Thanks, Joy. Have you recieved anything in regards to this  I have a requirement to do the same thing. ...Show All

• Visual Studio create report with 2 dataset (download project code)

  hi i have a project with 2 dataset, with no join please download this at: http://209.227.215.245/Prenotazioni/ExampleReport.zip this project send me an error: Error    1    The Value expression for the textbox ‘Descrizione’ 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.    C:\Documents and Settings\Administrator\Impostazioni locali\Dati applicazioni\Temporary Projects\ExampleReport\Report1.rdlc    ExampleReport please who, can repair me, this problem and run t ...Show All

• Visual C# Allowing a particular class in other namespace to access a method non public method of a class in other namespace

  Could in any way I can enable a particular class in other namespace to access a method(non public) of another class in other namspace That is suppose I have a namespace1 with class1 and a namespace2 with class2 class1 contain a method named OnlyAccessibleByClass2 Could I do it You cannot directly access it, bcoz it is not a static class nor a static function So, in namespace1.class1 , you have to create a object of namespace2.class2 then you can access the OnlyAccessibleByClass2 Function. ...Show All

• Visual Basic need to seperate field into first, last, middle initial

  I have a field with last name, first name, middle initial, second first name, second MI, Title. I need to seperate these out to seperate columns. I have done it in 25 queries in access. Is there an easier way If you have them in VB, then you can seperate them using regular expressions.  If you want to do it within the database, you should ask in the SQL forums.  <edit> Let me clarify: if you want to pull the data into VB and then store it again, you can use regular expressions.  If you want to write a stored proc, so the data gets manipulated entirely by SQL, then you need to ask in ...Show All

• .NET Development COM+ Application Hangs on Windows 2003

  We have a COM+ application written using .net framework 1.1 the, this application is accessed by a group of asp.net web services, When deploying the application to win 2000 and IIS 5 the application runs smoothly (fast response and low memory usage), but on win 2003 and IIS 6 the application hangs (stops to respond) after few minutes with no exceptions thrown, we generated a memory dump for the process after it hanged and analyzed it using Windbg, the hanging analysis gave “Probably caused by: comsvcs.dll ( comsvcs!CPool::Get+bb )” probably this is caused by the COM+ pooling, also form reviewing the stack trace we saw that the OLE32 mo ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. I cant Install Directx 9.0c December 2005 dsound.inf problem

  When I try install Directx 9.0c December 2005 Redlist I Envisage with this Error : "An internal system error occurred. Please refer to DXError.log and DirectX.log in your Windows folder to derermine problem." I several time download Directx 9.0c December 2005 and November 2005 but everytime I Envisage with this error and when I go to DXError.log and DirectX.log see this Problem with dsound.inf : -------------------- [01/05/06 01:40:11] module: dsetup32(Sep 28 2005), file: setup.cpp, line: 6443, function: CSetup::InstallDirectXInfsFromInfSection     Installation of 'C:\WINDOWS\System32\DirectX\DX113.tmp\dsou ...Show All

• SQL Server send email

  I have a table with email addresses of the customers. How could I send them emails from my tsql script. TIA.. Hi   If i want to do a HTML email like below what should i do exec sp_send_cdontsmail 'someone@example.com','someone2@example.com','Test of CDONTS','It <b>works</b>'   ...Show All

• SQL Server Authentication Extension - Permissions

  Hello all, I've implemented the custom Forms security extension and I can successfully log on to Report Manager and share cookies with an ASP.Net application. However, I'm getting the following error message when I try to deply from VS 2005 and when I claunch Report Builder: The permissions granted to user '' are insufficient for performing this operation Anyone come across this before Thanks in advance. chucho If you haven't already please review the july 2006 sql server sample forms authentication. Focus on the authentication extension/logon user. You need to return false to force ...Show All

• Visual Studio Team System Who can build?

  Who can build How can I limit who is able to launch a Team Build (a build task) It seems that most any user that can browse the list of build types, can invoke it. Thanks! Khushboo has a detailed description of the permissions in Team Build. The blog entry is Team Build Permissions  ( http://blogs.msdn.com/khushboo/archive/2005/11/09/490743.aspx  ). To answer your question, accounts with 'Start a build' permission on the team project will be able to launch a build. Thanks, Amit ...Show All