citan0896-CSDN博客

转载 To import data from excel to DB

Here,I introducesome methods to import data from excel to DB, 1 By OPENDATASOURCESELECT * FROM OPENDATASOURC...

2008-09-25 15:33:05 135

转载 To create user and maintain authorization

SAP authorization control systemTo create user1 Input T-code SU01, and then enter, and then input user name and c...

2008-09-09 10:59:46 107

转载 To create new Datatable

Tocreate new Datatable: private DataTable getTable(string client, string shipment, DataTable d) {...

2008-09-08 21:42:15 119

转载 Select all and Unselect all for ListView

Select all and Unselect all for ListView: private void btnSelect_Click(object sender, EventArgs e) {...

2008-09-08 21:30:40 175

转载 Useful Functions(2)

MessageBox.showif (MessageBox.Show(null, "Do You Want to Delete :" + LV.Items[i].SubItems[8].Text.Trim() + "' data...

2008-09-08 21:26:59 94

转载 To get text when ListView or GridView index changed

To get text when ListView or DataGrid index changed: private void LV_SelectedIndexChanged(object sender, Ev...

2008-09-08 21:14:51 88

转载 To add header and data for ListView

To add header and data for ListView: LV.Columns.Clear(); LV.Items.Clear();...

2008-09-08 21:11:32 84

转载 check all items

Select all and Unselect all for GridView:Background:protected void btnSelectAll_Click(object sender, EventArgs e...

2008-09-08 17:42:49 133

转载 To create ItemTemplate

To create ItemTemplate and get its value: BorderStyle="None" BorderWidth="1px...

2008-09-08 16:47:58 67

转载 ASPNET's useful function(2)

1 To create new page whenmany rows or data to be showed: protected void btnQuery_Click(object sender, Eve...

2008-09-08 16:31:12 76

转载 ASPNET's useful function(1)

1To addattribute to a button in Page_Load: protected void Page_Load(object sender, EventArgs e)...

2008-09-08 16:08:01 66

转载 Upload weight

How to get the true weight after goods was placed on a scale? private void Mscom_Initial() {...

2008-09-06 22:44:31 133

转载 To print label

To print label with the control named AxInterop.MSCommLib,Interop.MSCommLibinitial comm port try...

2008-09-06 22:36:35 164

转载 SQLHelper

SQLHelper offers some common function to operate DBusing System.Configuration;using System.Data;using System.Data....

2008-09-06 22:22:01 55

转载 Useful Functions(1)

How to catch UserName and Version? How to play audio file from special folder? You can benefit from blowcode.To g...

2008-09-06 22:01:57 122

转载 Common function of Read-write file

We often read or write a file(.txt, .xls etc.), and we can achieve it through following common class.using System;...

2008-09-05 23:13:20 87

转载 How to send mail automatically

Sometimes, it's convenient to do some tasks through background job. In other words, through Scheduled Tasks. If yo...

2008-09-05 22:34:33 172

转载 How to get the length of a string

If the length of an English character is 1, and Chinese character is 2, how to get the length of a string includin...

2008-09-05 12:31:48 163

转载 How to catch SQL Statement's information quickly

You can fetch all information about SQL Statement with below SQL scirpt. Then you can analyze and improve script ...

2008-09-05 10:51:12 81

citan0896的博客