|
Use the below user defined function......
Select dbo..INITCAP('amit')
output --> Amit
Cheers
Amit
CREATE function INITCAP (@inString varchar(4000) )
/* INITCAP returns char, with the first letter of each word in uppercase, all other letters in lowercase. Words are delimited by white space or characters that are not alphanumeric */
returns varchar(4000)
as
BEGIN
DECLARE @i int, @c char(1),@result varchar(255)
SET @result=LOWER(@inString)
SET @i=2
SET @result=STUFF(@result,1,1,UPPER(SUBSTRING(@inString,1,1)))
WHILE @i<=LEN(@inString)
BEGIN
SET @c=SUBSTRING(@inString,@i,1)
IF (@c=' ') OR (@c=';') OR (@c=':') OR (@c='!') OR (@c='?') OR (@c=',')OR (@c='.')OR (@c='_')
IF @i<LEN(@inString)
BEGIN
SET @i=@i+1
SET @result=STUFF(@result,@i,1,UPPER(SUBSTRING(@inString,@i,1)))
END
SET @i=@i+1
END
RETURN @result
END
|
|
|
|
|
Hi..
Could any one explain to me How could I make Business Entity and Business Entity Set and how to bind them to controls?I found an article in that subject but I couldn't understand these issues...
I am too late but i will never give up
|
|
|
|
|
Hi there,
You can see many examples from the stater kits[^].
|
|
|
|
|
|
If you open the starter kit for example the Time Tracker, you will see the way the Business Entity and Business Entity Set objects such as Project and the generic collection List< Project> . In the old days with the .Net framework 1.x, you'd normally use the ArrayList or a custom Collection class to define the entity set object. But with the appearance of the Generic concept, it's much easier to do this stuff.
|
|
|
|
|
I am using asp.net 1.1 so for example if I have a table :
CountryID,CityID,CityCode,NameEN,NameAR
What the BusinessEntity will look like?
and how the BusinessEntitySet will look like?
I am too late but i will never give up
|
|
|
|
|
You should have mentioned that you are using the .Net framework 1.1. The sample code for the BusinessEntity and BusinessEntitySet objects looks something like:
public class Location
{
private int m_CountryID;
public int CountryID
{
get { return m_CountryID; }
set { m_CountryID = value; }
}
private int m_CityID;
public int CityID
{
get { return m_CityID; }
set { m_CityID = value; }
}
private string m_CityCode;
public string CityCode
{
get { return m_CityCode; }
set { m_CityCode = value; }
}
private string m_NameEN;
public string EnglishName
{
get { return m_NameEN; }
set { m_NameEN = value; }
}
private string m_NameAR;
public string ArabicName
{
get { return m_NameAR; }
set { m_NameAR = value; }
}
}
public class Locations : CollectionBase
{
public Locations(): base(){ }
internal Locations(ICollection c) : base()
{
base.InnerList.AddRange(c);
}
public Location this[int index]
{
get
{
return base.InnerList[index] as Location;
}
set
{
base.InnerList[index] = value;
}
}
public int Add(Location location)
{
return base.InnerList.Add(location);
}
public void Remove(Location location)
{
base.InnerList.Remove(location);
}
} In the Location object, I define the CountryID, CityID properties with the primitive types, but you can also use the custom type if you have the Country, City objects.
|
|
|
|
|
Thanks for the code
Sorry for asking alot of questions but how could I use these classes:
location and locations?
I am too late but i will never give up
|
|
|
|
|
|
Thank you very much for helping me for along time and answering my several questions.
I won't forget your help.
I am too late but i will never give up
|
|
|
|
|
Hello,
If you make a search in Google for "CNN" you will get the result as follows:
CNN.com - Breaking News, US, World, Weather, Entertainment & Video ...
CNN.com delivers the latest breaking news and information on the latest top stories, weather, business, entertainment, politics, and more.
www.cnn.com/ - 99k - Cached - Similar pages
SI.com - News and Scores from ... - sportsillustrated.cnn.com/
International Edition - edition.cnn.com/
CNNMoney.com - money.cnn.com/
Entertainment - www.cnn.com/SHOWBIZ/
More results from www.cnn.com »
Instead of:
String.Split Method (System)
Returns a String array containing the substrings in this instance that are delimited by elements of a specified Char or String array.
msdn2.microsoft.com/en-us/library/system.string.split.aspx - 15k - Cached - Similar pages
when I do a search for "string.split". This is the tratidional format of Google search results.
How does google see those links inside a web site?
Should I implement something in Asp.Net web site?
Thanks,
Miguel
|
|
|
|
|
hi,
i need to submit several challenging project titles to my boss. the complex of the projects doesnt matter. need the title a basic descritpion of the project. it should be web project. can anyone help me out. i have already sumitted a big list. it seems he wants more complex ones. just help me guys. ok.
thanks in advance,
lavanya
|
|
|
|
|
is it possible to detect when an user closed browser manually?
samir
|
|
|
|
|
Where do you want to detect it? On the client-side, handle the unload event. On server-sside you can't get a direct notification.
only two letters away from being an asset
|
|
|
|
|
HI every1
I have developed on window service.I want to display messagebox after every 30sec?Is it possible?if not possible,what is another alternative option to display message in window service in asp.net?Pls reply me,i am in deadline.
Thanx
monika
|
|
|
|
|
Hello pls reffer below link,
http://www.codeproject.com/csharp/winservicemanage.asp
Parwej Ahamad
|
|
|
|
|
Hello All,
i would like set property ( ScrollToCaret() ) of TextBox in javascript.
or please tell me if other method to scroll the textbox still last line of the text box.
Softy Boy
|
|
|
|
|
how can i perform scheduler for performing
some task on given time periods?
|
|
|
|
|
There are many ways to do that:
+ You can use javascript to periodically send a request to the server to perform the scheduled task.
+ You can use the task scheduler at the server side to configure a scheduled job.
+ You can configure a window service at the server side.
+ You can use the Cache object as the scheduler, for example you can save an item in the Cache with the configured time, when it is kicked out due to the timeout, you can cach up this event and perform the task.
|
|
|
|
|
Hello,
I'm trying to use a class I've built in an ASP.NET page, but I can't seem to make it work. When compiling the project, everything is fine, but when I try to run it, I get an error saying that the class cannot be found.
The code behind the page is in VB.NET, and I'm trying to instantiate the class there.
For example:
--- Custom Class File ---<br />
Imports System.Web.UI.WebControls<br />
<br />
Public Class CustomButton : Inherits Button<br />
Public Sub New(Name As String)<br />
MyBase.New()<br />
MyBase.Text = Name<br />
End Sub<br />
End Class<br />
--- End of Custom Class File ---<br />
<br />
<br />
--- Main Page File ---<br />
Imports System<br />
Imports System.Web.UI<br />
<br />
Public Class MyPage : Inherits Page<br />
Protected Sub Page_Load(sender As Object, e As EventArgs)<br />
Dim b As CustomButton<br />
<br />
b = New CustomButton("Button!!")<br />
End Sub<br />
End Class<br />
--- End of Main Page File ---<br />
What am I doing wrong?
--
Nicola
|
|
|
|
|
Hi there,
Where do you define the CustomButton class? in a seperate class file in the same web project or in a seperate project?
|
|
|
|
|
Same project, separate class file.
<div class='ForumSig'>Nicola</div>
|
|
|
|
|
I guess you are using VS 2003? Can you post the code line causing the error and the error description?
|
|
|
|
|
im developing a online dictionary system for my project at college... but i cant find the database for it... im looking database for dictionary using SAL server 2005... if anyone had that database.. pls reply.. and givw your download url.. i really appretiate your help....
pls... help me....
|
|
|
|
|
HI,
I am facing the following issue,
I couldn't debug my project and getting access denied error.
When I was a memeber in Admin group I could debug.But when it is removed from admin and added to the following groups it is not working.
1)VS Developer
2)debugger User
3)IIS_WPG
But when we add a new user in the above groups and don't have admin rights,still he can work.
I found situation only when once the member has admin rights and later if it is removed the debugger stops working..
How to solve this issue without having added in the administrator group
Any idea is much appreciated.
Thanks,
RPM.
|
|
|
|