C#

FirstPrevNext

Find Row in Table and Update DB MrJJKoolJ10-Feb-04 4:58 MrJJKoolJ 10-Feb-04 4:58  Hi, Ok using Typed Datasets and using a table in that dataset that I am working on. What do I use in order to find a particular row and be able to update db with row changes? Do I use a dataview thats tied to datatable and have it find it that way or is their something else in order to find a particular row? Thanks, JJ Re: Find Row in Table and Update DB Marc Clifton10-Feb-04 8:45 Marc Clifton 10-Feb-04 8:45  MrJJKoolJ wrote: Do I use a dataview thats tied to datatable and have it find it that way or is their something else in order to find a particular row? You could. The point is you need to qualify the row somehow, which is usually done by an ID or by having the user select that row in a list, in which case the row is a simple numeric index. Without understanding the context of what you are asking, it's hard to be more specific--for example, my question to you is, what information are you looking for in the dataset that makes you *need* to search for a row? With the DataView, you can use the RowFilter to qualify the DataSet, or you could have the query already formed with the appropriate "where" clause, or you could have an "update" SQL statement yourself with the appropriate "where" clause. Different answers for different situations. Marc Latest AAL Article My blog Join my forum! One more thing... Marc Clifton10-Feb-04 8:47 Marc Clifton 10-Feb-04 8:47  With data binding, you don't even need to know what row because it's managed for you. Look at DataView.RowStateFilter as an example to view the data that's been modified. Marc Latest AAL Article My blog Join my forum! Re: Find Row in Table and Update DB[EDITED] Mazdak10-Feb-04 9:49 Mazdak 10-Feb-04 9:49  MrJJKoolJ wrote: What do I use in order to find a particular row and be able to update db with row changes? If you want ONE row you can get it with Find() method of your DataSet, if it could be more than one row use Select() method. FinD method return a DataRow which you can change each column like this: datarow["columnname"] = value; and then call the Update() method of DataAdapter. Thats it, you do not need DataView cause it filter your table. [EDITED] This is the place of Find and Select methods: DataSet.Tables[index].Rows.Find()/Select() [/EDITED] Mazy "Improvisation is the touchstone of wit." - Molière Re: Find Row in Table and Update DB[EDITED] MrJJKoolJ10-Feb-04 13:04 MrJJKoolJ 10-Feb-04 13:04  Thank you for your response guys. I am using a dataset and needed to find a particular *one* Row. And I was looking for the best way to go about it. I create a dataadapter with Typed dataset that brings back multiple recs. Now with that scenario, I am trying to find a particular row to update in dataset. I do have the row Identified by a key and I don't want to create another dataadapter and dataset to get just the one row. So I need to find out the position of rec in dataset so that I can update it. Make sense now? I think that Mazy's way sounds good. Use the find method. Thanks Again, JJ .NET and &quot;industrial espionage&quot; Palladino10-Feb-04 4:43 Palladino 10-Feb-04 4:43  Hi friends, I am involved in project whose the development of base classes and architecture high level were under my team responsibility. After creating 80% of these classes I am about to involve more developers in the process and I fall in problem that is me leaving a little preoccupied: These basic components won't be maintained by production team and they will only have access to the binaries of these components. The tools that I made some tests for assemblies obfuscation it doesn't allow me to protect such assemblies inside the team. I would like that the team have these assemblies ALREADY protected, what would be the first level of safety against copy of intellectual property. My idea is that even if talented programmer gets to leave of company with the sources that contain the business rules, the CORE it (basic classes, personalized controls, access rules for database and etc) of the thing he won't have access, which, I belive, turns the sources "less attractive" because to create such components of the zero it would take plenty time. Does anybody already use some tool that allows something like that? Does anybody have some idea on this? Greetings, Marcelo Palladino Brazil Re: .NET and &quot;industrial espionage&quot; Marc Clifton10-Feb-04 6:33 Marc Clifton 10-Feb-04 6:33  Palladino wrote: I would like that the team have these assemblies ALREADY protected, what would be the first level of safety against copy of intellectual property. My idea is that even if talented programmer gets to leave of company with the sources that contain the business rules, the CORE it (basic classes, personalized controls, access rules for database and etc) of the thing he won't have access, which, I belive, turns the sources "less attractive" because to create such components of the zero it would take plenty time. 1. You need to trust your team. 2. You are making the assumption that someone will act unethically at best, and illegally at worst. Another company hiring such a person, at least here in the US, can get in real hot water. There are employee agreements to prevent this, including the jokingly unenforceable "you can't work in a related industry for 5 years after termination" type of BS. 3. Is this something you really feel is necesary to spend time and effort worrying about? Palladino wrote: Does anybody have some idea on this? It wasn't clear as to why you can't give the production team the obfuscated assemblies. How is obfuscation failing you in this instance? Marc Latest AAL Article My blog Join my forum! Re: .NET and &quot;industrial espionage&quot; Palladino10-Feb-04 8:06 Palladino 10-Feb-04 8:06  Hi Marc, Before anything: Thank you for trying to understand me. I am aware that my English is badly, I am trying to get better. Marc Clifton wrote: 3. Is this something you really feel is necesary to spend time and effort worrying about? hum... To read your post made to think me of another point of view. Perhaps it is not, really... I will continue thinking about this. Marc Clifton wrote: It wasn't clear as to why you can't give the production team the obfuscated assemblies. How is obfuscation failing you in this instance? I have like this a class (before obfuscation): public class MyClass { } After obfuscation: public class 983276376jssdjh { } Perhaps I am making something wrong, but this way, the assemblie becomes invalid for programming. The execution goes well, however. Hugs, Marcelo Palladino Brazil Re: .NET and &quot;industrial espionage&quot; Marc Clifton10-Feb-04 8:38 Marc Clifton 10-Feb-04 8:38  Palladino wrote: Perhaps I am making something wrong, but this way, the assemblie becomes invalid for programming. The execution goes well, however. Ah, you so you want the source code obfuscated? It would be a little bit of work to add the automation, but what would happen if you took your obfuscated assembly, read it into Lutz Roeder's .NET Refelctor[^], and ran the "decompiler" function to emit the now obfuscated but still compileable assembly source? But I'm confused about something--why supply the source and obfuscate things like the class name? Wouldn't that break other functions that reference that class? Or do you *want* people to use the obfuscated source? No wait--you want to supply the internal source obfuscated, but there are certain "public" unobfuscated classes and methods that are the interface points? Is that it? Marc Latest AAL Article My blog Join my forum! Re: .NET and &quot;industrial espionage&quot; Palladino11-Feb-04 3:51 Palladino 11-Feb-04 3:51  Hi again Marc, Marc Clifton wrote: No wait--you want to supply the internal source obfuscated, but there are certain "public" unobfuscated classes and methods that are the interface points? Is that it? It is exactly this! What is happening, with the tool that I am using: It is changing the names of the types, instead of changing implementation only. However, when beginning to talk with you I went to test other tools (Salamander, for instance) and I noticed that work in the expected way. It seems that am in the road. Thank you, again! Marcelo Palladino Brazil Re: .NET and &quot;industrial espionage&quot; Palladino12-Feb-04 5:42 Palladino 12-Feb-04 5:42  Hi again, Marc! Now I have the clearest subject in my mind. I want assemblies obsfucation but it would like the names of the members not to be altered by this process. That is possible? Sincerely, Marcelo Palladino Brazil Testing .NET remote connection naxos10-Feb-04 3:53 naxos 10-Feb-04 3:53  Hey If you have a .NET remote server and a client seperated by an shared assembly, is it the possible to test the connection. I want to test the connection to the server to see if it is running before executing any of my remote methods on it. When I'm using RemotingServices.Connect I will never get null in return, when using a shared assembly. I have also tried using Activator.GetObject, no luck. Is there any way to see if there is a running server in the other end before executing methods? Re: Testing .NET remote connection Marc Clifton10-Feb-04 4:10 Marc Clifton 10-Feb-04 4:10  I just read yesterday something about that the proxy won't actually finish the process of connecting to the server and loading the shared assembly until you actually reference it in a method call. For example, I can create the channel, register it, and use Activator.GetObject without a single problem. Only when I make the function call do I get the following exception: "No connection could be made because the target machine actively refused it" So, maybe you can have a dummy "Test" method that you call and catch an exception on? Marc Latest AAL Article My blog Join my forum! Cannot abort thread Mertli Ozgur Nevres10-Feb-04 3:38 Mertli Ozgur Nevres 10-Feb-04 3:38  Hi all, I wrote a multi-thread application using sockets. But when i attempt to stop a thread, the thread is falling into "AbortRequested" state but never being aborted. Can anyone help me? My code is below: if ( this.m_ReceiveThread.IsAlive ) MessageBox.Show( "alive" ); MessageBox.Show( "State: " + this.m_ReceiveThread.ThreadState.ToString() ); if ( this.m_ReceiveThread != null ) { for ( int i = 0; i <= 10; i++ ) { try { this.m_ReceiveThread.Abort(); this.m_ReceiveThread.Join( 100 ); /* !!!!!! it always says current state is AbortRequested !!!!!! */ MessageBox.Show( "m_ReceiveThread trying to abort. - " + i.ToString() + "\nCurrentState: " + this.m_ReceiveThead.ThreadState.ToString() ); }//End of try. catch { }//End of catch. if ( this.m_ReceiveThread.ThreadState == ThreadState.Aborted || this.m_ReceiveThread.ThreadState == ThreadState.Stopped ) { MessageBox.Show( "m_ReceiveThread aborted." ); break; }//End of if ( this.m_ReceiveThread.ThreadState == ThreadState.Aborted ). }//End of for( int i = 0; i <= 10; i++ ). }// End of if ( this.m_ReceiveThread != null ). Re: Cannot abort thread Marc Clifton10-Feb-04 3:59 Marc Clifton 10-Feb-04 3:59  Thread.Abort: Raises a ThreadAbortException in the thread on which it is invoked, to begin the process of terminating the thread. Calling this method usually terminates the thread. I like the word "usually". Look at the example in MSDN. Are you catching all exceptions in the thread and not properly handling ThreadAbortException? Marc Latest AAL Article My blog Join my forum! Re: Cannot abort thread Kentamanos10-Feb-04 6:04 Kentamanos 10-Feb-04 6:04  To add to what Marc said, take a look at this. I, for one, do not think the problem was that the band was down. I think that the problem may have been that there was a Stonehenge monument on the stage that was in danger of being crushed by a dwarf. -David St. Hubbins Re: Cannot abort thread Marc Clifton10-Feb-04 6:24 Marc Clifton 10-Feb-04 6:24  Kentamanos wrote: To add to what Marc said, take a look at this. A thread will not terminate correctly if some process are still running (consuming) a protected ressource. Ah yes! Excellent! I'm in the middle of working with some serial I/O code in C# that uses protected resources, and it's the wierdest thing to exit the application and still see the application running in the process list even after doing an abort on the receiver thread. Needless to say, I wasn't cleaning things up. Marc Latest AAL Article My blog Join my forum! Re: Cannot abort thread David Stone10-Feb-04 9:06 David Stone 10-Feb-04 9:06  Marc Clifton wrote: some serial I/O code in C# Marc...why aren't you just using the System.IO.Ports.SerialPort class? When I can talk about 64 bit processors and attract girls with my computer not my car, I'll come out of the closet. Until that time...I'm like "What's the ENTER key?" -Hockey on being a geek Re: Cannot abort thread Marc Clifton10-Feb-04 9:38 Marc Clifton 10-Feb-04 9:38  Nice to know I'm on your "to read" list. David Stone wrote: Marc...why aren't you just using the System.IO.Ports.SerialPort class? Because I'm not using Longhorn! And, is there some reason they didn't inlude the parallel port in the Ports namespace? Oh yes, I forgot--Microsoft wishes the thing had never been invented! Marc Latest AAL Article My blog Join my forum! Re: Cannot abort thread David Stone10-Feb-04 10:36 David Stone 10-Feb-04 10:36  Marc Clifton wrote: Nice to know I'm on your "to read" list. Heh...I was just browsing through the forums. Marc Clifton wrote: Because I'm not using Longhorn! Well...you don't have to use Longhorn. You could just use Whidbey. When I can talk about 64 bit processors and attract girls with my computer not my car, I'll come out of the closet. Until that time...I'm like "What's the ENTER key?" -Hockey on being a geek Re: Cannot abort thread Marc Clifton10-Feb-04 13:40 Marc Clifton 10-Feb-04 13:40  David Stone wrote: You could just use Whidbey. Uh huh. For production software? Marc Latest AAL Article My blog Join my forum! how to draw a X coordinate with a series of datetime data? Member 185560810-Feb-04 3:22 Member 1855608 10-Feb-04 3:22  how to draw a X coordinate with a series of datetime data? my question is mainly how to deal with the datetime and how to draw? Please give me a sample about it! Thanks a lot! Re: how to draw a X coordinate with a series of datetime data? Alex Korchemniy10-Feb-04 7:20 Alex Korchemniy 10-Feb-04 7:20  Drawing is handled in the OnPaint of a control. Use DataTime to work with data time data. If you want to draw text you use DrawString() method. Doc's here: [^] Docs for Graphics class : [^] interact 2 way Blue_Aqua10-Feb-04 3:14 Blue_Aqua 10-Feb-04 3:14  Hi All, how do we interact 2 way BETWEEN A COM COMPONENT[say written in MFC COM] and a simple java class/EJB component. say i wish to call a method in the java class from the COM component. From COM component ,i pass it a number,the java class/component must multily it by say 10 and return the result back to COM component. Is it possible. Both reside on same machine. Thanking you.. Regards God Is Great Re: interact 2 way Heath Stewart10-Feb-04 11:10 Heath Stewart 10-Feb-04 11:10  Yes you can. See the JNI reference at http://java.sun.com[^]. Please do not continue this thread, though. This is the C# forum, not the MFC, COM, or Java forum.   Microsoft MVP, Visual C# My Articles

Last Visit: 31-Dec-99 18:00     Last Update: 26-Apr-24 21:48 Refresh ᐊ Prev1...14183141841418514186141871418814189141901419114192 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.