johnny_no1_boy's Q&A profile

• SQL Server Report from prcedure that return multiple recordsets

  Hi there, I am creating a report from a stored procedure that returns multiples record sets. For an example, my stored procedure is as follows CREATE PROCEDURE MYPROCEDURE AS BEGIN SELECT * FROM TABLE1 SELECT * FROM TABLE2 SELECT * FROM TABLE3 END Now lets say I want to create a report that will display the result of the query no 2 (which is SELECT * FROM TABLE2 in this example). How can I do this Is there any way to bind the second record set to the report dataset with out changing the stored procedure I will appreciate any kind of suggestions on this Thanks Moim Thanks Jarret for the answer. I did that earlier , but couldn't get my procedure ...Show All

• Visual Studio Express Editions Is this a bug?

  Here's the code that fills the ComboBox For i = 28 To 167 cmbSelected.Items.Add([Enum].GetName(GetType(KnownColor), i)) Nex t Here's the code to display the items in the Combo Private Sub ComboBox1_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmbSelected.TextChanged Label1.ForeColor = Color.FromKnownColor(cmbSelected.SelectedIndex + 28) 'TextBox so I can see what's happening TextBox1.Text = cmbSelected.SelectedIndex End Sub If I click on the Combo and enter the first color, Alice Blue, then move down using the down arrow on the keyboard each color is diplayed right down to the last color YellowGreen. When get to the last colour and keep going it loops around and the colours no longer m ...Show All

• Software Development for Windows Vista Fault Handler State Workflow

  I try to use the state faulthandler. that works fine, but for me the fault property is disabled ! So I'm not able to trace the exception! some Ideas regards Wolfram Fault is a readonly property so it appears disabled in the designer. you can add a code activity to the faulthandler and assign the value to a local variable e.g. CodeActivity code1 = sender as CodeActivity; FaultHandlerActivity faultHandler = (FaultHandlerActivity)code1.Parent; Exception exp = faultHandler.Fault;     ...Show All

• Visual C# Convert byte array to original string after received data using the socket class

  Hi to all, I've a string that I have to send as byte array (with a networkstream) on the network. I use this method to convert the string to byte[]: byte[] arr = (new ASCIIEncoding()).GetBytes(string) then, on the client, I've to convert the byte array received to the original string, using the socket.receive method. My problem is that I have to pass a byte[] as buffer to the receive method, but I don't know the size of the date I am receiving. So I create an oversized buffer and use it to contain the bytes received. Then, I've to convert my byte[] to the original string, sended from the remote server. I use this method to convert it: string converted = (new ASCIIEncoding()).GetString(characters) The convertion works fine, but the end of m ...Show All

• Visual C# Little Help

  I have figured out how to open webpages, but, if on the button click you open a webpage, say www.google.com. But, if you have a textbot on the program, and on the button click you want www.google.com/i-typed-this-in-the-textbot, how would you go about coding that Thanks usually when the button is on focus and you press enter, it presses the button. Perhaps you implemented a keypress event somewhere causing it to override the default behavior if you are saying that you wish that when the user presses the enter key IN the textbox and you wish to press that button, do the following: select the textbox on designer view. click on events (lightning symbol) double click on "KeyDown" event to generate ...Show All

• .NET Development ServicedComponent RegistrationException - Invalid Derived Classes

  I am having difficulty with code that used to work in 1.1 working in 2.0. I have an n-tier application that uses ServicedComponents for persisting database information within a single transaction. Because I want these classes to be able to participate in transactions, I derive them from System.EnterpriseServices.ServicedComponent. In 1.1, this worked just fine, however in 2.0, when remoting these components using .NET remoting over TCP, I recieve a RegistrationException stating that: Invalid ServicedComponent-derived classes were found in the assembly. (Classes must be public, concrete, have a public default constructor, and meet all other ComVisibility requirements). Since my other project contains 100's of different classes, I created a ...Show All

• SQL Server Predicting from a clustering model

  Hi, I have built a Clustering model that captures customer demographic information and identify various hidden clusters based on the information. What kind of predictions can I make using the above model You can do multiple types of queries with a clustering model: Get the most likely cluster for each case (or a new singleton case) - SELECT Cluster() FROM [model] Get the probability/distance from all the clusters for each case - use PredictHistogram(Cluster()) You can mark columns as predictable and predict those attributes for new cases - the prediction is based on the characteristics of the most likely cluster a case fits into You can do validation and detect outliers usi ...Show All

• Visual C# How to know the byte size of a string?

  Hello Guys, If the string strSubjectLine need to be only 128 byte long. How could I tell the size of the strSubjectLine in Bytes, so I can validate the string and if it is longer that 128 bytes send an message to the user Thanks, PRJUANL C# uses Unicode which is 2 bytes per character so if the limit is 128 bytes you can have 64 chars. You can tell the number of characters in a string by the Length property. You can use other encoding like ASCII to get a character per byte by using the System.Text.Encoding class. ...Show All

• Visual Studio 2008 (Pre-release) DependencyProperty value changed

  Hi, i'm trying to make a custom control and i need to know when a self implemented DependencyProperty has changed. What is the best practice I found the static PropertyChangedCallback method passed when registering the DP and the OnPropertyChanged instance event. Which should I use, or is there an other way to go (ex: overriding an instance method) However best practices say different. Quote from msdn: This method is not intended to generally detect property changes or invalidations. It is instead intended for modifications of the general invalidation pattern if certain information is known about wide classifications of properties. This method is potentially invoked many times during the l ...Show All

• SQL Server Processing a dimension using AMO does not work if the connection to the “DataSource” used is “SQL Server Authentication”

  Processing a dimension using AMO does not work if the connection to the “DataSource” used is “SQL Server Authentication” amoDimension.Process(ProcessType.ProcessFull)   The following exception is returned: -                        ex          {"OLE DB error: OLE DB or ODBC error: Login failed for user ' MyUserId '.; 42000. Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'MyDataBase', Name of ' MyDataBase'. Errors in the OLAP storage engine: An error occurred while the dimension, wit ...Show All

• Visual C++ "Unresolved external symbol" after upgrading to VS05

  Hi All, I have a project that build and worked fine all the way through Visual Studio 2003. After upgrading to VS2005 and rebuilding the two dependent libraries I am receiving a linker error on the parent DLL stating: Error 1 error LNK2001: unresolved external symbol _hInstDLL stdafx.obj Error 2 error LNK2001: unresolved external symbol _hInstGenDLL stdafx.obj There is a common header included in one of the libraries and the parent DLL. All files are C++. I can't get rid of the "extern "C"" section because of legacy stuff elsewhere. That header file contains amongst others the following code: #ifdef __cplusplus extern "C" { #endif extern HINSTANCE hInstDLL; ...Show All

• Visual Studio Express Editions sql insert statement

  I am trying to create a SQL insert statement and I am stuck, If someone can help me. here is my code : Imports System.Data.SqlClient Public Class NewCellTypes Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim connectionString = "Data Source=localhost;Initial Catalog=TESIS;User ID=sa;Password=mypassword" Dim queryString As String = "INSERT INTO FR-DEVICE-TABLE(DE_MANUFACTUREER, DE_ACTUAL_COST)VALUES( , )" '''' Using connection As New SqlConnection(connectionString) Dim command As New SqlCommand(queryString, connection) Dim p1 As New SqlParameter( "@p1" , SqlDbType.Text, ...Show All

• Windows Forms System.Windows.Forms.Timer not firing

  I have a C# Windows application which displays a status window. I'm trying to use a timer to close the window a given number of minutes after a certain message is displayed in that window. I've set up a timer control as shown below, but it never fires. Does anyone have a clue as to why Note that the same thing happens when, trying to emulate examples I've seen, I change the declaration from: private System.Windows.Forms.Timer tmrCloseTimer; to: private System.Windows.Forms.Timer tmrCloseTimer = new System.Windows.Forms.Timer(); Thanks in advance for any help you can give. ***************************************** public class StatusBar : System.Windows.Forms.Form { ... private System.Windows.Forms.Time ...Show All

• .NET Development One WebService, Multiple Classes

  Hello all, I'm trying to create a webservice that has multiple classes in it. I've been programming asp.net pages for a few years now and working with C# since the first day of it's "release" with .net 1.0 but, web the creation of webservices is fairly new to me. I'm now at a point in my software project where several of my clients want to connect to me and get their data via web service. I've created a few sample services but, for each class that i want to expose web methods on i seem to need a seperate .asmx file for. But, in the following example (this is a live site) they have somehow combined all of their classes into one .asmx I can't find a single bit of information anywhere on how I would go about doing this. https://p ...Show All

• Visual Basic Importing Excel files into Visual Basic 2005 Express

  Hi, I'm a complete database newbie so please bear with me! I'm using Visual Basic 2005 Express to create an application which will just list an editable database of stuff, but I don't want to have to enter all the info manually. I have it all on an XLS / CSV spreadsheet: 10 columns and 9000 rows, I just want to import it. But how If your reading the data only you use ADO.NET to read the data as one approach, another may be to export the data to a CSV File and then use something like the TextFieldParser object to process the CSV file or you can access the Excel sheet directly ADO.NET to Retrieve and Modify Records in an Excel Workbook http://support.microsoft.com/kb/316934 READING A COMMA SE ...Show All