|
create a fillschema a dataset
I create a SYBASECOMMANDBUILDER (from DDTEK Sybase Driver)
I create a row from the dataset
I fill the row with data
I add the row back to the datatable
[rowstate is now UNCHANGED]
I make a change to the newly added row
[rowstate is still UNCHANGED]
Of course the following update command returns zero, since there are no rows that do not have a status of "UNCHANGED". Can someone explain to me what I did wrong? datarow adds and changes should change the rowstate to Added and Modified respectively. Thanks in advance
Have a blessed day in Messiah EYAWHOOSHUA!
|
|
|
|
|
Make sure you don't call AcceptChanges on either the DataSet or the DataTable. To note, a DataAdapter will call this after updating your data store (ex: database).
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Also the rowstate changes as soon as I create the commandbuilder. If I call the command builder before adding the row(as in my example), then the rowstate stays Unchanged.
Have a blessed day in Messiah EYAWHOOSHUA!
|
|
|
|
|
|
|
|
A quick FYI for ya: Microsoft is considering deprecating, changing the name of, or possibly removing the ICloneable interface in version 2 of the .NET framework. This is due to the ambiguity of whether ICloneable objects implement deep or shallow copies. Microsoft is recommending that library designers do not implement ICloneable.
#include "witty_sig.h"
|
|
|
|
|
That's not surprising. Thanks for the info.
BTW, are they going to deprecate overloading operator == for the same reason?
|
|
|
|
|
No, or at least I've not heard anything as such. Whether some object "equals" something is up to the object designer. That differs from ICloneable because of the ambiguity of the type of cloning. So I'd say they'll probably keep it.
#include "witty_sig.h"
|
|
|
|
|
Hi,
I'm wondering if there can be any problem related to using a datadrig bounded to a dataset that is updated by temporary methods called from different timers:
<br />
OnTimer1 () { put data into data set table 1}<br />
<br />
OnTimer2 () { put data into dataset table 2 }<br />
<br />
Datagrid uses dataset to show data inserted by the two timers.<br />
After a few updates on the dataset, de application throws a System.NullReferenceException in system.windows.forms.dll (Object reference not set to an instance of an object).
Could it be that I'm using DataView's to search for records to update in the timers? Well this as proved to be a great headache to me, I appreciate your atention.
Best Regards,
Anfernius
|
|
|
|
|
Using a DataView is not a problem. With a lack of more detailed information, it's impossible to help you. You need to debug your code: step through your code and find where the NullReferenceException is being thrown.
Also, when a NullReferenceException is thrown, this often points to badly written code. There is no excuse for this exception - always check your variables to make sure they're not null before calling methods on them. If you're expecting data in a particular DataTable within your DataSet, for example, and no data was returned, that DataTable reference could be null (depending on whether or not the DataSet was filled with schema information). Calling a method on that DataTable without checking for a null reference would throw a NullReferenceException. Checking the return value, using a typed DataSet, and programmatically adding a new DataTable with the appropriate name would get rid of this problem.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
This Exception may be thrown when you try to change data in the same time as DataGrid reads them. Try to suspend binding before changing data from timer thread, or try to use Invoke method of the datagrid and then call your changing methods.
I am less sure the 2nd method, but it may work.
h.
|
|
|
|
|
Hi,
I have a text box on my form . I want to move the text box to the position where the user clicks. So I kept the location in variables and I am getting the coordinates of mouse click. How do I repaint the form so that the text box appears at the mouse click position.
Karteek
|
|
|
|
|
So, what is your problem? Just set the new X and Y values of the textbox and call the Refresh() method of the form if required.
Don't forget, that's Persian Gulf not Arabian gulf!
Murphy:
Click Here![^]
I'm thirsty like sun, more landless than wind...
|
|
|
|
|
|
Setting TextBox.Location will move the textbox to the new position, no calls to refresh required; the form will refresh itself automatically.
#include "witty_sig.h"
|
|
|
|
|
hi all
can anybody tell me about functions in c# like _inp & _outp in VC++
or can u tell me how can I access 378,379,37A (parallel port) using API functions or C#
thanks for all
|
|
|
|
|
|
just search NTPort in google.
/\ |_ E X E GG
|
|
|
|
|
Hi,
I've noticed that when you load a second Form (set to TopMost=true), that the cursor does not activate (show up) in the textbox set to TabIndex=0. Click back to the first Form and then back to the second Form, the cursor shows blinking away. Any ideas on how to fix this?
thanks,
Ron
|
|
|
|
|
Are you using Show or ShowDialog? In the former case, also try calling Activate on your form after calling Show.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Thanks Heath!
I'm using a Show (it's a Find/Replace Form for a notepad like application)...
I'll have to give that a try (I'm at work now).
One way I was able to correct this was to call the TopMost just after the Show call and not set in the Find/Replace Form.
One other question... when you have a TopMost Form and you want to click onto the original Form (back to editing the richtextbox but keeping the Find/Replace Form open) how do make it so ONE click activates the original Form and places the cursor where you clicked?
Ron
|
|
|
|
|
One click will activate the form. To set the cursor, override OnActivate, get the current mouse coordinates (in screen coordinates) using the static Control.MousePosition property, convert those coordinates to client coordinates by calling PointToClient on the Control and then set the insertion point in whatever way the control supports.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
I can't get this to work at all.
If i use vba i use:
myRange.copy
myRange.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
what i'm trying to do is paste the data back to where they originally came from. In c# though, there is no overload for copy that doesn't take arguments.
has anyone done copy and pastespecial before, or know another way of getting c# to convert a range from references / formulas to values. The code will be called up to 5000 times per run of the application, so while it doesn't need to be lightning fast, it needs to be quicker than looping throught the cells and setting their values individually.
Thanks
Russ
|
|
|
|
|
i've solved this one, the copy method is more than happy with a param: Type.Missing
Variants make c# a pain for this office lark.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
