1.建立一aspx页面，html代码2.cs代码
menggunakan Sistem.Data.SqlClient;
menggunakan Sistem.IO;
dilindungi kekosongan Page_Load (pengirim objek, EventArgs e)
{
jika (!Halaman.IsPostBack)
{
BindData();
}
jika (ID != "")
{
DapatkanDeskripsiOlehID(ID);
}
}
properti#properti wilayah
ID string pribadi
{
mendapatkan
{
if (Permintaan["ID"] != null && Permintaan["ID"].ToString() != "")
{
permintaan pengembalian["ID"];
}
kalau tidak
{
kembali "";
}
}
}
#endregion
GetDescriptionByID#region GetDescriptionByID
kekosongan pribadi GetDescriptionByID (ID string)
{
string connStr = ConfigurationSettings.AppSettings["ConnectionString"];
Sambungan SqlConnection = SqlConnection baru(sambunganStr);
string sql = "pilih * dari testimage dimana userid='" + ID + "'";
SqlCommand cmd = new SqlCommand(sql, samb.);
samb.Buka();
SqlDataReader dr = cmd.ExecuteReader();
string s = @"<table Cellspacing='0' cellpadding='4' width='300' height='200' border='0' id='GridView1' style='color:#333333;border-collapse:collapse ;'>";
jika(dr.Baca())
{
s += "<tr style='warna:#333333;warna latar:#FFFBD6;'>";
s += "<td width='50'>名称:</td>";
s += "<td>" + dr["Nama Pengguna"] + "</td>";
s+= "</tr>";
s += "<tr style='warna:#333333;warna latar:Putih;'>";
s += "<td scope='col'>描述:</td>";
s += "<td>" + dr["Deskripsi"] + "</td>";
s+= "</tr>";
}
s += "</tabel>";
dr.Tutup();
samb.Tutup();
this.Response.Write(s);
this.Respon.End();
}
#endregion
simpan gambar#wilayah simpan gambar
void yang dilindungi Button2_Click(pengirim objek, EventArgs e)
{
Streaming GambarStream;
string Path = FileUpload1.PostedFile.FileName;// 文件名称
int Ukuran = FileUpload1.PostedFile.ContentLength; // 文件大小
tipe string = FileUpload1.PostedFile.ContentType; // 文件类型
ImageStream = FileUpload1.PostedFile.InputStream;
byte[] Konten = byte baru[Ukuran];
int Status = ImageStream.Read(Isi, 0, Ukuran);
SqlConnection samb = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
SqlCommand comm = new SqlCommand("masukkan ke dalam testimage (UserName,Image,Path,Type,Description) nilai(@UserName,@Image,@Path,@Type,@Description)", samb);
comm.CommandType = CommandType.Teks;
comm.Parameters.Add("@UserName", SqlDbType.VarChar, 255).Value = txtUserName.Text;
comm.Parameters.Add("@Image", SqlDbType.Image).Value = Konten;
comm.Parameters.Add("@Path", SqlDbType.VarChar, 255).Nilai = Jalur;
comm.Parameters.Add("@Type", SqlDbType.VarChar, 255).Nilai = Tipe;
comm.Parameters.Add("@Description", SqlDbType.VarChar, 2000).Value = this.TextBox1.Text;
samb.Buka();
comm.ExecuteNonQuery();
samb.Tutup();
}
akhir
#Data Bindwilayah
kekosongan pribadi BindData()
{
string sql = "pilih * dari testimage";
Kumpulan Data ds = DapatkanDataSet(sql);
ini.DataList1.DataSource = ds;
ini.DataList1.DataBind();
}
#endregion
GetDataSet#region GetDataSet
Kumpulan Data pribadi GetDataSet(string sql)
{
string constring = Sistem.Konfigurasi.ConfigurationSettings.AppSettings["ConnectionString"];
SqlDataAdapter sda = baru SqlDataAdapter(sql, constring);
Kumpulan Data ds = Kumpulan Data baru();
sda.Isi(ds);
kembali ds;
}
#endregion3.数据库脚本
jika ada (pilih * dari dbo.sysobjects di mana id = object_id(N'[dbo].[TestImage]') dan OBJECTPROPERTY(id, N'IsUserTable') = 1)
letakkan tabel [dbo].[TestImage]
BUAT
TABEL [dbo].[TestImage] (
[UserID] [int] IDENTITAS (1, 1) BUKAN NULL ,
[Nama Pengguna] [nvarchar] (500) Susun Chinese_PRC_CI_AS NULL ,
[Gambar] [gambar] NULL,
[Jalur] [nvarchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
[Jenis] [nvarchar] (20) Susun SQL_Latin1_General_CP1_CI_AS NULL ,
[Deskripsi] [nvarchar] (2000) COLLATE Chinese_PRC_CI_AS NULL
) DI [UTAMA] TEXTIMAGE_ON [UTAMA]
PERGI
<html>
<kepala>
<title>Formulir Web1</title>
<style type="text/css">.logo }{}{ POSISI: absolut }.dek {}}{ Z-INDEX: 200; VISIBILITAS: tersembunyi; POSISI: }</style> mutlak
</kepala>
<tubuh>
<Formulir runat="server">
<DIV kelas="dek" id="dek"></DIV>
<skrip bahasa="javascript">
Xoffset=-20;
Yooffset= 20;
var nav,yyy=-1000;
var skn=dek.gaya;
dokumen.onmousemove=get_mouse;
//ajax
var xmlHttp;
fungsi buatXMLHttpRequest()
{
jika (jendela.ActiveXObject)
{
xmlHttp = new ActiveXObject("Microsoft.XMLHTTP");
}
lain jika (window.XMLHttpRequest)
{
xmlHttp = XMLHttpRequest baru();
}
}
fungsi startRequest(id)
{
buatXMLHttpRequest();
xmlHttp.onreadystatechange = handleStateChange;
xmlHttp.open("GET", "?ID="+id, benar);
xmlHttp.kirim(null);
}
konten var;
fungsi handleStateChange()
{
if(xmlHttp.readyState == 4)
{
if(xmlHttp.status == 200)
{
konten=xmlHttp.responseText;
}
}
}
//keterangan alat
fungsi popup (id)
{
startRequest(id);
yyy=Yoffset;
document.all("dek").innerHTML=isi;
skn.visibility="terlihat"
}
fungsi get_mouse(e)
{
var x=event.x+document.body.scrollLeft;
skn.kiri=x+Xoffset;
var y=acara.y+dokumen.tubuh.scrollTop;
skn.top=y+yyy;
}
fungsi mematikan()
{
yyy=-1000;
skn.visibility="tersembunyi";
}
</skrip>
<div>
<asp:FileUpload ID="FileUpload1" runat="server" /><br>名称:<asp:TextBox ID="txtUserName"
runat="server"></asp:KotakTeks><br>
alamat:<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br>
<asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="保存" />
<asp:DataList id="DataList1"
Warna Batas = "hitam"
Bantalan Sel = "1"
CellSpacing="4" HorizontalAlign="Tengah"
UlangiKolom = "4"
RepeatLayout="Tabel"
runat="server" ShowFooter="benar" ShowHeader="benar"
lebar="100%">
<Templat Barang>
<%# DataBinder.Eval(Container.DataItem, "Nama Pengguna")%><br>
<img ID="img1" onmouseover="popup(<%# DataBinder.Eval(Container.DataItem, "UserID")%>);" onmouseout="bunuh();" src='<%# DataBinder.Eval(Container.DataItem, "Jalur") %>' height='150'/>
</Templat Barang>
</asp:Daftar Data>
</div>
</Formulir>
</tubuh>
</html>