Sanjoyan's Q&A profile

• SQL Server Beginning SSIS - Sharepoint and Excel

  Hi all, I have never used SSIS before, but am looking to use it in this aspect: 1) A user uploads an Excel file into Sharepoint. This will be through a Document Library in a Sharepoint page. 2) When this file is uploaded, I'd like SSIS to notice there is a new file and process it - it will pull information from the Excel file, put it into a database, and - if this is possible - delete the new file. 3) This is iffy. Can SSIS then generate an InfoPath document  from the information stored in the database If not, I can just have a InfoPath query form. I'd just like to know if this is possible. If you have any helpful links, ple ...Show All

• Smart Device Development WSAEINPROGRESS

    When i use the method getRequestStream() of an object HttpWebRequest, and try to write to this stream i got a socket exception. The errorcode is 10036, WSAEINPROGRESS.             Dim postBytes() As Byte             Dim asciiEncode As Encoding = New ASCIIEncoding             postBytes = asciiEncode.GetBytes(Me.mQuery)             httpReq.ContentType = "application/x-www-form-urlencoded"     ...Show All

• Visual Studio Team System Team Build, exclude a project.

  I have team build successfully building a solution, however, the solution contains a database project (*.dbp) which produces a warning of "*.dbp is not supported by MSBuild and cannot be built".  Is there any way to exclude this from even being attempted to be built in the TFSBuild.proj Hi Ridge, The TFSBuild.proj file only gives an option to choose which solutions to include/exclude in the build process. In order to exclude building a project that is part of the solution, I am afraid you will have to modify the solution file itself. You can either edit the .sln file in notepad or open the solution in VS and choose "Exclude Proje ...Show All

• Visual C++ Traversing a Directory using Visual Studios 6.0 C++

  Hello Guys. I am writing a program for a friend that needs to traverse a directory. The user enters a directory location, and then the program needs to display a "list" of the file paths in that directory. For instance, the user enters the following directory location: c:\Program Files\Code and this directory contains five files: first.txt second.txt third.txt fourth.txt fifth.txt what I need to do is be able to extract the file locations of the five files. So the program must return a list of the following: c:\Program Files\Code\first.txt c:\Program Files\Code\second.txt c:\Program Files\Code\third.txt c:\Program Files\Code\fourth.txt c:\Pr ...Show All

• Visual Studio Express Editions data view multiple search

  hi there any advise would be greatly appreacated im trying to filter a datagrid i only want to show records with eather 1 or 2 or both in one column but i cant seam to figure it out the code i have so far goes as follow but it only shows the rows with 2 in there column Dim toorder2 As Integer Dim toorder As Integer toorder = 1 toorder2 = 2 Me .Tyre_stockTableAdapter.Fill( Me .WorkshopDatareoreder.tyre_stock, New System.Nullable( Of Integer )( CType (toorder, Integer ))) Me .Tyre_stockTableAdapter.Fill( Me .WorkshopDatareoreder.tyre_stock, New System.Nullable( Of Integer )( CType (toorder2, Integer ) ...Show All

• Visual Studio Express Editions Deleting a record from dataset

  I have a table in an Sql database with 2 columns. One column is the record ID and Primary key the other is the information item I am storing. I have a form with a List box that is populated by the dataset and displays the information column from the above table. When a user selects one of the items in the list box and clicks a Delete button I want to delete the record for that item. What I have found is that I can delete the item but sometimes the wrong item is deleted from the dataset. I know the problem is that I am grabbing the Index number from the list box and using it to delete the record in the dataset. These two do not always ma ...Show All

• Visual Studio Express Editions Sifting through array for matches

  Hello all, Sorry for such a beginner question, but I can't seem to work through this. I've thought about it for a while, and I just can't seem to figure out a solution. Sorry in advance: I've got an array with a bunch of names in it, and I want to sift through it to make sure that none of the names are the same, and if they are, then I want to take out one of the matches from that pair. So for instance, if i've got an array that contains the names: Robert Rob Jacob Jack Jacob I want to be able to go through and find that second jacob to take it out, so that the array only contains the names Robert Rob ...Show All

• Visual Studio Express Editions First Project

  I have been charged with gathering all incoming faxes, converting them to PDF files and thru keywords (Names Departments etc.) sending them to specific personel using Active Directory. I have a program that will convert to PDF, but I need to know how to search and distribute with (I hope) VB. I am brand new to this so any help would be greatly appreciated. OMG Tally, To what degree is this to be automated My gosh.... how familiar are you with Object oriented programming. I really don't feel that this is an appropriate assignment. ...Show All

• SQL Server Cannot attached Personal.mdf

  SQL 2005 CTP does not like the personal.mdf from the Starter kit.  I cannot attach the file at all.  Can someone send me the scripts for database build   Thanks. sorry, I'm not familiar with personal.mdf.  Could you post the command you're executing as well as the error you're getting ...Show All

• Windows Forms conn.Close() doesnt actually close connections

  I am using this connection called 'conn'. After my operations I always do the conn.Close( )  I was under the assumption that the connections would close, but my SQL Admin showed me a window in the Enterprise Manager with those connections still on. Is there any other way to do it. VB6 allowed one to do xx.activeConnection = Nothing and that did&nb ...Show All

• Visual Studio Express Editions VB + SQL server vs Access

  I am very new to programming etc so I may be misunderstanding the situation, but my question is this: VB.Net Express is a programming language which comes with database functionality via SQL Server Express, whereas Access is a Database which is programmable via VBA. So, if one is developing a (fairly simple) database based application what are the pros and cons of using one set of software tools versus the other Thanks for any insights. Eric It really depends on your field of expertise. Personally, I'd crank out something faster using C# and SQL Server, because that's what I do. But, Access is definately e ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Device Lost Problem

  I am having a problem with losing the device that I'm not sure about. The window can be minimized, lose focus to another app, and be resized with no problem. The problem occurs if in WinXP the user hits cntl-alt-del and then goes back (either by canceling or by unlocking later). The device can't seem to recover properly from this. Sometimes I can even continue drawing to the device after coming back but resizing it immediately breaks it (when you could resize fine before). Has anyone had this kind of experience and solved it Does somebody have a clear example in C# for how to handle the device lost, resize, and reset events cleanly in MDX ...Show All

• .NET Development Show/Hide Placeholder in JavaScript

  Hi, I have a Placeholder with a calender control in it. When you click on a button im calling som javascript: (In the button property OnClientClick is advancedSearch_Click()) function advancedSearch_Click(){ var theElement = document.getElementById( "myPlaceholder" ); alert("HI"); if (theElement.visible == false) { theElement.visible = true; } else { theElement.visible = true; } alert("The End"); } The alert HI is shown, but The end is not show, that is because something is wrong but what Can't I say visible on a placeholder Thanks for the help Best Regards Kim ...Show All

• Visual Studio SCC API Deployment Question - Getting Rid of Error Message

  Hi, I've researched this topic for a while now and no one seems to be able to provide an answer. What exactly must be done to get VS.NET 2003 to stop showing the "The installed source control provider does not support all the capabilities required to integration into Visual Studio. Do you want to try using it anyway " question The VSIP documentation states that "while you are adding capabilities" you will see this error.  What capabilities are required to get this error to stop I have seen a couple of people ask this question, but no one's answered it yet.  Any help would be SO appreciated! I answ ...Show All

• Visual Studio Express Editions search a directory

  Hello! I'm experimenting with making a simple media player in Visual C# Express edition. I would like to know exacly how to open a directory and list only the .mp3 files or .ogg files in the listview I'm unsure how to do this. If you can point me to a good example or article, I would be very thankful. Thank you. hi, what you asking about is System.IO name space it have directoryinfo and fileinfo classes that you can that, it will be something like that using System.IO; namespace WindowsApplication1 { //this form contain listbox and a button public partial class Form ...Show All