CraigHunterFXA's Q&A profile

• Visual FoxPro Help creating a folder!!

  I am trying to create a folder with Visual Fox Pro, using the MD commnad, and i the name of the folder to be the currnet date, anyone has an ideea md date() doens't work Yes thank you both, it works. But now i wanna copy the database in this folder i just made, with the name as he current date. This doens't work: COPY FILE "receptii.dbf" TO (m.lcFolderName)\ Any ideea how Thank you. ...Show All

• Visual Studio 2008 (Pre-release) Open the configuration file.

  I have a question regarding the opening of the configuration file. I have written a library to assist me writing ASP.NET webservices and I want to use it in WCF applications. How do I open the configuration file so I can get my custom section The service is hosted in the ASP.NET developement server but will be hosted in IIS6. Thanks in advance, Trilobyte I use the following code in my application: // check if this is a web application System.Configuration.Configuration config = null; if (HttpContext.Current != null) { // open the web configuration config = WebConfigurationManager.OpenWebConfiguration(null); } else { // open the application configuration config = ConfigurationManager.OpenExeConfigu ...Show All

• SQL Server passing parameter to SQL task variable

  I am trying to exectue SQL task as below by passing a parameter If I try.... @v1 datetime set @v1 = convert(datetime, ,103) it fails with below error " failed with the following error: "Syntax error or access violation". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. however the below code works well delete from t1 where last_update = convert(datetime, ,103) What could be the problem Thanks Grants, your tip on Bypassprepare to True worked! (suprisingly) I am using OLEDB conn and used 0,1,2... notations My requirement was something like below.. @v1 datetime ...Show All

• SQL Server #Error when printing report

  I have a field on a Group Footer which is a Sum field based of an IIF statement. Here it is. =Sum(IIF(Fields!EXPR1.Value=2 and Fields!Type.Value=1,Fields!Quantity.Value,0)) If I do not use the AND, by by only checking on one field it works fine and it returns a result, however if I use the AND Operator I get the #Error when previewing the report. Does anyone have any idea why this is happening. Any suggestion would help/ THanks Can you try to get more information about the #Error The output window should have something listed about your error. Jarret ...Show All

• Visual C# Select Case

  In VB6 i have this: Select Case number Case Is = 0 a = 1 Case Is <= 50 a = 2 Case Is <= 100 a = 3 Case Is <= 200 a = 4 How do i achieve the equivalent in c# In C# swicth statement is used to do this but its not flexible enough to provide you more than one check as you are doing in above code in VB6 C# switch statement is: switch(number) { case 0:    //Exact 0        // your code        break; case 1: //Exact 1        // your code        break; defaul: //Any other value than above cases        // your ...Show All

• Visual Studio 2008 (Pre-release) Rockside Query Framework

  I mentioned this a few months back to Kieth Farmer and had no time to actually post this anywhere. I loved LINQ when I saw it at PDC 05 and wanted to experiment with building an IEnumerable based query framework with many of the same features. The purpose of the Rockside project was to emulate much of what's in LINQ without the need to use a special compiler. I've finally been able to start blogging about the Rockside project as well as take a deep dive into LINQ at my blog at http://community.bennettadelson.com/blogs/rbuckton so for those of you that were curious back in november/december of last year when I mentioned it i'm starting to post content now. I'll have the whole Rockside query project (including source) up on the site in a ...Show All

• SQL Server Cannot connect to SQLExpress

  Hi, I'm using Microsoft SQL Sever Management Studio Express. But all of a sudden, if I clicked connect button, the messageBox pops up and it doesn't let me connect. It says "TITLE: Connect to Server ------------------------------ Cannot connect to YOUR-4105E587B6\SQLEXPRESS. ------------------------------ ADDITIONAL INFORMATION: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1) For help, click: http://go.microsoft.com/fwlink ProdName ...Show All

• SQL Server Anyone completed the SQL Business Intelligence exams?

  I've just done my final exam on SQL BI (71-445 & 71-446), have to say I gotta commend Microsoft for the new testing systems; much better than before. Anyone else done the exams and have some input on them. Currently revising for MCITP so my girlfriend is not happy ;-), but she knows it's worth it. Thanks, all i could find on the subject was one book on Designing a BI Solution which wasn't the best (but helped me more on the Design exam, but less on the Optimizing a BI solution exam). Theyre really tough but hopefully worth it. Word is they'll go official in February 2007 with courses starting up shortly after, should get my results in about 6 weeks time so fingers crossed. ...Show All

• Visual Studio Team System Uploading a process template programatically

  I am trying to automate the installation of process template using ProcessTemplateManager.exe from the command line. This all works fine, however to generalise this to a dual server installation I need to execute some code on the application tier that will tell me the name of the data tier computer as this is one of the required parameters for ProcessTemplateManager.exe. So is there a way I can find out programatically the name of the data tier computer associated with the application tier computer Uploading process template is a two step process: Create a process template entry. Upload the template data corresponding to the process template id just created. You should use the TFS OM for this purpose. ...Show All

• .NET Development test form is only available for requests from the local machine?

  Using web services i'm receiving a message saying 'The test form is only available for requests from the local machine.' my Service.aspx file is simply: using System; using System.Web; using System.Web.Services; using System.Web.Services.Protocols; [WebService(Namespace = "http://bristolmessenger.co.uk")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] public class Service : System.Web.Services.WebService { public Service () { //Uncomment the following line if using designed components //InitializeComponent(); } [WebMethod] public string HelloWorld() { return "Hello World"; } } I was experimenting other day and was working fine. I have not changed anything so mignt be a setting beyond my control as im us ...Show All

• Windows Search Technologies Manually Configure URLs

  Hi all, I need to be able to manually "configure URLs" for documents. I'm not sure how else to word it. Basically, say I have a document "d1" which I get WDS to index. However, I would like to map d1 to URL u1, so that when I search for the document using WDS, I get back u1, and not d1. This would probably be some sort of wrapper around the index, which would perform the mapping between document ID and URL. Is there any way to do this I've looked at the documentation, and I haven't found anything that addresses this issue. Thanks in advance, -A Eric, Thanks for your response. I just thought it would be cool to do, for many reasons. For instance, I index a basic document which contains a ...Show All

• Visual Studio Express Editions why wont thins work?!

  hello, i am stuck with this thing!! i want to make a timer that count's down from 30 to 0 and this is what i've used. class timeDown { private int _time; public int time { get { return _time; } set { _time = value ; } } } then on the button i want to start the timer i put private void button1_Click( object sender, EventArgs e) { timeDown count = new timeDown (); count.time = 30; timer1.Start(); } and on the timer_tick thingy i put private void timer1_Tick( object sender, EventArgs e) { timeDown Count = new timeDown (); int num = Count.time; int final = num - 1; Count.time = final; label3.Text = final.ToString(); } ...Show All

• Windows Forms DatagridView HowToDo?

  I have a column in the grid which has coded Data, 0 or 1 which shall be displayed as "Deactive" for a 0 and "Active" for a 1. Is this possible to do The application is VB2005 Express and Windows Forms Thanks Manfred Use the datagridview's cellformatting event for that. Public Class Form1 Private Sub Form1_Load( ByVal sender As System. Object , ByVal e As System.EventArgs) Handles MyBase .Load Dim dt As New DataTable("Names") dt.Columns.Add("Name") dt.Columns.Add("State") dt.Columns.Add("Active") dt.LoadDataRow( New Object () {"Ken Tucker", "Florida", "0"}, True ) dt ...Show All

• Visual Studio Express Editions Cannot access the Benefits Portal

  I have the same problem: when I try accessing the Benefits portal, I get a page telling me that the page is not available. I had the same problem but it's actually easy to fix, just go to http://connect.microsoft.com select 'Sign In', after signing in go to 'Manage your connect profile' in the bottom left corner and fill in everything that has a red * next to it. Then click ok (or it's equivilent). Don't bother with then next page (personal info) unless you need to. Click OK and sign out. Try the benefits portal again and it should work. Hope it helps! ...Show All

• Software Development for Windows Vista Modifying custom composite activities at design/runtime time inside of a workflow.

  If I create a composite activity that inherits from SequentialActivity and has a number of other activities added to it and drop this new activity on a workflow is it possible to modify it at design time. So if one of the sub-activities I dropped on my composite activity was a sequential activity can it get modified after it is dropped on to the workflow. Basically what I want is to be able to create custom activities with certain common flows but at some point I want to be able to put a place holder in that flow to allow someone reusing my custom activity to do something custom. 2nd question related to the first. Same situation but instead of a placeholder (i.e. sequential activity) inside of this custom activity I want to use an ...Show All