Kamen's Q&A profile

• SQL Server Is it possilbe to load my data directly?

  I have thousands of records, which are .txt format, to be loaded to the DB and need to mining them. The only way for that is to write a program and read them to the DB or can I load them directly And also I have to design the tables based on these data myself, right Thank you. Thank you. I am now investigating the Importing wizard(but the server is not ok..), but I still have a question about the data structure shown as follows: Test Record Number: 1 Prospect ID = 254065363128601034074140572161982 ---(This should be the primary key) Match Score = 90 Input Record Fielding ( eg wordnumber[Field] ) : 1[1] 2[1] 3[1] 4[11] 5[11] 6[11] 7[11] Prospect Word = 1 type = 1 match level = 4 input word = 1 inpu ...Show All

• Windows Live Developer Forums More tiles, please?

  Greetings, I see from the API that there's a way to implement a custom tile layer. Pretty cool, but for the project I'm brewing, I need more tiles (it's a granularity/server resource issue) at all zoom levels than the map engine uses. Is there a way I can implement this, or should I just roll my own tool Cheers, Bradford This is worth a read: http://viavirtualearth.com/vve/Articles/WorldWind.ashx John. ...Show All

• Windows Forms Databinding to Combobox Error! Help Please

  Dear All, I have problem with following code : Private Sub frmProdDataEntry_Load( ByVal sender As Object , ByVal e As System.EventArgs) Handles MyBase .Load Dim Categories As TechManagement.DBComponents.ProductDB = New TechManagement.DBComponents.ProductDB cboCategory.DataSource = Categories.GetProductCategories End Sub When I run the application, following error message appears:- An unhandled exception of type 'System.Exception' occurred in system.windows.forms.dll Additional information: Complex DataBinding accepts as a data source either an IList or an IListSource Thanks a lot in advance Dear Prasant, Thanks for your reply. This is the code I'm using in GetProductcategori ...Show All

• Visual Studio Team System Branching - how to prevent merging into older branches?

  Here's the situation that we ran into.... We have two release versions: 5.0 and 6.0 5.0 is in production and 6.0 is in dev currently. In the meantime there is a call for a maintenance release off 5.0, which we call 5.1. Obviously, we want these changes merged into 6.0. But, we don't want these changes merged into 5.0, because then 5.0 would not be representative of its original form. So....how do we go about merging the changes from 5.1 to 6.0 The only option I see so far is baseless merging from 5.1 to 6.0. Since this scenario is pretty common we will be doing a lot of baseless merges. I would like to stay away from this option if possible since it seems more complex and something that could result in more errors. Any thoughts on how to ...Show All

• SQL Server Dynamic query

  Hello I have a problem with writing a query.Let me give an example: Table: ColA , ColB , ColC , Col1 , Col2 , Col3 , Col4 , Col5 Ok.I must write a SP and it gets a parameter,say @param. if @param=1 then in the select statement I will select Col1,if @param=2 then I will select Col2 and so on. How can I do this Thanks. ------------------------------------------------------------------------------------------------------------------------------------- CREATE PROCEDURE dbo.dynsql @param int AS BEGIN DECLARE @q varchar(max) select @q = 'SELECT sym_no'+CAST(@param AS nvarchar(2)) + ' FROM TABLE' exec sp_executesql @q END execute dynsql 2 ---------------- ...Show All

• SQL Server Updating a Table having a Foreign key constraint

  Hi I am trying to update tables "Table A" & " TableB" with a new value for a particular column1. Now "TableA" contains a foreign key "FK1" defined on it and is referencing another table "Table B" containing the similar column "Column1" Because of this constraint I was not able to update TableA and TableB. My question is 1) If i wanted to go ahead with this update, what are the possible ways 2) If only solution is to drop the constraint. Then How do i know the definition for this particular Foreign key, i mean it may refer some columns in Table B. I wanted to know the complete definition of it so that i can rebuild the constraint after the update. Right now i can se ...Show All

• Windows Forms Collapsible property for custom control

  How can I make property for my custom control collapsible at design time Similar to Size, Location, Padding and other properties. I want to create Dimension property for my control which has collapsible x and y element. Thanks Use a property of type Point or Size. For example: public partial class UserControl1 : UserControl { public UserControl1() { InitializeComponent(); } private Point mDim = new Point(0, 0); [Browsable(true)] public Point Dimension { get { return mDim; } set { mDim = value; } } } ...Show All

• Windows Forms Transparent label control and overriding the WndProc() method

  Hi, In one of my winforms, i override the WndProc() method to paint a vertical gradient background . However, when i placed a label control on the winform and set the label's backcolor property to transparent ; when i run the application, the label control does not blend with the forms gradient background. I tried to use the winform's Paint event but it caused the form to flicker everytime the form is resized or moved. The WndProc() approach solved this for me. Any suggestions to make the Label control's backcolor blend properly with the gradient background the following is the code I used in the WndProc() method: if (m.Msg != UnmanagedCode.WM_ERASEBKGND) { base.WndProc(ref m); } else { if (m.Msg == UnmanagedCode.WM_E ...Show All

• .NET Development Empty String Being Passed

  I have a stored procedure that sends cdo mail, and the sp has a parameter that I can pass a semi-colon separated list to that specifies the attachments for the e-mail.....The e-mail has always worked for me, and when I pass it the attachment parameter from query analyzer it works fine, and it has always worked when the procedure is called via .NET. The problem is that recently I have .NET dll that I created that passes a long list of attachments to the sp, I tried the values from query analyzer and they worked but when I pass them from .NET the sp says the parameter value is blank. There are no errors, it just seems to be not accepting such a long parameter string even though the value is shorter than the parameter length (in both the sp a ...Show All

• Visual Studio Retrieving a CodeElement for a local variable or parameter.

  Hi, I’m wondering if it is possible to retrieve a CodeElement for a local variable inside a method and also for the parameters of a method. I need a CodeElement representing the variable and parameters, in order to call the RenameNoUI of the ICSCodemodelRefactoring interface. I have tried alot of different approaches, like the following: CodeElement element = fileCodeModel.CodeElementFromPoint(editPoint, vsCMElement.vsCMElementVariable); Unfortunately nothing works... Any clues / Joel Hi Joel, Third try, repeat after me :-) : there is no support for procedure variables in the extensibility model for VS 2005. Nor even in the new EnvDTE80 assembly. The classes ending with " ...Show All

• Visual Studio Tools for Office problems re - opening .xsn with the infopath form control for windows

  hi all, im hosting an infopath form in a .NET windows app. and im having trouble re-openning a form once i close it the code is pretty simple: formControl1.NewFromFormTemplate("C:\\MonitorDirectory\\MyTemplate.xsn"); formControl1.XmlForm.Close(); formControl1.NewFromFormTemplate("C:\\MonitorDirectory\\MyTemplate.xsn"); formControl1.XmlForm.Close(); the form open fine the first time, but when i open the same form again it says: infoPath cannot create a blank new form. infoPath cannot open the form because another version of the form template is currently open. if i open "someform.xsn" and close it, and then open "someotherform.xsn" it works. then if i open "someform.xsn" again it' ...Show All

• Visual Studio 2008 (Pre-release) IErrorHandler and FaultException<T>

  I have a service using an IErrorHandler from which I'd like to return typed FaultExceptions. The ProvideFault implementation does something similar to the following: FaultException<GreetingFault> fe = new FaultException<GreetingFault>(new GreetingFault(error.Message)); MessageFault fault = fe.CreateMessageFault(); msg = Message.CreateMessage(version, fault, " http://microsoft.wcf.documentation/ISampleService/SampleMethodGreetingFaultFault "); The invoking operation contract is decorated with the fault contract attribute: [FaultContract(typeof(GreetingFault))] [OperationContract] void MyMethod(); The client application always receives an untyped FaultException, however, and not the FaultException ...Show All

• Visual Studio Express Editions Issues to watch out btw 1.1 and 2.0

  I'm not very sure where to post this qns and i'm using C# so i think this would be the approriate forum to post. I am told to develop some applications using C# in .Net 1.1. However with the usage of express edition, i would be require to use 2.0. I would like to know the possibility of compactability issues if my development is done in 2.0 and deployment over 1.1 framework Appreciate any help. thanks for the advice given... i have another question is that what is the normal practice for developers to do if they require to write an application for .net 1.1 and another application for .net 2.0 on the same machine can both version co exist in the same machine and the developer can choose between the versio ...Show All

• SQL Server Transaction Rollback Issues

  Hi We are loading data from one extract file in to 4 different database tables. When we are loading if the first table gets loaded without any issues and the second table loading gives any issues, we need to rollback the data loaded in to the first table also. In the package for achieving this, we are using Sequence container. In the sequency container we are having 4 different tasks for loading data to 4 different tables from the same extract file. We also tried setting the different transaction options given in the properties box of the packages, container and tasks. Also we tried the properties by setting as mentioned in the Test# 7 and 8 in the following URL http://www.sqlservercentral.com/c ...Show All

• Windows Forms Control values do not refresh

  I have 2 projects: Project 1: A strongly typed dataset with a table etc. I have some code in the ColumnChanged event that looks like this: Select Case e.Column.ColumnName Case Me.columnDISCOUNT.ColumnName Dim r As REQUEST_LINERow = CType(e.Row, REQUEST_LINERow) r.UNIT_COST = r.LINE_PRICE * r.DISCOUNT End Select Project 2: A windows form that has the above dataset placed on it, a BindingSource (bound to the dataset) and several textboxes (bound to the BindingSource). When the user changes the discount text box (by tying a new value). I would expect the Unit Cost text box to update with the newly calculated value as a result of the ColumnChanged event. However the new value does not appear. The new value howev ...Show All