Mark Melburn's Q&A profile

• SQL Server What is the best way to dynamically change Server or Database name inside a sp?

  To be clear: You have a store procedure and inside you make Updates or Inserts against another Server. But that name can change and I dont want to change it manually in everyplace. Per example: SELECT * FROM Himalaya . DBName .dbo.tblUserGroup WHERE fldUserID = 7300 I have several Selects, Updates and Inserts pointing to that server. What I can do if I want to change from Himalaya server to another server The same with the Database Name. Thank you Hi, the way to achieve this is to use dynamic SQL. Setting the dynamic SQL string in the procedure and executing it either via sp_executesql or EXEC(@Statement). HTH ...Show All

• SQL Server Still a problem with Report Refresh Icon

   In my installation of RS 2005 when I click the Refresh Icon on a report the report doesnt update. But when I click the "View Report" button it does. For example, if I change the parameters on the report and click the refresh icon the report seems to flicker as if it was rfreshing but the report data remains the same, even the paramaters in the report remain the same (I have the parameters that are selected in the report header) Anyone have the same problem or know the solution Reports are cached within Reporting Services, clicking refresh just reloads it from the cache. Only by clicking on 'View ...Show All

• .NET Development How to fill a textbox in a website application in VS 2005

  Hi, How can i fill a textbox with a tablefield that’s in a sql server. I only can explain in Delphi pascal it looks like this: Begin Edit1.Text := adoquery1.fieldbyname('a field').asstring; end; Thanks a lot for the help. I 'am really a VS noob but willing to try. Grtz Dipsy. Well, first you need a datasource, then you will have a table you can access. edit1.Text = myTable.Rows[0]["columnname"].ToString(); Something like that. You can reference columns by index or name. ...Show All

• Visual Studio Team System Error on Work Item reports details

  I create a Team Project with MSF for CMMi Process. When I go on the reports services portal (ie : http://myserver/reports/ ) and I browse all reports for my project, I see a Work Item reports. This reports executes correctly, but when I want to show details on a proposed Work Item (clicking on the ID), I have this error : TF51300: Either access to the database is denied, or the item does not exist. does anyone had this problem any idea to solve it I tried to create a new project with Agile and all is OK. So I search in the TFWWarehouse DB and I found that there were old work items linked to a team project that I deleted with TFSDelete ...Show All

• .NET Development DataSet Location

  where is the dataSet been saved is it on the client's computer thanks in advanced. Hi, What do you entirely mean by "Where is dataset saved " A dataset object resides in the memory. Its an in-memory representation of your database. Any changes you have made to the dataset is not reflected to the underlying datasource. You must manually call an update statement of an adapter to send those updates to the source... cheers, Paul June A. Domag ...Show All

• Visual Basic Btn nothing Event

  I have a WForm with a button, this button pulls up a word document when a letter is chosen...great......now if a letter is not chosen and i click extract i get an unhandled exception error...any ideas on how i can solve this...so that when a letter is not chosen and i click extract a message box will come up and say no letter chosen....... thanks i got the app running now...All i need to do is get my code right so i can input the policy number in the PolNmber.Textbox...then hit extract and it comes out through my Word 2002 field called <<PolNum>> ...Show All

• .NET Development Ping SendAsync() not releasing resources or GC'ed bug?

  System.Net.NetInformation.Ping after doing a SendSync() does not appear to be releasing resources or being Garbage collected. Am I missing something here or is it a bug Using a memory profiler and seeing and application that does a lot of pings grow with out bound I am seeing that the async does not let go. It there anything I can do about this A simple test case is creating a form with a couple of buttons: // do a ping private void PingButton_Click( object sender, EventArgs e){     ping = new Ping ();     //ping.Send("mymachine");    ping.SendAsync( "mymachine", ,null); } // wait for d ...Show All

• Visual Studio Crystal Reports and the VS IDE (toolbar align lefts, rights, etc..)

  Why, when designing a report, the toolbar with Align Lefts, Align Tops etc is greyed out, but right-click align lefts does work Anyway to add those features to a toolbar in the IDE Carl Hello Carl, It looks like our report designer doesn't support the Layout tool bar.  I'll try to find out why, but since it is a low priority it may take a while to get an answer. Keith - Business Objects ...Show All

• Visual J# java.lang.Math.hypot J# equivalent?

  I'm a total newbie to J#, I'm a C# and VB.NET programmer. I know a bit about Java, but not at a professional level, and I need to convert a Java program to J#. The part that I'm stuck on is I need to find a J# equivalent method of: java.lang.Math.hypot Any ideas Also, I need to have the same exact results, not a result that is "close enough and will suffice." Thanks:) java.lang.Math.hypot(x, y) is identical with System.Math.Sqrt(x * x + y * y). CLR handles Infinity and NaN correctly. ...Show All

• .NET Development creating Sockets

  Hi buddies, I wonder how easy to create a socket with out connecting to RemoteEndPoint in sockets My idea is to create a “dummy” socket of an existing socket. I wrote code like, System.Net.IPAddress ConnServerIP = IPAddress.Parse(s_myLinOldIP.Substring(0,s_myLinOldIP.IndexOf(":"))); int listenPort = int.Parse(s_myLinOldIP.Substring(s_myLinOldIP.IndexOf(":")+1,(s_myLinOldIP.Length - s_myLinOldIP.IndexOf(":"))-1)); Socket sk = new Socket(AddressFamily.InterNetwork,SocketType.Stream,ProtocolType.Tcp); IPEn ...Show All

• Windows Forms Have a question about TrackBar?

  hi, everyone :) in vs.net2005 C#, How to sets the TrackBar Control style and looks like Windows MediaPlayer9 thanks. ...Show All

• SQL Server How to integrate reports into java application

  Hi, I am currently using the Business Intelligence Management Studio to design my reports but how am i going to integrate into my java application For example: I do a search for a transaction on May 2005 and then it will return the search results to me, in which when i click a button, it will generate a report/chart out. Have any of you did it before If you do, then can you all guide me Thanks. Rgds, Celine We've made a little java http-client, wich requests a report from the Report Server via url-access, the report server sends the report as a pdf and the client shows it via Acrobat Reade ...Show All

• Windows Forms Control Initializer Disappears from Designer

  I've got an app written in C# in Visual Studio 2005. On one of my forms, I have a user control that contains some user controls and ListViews. For some reason, nearly every time I move off of the form's design view and back, or build the application, the initialization line of code in the designer disappears. I get either a null reference exception, or on the designer I get "The variable 'fltrOrganization' is either undeclared or was never assigned." The line that is being deleted is this.fltrOrganization = new OrganizationFilterPanel(); If I retype this line into the designer code behind, the form will come back up, and allow me t ...Show All

• Visual Studio Team System Find Changesets

  How do I go about determining which changesets were created between two dates Is there a web service that can supply this information for me Michael, The VersionControlServer object in the client OM exposes the method QueryHistory which returns an array of changesets for the specified item. If you provide $/ as the item and specify the date range, it should return all changesets that were checked in during that time period. You can also scope this to a particular team project or folder by specifying the full server path to the folder. This blog entry has an example of how to retrieve the VersionCon ...Show All

• Visual Basic Arrange Shape on Form in VB 6.0

  I want to use shape control on Button Control, but when i use it, it was create back side of Button. how can i bring shape front of Button Help me soon. Thanking u all. Sorry this forum is not for vb6 questions you might want to try one of the vb6 newsgroups . ...Show All