Vlad.ToString()
Tuesday, November 01, 2011
Accessing Stored Procedures Using ADO.NET
From here.
// create the connectionOracleConnection conn = new OracleConnection("Data Source=oracledb;User Id=UserID;Password=Password;");// create the command for the stored procedureOracleCommand cmd = new OracleCommand();cmd.Connection = conn;cmd.CommandText = "SELECT_JOB_HISTORY.GetJobHistoryByEmployeeId";cmd.CommandType = CommandType.StoredProcedure;// add the parameters for the stored procedure including the REF CURSOR// to retrieve the result setcmd.Parameters.Add("p_employee_id", OracleType.Number).Value = 101;cmd.Parameters.Add("cur_JobHistory", OracleType.Cursor).Direction =ParameterDirection.Output;// createt the DataAdapter from the command and use it to fill the// DataSetOracleDataAdapter da = new OracleDataAdapter(cmd);DataSet ds = new DataSet();da.Fill(ds);// output the results.Console.WriteLine(ds.Tables[0].Rows.Count);
Thursday, September 15, 2011
Sunday, September 04, 2011
Starting activity from command line
am start -a android.intent.action.MAIN -n com.mydomain.mypackage/com.mydomain.mypackage.HomeActivity
-a action to perform
-n on this activity
Tuesday, August 16, 2011
Add static libraries *.jar to Android.mk based build
in Android.mk
LOCAL_STATIC_JAVA_LIBRARIES := mylocaljar
LOCAL_PREBUILT_STATIC_JAVA_LIBRARIES := mylocaljar: mylocaljar.jar
mylocaljar.jar should be in root directory of the project. Look at the Calculator app's Android.mk in Android tree as an example
Blogpost code highlighting
Here I found how to highlight code in my blogposts on Blogspot. It's still not ideal because it doesn't support the original indentation but better nothing.
Subscribe to:
Posts (Atom)