Jamie Thomson's Q&A profile

• Visual C# How to store dataset to a table in the database. Please be specific. Urgent

  I have create the following datarow: _dtProjectQuestion.Columns.Add("ProjectQuestionNo"); _dtProjectQuestion.Columns.Add("ProjectQuestionType"); _dtProjectQuestion.Columns.Add("ProjectQuestionName"); _dtProjectQuestion.Columns.Add("ProjectQuestionLastModifiedDate"); _dtProjectQuestion.Columns.Add("ProjectQuestionDateFormat"); _dtProjectQuestion.Columns.Add("ProjectQuestionShortLabel"); _dtProjectQuestion.Columns.Add("ProjectQuestionLongLabel"); _dtProjectQuestion.Columns.Add("ProjectQuestionMessage"); _dtProjectQuestion.Columns.Add("ProjectQuestionMinAnswer"); _dtProjectQuestion.Columns.Add("ProjectQuestio ...Show All

• Silverlight (formerly WPF/E) WPF/E (TextBlock) is not rendering Unicode correctly

  I have downloaded the WPF/E CTP & SDK, I played with them and have noticed that WPF/E does not fully support Unicode, as I use a TextBlock to test the display of Arabic text, WPF/E was rendering the text incorrectly as if it is rendering the text from left to right while it should render the text from right to left. This same behavior is true for Hebrew too which is also a right-to-left language. am I missing somthing Until FlowDirection is implemented, Can you mirror your text <TextBlock > <TextBlock.RenderTransform> <TransformGroup> <ScaleTransform ScaleX="-1" ScaleY="1"/> <TranslateTransform X="100" Y=" ...Show All

• SQL Server Distributed processing "farm" using Broker for middleware.

  In our current project, we are attempting to use Broker for the middleware for a "queuing" solution that helps in throttling & load-balancing incoming messages. These messages could potentially be either long-running jobs or simply an incoming flood of messages received from our integration web services that are called upon via BizTalk. For the posting of messages onto the "to do" queue, we are implementing the "fire & forget" pattern that has been discussed here previously and on Remus' blog. This aspect of the design seems to work fine for us. Currently we have this setup where activation is occuring on the target queue, but we don't want to hold open a thread there on the server while waiting for ...Show All

• Visual Studio Can't Configure .NET Configuration 1.1

  Guys I need help. I've got .net framework 1.0 (hotfix), 1.1, and 2.0 installed. For some reason, 1.0 sp3 won't install. I also cannot configure .net 1.1 through the option under administritative tools. I get the error: Microsoft Management Console Snap-in failed to initialize Name:.NET Framework 1.1 Configuration CLSID:{1270E004-F895-42BE-8070-DF90D60CBB75} I then click ok, and the .NET Configuration 1.1 thing opens, but just says: Snap-in Creation Failed. The snap-in is not created, it may not be installed properly. Name:.NET Framework 1.1 Configuration CLSID:{1270E004-F895-42BE-8070-DF90D60CBB75} What is the problem here I first realised I was having problems when trying to install Sky By Broadband on my Media Center 2005 de ...Show All

• Visual Studio Express Editions Adding Dynamically to a DataGridView

  Hi I wonder if anyone can help I am trying to create a class to dynamically create a DataGridView (without using data binding). I know the number of columns but cannot figure out how to add the row data. Is there a way to do this For example I want to do the equivalent of the following: Dim dgv As DataGridView dgv = New DataGridView gv.Rows.Add("data1", "data2", "data3") The data I have is stored within an array which is variable length. I could do the following: gv.Rows.Add(dataArray(0), dataArray(1), dataArray(2)) but, as I said, I do not know what the number of elements of the array will be. Any help will be appreciated. Regards, Sean well the ...Show All

• Visual Studio Express Editions Saving Changes made in a dataset (Access2002) to the original datasource

  I've just recently started using VB8 and I'm having some problem understanding the way data(changes) from my programm is to be handled, so it will be saved in the original database. I've setup the connection to the database and made a Dataset with the appropriat datatables. When I want to add a new 'record' to the database, using the command Me.SomeTableAdapter.Update() command, only the temporary database in the /bin-directory is updated and not the original one. This temporary database is of course overwritten by a new build. What am I doing wrong     This is a well known issue. There are a couple ways to deal with. The way I deal with it is to move the database to the main directory to begin with. ...Show All

• SQL Server Dimension Range

  I have a simple cube based on just 2 DB tables. I have 1 measure and 5 Dimensions. I need to create some ranges out of 2 numeric Dimensions. Can anyone suggest how to go about it. It may be a simple thing- but I am just a learner...I have tried to use DiscretizationMethod but my ranges are very specific so it does not help. What are the numeric dimensions, and what are the ranges you want to create on the numeric dimensions Your answers will point us in the direction of a solution. An example would be very helpful. PGoldy ...Show All

• .NET Development Run my program on startup - without logging in - is it possible?

  Basically I want my program to be run on startup. The program uses a GUI form. Is there a way that can be accomplished without anybody logging in I'm not really used to windows account and privilege system (linux guy), so any comments are appreciated. If there's no way to do the GUI thing, can I make a service that logs someone in and launches the program Any pointers or suggestions are appreciated. If nothing works I can always have someone log in whenever the computer starts and just put those programs into the startup folder, but I'd rather have it automated. I am trying to show a custom web page if a user log in fails. Can some one tell me how it can be achieved. I tried the article on MSDN about gina ...Show All

• SQL Server Process cannot connect to distributor error !!!

  Hey guys. I am creating an app that uses the RMO Merge Replication objects. So far it can subscribe and unsubscribe just fine but when it comes to the syncing process it gets a little weird, here's why. - If I run the SQL GUI Sync tool, it sinks fine. So that setup is working. - When I run the C# App it blows up witht the error: "Process cannot connect to Distributor" - Here's the weird part: When I set a breakpoint on my custom method SyncData (this method sets up the connection info and properties and then calls Syncronize( ) ) and step through the code when it gets to Syncronize( ) it runs perfectly fine, no execeptions. I thought that maybe the Syncronize( ) method was being called too fast before the connection properties g ...Show All

• SQL Server Connecting to Oracle RDB from SSIS

  Hi Gurus, I am trying to build a Data Warehouse using SSIS in SQL Server 2005. My source data is in Oracle RDB. Now when I am trying to connect to oracle RDB using the OLE DB Source component, I am getting the following error. Test connection failed because of an error in initializing provider. Oracle client and networking componenets were not found. These components are supplied by Oracle Corporation and part of the Oracle Version 7.3.3 or late client software installtion. Provider is unable to funtion until these components are installed. I did install the Oracle RDB client software .Apparently it looks like Microsoft OLE DB for Oracle supports Oracle 7.3.3 and above. At the same time I tried to use ODBC for Oracle RDB driver ...Show All

• Visual C++ Open a browser

  Hi there I have trouble to solve a problem. Imagine the following situation: I use the WinInet-API from Microsoft to login to a sever. The server is written is whatever (i think its Java or something like that). The authentication works over a session cookie (named for example JSESSIONID and contains a string like: "Kjf98zh123on0h834..."). The whole login-process is a 2nd step login with a UID/PWD for the first step and a challenge response code for the second step. But never mind, its not so important. Only that you can imagine what I am talking about if I say "Login to a server". The messages from the server for "Login okay" e.g. and so on are simple ASCII-Text-Messages. I parse them and can see: &q ...Show All

• SQL Server too many cursors

  hi am in situation where i have to place a cursor inside another cursor and within the inner cursor i have to insert record into temp table will this degrade the performance of my sp If so, what should i do thanku Well, if you are actually in the situation where you have to do it, then performance comes second. However, it is very rare to need a cursor, much less a cursor inside in a another cursor. Please post your need and we can help you find a non-cursor solution ...Show All

• SQL Server Keep speed

  Hi... I'm inserting and deleting about 30 000 records into 2 tables each day - import them from a text file using DTS. The users add about 1000 records a day using Access and Windows .NET frontends... Which TSQL commands should I run frequently to keep the database up to speed I'm doing the following ... do you know of anything else Backup LOG MyDataBase WITH TRUNCATE_ONLY DBCC SHRINKDATABASE (MyDataBase , 40) GO Backup LOG tempdb WITH TRUNCATE_ONLY DBCC SHRINKDATABASE (tempdb, 70) GO THANKS!!!!!!!!!!!!!!! Dave There are a lot of different things you can do to keep the speed of your database up, such as: Set the database to Simple Recovery and enable Auto Shrink, this will perform the same function y ...Show All

• SQL Server Calendar is only one.

  How can I drop the same calendar dimention as filter AND columns ...Show All

• SQL Server Chart in Report Builder

  hi there I am just designing a simple chart in Report Builder - but when trying to drag any field into the value field of the chart (it doesn't change colour and won't accept any field). If I drag a field into the category or series the curser changes and on approaching the chart properties they seem to change colour. Can someone help to what can be wrong thanks Dianne hey there Carolyn thank you for your answer - I didn't know that. so if I explain what I wanted to do can you tell me if it is possible some way then. CallID field Application field in my graph I just wanted to show - no of calls per application and as you pointed out my CallID field is not an aggregate ...Show All