osmansays's Q&A profile

• SQL Server Error:Procedure or function CatalogJSummary has too many arguments specified

  hello, all I am using a Stored procedure and calling this in my code in C#. Here is my procedure: CatalogJSummary ( @SeriesId INT ) AS SELECT Games.GameName, Games.Id AS GameId FROM GameCodes INNER JOIN Games ON GameCodes.GameId = Games.Id INNER JOIN MobileSeries ON GameCodes.SeriesId = MobileSeries.Id INNER JOIN Mobiles ON MobileSeries.Id = Mobiles.SeriesId GROUP BY Games.GameName, Games.Id, MobileSeries.Id HAVING (MobileSeries.Id = @SeriesId) RETURN and here is the calling C# code:: public DataSet CatalogJSummary( int sid) { SqlConnec ...Show All

• Visual Studio Team System team build of C# and C++ projects

  Hi, I am working on managed code projects written in C# and C++. Now, iam trying to build using Team build. It seems its not possible to build them with one buildtype because platform settings. Is there any possible solution Thanks in advance. Yes, you can build them in one build type. Use "Mixed Platforms" as the platform. Thanks. ...Show All

• Visual Studio Team System How to exclude a Folder from a Webproject

  Hi We are testing here TFS SP3, and have the following question. We have a website project, that uses TFS as source-control. When adding some files to the folder of the webpage, TFS automaticly adds it to the TFS Soruce control. But when doing checking, it always wants also to checking these files, but I don't want to checking that, as this is just test-data created on the local environment. What do I have to do Thanks Patrick You can correct the TeamBuild issue by overriding AfterGet target to add an exec task and remove read-only attribute on these files, something like the following in TfsBuild.pr ...Show All

• Windows Forms execute a common file in vb2005

  Hello again, i want to execute a common file from vb2005. Example: (i got a listview that contains the name of the file, and a label with the path of it)                listview1.selecteditems(0).text="common.txt"                label1.text = "C:\" so how can i execute "C:\common.txt" with the default program (notepad.exe) I want to use this with any kind of file (eg.: .jpg, .avi, ... etc...) Any idea thnx a lot              ...Show All

• Windows Forms CustomToolboxItem class and DragDrop

  I've implemented a few classes derived from ToolboxItem and have successfully used them to create components on an instance of the DesignSurface class both by selecting an item in the toolbox and drawing a rectangle on the surface and by simply double-clicking the item in the toolbox.  However, I am unable to cause anything to be created using a straight drag/drop operation (i.e. dragging the toolbox item fromt the toolbox to the surface) using my derived classes.  I've copied an approach I've seen in a few of the custom designer samples I've managed to gather, and the code does indeed work for instances of the framework's Toolbo ...Show All

• .NET Development StructLayout Sequential not working for class

  Try running this example: -------------------------------------------------------------------------------- [StructLayout(LayoutKind.Sequential)] class Test { public bool var1; public int var2; } class Program { static unsafe void Main(string[] args) { Test t = new Test(); fixed (bool* p1 = &t.var1) { fixed (int* p2 = &t.var2) { Console.WriteLine("var1 addr = " + (int)p1); Console.WriteLine("var2 addr = " + (int)p2); } } } } ----------------------------------- ...Show All

• .NET Development Assembly class -- Cannot release its resouces after loadfrom

  I am using Assembly.LoadFrom to load an assembly check its version and copy a file over if its old. However, once I load an assembly that process has the resources to that file and the file copy fails. There is no Assembly.Close(), how do I release those resouces Assembly test = Assembly.LoadFrom("test.exe"); String ver = test.GetName().Version; // ....... some conditional logic checking version try { File.Copy(CurrentVersion, NewVersion, true); } catch(Exception e) { // will fail with file is in use by another process.. However, if I take out the Assembly.Loadfrom // and associated code it ...Show All

• Visual Studio Team System VSTS Architect vs. VSTS Developer

  With he proposed changes in MSDN subscriptions and Visual Studio licensing, I now have to make a decision between VSTS Architect and VSTS Developer. As I understand, MSDN Universal subscribers will have a choice - they can either go for VSTS Architect and VSTS Developer. I believe that I need both architecture and development tools. Which out of two should I go for The information was interesting but too high-level to be really useful or answer the questions I feel most developers have. I hope you folks will be releasing something with a bit of meat on it like a feature by feature breakdown of what is included in each edition in t ...Show All

• .NET Development Updating IBindingList from different thread

  I have a DataGridView which draws it's information from a BindingSource. This BindingSource gets it's data from a BindingList. Now, I need to update this BindingList from a different thread than the one that the DataGridView is implemented on. When I try to do this, I catch a thrown exception and the exception says that I cannot modify the control from a different thread (understandable). However, how can I work around this In my opinion, shouldn't the BindingSource or DataGridView controls ensure that the control is updated from the implementing thread Is this a bug Any suggestions would be welcomed - Thanks! ~ matt ...Show All

• SQL Server Does SQL Server Support the "MINUS" Keyword?

  Maybe there's another better way to do this... Anyway, here's what I'm trying to do: I have two tables CarType & Cars. Table CarType has a column CarTypeId which is the primary key (int, identity). Table Cars includes a column CarTypeId (int) which is a foreign key into the CarType table. Now I am trying to build a list of all those CarTypeId entries (from the CarType table) for which there are no Cars (i.e. there is no corresponding entry in the Cars table). I read that there is an SQL " MINUS " keyword that you can use like this: SELECT CarTypeId FROM CarType MINUS SELECT CarTypeId FROM Cars So if CarType c ...Show All

• Visual C# Typedef in C#

  How can the same effect as of C++'s typedef be achieved in C# For instance, I want my assembly to be able to compile either with float or with double data types for the real number calculations, as a means of finding the correct tradeoff of memory consumption/speed and accuracy. I guess I probably can't without deriving a type from System.ValueType and whenever I want to change the actual variable I have to replace everything in that class - Or - making the classes generic. One thing to note is that a using statement is only scoped to your current file (in other words you can't easily reuse your using 'type ...Show All

• SQL Server How to do Minof max and maxof min Calculation in SQL

  Hi all, I have two tables say A and B. and i have the following fields in the two tables A                                                  B vc_low(say 32)                       min_vc(say 35) What is the query to get the MAX of these two fields It should be like ...Show All

• Visual Basic Sending e-mail from Vis Basic

  I know how to send an e-mail from VB based on results of an excel spreadsheet operation.  Is there a way to delay sending the e-mail.  I want to use it as a follow-up tool for sales leads. Another way you can do it is to calculate the date now minus the date on the excel sheet. Assume that sDate , which i set to 07/21/2005, is the date from the cell in your excel sheet. Dim sDate As Date = "07/21/2005" Dim Diff As Integer = DateDiff(DateInterval.Day, sDate, Date .Now ) If Diff > 1 Then 'If the date difference is more then 1.    'Create and send email now End If ...Show All

• Visual Studio Team System automated unit tests

  Hello, I have a Solution consisting of 3 Projects. One main App that depends on a COM-ActiveX Control, and a project that builds an assembly wrapping native C++ code with some image processing algorithms. Additional there is a project that performs the unittest for this project. Everything works fine when I do a local run: the test runs and I get my coverage results. When automating this doing a Build, my compilation still works fine ( after doing some adjustments to the TFSBuild.proj - file as described here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=421666&SiteID=1 ) , but the tests won't run: Das Projekt c:\BuildDir\DicomV ...Show All

• SQL Server Replace strings in Text column

  Hi! I would like to replace some strings (for instance 'mystring1' with 'mystring2') in a column of datatype Text. Replace function does not work with Text columns. The following works: update mytable set myfield=replace(convert(varchar(8000), myfield),'mystring1','mystring2') but it truncates data the exceed the 8000 bytes. Ofcourse I have some rows containing more than 8000 bytes in that field, that's why it is set a Text. Any ideas You might be able to use PATINDEX along with UPDATETEXT to replace all occurances in your TEXT column. Have a look here: http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part3/c1161.msp ...Show All