Microsoft Sql Server Management Object--Getting Problem In Defining DataType

Hiii

     I am working on a application where I will upload my excel sheet.Then the application will read the header and will create a table to store the excel sheet.

When the excel sheet will be uploaded first it will read the header of the excel and will display it inside a gridview to choose which columns are to be created along  with datatype.I am giving u a snapshot



Column Name
Select
Datatype

Group Code



Emp No



Mem code



Amount



So Here the user is selecting tha data type.So I am passing the data type to my functions.But while assigning the datatype I am getting error that can no convert from sting to Microsoft.SqlServer.Management.Smo.DataType.I am giving u the demo codeprivate void button1_Click(object sender, EventArgs e)

{ServerConnection objsvrconn = new ServerConnection();

objsvrconn.LoginSecure = false;objsvrconn.ServerInstance = "DEMO";

objsvrconn.Login = "sa";objsvrconn.Password = "sa";

Server objsvr;objsvr = new Server(objsvrconn);

//objsvr.ConnectionContext.Connect();Table tb = objsvr.Databases["Demo"].Tables["Temp"]; Column c = new Column(tb, "GrpCode");

DataType dt = new DataType();dt.SqlDataType =(DataType)"Varchar" ---I am getting the error here.It only accecept from a enum i.e Datatype.Typename but doesnot accept like this

dt.MaximumLength = 10;

c.DataType = dt;

tb.Columns.Add(c);

tb.Alter();

}

 

Please help me.