Katarina C.'s Q&A profile

• Visual Studio Team System dropped user

  I deployed my project to the target and after deployment it dropped my user. Understandable, I could no longer connect to that database. How do I prevent that I looked in the post deplyment scripts and found nothing specific to my user. I do not have a server level role. Only dbo_owner for the target database. Paul It probably dropped your user because it didn't exist in the source (project ) but did exist in the target (deployment database). Amos. ...Show All

• SQL Server sql statement

  I plant lettuce in fields multiple times during the season. when i plant a trial it gets a wet date, lets just say 10-20-06. i need to go back to each planting 14 days after its been planted. How do i write the statement to display these lettuce trials. i tried this statement SELECT species, trialnum, wetdate FROM mapdata WHERE (wetdate = DATEADD([Day], - 14, GETDATE())) I went from that statement to this one WHERE (DATEDIFF([DAY], wetdate,DATE("d"))=14) Now the error reads "Wrong number of arguments used with function in query expression '(DATEDIFF([DAY],wetdate,DATE("d"))=14)' Not sure what to try next. jdslim Well, you need to be careful about using the datetime da ...Show All

• Visual Basic Extending Richtextbox control.

  Is there a way to select columns 1 through 10 for all of the rows which have text in them and either cut or copy them to the clipboard or simply delete them Textpad and MS Word support this by holding on the alt key while selecting with your mouse. I am trying to implement this and i am finding suitable way to do this. Thanks in advance. chirag dave Hi Dave, This forum is for questions related to the Visual Basic 2005 PowerPack downloads. You will probably have better luck getting a quick answer if you post your question in the Visual Basic General section ( http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=32&SiteID=1 ) or in the Windows Forms section ( http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=8& ...Show All

• Visual Basic Terminal Services Control (msrdp.ocx) vs Remote Desktop Client 6.0 (KB925876)

  Hello! I am writing simple application (on VB6 first, then VB.Net and C# with the same result) that uses the control MsRdpClient2 from msrdp.ocx. Everything works well until I install Remote Desktop Connection 6.0 client update (KB925876). My application now said it cannot load this control from msrdp.ocx. Cheking msrdp.ocx file ... and found it's still available in "C:\WINDOWS\system32\web\tsweb\". Then simple test "regsvr32 msrdp.ocx" ... and now my application works again (but seems it's not good idea to do this on any computer except test lab). Doing registry state comparision before and after update installed shows that MsRdpClient2 now lives in mstscax.dll and if I understand correctly it's not now UI control( ). ...Show All

• Architecture To use DevForce O/RM or Datasets?

  Hello, I am wrestling with the decision on how to design a new (Order Entry) application. I am using VB 2005, and it will be a Windows Forms app. I have about an intermediate+ level of expertise. In the past I have used VB DataSets and the whole dataset designer which connects to the database. Since then I have learned about O/R mapping tools and am considering using DevForce from IdeaBlade. It seems to work well, so far connecting to the database and generating the classes that relate to the tables. I like this concept and think it makes sense. This seems like a big change, or is it My question is, is this a good direction to go Everything you read from the VS documentation refers to typed Datasets as well as the examples. Wha ...Show All

• .NET Development Access Excel File On Different Server ** Help Urgently Needed Plz **

  Hi all, I am trying to link to an excel file on a web directory on a different server but can't seem to get access to the file, This is the code i'm using: Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _ & "Data Source=\\fse1web563\fsetrain$\public\Equiv\FSE_PAS.xls;" _ & "Extended Properties=Excel 8.0;" Any ideas, help appreciated I've tried it on mine using this: " Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\server\\C$\\Book1.xls;Extended Properties=""Excel 8.0;""" Does this one work for you difference being that the Extended Properties section is in double quotes ...Show All

• .NET Development Calling Asynchronous Process in Synchronous way?!

  Hi I have a middle tier library, which manage all the asynchronous calls (number of call depends on parameter value). This middle tier library will be call from a front end form (c#). In usual case, the calling statement in form will be returned immediately just after the call and I have to handle the call back method separately. I don't want to do that. The callback method will be handled in middle tier(this can be done). Also, what I want to do is, to return the calling statement, after finishing all the asynchronous call and the callback method in middle tier. I have put my problem and a temporary solution: MiddleTierMethod() { //say 15 aynch call for (int i = 0; i < 15; i++) { doAsynchCall(i); } //Blocking immed ...Show All

• Windows Forms toolStripButton

  For some reason the toolStripButtons on a toolstrip don't have a handle when using Spy++. At the same time a toolStripComboBox on a toolStrip has handle. I am tryign to send a message to the toolStrip buttons but I can't because thre is no handle. Is there a workaround Why doesn't a toolstripbutton have a handle and a toolstripcombobox does Thanks a lot! Managed Spy has the same problem you do. A button on the ToolStrip is not a real control, it is just a picture of a button that the ToolStrip control paints. Same with a label BTW. I don't know what you're trying to do but if you want to click on the button with your own program, you could click on the ToolStrip control at the "right&q ...Show All

• .NET Development System.IO.IOException was unhandled, Message="Unknown error -1."

  Hi I have this small program, that runs fine from Visual Studio or from the debug directory. using System; using System.Collections.Generic; using System.IO; using System.Text; namespace TestAccess { class Program { static void Main( string [] args) { string filename = @"C:\Documents and Settings\All Users\Application Data\Company\Product\config.txt" ; Directory .CreateDirectory(filename.Substring(0, filename.LastIndexOf( '\\' ))); FileStream fs = File .OpenWrite(filename); StreamWriter sw = new StreamWriter (fs); sw.WriteLine( "This is a test" ); sw.Close(); fs.Close(); } } } When installed via a setup project I get this error. ...Show All

• Windows Live Developer Forums HowTo: Click a country, click a county and detect it...

  There is a nice news map here: http://muti.co.za/static/newsmapve.html They show a map of Africa, with it's countires outlined and labled. When you click within the country's borders, it diplays news for that country. Same for the states of the united states. How do you detect where the click occured AND how do you know it is within the border of a state or country -jeff They are doing it server side Jeff. If you look at the AJAX they send the lat/long you clicked: http://muti.co.za/get_news_xyz_json x=27.597656250000018&y=15.114552871944092&z=3 Follow the link to see the JSON returned. It identifies the country based on lat/long. They would be reverse geocod ...Show All

• Visual C# Static Classes being referenced by multiple processes within the GAC??

  If I have multiple processes accessing the same assembly within the GAC, and within that assembly a static class's members are initialized by one of the processes, the members remained initialized for all processes accessing the assembly correct I am assuming so by way of this quote on MSDN: Static classes are loaded automatically by the .NET Framework common language runtime (CLR) when the program or namespace containing the class is loaded. No, the static class values are not shared between the apps because each app that uses the CLR loads its own instance of it (both the class and the CLR) and each would end up with a separate copy of your class’s static methods and the values they access. ...Show All

• SQL Server Deployed Application isn't connecting to SQL Server

  When deploying my application that uses sql server it doesn't connect to the server. I checked the connection string & it's ok the server instance is the same. The computer name isn't the same & i use the .\SQLExpress as the data source. I get an error saying 'sqlserver does not allow remote connections error 26 locating server / instance specified'. This link can help you. http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx ...Show All

• Visual Basic multiple textbox counter

  i have a program with about 30 textboxes on it for number inputs. I need to make a label that on a tab or mouse click it will show the total number amount from each text box. for instances tb1 -- 10 tb2 -- 3 tb 3 -- 5 label = 18 Thanks Michael Hi, Define what tb1--10, tb2--3 and tb3--5 are please. Are these 3 separate textboxes or is tb1--10 all of the 1st 10 textboxes What number format are you using integers or decimal Are you wanting to simply add up totals from the lot to show the answer in a label or a textbox or 4 separate answers I'm guessing here. Put this code into a button-click event Sub or label-click event Sub. Dim answer1, answer2, answer 3 As Double ...Show All

• Visual Studio Team System with http connection added forms in VB 2005 don't get added to source control Team project.

  One of our developers is using http to connect to TFS. When he adds new forms to his project they don't get automatically added to his source control project, nor is there any right click menu item to add it. If we try to drag one of the new files from file explorer, the hour glass goes on for a while, but nothing happens and file is not added to source control. Are we doing something wrong or is this a know bug We have developer who is a not a US citizen, so our corporate security requirements, require him to work outside our firewall, which necessitates his using http to connect to our TeamServer project. Out of the box VSTS is supposed to support http connections. We are just finding that it seems to be a bit flakey and temperme ...Show All

• Windows Forms Winform inside a SplitContainer Funny Behaviour

  Hi, I have a split container with the left panel having the navigation menu and the right panel displays the required winform. When the form is displayed inside a splitcontainer panel, the textboxes behave a bit funny. There is no way I can have the mouse cursor placed inside a textbox in the position I want to. The complete textbox gets selected on entering the textbox. Also, I can only place the mouse cursor at the extreme left of the text in the textbox. Any ideas why this is happening. If I run the same form outside the split container (that means the form is not docked in the split container panel, then the textbox behaves normally. thanks Hi, Will the mouse cursor be change ...Show All