Stanislav D's Q&A profile
Visual Studio Express Editions C# connect a SQLDATABASE
hi I'm try to connect my aplication a data base in SQL SERVER but i have a error "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)" And the code it's SqlConnection sqlConn = new SqlConnection( "Data Source=AttachDbFilename=bd.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" ); sqlConn.Open(); SqlCommand sqlComm = new ...Show All
SQL Server Copying database using "Copy Database"
I am struggling with the "Copy Database Wizard" in SQL Server 2005. I am used to working with DTS to copy data from one server to another, but with the new tools, I am having serious problems (in fact, it's unusable) 1. When copying a database using the "SQL Management Object" method, I always get errors concerning logins. If I select not to copy logins, I get errors "sp_grantdbaccess failed". If I do select to copy logins, the logins can't be created because the machine names are different (one the source machine, the login is called MACHINE1/mylogin, but on the destination machine, such a login cannot be created) 2. For small databas ...Show All
Visual Studio 2008 (Pre-release) ListView not using Style when data bind
I have a ListView control on the screen. In one of the columns, I want to display a complex type, "DistributorInformation". In the <Application.Resources>, I have defined < DataTemplate DataType = " {x:Type src:DistributorInformation} " > ... If I display something of this type in a ListBox, it works great. However, when I try showing it in a ListView, it doesn't pick up my default DataTemplate. I defined it like this and assumed it would pick up the default template: < GridViewColumn Header = " Country Earned " DisplayMemberBinding = " {Binding Path=DistributorInfo} " ...Show All
Visual Basic COM Interop, Property Get,Let,Set Interface Attribute?
Hello, We are in the middle of a rather large piecemeal upgrade of our VB6 system to .NET 2.0. We started in 1.1 and have sence migrated that code to 2.0. We have done a few of our libraries to this point, and are gearing up to upgrade a lot more of them in the next month or so. We ran into a problem in our first library that required a rather nasty fix and I was hoping someone could point us to a better solution. Problem: The problem we are having is in VB6 we defined many properties of type Variant for the sole purpose of being able to store Null. These properties are typically used t ...Show All
Visual Studio Team System From services to application model to conceptual model
I am reading Analize requirement and Dev. solution, MS Press and have some confusions about the conceptual model. How do i create a conceptual model after defining services and selecting an application architecture Can you give me an example about conceptual model Thank Thank Caron. The book I read is for exam 70-300. I heard about VS Team 2005 but this book does not mention anything about VS Team at all . In the step creating conceptual model we refine use cases, create usage scenarios, select an application architecture like client/server, layered,ect. and then create the conceptual model. If the conceptual model "is most closely r ...Show All
.NET Development selecting network interfaces
Hello everyone, I have been trying to find a way to activate/inactivate network cards in .NET, kinda like ifconfig up and ifconfig down on Linux. The reason is that I simply don't want Windows to automatically choose one interface over the other and use this, but to decide for myself. Is there any good way to do this in .NET I found that IP Helper API can list all interfaces, but it does not seem to be able to manage them. Thanks a lot for any tips! / Roland Ahh, yes. We could have pointed you in that direction if you had mentioned that it was for use with a socket. Your original question only spec ...Show All
Visual Studio GetService allways returns null
I created a project using the "Visual Studio Integration Package" wizzard. trying IVsTrackSelectionEx Tracker = ( IVsTrackSelectionEx )provider.GetService( typeof ( SVsTrackSelectionEx )); returns Traccker==null. I've tried it in the MyToolWindow class as well as in the VsPackage1 class, also using GetGlobalService(). I just cant get a reference. By the way, is the IVsTrackSelectionEx the correct service to use if I want to show properties in the PropertyGrid Thanks in advance, Louis Have a look at the following blog post: http://weblogs.asp.net/gmilano/archive/2004/04/30/124342.a ...Show All
SQL Server dimension records exceeds 64000
I am facing a problem in SSAS, unlike Analysis service 2000 , I cannot find any grouping under level properties for a dimension. Actually one of the dimension is too big, some 1600000 records are there and no hierarchy as such. only way is to club by first alphabet,which we were using in 2000. i.e. by using the grouping property. but in SSAS 2005 I cannot find any, how do i overcome this, otherwise beyond 64000 records its not showing There has been a change in terminology in AS2005. Instead of grouping this functionality is refered as Discretization. You need to create a new attribute based on the same column as your main attribute. ...Show All
SQL Server mdx question
I have 2 dimension tables :students and classes related through a fact table that contains the keys of these tables in addition to other keys such as academic year and other stuff. the classes dimension has an attribute called class_department. what is the statement in mdx to get the class_department for a student in students table thanks Christina I guess you want the MDX query Since I don't know the naming of your dimensions/members/measures, I will just give it a shot with some similar names. I assume that you have one measure in your fact table - a count measure. SELECT {[Measures].[Coun ...Show All
Windows Forms Basic Problem, i guess
Hi All, This is my first post as i just started using WinForms. I am looking at an equivalent code for WinForms. I have been using Webforms for a while. The following code is related to Webforms. <CODE> dgDetails.DataSource = fetchDetails() dgDetails.DataBind() For i = 0 To dgDetails.Items.Count - 1 If dgDetails.Items(i).Cel ...Show All
.NET Development Visual Studio 2005 NEW Data Access Methods!
Hi, I've been using Visual Studio 2003 for a few months (having come from Java). I had just got used to using datasets and data adapters and stuff, then Visual Studio 2005 comes along and changes it all !!! It's supposed to be easier, but I dunno! My question, is this : - I have just created a datasource called PhonebookDS which is my single oracle table. I dragged a single field over to my blank windows form, and it created a TableAdapter and a binding source for me. All OK so far! But, HOW do I access the original SQL string so I can change it from 'SELECT * FROM PHONEBOOK' to 'SELECT * FROM PHONEBOOK WHERE SURNAME = ' ...Show All
Visual C# System.net not able to configure IE explorer's proxy setting?
I realize that there seems no way to use classes under System.net to configure IE explorer's proxy setting. Everybody seems to point to wininet.dll, which i dont quite like to use. Unless microsft create a managed version of wininet.dll , otherwise, I prefer to use System.net classes to change IE explorer's proxy setting...but is that possible ...Show All
SQL Server Top 20 ordered and rest grouped into 'others'
Hi guys. I want to create a top 20 product list from a few thousand products. I want the rest of the products to be grouped into 'others'... I also want the products to be ordered by the facts in the cube. Thus the product dimension would dynamically change depending on the Time dimension thats being selected. is this plausible Thanks Tom No, this query is for trying in MDX Sample Application if you are using AS 2000 or directly in the Microsoft Managment Stuidio if you are using AS 2005. When you are designing a cube the only part of the query is that is between ' '. ...Show All
Windows Forms stell having problem
to use the toolbarstrip i need winfx sdk i found "Public November 2004 Avalon CTP Release.msi" but when i double click on it the exproler get stuck how can i install it and do i have to install the winfx sdk i have visual studio 2002 sp1 , winxp pro sp2 I'm assuming you're referring to the new ToolStrip control. To use this, you'll need a version of Visual Studio 2005. You can download Beta 2 from: http://lab.msdn.microsoft.com/vs2005/ - mike ...Show All
Visual C++ a paradox in mfc head file?
problem code: pMetaFileDC->SelectObject(newPen); when debug, it causes an assertion. the source is: { ASSERT(m_hDC == m_hAttribDC); // ASSERT a simple CDC object return (hObject != NULL) ::SelectObject(m_hDC, hObject) : NULL; } ok, then i write this: pDoc->pMetaFileDC->SetAttribDC(pDoc->pMetaFileDC->GetSafeHdc()); but this fuciton do not work as supposed. and the assertion remains. look into the source code: & ...Show All
