|
i wount to select (max) or (min) Feilds from sqlserver as database
the feild is String datatype
what I can do to selectmax(string from database table
or select min(string)from database table
if you have any sample code give me it
thanks you every body
pleas give me your help
Thaer
|
|
|
|
|
Quit asking the same question over and over. Have some patience, man 
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
SELECT MAX(LEN(ColumnName)) FROM TableName
|
|
|
|
|
That would work if he is looking for the longest string in the table. He didn't specify, so it is pretty much up in the air 
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
hi all
i wount to select max(string)from database
the database is sql server2005
who i can do tht without do any thing in code(c#)
thanks for any body help me
Thaer
|
|
|
|
|
Didn't you look at the replies you already received? Quit asking the same question over and over...
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
hi Paul Conrad
i repete the same sample more than one becuse the member in codeproject not replay the answer
i would the answer for my Quesion
and i sent this Quesion befor 11:30 hours why you stoped for me at this time
i repet the qustion to see all member my Quesion
pleas give me free to sent my Quesions ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
Thaer
|
|
|
|
|
That's not how it's done. If everyone would ask the same question over and over then the board would be spammed with the same questions. If someone is really willing to help he will click the "View unanswered questions in the C# forum" link.
regards
modified 12-Sep-18 21:01pm.
|
|
|
|
|
Greeeg wrote: If someone is really willing to help he will click the "View unanswered questions in the C# forum" link.
I utilize that link quite often and try to answer questions even from two months ago. I usually ask the poster if he/she is still having trouble, if so and they reply, I try to help. If I don't hear anything back, then I figure they must have fixed the issue.
As far as Thaer is concerned, I gave him a possible solution to his question earlier.
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Thaer Hamael wrote: i repete the same sample more than one becuse the member in codeproject not replay the answer
Thaer,
That is very, very rude and people do not like that very much. I offered a possible solution for you, have you even given it a try?
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi everybody
I'm wondering why many articles and tutorials suggest using a List<T>, while in theory (and practice) a LinkedList<T> should be both faster and more flexible.
I did some tests and found out that a LinkedList<T>.AddLast(T) is faster than a List<T>.Add(T) up to about 50.000 items.
What's the advantages and disadvantages of both lists?
regards
modified 12-Sep-18 21:01pm.
|
|
|
|
|
LinkedList: every item knwos its successor and its precessor, start end end of list are directly accessible.
List: more or less a "fixed" size array
Some consequences:
Adding to LinkedList (at the end is) as moving the next or previous item are simple opperations and therefore fast. The List has to be grown to fit all items.
Accessing an item at a specific position is faster in List. In LinkedList the chain of items has to be followed.
Maybe there are some optimizations included that I'm unaware of, so if you know better, let me know 
-^-^-^-^-^-
no risk no funk
|
|
|
|
|
Looks like a LinkedList doesn't even have an indexer or a GetAt(index) method, unless I'm missing something. You'd need to iterate over all items and stop at the desired one.
regards
modified 12-Sep-18 21:01pm.
|
|
|
|
|
In a LinkedList, each item is contained in a LinkedListNode object. The node contains references to the previous and next nodes, and to the list. Including the two references that every object instance contains, it's an overhead of 20 bytes (on a 32 bit system).
In a List, there is no overhead per item, only the overhead of allocated but unused entries.
So, storing 1000 bytes in a List uses 1024 bytes, but storing them in a LinkedList uses (at least) 24000 bytes.
---
single minded; short sighted; long gone;
|
|
|
|
|
Okay, I guess for most of my purposes a normal List will be fine then.
regards
modified 12-Sep-18 21:01pm.
|
|
|
|
|
hi
i want to get the mouse location when the mouse enter the control.i override the MouseEnter Event--protected override void OnMouseEnter(EventArgs e),but the parameter of this functon is EventArgs.can not get the location of mouse.in this condition how can i get the mouse location??
thank you ..
|
|
|
|
|
You can use Cursor.Position
regards
modified 12-Sep-18 21:01pm.
|
|
|
|
|
thank you for you answer
but i use this can't get what i want.
if i write "Point p = Cursor.Position",the p is the location of the control or the form who contain the control.
i devide a control into three partions, mouse enter each partion i give him a different cursor style ,how can i do this.
thank you!
|
|
|
|
|
Cursor.Position or Control.MousePosition
both give screen position
convert back to position inside myControl using myControl.PointToClient()
You do realize there is a thing called documentation ? see MSDN either inside
Visual Studio or on the web.
|
|
|
|
|
Look into the GetCursorPos API command of Windows. Do a quick search on MSDN.
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my homepage Oracle Studios[ ^]
|
|
|
|
|
I have a Windows Forms program, written in C#. Not a ASP.NET web page. And I'd like to get the value of the Firefox and Internet Explorer user agents, if this is at all possible. Any ideas?
-Domenic Denicola- [CPUA 0x1337]
“I was born human. But this was an accident of fate—a condition merely of time and place. I believe it's something we have the power to change…”
|
|
|
|
|
Have you tried the link below:
http://www.google.com/search?lr=&ie=UTF-8&oe=UTF-8&q=Internet%20Explorer%20user%20agent
The first hit should solve your problem.
|
|
|
|
|
I indeed saw that page and others like it. The problem is that the registry only stores those values if the user has changed his/her user agent. If the user has left it as default, then it's unknown what the user agent is, as those keys don't exist.
I guess I could have fun reconstructing the user agent string from the user's platform, browser version (which shouldn't be too hard to find), and then those add-on strings which I think are stored in the registry (.NET CLR etc.)
-Domenic Denicola- [CPUA 0x1337]
“I was born human. But this was an accident of fate—a condition merely of time and place. I believe it's something we have the power to change…”
|
|
|
|
|
Hello There,
I have technical problem in with web project.
I'm trying to pass form data (hidden fields) to a url without redirecting to the page.
In other words, lets suppose my web project has 2 files 1.aspx and 2.aspx.
A user submits a form on 1.aspx and the page navigates to 2.aspx. But before navigating to 2.aspx I'm validating the user inputted data. After the validation I need pass the status of validation(Valid or Invalid data) to an external url lets suppose http://somewebsite.com/3.aspx.
The posting of data to http://somewebsite.com/3.aspx has to happen asyncronously behind the scene so that user navigates from 1.aspx to 2.aspx.
Could anyone please help me...any reference to any articles will be of great help.
Thanks!
Amit.
|
|
|
|
|
Use AJAX dude.
--------------------------------
txtSignature
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
