|
I have a c# winforms app (must be a win app - responds to windows events) that accesses a web server side DB through a web app using a .ashx http handler that queries the DB into a dataset then coverts the dataset into XML and sends it back to the client.
My hosting service does not allow a remote DB connection (is this typical?) so I must do it this way.
Getting the server data into the client dataset is easy enough (ds.readXML) but is there an easy way to send back inserts/updates/deletes in the local dataset without coding all the SQL?
I know I can set up the generic insert/update/delete sql commands on the local DS but is there a way to get the actual resulting SQL statements and sent them to the server? or send the DS back as an object (the XML conversion loses the meta info on changed/inserted records)?
|
|
|
|
|
http://www.pcreview.co.uk/forums/thread-1237619.php[^]
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia> -------------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
Thanks Xmen - but this is what I'm trying to avoid. I'm dealing with 5 or 6 tables and I was hoping to take advantage of the built in updating features of the DS as if it were local DS <-> local DB. It's early in development so I don't want to hard code field names for 5 tables. What I want to do just might not be possible.
|
|
|
|
|
did ya read full topic...I think there may be a solution
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKQUFK[M`UKs*$GwU#QDXBER@CBN%
R0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia> -----------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
It's not exactly what I was looking for but it did lead me to Diffgrams (http://msdn.microsoft.com/en-us/library/ms172088(VS.80).aspx) which is exactly what I was looking for.
This converts the DS to XML including the DS meta data on updates/inserts/deletes
Thanks for the nudge in the right direction.
|
|
|
|
|
Hi, Sorry if i am posting in the wrng place, this is a general ques. I am doing an SMS application that communicates with the COM port, i want to use my O2 zinc phone as a modem, but whenever i connect the phone activesync use usb connection to connect, in the device manager also there is no COM port appear when i connect, so how can i use COM port with this O2 Zinc phone? (The cd comes with the phone also doesn't have any drivers for this purpose, internet also i searched and find no result  . Please help me with this..
|
|
|
|
|
i used DSOFile to read and Write File Summary infor....it successfully can work... but i having a problem....i can run application only on my pc when i try to install in another PC. System asking to install OLEdocument.....etc.....is there got any way to slove this problem....either by change codes.....
here is my code...
foreach (ListViewItem item in listView2.SelectedItems)
{
FileInfo fileInfo = new FileInfo(item.Text);
string image = "C:\\PhotoManager\\" + fileInfo.Name;
DSOFile.OleDocumentPropertiesClass file = new DSOFile.OleDocumentPropertiesClass();
file.Open(image, false, DSOFile.dsoFileOpenOptions.dsoOptionOpenReadOnlyIfNoWriteAccess);
{
tbxFileName.Text = file.Name;
tbxTitle.Text = file.SummaryProperties.Title;
tbxSubject.Text = file.SummaryProperties.Subject;
tbxAuthor.Text = file.SummaryProperties.Author;
tbxKeywords.Text = file.SummaryProperties.Keywords;
tbxComments.Text = file.SummaryProperties.Comments;
file.Close(false);
}
}
A S E L A
modified on Monday, March 16, 2009 9:11 PM
|
|
|
|
|
I would assume that you have a reference to the DSO stuff in your project. Make sure it is marked "copy local" otherwise it will not be deployed.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Hi,
I have a ReadOnlyObservableCollection<t></t> being returned in an AsyncCompletedEventArgs derived object. Is there any way in the get; accessor to automatically pass it back to the original thread without having to use the Dispatcher in the callback method?
At the moment I'm doing this:
void SyncCompletedCallback(object sender, SyncJobCompleteCallbackEventArgs args)
{
Dispatcher.BeginInvoke(DispatcherPriority.Normal, (ThreadStart)delegate
{
ReadOnlyObservableCollection<synceditem> history = args.SyncJobHistory;
HistoryView.ItemsSource = history;
});
}
</synceditem>
I'd rather let consumers have easy access to the collection like:
void SyncCompletedCallback(object sender, SyncJobCompleteCallbackEventArgs args)
{
HistoryView.ItemsSource = args.SyncJobHistory;
}
Thanks,
|
|
|
|
|
I am working on a touch screen application and I am trying to add a button(s) that function as pageup/pagedown on a MDI Parent form with the child forms as the items to scroll.
I've spent entirely way too much time scouring the internet for a solution to this. I've tried multiple items that I thought would be the answer to no avail.
I really thought that this would be the answer:
SendMessage(this.Handle, WM_VSCROLL, (IntPtr) SB_PAGEDOWN, IntPtr.Zero);
I know I'm close, but then again, I could be way off!
Ideas?
I guess no one has a solution for this...
For those who are wondering...
Given the scope of the project and the fact that I had to use a MDI parent and children (specs from customer)and buttons to scroll (touch screen app), I used a method to give the appearance of scrolling by setting the location of each form in a foreach loop. It moves the forms as if it were scrolling.
modified on Wednesday, March 18, 2009 9:22 AM
|
|
|
|
|
Hi All,
I'm just wrapping up some functionality in a class that uses some third party components under the hood. My wrapper object by default subscribes to some events on the third party components and forwards them on to consumers of my wrapper class.
In general I would expect consumers to subscribe to these events most of the time, however, I can't always assume that and I also want to optimise my wrapper. What is the general consensus on coding around this? At the moment I always subscribe to the third party events and then each time one of these events fires I check to see if the event handler is null before forwarding on the event.
Is there a better pattern for this?
|
|
|
|
|
If you're using delegates, your choices are
1 - check if it's null and if so, do nothing and
2 - check if it's null and if so, throw an exception.
Depends on if you want to force your clients to subscribe to the specific event.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi Christian,
I've already implemented option 1 as I didn't want to needlessly throw exceptions. Although I wasn't sure this was the best way.
Thanks,
|
|
|
|
|
Another option... If the methods in the wrapped class that raise the events i.e.
OnSpecificEvent(MaybeDerivedEventArgs e)
are protected virtual, then you can override them and fire your own events from your override methods so the original events will never get fired, only yours.
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
|
|
|
|
|
Hi all
Can anyone tell me how to refreash an array;
I mean lets assume an array with some values.
Now I just want to clear all the contents of array by clicking a button.
That button will have the code like array.refreash....something like that I dont know.
I dont want to clear the array by using for loop to putting all array address(0-20) null.
Is there any way to do it.
Pls reply me
Thanks 
|
|
|
|
|
You're looking for the Array.Clear static method
|
|
|
|
|
|
Was your meaning refreash refresh ?
|
|
|
|
|
foreach(object yourArrayItem in yourArray)
{
youArrayItem.remove();
}
A S E L A
|
|
|
|
|
Hello all,
Excel.Application excel = new Excel.Application();
Excel._Workbook book = new Excel._Workbook();
Excel._Worksheet sheet = new Excel._Worksheet();
Excel.Range range = new Excel.Range();
After adding a reference to the Excel Object Library in my VC# project, these few lines start the process of opening a 'new' workbook. But, how do you open a workbook that already exists?
I would like to point to the link to the existing book, if possible.
Thanks
|
|
|
|
|
excel.Workbooks should have an Open(...) method in it.
|
|
|
|
|
|
You're welcome. 
|
|
|
|
|
This method really stinks. Why is this in the object model? http://msdn.microsoft.com/en-us/library/bb179167.aspx
Thanks
|
|
|
|
|
it's there so you can open existing workbooks . I'm not sure about the 2007 version, but with the Office XP version you can get away with passing in System.Reflection.Missing.Value for all the parameters except the first one - provided that you don't care what those params are.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
