Dan Waters [MSFT]'s Q&A profile

• Visual FoxPro reading a directory for a existing files

  hi there! im new to vfp and i want to make a programm that reads a certain directory and which gives me back the number of the files in that directory and the filenames. can someone tell me how it works in vfp it will really be great... thanks in advanced! novelle hi thanks again... what i really like to do is like this i=0; WHILE i NOT EQUAL numbersOfFiles in the directory THEN DO DELETE FROM tabelle_1 WHERE nr IN(SELECT nr FROM this file in the directory) NEXT i want to check if this Nr. already exist on those files in the directory and if it exist there i want to delete it to my Tabelle_1 do u get me thanks in advanced!!! novelle ...Show All

• Visual Studio Drilldown feature only for Remote mode?

  Hello, I was just wondering if the drilldown (expand/collapse node) feature can be enabled when using the ReportViewer in Local Mode (No ReportServer) I was able to easily setup a report with drilldown when designing it on the SQL Server BI Studio for Reporting Services but I could not do the same when creating a report within VS 2005 using the ReportViewer. Can the drilldown feature be enabled for local mode Yes, drilldown in local mode should work. Did you look at http://gotreportviewer.com/MasterDetailDrilldown.zip -Albert ...Show All

• SQL Server Writing a custom class

  Hello everybody, I am new to .NET programming and the C# language. I'm coming from a ColdFusion/Java background, but am trying to learn .NET to further my abilities as a programmer, and take advantage of the CLR functionality in SQL Server. What I am wondering is: is it possible to write an assembly which has stored procedures and functions that each utilize a custom class written within that assembly I am having some trouble with this concept. I am writing a UDF that will compile various data together and build a string from it. To help simplify the code, I want to build a custom class which will represent the primary object I am running the compilations against. I would like to have the class be able to load its data directly from the ...Show All

• Visual Studio Express Editions 2 primary Keys in 1 table

  How do I create 2 primary keys in 1 table in vb05ee. I know this can be done because I am looking at a table sample with 2 primary keys in it. Help The user asked about setting up two primary "keys" The operative part here is the plural keys - a table cannot have two primary keys. The designer allows you to select as many fields as you want to create a (singular) primary "Key" This field can be a single field key or a composite key field but there still can only ever be one primary key. ...Show All

• SQL Server Navigation on Matrix Subtotal

  Here's a sample matrix: Men Women Total Full Professor 36 12 48 Assoc. Professor 16 9 25 Assistant Professor 11 14 25 Total 63 35 98 Now, it's easy enough to make the values clickable so that somebody can drill down to a report that shows detail about the people. I have also discovered how to turn off clickability on the totals. However, what I really want is for the totals to be clickable so that, for example, if I click on the 63, I see a report that shows all men. Likewise, If I click on the 48, I want to see a report that shows all Full Professors. What currently happens when the totals are clickable is that if I click on the 63, I get all men who ar ...Show All

• SQL Server Trigger data corruption

  I have a weird issue with a trigger... I have a table called category, which has a column [Name], and a record "113_Install". I have the following query in an AFTER UPDATE trigger on this table: INSERT INTO DataPump_PendingCategory (CategoryName) SELECT i.[Name] from DELETED After changing the data in Category, I see the following record in my pending table..."113_Ins D" or something similarly corrupt looking. From what I can tell, both of the tables have the same settings, any thoughts Additionally, if I follow your example one step further, recreating these tables (using the "Create To -> new query editor window in SMS) exactly, recreating the exact trigger I have, and going from there... I do not ...Show All

• Visual Studio Express Editions Array Assistance

  I have a couple of textboxes for user input. They will put in the number of answers to a specific question. For example TextBox1.Text they enter in 7 for "yes" TextBox2.Text they enter in 4 for "no" So I need to get the answer values into an array. Textbox1 value is "YES", Textbox2 values is "NO" So I need an array that would be "YES, YES, YES, YES, YES, YES, YES, NO, NO, NO, NO" Could someone point me in the right directions. Thank you I have to say I don't really understand what you are trying to do, however if you want an array to hold just the two "values" Yes and No then a boolean array might be sui ...Show All

• .NET Development Determining Primary Key When Inserting Parent Table For Foreign Key Insert on Child Tables

  I've search many postings regarding retrieving the Identity value from a table after it has been inserted. I have a slightly different situation. I am performing an insert on 6 tables within a given transaction. Table1 is the parent and the Table2 - Table6 are (so called child) tables. On Table1 we have a ID field which is the primary key (float), hence I cannot use the SCOPE_IDENTITY. I have 6 SqlDataAdapters with 6 corresponding DataSets. How do I retrieve the Primary Key on Table1 to be used as a foreign key on Tables2 - 6 using a disconnected DataSet My code looks something like this: SQLTransaction trans = cn.BeginTransaction(); Adapter1.InsertCommand = new SqlCommand( "INSERT INTO Table1(Name) VALUES("@Name ")&q ...Show All

• Visual Basic Uploading Files

  Hi there, I know how to upload a file to a remote server but it always comes up with a dialog box saying where it going, etc. Is there any code that stops that dialog box appearing. Thanks, AliQ Hi AliQ It looks like you are setting the ShowUI argument to true. Try the following and see if it solves the problem ... My .Computer.Network.UploadFile( "C:\MyFileLocation" , " ftp://MyRemoteServerLocation " , username, password, False , 500) Richard ...Show All

• Windows Forms Custom Control On_Load

  I have a custom control and I want to run some code associated with it in the Parent Form on Panels On_Load event. (Similar to what happens when you drag a datasource onto a window, it adds the DataTable.Fill code to the Load event.) I want to do something very similar and I want the Designer to add the code to the parents Load event for me. Note: I do not want to attach a Handler to Parent.Load I want the code to in the load event so it can be easily modified by the end user of the control. Thanks, Martin Shane Horn Ummm... It is seen that it is possible to use the class CodeDomSerializer to realize what you want. Check the help related to this topic. See following articles: htt ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Building a Class repository but I have Namespace issues.

  You'll have to forgive the no doubt "simplicity" of this question but please bear with me. I am currently writing lots of small projects to learn different aspects of how C# and XNA both work. This is pretty much the first major involvement in a class based language that I have really dug into and it is certainly one where I have encountered namespaces and had to take notice of them. My plan is to build a set of classes that any new project can have access to (gameObjects, cameras etc...), ideally in a central location to all projects. Every class I create has a Namespace associated with it which means every time I try and use it from a different project, I have to add the class to the project and then change the Namespace. ...Show All

• SQL Server Permissions to view Stored Procedure Property

  My Production servers are SQL Server 2005 x64. I would like to allow my developers the ability to look at permissions on production stored procedures but not be able to change those permissions or alter the production code. What has to be set to allow this sort of security. I have done that for the developer group and I still get this error on Stored Procedures TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. ------------------------------ ADDITIONAL INFORMATION: Cannot show requested dialog. (SqlMgmt) ------------------------------ Property DefaultSchema is not available for Database '[HouseAccounting]'. This property may not exis ...Show All

• Software Development for Windows Vista Works in XP but not in Vista

  Hello, We include a root certificate with our installation that we try to install using a client configuration tool. This installs a trusted root, so that when a client activates our product, they get their own unique certificate that is trusted by our installed root. I have included the code that we use to install the root certificate, but it does not seem to work in Vista, as I get an Access Denied when I try to do the store.Add(cert) In XP, I did not originally have the StorePermission object, and as an administrator on the machine, this worked fine. We require an administrator to run the "utility" that installs the certificates before a user can run the application. In Vista, even as an adminstrator, we get the Ac ...Show All

• SQL Server Modify excel spreadsheet on the web page...doable?

  Hi there, I am making an web application and it involves a spreadsheet object... now i manage to show the spreadsheet on the web page by using Response.ContentType = "application/vnd.ms-excel" Response.Write(sheet.XMLData) The requirement from my clients is that they wish to modify the spreadsheet on the web -> and then click the save button -> update the database Can anyone here help me with that i am using vb.net and the application will be use in LAN If you want to write back to the excel sheet you probably should try to post your question in an Office group, nit the SQL Server group. They wil be able to help you with the problem better than guys in this forum can d ...Show All

• Visual FoxPro Help: Open a Table from within a Report?

  Hi, I am supporting an Accounts program that is written in Visual Foxpro. I am editing a Report using the Report Designer and the Data I wish to access is in a Table that is not open in the Data Environment, and I cannot simply Open it and Save as the Data Environment reverts when re-opened. I am aware that there is a way to Open a Table in the Header of the Report by adding a Field and using a Command in the Expression Builder as I found out about a year ago, unfortunately I cannot remember or find the Command for doing this. Can anyone put me out of my misery and give me some help on how to acheive this Many Thanks. Hi, You can open your table manually before REPORT FORM. *** Command.Click ...Show All