C#笔记（内容源于互联网）

*****载入等待图标（起始语句，结束语句）

Cursor.Current=Cursors.WaitCursor

Cursor.Current=Cursors.Default

*****判断列表是否选中一条记录

if(listView1.SelectedIndices.Count!=1)return;

*****取出列表中选中的一条记录

listView1.Items[listView1.SelectedIndices[0]].Tag

*****向列表中加入记录

ListViewItem i = new ListViewItem();

i.Text="第一列参数";

i.SubItems.Add("第二列参数");

i.SubItems.Add("第三列参数)";

listView1.Items.Add(i);

*****弹出提示是否要删除的询问框

if(MessageBox.Show("删除","是否删除？",MessageBoxButtons.YesNo,MessageBoxDefaultButton.Button1).Equals(DialogResult.No))return;

*****SQLite操作数据库

addDate(Date date)

{

string sql=@"insert into datebase(id,name) values(@id,@name)";

SQLiteCommand cmd = new SQLiteCommand(sql);

cmd.Parameters.AddWithValue("id",date.id);
cmd.Parameters.AddWithValue("name",date.name);

SQLiteConnection connection ;

connection=new SQLiteConnection("Data Source=数据库文件地址;Version=3;");

cmd.Connection=connection;

cmd.ExecuteNonQuery();

}

deleteDate(Date date)

{

string sql="delete from datebase where id = @id";

SQLiteCommand cmd =new SQLiteCommand(sql);

cmd.Parameters.AddWithValue("id",date.id);

SQLiteConnection connection ;

connection=new SQLiteConnection("Data Source=数据库文件地址;Version=3;");

cmd.Connection=connection;

cmd.ExecuteNonQuery();

}

List<Date>getDate(string condition)

{

List<Date> date=new List<Date>();

string where = condition.Length>0 ?" where "+condition : " ";

string sql="select * from datebase "+where;

SQLiteCommand cmd = new SQLiteCommand(sql);

SQLiteConnection connection ;

connection=new SQLiteConnection("Data Source=数据库文件地址;Version=3;");

cmd.Connection=connection;

SQLiteDataReader reader=cmd.ExecuteReader();

while(reader.Read())

{

Date dateOne=new Date();

if(!reader.GetValue(reader.GetOrdinal("id")).ToString().Equals(""))dateOne.id=reader.GetString(reader.GetOrdinal("id"));

dateOne.name=reader.GetString(reader.GetOrdinal("name"));

date.Add(dateOne);

}

reader.Close();

return date;

}

cmd.Parameters.AddWithValue("id",date.id);

*****快捷键

Ctrl+E+D 整理代码格式
Tab 右移
Shift+Tab 左移