Convert String to Enum

Hi,

Today, I will show you how you can convert the Enum type to a string in .Net. In my demo, I use C#.

Say for example, you have a dropdown where values and texts are list of genders (Male, Female, Gay, Tomboy, Idk),...

and you want to get its preferred partner based on the selected drop down.

public enum Gender
{
MALE,
FEMALE,
GAY,
TOMBOY,
IDK
}


public class Dummy
{
public string GetPreferredPartner(Gender g)
{
if(g == g.MALE)
return "pretty woman";
else if(g == g.FEMALE)
return "handsome guy";
else if(g == g.GAY)
return "macho man";
else if(g == g.TOMBOY)
return "hot mama";
else if(g == g.IDK)
return "macho man";

}
}




//get the selected gender from the drop down
string strGender = this.ddlGender.SelectedValue;

///Here is the conversion of string to an Enumeration
Gender gender = (Gender)Enum.Parse(typeof(Gender), strGender, true);

//the first parameter is the Enum type you want your string to convert to
//the second is the string which will be converted to the specified Enum type
//the third parameter is to determine if the string is case sensitive

That's all, thank you.

-Jygz
jjygot@gmail.com

How to use CURSOR in MSSQL

Hi,
Most of us sql lovers might be wondering on how to navigate in every row of a table treating the sql result set like a record set. Although I am sure that for those SQL Server experts, the word Cursor is too common for them and some would say that it would cause too much overhead. But just for the sake of those who don't know what cursor is, I have a basic tutorial for you guys.

-- First I would like to create a temporary table to help us on our tutorial.
Create Table tbl_Temp(
[RowNum] [int] NOT NULL,
[RowValue] [int] NOT NULL
)
Go

-- Next I will insert few records into the newly created table

Insert into tbl_Temp(RowNum,RowValue) values(1,50)
go
Insert into tbl_Temp(RowNum,RowValue) values(2,22)
go
Insert into tbl_Temp(RowNum,RowValue) values(3,11)
go
Insert into tbl_Temp(RowNum,RowValue) values(4,16)
go
Insert into tbl_Temp(RowNum,RowValue) values(5,23)
go


-- Here I need to create a variable that will serve as a storage
-- I want to have it as a varchar so that to avoid casting int values to varchar
Declare @RowNumStorage as varchar(3)
Declare @RowValueStorage as varchar(3)

-- Declare a cursor object that will serve as a pointer for the table tbl_Temp
Declare MyCursor cursor for
select * from tbl_Temp

-- Opening the cursor is important
-- It's like we didn't create any instance of the cursor at all if don't open it
open MyCursor

-- The lines below dictates the cursor to move to the next record
-- by default the cursor's current row location is set to -1
fetch next from MyCursor
into @RowNumStorage,@RowValueStorage

-- Check the row status of the cursor if it is not in the last row
while @@Fetch_Status =0

begin
-- Here I just need to show some displays to test if the cursor is really moving
-- I tried to check every row if the value is an ODD or EVEN number.

if((@RowValueStorage%2)=1)
begin
print 'RowNumber: ' + @RowNumStorage + ', Value:' + @RowValueStorage + ' is an ODD number '
end
else
begin
print 'RowNumber: ' + @RowNumStorage + ', Value:' + @RowValueStorage + ' is an EVEN number '
end
-- I need to call the fetch in order to loop through the record
FETCH NEXT FROM MyCursor
into @RowNumStorage,@RowValueStorage
end

-- finally I need to close the cursor and dispose it
close MyCursor
deallocate MyCursor