Ajax实现DataGrid/DataList动态ToolTip

最新推荐文章于 2021-08-06 09:51:16 发布

iteye_11848

最新推荐文章于 2021-08-06 09:51:16 发布

阅读量103

点赞数

文章标签： Ajax SQL SQL Server JavaScript CSS ViewUI

本文介绍了一个ASP.NET应用程序的实现细节，包括如何通过页面上传图片并将其保存到数据库，同时从数据库中检索图片信息进行展示。代码示例涵盖了图片上传、数据库交互以及数据显示等关键环节。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.建立一aspx页面，html代码2.cs代码

usingSystem.Data.SqlClient;

usingSystem.IO;

protectedvoidPage_Load(objectsender,EventArgse)

{

if(!Page.IsPostBack)

{

BindData();

}

if(ID!="")

{

GetDescriptionByID(ID);

}

property#regionproperty

privatestringID

{

get

{

if(Request["ID"]!=null&&Request["ID"].ToString()!="")

{

returnRequest["ID"];

}

else

{

return"";

}

#endregion

GetDescriptionByID#regionGetDescriptionByID

privatevoidGetDescriptionByID(stringID)

{

stringconnStr=ConfigurationSettings.AppSettings["ConnectionString"];

SqlConnectionconn=newSqlConnection(connStr);

stringsql="select*fromtestimagewhereuserid='"+ID+"'";

SqlCommandcmd=newSqlCommand(sql,conn);

conn.Open();

SqlDataReaderdr=cmd.ExecuteReader();

strings=@"<tablecellspacing='0'cellpadding='4'width='300'height='200'border='0'id='GridView1'style='color:#333333;border-collapse:collapse;'>";

if(dr.Read())

{

s+="<trstyle='color:#333333;background-color:#FFFBD6;'>";

s+="<tdwidth='50'>名称:</td>";

s+="<td>"+dr["UserName"]+"</td>";

s+="</tr>";

s+="<trstyle='color:#333333;background-color:White;'>";

s+="<tdscope='col'>描述:</td>";

s+="<td>"+dr["Description"]+"</td>";

s+="</tr>";

}

s+="</table>";

dr.Close();

conn.Close();

this.Response.Write(s);

this.Response.End();

}

#endregion

saveimage#regionsaveimage

protectedvoidButton2_Click(objectsender,EventArgse)

{

StreamImageStream;

stringPath=FileUpload1.PostedFile.FileName;//文件名称

intSize=FileUpload1.PostedFile.ContentLength;//文件大小

stringType=FileUpload1.PostedFile.ContentType;//文件类型

ImageStream=FileUpload1.PostedFile.InputStream;

byte[]Content=newbyte[Size];

intStatus=ImageStream.Read(Content,0,Size);

SqlConnectionconn=newSqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);

SqlCommandcomm=newSqlCommand("insertintotestimage(UserName,Image,Path,Type,Description)values(@UserName,@Image,@Path,@Type,@Description)",conn);

comm.CommandType=CommandType.Text;

comm.Parameters.Add("@UserName",SqlDbType.VarChar,255).Value=txtUserName.Text;

comm.Parameters.Add("@Image",SqlDbType.Image).Value=Content;

comm.Parameters.Add("@Path",SqlDbType.VarChar,255).Value=Path;

comm.Parameters.Add("@Type",SqlDbType.VarChar,255).Value=Type;

comm.Parameters.Add("@Description",SqlDbType.VarChar,2000).Value=this.TextBox1.Text;

conn.Open();

comm.ExecuteNonQuery();

conn.Close();

}

#endregion

BindData#regionBindData

privatevoidBindData()

{

stringsql="select*fromtestimage";

DataSetds=GetDataSet(sql);

this.DataList1.DataSource=ds;

this.DataList1.DataBind();

}

#endregion

GetDataSet#regionGetDataSet

privateDataSetGetDataSet(stringsql)

{

stringconstring=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];

SqlDataAdaptersda=newSqlDataAdapter(sql,constring);

DataSetds=newDataSet();

sda.Fill(ds);

returnds;

}

#endregion

3.数据库脚本

ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[TestImage]')andOBJECTPROPERTY(id,N'IsUserTable')=1)

droptable[dbo].[TestImage]

CREATETABLE[dbo].[TestImage](

[UserID][int]IDENTITY(1,1)NOTNULL,

[UserName][nvarchar](500)COLLATEChinese_PRC_CI_ASNULL,

[Image][image]NULL,

[Path][nvarchar](500)COLLATEChinese_PRC_CI_ASNULL,

[Type][nvarchar](20)COLLATESQL_Latin1_General_CP1_CI_ASNULL,

[Description][nvarchar](2000)COLLATEChinese_PRC_CI_ASNULL

)ON[PRIMARY]TEXTIMAGE_ON[PRIMARY]

<html>

<head>

<title>WebForm1</title>

<styletype="text/css">

.logo{

}{POSITION:absolute}.dek{

}{Z-INDEX:200;VISIBILITY:hidden;POSITION:absolute}</style>

</head>

<body>

<Formrunat="server">

<DIVclass="dek"id="dek"></DIV>

<scriptlanguage="javascript">

Xoffset=-20;

Yoffset=20;

varnav,yyy=-1000;

varskn=dek.style;

document.onmousemove=get_mouse;

//ajax

varxmlHttp;

functioncreateXMLHttpRequest()

{

if(window.ActiveXObject)

{

xmlHttp=newActiveXObject("Microsoft.XMLHTTP");

}

elseif(window.XMLHttpRequest)

{

xmlHttp=newXMLHttpRequest();

}

functionstartRequest(id)

{

createXMLHttpRequest();

xmlHttp.onreadystatechange=handleStateChange;

xmlHttp.open("GET","?ID="+id,true);

xmlHttp.send(null);

}

varcontent;

functionhandleStateChange()

{

if(xmlHttp.readyState==4)

{

if(xmlHttp.status==200)

{

content