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.Data.SqlClient;namespace Admin
{
/// <summary>
/// WebForm1 的摘要说明。
/// </summary>
public class Send : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label lblMessage;
protected System.Web.UI.WebControls.Label lblMessage2;
protected System.Web.UI.WebControls.TextBox txtName;
protected System.Web.UI.WebControls.TextBox txtContent;
protected System.Web.UI.WebControls.Button btnOk;
protected System.Web.UI.WebControls.Button btnCancel; private SqlConnection conn ;
private SqlCommand comm;
private SqlDataAdapter dpt;
private DataSet DSPageData;
private string strSQL;
private string strConn;
protected void btnOk_Click(object serder,EventArgs e)
{
string strContent = txtContent.Text.Trim();
string strName = txtName.Text.Trim();
if (strContent.Length > 70)
{
Response.Write("<script>alert('发送内容长度不能多于70字!');</script>");
return;
}
strConn=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
conn = new SqlConnection(strConn);
conn.Open();
comm = new SqlCommand("sp_9120006_SendMsg",conn);
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add("@name",SqlDbType.VarChar,20);
comm.Parameters.Add("@message",SqlDbType.VarChar,140);
comm.Parameters["@name"].Value =strName;
comm.Parameters["@message"].Value =strContent;
try
{
comm.ExecuteNonQuery();
Response.Write("<script>alert('短信群发已成功完成!');</script>");
}
catch(Exception E)
{
Response.Write("<script>alert(E.Message);</script>");
}
conn.Close();
}
protected void btnCancel_Click(object serder,EventArgs e)
{
txtName.Text = "";
txtContent.Text = "";
}
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化
if(Convert.ToString(Session["uid"])==string.Empty)
Response.Redirect("default.aspx");
if(!Page.IsPostBack)
{
}
}
}
}
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.Data.SqlClient;namespace Admin
{
/// <summary>
/// WebForm1 的摘要说明。
/// </summary>
public class Send : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label lblMessage;
protected System.Web.UI.WebControls.Label lblMessage2;
protected System.Web.UI.WebControls.TextBox txtName;
protected System.Web.UI.WebControls.TextBox txtContent;
protected System.Web.UI.WebControls.Button btnOk;
protected System.Web.UI.WebControls.Button btnCancel; private SqlConnection conn ;
private SqlCommand comm;
private SqlDataAdapter dpt;
private DataSet DSPageData;
private string strSQL;
private string strConn;
protected void btnOk_Click(object serder,EventArgs e)
{
string strContent = txtContent.Text.Trim();
string strName = txtName.Text.Trim();
if (strContent.Length > 70)
{
Response.Write("<script>alert('发送内容长度不能多于70字!');</script>");
return;
}
strConn=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
conn = new SqlConnection(strConn);
conn.Open();
comm = new SqlCommand("sp_9120006_SendMsg",conn);
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add("@name",SqlDbType.VarChar,20);
comm.Parameters.Add("@message",SqlDbType.VarChar,140);
comm.Parameters["@name"].Value =strName;
comm.Parameters["@message"].Value =strContent;
try
{
comm.ExecuteNonQuery();
Response.Write("<script>alert('短信群发已成功完成!');</script>");
}
catch(Exception E)
{
Response.Write("<script>alert(E.Message);</script>");
}
conn.Close();
}
protected void btnCancel_Click(object serder,EventArgs e)
{
txtName.Text = "";
txtContent.Text = "";
}
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化
if(Convert.ToString(Session["uid"])==string.Empty)
Response.Redirect("default.aspx");
if(!Page.IsPostBack)
{
}
}
}
}
解决方案 »
- 不同服务器上的数据库,表之间数据同步的问题或两个表联合查询
- 菜鸟求教 C# list 的问题
- 寻求站内搜索解决方案
- 怎样把Hello wodld倒转过来dlrow olleH(急)
- 求,viso数据库建模例子或资料,谢谢!!在线等,急!!!
- 请问如何安装.NET快速门呢?那个MSDE怎么搞呢,多谢各位?
- 这样的xml文件,如何用asp.net往里面插入一条记录和删除一条以及更新一条记录,请各位多多帮忙。
- (全部分数奉上--求一简单问题)ASP中的文件文件权限问题!
- 如何实现把服务器上的文件下载到本地?
- 我想做个欲揽本地文件的自定义控件
- <急>网页表格居中
- “未与信任 SQL Server 连接相关联”,SQL SERVER数据库连接问题
网上的大哥,大姐,能否发一个整个源码给偶,
偶的Email:[email protected]
谢了。
去申请吧,不过money得大大的。