Jamie Thomson's Q&A profile

• Visual Basic Opening File in textbox

  How would I open a file selected in an openfile dialog in a richtext box Thank You! How would I open a file selected in an openfile dialog in a richtext box Thank You! Dim theOpenFileDialog as new OpenFileDialog() if theOpenFileDialog.ShowDialog() = DialogResult.OK then Me.theRichTextBox.LoadFile(theOpenFileDialog.FileName) end if does this help ...Show All

• SQL Server New to IS -- please help me!!

  Hi i am new to IS and I have been trying to use conditional split but cannot get the syntax to work. Can someone please tell me where i can find a syntax guide or samples especially on how to make the datetime funnction and maths function work. And, am I correct that the syntax is not as simple as they look in the conditional split transformation editor thanks!!! If you want to know how to use individual function, then look them up in the reference I sent a link to, or just use your local copy of Books Online. They all have descriptions and simple examples, e.g. SUBSTRING(MiddleName,1,1) This example uses variables in the position and length arguments. If Start is 1 and Leng ...Show All

• SQL Server Do I have to rebuild all my aggs after a ProcessUpdate of my dimensions

  In this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=580892&SiteID=1 Edward told me that doing a ProcessUpdate of your dimensions causes the indexes and aggregations of all your partitions that use those dimensions to get dropped. I am really worried about this. Does this mean that I have to manually rebuild all my indexes and on ALL partitions after I have done the ProcessUpdate or is it done for me Another worry is that if I have a big fact table this could take a long long long time. In fact I'm not just worried, that is a huge risk in my book. Could soeone fill me in as to what happens with the indexes and aggs after they are dropped. Thanks Jamie This is known and well documented situa ...Show All

• Visual Basic ADO and Forms

  I have created an Access database to store information for a VB program. I have no problem filling the form from the dataset but I'm losing the formating from my number fields in Access. I'm using VS2003 and tried to txtCaseNumber.Text = txtCaseNumber.Text & Format(casenum, "##-##-####") this did nothing no matter where I put it and txtCaseNumber.Text = txtCaseNumber.Text & Format(casenum, "00-00-0000") this add 00-00-0000 to the end of the number It filled in from the db. Could someone much smarter than I, HELP. I have several other text boxes that i need to format and I'm just getting frustrated at this point. Thank you thank you thank you ...Show All

• Visual C# Addin development (options control with scrollbar)

  Hi, I noticed for some time now that the VS 2005 has the tools->options window fixed in size. Although I found it strange at first, I came to the conclusion that the only reason to keep this window with a fixed size is because of components' design. Yesterday was experiencing with the addin extensibility and I created a component, an options user control, that would go under this tools->options and it all went fine till I tried to add a scrollbar to the user control, the VS options window would say that there's a problem with the addin and try to reinstall it. I went through all options and didn't find any with a scrollbar (only listboxes and checkboxeslist) Is there a way to add a simple control with a scroll bar to the options pane ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Having a problem rendering a quad with a texture

  Hello- i can't seem to get the quad on the screen. I can render a .x file, but not a textured quad. here is some code: void cBillboard::CreateBillboard() { HRESULT r; VOID* pVertices; v = new CUSTOM_VERTEX[ 4 ]; //create the vertical info. //thisprobably cold only happen once if the billboard isn't changing, but it works for now v[ 0 ].x = 0.0f ; v[ 0 ].y = 0.0f ; v[ 0 ].z = 0.0f ; v[ 0 ].color = myColor; v[ 0 ].u = 0.0f ; v[ 0 ].v = 1.0f ; v[ 1 ].x = myWidth; v[ 1 ].y = 0.0f ; v[ 1 ].z = 0.0f ; v[ 1 ].color = myColor; v[ 1 ].u = 1.0f ; v[ 1 ].v = 1.0f ; v[ 2 ].x = myWidth; v[ 2 ].y = myHeight; v[ 2 ].z = 0.0f ; v[ 2 ].color = myColor; ...Show All

• SQL Server Insufficient Memory Errors - 12GB RAM - 64-bit???

  hi, it was suggested to try this forum, so I am hopeful I can get some more ideas. Please see this link where i posted my issue: http://sqlforums.windowsitpro.com/web/forum/messageview.aspx catid=82&threadid=49973&enterthread=y Summary: I have just installed a brand new 64-bit system, with 64-bit SQL Server 2005 sp1, and 12GB of RAM. The same queries and processes that worked on SQL Server 2000 Std Edition successfully, are failing on SQL2k5 64-bit After migrating the databases and jobs, I am frequently getting this msg: 701:Insufficent memory to run this query Nothing else in the logs. I also made sure that the SQL Service account is granted Lock Pages in Memory - no help. First, I thought that SQL 2005 can take all ...Show All

• SQL Server i think i'm in the same ball park. Database not found !

  1. Run the AdventureWorks installation, it will create two files - a MDF and LDF file. Are these two files created here : C:\ProgramFiles\MicrosoftSQLServer\MSSQL.\MSSQL\Data\AdventureWorks_Data.mdf If so i'm missing the AdventureWorks_Data.mdf file Or am i it installs it to the corresponding instance's directory so for my machine the AW files are installed to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data . To use the files simply attach a new database pointing it to the AdventureWorks_Data.mdf file. ...Show All

• SQL Server new to sql, don't understand "text filegroup" PRIMARY

  Thanks for any help in advance. I'm new to MS SQL and I'm having trouble adding a table with the property, "Text filegroup" = PRIMARY. Frankly, I haven't done much reading (I've done lots of googling though, but to no avail) about the subject, but nevertheless it seems that I can't add data to my table unless the 'text filegroup' is set to PRIMARY. However, I can't figure how to set it to primary. Even when I create a new table the default (I think ) seems to not set it to PRIMARY. By the way, I'm using Microsoft SQL Server Management Studio Express. I reread your post and I see you're using SQL Express. Did you download/install Microsoft SQL Server Books Online at all If not, download it from ...Show All

• SharePoint Products and Technologies SPItemEventReceiver do not work properly when i use the wss object model API.

  Hi everyone. I got a problem unsolved almost 2 weeks. Please somebody tell me a clue. I customized the SPItemEventReceiver and associated the customized SPItemEventReceiver with a content type was inherited from the Document Library content type and deployed this content type to a server as a Feature. When I uploaded a file from Word 2007, Events associated with the ListItem fired. but on uploading using the Wss Object model ,  events did not fire at all. I have a same experience when I using not only a document library type and SPFileCollection.Add method but also a list type and SPListItemCollection.Add method. I have found the following from the WSS3.0 sdk document. SP ...Show All

• Visual Studio Team System FxCopCmd from VS SP1 having problems with large number of messages

  Im part of a group that are testing VS SP1 prior to installing in our development group. One of my tasks is to make sure that my msbuild script for running a daily code analysis is still running as expected. Sadly it doesn't!! It seems that the fxcopcmd.exe does no longer like a large number of messages. I am running it on 20 assemblies which contain about 2200 messages in total (Yes, we are working on solving them all!!). It produces the output below: I have tryed to exclude some of the dll's until it works, but running the excluded ones does not produce the error. It seems that the problem starts when the number messages produced reaches a certain amount. Any suggestions to a solution C:\Program Files\Microsoft Visual Stu ...Show All

• SQL Server Formatting/CR in Report Manager Report Description

  Is there any way to format or add a CR to the report description in report manager Thanks! BobP ...Show All

• Internet Explorer Development IE7, OE6 Printing problems with headers TEMP SOLUTION

  Having an intermittent problem printing To: From: CC: Subject: Attachments: headers on emails. Usually happens with larger emails or emails with large attachments or emails that have been replied to or forwarded from other people. Have installed Generic/text printer and sent the email to this printer but sometimes the headers are still missing even printing this way. I have if I open the offending email and highlight just one or two words in the text of the email eg Dear John and then print the email using my HP printer (not as text on Generic printer) - the headers then print and so does the selected words. Don't suggest using Outlook as often we only print the first page of emails as we already have the rest of the email on file especial ...Show All

• SQL Server Oracle odbc driver on windows 2003 64 bit, SQL Server 2005

  God morning! I 've just installed SQL Server 2005 on Windows 2003 Server 64 bit. One of my databases need to connect to seveal Oracle databases. - I tried installing 64 bit Orcale 9 on this server. Got a strange message that the application (Oracle 64 bit) could not be installed on a 32 bit server! Strange! - I installed Oracle 9 32 bit on the server, but I could not find ODBC driver in the Data sources! Neither the oledb under providers in MSS Manager Studio! - Same result efter several desintall and installation. A college copied the .dll files och run a script to register the dll files. We could then se the Oracle driver in the Database sources, but we could not create any connection. - We have even tried an 10G version of Oracle with t ...Show All

• Windows Forms outlook-like application layout

  hi! I'm quite new to c# and windowsforms.... So i want to make an application that has an outlook-like layout. Everyone knows it well, i think. i tried to design the application like the following. In the layout i have a navigation-"control" that is on the mainform and "panels" where the navigation-dependent controls should be loaded (toolbar, tree, maincontent,..) so when i click the first navigationitem, let's call it "contacts" the application should load the contact's toolbar, tree and datagrid which are all single user controls. same with the other "modules" (navigationitems) is this the right way, or is it completely wrong if wrong how could i make it thx for helping.. ...Show All