C# with SQLserver ,same code wanted with oracle

[rameshonweb]

Can some one help to change the below code with oracle database instead of sqlserver


[CODE=cpp]private void SortDataList(st ring strSort)
{

SqlConnection objConn = new SqlConnection(G etConnectionStr ing());

SqlDataAdapter objCmd = new SqlDataAdapter( "exec dbo.MyStoredPro cedure", objConn);

DataSet objDS = new DataSet();

DataTable objDT = new DataTable();

DataView objDV = new DataView();



objCmd.Fill(obj DS);

objDT = objDS.Tables[0];

objDV = objDS.Tables[0].DefaultView;



objDV.Sort = strSort;



Repeater1.DataS ource = objDV;

Repeater1.DataB ind();

objConn.Close() ;

}[/CODE]

[Shashi Sadasivan]

please check this website on Build a .NET Application on the Oracle Database