john smith's Q&A profile

• SQL Server How can I make a Matrix Transposition in SQL ?

  Can we do matrix transpose (rows become columns and columns become rows) in standard SQL 1 2 3 4 5 6 7 8 9 changes to 1 4 7 2 5 8 3 6 9 how about the situation when no of rows <> no of column let's consider the no of rows it's fixed and known before running the SQL statement. thanks. What do you mean standard SQL   Here is a 2005 version that will rotate your data (it is not as elegant wit ...Show All

• Visual Studio CreateToolWindow2

  Does anyone have any code examples (C#) on how to use CreateToolWindow2 method Sorry to bring this up again... I want to create a toolwindow and place a usercontrol in it. So far, the CreateToolWindow2 method would work, if I want visual Studio to create the usercontrol (I think it uses reflection). But in my case, I already have the usercontrol instance and I just want to pass e.g. the reference to the toolwind ...Show All

• Visual Studio Express Editions Create A Link

  How do I create a button that links to a certain webpage. I have been trying and haven't quite figured out. Please help! ...Show All

• SQL Server stored procedure that performs a search is too cumbersome

  Hi I am new to this forum. I have a stored proc that conducts a search based on a number of parameters entered by the user. The way I am currently building the procedure is the following, this is one segment of the if/else structure: ------------------------------------------------------------------------------------------------------------------------------ --If latitude, longitude or distance are null and ProjectID and AnalysisTypeID are not ...Show All

• .NET Development Error while sending email using ASP.NET 2.0 Beta 2 (Visual Studio 2005 Beta 2)

  While trying to send email using <code> SmtpClient obj_SmtpClient = new SmtpClient (); obj_SmtpClient.Host = "" t; obj_SmtpClient.Send(s_from, s_recipients, s_subject, s_body); </code> I get the error message: Failure sending mail. Unable to connect to the remote server An established connection was aborted by the software in your host machine at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, So ...Show All

• Visual Studio 2008 (Pre-release) Custom ServiceAuthorizationManager

  Hi, In Feb CTP I tried it : ServiceHost host = new ServiceHost ( typeof ( Hello ), " http://localhost:9090/Hello "); host.AddServiceEndpoint( typeof ( IHello ), new BasicHttpBinding (), "" ); host.Authorization.PrincipalPermissionMode = System.ServiceModel.Description. PrincipalPermissionMode .Custom; host.Authorization.ServiceAuthorizationManager = new AuthorizationDomain (); host.Open(); public cla ...Show All

• Windows Forms Egg timer when hovering over my picturebox

  I have a few picture boxes in my app. Whenever I position the mouse cursor over the top of any of the images, I get the egg timer as If it's doing something. It's not stopping my app from working or anything, I just can't work out why. Anyone else had that before Thanks ICW ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. D3D Sprite Object

  Hello everyone, I've been using the D3D Sprite object to create a simple sprite based game.  Everything was going accordingly until it came to scroll the camera.  After trying many implementations and reading conflicting resources I've come here asking for help. My objective:  Center the camera on an object that moves around the world.  The problems: Setting the device.Transform.View matrix does nothing. Setting the sprite.Se ...Show All

• .NET Development dynamically setting the SelectParameters of an ObjectDataSource

  Is it possible to dynamically set the SelectParameters of an ObjectDataSource control in the code behind I know this can be done if you handle the ObjectDataSource’s Selecting event. i.e Protected Sub odsReportList_Selecting( e ………. ) Handles odsReportList.Selecting e.InputParameters("reportGroup") = "Expenses" End Sub However, I want to do this in other functions and event ...Show All

• Visual Studio Express Editions App. performance degrade 2003 -> 2005

  After converting my project from VC++ 2003 to 2005 Express and rebuilding in release mode, I've found that my application's performance has dropped by about 25%. I reviewed all of the project's optimization settings to make sure that nothing got set wrong during the project conversion. I reviewed the documentation for optimization settings differences between VC++ 2003 and 2005, and made sure that I am using appropriate settings for speed ...Show All

• Visual Basic convert point to comma in .net

  hi my questions about in vb.net i want to convert point to comma Which using method or property Assuming VB 2005 and that you have a string variable: NewString = OldString.Replace(".", ",") ...Show All

• Smart Device Development removing a selected text from textbox

  hi, could someone please tell how to remove a selected text in a textbox textBox1.Text.Remove(textBox1.SelectionStart, textBox1.SelectionLength) doesn't seem to work... i've managed removing the text by using the string.substring() function... still, there should be a more efficient way to do this... ...Show All

• Windows Forms who do i capture events from a user control

  Hi, and thanks in advance I have created a simple control with a comobox and a listbox the two interact together based on there selecteindex change event. My problem is that when i place this usercontrol onto a form i am unable to capture the&n ...Show All

• Windows Forms Listview Items Checked

  Using VS 2005 C#   I have a listview with CheckBoxes = true. I want to be able to extract the current index when the CheckBox = true Can anyone show me how  and where to code this- thanks   Not sure what exactly you need but here is how I would do that. ListView . CheckedListViewItemCollection checkedItems = listView2.CheckedItems; foreach ( ListViewItem item in ch ...Show All

• Visual Studio Express Editions no option for C# in visual Web Developer

  When I create a new web site, it is auytomatically created in VB no screen to choose type of component or to select c# as the language. Any ideas will be greatly appreciated. BTW this is Beta 2 Try the answer from the following post: http://forums.microsoft.com/msdn/ShowPost.aspx PostID=3811 ...Show All