theSpoke.net

01.Blogs :

View Subscribers (0) | | Subscribe |

View as RSS news feed in XML

April 2004 - Posts

Simple Paging in ASP.NET
Tuesday, April 27, 2004 12:51 AM

Private m_Conn As clsConnection Private dd As SqlClient.SqlDataAdapter Private ds As DataSet Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Put user code to initialize the page here Me.m_Conn

Read More

posted by CCTING (Comments Off)

Parent Form - Child Form
Wednesday, April 21, 2004 9:26 AM

In Parent FormPrivate Sub btnCreateChildForm_Click()… Dim frm As New frmChildren frm.Owner = Me frm.Show() End Sub

Read More

posted by CCTING (Comments Off)

Automatically building SQL Query
Tuesday, April 13, 2004 1:52 AM

Automatically building SQL QuerySystem.Data.SqlClient.SqlCommandBuilder m = new System.Data.SqlClient.SqlCommandBuilder(this.sqlDataAdapter1); System.Windows.Forms.MessageBox.Show(m.GetInsertCommand().CommandText); System.Windows.Forms.MessageBox.Show(m.GetUpdateCommand().CommandText);

Read More

posted by CCTING (Comments Off)

Sick
Monday, April 12, 2004 5:21 AM

Today i am on leave.. not feeling well.. tomorrow i will publish a system tracker using Window Services..

Read More

posted by CCTING (Comments Off)

Window Service QuickStart
Friday, April 09, 2004 1:26 AM

Why do we need window services? We need it when we want to run an EXE without having to log in the system.1. Start a window services C#2. Protected Overrides Sub OnStart(ByVal args() As String) ' Add code here to start your service. This method should

Read More

posted by CCTING (Comments Off)

Distributed Cache - Dataset. What if cache capacity < capacity (dataset)?
Thursday, April 08, 2004 12:25 AM

If you need to manipulate data within the same database, it is better for you to have dataset (partial / database on local computer) for performance purpose (ignore comfounding factors / other factors.. :D)However, dataset needs memory. What if our pc

Read More

posted by CCTING (Comments Off)

ADO.NET dataset RowFilter
Wednesday, April 07, 2004 4:12 AM

Figure1: Original data from sqlDataAdapterFilter = LastName NOT LIKE 'B*'

Read More

posted by CCTING (Comments Off)

Delete a column from dataset
Tuesday, April 06, 2004 7:52 AM

MyDataView.Table.Columns.Remove("ColumnIWantToDelete")DataGrid1.dataSource = MyDataView

Read More

posted by CCTING (Comments Off)

Insert DataSet to existing Table
Tuesday, April 06, 2004 7:36 AM

Technical Skills (self-evaluation) for this article : 1/10 (too poor but still working!). Please suggest how to use SqlDataAdapter.InsertCommand... Dim f As System.Data.DataRow Dim ii As Integer Me.SqlConnection1.Open() For Each f In d.Tables(0).Rows

Read More

posted by CCTING (Comments Off)

Reading from Excel -ADO.NET
Tuesday, April 06, 2004 2:57 AM

Dim strConn As String = "Provider=Microsoft.Jet.OleDb.4.0;data source=d:\NameAndAddress.xls;Extended Properties=Excel 8.0;" Dim strSql As String = "Select * From Addresses" Dim a As New OleDb.OleDbConnection(strConn) Dim b As New OleDb.OleDbCommand(strSql,

Read More

posted by CCTING (Comments Off)

Hashtable (Performance)
Friday, April 02, 2004 12:39 AM

Hashtable is to arrange a set of keys in an array , which will improve the performance especially you need to access all those keys frequently.Hashtable a = new Hashtable();a.Add("Name", "Ting Choo Chiaw");a.Add("Age", "28");Console.WriteLine(a["Name"].ToString());Just

Read More

posted by CCTING (Comments Off)

sleep for 4 hours / day
Thursday, April 01, 2004 12:08 AM

:( recently i sleep only 4 hours / day. I can't even sleep well within these 4 hours because my housemates are playing game when i am sleeping :(((((

Read More

posted by CCTING (Comments Off)

03.UPDATE CALENDAR :

04.CATEGORIES :

06.Archives :

07.Subscriptions :

Subscriptions

© Copyright 2005 Microsoft Corporation. All Rights Reserved.

Terms of Use | Privacy Statement | Code of Conduct | Hosted by MaximumASP for Microsoft

WHO-BAR