2008-3-10 8:09:45 阅读17 评论2 102008/03 Mar10
2008-10-9 14:56:28 阅读48 评论0 92008/10 Oct9
--创建链接服务器
exec sp_addlinkedserver 'srv_lnk','','SQLOLEDB','远程服务器名或ip地址'
exec sp_addlinkedsrvlogin 'srv_lnk','false',null,'用户名','密码'
go
--查询示例
select * from srv_lnk.数据库名.dbo.表名
--导入示例
select * into 表 from srv_lnk.数据库名.dbo.表名
--以后不再使用时删除链接服务器
exec sp_dropserver 'srv_lnk','droplogins'
2008-10-1 10:21:43 阅读28 评论0 12008/10 Oct1
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="EventTask.aspx.cs" Inherits="EventTask" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml
2008-10-1 10:20:46 阅读19 评论0 12008/10 Oct1
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="SysNet.aspx.cs" Inherits="SysNet" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml
2008-9-14 16:07:58 阅读9 评论0 142008/09 Sept14
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default5.aspx.cs" Inherits="Default5" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml
2008-7-22 15:46:36 阅读148 评论1 222008/07 July22
前台没有什么代码,只要托一个reportview即可,对于后台,代码如下:
protected void Page_Load(object sender, EventArgs e)
{
this.ReportViewer1.LocalReport.ReportPath = Server.MapPath("r1.rdlc");
DsTableAdapters.cuTableAdapter adapter1 = new DsTableAdapters.cuTableAdapter();
2008-7-22 11:00:27 阅读45 评论0 222008/07 July22
2008-7-14 14:06:23 阅读19 评论0 142008/07 July14
protected void Button1_Click(object sender, EventArgs e)
{
byte[] b = this.FileUpload1.FileBytes;
string name = this.FileUpload1.FileName;
string sql = "insert into Content (name,content) values (@name,@content)";