Charles Tam's Q&A profile

• Visual Basic Edit properties of controls on other forms

  I understand how to change the value of a textbox by making a new form in the code Dim Form2 as New form ... Form2.show() This however does not work for me, i need to edit existing form controls that i make in the designer. So instead of making a new form in the code, i wnat to just edit one i already made. Right now i can only get the code to run when I dim Form1 as new Form I cant dim it as new, then nothing works and i get null erros and such. Any help will be greatly appreciated, I did search the forums and all i found was what i have above and that wont work, atleast i dont believe it will. I can understand that. Let me try again. I have a project with multiple forms in ...Show All

• .NET Development i need Help

  I started a project that is using a Access Database. Now I loaded the Database in my Database Explorer in Visual Studio. I have already set the connection with the Asistent. Because i am working at home, the destination of my Project is differen then the destination in my enterprise. But i dont want to have the database in the same location like the executable and the project files.  What i need is to change the connection string of this database at runtime. For example i make a codet that is looking  for the database in all locations, when he has found the right location he change the connection string of this database to the new one. But i am not speaking about  DataAdapter, DataSet or DataTable, it is a D ...Show All

• .NET Development problem with install my vb.net application

  hi, i build small application in VB.NET that works whith access' DB i did "publish" to it, and its works fine on my computer. but when i tried to install it in another comupter, i got the message: the application requires that assembly stdole version 7.0.33.0 be installed in the global assembly cache(gac) first. anyone know what i can do with it thanks See if the following helps: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=158186&SiteID=1 ...Show All

• Windows Forms How can I apply sql commands on a dataset?

  for example, I read data from a xml file into a data set, DataSet dSales = new DataSet(); dSales.ReadXml("Sales.xml"); How can I apply sql commands on the dataset dSales like, select sum(FQty),sum(FAmount) from dSales.Table["Sales"] group by F01 . hi, simply you creat a dataView from your dataset.table, and perform all rules you want from it, unfortunatly not all the sql commands are available for example you can't chose fields from more than one table you are abide to single table, if you want data from 2 tables you create 2 dataviews one for each table, search MSDN for System.Data.DataView class also functions like groupby is not available but the ...Show All

• Internet Explorer Development IE 7 and Framsets

  I am using a simple standard framset, in IE 7 the target is all off, opening each page into a new window instead of the proper frame. Is there a solution for this, I have refrences to it being an issue caused with tabing but have not yet seen a solution. Thanks Rian Edwards I found a workaround: go to Internet Options -> Security Tab -> Custom Level look for this setting "Navigate sub-frames across different domains" and set it to Enable (default is Disable). It seems that IE7 handles subdomain from the same domain as different domains, as IE6 didn't do. Hope this helps. ...Show All

• .NET Development How to Fill a OleDbDataAdapter with a DataSet

  Hi, I have a Connection to a Access DB, In the DB is a Query that I need to be displayed on a DataGrid from a Dataset. OleDbConnection OleConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=./MyAccessDB.mdb); OleDbCommand OleComm = new OleDbCommand("SuppliersCliamQuery", OleConn); OleComm.Connection = OleConn; OleComm.CommandType = CommandType.Text; OleComm.CommandText = "SELECT * FROM SuppliersCliamQuery WHERE ClaimNumber = '#23XP'"; DataSet ds = new DataSet(); OleDbDataAdapter myReader = new OleDbDataAdapter(OleComm); myReader.Fill(ds); My Current Query in Access look like this: ClaimNumber ItemDetailsFromClient #12BX P3445 ...Show All

• Visual Studio Team System Help Needed

  Hi All, My requirement is like below. When a user clicks on "Work Items--> Team Queries--> All Tasks" icon . I need to displays a custom built win form . In this custom built win form , user enters some details and the data saved in the database. I have built the custom win form. But i need to know who can i call this form on click on the win form. Has any one did this Thanks in Advance, Sudheer. Thanks Naren for the help. My requirement is "Want to show my winform when some one clicks on All task node in Team Explorer". So as per Ravi's suggestion , do we need to create a addin to solve this puprose Regards, Sudheer ...Show All

• SQL Server The setup has encountered an unexpected error while Setting reporting service and share point exclusion path.

  I got this error message during install with no error code on Server 2003 SP1. I'm installing on an older development machine and although I do have a very large log file somewhere I wanted to post before I even dug into it. I noticed in IIS under my Webs that the MSSQLExpress webs were there at first but when I clicked on them to get any info or Properties... they dissapeared. So they were almost installed but they no longer exist. Also I do not have a SQL Service Manager icon down near the clock. I almost took a step to fix this. After reading a few posts about similar problems I thought maybe this happened because the Default Web Sites IP # was not set to (All Unassigned). I was going to try a repair install from Add/Remove Progr ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Yet another tile game : Psykoban (Sokoban clone, source included)

  This is the fourth game I've made using the XNA framework & GSE, this one is a sokoban clone (sokoban meaning warehouse keeper). The objective is simple, push the boxes/barrels in the appropriate locations to complete the level. But you can only move in one direction and can only push one box/barrel at a time. The game includes 12 levels, and unlike other clones having a character as the player, I used a forklift thing-a-ma-jig . Screenshots/Download Enjoy! Thanks Maximus, About the key(s) not registering, It'll only register if no other keys are pressed and the player isn't moving, I'll try to fix that. For the "hit Start", its mainly because the game can be played with the 360 controller.. maybe I should make a PC and a 360 v ...Show All

• .NET Development Filtering a DataTable By Comparing Column Values in another table

  Hi, I have the following requirement, I have a table let's say Test1 and columns like t1c1,t1c2,t1c3 with n rows and an another table Test2 which has a column t2c1 with n rows. Basically i need to match column t1c1 with t2c2 and get the matching rows without using any for or foreach loop. The implemetation on DataTable should be like below, Select * From Test1 Where t1c1 in (Select t2c1 From Test2) How to accomplish this Regards, Jeevanantham.S Hi, Without loop One way is to index column 1 of table 2 in a dictionary (the indexing is a for loop, but no extra loop when filtering). Regards, Charles ...Show All

• Gadgets Can't get xml back from Amazon Web Service?

  I can put the feed url in the browser and all is well, but I can't seem to get a response using the code below function GetFeed() { var r = Web.Network.createRequest( Web.Network.Type.XML, m_feedUrl, {proxy:"generic", numItems:m_numItems}, OnFeedReceived); r.execute(); } Is the m_feedUrl just too long maybe http://webservices.amazon.com/onca/xml Service=AWSECommerceService&Version=2006-06-07&AWSAccessKeyId=1CE7SK4ZPTNDQZCWBP82&Operation=ListLookup&ListType=WishList&ListId=241KH7V8OZ7EQ&Sort=DateAdded&ResponseGroup=ListItems Any help would be greatly appreciated! Thank you for the suggestions Todd0s! I tried looping through the items with innerHTML ...Show All

• SQL Server Data Driven Subscriptions

  Is it possible to copy an existing Data Driven Subscriptions and make some minor changes Elias ...Show All

• Visual Studio Winform ReportViewer Background Thread

  Hi All I'm currently trying to make our winform application more responsive, and I'm having a few problems with the reportviewer. I'm trying to call RefreshReport on a backgound thread. However, because this method call is intrinsically bound to a control that is on the UI thread, this is not allowed. There in lies my problem. Is there any way to refresh the report asynchronously I'm confused as there is a method called " CancelRendering " that stops background processing of the report. But how on earth do you start it. Any advice would be gratefully received. Hopefully I'm just missing somthing obvious. Regards Darren Let me give you some background on what's happening: The ReportViewer control i ...Show All

• Windows Forms MDI Child Forms not Maximising

  Hello, I had a .NET 1.1 MDI application that I've recently updated to .NET v2.0 but there is a problem with showing MDI child forms that wasn't previously there. The MDI parent is split into two. On the left there is a tree view which, when a node is clicked, shows the relevant MDI child form. The MDI child is set to a fixed tool window and when shown it's maximised to fill the space available in the MDI parent. In .NET v1.1. this worked fine however in .NET v2.0, although the form is shown maximised, the form area being displayed is actually the same size as it is at design time. I know the form is maximised because it can be minimised, and when this is done and then the form is re-maximised it fills the space available as its su ...Show All

• Windows Forms Webbrowser keypress event

  Hello everybody, I'm just playing with the new webbrowsercontrol of .NET 2.0 and I would like to capture the keypress event of that control, but it seems that the control doesn't have that event... I've got a webbrowser control with designmode="on". Now I would like to capture the keypress event (for inserting a line break when enter is pressed) On the internet I could not find any solution, so therefore I hope that there is someone here who knows a solution. THanks in advance Hi Any solution to this problem I tried it using the AttachEventHandler() function for 'keypress' event. But the event arguments are null in that case. So i dont get to know which key is pressed. Any other way to do th ...Show All