JordanTan's Q&A profile

• Visual Basic Filling DataGridView with search results

  I have created a simple Visual Basic 2005 application for doing word searches on a SQL Server 2005 database using a Button, TextBox, and ListBox to search and retrieve results based on terms typed into the TextBox. The program works, but I think I would like to use a DataGridView control for the search results instead of the listbox to provide more options for how the results are displayed. Here is the code I used successfully for the Listbox: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim ds As New Documents_DataDataSet Dim ta As New Documents_DataDataSetTa ...Show All

• Visual FoxPro Adding to a report.

  Ok, i have a report that is in foxpro that came with a software called DataTrac. I can open the report and using a table list add fields to the report. The fields are labeled like following. Existing Report Field names: loan_amt borr_phone New Report fields names: gen.loan_amt gen.borr.phone So when the gen.loan_amt fields are added to the reports that for some reason dont need the xxx. part they show the same figure of every record. They wont show the loan_amt for each record. I tried using the style that is in the report like loan_amt but it gives a error when trying to print. Am i missing something. Please let me know. ...Show All

• SQL Server Troble copying data between SQL 2000 and SQL 2005

  When I right-clicked on a SQL 2000 database from the Management studio, and chose "export data", all my views where transferred as tables, which is wrong. I would like to get my tables copied over including triggers and indexes, etc. plus (optionally) my views copied also but at the definition level. How do I make this work The wizard you are using is currently only transferring data. To copy database objects, use the transfer objects tasks from the SSIS designer. Thanks. ...Show All

• Visual Studio .VSSCC file

  Is this file created by Visual Studio, or the the MSSCCI plugin Thanks, JD Hi JD, This file is created by VisualStudio. It is meant to exist only in the source control database, when the solution file is not in the solution's bound root (the folder used for the solution connection to the source control database). The <Solution>.VsScc file contains in that case a relative path (from the solution's file to the bound folder) that allows the scc integration package to correcly open that solution from source control. Alin ...Show All

• Visual Basic VB 2005 Compiler Optimization Discussion

    There's been something percolating in the back of my mind. I come from a computing environment that preceeded windows and the Intel Architecture and instruction set. n comparison to the instruction set that i'm used to, the Intell instruction set looks like a house wreck which may or may not be important to the discussion at hand. Everyone knows that moderators agree on everything and that in moderator space we just stand in love circles and sway back and forth. So when I was discussing a compiler one day, I said I really admired a language which had a seven pass compiler. "Nonsense", was the response, "two will do it." Wi ...Show All

• SQL Server How do a make a bulleted list.

  This is probably a dumb question... I am new to Reporting Services. I have data coming from a DataSet that I would like to make bulleted. Right now I have a text box and an image inside of a list control. It works but it is cheezy. Is there another / better way to accomplish this Thanks. ...Show All

• Visual Studio Printing Local Report Without Preview does not work.

  I use a WindowsForm Reportviewer. C# 2.0 I generate the report and all is OK but when the user try to print (print button in toolbar), the application open the printdialog, I select the printer and press Ok. But the application doesn't generate a document. When I try again, all work fine. If I close the application and restart, occurs the same (first doesn't works, second works, all time works). somebody have any idea Thanks form Spain.               Are you using the RTM version of the controls and of the 2.0 framework   We saw iss ...Show All

• Visual Studio 2008 (Pre-release) Official Release Date

  Hi we are evaluating WPF to use in our product. Can u plz tell me when it will be releases officially If going to release with Windows vista then when vista will be available thanks regards WPF-specific questions are better suited for the WPF forum: http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=119&SiteID=1 thanks chad ...Show All

• Windows Forms Active X Viewing in Internet Explorer

  Hi Everyone, I expect that everyone here are familiar about the activeX content viewing problem in IE. I have got a solution from a website ( a javascript and an HTML code) that solves the problem. This works for flash files: The javascript is downloadable at: http://www.ediy.co.nz/content.asp syscmd=dl&ID=C0CF7FD6627649DA99EADCE5C97BC92D and the HTML code is <script type="text/javascript" src=" (javascript-filename).js "></script> the text in orange color must be replaced by the javascript file's name eg. ieactivate.js Now my question is that anyone can send me a sol ...Show All

• Visual Studio Tools for Office ServerDocument VSTO2 question

  I thought I had the solution I needed: use ServerDocument to change the cached dataset inside a VSTO doc. This would update various bound bookmarks and I would be left with a standard Word doc with my bookmarks replaced by my database data. Problem is, the bookmarks only get replaced when opening the doc, and the VSTO assembly has to be at hand. Is there not a way to have my bookmarks replaced and the new doc saved, without it being a VSTO document   Should I simply be using the Word object model for this and manipulating the bookmarks directly Actually, my end goal is to create PDFs from the Word doc by printing to a postscr ...Show All

• Windows Forms Deploying .NET 2.0 Application to Network?

  I am trying to deploy a .NET 2.0 Application to the network. However, I have run into the Runtime Security Policy problem. The whole point of deploying to the network instead of to each user's machine was to decrease the amount of work involved in the initial deployment and any future deployments. I want to make the deployment process as easy as possible without leaving gaping security holes. I was wondering what the general consensus is on the best way to do this Is it easier to simply just deploy to each user's machine with an auto-update feature built into the application Or would it be better in the long run to digitally ...Show All

• SQL Server Multiple transactions not working in package

  I have a package with two sequence containers, each containing two SQL tasks and a data flow task, executed in that order.  I want to encapsulate the data flow task in a transaction but not the SQL tasks.  I have the TransactionOption property set to 'required' on the data flow tasks and 'supported' on the SQL tasks and the sequence containers.  When I run the package I get a distributed transaction error on the first SQL task of the second sequence container: "[Execute SQL Task] Error: Executing the query "TRUNCATE TABLE DistTransTbl2" failed with the following error: "Distributed transaction completed. Either enlist thi ...Show All

• Windows Forms Updating a local SQL Server Express database

  Hi, I created a SQL Server Express database and added it to my project by using "Project|Add New Item" and selecting "SQL Database". I then added a single table to the database and added a single text column to the table. I dragged the table to an empty form which prompted the UI to automatically add a datagridview, a binding source and a dataset, configured and ready to go. When I run the program, I can add data to the dataset (apparently), but the next time I run the program, the data from the previous session is gone. I have tried all sorts of things including adding an "update" button to invoke the " ...Show All

• Visual Studio Tools for Office ExcelSheet deployment

  Hi, I have seen the following article: To prepare an end user's computer to run Office solutions 1. Install the Microsoft .NET Framework version 2.0 2. Install one of the following editions of Microsoft Office 2003: Microsoft Office Professional Edition 2003. Microsoft Office Professional Enterprise Edition 2003. Microsoft Office Excel 2003. Microsoft Office Word 2003. Microsoft Office Outlook 2003. Microsoft Office Professional Edition 2003 Trial. Microsoft Office System Evaluation 2003 Enterprise Edition. etc...............as in the document. Actually ...Show All

• SQL Server Bulk Insert from Mapped Network Drive

  Hi, I am trying to perform bulk insert using mapped network drive, but getting following error: Server: Msg 4861, Level 16, State 1, Line 1 Could not bulk insert because file ' F:\Download\MVY.b45 ' could not be opened. Operating system error code 5(Access is denied.). F is mapped network drive pointing to my SQL Database Server. While searching, i got the following link but not able to relate with my problem: http://support.microsoft.com/default.aspx scid=kb;en-us;238238 One exe is running on component server [CTom] and copying the data file to mapped drive (i.e. F:\), then bulk insert is trying to insert from that mapped drive. ...Show All