|
Did you know that databases do not care about the order of records in a table?? Unless told otherwise with a ORDER BY clause, a SELECT statement can return records in any order.
About the only way to accomplish this would be to give each record in the table an index number specifying which row in the view it is in. When you write the data back out to the database, you'd have to include this view order number with the data and store it in it's own column in the table. When you retrieve the data again, you'd have to specify and ORDER BY clause on that view order column in the SELECT statement, thereby guaranteeing that you get a table sorted in the order the user last saw it.
|
|
|
|
|
thx that gives me the idea....
now only 1 question left.for the accomplish of the above is it OK to have an [int-increment 1 ] identity (primary key)column for this?
|
|
|
|
|
Each record is going to need it's own identity, yes, but it's useless in the row order because your users can rearrange the rows. You'd actually need BOTH colums, one for an ID key and the other for the row position in the view.
|
|
|
|
|
Thanks Dave
problem solved
|
|
|
|
|
|
You don't ask for much do you? We aren't here to write your code for you. We'll help you with specific problems but not the whole darn shootin match. That isn't the way that this site works - if that's what you want, try rentacoder.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
And the well-noticed pattern continues, Location: India...
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
|
|
|
|
|
The way you want do it involves writing your own network sniffer. Which, BTW, is a HORRIBLE way to do this.
Do it the write way and modify the database to log all this stuff. With Trigger support in the SQL Server, it's easy.
|
|
|
|
|
Can someone tell me what is the new Plugin API that comes with .Net 3.0 called? I want to use it but can find no reference to it.
Thanks
|
|
|
|
|
|
It's called System.AddIn and is in .NET 3.5, not 3.0. See these MSDN articles:/ravi
|
|
|
|
|
|
What is the difference between creating a static class object and creating a non static class object?
Class A{
Int a;
Public:
Fun1(){cout<<”hi”}
}
Static A obj;
Int main(){
A obj2;
}
What is the difference between obj and obj2? Does this make any difference if there is a static member within the class????
Thanks
|
|
|
|
|
A static member can be accessed with out creating the class. It would just be clasname.staticmember. If it is a non static member then you have to create the class to access the member.
Hope that helps.
Ben
|
|
|
|
|
kubben wrote: you have to create the class to access the member
Just to be pedantic: You have to create an instance of the class.
|
|
|
|
|
You are correct. Sorry if I wasn't clear.
Ben
|
|
|
|
|
Surely not - you only have to code the class to create it.
To make it clear to anybody else - I am joking.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Thank you all for helping me out.
|
|
|
|
|
I am using a .net console apllication(C#) which makes API calls to a web service. There is a large amount of data transfer.
The exception i am getting is "The operation has timed out".
I generated stub classes from WDL files and using them in client application.
Where can i set the timeout value.
Is it on the client application or on the web server. and what parameters are used to set the time out value.
thanks
|
|
|
|
|
There are 2 types of timeouts that you can specify on the client side when making a call to a web service: send and receive. If you're expecting to send a large amount of data, increase the send timeout; if you're expecting to receive a large amount of data, increase the receive timeout. You can of course specify both or none.
The timeouts are properties of the binding. Here's an example of how to specify them.
string url = "http://localhost:1234/MyService";
EndpointAddress address = new EndpointAddress (url);
WSHttpBinding binding = new WSHttpBinding();
<code>binding.SendTimeout = ...;</code>
<code>binding.ReceiveTimeout = ...;</code>
ChannelFactory<IMyService> cf =
new ChannelFactory<IMyService>(binding, address);
IMyService svcProxy = cf.CreateChannel();
svcProxy.MyMethod();
Hope this helps!
/ravi
|
|
|
|
|
Thanks for the fast reply.
It seems system.servicemodel is supported by only .Net framework 3.0, but i am using 2.0. so are there any equivalent methods in 2.0
|
|
|
|
|
Sorry, I (incorrectly) assumed you were using WCF.
/ravi
|
|
|
|
|
I have a question about windowless controls. I need to make an control (actually a sprite control). If I derive it from control, I can't get the flickering to stop when I am drawing more sprites one on top of the other, and all of them updating fast. So no I need to make this control windowless(without a HWND), but I still want to keep the advantages of design-time.
So, can I make a windowless control but still set the control from the design-time?
Thanks in advance!
|
|
|
|
|
Derive from UserControl and make sure that DoubleBuffered = True .
|
|
|
|
|
Well, I can't derive from usercontrol, because usercontrol is derived from Control, wich in turn is derived from IWin32Window, i.e it has a HWND. This is exactly what I don't want, I want to do the painting with only one Graphics(the forms Graphics). And if I use a control, and 10 instances of it, each drawing one over the other() maybe with transparency, DoubleBuffer can't help me. I need something more "light" than a control, but still be albe the process events. Thanks
|
|
|
|