tnfemme's Q&A profile

• Windows Forms Editing tables without Primary Key

  Hello everyone. I am trying to work with a database in C# 2005 Express. One of the tables in that database doesn't have a Primary Key. However, it has a unique Foreign Key associated with each row. How can I select any particular row for editing on that table Its easy to select and edit tables which have a Primary Key by writing something like: dataset.TableNameRow row = dataset.TableName.FindBy(PrimaryKey); row.BeginEdit(); . . . row.EndEdit(); But how can I select and edit a row from a table which doesn't have a Primary Key Thanks in advance, Ashish just select the row you want to edit, or if you know the foreign key, get the row: DataRow[] theDataRow = dataset.Tables[ index ].Select ("[ForeignKeyColumn] ...Show All

• Windows Forms ListBox - Drag & Drop, dragging problem

  Hi I have a ListBox control full of items. I've implemented the code for dragging (moving) one item around within the control. But now I want to have an "insertion separator" while dragging an item. With "insertion separator" I mean some kind of horizontal line between two items, where the new item is to be placed if dropping. Anyone Kind Regards Did you find solution to this I need to do the same. :) I heard, that ListView show separators automatically, but didn't try it yet. ...Show All

• Software Development for Windows Vista Control panel "Windows Cardspace" doesnt work

  Every time i start the "Windows Cardspace" from the control panel, i get this eventlog error: Running on german XP Pro SP2 Ereignistyp: Fehler Ereignisquelle: CardSpace 3.0.0.0 Ereigniskategorie: General Ereigniskennung: 269 Datum: 07.11.2006 Zeit: 19:38:32 Benutzer: NT-AUTORITAT\SYSTEM Computer: ATHLON64 Beschreibung: The Windows CardSpace service is too busy to process this request. User has too many outstanding requests. Additional Information: bei System.Environment.GetStackTrace(Exception e, Boolean needFileInfo) bei System.Environment.get_StackTrace() bei Microsoft.InfoCards.Diagnostics.InfoCardTrace.BuildMessage(InfoCardBaseException ie) bei Microsoft.InfoCards.Diagnostics.InfoCardTrace.TraceAndLogExceptio ...Show All

• SQL Server how to do this in SSIS? soory if i m a noob

  Hi all, Am trying to setup a SSIS package between a sql2000, sql2005 source and a sql2005 destination. I have 2 concerns, firstly, due to performance reasons (we have 2 huge legacy databases): After 1st run, Source table has: 1 - 1000 records Destination table has: 1 - 1000 records For 2nd run, Source table has: 1 - 1500 records Destination table has: 1 - 1500 records How I insert only the 1001th record - 1500th record, without touching the 1st to 1000th record Secondly, if there are any changes in values in the records 1st to 1000th record, how to I compare and only update the value that has changed Is there any particular configuration setting in sql that I can use Many thanks for any help provided. ...Show All

• Visual Basic ado.net

  Why Microsoft net team not introduce a managed recordset. This method of develop data-driven application in not depending from a technology (com-based dlls), but is a system to access the data. The syntax is more clear than cmd, parameters, insert. updates. When I've updated a table I close the cnn immedetiately! I read on DLINQ.. beautyful, but the SQL syntax is changed in a c# or vb project. This not help upgrading application/technology. I hope that Ma' Soft think about this problems! At end the result is the same. regards Have you looked at the data adapters They provide an approach to data access which encapsulates both the connection and the retrieved data. Are you having a specific prob ...Show All

• Visual Basic Programming Languages

  Hi, I'm relatively new to programming, and Visual Basic doesn't seem to be that good of a language, and not that much used in real applications. I want to move onto a different language, one that is very popular, can do almost anything, and can be and IS used in professional applications. Another important factor is platform compatibility. Java provides that, but Java isn't that popular for Windows, and Windows is my primary target. C++ works, but I have a couple of questions: 1) Can C++ be used on any OS Is it a good language to use as my primary language 2) Is C# going to replace C++ Does that work on other OS's C# is newer, and so I'm thinking maybe its the new version of C++ that's going to replace it, as xhtml is probably going to do ...Show All

• Visual Studio Express Editions Forms in Visual Express

  I have start creating a form even when I am begineer. I was watching a person @ Microsoft. When I try to right a script there is no scroll bar that makes it easier for user to scroll and pick the task of the this rather then writing the whole code but when I type Me. no scroll bar comes. Why and How can I fix it. I think something is wrong with my code. Ok, How do u make the webbrowser open the home page in the form. Using MS Visual C++ Express. ...Show All

• Visual Basic assigning substring to a variable

  Hi i try assigning a substring to a variable " strRemarks = ScmSplit(21).Substring(10, 25)" when debug i have the following errors "An unhandled exception of type 'System.ArgumentOutOfRangeException' occurred in mscorlib.dll Additional information: Index and length must refer to a location within the string." How to assign a substring to a variable or how can i remove the first 10 substring on a variable Hope anyone would clarify my question rgds vincent   vincent cheong wrote: Hi i try assigning a substring to a variable   " strRemarks = ScmSplit(21).Substring(10, 25)" when debug i have the following errors " ...Show All

• SQL Server Sql query for Master Detail Record in One Row

  I am having a table contains Nurse Detail like nurseid 1 address fname last name phone another table contains the exp detail in 28 different type of speciality nurseid specialiity year Exp. 1 icu 4 1 ccu 5 1 OPD 2 i need to display the record in datagrid as nurse Name ExamPassed Address MostExp SecondMostExp 1 toefl abc, india ccu icu if i use the select query to find the top two inside a datareader which collect the info. about each nurse this takes lot of time to complete this and many times gives Timeout error about(50%) is there any code to combine with the urse detail records as a column for speciality one and two. any stored procedure / se ...Show All

• SQL Server Connecting to SSIS in Management Studio.

  Hi: I have 4 named instances of SQL 2005 running on one of our sales server (dont ask me why I have 4 instances.Its a beefy box btw). All the instances have SSIS Packages (around 6-7 in each instance) saved to the SQL server and not to the file system. The issue is every time i need to look at the packages or export the packages from SSMS I have to edit the MsDtsSrvr.ini.xml and type in the named instance name within the <ServerName></ServerName> tag . I then have to restart my SSIS. I dont see an easier approach to this method. This is causing me a lot of unnecessary time waste. is there anyway this can be automated where in i can pass the instance name dynamically to the ini file or even more best, can I have all the in ...Show All

• Visual Studio Team System Date Recreation in VC Migration

  I am attempting to migrate from a previous Version Control to TFS and I was wondering if it is possible to maintain the same dates on the version history. So far I haven't been able to find any method that allows entering dates as a parameter. I was hoping this would work. It attempts to get the current changeset just checked in and change its CreationDate. It doesn't work. Changeset changeSet = versionControl.GetChangeset(n); changeSet.CreationDate = new DateTime (2006, 6, 26, 2, 0, 0); changeSet.Update(); I am not adamant about using the API, but I sure would prefer it. Perhaps there is an option in the Command Line Interface or the GUI Ok, it's not possible to update it. But, is there ...Show All

• Smart Device Development How to unload Assembly in .NET CF 1.0?

  Hi, i used Assembly.loadFrom(sAppName).getName().version.toString() to retrieve the version of the one of my exe file. The problem now is that i can "unload" the assembly. I need to release the write lock for this file so that i can overwrite the exe file. Anyone knows how to do this in CF 1.0 Thanks, Jeff Hello Jeff, i have never done this under the Compact Framework, but for desktop applications running the full blown framework the trick is to load Assemblies in another AppDomain. Whenever it is time to unload the assembly or assemblies this secondary AppDomain can be disposed of. This method is often used for framework/plugin architectures, and i guess it should also be possible to use it u ...Show All

• SQL Server Is it possible to send email within an sp or sql statement?

  Hi guys Is there anyway to fire an email from within sp - of course base on conditon. say I write: declare @emailaddr varchar ( 4000 ) set @emailaddr = 'whatever@me.com' if not exists( select a, b from C group by a, b having count (*)> 1 ) begin ********** -- fire the email to @emailaddress Is there an sp or a way to send email Thanks yes, you can use xp_sendmail or in 2005 you can use sp_send_dbmail Look up the usage and how to set it up in BOL Denis the SQL Menace http://sqlservercode.blogspot.com/ ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Cannot load XACT Data (InvalidDataException)

  I am attempting to load a set of XACT data files, similar to how the XNA Starter Kit does so. I get an InvalidDataException when it attempts to load the xgs file, however. "XACT could not load the data provided. Make sure you are using the correct version of the XACT tool." I am using XACT 2.0, Windows Version 9.13.644.0, if that means anything. The starter kit XACT files load fine, but mine do not. Any ideas Here's a link to my XACT project: http://dusda.com/files/Theta%20Wars.zip Yes, I do have the same problem as you. My sounds are MP3 transformed into WAV files by the XILISOFT MP3 WAV Converter. When I build my project in the XACT tool, the "win" directory contains my 3 files (.xgs ...Show All

• .NET Development How to Insert/Update/Delete nodes using XPath expressions?

  Hello, I have been using XPath expressions to iterate through a set of nodes (see example below). Can someone please suggest how I can add or drop sibling or child nodes using XPath expressions. Thanks, Tad code snippet: XmlDocument xd = new XmlDocument(); xd.Load("data.xml"); XPathNavigator xn = xd.CreateNavigator(); XPathExpression xe = xn.Compile(" //Assembly/Component/@cn ame"); XPathNodeIterator nodes = xn.Select(xe); while (nodes.MoveNext()) { MessageBox.Show(nodes.Current.Value.ToString()); } data.xml < xml version="1.0" encoding="utf-8" > <WidgetSettings> <Assembly> < ...Show All