blaineca's Q&A profile

• .NET Development DataTable Rows with Conditional Query

  I am using a query which is: "select * from newsletters where IsSubscriber is 1" newsletter=TABLE IsSubscriber =COLUMN NAME 1=bit value(can be 0 or 1) On getting the result from query, I am counting the number of rows returned and then putting the emailAddresses(which are returned if IsSubscriber=1) in a text file using the streamwriter class. It is very strange that the only one email address is being written to the text file. My code ...Show All

• Visual FoxPro VFP 9.0 SQL worthless under a non client server network?

  Hello everyone; I have posted this problem here and also on UT and no solution yet. I have a small network with a 2003 server, and XP pros. I am running vfp 9 select * from products where status = "S0000" takes apx 10 seconds when run over the network. When running this locally, it takes only a fraction of a second. The product table contains 100,000 records, and the result of the SQL command is just a few hundred rec ...Show All

• SQL Server Filter a Model Table?

  I am using  RS 2005. I am setting up a Model for use within Report Builder so our clients can write their own reports. A 2 part question, simple question first: 1. How can I filter the records in a Model Entity I thought this would be possible from a Perspective but it is not. 2. How can I filter the records in a Model Entity based on the locale of the person who is logged on And also based on their permissions TIA You are corr ...Show All

• Visual Studio Team System Errors re-installing beta 3 refresh

  We installed Beta 3 refresh a few weeks ago, and all was working fine. However, we experienced some corruption outside of Team Foundation Server that caused us to have to reinstall Beta 3 Refresh - the reasons behind the need to reinstall are a bit shady at the moment - sorry! During the reinstall procedure, we keep receiving the following error: Error 32000: The CommandLine "F:\<path name>\createds.exe" /setup /install &qu ...Show All

• Visual Basic Info call using VB and Access

  I am currently trying to build a system but its llooking a mess so im trying to make it look presentable. Its based on a booking system of cars with customers. Before i had just one form where i can input both information and then book it for a given period. But instead now what i want to do is to insert the information of customers on one form, and insert the information of the car on the second form, however i want to use a third form as a ...Show All

• SQL Server multiple result sets from stored proc

  I have a problem with the following query analyzer code. exec RoomRoster '3/9/2006',5,1,60,null,null,null select rr.*, d.dependent_name from ##RoomRoster rr inner join cm_dependents d on d.dependent_contract_fk = rr.cntrWRL_contract_fk drop table ##RoomRoster This t-sql calls a SP that returns a global temporary table named ##RoomRoster. This sql produces 2 result sets in 2 QA grids. The first ...Show All

• Visual Studio Tools for Office Most flexible deployment is to GAC?

  Working on a VSTO Word application. Users will need to be able to pull documents from a Sharepoint site that use the app as well as email them to each other, and also be able to work offline... Right now I have decided to install the assemblies into the application folder. However, I assume that if two users install into different app folders (or if Program Files is on D: for one user...) then they cannot email the document from one user to a ...Show All

• SQL Server How can we write C# code in sql.

  Hello Anybody knows how to write c# in SQL All responses appreciated. thanks. There are many examples out there, one of them is http://www.codeproject.com/dotnet/CLR_in_Sql_Server_2005.asp . But anyway if you google for word like clr or c# in combonation with SQL Server 2005 you will find some good examples out there, depending of what you want to do (triggers, udts, udfs, procedures) HTH, Jens Suessmeyer. ...Show All

• Visual Studio Team System WSS account creation in AD for TFS

  Hi, Would it be possible to deploy the SharePoint service portal site generated by TFS application tier to support account creation in AD like http://www.microsoft.com/resources/documentation/wss/2/all/adminguide/en-us/stsc05.mspx In other word, can I invite developers to my project with TFS just like ISP prvoviding web site owner the ability to invite users not already have accounts in the domain for collaboration Can TFS utilize this ne ...Show All

• Visual C# Compare 2 objects

    Hi all I have a class that contains an object that holds some value. the value can be any primitive data type I need a good way to compare 2 and check the relation (greater, smaler) between the  2 objects . for example , 1 can be int and the other can be decimal I am trying to avoid "if X is int32...." and things like that. looking for a general way to compare.   Thanks Avi     ...Show All

• Visual Studio Express Editions problem installing

  hi ive been trying to install c# but it just seems to stop suring the setup phase. It comes up with a little pop-up saying "Setup is loading installation components This may take a minute or two" It gets about 3/4 of the way there then just stops Any idea why thanks blowsie Make sure you have updated your system with windows update. Some have reported problem ...Show All

• Visual Studio Tools for Office Outlook Crash after ThisApplication_Shutdown()

  I’m currently working on an Outlook Add-in using c# with VSTO 2005. The add-in creates a custom menu and pushes data into a custom “Today” page. My problem is that Outlook is crashing after the ThisApplication_Shutdown() event. My code for this event disposes and/or sets to null every variable that I create so I’m fairly confident I’m not holding onto any resources.   If I enable native code debugging I see the following error ...Show All

• .NET Development Filling DataSet?

  Hello, I need to read a XML file, I've generated a typed DataSet with xsd.exe, but I don't know how to fill the DataSet: DataSet1 ds = new DataSet1(); ds.ReadXml("file.xml");   but the dataset seems to be empty, what am I doing wrong Also, I can't find a way to append a TableAdapter to the scheme from the designer I'm using Beta 2 obviously. How stupid can I get New XMLs weren't pointing to th ...Show All

• Visual Studio Express Editions Express capabilities

  In Visual Studio I can take a .asp page (with javascript in it), and then compile the page to a .dll. That way, I can give the .asp page out to someone, and have my code protected. Does the Express version allow the compiling of a .asp page to a .dll If it has "build a web project" as file option, the answer is yes. If it doesn't Visual Web Developer does. Isn't there an Express version of that ...Show All

• .NET Development Richtextbox formatting between events

  Hello all, I am using a richtextbox to read information in when a use clicks a button.  on every click i need to display a differet color for the text.  What happens is that all my previous formating is lost and only the latest is saved.  Is there a way to prevent this from happening. I am currently using the following method to add the new text to the box ImportTextBox.Text &= NewText   I then select the new text ...Show All