可以将此模板加在dedecms上,这个需要修改一下html文件,将相关信息替换为dede的标签调用。具体操作可以网上搜一下dedecms添加模板和dedecms仿站教程。
求VB,NET 2008 源代码或图文视频教程
这里黏贴出代码,同时把文件发送到你那儿:
1)首先创建脚本,便于您调试数据模拟:
--自动生成表,测试使用
use master
if exists (select [name] from sysdatabases where [name]='db_test')
drop database db_test
go
create database db_test
go
use db_test
create table tb_test
(
id int primary key identity(1,1),
oper varchar(max),
workpone varchar(10)
)
--Insert several data
declare @i int
set @i=1
while(@i<101)
begin
insert into tb_test(oper,workpone)values('Oper'+CONVERT(varchar(3),@i),convert(varchar(3),@i))
set @i=@i+1
end
放入SQL2005或者2008中,F5运行即可。
2)以下是代码片段:
i)MainForm窗体:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
namespace DBDemo
{
public partial class MainForm : Form
{
public MainForm()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'db_testDataSet.tb_test' table. You can move, or remove it, as needed.
this.tb_testTableAdapter.Fill(this.db_testDataSet.tb_test);
}
private void searchingToolStripButton_Click(object sender, EventArgs e)
{
try
{
this.tb_testTableAdapter.Searching(this.db_testDataSet.tb_test, operToolStripTextBox.Text, workponeToolStripTextBox.Text);
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
private void 添加新项AToolStripMenuItem_Click(object sender, EventArgs e)
{
FormInsert fi = new FormInsert();
fi.DataSet = db_testDataSet;
fi.AdapterSet = tb_testTableAdapter;
fi.ShowDialog();
}
private void 删除当前项DToolStripMenuItem_Click(object sender, EventArgs e)
{
//判断是否有选中的行或者列
if (dataGridView1.Rows.Count>0 && dataGridView1.SelectedCells!=null)
{
int index = dataGridView1.SelectedCells[0].RowIndex;
int key = (int)dataGridView1.Rows[index].Cells[0].Value;
string workp = dataGridView1.Rows[index].Cells[2].Value.ToString();
tb_testTableAdapter.Delete(key, workp);
MessageBox.Show(删除成功!);
this.tb_testTableAdapter.Fill(this.db_testDataSet.tb_test);
}
}
}
}
ii)FormInsert代码:
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
namespace DBDemo
{
public partial class MainForm : Form
{
public MainForm()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'db_testDataSet.tb_test' table. You can move, or remove it, as needed.
this.tb_testTableAdapter.Fill(this.db_testDataSet.tb_test);
}
private void searchingToolStripButton_Click(object sender, EventArgs e)
{
try
{
this.tb_testTableAdapter.Searching(this.db_testDataSet.tb_test, operToolStripTextBox.Text, workponeToolStripTextBox.Text);
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
private void 添加新项AToolStripMenuItem_Click(object sender, EventArgs e)
{
FormInsert fi = new FormInsert();
fi.DataSet = db_testDataSet;
fi.AdapterSet = tb_testTableAdapter;
fi.ShowDialog();
}
private void 删除当前项DToolStripMenuItem_Click(object sender, EventArgs e)
{
//判断是否有选中的行或者列
if (dataGridView1.Rows.Count>0 && dataGridView1.SelectedCells!=null)
{
int index = dataGridView1.SelectedCells[0].RowIndex;
int key = (int)dataGridView1.Rows[index].Cells[0].Value;
string workp = dataGridView1.Rows[index].Cells[2].Value.ToString();
tb_testTableAdapter.Delete(key, workp);
MessageBox.Show(删除成功!);
this.tb_testTableAdapter.Fill(this.db_testDataSet.tb_test);
}
}
private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
//双击某个单元格(主键除外,修改)
tb_testTableAdapter.Update(db_testDataSet.tb_test);
tb_testTableAdapter.Fill(db_testDataSet.tb_test);
}
}
}