PK Tech Home

Android, sample3 , Create,open close SQLite DB

2008-04-01T01:43:00.001-07:00

Source from:http://code.google.com/android/intro/tutorial-ex1.html

/*
* Copyright (C) 2008 Google Inc.
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.google.android.demo.notepad1;
import android.app.ListActivity;
import android.database.Cursor;
import android.os.Bundle;
import android.view.Menu;
import android.view.Menu.Item;
import android.widget.SimpleCursorAdapter;
public class Notepadv1 extends ListActivity {
private int mNoteNumber = 1;
private NotesDbAdapter mDbHelper;
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle icicle) {
//super.onCreate(icicle);
super.onCreate(icicle);
setContentView(R.layout.notepad_list);
mDbHelper = new NotesDbAdapter(this);
mDbHelper.open();
fillData();
}
public static final int INSERT_ID = Menu.FIRST; //Note: In strings.xml resource (under res/values), add a new string for menu_insert with text "Add Item" Add Item, then save the file
@Override
public boolean onCreateOptionsMenu(Menu menu) {
// TODO Auto-generated method stub
// return super.onCreateOptionsMenu(menu);
boolean result = super.onCreateOptionsMenu(menu);
menu.add(0, INSERT_ID, R.string.menu_insert);
return result;
}
@Override
public boolean onOptionsItemSelected(Item item) {
// TODO Auto-generated method stub
//return super.onOptionsItemSelected(item);
switch (item.getId()) {
case INSERT_ID:
createNote();
return true;
}
return super.onOptionsItemSelected(item);
}
private void createNote() {
String noteName = "Note " + mNoteNumber++;
mDbHelper.createNote(noteName, "");
fillData();
}
private void fillData() {
// Get all of the notes from the database and create the item list
Cursor c = mDbHelper.fetchAllNotes();
startManagingCursor(c);
String[] from = new String[] { NotesDbAdapter.KEY_TITLE };
int[] to = new int[] { R.id.text1 };
// Now create an array adapter and set it to display using our row
SimpleCursorAdapter notes =
new SimpleCursorAdapter(this, R.layout.notes_row, c, from, to);
setListAdapter(notes);
}
}

----------------------------------------------------------------------------

/*
* Copyright (C) 2008 Google Inc.
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/ package com.google.android.demo.notepad1;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;

import java.io.FileNotFoundException;

/**
* Simple notes database access helper class. Defines the basic CRUD operations
* for the notepad example, and gives the ability to list all notes as well as
* retrieve or modify a specific note.
*
* This has been improved from the first version of this tutorial through the addition
* of better error handling and also using returning a Cursor instead of using
* a collection of inner classes (which is less scalable and not recommended).
*/
public class NotesDbAdapter {

public static final String KEY_TITLE="title";
public static final String KEY_BODY="body";
public static final String KEY_ROWID="_id";

/**
* Database creation sql statement
*/
private static final String DATABASE_CREATE =
"create table notes (_id integer primary key autoincrement, "
+ "title text not null, body text not null);";

private static final String DATABASE_NAME = "data";
private static final String DATABASE_TABLE = "notes";
private static final int DATABASE_VERSION = 2;

private SQLiteDatabase mDb;
private final Context mCtx;

/**
* Constructor - takes the context to allow the database to be opened/created
* @param ctx the Context within which to work
*/
public NotesDbAdapter(Context ctx) {
this.mCtx = ctx;
}

/**
* Open the notes database. If it cannot be opened, try to create a new instance of
* the database. If it cannot be created, throw an exception to signal the failure
* @return this (self reference, allowing this to be chained in an initialization call)
* @throws SQLException if the database could be neither opened or created
*/
public NotesDbAdapter open() throws SQLException {
try {
mDb = mCtx.openDatabase(DATABASE_NAME, null);
} catch (FileNotFoundException e) {
try {
mDb =
mCtx.createDatabase(DATABASE_NAME, DATABASE_VERSION, 0,
null);
mDb.execSQL(DATABASE_CREATE);
} catch (FileNotFoundException e1) {
throw new SQLException("Could not create database");
}
}
return this;
}

public void close() {
mDb.close();
}

/**
* Create a new note using the title and body provided. If the note is successfully created
* return the new rowId for that note, otherwise return a -1 to indicate failure.
* @param title the title of the note
* @param body the body of the note
* @return rowId or -1 if failed
*/
public long createNote(String title, String body) {
ContentValues initialValues = new ContentValues();
initialValues.put(KEY_TITLE, title);
initialValues.put(KEY_BODY, body);
return mDb.insert(DATABASE_TABLE, null, initialValues);
}

/**
* Delete the note with the given rowId
* @param rowId id of note to delete
* @return true if deleted, false otherwise
*/
public boolean deleteNote(long rowId) {
return mDb.delete(DATABASE_TABLE, KEY_ROWID + "=" + rowId, null) > 0;
}

/**
* Return a Cursor over the list of all notes in the database
* @return Cursor over all notes
*/
public Cursor fetchAllNotes() {
return mDb.query(DATABASE_TABLE, new String[] {
KEY_ROWID, KEY_TITLE, KEY_BODY}, null, null, null, null, null);
}

/**
* Return a Cursor positioned at the note that matches the given rowId
* @param rowId id of note to retrieve
* @return Cursor positioned to matching note, if found
* @throws SQLException if note could not be found/retrieved
*/
public Cursor fetchNote(long rowId) throws SQLException {
Cursor result = mDb.query(true, DATABASE_TABLE, new String[] {
KEY_ROWID, KEY_TITLE, KEY_BODY}, KEY_ROWID + "=" + rowId, null, null,
null, null);
if ((result.count() == 0) !result.first()) {
throw new SQLException("No note matching ID: " + rowId);
}
return result;
}

/**
* Update the note using the details provided. The note to be updated is specified using
* the rowId, and it is altered to use the title and body values passed in
* @param rowId id of note to update
* @param title value to set note title to
* @param body value to set note body to
* @return true if the note was successfully updated, false otherwise
*/
public boolean updateNote(long rowId, String title, String body) {
ContentValues args = new ContentValues();
args.put(KEY_TITLE, title);
args.put(KEY_BODY, body);
return mDb.update(DATABASE_TABLE, args, KEY_ROWID + "=" + rowId, null) > 0;
}
}

--------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------

Notepad v1
No Notes Yet
Add Item

Android, sample2 ,Display String!

2008-04-01T01:35:00.001-07:00

package com.android.hello;
import android.app.Activity;
import android.os.Bundle;
public class HelloAndroid extends Activity {
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle icicle) {
super.onCreate(icicle);
setContentView(R.layout.main);
}
}

Android, sample1 ,Hello, Android!

2008-04-01T01:33:00.000-07:00

package com.android.hello;
import android.app.Activity;
import android.os.Bundle;
import android.widget.TextView;
public class HelloAndroid extends Activity {
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle icicle) {
super.onCreate(icicle);
TextView tv = new TextView(this);
tv.setText("Hello, Android");
setContentView(tv);
}
}

Java, Beginning

2007-10-21T09:33:00.000-07:00

=Tools Download =
==Java JDK 6.0 SE ==
Standard Edition and JRE http://java.sun.com/javase/downloads/index.jsp

VLC, Vlc cannot insert to IE browser by Javscript innerHTML function

2007-10-19T18:34:00.000-07:00

Question: VLC, Vlc cannot insert to IE browser by Javscript innerHTML function in the run-time.
(Solution) Used below web site test HTML code, It can working with latest version 0.8.6c,
(6) http://forum.videolan.org/viewtopic.php?t=28383
Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\TypeLib\{DF2BBE39-40A8-433B-A279-073F48DA94B6}]
[HKEY_CLASSES_ROOT\TypeLib\{DF2BBE39-40A8-433B-A279-073F48DA94B6}\1.0]@="VideoLAN VLC ActiveX Plugin"
[HKEY_CLASSES_ROOT\TypeLib\{DF2BBE39-40A8-433B-A279-073F48DA94B6}\1.0\0]
[HKEY_CLASSES_ROOT\TypeLib\{DF2BBE39-40A8-433B-A279-073F48DA94B6}\1.0\0\win32]@="C:\\$PATH\\VideoLAN\\VLC\\axvlc.dll"
[HKEY_CLASSES_ROOT\TypeLib\{DF2BBE39-40A8-433B-A279-073F48DA94B6}\1.0\FLAGS]@="0"
[HKEY_CLASSES_ROOT\TypeLib\{DF2BBE39-40A8-433B-A279-073F48DA94B6}\1.0\HELPDIR]@="C:\\$PATH\\VideoLAN\\VLC"

ATSC-EPG- Learning Day1

2006-08-04T12:08:00.000-07:00

First, we need to get the Demux file,
IMpeg2Demultiplexer *pDemux = NULL;
hr = m_FunCPoGraphBuilderSupport1.FindFilterInterface(pieHIPDVRGraph,IID_IMpeg2Demultiplexer, (void**)&pDemux);
if (SUCCEEDED(hr))
{
}

**, Create a IMPEG2pPIDMAP

// Map the PID.
IMPEG2PIDMap *pPidMap = NULL;
hr = pPin->QueryInterface(IID_IMPEG2PIDMap, (void**)&pPidMap);
if (SUCCEEDED(hr))
{
ULONG Pid[] = { 0x00 }; // Map any desired PIDs.
ULONG cPid = 1;
hr = pPidMap->MapPID(cPid, Pid, MEDIA_MPEG2_PSI);
pPidMap->Release();
}
pPin->Release();

**.. Or, you can search the IMpeg2Data

const IID IID_IMpeg2Data = {0x9B396D40, 0xF380, 0x4e3c, 0xA5, 0x14, 0x1A,0x82, 0xBF, 0x6E, 0xBF, 0xE6};
IMpeg2Data *pMPEG = NULL;
hr = m_FunCPoGraphBuilderSupport1.FindFilterInterface(pieHIPDVRGraph, IID_IMpeg2Data, (void**)&pMPEG);

**. Create a new pDemux and PIDMap

//-------------
// Query the demux filter for IMpeg2Demultiplexer.
IMpeg2Demultiplexer *pDemux = NULL;
hr = pieHIPDVRGraph->QueryInterface(IID_IMpeg2Demultiplexer, (void**)&pDemux);
if (SUCCEEDED(hr))
{
// Define the media type.
AM_MEDIA_TYPE mt;
ZeroMemory(&mt, sizeof(AM_MEDIA_TYPE));
mt.majortype = KSDATAFORMAT_TYPE_MPEG2_SECTIONS;
mt.subtype = MEDIASUBTYPE_None;

// Create a new output pin.
IPin *pPin;
hr = pDemux->CreateOutputPin(&mt, L"PSI Pin", &amp;amp;amp;amp;pPin);
if (SUCCEEDED(hr))
{
// Map the PID.
IMPEG2PIDMap *pPidMap = NULL;
hr = pPin->QueryInterface(IID_IMPEG2PIDMap, (void**)&pPidMap);
if (SUCCEEDED(hr))
{
ULONG Pid[] = { 0x00 }; // Map any desired PIDs.
ULONG cPid = 1;
hr = pPidMap->MapPID(cPid, Pid, MEDIA_MPEG2_PSI);
pPidMap->Release();
}
pPin->Release();
}
pDemux->Release();
}

//-------------

* Get PSIP data function is below, for get the MGT data. (Working)
(5+)http://msdn.microsoft.com/library/default.asp?url=/library/en-us/directshow/htm/gettingmpeg2psitables.asp

hr = pieHIPDVRGraph->QueryInterface (&this->pieHIPDVRControl);
hr = this->pieHIPDVRControl->Run();

//Start EPG --------------------
// (5+) http://forums.dvbowners.com/lofiversion/index.php/t1117.html

const IID IID_IMpeg2Data = {0x9B396D40, 0xF380, 0x4e3c, 0xA5, 0x14, 0x1A,0x82, 0xBF, 0x6E, 0xBF, 0xE6};
if (SUCCEEDED(hr))
{
IIPDVDec *pDvDec=NULL;
IMpeg2Demultiplexer *pDemux = NULL;
hr = m_FunCPoGraphBuilderSupport1.FindFilterInterface(pieHIPDVRGraph, IID_IMpeg2Demultiplexer, (void**)&pDemux);
if (SUCCEEDED(hr))
{
// IMpeg2Data *pMPEG = NULL;
// Initialize pMPEG by searching the graph for a filter that exposes the
// IMpeg2Data interface (not shown). Run the graph to get MPEG-2 data.
// CLSID_MPEG-2 Sections and Tables

hr = m_FunCPoGraphBuilderSupport1.FindFilterInterface(pieHIPDVRGraph, IID_IMpeg2Data, (void**)&(this->g_pMPEG)); //pMPEG);
if (SUCCEEDED(hr))
{
this->GetEPG(this->g_pMPEG);
}

pDemux->Release();
}
else
{
// Some other error occurred.
}
}
#ifdef _DEBUG
m_FunCPoGraphBuilderSupport1.POSaveGraphFile(pieHIPDVRGraph,L"C:\\3.grf");
#endif
//End EPG ------------------

//---------------------------------------------------------------------
//---------------------------------------------------------------------
//---------------------------------------------------------------------

HRESULT CieHIPDVRGraphBuilder::GetEPG(IMpeg2Data *i_pMPEG)
{ HRESULT hr = S_OK;
ISectionList *pSectionList = NULL;
/*
pid=0, tid=0; ok, It is for call Program Association Table
pid=0x1ffb tid=c7; ok, MGT
pid = 7424; tid = 0xcb;
*/
static PID pid = 0x1ffb; //0xc7; //0x00;//0x00;
TID tid = 0x1ffb; //0xcb; //0x00;
DWORD dwTimeout = 500; // msec
// pid=7424;
// PID pid2 =pid;
try
{
hr = i_pMPEG->GetSection(pid, tid, NULL, dwTimeout, &pSectionList);
if (SUCCEEDED(hr))
{
// Use pSectionList to access the data
// 060804 1608 start get the data
WORD cSections;
hr = pSectionList->GetNumberOfSections(&cSections);
for (WORD i = 0; i < hr =" pSectionList-">GetSectionData(i, &cbSize, &pSection);
if (SUCCEEDED(hr))
{
m_FunCPoGraphBuilderSupport1.PrintMpeg2Section(pSection, cbSize);
// Examine the data contained in pSection.
}
}
// 060804 1608 end get the data

pSectionList->Release();
}
}catch (CException *e)
{
}
return hr;
}

//------------------------------------------------------------------------------

---------------------
1) Copy below code
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/directshow/htm/gettingmpeg2psitables.asp
2) Used below code to get the MPEG-2 Table and section Filter interface,
const IID IID_IMpeg2Data = {0x9B396D40, 0xF380, 0x4e3c, 0xA5, 0x14, 0x1A,0x82, 0xBF, 0x6E, 0xBF, 0xE6};
if (SUCCEEDED(hr))
{
IIPDVDec *pDvDec=NULL;
IMpeg2Demultiplexer *pDemux = NULL;
hr = m_FunCPoGraphBuilderSupport1.FindFilterInterface(pieHIPDVRGraph, IID_IMpeg2Demultiplexer, (void**)&pDemux);
if (SUCCEEDED(hr))
{
// IMpeg2Data *pMPEG = NULL;
hr = m_FunCPoGraphBuilderSupport1.FindFilterInterface(pieHIPDVRGraph, IID_IMpeg2Data, (void**)&(this->g_pMPEG)); //pMPEG);
if (SUCCEEDED(hr))
{
this->GetEPG(this->g_pMPEG);
}

pDemux->Release();
}
}
3) Set up Table ID and Package Identifier.
pid=0, tid=0; ok, It is for call Program Association Table
pid=0x1ffb tid=c7; ok, MGT
pid = 7424; tid = 0xcb; //EIT

4)MGT Data struct and EIT Data Struct
see http://www.atsc.org/standards/a_65c_with_amend_1.pdf
http://www.atsc.org/standards/a_69.pdf
http://www.atsc.org/standards/a_65c_with_amend_1.pdf

Refrence:
(Software Filter )http://www.coolstf.com/tsreader/

Refrence
*.Select decoder http://www.delphibbs.com/keylife/iblog_show.asp?xid=23054
*. Get PSI http://msdn.microsoft.com/library/default.asp?url=/library/en-us/directshow/htm/usingthedemuxwithpsistreams.asp
*. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=46331&SiteID=1

C#-DB-Create a Access DB

2006-04-10T13:25:00.003-07:00

Below code is a way to create a Access DB by Database.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q307283

using System;
using System.Data.SqlClient;

private void btnCreateDataBase_Click(object sender, System.EventArgs e)
{
SqlDataReader reader = null;
SqlConnection myConn = new SqlConnection("Server=serverName;uid=sa;pwd=;database=");

SqlCommand myCommand = new SqlCommand("CREATE DATABASE test ON PRIMARY"
+"(Name=test_data,filename = 'C:\\myDatabase\\test_data.mdf',size=3,"
+"maxsize=5,filegrowth=10%)log on"
+"(name=test_log,filename='C:\\myDatabase\\test_log.ldf',size=3,"
+"maxsize=20,filegrowth=1)",myConn);

try
{
myConn.Open();
reader = myCommand.ExecuteReader();
}
catch (Exception e)
{
Console.Write(e.ToString());
}
finally
{
if (reader != null)
reader.Close();
if (myConn.State == ConnectionState.Open)
myConn.Close();
}
}

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
http://www.codeproject.com/dotnet/ExportToExcel.asp?df=100&forumid=146533&exp=0&select=1357703

using System;
using System.IO;
using System.Collections;
using System.Data;
using System.Text;
using System.Data.OleDb;

private static OleDbConnection GetConnection(string filePath )
{
return new System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties=\"Excel 8.0;HDR=YES;\"");
}

public static void exportToExcel(DataTable dt, string fileName)
{
#region initialization
//if the file already exists then delete it
System.IO.FileInfo fi = new System.IO.FileInfo(fileName);
if (fi.Exists)
{
fi.Delete();
}

//set the table name if its not there
if (dt.TableName == string.Empty)
{
dt.TableName = "Sheet1";
}
else//remove $ from table name if it is there
{
dt.TableName = dt.TableName.Replace("$",string.Empty);
}
#endregion

string sql = GetTableCreationSql(dt);
OleDbConnection connection = GetConnection(fileName);
OleDbCommand command = new OleDbCommand();
command.Connection = connection;
try
{
#region Create table
command.CommandText = GetTableCreationSql(dt);
command.Connection.Open();
command.ExecuteNonQuery();
#endregion

#region Insert Into Table

command.CommandText = GetInsertSql(dt);

foreach(DataRow row in dt.Rows)
{
SetParametersInCommand(row, command);
command.ExecuteNonQuery();
}

#endregion
}
finally
{
command.Connection.Close();
}

}

///
/// form a string which should be the sqlCommand for creating Table in oleDB
///
///
/// create table [tableName] ( Column1 type, ..., Columnn Type)
private static string GetTableCreationSql(DataTable dt)
{
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append("create table [");
sqlBuilder.Append(dt.TableName);
sqlBuilder.Append( "] ( " );

#region Get Column List
//Create a list of column names and their data types, e.g
//[ColumnName1] nvarchar, [ColumnName2] nvarchar,...[ColumnNamen] nvarchar
foreach(DataColumn col in dt.Columns)
{
if (col.Ordinal== 0)
sqlBuilder.Append( "[" );
else
sqlBuilder.Append( ", [" );

sqlBuilder.Append(col.ColumnName.Trim());
sqlBuilder.Append("] nvarchar");
}
#endregion

sqlBuilder.Append(" )");

return sqlBuilder.ToString();
}

///
/// form a insert statement to insert data into oleDB
///
///
/// Insert Into tableName ([ColumnName1], [ColumnName2] ,...[ColumnNamen]) values (?,?,..,?)
private static string GetInsertSql(DataTable dt)
{
StringBuilder sqlBuilder = new StringBuilder();
StringBuilder paramMarks = new StringBuilder();
sqlBuilder.Append("Insert Into [");
sqlBuilder.Append(dt.TableName);
sqlBuilder.Append( "] ( " );

#region Get Column List
//Create a list of column names and their place holders
//[ColumnName1] , [ColumnName2] ,...[ColumnNamen]
// ?,?,...?
foreach(DataColumn col in dt.Columns)
{
if (col.Ordinal == 0)
{
sqlBuilder.Append( "[" );
paramMarks.Append( "?" );
}
else
{
sqlBuilder.Append( ", [");
paramMarks.Append(",?");
}

sqlBuilder.Append(col.ColumnName.Trim());
sqlBuilder.Append( "] " );
}
#endregion

sqlBuilder.Append(" ) values (");
sqlBuilder.Append(paramMarks.ToString() );
sqlBuilder.Append( ")" );

return sqlBuilder.ToString();
}

private static void SetParametersInCommand(DataRow row, OleDbCommand command)
{
UnicodeEncoding en = new UnicodeEncoding();
string argumentName= string.Empty;
int index = 0;
foreach(DataColumn col in row.Table.Columns)
{
argumentName = "@Args" + index;
command.Parameters.Add( new OleDbParameter(argumentName, OleDbType.VarBinary)).Value =
en.GetBytes(row[ col ].ToString());
index++;
}
}

Sanjeev Kumar Singh,(sanjeevofbcs@hotmail.com)
MTS,
Persistent System Pvt Ltd
(http://www.persistentsys.com/)

AJAX-- nice web site

2006-03-30T13:22:00.000-08:00

www.meebo.com

Music player
http://www.pandora.com/

Deitel AJAX Resource Center
http://www.deitel.com/ajax/AJAX_resourcecenter.html

It was very interesting. A lot of Web 2.0 companies where presenting and demoing their technology.
Among them were Sphere, Meebo, Healthline, Wink, Flock, Pandora, Zvents, Loomia, Goowy, RealTravel, TailRank, MeasureMap. Most of them revolve around the blog / bloggers sphere.

The Web 2.0 business model is scary. None of these companies have a clear plan for revenue. It seems like most of the Web 2.0 companies are think tanks or research-oriented technologies whose only goal is to be purchased by a big Web portal (google, yahoo, etc).

Sphere, Wink, Flock, Zvents, TailRank are all about blogs and similar user-contributed content.
I couldn't see any method other than advertising to generate revenue. When you only have 3 big players for the advertising market today -- Google, Yahoo, and MSN -- the only exit is a purchase.
The key for these companies seems to be user adoption. The more users they have and the bigger their community is the more likely they will be able to get some value out of it.

Pandora and Loomia are about podcasting and music, both very interesting and complementary technology.

Goowy is a MS Exchange killer using Macromedia Flash. It looks good, but with free open source players like Zimbra, Hula, Open Exchange, Kolab, RoundCube they have serious competition.

Meebo is an interesting technology for a web based instant messaging system, but it's not currently building a community of users, so I am not sure what their plans are.

RealTravel is a user-contributed travel guide -- very nice, with a clever way to build traffic with high quality user-contributed content. But I see it as a niche market.

Healthline was probably the best technology I've seen. Especially after listening to Adam Bosworth (Google VP of Engineering) talking about upcoming new types of searches (such as medical searches). It's an intelligent and tool-rich search for health-related information. It reminds me of a company I saw at the Santa Barbara Tech Coast Angel presentation.

MeasureMap is a web traffic report for Blogs. The user interface is very nice.

I've learned a lot by looking at these technologies. There are a lot of good ideas and user interface tricks among them, especially in terms of UI, as seen in MeasureMap.

It comforts me to see that we have a good business model with revenue as well as all the components necessary to be part of this Web 2.0 trend.

I would like to thank Michael for putting together such an event; it was great to be able to meet amazing entrepreneurs and smart VCs in such a casual atmosphere.

Digital Integrated Circuits-Week 1 PartI

2006-02-23T20:36:00.000-08:00

$---mos1-----
********
.temp=25
.option dccap=1 scale=1u post
.param vd=3 vg=1.5 vs=0
$-------
vd1 d 0 vd
vg1 g 0 vg
vss vss 0 vs
mn1 d g vss vss ns w=10 l=0.3
$-----
.dc vd1 0 3 0.05 sweep vg1 1 3 0.5
.op
.probe i(mn1)
$========================
$.model ps pmos
$+ level=1
$+ acm=3 capop=1
$$-----
$+ ld=0.05u wd=0.1u hdif=0.4u rsh=8
$$-----
$+ vt0=-0.7 tox=60 ub=200
$+ gamma=0.6 lambda=0.05
$+ js=1m jsw=1n cj=1m cjsw=1n cjgate=0.5n mj=0.5 mjsw=0.3 pb=0.6 php=0.6
$$=========================
.model ns nmos
+ level=1
+ acm=3 capop=1
$+ theta=0.6 vmax=3e5 kappa=0.6
$-----
+ ld=0.05u wd=0.1u hdif=0.4u rsh=8
$-----
+ vt0=0.7 tox=60 ub=450
+ gamma=0.6
+lambda=0.05
+ js=1m jsw=1n cj=1m cjsw=1n cjgate=0.5n mj=0.5 mjsw=0.3 pb=0.6 php=0.6
$-------
.end

Digital Integrated Circuits-Week 1

2006-02-23T20:13:00.000-08:00

MOS.TXT
$--- mos ---
******
.temp=25
.option dccap=1 scale=1u nopage
.param vd=3 vg=1.5 vs=0
$-------
vd1 d 0 vd
vg1 g 0 vg
vss vss 0 vs
mn1 d g vss vss ns w=10 l=0.3
$-----
.dc vd1 0 3 0.05 sweep vg1 1 3 0.5
.op
.probe i(mn1)
$========================
$.model ps pmos
$+ level=1
$+ acm=3 capop=1
$$-----
$+ ld=0.05u wd=0.1u hdif=0.4u rsh=8
$$-----
$+ vt0=-0.7 tox=60 ub=200
$+ gamma=0.6 lambda=0.05
$+ js=1m jsw=1n cj=1m cjsw=1n cjgate=0.5n mj=0.5 mjsw=0.3 pb=0.6 php=0.6
$$=========================
.model ns nmos
+ level=1
+ acm=3 capop=1
$-----
+ ld=0.05u wd=0.1u hdif=0.4u rsh=8
$-----
+ vt0=0.7 tox=60 ub=450
+ gamma=0.6 lambda=0.05
+ js=1m jsw=1n cj=1m cjsw=1n cjgate=0.5n mj=0.5 mjsw=0.3 pb=0.6 php=0.6
$-------
.end

IIS-Cassini

2006-02-23T14:57:00.001-08:00

I'm coming dear Cassini
I hear cassini this program for a while time,
luckly, right now has chance to learn and research the cassini.

Refrence:
http://support.microsoft.com/default.aspx?scid=kb;en-us;893391

What is the Cassini Web server?
The Cassini Web server is a simple, fully managed Web server that hosts ASP.NET. The Cassini Web server is a combination of the following:
•A simple HTTP listener that was built by using System.Net.Sockets.
•A hosting sample of ASP.NET that was built by using System.Web.Hosting APIs. This lets you host ASP.NET from any managed application.

What are some known functionality limitations of the Cassini Web server?
•It can host only one ASP.NET application per port.
•It does not support HTTPS.
•It does not support authentication.
•It responds only to localhost requests.

Where can get the Cassini

Is the Cassini Web server open-source software?
Although the source code for the public version of the Cassini Web server is available for download, the instance of the Cassini Web server that is installed with the Outlook client is not an open-source product.

IIS-Cassini

2006-02-23T14:57:00.000-08:00

C#-Thread-Passing Parameters to Threads

2006-02-21T14:26:00.000-08:00

Passing Parameters to Threads
Often when you start a thread, you want to give it some parameters - usually some data it has to process, a queue to wait on, etc. The ThreadStart delegate doesn't take any parameters, so the information has to be stored somewhere else if you are going to create a new thread yourself. Typically, this means creating a new instance of a class, and using that instance to store the information. Often the class itself can contain the delegate used for starting the thread. For example, we might have a program which needs to fetch the contents of various URLs, and wants to do it in the background. You could write code like this:

public class UrlFetcher
{
string url
public UrlFetcher (string url)
{
this.url = url;
}
public void Fetch()
{
// use url here
}
}
[... in a different class ...]

UrlFetcher fetcher = new UrlFetcher (myUrl);
new Thread (new ThreadStart (fetcher.Fetch)).Start();

JS- XML and JavaScript

2006-02-04T19:48:00.000-08:00

XML and JavaScript
Introduction:XML is a very important base on which Web Services work. XML can be used in conjunction with a lot of client side and server side languages to put it to good effect. Let us see how we can use XML and client side JavaScript to work. We will see how we can display the contents of a XML file using JavaScript, accessing child elements, manipulating elements etc. Browser Issues:When it comes client side languages browser incompatibilities is a major issue. But here where we want to use XML and JavaScript, XML is the issue. Not all browsers have support for parsing XML documents. I will use IE6 to explain the codes. Browsers that do not support XML, cannot read them. When you view an XML file in such a browser it will just ignore all the tags. S
ample XML file:Let us consider a sample XML file >>

Premshree PillaiKumar SinghSuhasini Pandita100,000140,000200,000

The above XML file shows employee data and Turnover of the company (just an e.g).Manipulating XML file data using JavaScript:

Loading XML file: You can load a XML fie from JavaScript like this >>

var xmlDoc = new ActiveXObject("Microsoft.XMLDOM");
function loadXML(xmlFile)
{
xmlDoc.async="false";
xmlDoc.onreadystatechange=verify;
xmlDoc.load(xmlFile);
xmlObj=xmlDoc.documentElement;
}

Actually, just the last two lines of the function are enough to load the XML file. It is very easy then you think, The previous two lines are written to ensure that the JavaScript functions that we may use later to manipulate the XML file data, does not perform any function on an uninitialized object. Thus the function verify()is called.

function verify()
{
// 0 Object is not initialized
// 1 Loading object is loading data
// 2 Loaded object has loaded data
// 3 Data from object can be worked with
// 4 Object completely initialized
if (xmlDoc.readyState != 4)
{
return false;
}
}

Now the XML file can be loadedloadXML('xml_file.xml');

source from:
http://www.a1javascripts.com/tutorials/xml.html

VC-SYS-Get current APP working directory.

2006-01-30T13:59:00.000-08:00

How to set the current working directory?

if(::SetCurrentDirectory("c:\\test") == FALSE)
// Error -> call 'GetLastError()'

How to Get the current working directory?

char CurPath[MAX_PATH];　　
DWORD size=MAX_PATH;　　
GetCurrentDirectory(size,CurPath);　　
AfxMessageBox(CurPath);　　　　//　　CString number;　　
int len = LineLength(LineIndex(0));　　
LPTSTR p=number.GetBuffer(len);　　
this->GetLine(0,p,len);　　
AfxMessageBox(number);　　

Refrence:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fileio/fs/getcurrentdirectory.asp

MDI-Get the view rect size.

2006-01-29T15:41:00.000-08:00

void CEx08bView::OnInitialUpdate()
{
CView::OnInitialUpdate();
CRect rectClient; GetClientRect(rectClient);
}

DVB and ATSC Q&A

2006-01-27T14:01:00.000-08:00

Turn space:

TV-Get the SignalQuality from ASTC and DVBT -Day1 -Done

2006-01-27T12:11:00.000-08:00

Target: Get the SignalQuality from ASTC and DVBT -Done

1. It has problem to get the Singal in kworld card. but Prolink is working.

Origial code:

HRESULT spb_IEHIPbdaTV::GetSignalStatistics(long &iLOCKED, long &iSTRENGTH, long &iQUALITY, long &iSIGNAL,long &iFrequency )
{
HRESULT hr = S_OK;
BOOLEAN locked;
long strength;
long quality;
BOOLEAN present;

CComPtr bdaNetTop;
/*
The IBDA_Topology interface is implemented on BDA device filters.
A single filter may represent multiple hardware devices (called control nodes)
which may be connected in various ways within the filter itself.
These connections generally represent hardware paths on the card.
This interface provides methods that enable a Network Provider to
configure or discover the types of nodes within the filter, and how these nodes are connected.
The methods correspond closely to the Ring 0 property sets which are documented in the Windows DDK.
*/
hr = this->GpTUNERDEVICE.QueryInterface(&bdaNetTop);
if(SUCCEEDED(hr))
{
CComPtr unknown;
// Retrieves an IUnknown interface pointer for a specified control node.
hr = bdaNetTop->GetControlNode(0, 1, BDA_TWINHAN_DEMODULATOR_NODE, &unknown);
if (FAILED(hr))
{
this->CONSOLE_TEXT("Error : Code # %d - GetSignalStatistics : GetControlNode BDA_TWINHAN_DEMODULATOR_NODE",hr);
}
else
{
CComPtr pSigStats;
hr = unknown.QueryInterface(&pSigStats);
if (FAILED(hr))
{
this->CONSOLE_TEXT("Error : Code # %d - GetSignalStatistics : IBDA_SignalStatistics QI",hr);
}
else
{
long quality = -2;
hr = pSigStats->get_SignalQuality(&quality);
iQUALITY = quality;
if (FAILED(hr))
{
// this->CONSOLE_TEXT("Error : Code # %d - GetSignalStatistics : get_SignalQuality()",hr);
}
else
{
}
BOOLEAN locked = FALSE;
//long locked = -2;
hr = pSigStats->get_SignalLocked(&locked);
iLOCKED = locked;
if (FAILED(hr))
{
// this->CONSOLE_TEXT("Error : Code # %d - GetSignalStatistics : get_SignalLocked()",hr);
}
else
{
}
}
}
CComPtr unknown2;
hr = bdaNetTop->GetControlNode(0, 1, BDA_TWINHAN_TUNER_NODE, &unknown2);
if (FAILED(hr))
{
this->CONSOLE_TEXT("Error : Code # %d - GetSignalStatistics : GetControlNode BDA_TWINHAN_TUNER_NODE",hr);
}
else
{
CComPtr pSigStats2;
hr = unknown2.QueryInterface(&pSigStats2);
if (FAILED(hr))
{
this->CONSOLE_TEXT("Error : Code # %d - GetSignalStatistics : IBDA_SignalStatistics QI",hr);
}
else
{
long strength = -1;
hr = pSigStats2->get_SignalStrength(&strength);
if (FAILED(hr))
{
this->CONSOLE_TEXT("Error : Code # %d - GetSignalStatistics : get_SignalStrength()",hr);
}
else
{
iSTRENGTH = strength;
}
BOOLEAN present = FALSE;
hr = pSigStats2->get_SignalPresent(&present);
if (FAILED(hr))
{
this->CONSOLE_TEXT("Error : Code # %d - GetSignalStatistics : get_SignalPresent()",hr);
}
else
{
iSIGNAL = present;
}
}
}
}
else
{
this->CONSOLE_TEXT("Error : Code # %d - GetSignalStatistics : IBDA_Topology QI",hr);
}

/////////
// HRESULT hr;
TCHAR BUFFER[128];
// (*numFound) = 0;
ProgramINFO info;
CComPtr piTuneRequest;

if (this->GpNETWORKPROVIDER == NULL)
{
this->CONSOLE_TEXT("Error : Code # %d - ScanForProgramInfo : GpNETWORKPROVIDER NULL",E_FAIL);
return E_FAIL;
}
CComQIPtr LpTUNER(this->GpNETWORKPROVIDER);

hr = LpTUNER->get_TuneRequest(&piTuneRequest);
if(FAILED(hr))
{
this->CONSOLE_TEXT("Error : Code # %d - ScanForProgramInfo : LpTUNER->get_TuneRequest(&piTuneRequest)",E_FAIL);
return hr;
}

CComPtr pILocator;
hr = piTuneRequest->get_Locator(&pILocator);
if(FAILED(hr))
{
this->CONSOLE_TEXT("Error : Code # %d - ScanForProgramInfo : piTuneRequest->get_Locator()",E_FAIL);
return hr;
}
hr = pILocator->get_CarrierFrequency(&iFrequency);//info.FREQ);
if(FAILED(hr))
{
this->CONSOLE_TEXT("Error : Code # %d - ScanForProgramInfo : pATSCLocator->get_CarrierFrequency(&iFrequency)",hr); //info.TSID)",hr);
return hr;
}
hr = pILocator->get_SignalStrength(&iSIGNAL);//info.FREQ);
if(FAILED(hr))
{
this->CONSOLE_TEXT("Error : Code # %d - ScanForProgramInfo : pATSCLocator->get_CarrierFrequency(&iFrequency)",hr); //info.TSID)",hr);
return hr;
}

return hr;
}

-----------------------------------------------------------------------------------------------
Fixed solusion:
1. In fact, We just want have a auto scan function, and some hardware card doesn't 100% support the DirectShow function.
2. We can used the get the TV Major and Minor to get the right data.
if Major is some number and Minor is some number, we get the frequence is "-1" if ATSC Card get the Signal. otherwise is very big number, like xxx245
3. Don't waster time to check the Lock, Singal,... The vaule is not 100 % can reliable.

HRESULT spb_IEHIPbdaTV::GetATSCChannel(long* lPhysicalChannel, long* lMajorChannel, long* lMinorChannel,long* iLOCKED, long* iSTRENGTH, long* iQUALITY, long* iSIGNAL,long* iFrequency )
{
HRESULT hr = S_OK;
ProgramINFO info;

if (this->GpNETWORKPROVIDER == NULL)
{
this->CONSOLE_TEXT("Error : Code # %d - ChangeChannel : GpNETWORKPROVIDER NULL",E_FAIL);
return E_FAIL;
}
CComQIPtr LpTUNER(this->GpNETWORKPROVIDER);
CComPtr pTuneRequestForGet;
hr = LpTUNER->get_TuneRequest(&pTuneRequestForGet);
if (FAILED (hr))
{
this->CONSOLE_TEXT("Error : Code # %d - ChangeChannel : Cannot submit tune request",hr);
return hr;
}
//query for an IATSCChannelTuneRequest interface pointer
CComQIPtr pATSCTuneRequest(pTuneRequestForGet);
// Set the initial major and minor channels
//long lGetReturnMajorChannel;
hr = pATSCTuneRequest->get_Channel(lMajorChannel); //&lGetReturnMajorChannel);
if(FAILED(hr))
{
return hr;
}
hr = pATSCTuneRequest->get_MinorChannel(lMinorChannel); //&lGetReturnMajorChannel);
if(FAILED(hr))
{
return hr;
}

CComPtr pILocator;
hr = pATSCTuneRequest->get_Locator(&pILocator);
if(FAILED(hr))
{
this->CONSOLE_TEXT("Error : Code # %d - ScanForProgramInfo : piTuneRequest->get_Locator()",E_FAIL);
return hr;
}
hr = pILocator->get_CarrierFrequency(iFrequency);
if(FAILED(hr))
{
this->CONSOLE_TEXT("Error : Code # %d - ScanForProgramInfo : pATSCLocator->get_CarrierFrequency(&info.TSID)",hr);
return hr;
}

CComQIPtr pATSCLocator(pILocator);
if (pATSCLocator!=NULL)
{
hr = pATSCLocator->get_TSID(&info.TSID);
if(FAILED(hr))
{
this->CONSOLE_TEXT("Error : Code # %d - ScanForProgramInfo : pATSCLocator->get_TSID(&info.TSID)",hr);
return hr;
}
// hr = pATSCLocator->get_Locator(&pILocator);
hr = pATSCLocator->get_PhysicalChannel(lPhysicalChannel); //&lGetReturnMajorChannel);
if(FAILED(hr))
{
return hr;
}

hr = pATSCTuneRequest->get_Channel(lMajorChannel);
if(FAILED(hr))
{
this->CONSOLE_TEXT("Error : Code # %d - ScanForProgramInfo : pATSCTuneRequest->get_Channel(&info.MajorChannel)",hr);
return hr;
}
hr = pATSCTuneRequest->get_MinorChannel(lMinorChannel);
if(FAILED(hr))
{
this->CONSOLE_TEXT("Error : Code # %d - ScanForProgramInfo : pATSCTuneRequest->get_MinorChannel(&info.MinorChannel",hr);
return hr;
}

}

return S_OK;
}

void CDVBT_VIDEOMATE::OnButton3() //Auto Scan Function.
{
HRESULT hr;
TCHAR tmp[256];
CString lcstmp1,lcstmp2,lcstmp3;
if (bdaTV->GpNETWORKPROVIDER == NULL)
{
this->CONSOLE_TEXT("*** Plugin File not loaded. Click LOAD PLUGIN. ***");;
return;
}

this->mTUNINGLIST.ResetContent();
long t_iPhy=1;
long t_iMajor=-1;
long t_iMinor=1;

// Open a Log file for write the Channels info.
CString TV_CStingCurTime;
static FILE *pLogFile;
static int isNewLog = TRUE;
pLogFile = fopen("C:\\ATSC.log", "w"); //a+");

// This loop is for Scan the ATSC Channels,
//
for (t_iPhy=2; t_iPhy<=158;t_iPhy++) { t_iMajor=-1; for (t_iMinor=-1;t_iMinor<=12;t_iMinor++) { lcstmp1.Format("%d",t_iPhy); lcstmp2.Format("%d",t_iMajor); lcstmp3.Format("%d",t_iMinor); hr = bdaTV->ChangeATSCChannel(atol(lcstmp1),atol(lcstmp2),atol(lcstmp3)); //change Channel data
if (hr != S_OK)
{
break;
}
long iLOCKED, iSIGNAL;
long iQUALITY, iSTRENGTH,iFrequency;
TCHAR tmp1[128],tmp2[128],tmp3[128],tmp4[128],tmp5[128];
iLOCKED=-2;
iSTRENGTH=-2;
iQUALITY=-2;
iSIGNAL=-2;
iFrequency=-2;
::Sleep(1000); // It is for ATSC Hardware card process time, // if rip if out, the ATSC Card get vaule will be wrong.
hr = bdaTV->GetATSCChannel(&t_iPhy,&amp;t_iMajor,&t_iMinor,&iLOCKED, &iSTRENGTH, &iQUALITY, &iSIGNAL, &amp;iFrequency );
if (t_iMajor!=-1)
{
lcstmp1.Format("%d",t_iPhy);
lcstmp2.Format("%d",t_iMajor);
lcstmp3.Format("%d",t_iMinor);
hr = bdaTV->ChangeATSCChannel(atol(lcstmp1),atol(lcstmp2),atol(lcstmp3)); //change Channel data
::Sleep(1000); // It is for ATSC Hardware card process time, // if rip if out, the ATSC Card get vaule will be wrong.
hr = bdaTV->GetATSCChannel(&t_iPhy,&amp;t_iMajor,&t_iMinor,&iLOCKED, &iSTRENGTH, &iQUALITY, &iSIGNAL, &amp;iFrequency );
}
lcstmp1.Format("%d",t_iPhy);
lcstmp2.Format("%d",t_iMajor);
lcstmp3.Format("%d",t_iMinor);
this->CONSOLE_TEXT("*** Current Channels: Phy:"+lcstmp1+" ,Major:"+lcstmp2+ ",Minor:"+lcstmp3 );
if
(iFrequency==-1 && t_iMajor!=-1 )
{
this->CONSOLE_TEXT("**** Working... ");
CString msgStr="Current Channels: Phy:"+lcstmp1+" , Major:"+lcstmp2+ ", Minor:"+lcstmp3;
// msgStr=msgStr+" "+tmp1+tmp2+tmp3+tmp4+tmp5;
// Write the Phy, Major, minor data to a File.
if (isNewLog)
{
fprintf(pLogFile, "Beginning of log session\n");
isNewLog = FALSE;
}
fprintf(pLogFile, "%s\n",msgStr.GetBuffer(0));
}else
{
this->CONSOLE_TEXT(" Not Working... ");
break;
}
}
}
// Close the Log file.
fclose(pLogFile);
this->CONSOLE_TEXT("*** Finish Auto Scan.." );
}