danych's Q&A profile

• .NET Development Two dimension array into one dimension array

  I have two dimension array object [,] twoDimArr = new object[3,2]; Later in the code I would like to get only the first column (or row ) of it meaning twoDimArr[1] . How do I do that without running on all the twoDimArr Array attwoDimArr[1,i] and allocating new array for that . Thanks Shauli no good , becasue i get the two dim array from the code - object [,] twoDimArray= (( object [,]) range[1, 9].Value2); where range is Microsoft.Office.Interop.Excel. Range ; ...Show All

• SQL Server Creating full-text indexes on a table in a publication

  I have a table that is in a one way transactional publication. I need to create a full-text catalog on this table and have that catalog exist on the subscriber as well. I understand simply creating a FTC for an object in a publication will not cause that FTC to be replicated to the subscribers. I have scripted out the command and tried to use sp_addscriptexec to push it to the subscriber. When I do this, I get the following error: Last 183 characters in 'sqlcmd' output buffer: Changed database context to 'database'. Msg 574, Level 16, State 1, Server SQLSERVER, Line 2 CREATE FULLTEXT CATALOG statement cannot be used inside a user transaction. Also, when this script is run directly from the subscriber, it works fine (but since the subscribe ...Show All

• SQL Server SQL Server evaluation period has expired??!

  Hi, Today my SQL Server Express suddenly stopped working. After a few hours troubleshooting I finaly found something in the Event Viewer/Application Errors: SQL Server evaluation period has expired...Isn’t the express edition supposed to be free . By the way: Windows did 27 automatic updates just before this happened. Might have something to do with it. Is there a easy way to deal with this or do I have to reinstall and just hoping that I can restore my database Most greateful for any answers! Johan Hi, normally SQL Server Express should not expire. Do you have other instances running on that machine They could cause the problem, but you should only not be able to connect to the SKU that ...Show All

• Visual Basic Combobox sort

  Me .cboList.BindingContext = New BindingContext Me .cboList.DataSource = Me .RealList.SEL_Full Me .cboList.DisplayMember = "Full" Me .cboList.ValueMember = "ID" I have a combo box, I showed how i fill the data. I want the data to be sorted, There is a SORT property of combobox. When i use the SORT property of the comcobox i have such result: 1/ xyxyxy 11/ Ksak 12/ pyuoi 13/ iotry 2/ oitjh 23/ iuy 3/ ktpoyku 4/ ewre To be honest it works :)... But i would like it to sort like this. 1/ xyxyxy 2/ oitjh 3/ ktpoyku 4/ ewre 11/ Ksak 12/ pyuoi 13/ iotry 23/ iuy I woul like it to use 2 digits instead of only the first digit...I also tried to sort the data from the Stored Procedure by us ...Show All

• SQL Server Zero Aggregations Created

  Hi Friends, We have year depended cubes. This year i just copied last year cubes and replaced data source, what happens is when i use by Storage Design Wizard it creates zero Aggregations. Can you tell me what could be the reason. This is very urgent. Regards, Kaushal Hi Edward, I am using Analysis Services 2000. I found the reason why it was not calculating any aggregations, problem is i have not used "All Level". Without using "All Level" can i calculate aggregations. Regards, Kaushal ...Show All

• Audio and Video Development ihdsim crashes

  ihdsim crashes after 3 or 4 times refreshing (ctrl+r). Using V6.0.5285.0. ...Show All

• SQL Server Issues with SMO Transfer

  I am trying to come up with a way to copy a database from one server to another. I have been running tests using the Transfer method from SMO. I can make it work in some cases and not in others. Currently I am trying to copy a database and am getting an error in a script to create a View. This View is the first one in the list of views from the source database. The problem appears to be that this View refers to another view that has yet to be created in the new database. Is there a way to handle this kind of dependency or is this a limitation to the Transfer method. I was hoping to avoid having to do that. The odd thing about this issue is when we create our database from scripts generated from DB Ghost and then attempt the transfer ...Show All

• .NET Development Can Lease Expiry have anything to do with changing of system time?

  I have a .Net Client/Server application. On some occassions it so occurs that the connection between the client and the server breaks, on changing the system time. I couldnt find the source of this problem yet. I am using the Lease mechanism to keep the server objects active when the client is connected.The Lease is renewed every x minutes.I was wondering whether the Remoting Library also internally uses system time to keep track of Lease expiry and whether the changing system time fools it to expire a lease Can anyone comment on this Regards Vipul Shah The PC time is being synchronized with the PLC Time. The PLC is being used to control the machine for which the software is being developed and ...Show All

• Visual Studio Express Editions how can i add gradient color to a usercontrol and or panel backcolor from my.settings

  Hi i'm new to programing. I would like to know how i can add gradient colors to a usercontrol and on a panel. i woul like to select the colors from the my.settings.topcolor and mysetings.bottomcolor. ahmedilyas helped me to set the forms back gradient color. how can i set the back color on a panel and usercontrol. see sample code below for the form gradient background color. i would like to instead of specifying the colors blue and white i would select them from the my.setting Protected overrides sub OnPaint(ByVal e as PaintEventArgs) Dim theBackground as System.Drawing.Drawing2D.LinearGradientBrush theBackground = new System.Drawing.Drawing2D.LinearGradientBrush(new Point(0, 0), new point(0, ClientSize.Height ...Show All

• Visual Studio Problem installing SP1 Update for Vista

  Hi, the Vista Update for SP1 doesn't install. The error message says wrong version of programm or not installed. I installed VS2005 Pro + SP1 GERMAN. Is it the language which is wrong ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Direct X 7 Direct Draw related question(novice)

  Hi I just have joined to the world of Direct X. Now I'm trying to make some basic direct draw game to understand Direct X. And I found some difficult problems that I cannot solve by myself. Since MSDN was still providing useless, less-example based references that I cannot understand, I'm looking for detailed help from real-world person. My first goal is to make basic game with Direct X 7(ONLY). Especially intensifying on Direct Draw technology. Because game I trying to make is text-based simple graphic game. Detailed examples would be welcomed. Because I'm just a novice. (*DD->Direct Draw) Questions are following: 1. How can I draw texts with specific fonts on surface I know that there is simple way t ...Show All

• Visual Basic Throw Exception

  I've got several text files in a folder. I would like the user to input the name of the file to open it. It can be achieved in this way: Process.Start("C:/Text Files/" + Me.TextBox1.Text + ".txt") My question is that if the user inputs a file name which doesn't exist in the folder, how to give the user a wrong message edited by myself, rather than the exception thrown by the programme. I would actually check the file existed first and only do this if the file actually did exists Try If My.Computer.FileSystem.FileExists("C:\Text Files\" & me.textbox1.text & ".txt" ) Then Process.Start("C:\Text Files\" ...Show All

• Visual Studio 2008 (Pre-release) Re-usable code Best Practice / Method with UserControl

  I have written a little framework that allows me to control "mini windows" in a canvas. Allow me to further explain. I have a usercontrol I wrote, that includes a titlebar with title, and two button minimize and close. Below this titlebar is the "content" of this "mini-window", labels, textboxes, etc etc. There is also some initial handshaking that occurs when a mini-window opens up. All of this is contained in one single usercontrol, along with the content of the "mini-window". What I would like to do, though I have no idea how, is bring the code for the handshaking and titlebar ui layout to a "higher" level that can be placed on a new thing. I say thing because I assume that I wo ...Show All

• Visual Studio Express Editions Need help with "Saving Data to a Database"

  Hi, I have VBExpress and Access with WinXP. I started a new project, created a new datasource by connecting to the "Northwind traders" database. From the datasource window I selected the Employee node and set the control type to "Detail". I then dragged the Employees node to my form1 and got a bindingnavigator and several textboxes. When I click on "Add New" and "Save" without entering any data, I get an error which indicates that Null values are not allowed in some of the fields. I have been trying to insert validation code but it is obvious that I know not what I am doing! What is the "Best Practice" method of dealing with this issue I ...Show All

• Visual Studio missing Microsoft.WebApplication.targets for flavored web projects.

  Hi, I ran IronPython and tried to add an ASP web application from the Windows Project and got an error. It appears to be missing a file, "C:\Program Files\MSBuild\Microsoft\VisualStudio\v8.0\WebApplications\Microsoft.WebApplication.targets". I've checked and the file is indeed not there. Is web flavoring supported yet If so, can I get the specified missing file Thanks, Hi, Could you please tell me url to download webapplicationsetup.msi file Thanks, Shobha ...Show All