只有管理员才能查看数据和报告的创建报告 [英] Creating a Report of the data and the report should be viewed by only admin
本文介绍了只有管理员才能查看数据和报告的创建报告的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
<％@ Page 语言 = C＃ AutoEventWireup = true CodeFile = YKTCReport.aspx.cs 继承 = YKTCReport ％>
< ！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 >
< head runat = server >
< ; title > < / title >
< style type = text / css >
。 style1
{ height ： 41px;
}
。 style2
{
width ： 241px;
}
。 style3
{
height ： 79px;
}
< / 风格 >
< / head >
< body style = height：384px; width：891px >
< 表单 id = form1 runat < span class =code-keyword> = server >
< div >
< 表 style = width：515px;高度：330px >
< tr >
< td align = center class = style2 > 咖啡< span class =code-keyword>< / td >
< td align = center > Tea < / td >
< / tr < span class =code-keyword>>
< tr >
< td class = style2 > < / td >
< td > < / td >
< / tr >
< tr >
< < span class =code-leadattribute> td class = style2 > < / td >
< td > < / td >
< / tr >
< tr >
< td 类 = style2 > ; < / td >
< td > < / td >
< / tr >
< tr >
< td class = style2 > < / td >
< td > < / td >
< / tr >
< tr >
< td class = style2 > < / td >
< td > < / td >
< / tr >
< tr >
< ; td class = style2 > < / td >
< td > < / td >
< / tr >
< tr >
< span class =code-keyword>< td class = style2 > < / td >
< td > < / td >
< / tr >
< tr >
< td class = style2 > < / td >
< td > < / td >
< / tr >
< tr >
< td class = style2 > < / td >
< ; td > < / td >
< / tr >
< tr >
< td align = center class = style1 colspan = 2 > 数字
咖啡
< asp：标签 ID = Label1 runat = server 文字 = 标签 >
< / td >
< / tr >
< tr >
< td align = center class = style3 colspan = 2 > 茶数
< asp：标签 ID = Label2 runat = server 文字 = 标签 >
< br / > ;
< asp：按钮 ID = Button1 runat = server style = font-weight：700 文本 = 短信
onclick = Button1_Click / >
< / td >
< / tr >
< / table >
< / div >
< / form >
< / body >
< / html > >
从以下非解决方案复制的其他信息
使用系统;
使用 System.Collections.Generic;
使用 System.Linq;
使用 System.Web;
使用 System.Web.UI;
使用 System.Web.UI.WebControls;
使用 System.Data.SqlClient;
使用 System.Data;
public partial class YKTCTWelcome：System.Web.UI.Page
{
protected void Page_Load（ object sender，EventArgs e）
{
SqlConnection con = new SqlConnection（ @ 数据源=。;初始目录= YKTCoffeeTea; uid = sa; pwd = sql ）;
SqlCommand cmd = new SqlCommand（）;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = URegis;
if （Convert.ToString（RadioButtonList1.SelectedValue）== C）
{
cmd.Parameters.Add（ @Coffee，SqlDbType.Bit）.Value = true ;
cmd.Parameters.Add（ @ Tea，SqlDbType.Bit）.Value = false ;
}
else
{
cmd.Parameters.Add（ @ Tea，SqlDbType.Bit）.Value = false ;
cmd.Parameters.Add（ @ Coffee，SqlDbType.Bit）.Value = false ;
}
// cmd.Parameters.Add（@ Coffee，SqlDbType.Bit） .Value = RadioButtonList1.Text.Trim（）;
// cmd.Parameters.Add （@ Tea，SqlDbType.Bit）.Value = RadioButtonList1.Text.Trim（）;
// cmd.Parameters.Add（@ Date，SqlDbType.VarChar）.Value = Button1.Text.Trim（）;
cmd.Connection = con;
con.Open（）;
cmd.ExecuteNonQuery（）;
con.Close（）;
// RequiredFieldValidator1 .Text =已成功保存;
// RadioButtonList1.Text =;
// RadioButtonList1.Text =;
// Button1.Text =;
// }
// private void SqlConnection（string p）
// {
// 抛出新的NotImplementedException（）;
// }
// protected void Button1_Click（object sender，EventArgs e）
// {
if （RadioButtonList1.SelectedValue！= ）
{
Label4.Text = Thanx For Your Confirmation ;
}
else
{
Label4.Text = 选择咖啡或茶;
}
}
受保护 void Button2_Click（ object sender，EventArgs e）
{
}
protected < span class =code-keyword> void Button1_Click（ object sender，EventArgs e）
{
}使用System;
使用System.Collections.Generic;
使用System.Linq;
使用System.Web;
使用System.Web.UI;
使用System.Web .UI.WebControls;
使用System.Data.SqlClient;
使用System.Data;
public部分类YKTCTWelcome：System.Web.UI.Page
{
protected void Page_Load（object sender，EventArgs e）
{
SqlConnection con = new SqlConnection（@Data Source = .; Init ial catalog = YKTCoffeeTea; uid = sa; pwd = sql）;
SqlCommand cmd = new SqlCommand（）;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText =URegis;
if（Convert.ToString（RadioButtonList1.SelectedValue）==C）
{
cmd.Parameters.Add（@ Coffee，SqlDbType.Bit）.Value = true;
cmd.Parameters.Add（@ Tea，SqlDbType.Bit）.Value = false;
}
else
{
cmd.Parameters.Add（@ Tea，SqlDbType。 Bit）.Value = false;
cmd.Parameters.Add（@ Coffee，SqlDbType.Bit）.Value = false;
}
//cmd.Parameters.Add(\"@Coffee，SqlDbType.Bit）.Value = RadioButtonList1.Text.Trim（）;
//cmd.Parameters.Add(\"@Tea ，SqlDbType.Bit）.Value = RadioButtonList1.Text.Trim（）;
//cmd.Parameters.Add(\"@Date，SqlDbType.VarChar）.Valu e = Button1.Text.Trim（）;
cmd.Connection = con;
con.Open（）;
cmd.ExecuteNonQuery（）;
con.Close（）;
// RequiredFieldValidator1 .Text =成功保存;
//RadioButtonList1.Text =;
//RadioButtonList1.Text =;
//Button1.Text =;
//}
// private void SqlConnection （字符串p）
// {
//抛出新的NotImplementedException（）;
//}
// protected void Button1_Click（object sender，EventArgs e）
// {
if（RadioButtonList1.SelectedValue！=）
{
Label4.Text =Thanx For Your Confirmation;
}
{
Label4.Text =选择咖啡或茶;
}
}
protected void Button2_Click（对象发送者，Eve） ntArgs e）
{
}
protected void Button1_Click（object sender，EventArgs e）
{
}
}
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="YKTCReport.aspx.cs" Inherits="YKTCReport" %>
<!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">
<head runat="server">
<title></title>
<style type="text/css">
.style1
{ height: 41px;
}
.style2
{
width: 241px;
}
.style3
{
height: 79px;
}
</style>
</head>
<body style="height: 384px; width: 891px">
<form id="form1" runat="server">
<div>
<table style="width: 515px; height: 330px">
<tr>
<td align="center" class="style2">Coffee</td>
<td align="center">Tea</td>
</tr>
<tr>
<td class="style2"></td>
<td> </td>
</tr>
<tr>
<td class="style2"></td>
<td> </td>
</tr>
<tr>
<td class="style2"></td>
<td> </td>
</tr>
<tr>
<td class="style2"></td>
<td> </td>
</tr>
<tr>
<td class="style2"></td>
<td> </td>
</tr>
<tr>
<td class="style2"></td>
<td> </td>
</tr>
<tr>
<td class="style2"></td>
<td> </td>
</tr>
<tr>
<td class="style2"></td>
<td> </td>
</tr>
<tr>
<td class="style2"></td>
<td> </td>
</tr>
<tr>
<td align="center" class="style1" colspan="2"> Number
Of Coffee
<asp:Label ID="Label1" runat="server" Text="Label">
</td>
</tr>
<tr>
<td align="center" class="style3" colspan="2">Number Of Tea
<asp:Label ID="Label2" runat="server" Text="Label">
<br />
<asp:Button ID="Button1" runat="server" style="font-weight: 700" Text="SMS"
onclick="Button1_Click" />
</td>
</tr>
</table>
</div>
</form>
</body>
</html>>
additional information copied from non-solution below
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
public partial class YKTCTWelcome : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=.;Initial catalog=YKTCoffeeTea;uid=sa;pwd=sql");
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "URegis";
if (Convert.ToString(RadioButtonList1.SelectedValue) == "C")
{
cmd.Parameters.Add("@Coffee", SqlDbType.Bit).Value = true;
cmd.Parameters.Add("@Tea", SqlDbType.Bit).Value = false;
}
else
{
cmd.Parameters.Add("@Tea", SqlDbType.Bit).Value = false;
cmd.Parameters.Add("@Coffee", SqlDbType.Bit).Value = false;
}
//cmd.Parameters.Add("@Coffee", SqlDbType.Bit).Value = RadioButtonList1.Text.Trim();
//cmd.Parameters.Add("@Tea", SqlDbType.Bit).Value = RadioButtonList1.Text.Trim();
//cmd.Parameters.Add("@Date", SqlDbType.VarChar).Value = Button1.Text.Trim();
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
//RequiredFieldValidator1 .Text = "Saved Sucessfully";
//RadioButtonList1.Text = "";
//RadioButtonList1.Text = "";
//Button1.Text = "";
//}
//private void SqlConnection(string p)
//{
//throw new NotImplementedException();
//}
//protected void Button1_Click(object sender, EventArgs e)
//{
if (RadioButtonList1.SelectedValue != "")
{
Label4.Text = "Thanx For Your Confirmation";
}
else
{
Label4.Text = "Select Coffee or Tea";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
}
}
解决方案 using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
public partial class YKTCTWelcome : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=.;Initial catalog=YKTCoffeeTea;uid=sa;pwd=sql");
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "URegis";
if (Convert.ToString(RadioButtonList1.SelectedValue) == "C")
{
cmd.Parameters.Add("@Coffee", SqlDbType.Bit).Value = true;
cmd.Parameters.Add("@Tea", SqlDbType.Bit).Value = false;
}
else
{
cmd.Parameters.Add("@Tea", SqlDbType.Bit).Value = false;
cmd.Parameters.Add("@Coffee", SqlDbType.Bit).Value = false;
}
//cmd.Parameters.Add("@Coffee", SqlDbType.Bit).Value = RadioButtonList1.Text.Trim();
//cmd.Parameters.Add("@Tea", SqlDbType.Bit).Value = RadioButtonList1.Text.Trim();
//cmd.Parameters.Add("@Date", SqlDbType.VarChar).Value = Button1.Text.Trim();
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
//RequiredFieldValidator1 .Text = "Saved Sucessfully";
//RadioButtonList1.Text = "";
//RadioButtonList1.Text = "";
//Button1.Text = "";
//}
//private void SqlConnection(string p)
//{
//throw new NotImplementedException();
//}
//protected void Button1_Click(object sender, EventArgs e)
//{
if (RadioButtonList1.SelectedValue != "")
{
Label4.Text = "Thanx For Your Confirmation";
}
else
{
Label4.Text = "Select Coffee or Tea";
}
}
protected void Button2_Click(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
}
}
这篇关于只有管理员才能查看数据和报告的创建报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
