|
So, create a minimal webpage with the onpaste function already in it.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys
|
|
|
|
|
I am doing an update to my database after adding a row to the data table. The TableAdapter uses the VS2005 generated INSERT command (the table has a lot of columns). The line is...
DishVarTA.Update(CurrentStDishVarRow);
where 'CurrentStDishVarRow' points to the row in the 'Added' state.
My problem is that I want to use the row data after this statement to format and send off to some machinery. After the Update however 'CurrentStDishVarRow' points to an entirely different row.
I think the INSERT statement in the TableAdapter is putting the new row in at the beginning of the table so the row indexing changes.
Is there any way I could preserve the pointer, or is the only way to fill the table again and/or find it again?
Done a lot of searching and haven't found much that covers this, does that mean preserving row pointers across updates is not 'de rigeur'?
Thanks,
|
|
|
|
|
jrgrobinson wrote: DishVarTA.Update(CurrentStDishVarRow);
This code will attempts to save changes in the indicated DataRow to the database.
You can store the row before updating and then manipulate the new instance of required row.
now to locate the row in the datatable before calling the update method for the dataadapter use one of this methods:
<br />
string s = "primaryKeyValue";<br />
DataRow foundRow = datatable.Rows.Find(s);
<br />
DataRow[] foundRows;<br />
foundRows = datatable.Select("put filter expression ");
|
|
|
|
|
Thanks. Just a simple question, after the update, could I assume the rows are all still in the TableAdapter and do the Find or Select then?
Thanks
|
|
|
|
|
TableAdapter don't store any rows, it just provide communication between your application and a database.
try to read this article to get more info:http://msdn.microsoft.com/en-us/library/bz9tthwx(VS.80).aspx[^]
The Datatable represents one table of data, so you should depend on the datatable to use the find or select methods.
Like what you do if you can't do what you like 
|
|
|
|
|
You are using the built in wizard thingys to do your data processing and now you want to do something slightly different to the STANDARD methedology, like post processing after an insert. This is why they are a POS, I strongly suggest you read up on Data Access Layer and rework all your data processing.
As that is probably going to frighten the day lights out of you (as it would most people) try and capture the row information prior to saving back to the database (take a copy/clone of CurrentStDishVarRow) and see if you can work with that.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I guess this is the problem with the 'standard methodology'. It is kinda hard comining into it to understand the conventions. There certainly isn't a lot except experience that would tell you an update rearranges the cache. A view from other worlds would be that a data cache wouldn't change after a write to the source, thus preserving some independance between the user and source.
Been doing a lot of reading and SQLCommands are looking attractive, but copying across the database update will get my machines working tomorrow.
Thanks for taking the time to respond.
|
|
|
|
|
Just to close it off for prosperity.
I have a data table, filled by a table adapter with '...WHERE(PK=@PK)'. It had a single row in it. I added another row (.NewRow, .AddRow). The Rows count of the table was 2. Index [0] pointed to the old origional data. Index [1] pointed to the new data, DataRowState=Added.
I then called the table adapter.update (a rather large INSERT statement)
There was still a count of two rows but both [0] and [1] pointed to the same row, the origional. This would indicate the data table of the dataset is no longer valid after an Update. I then did another fill and the data table had both rows as before (now unchanged state).
The reason for writing this is to record for other people that may fall into this minor but time consuming trap. The tableAdapter.Update call is the end of the road for the validity of the data table data. There isn't a lot of documentation or web resource that tells you this.
It maybe obvious to seasoned .NET database engineers, and maybe standard practice. It would be unexpected to new entrants in this field with experience of other, dare I say it, more normal, caching systems.
Thanks for the help.
Ooops, I modified Table Adapter to refer more correctly to the data table of the dataset where referring to storage.
|
|
|
|
|
I want to know how to make my application autorun I mean how to put it in the system startup. I want when the windows starts my main form get minimized and instead of taskbar I want to show its icon in the notification area.
Also, I need to know how can I realize when my form restores after minimizing.
I really need to know the answer as soon as possible 
|
|
|
|
|
|
saeidfarahi wrote: I really need to know the answer as soon as possible
Man you should be a comedian... you seem to have a beeter angle on that then programming!
However ... TO answer your first question just put a shortcut to your application in the startup folder on windows....
Not sure on the other answer....
|
|
|
|
|
in my application i need to create our own spell checker...
actually wht i am doing is in my form i have some control like buttons,label like..when i click on spell check i need to check the all the controls Text..
so i need to create own spell check Designer..
please any one help me.......
Thanks
|
|
|
|
|
Do you honestly think that a forum reply will teach you how to write a spell checker ? Buy one, use Word, or give up.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Creating your own would be more difficult than using an existing one. There are some free solutions available, so why would you even want to create your own wordlist?
Take a look here[^] and here[^] 
I are troll
|
|
|
|
|
hi
I create customize template for VS2008 in which whenever user add project using this template, i want to add folder with some files copy from some path.
i write following code as
project.ProjectItems.AddFolder("myfolder");
folder is created into explorer. i used
project.ProjectItems.AddFromFileCopy(filepath) to add files into exploer but how can i add
files into "myfolder" in explorer.
thanks
abc
|
|
|
|
|
i hav already finished half of my website, and now i wish to add ajax enabled master page to it(to show news) so that all the pages in my website can have AJAX properties. i use vs2005, hw can i do it?
|
|
|
|
|
If you're not smart enough to find the ASP.NET forum, this task is probably too hard for you
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hello All
Kindly help me resolve the issue. I want to fill multiple values in a single cell of excel using c#. The values are received from a loop.
Thanks
shantanu
|
|
|
|
|
If they go in the one cell, I assume you want to build them into one string and hten insert that ? If not, please ask in a way that makes sense
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
|
This is ridiculous. No beginner should be working on such a thing. LEarn C# first. If this is paid work, be ashamed.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi,
Please let me know how can i use UrlDownloadToFile() in c# .....
|
|
|
|
|
IS it a .NET method ? If not, then perhaps you need to use p/invoke. Either way, you don't say what you want to use it for, or why you can't google it for yourself.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
this is the customer class(created by XSD) which i use to create the customer object at client
and pass to web service.
public partial class Customer {
private System.DateTime dATEOFBIRTHField;
private string cUSTEMAILField;
[System.Xml.Serialization.XmlAttributeAttribute()]
public System.DateTime DATEOFBIRTH {
get {
return this.dATEOFBIRTHField;
}
set {
this.dATEOFBIRTHField = value;
}
}
[System.Xml.Serialization.XmlAttributeAttribute()]
public string CUSTEMAIL {
get {
return this.cUSTEMAILField;
}
set {
this.cUSTEMAILField = value;
}
}
}
when i set the date of the customer object
customer.DATEOFBIRTH = DateTime.Today;
and pass it to web service by calling it's method at client side the time is
automatically set to "01/01/0001" . any suggestions why?
|
|
|
|
|
Hi,
the DateTime.Today property returns a value like
"03/16/09 12:00:00 AM" whereas your method's argument might need only the date or time.....
Check this and if you need to pass anyone modify your code accordingly....
Have a Happy Coding.....
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
