Helio Gama Faria Filho's Q&A profile

• Visual Basic Determining whether a record was located or if it is not found

  The following is the statement that I use to select my record(s) from a table: Private Sub Dimension1Goal2_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Try Me .Dimension1_Goal2TableAdapter.FillByTreatPlanID( Me .CCADPDataSet._Dimension1_Goal2, Common.sTreatPlanID.Text) Catch ex As System.Exception System.Windows.Forms.MessageBox.Show(ex.Message) End Try End Sub My "Question" is how do I determine if there isn't a record found Thanks in advance for your help. well you look at the Datatable's Row count property. theDataSet.Tables(0).Rows.Count so in your case, it maybe like... if Me.CCADPDataSet.Tables(0).Rows.Count = ...Show All

• Visual Studio There is no source code available for the current location message box

  Hi, I'm having problems with the debugger. The code was working fine 2 days ago and since yesterday I'm getting a popup window saying "there is no source code available for the current location". It must be a very common problem, since I've seen many posts over the internet related to this message. I'm posting with the source code, so apologies if you find that the post is lengthy. My environment is Visual C++. NET 2003. I also checked the debug source files from the solution properties and checked that there's no file appearing on the "Do not look for these source files" field. I tried to clean the solution, I even tried to create a new project from scratch.... If anybody is kind enough to test this little pie ...Show All

• SQL Server SQL Server CE Replication: Integrity error, but not at all

  Error information: NativeError: 28549 HRESULT: -2147217873 Message: OrdersHeader,Delete,{0503BF00-BB05-11C6-8000-36BC4ADEE342} Description: The row update or insert cannot be reapplied due to an integrity violation. Server side: SQL Server 2000 or MSDE Client side: SQL Server CE or SQL Mobile This error is usually caused because of an error on the filters. But not in this case, i think. I assume it's not a filter error because if I delete the SDF and run the sync it works. The error occurs when I delete some rows in the server (parent( OrdersHeader ) and child( OrderLines ) tables) and the PocketPC stills have this rows. On the next synchronization It seems that replication process tries to delete the OrdersHeader rows before the OrderLin ...Show All

• Visual Studio Express Editions MS Visual Basic 2005 has encountered a problem and has to shut down

  This is an error message I get when I try to start my current project. Before that, I had a message saying that VB had not shut properly previously and it needed to recover some files. I'm pretty sure that the project was closed properly before but I sadi yes anyway. Now, whenever I try to open the project, I get the error message that VB has to shut down and it closes. This must be a VB problem as the solution was running fine before. Any idea on a possible fix I'll be really disappointed if I have to start all over again :( ReneeC wrote: Use Search. There was a long discussion of the shutdown message in the VB IDE forum. I've had a similar IDE crash problem. The trouble is that VBE is ...Show All

• Visual C# How to rewrite URLs like www.website.com/username to .aspx page

  Hi all, How to rewrite URLs like www.website.com/username to .aspx page. When ever a user requests for www.website.com/username   I have to first parse the URL get the UserName part of the URL ,authenticate ( database authentication and UserName is unique for each user)and  fill the current contexts profile with this users info if authenticated and finally redirect to landing page of the site. I researched and found that this can be done by httpURLRewriter module. Can someone pls provide sample code and also let me know if any changes have to be done at IIS level. Thanks, Shilpa Hi, The right forum for this question would be http://forums.asp.net For y ...Show All

• Windows Live Developer Forums Windows Live Seach SOAP API & a search like:www.mysite.com

  Hello, I'm using the SOAP API version, but instead of searching on the web, I need to only limit the scope to 1 site. Can you show me which paramater I have to use to make a search like site:www.microsoft.com by exemple. I can not find it in the documentation... I found it :) It's more simple that I thought. SearchRequest.Query = "site:www.mysite.com" & " " & strMySearchText So simple :) Nicolas ...Show All

• SQL Server Conditional Order by?

  Is there a way to do a conditional order by so that a user can give a parameter to a stored proc and it give back results sorted the way they want I want it so that the user can do 1 of 4 things, * sort by "title" ascending, * sort by "title" descending, * sort by "synopsis" ascending, * sort by "synopsis" descending Can it be done This is what I have but I get a syntax error: select * from Blah Order By Case when @orderId = 1 then title asc when @orderId = 2 then title desc when @orderId = 3 then synopsis asc when @orderId = 4 then synopsis desc end Any help is greatly appreciated! Thanks both for the replies, I didnt know it would be so detailed, I have ...Show All

• SQL Server How to print labels like label 1 of 1 and label 2 of 3....

  I have a report that will be a label and I need to print N number of labels depending on a certain number returned from the query. Let's say that number returned is 3. So, on my first label I want to print 1 of 1 and on the second label, 2 of 3 and the third, 3 of 3. All other information on the label will be the same for all 3 labels. All information used is from the query. One of the fields accessed through the query holds the number I need to use to do this. Is there a way to do that through the report designer using vs.net Is there a setting for this or is it a SQL thing I need to put in the query some how. Or am I completely off track Any help would be greatly apprciated. thanks Owkey this ...Show All

• Visual C# debugger steps through commentlines

  Hi, I'm trying to debug my application, so I put a breakpoint in the area I suspect to be buggy and I run my application. When I hit the breakpoint I step through the code. To my surprise I see myself stepping through lines of comment (and skipping several lines of code as if they were comment). I tried deleting the build files, rebuilding, etc, but nothing seems to work. Any suggestions It is just looks like it goes through commented lines. The problem is that your app use diferent dll assembly that the current code is, so in that lines previously when you build that assembly that your application is using, there were some execution lines. To solve this problem you need to remove your reference and instead of adding assembly as ...Show All

• Visual Basic Lines in the body of an email

  I am trying to do what I thought would be simple (especialloy since it worked like a charm in VB 6 with the mapi control: The program populates a multi-line text box with information based on user selections The user hits a button and it pulls up his email client with the subject and body filled in so that he can select a recepient and send off the information. The problem. The text always comes out as a single line run together How can I get line breaks back into the body The code that doesn't work is: Dim sendthis As String = "" sendthis = sendthis & "mailto:" sendthis = sendthis & "&subject=New Loss for client " & frmMain.Clt & " Number: " & ...Show All

• SQL Server Web Services

  Is it possible to call a SQL Server webservice using a url I have a web service that doesn't take any parameters but can't seem to call it using an http get. http://localhost:8090/TestWS WSDL returns my wsdl. I have a webmethod GetProductsByColor. Thanks ...Show All

• .NET Development c# performance

  I am working on performance tuning for an app. The old code is the following: for(int i=0; i<10000; i++) {     MyClass a = MyClassCollection[ i ]; } If I declare the reference type a outside of the loop like the following, will I get better performance MyClass a=null; for(int i=0; i<1000; i++) {     a = MyClassCollection[ i ]; } It seems to me that there is a performance gain since I am not allocating new memory for reference type a during each loop iteration, but I want to confirm this. Um, actually the generated IL will be semantically identical. All locals are declared in the method header irrespective of where you declare them in the method body. So ther ...Show All

• Visual Studio Team System How to rollback bad check-in?

  How I can rollback files checked in a source control The only things I found that I can specific version before the bad check-in but when somebody will get latest version he/she will screwed again. And also I have all kind of problems when trying to modify and check-in those files I loaded from previous changesets - Source Control detects that newer version is available in database and offers me to merge the changes. Which I am obviously do not want as newest check-in is a bad one. How can I remove this bad check-in from the top of the stack OK, so for your scenario I would use branching+merging+rollbacks - I still not convinced shelving as a required feature - but it's nice to have it anyway. I would th ...Show All

• Visual Studio Team System Number of tests executed in build report does not match the number of tests executed in build log

  We are using TFSBuild and have 33 tests run automated during the build process. When we look at the report for Builds, it states that only 1/1 tests run. However, looking at the actual build log shows that all 33 tests were executed and passed. The tests are broken up until 2 solutions. 1 Solution has only 1 test running, while the other has 32 tests. Looking at the build log, both solutions say that their test results were published. Any idea why the build report would say that only 1 test ran and passed Thanks Hi Aaron, They are both testing the same website, and therefore the same assemblies. The interesting thing is that the 32 tests are executed after the 1 test. If the publishing was overwriting ea ...Show All

• .NET Development determine external ip address from a windows forms application

  I've searched the forums for the answer to this but can't find a satisfactory resolution. We need to determine the external ip address (the same as if you went to www.whatismyip.com ) from our vb.net windows forms application. Any ideas Thanks Bruce thanks for the replies - but as my original post I have a windows forms application - it is not a web application - it's just that we call a webservice (to do a credit card payment) and we need to pass in the clients external ip address. I'll see if I can get the webservice modified to determine it from that end perhaps thanks ...Show All