string js = "<script language=javascript>alert('{0}');window.location.replace('{1}')</script>";
Response.Write(string.Format(js, "帐号已在别处登陆，你将被强迫下线（请保管好自己的用户密码）！", "logout.aspx?cname=noadmin"));
return;
后台新窗口打开页面
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Button1.Attributes.Add("onclick", "this.form.target='_blank'");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
Response.Redirect(string.Format("~/Publish/PublishDetail.aspx?Ids={0}", ids));
}
CREATE PROCEDURE test
@start INT ,
@end INT ,
@total INT OUTPUT
AS
BEGIN
DECLARE @strSQL VARCHAR(5000)
SET @strSQL='select top '+Convert(varchar(50),@start)+' * from v_hospital';
EXEC(@strSQL)
END
GO
DateTime.Now.ToString("yyyy-MM-dd HH:mm:dd.ffffff");
<asp:LinkButton ID="LinkButton1" CommandName="san" CommandArgument='<%#GetPermissionId(ProjectId.Value+";"+Eval("EXTERIORID")) %>' Text="△" runat="server"></asp:LinkButton>
<asp:HiddenField ID="ProjectId" runat="server" />
管理员回复：<%# Eval("IsReplied").ToString() == "False" ? "暂无" : Eval("Reply")%>
判断所有textbox是否为空
/// <summary>
/// 不为空返回true
/// </summary>
/// <param name="controls">父节点的所有子节点</param>
/// <returns>bool</returns>
private bool isNullControls(ControlCollection controls)
{
foreach (Control control in controls)
{
if (control is TextBox)
{
if (!string.IsNullOrEmpty((control as TextBox).Text))
{
return true;
}
}
else if (control is DropDownList)
{
if ((control as DropDownList).SelectedValue!="99")
{
return true;
}
}
}
return false;
}
隔行变色+选中变色 列表
<tr style="line-height: 15px; background-color: <%#(Container.ItemIndex%2==0)?"#EDEDED":""%>"
onmouseover="this.style.backgroundColor='#CCFFFF'" onmouseout="this.style.backgroundColor='<%#(Container.ItemIndex%2==0)?"#EDEDED":""%>'">
NavigateUrl='<%# Eval("Id", "article.aspx?id={0}") %>'
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl='<%#"ResumeDetails.aspx?userid="+Eval(DataList1.DataKeyField)+"&keyword="+HiddenField1.Value%>'
Text="简历详情" Target="_blank"></asp:HyperLink>
//写在text里面 只能输入6位的数字
onKeyUp="this.value=this.value.replace(/[^0-9.]/g,'')" maxlength="6"
唯一性约束
Alter table 表名 add constraint 约束名 unique (列名)
<fieldset id="fieldset2" runat="server" visible="false">
<legend>您的签退信息</legend>
</fieldset>
///<reference path=~/jquery/jquery-1.3.2-vsdoc2.js>
ModalPopup样式
.otherBgCss{
background-color:Gray;
filter:alpha(opacity=70);
opacity:0.7;
style="word-break:break-all;word-wrap:break-word"
JQuery：
function show_2(obj){
$("#model_2").css("display","block");
$("#model_2").css("top",$(obj).offset().top+20);
$("#model_2").css("left",$(obj).offset().left-5);
}
jquery asp.net
id选择器
$(function() {
var bb = $("#<%=Label2.ClientID %>").text();
alert(bb);//可以输出
var aa = $("#<%=Label2.ClientID %>").val();
//alert(aa);//不能输出
});
FreeTextBox 隐藏工具栏
EnableToolbars="False"
隐藏列表中多余的字
<style type="text/css">
ul {width:300px; margin:50px auto;}
li {width:300px; line-height:25px; text-overflow:ellipsis; white-space:nowrap; overflow:hidden;}
a {color:#03c; font-size:13px;}
a:hover {color:#000;}
</style>
问题描述：HyperLink控件的NavigateUrl=’~/PersonalManage/userInfo.aspx?uid=<%#Eval("userID") %>’
运行结果,链接变成：
http://localhost:1107/.../PersonalManage/userInfo.aspx?uid=<%#Eval("userID") %>
<asp:HyperLink ID="HyperLink1" runat="server"
NavigateUrl='<%# "~/details.aspx?id="+Eval("id") + "&key=" + Session["keyword"] + "
&key1=" + Session["keyword1"] + "&key2=" + Session["keyword2"] + "
&key3=" + Session["keyword3"] %>'><%# Eval("name") %></asp:HyperLink>
也就是说绑定部分没有被解析
方法一: NavigateUrl=’ <%#Eval("userID","~/PersonalManage/userInfo.aspx?uid={0}") %>’
方法二: NavigateUrl='<%# "~/PersonalManage/PersonalInfoChange.aspx?UID="+Eval("userID") %>'
如果是GrilView控件的HyperLinkField,则可以这样写(因为GrilView控件的HyperLinkField的NavigateUrl不支持直接在=号后面加绑定)
<asp:HyperLinkField HeaderText="个人信息" Text="查看" DataNavigateUrlFormatString="~/PersonalManage/PersonalInfoChange.aspx?uid={0}" DataNavigateUrlFields="userID" />
也可以将HyperLinkField转换为TemplateField,然后再在TemplateField里加HyperLink,再按照前面的方法做即可
//获取当前右键点击的PictureBox
PictureBox monsterPic = (PictureBox)this.cmsAttack.SourceControl;
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add("@StudentID", SqlDbType.Int).Value=0;
//设置函数输出或者输入的类型 comm.Parameters["@StudentID"].Direction=ParameterDirection.Output;
conn.Open();
comm.ExecuteNonQuery();
conn.Close(); conn.Dispose();
number = Convert.ToInt32(comm.Parameters["@StudentID"].Value);
public static SqlDataReader GetReader(string sql, params SqlParameter[] values)
{
SqlCommand cmd = new SqlCommand(sql, Connection);
cmd.Parameters.AddRange(values);
SqlDataReader reader = cmd.ExecuteReader();
return reader;
}
public void DeleteTeacher(int teacherID)
{
string sql = "delete from teacher where teacherid = @teacherID";
SqlParameter para1 = new SqlParameter("@teacherID", SqlDbType.Int, 4);
para1.Value = teacherID;
SqlParameter[] paras = {para1};
DBHelper.ExecuteCommand(sql, paras);
}
//事务
{
{
connection.Open();
SqlCommand command = connection.CreateCommand();
SqlTransaction transaction;
transaction = connection.BeginTransaction("SampleTransaction");
command.Connection = connection;
command.Transaction = transaction;
{
command.CommandText =
"Insert into Region (RegionID, RegionDescription) VALUES (100, 'Description')";
command.ExecuteNonQuery();
command.CommandText =
"Insert into Region (RegionID, RegionDescription) VALUES (101, 'Description')";
command.ExecuteNonQuery();
transaction.Commit();
}
{