</center>
</form>
</body>
</html>
------------------
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Configuration;
using System.Data.SqlClient; //这句不能少;否则不能那样连接数据库。呵呵!
namespace scm
{
public class vendor_start : System.Web.UI.Page
{
public DataGrid MyList,MyList2;
protected System.Web.UI.WebControls.Label label1,label2;
public static int CalculateQRecord(string s)
{
try
{
DataRow dr=GetDataRow(s,"ballot");
return System.Convert.ToInt32(dr["sum1"].ToString());
}
catch
{
return 0;
}
}
SqlCommand myCommand2=new SqlCommand("SELECT sum(ballot_num) as sum1 FROM ballot",NewConn);
label2.Text = CalculateQRecord("SELECT sum(ballot_num) as sum1 FROM ballot").ToString(); //方法一
NewConn.Open();
//label1.Text=""+myCommand2.ExecuteScalar(); //方法二
SqlDataAdapter myCommand=new SqlDataAdapter("SELECT (ballot_num/(SELECT sum(ballot_num) as sum1 FROM ballot))*100 as sum2,ballot_id,ballot_name,ballot_num FROM ballot",NewConn);
DataSet ds = new DataSet();
myCommand.Fill(ds, "ballot");
return ds.Tables["ballot"].DefaultView;
<%@ Page Language="VB"%>
<script runat="server">
Sub Enter_Click(Sender As Object, E As EventArgs)
myimage.ImageUrl="showimage.aspx?thenumber=" & thenumber.Text
myimage.Visible=True
End Sub
</script>
<%@ Import Namespace="System.IO"%>
<%@ Import Namespace="System.Drawing"%>
<%@ Import Namespace="System.Drawing.Imaging"%>
<Script Language="VB" Runat="Server">
Sub Page_Load(Sender As Object,E as Eventargs)
'获取传过来的数字字符串,注意本例规定必须是4个数字组成的字符串
Dim numTemp As String =Request.QueryString("theNumber")
'下面一段其实是建立一个空白的点阵图像,然后等待下面将数字图像填充到该空白图片中******************
'建立点阵图像对象实例,也就是建立一个空白的图像,3个参数依次为图像的宽、高和图片格式
Dim bmp As New Bitmap(70,25,PixelFormat.Format24bppRgb)
'建立一个Graphics图像对象,并载入刚刚建立的bmp点阵对象实例
Dim grh As Graphics = Graphics.FromImage(bmp)
'下面一段其实是根据数字读取相应的数字图片,并将其填充到上面建立的空白图片中********************
'下面逐个读取4张图片,并将其添加到上面建立的grh对象中
Dim img As System.Drawing.Image
Dim I As Integer,picPath As String
For I=1 To 4
'根据数字获取对应的图片物理路径
picPath=Server.Mappath("images/" & Mid(numTemp,I,1) & ".gif")
'读取该图片到Image对象中
img=System.Drawing.Image.FromFile(picPath)
'将该图像输出到图片的指定位置,Point有两个参数,分别是图像距左边和上边的距离
grh.DrawImage(img,New Point(3+Img.Width*(I-1),3))
Next
'将声成图片以Jpeg格式保存到输出流中,也就是会显示在页面上
bmp.Save(Response.OutputStream,System.Drawing.Imaging.ImageFormat.Jpeg)
End Sub
</Script>