Randine's Q&A profile

• Visual Studio Express Editions Formulas like excel

  Can anyone tell me how a program like excel handles formulas. From what i can see it looks like it stores the formulas somewhere away from the database. How does this work Or am i even close Can someone tell me how to create something similar This isn't exactly what i am looking for but it did spark some thoughts to withhold formulas from my spreadsheet and hard code them to use only when my app is running. Thanks for the spark. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. RenderTarget2D and MipMaps

  How to "enable" automatic mipmap generation in RenderTarget2D i don't know why but it don't work m_DrawBufferColor = new RenderTarget2D(m_GraphicsDevice, 1024, 1024, 4, SurfaceFormat.Color, MultiSampleType.None, 0); m_Game.GraphicsDevice.SetRenderTarget(0, m_DrawBufferColor); //here i render m_GraphicsDevice.ResolveRenderTarget(0); m_GraphicsDevice.SetRenderTarget(0, null); //now i use it Texture2D Tex = m_DrawBufferColor.GetTexture(); m_HDREffect.Parameters["DiffuseTexture"].SetValue(Tex); //part of fx file Out = tex2Dbias(DiffuseSampler, float4(In.TexCoord.xy, 0, 3)); and i get some thing that looks like like random (texture on this mip level is some random memory) //------ ...Show All

• SQL Server SQL 2005 Enterprise to 2005 Standard

  We have a situation where we installed the Enterprise version of SQL Server 2005 on a server that is now in production and we had intended to install the standard edition (what we are licensed for). We have enterprise licenses for other servers so we have both types of media and it was a mistake that was made. I was wondering if there is a way to downgrade the version without uninstalling and reinstalling and having to backup and restore all the databases, jobs, SSIS packages, etc. Any suggestions or help would be much appreciated. Thanks, John Nay. Microsoft is quick to tell you how easily you can upgrade from one version to another ... downgrading though (with the exception of license rights) is ...Show All

• .NET Development using the output from a DataReader to insert in another DB

  Here's my situation. I have two tables with the same structure but residing in different databases (and different machines). I need to read a set of records from one table/database and insert the records (as is) into the other table/database. I don't want to loop through each record and column. Is there a way to do this in "one shot" What I have is a DataTable that I created by overriding the DbDataAdapter class to allow for a FillFromReader eg: public int FillFromReader(DataTable dataTable, IDataReader dataReader) { return this .Fill(dataTable, dataReader); } Any ideas Thanks, gagis. Take a look at SqlBulkCopy ...Show All

• Visual Basic help with learning how to program

  Hi- How would you write a program to make the computer not evaluate exclamation points, symbols, spaces, and not be case sensitive For example, if I were to make a text box for input and someone inputs "Oh no! Don Ho!", how could I program it so that the computer only sees it as "ohnodonho"... the point is to type in palindromes and for the computer to evaluate whether or not the input is a palindrome. Thanks for any help! (Moderator: Thread moved to VB.Net forum due to other posts by user in that genre) One way to do that is to learn about Regular Expression. RegEx'es are used for string manipulation in many different languages. Below is code to do such an activity. ' Imports System.Text ' ...Show All

• SQL Server Adding a column to a Fact table in Analysis Services 2000

  How do you add a column to a fact table I added a column to the SQL table that the cube is based on "FactVoyage". I then went to Analysis Manager refreshed everything, and edited the cube. the table "FactVoyage" shows on the Schema tab, but the new column does not appear. I presume there is some trick apart from deleting the Table and reinserting it Thanks ...Show All

• Windows Search Technologies How to calculate the mailbox hash to construct URL path

  Hello, It seems WDS is using some hash number in MAPI url to locate items. For example, the text in red : mapi://LocalHost/default/Mailbox - Wang, George ( $d3f5 )/ Is it possible to expose the hashing routine so that we can construct the URL from mailbox ENTRYID Here is a doc about something similiar, http://blogs.msdn.com/stephen_griffin/archive/2006/05/10/594641.aspx , search for "ComputeStoreHash", not sure if they are related somehow Thanks! Ok, it's goes something like this (apologies for rough format, but I hope it helps): // // We get back from WDS 2.6 this: url := ""mapi://localhost/default/my internet ($855f)/deleted items/H00 P" // // So we have ...Show All

• Visual Studio Team System Regarding error location.

  Hi, On one of the posting at following link I read that for certain cases the error location is not reported. Is this still true for FxCop 1.35 or there is some change. https://blogs.msdn.com/fxcop/archive/2004/01/09/writing-custom-rules-in-fxcop-amp-fxcop-visual-studio-integration-jeffrey-van-gogh.aspx#comments Also, can anybody in anyway write the custom rule carrying code which can change the FxCop's behaviour of reporting error location We can't report the location of things that do not have source information available in PDB. This includes types, fields, abstract/interface methods, namespaces, assemblies, modules, etc. If you using Visual Studio Code Analysis, then we can provide sou ...Show All

• Visual C# Change the BackGround Color of a Window or Control.

  Is there a way with the API functions to change the background color of a Window (or control) having only its Handle Not only the background color behind the text, rather all the window or control, and without changing the original content. Something as: System.Windows.Forms. Control ctrl; ctrl.BackColor = Color .Red; But, With API Functions. Thanks, Deza im not sure but wondering why you would rather use a "handle" or even some API to do this when you can do this, as you have shown, using the .NET Way if there already exists a .NET way, you should really be using it :-) ...Show All

• SQL Server SQLCMD taking lot of time during insertion

  Hi I am using SQL Server 2005(Express Edition) and i am trying to insert around 50,000 records in a table through a sql file by providing that file as inputfile to the sqlcmd utility. SQLCMD utility is taking a lot of time in completing the transaction. Moreover if i am doing the same thing with the help of a procedure its taking around 30 sec to do so. Please tell me why its taking so much of time via SQLCMD. Also it seems that sqlcmd is taking a lot of time in parsing the file. Can we somehow disable the parsing done by the sqlcmd utility Regards Salil The quickest way to get data into SQL server is going to be BCP. Check out the online docs for bcp.exe and in SS2005 check out the &quo ...Show All

• Windows Forms ToolStripMenu

  Hi, quick question: Is there a way to remove the image margin for ToolStripMenu items like you can with ContextMenu items Thanks mate, although I knew that there was as "ShowImageMargin" property for ContextMenu's. My query was regarding ToolStripMenu's and as the above mentioned article shows, Tomas Frojdo wrote: http://msdn2.microsoft.com/en-us/library/ms229638(d=ide).aspx and you have rightly pointed out, the only way to change that property for a ToolStripMenu, is to assign a ContextMenu to the ToolStripMenu rather than using the default ToolStripMenuItem's. ...Show All

• Software Development for Windows Vista IGraphBuilder Render from stream

  Hello everybody, If there is an identical topic I excuse, I couldn't find one. I need to render mpeg2 program stream on the fly. As I know I can't write to file and render file at the same time. Can anyone give me some help Thanks in advance. Take a look at the Infinite Pin Tee Filter: http://msdn.microsoft.com/library/default.asp url=/library/en-us/directshow/htm/infinitepinteefilter.asp ...Show All

• SQL Server HTTP 500 error accessing Reporting Services..

  I have just set up reporting services on my development machine. I hvae set up the Virtual Directories for the Report Manager and the Report Server using the Reporting Services Configuration Manager. I have checked that they are set up in IIS admin and everything seems OK... until I try to connect to them of course! In every instance I get a 500 error.. looking at the web log, this is preceded by a 401 (unauthorized) error. IIS seems to have been set up for windows integrated only. I am local admin and have acces to everything.. what is happening What do I need to set to be able to use this service I had the same problem a few days ago. I just changed in the website properties , in website authentifica ...Show All

• SQL Server Problem with reference dimension & snowflaked tables

  OK, this is a bit complicated, so I hope I can explain it clearly. I'll try not to get bogged down in the details of the problem domain, but bear with me. We have a cube with a regular dimension and a reference dimension. The reference dimension is connected through the fact table through the regular dimension (there are many other dimensions as well, but I'll simplify the situation here). Both the regular dimension and the reference dimension have hierarchies that that include as their top level a level called "System". For both of the dimensions, the "System" level is snowflaked in from the same table. So the regular dimension table contains a column called System_key, and a corresponding attribute. Similarly, the ref ...Show All

• Windows Forms VDProj BannerText

  Hi All, Is there any way to change BannerText in the welcome screen of a vdproj file made with VS2005 It seems like now it gets it from VsdWelcomeDlg.wid and currently has this value: "Welcome to the [ProductName] Setup Wizard" Obviously, I can't edit that file, so I want to know if there is any way to change BannerText without changing that file (using a post build event, a script, or anything else).   Why I want to do this I have a long ProductName and a BannerBitmap, so the text gets over bitmap, making it difficult to read. I agree with you. This is what I thought initially I can do. The problem is I don't know VBS very well and I can't find any sample of d ...Show All