zebber04's Q&A profile

• Visual C# How to merge in new data from second dataset

  If you fill one dataset with data wait a while and then fill another dataset with a later version of the same table: How do you find which rows have been modified, deleted, added without looping through each one in two foreach loops (for the two tables) foreach datarow in the first table { foreach datarow in the second table { itemarray_1.equals(itemarray_2) } } Hi, try looking at the Merge method of the Dataset: http://msdn2.microsoft.com/en-us/library/system.data.dataset.merge.aspx To get all changes in your dataset use the Dataset.GetChanges http://msdn2.microsoft.com/en-us/library/system.data.dataset.getchanges.aspx cheers, Paul June A. Domag ...Show All

• Visual Studio 2008 (Pre-release) ASP.NET Integration

  I'm curious as to the plans you have for integration with ASP.NET, especially things like the ObjectDataSource control. Given that there's no template for ASP.NET, I suspect that you've not done much work in this area specifically. I'm particularly thinking about Update/Delete scenarios; while the EDF entity works well through through the ObjectDataSource, I'm wondering if you're thinking of more involvement. For example, removing the requirement for actually having methods to perform Insert/Update/Delete operations; could these somehow be implemented as part of the entity itself Have you thought about this at all If creating the methods is a requirement (and I can think of many reasons why it could be), are there improvements I can do ...Show All

• Visual C# Displaying The Form?

  Hi, I'm new here. I am making an application, and was going quite well in the design of the Form, but now, after saving, I cannot find the Form again. I've looked thorugh the Browser, but couldn't find a thing. This is a really novice question, but I cannot find the answer. Where are saved Forms located First of all welcome to the MSDN Forums and thanks for participating in it! I don't fully understand your question but when you add a Form to your project is will be created as a FormName.cs file and when you are using Visual Studio 2005 it will also create a FormName.Designer.cs file. You will find this form in the project directory of the project where you added the Form. Default, projects are cre ...Show All

• SQL Server OpenQuery() to Linked Server hangs, leaving SPID with open tran, then templog.ldf grows without limit.

  Hi, We have a customer that is using SQL Server 2000, and experiencing the following intermittent problem -- occasionally templog.ldf will grow and grow until it fills the entire disk. This is a rare problem, it has happened less than 10 times in the past two years, for a job that runs once a minute. But it has happened on 3 different SQL Servers, (two production servers, and one test server). Our suspicion is that the root cause is an OPENQUERY() to pull data from a linked server (Oracle database on Unix). We have seen that these OPENQUERY() statements occasionally hang and cannot be killed. The OPENQUERY() is used to populate a local table, and when we originally populated permanent tables with OPENQUERY(), then there would be a ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Where is the download?

  It is 12:48 pm here (GMT + 1)... in Nuku'alofa (GMT + 13) it is tomorrow... So where the hell is my download link :-D :'( Its like 1am in the states so i guess we are waiting for them :(. This is like xmas and Bill Gates is our dad, wake up Billy so I can open my XNA! ...Show All

• SQL Server problem running vb.net application with sqlexpress in system with only .NET FRAMEWORK

  Hi, I have developed a stand alone application that get data from excel and dumps it in local database (sql server database primary data file) in visual studio .net 2005. I had no issues while developing the application. When i am trying to install this application in the standalone system with .net framework 2.0 and no backend database it giving the following error provider: sql network interfaces, error 26 - Error locating Server/ Instance Specified connection string i am using is Dim objLocalDB As System.Data.SqlClient.SqlConnection objLocalDB = New System.Data.SqlClient.SqlConnection( "Data Source=.\SQLEXPRESS;AttachDbFilename=" & System.AppDomain.CurrentDomain.BaseDirectory & "LFDB.md ...Show All

• Windows Forms creating dynamic textbox controls with a click of the button

  I need to create X number of text boxes during runtime. I have a combo box with a list of opperations the user selects an operation from the list then clicks Add step. I need to create a textbox1 then put the selected items text in the textbox. user selects another item clicks enter I need to create textbox(2)..... place the next text box at location 10 below I under stand how to create dynammicly but how do I dynamiclay change the names .... My code (but names are hard coded to create at run time Dim dymTxtStart As TextBox = Nothing dymTxtStart = New TextBox dymTxtStart.Name = "step1" dymTxtStart.Location = New System.Drawing.Point(10, 100) Me .Controls.Add(dymTxtStart) Dim startte ...Show All

• Visual Studio Express Editions How to detect 3 key sequence pressed

  I need to pop up a form when 3 keys are pressed. I tried this but it didn't work. compiles ok, just dosen't work. If e.KeyChar = (Chr(Keys.B) & Chr(Keys.Q) & Chr(Keys.K)) Then e.Handled = True MsgBox("You pressed the B Q and K keys") ' I would do form open here. End If Any Ideas Thanks Dave Sorry, the code is in the press event as below... Private Sub Form1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles Me.KeyPress If e.KeyChar = (Chr(Keys.B) & Chr(Keys.Q) & Chr(Keys.K)) Then e.Handled = True MsgBox("You pressed the BQ AND K keys") End If End Sub Dave ...Show All

• Visual Studio Express Editions How to display a .xls file data in my form or tab page?

  Hi, how to display a .xls file data in my form or tab page Can the data be edited from the form or tab page OleDbConnection theExcelConnection = new OleDbConnection ( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application .StartupPath + "\\Book1.xls;Extended Properties=\"Excel 8.0;\"" );   The Data Source=" + Application.StartupPath   needs to be changed. So if your file was C:\Book1.xls then: OleDbConnection theExcelConnection = new OleDbConnection ( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\ Book1.xls;Extended Properties=\"Excel 8.0;\"" ); whenever you need to do a backslash, make sure you add 2 backslashes instead of 1 in C# as it is an escape character ...Show All

• Visual Studio Tools for Office Finding the current Table

  Hi, I have a Smart document with XML tags inside of a Word.Table. The rows repeat these XML tags so I end up with Word.XMLNodes. This is not a problem, but I would like to have different information load into my action pane when different XMLNodes are entered meaning that I want the user to enter information into the action pane, then be able to come back to the same node and populate the action pane with the previously entered information. I would also like to have different information for each XML node created by the user(as rows are added to the table). How do I get the row index of the entered node Thank you in advance for your help and support. For this case, it might be better to capture the ...Show All

• Visual Studio Team System No backslahes in regular expressions for work item rules? (MATCH pattern attribute)

  I attempted to write a regular expression to disallow backslashes in work item titles. It looks like this in the work item type definition XML: <FIELD name="Title" refname="System.Title" type="String"> <MATCH pattern="^[^\\]*$"/><!--disallows backslashes--> </FIELD> However, the server rejects it: Xml validation error at row 11, column 13: The 'pattern' attribute is invalid - The value '^[^\\]*$' is invalid according to its datatype 'http://schemas.microsoft.com/VisualStudio/2005/workitemtracking/typelib:NonEmptyPlainConstant' - The Pattern constraint failed. Looking up the "Non empty plain constant" in typelib.xsd, I can see that backslashes are prohibited! <!-- Non-empty plain constant --> ...Show All

• Visual C++ Function return values?

  I just noticed that the "Autos" window does not show the values returned by functions. These did appear in VS6. Has this capability been lost, or is there some setting that needs to be changed in order to have the return values displayed When I am running a debug build (all debugging info present, all optimizations turned off), the function return values do not appear in the autos window. So how do I see what they are ...Show All

• .NET Development Object must implement IConvertable

  Object must implement IConvertable MS Data Access Application Block returns the subject error when passing more than one parameter to a stored procedure.Does anyone know a work-around this problem for C# Thanks in advance Hello All. Furqanms: Okay, then use SqlDbType.SmallInt. ...Show All

• Visual C# doubt in FOR loop urgent .

  DateTime sdate=Convert.ToDateTime(amcsdate.Text); DateTime edate=Convert.ToDateTime(amcedate.Text); DateTime i; for(i=sdate;i<=edate;i=i.AddMonths(1)) { Response.Write(i); } above coding works fine . how to store the values of i in different variable like d1,d2,d3 etc. Example : sdate = jul 03 2006 edate = jul 03 2007 now i want to store the value of i in d1,d2,d3,d4.........etc till i <= edate . after getting the values of d1,d2 etc i will be storing in database . my table format : d1 d2 d3 d4 etc ............ jul 03 2006 Aug 03 2006 Sep 03 2006 Oct 03 2006 Use ArrayLists like this ArrayList list = new ArrayList(); for(i=sdate;i<=edate;i=i. ...Show All

• .NET Development CannotUnloadAppDomainException on a wrapped COM object

  I'm using a 3rd party COM object that has a .NET wrapper in an ASP.NET 2.0 web service. This COM object is a print engine for industrial label printers, and doesn't come with a lot of documentation for .NET users, other than specifying some DCOM settings for the ASPNET user that need to be made via the Component Services snapin. Anyway, I got it up and running with IIS 5.1 on my primary WinXP development PC. Eventually this web service will be deployed on a Windows Server 2003 R2 box, but I wanted to try it out on my other development PC to see how hard it would be to deploy. On my other PC I keep getting a "CannotUnloadAppDomainException" in aspnet_wp.exe whenever the web service tries to call the constructor of this wrapp ...Show All