DreamingBear's Q&A profile

• Visual Studio Team System Can not find TFS Beta 3 download

  When I look in the MSDN Subscriber download center under vs2005, I find both the Trial and Workgroup download with March posted dates. Any suggestions I guess I am confused. So the lastest version is the one from March that is on the MSDN Subscriber download center I do have that one. I am re-installing because I got to a dead end on a project creation problem. I just wanted to make sure I have the latest. Thanks, Robert ...Show All

• .NET Development Repeater and datalist

  Hi i am Vojislav Milutinovic from Serbia (Europa) and i have problem with a nested datalist control inside repeater. So pleas help me. Problem I have database with 3 data tables. First with employes , second with pictures and thrd with idkeys from this two tables because i want to every employe have many pictures so thats a many to many releshionship. I made DAL and BLL , on presentacion layer i have two datasource object first DS1 is list of all employes and second is DS2 with list of pictures but with parameter IDEmploye so i can find pictures for every employe. I made repeater and inside datalist (for list of pictures that he have , just names not real images) . Data repeater shows ok , but datalist shows data fro ...Show All

• SQL Server SQL SERVER 2005 DATABASE MIRRORING for large number of databases

  I am trying to enable database mirroring for 100 database. It goes error free till 59 databases (some times 60 databases) with the status (principal, synchronized) on principal. on the 60th or 61st database it gave the status (principal, disconnected). Also mirror starts acting abnormal. connection to mirror starts to give connection timeout and it is not enabling database mirroring on any more databases. I have SQL SERVER 2005 Enterprise with SP1 on the servers. witness is not included yet. these are my test servers... i have more than 500 databases on my production servers. principal and mirror both are using port 5022 for ENDPOINT communication. All of the databases are critical and all must be included in the Database Mirroring. s ...Show All

• SQL Server putting data into table B from table A without using a cursor

  on SQL Server 2005, no SP. Currently using a cursor in a stored procedure to retrieve data from one table and to put it into another table. like so: declare @HTR money declare @Uniqueid varchar(15) declare cur_HTR cursor for select uniqueid, sum(hours_to_resolve) as thtr from com_trail_helpdesk_module group by uniqueid open cur_htr fetch next from cur_HTR into @Uniqueid, @HTR while @@fetch_status = 0 begin update com_hpd_helpdesk_history set total_hours_to_resolve = @HTR where case_id_ = @Uniqueid and dateasat = @dateasat fetch next from cur_HTR into @Uniqueid, @HTR end close cur_htr deallocate cur_htr ... This is taking about 45 minutes each time to do 21k records. Is there a faster, better way to do this ...Show All

• SQL Server database compatibility between sql 2005 standard v/s sql 2005 64 bit

  I am a newbie developing a web site. My local machine has sql 2005 standard edition on it. The host that I am trying to use only has sql 2005 64 bit version. would I be able to do the use the same database between the two ( i.e. once my site is running at host, would I be able to download the database on my local machine, make changes to my site and then upload again on the hose without any glitches ). In addition, how about sql express doing the same with sql 2005 64 bit. Thanks a lot for taking time to read the post. get a new host lol...come to my employeer, www.hosting.com . we offer express & std 32BIT lol who only offers 64bit. ...Show All

• SQL Server Need help converting a CHAR into a Datetime

  I have a Database which is having a Counterdate time Column stored in the form of Char(24) But i need it to be in form of datetime so that i can use the datetime functions on it..When i use the cast or convert inside the function where i am passing this character it gives me error "Conversion failed when converting datetime from character string." I am done all permutatiions and combinations for this used Set @DE = convert ( datetime, @ts,121) Set @de = cast( @ts as datetime) BUT ALWZ give me same error.... also when i copy the whole of the data table into some other database the error doesnt come.. i converts the character into the datetime.. I DONT understand why the Server is behaving wiered.. Hoping to ...Show All

• SQL Server Bug in Management Studio : Scripting of Publication generates wrong value for @schema_option in sp_addarticle statements

  Hi everybody, I found the following bug in Management Studio: I add an article with sp_addarticle and a value of 0x00 for @schema_option or via the wizard with all article properties set to false. Then I script the publication to a file. The result contains a sp_addarticle statement with @schema_option = 0x0000000000004071, which must be wrong. To prove that I recreated the article with the generated script and checked the article properties. As I feared 4 of the properties ('Copy clustered index', 'Copy nonclustered index', 'Copy unique key constaints' and 'Convert data types') are set to true! Is this a known bug wolfgang Kunk Hi, Thanks for reporting the issue. I tried it on my server, but I can ...Show All

• Visual Studio Express Editions help... function keys

  help plz.... e.Handled = True If e.KeyChar = ChrW(70) & ChrW(53) Then MessageBox.Show("Sample") End If this code was located at form1_keypress when the user press F5, a message would pop-up. but it does not work... F5 doesn't generate a KeyPressed event, use the KeyDown event instead: Private Sub Form1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles Me.KeyDown If e.KeyCode = Keys.F5 Then MsgBox("F5 pressed", MsgBoxStyle.OkOnly, "nobugz was here") End If End Sub ...Show All

• Visual Studio 2008 (Pre-release) Problem with 1:1 Association in EDM Designer

  In developing a test harness to validate name changes I made to entities, entity sets, and association sets for a EDM based on the Northwind database (Access version), I wrote some code to retrieve and display foreign key values and related entity counts for entity sets loaded in a DataGridView. I'm seeing a problem of consistency in foreign key values returned from the 1:1 Employees.ReportsTo:Employees.EmployeeID association. The initial values when loading the related entities are correct for the nine Employee instances. However, data returned from the cache is missing six of the nine values. Screen captures of the initial and final diagram, as well as test harness results, plus code snippets are in today's post on the OakLeaf blog ...Show All

• SQL Server date parmeter converts into drop down

  I am working in SSRS 2005. I have three parameters on the reports Parmeter 1 is Date filter which is drop down and values are MTD,QTD,YTD... 2nd and 3rd parameters are fromdate and todate which are datetime parameters. When user select let's say MTD from parameter1 then i have Stored procedure which populate the fromdate paramter with 1st date of the month and, todate populate the todays's date. The problem i am facing is the moment these date parameters get populated it converts into drop down. i want these date parameters should be still datetime so user can select the date. The value i am passing to these parameters are datetime type( Now() ) .Still the date parameters controls are showing as dropdown. I don't know how to hand ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Content Pipeline and FX files

  I noticed that on the post which Michael Klucher made on the content pipeline back in August that the FX files had importers for the Content pipeline included. I was wondering if anyone knew how it works ie does it a: simply compile the shader and create the binary shader file, which is loaded in at runtime b: Create an effect wrapper around it. By this i mean a little like a strongly typed dataset - rather than having to constantly lookup what parameters are required by a particular shader (ie worldviewproj), does it created a descendant of Effect and have properties that are set at designtime, so we know that we should never get errors from passing in values with incorrect names. I would guess that a is what will be in there, bu ...Show All

• Windows Live Developer Forums Problems with themes graphics?

  The switchover to Live Spaces changed my theme. I was left with one little spot of my theme background on my space about the size of two postage stamps side by side. I used the Tweak toy to repeat it around. But, because of the shape of the theme graphic I have it does not match up worth beans. Surprisingly, when I use Tweak, the initial graphic gets bigger. This is one of the standard themes that comes with spaces. It was not custom or anything. I did not do anything to it until I tried to fix it with Tweak. My space is pretty crowded because I have a lot of lists, but at the bottom where it is blank, it looks like a badly done half-painted and half-wallpapered, wall. Also, it changed the colors in my space. I used tw ...Show All

• .NET Development Strange: Session cleared after Directory.Delete

  Hi, usually session state is cleared after runtime errors (on a Win2003 Server with .NET2 using C#). But in my case a directory is deleted including all subdirectories and files using Directory.Delete(AbsolutePath, true), don't get any exceptions but nevertheless the session is cleared. By the way: Meanwhile aren't any session operations processed. Could anyone give me a hint, please Or did anyone experienced similar problems Thank you very much in advance! Marcus Hello Marcus, Truely, I have not touched ASP for last 2 years but i am quite sure that there is nothing like deleting a directry is finishing session. Unfortunately I cannot try it because I dont have installed all that stuff and ...Show All

• Visual Studio 2008 (Pre-release) How To: Create Custom Client and Service Credentials

  I read this article on MSDN, but it doesn't describe how you consume a custom ClientCredentials on the service side. I'm fairly new to WFC and am looking to create a custom ClientCredentials class that includes additional meta information about the user that can be used to determine what authority they have to perform a particular function within the service. Maybe a custom ClientCredentials class isn't the correct way to do this but I would like to make it as easy as possible for the client side of my services to just instantiate the client proxy and have it use my custom ClientCredentials so that on the service side that meta information will be available to make certain decisions about how to process the request. The article I am ...Show All

• Visual Studio Team System CA1706 and System.Data.Command.DbCommand

  Heya folks, the help file for CA1706 states that under most scenario's two letter acronym's need to be uppercase. quote the rule cause: The name of an identifier contains a two-letter acronym and the second letter is lowercase . so does this mean the object System.Data.Command.DbCommand is breaking this rule i know this is an OBJECT name and not an instance variable name, but I was just curious Yes, this is considered a break with the design guidelines. See the following for some information regarding why various redist binaries don't exactly conform to the DG. In this specific case, DbCommand had been developed and shipped through all v1.0 framework betas before the pattern was noticed. http://blogs.msdn.com/fxcop/archi ...Show All