c863123的专栏

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Drawing.Printing;using System.Text;using System.Windows.Forms;namespace

SaveFileDialog saveFileDialog = new SaveFileDialog();            saveFileDialog.Filter = "Execl   files   (*.xls) |*.xls ";            saveFileDialog.FilterIndex = 0;            saveFileDialog.Restore

插入（insert into ）存储过程为：CREATE PROCEDURE [mypro]@code varchar(50),@type varchar(50),@name varchar(50)AS insert into prm values (@code,@type,@name)GO在C#中：           try            {               

在C#中运用SQLDMO备份和恢复Microsoft SQL Server数据库SQLDMO(SQL Distributed Management Objects，SQL分布式管理对象)封装了Microsoft SQL Server数据库中的对象。SQLDMO是Microsoft SQL Server中企业管理器所使用的应用程序接口，所以它可以执行很多功能，其中当然也包括对数据库的备份和恢复。

SqlConnection conn = null;SqlTransaction trans = null;try {   conn = new SqlConnection("");//连库，略  SqlCommand cmd = new SqlCommand("INSERT INTO test(title) VALUES ("+txtTitle.Text+")",conn);   trans