vbmon's Q&A profile

• SQL Server Client Tools

  Hello, I have just Installed SQL Server 2005 on windows 2003 OS. Is there any client tools like Query Analyzer of SQL server 2000 through which i can connect to the server and fire my queries Where do I find that tool...       Thanks, siaj Siaj, The functionality of Enterprise Manager & Query Analyser have been rolled into 1 tool - SQL Server Management Studio (SSMS). I'm sticking my neck out here but I don't think there's anything you can do in Enterprise Manager that you can't do in SSMS. -Jamie ...Show All

• Visual Basic How to debug

  Hello, I am relatively new to VB.NET and I've inherited an old project which is causing some grief with one particular user. Unfortunately, all I've managed to obtain from her is what appears when it dies: EventType : clr20r3 P1 : customsales.exe P2 : 2.5.0.1325 P3 : 43f209ce P4 : microsoft.visualbasic P5 : 8.0.0.0 P6 : 4333d6d8 P7 : 35e P8 : 36 P9 : system.invalidcastexception How exactly can one use this information to find out where in the code this is going on JeffL Yes I know that-- I'm not that stupid, but I can't duplicate the problem on my machine, nor is the proble ...Show All

• .NET Development DataGrid & Multi Table Issue...

  Good Day All... Using VS 2005 (VB) & MS SQL 2005 - (targeting .NET 2.0) I have a parent and child data tables, with a PK field QuoteNumber (INT) Identity PK field on the Parent, and a QuoteNumber (INT) FK which is not Identity. There are common fields such as CustomerID and Date fields that are bound to edit fields on the top of the form. There is also a DataGrid on the form that is connected to the child table. Common fields between the two tables such as the CustomerID and the QuoteNumber are not updating, and I can't seem to get the datagrid to create a second row in the grid while entering data. How do I get the QuoteNumber ...Show All

• SQL Server Questions about sp_addlinkedsrvlogin

  1. Is there any command in SQL Server that can tell me which remote login on the linked server have I mapped my local login 2. If I use below command to map a local user: Locallogin to the domain administrator sp_addlinkedsrvlogin 'mainsql', 'false', 'Locallogin', 'Administrator', 'pwd' What will happen if the domain administrator's password may change in the future Should I execute sp_addlinkedsrvlogin with new rmtpassword again Unfortunatly, I use SQL Server 2000. It seems that SQL Server 2000 does not have catalog view. :-( After all, thank you for your informational reply. ...Show All

• Visual FoxPro error in sql command

  SET ENGINEBEHAVIOR 70 SELECT lcode, sec ,descr,examcode, sum (tobt) as tobtt,; SUM (tmax) as tmaxt; FROM Examtran; WHERE examcode= thisform . code . value .and. scode>= thisform .shiftfm. value .and. scode<= thisform .shiftto. value ; GROUP BY lcode, sec ; INTO CURSOR tyu brows SELECT lcode, sec ,descr,examcode,tobtt,tmaxt,; TRANSFORM ((tobtt/tmaxt)*100,"##.##") AS PERCENTAGE; FROM tyu; WHERE examcode= thisform . code . value .and. scode>= thisform .shiftfm. value .and. scode<= thisform .shiftto. value ; GROUP BY lcode, sec ; INTO CURSOR ppp SELECT ppp brows ...Show All

• Windows Forms Questions about MSDE...

  MSDE is called a "desktop" DB engine, is it not  I think it is.....so anyway....my question goes like this... I'm writing an app that requires some variables common to all users of the app. The app store much data not does it need much data to run. So, since the company I work for is not ready to purchase SQL server yet (we need&nbs ...Show All

• Windows Forms StopMoving() not stopping moving

  I've been playing around with a very simple herbivore this afternoon based off of the template in the tutorial. Right now I have it remembering the plants that it wasn't able to reach because it ran in to something on the way there. My problem is, if the creature runs in to the plant it's eating it gets added to the "blocked list"&n ...Show All

• SQL Server Pass through Authentication

  We have Reporting Services 2000 standard edition installed and everything works fine. You can log in and run reports and the Reporting Services security rolls work. The problem is when a user goes to the url of reporting services web server it prompts them for a login. They enter their Windows domain login and they get in. Is there a way to configure Reporting Services to use the user's Windows Domain login credentials (pass through) and not prompt for them, similar to SharePoint. Here is our configuration: We have a NT Domain (not active directory) all servers and client machine’s are in the same domain. IIS for Reporting Services i ...Show All

• Visual Studio Express Editions absolutly new and very confused

  hi everyone , I work in construction , and last year i developed a spreadsheet to estimate materials for different phases of my job . theres about 25 worksheets and lots of vba code . macros etc . I was hoping to try marketing spreadsheet , but ran into issues with excel and protection , liscense control etc . Sooooooo I figured vb 2005 express ...free ....i'm on it ...this will be great ... well .... i'm having issues ....and the worst issue is I dont even know which way i should be going with this thing ... do I try to build a program that opens excel and shows my SS ..... do i try to embed it , or link it ....do I have to mak ...Show All

• Windows Forms Welcome to the Whidbey Forums

  Please use these forums to discuss Whidbey features, ask the Windows Forms team questions and report any bugs found. thanks  - mike hmm, I didn't concider partial class as a step toward Xaml. <a href="http://www.myxaml.com">www.myxaml.com</a> uses on the run compilation of it's inline code, does this mean that one could at runtime create add-onns& ...Show All

• Software Development for Windows Vista Workflow instance does not exists

  I have a workflow that hosted under a windows form application. The workflow is published as a web service. The winform client sends a request to the workflow and the workflow logic may escalate the request to a manager by sending an e-mail with an InfoPath attachment. The manager approves or denies the request through InfoPath. The issue that I am having is when the web service request comes to the workflow, I am receiving there is no workflow instance exists error. My web service receive shape is placed right after delay shape. Any ideas How could I build a long running workflow that is initiated by a winform and sometime later can be cal ...Show All

• Visual Basic From readonly

  Hello, How can I make all the textboxes in a form readonly, or the hole form readonly, or the datatable readonly Marcel In general I'd prefer to localize something like "readonly", rather than to make it form wide unless there were a large numb of controls to be treated uniformly. ...Show All

• Windows Forms Data Table Reader

  if you look at the code below you will see a for loop that goes through all the rows. I would like to only look at the rows in the first column. How would I do this void GetActionData() { DataTableReader Reader = StationDataTable.CreateDataReader(); while (Reader.Read()) { for ( int i = 0; i < Reader.FieldCount i++) { MessageBox .Show(Reader .ToString() ); } } Did you mean that you want to get the values of first column of rows void GetActionData() { DataTableReader Reader = StationDataTable.CreateDataReader(); while (Reader.Read()) { Me ...Show All

• Windows Forms OpenFileDialog but no dialog

  I'm looking for a control och a way to make a control that is as the OpenFileDialog, but I whant it to not popup as an dialog. As any other controls you put on a form (textboxes, treeviews and so on). Any thoughts, ideas och urls, to a good control  The browsing of the filesystem should not be like a treeview.  Regards ...Show All

• Smart Device Development Windows CE from commandline?

  Is there a guide or document explaining how to use the to use the tools in VC\CE directory I can create a smart device project inside the IDE but it is only limited to ARM processor. I want to perform compilations from commandline but I have yet to find a reference for the tools. Even a simple hello world program will do fine. -- Henrik However, if you use EVC clarm, some libs are linked automatically.   Perhaps there is no such a link error with the VS2005 Arm cl. I am using an old VC cl right now that requires all necessary libs to be included. ...Show All