1、Chcekboxlist选择的值放Label中显示:
protected void cbxList1_SelectedIndexChanged(object sender, EventArgs e)
{ Label2.Text=null; //先清了
for (int i = 0; i <= cbxList1.Items.Count - 1; i++)
{
int index = Convert.ToInt16(cbxList1.Items[i].Value);
Label2.Visible = true;
if (cbxList1.Items[i].Selected == true)
{
Label2.Text += "您选择的表名是:" + cbxList1.Items[i].Text + "值是:" + cbxList1.Items[i].Value + "/<BR>";
}
}
2、ChcekboxlistItems放ListBox中显示
protected void cbxList1_SelectedIndexChanged(object sender, EventArgs e)
{
ListBox1.Items.Clear(); //先清空Items项;
for (int i = 0; i <= cbxList1.Items.Count - 1; i++)
{
if (cbxList1.Items[i].Selected == true)
{
ListBox1.Items.Add(new ListItem(cbxList1.Items[i].Text));
}
}
3、 怎样使录入界面不滚动
4、Drop database
5、使用开放式并发
加入</th></tr><tr>制造换行效果
6、sqldsCustomer.SelectParameters.Add(ctlCountry)与<SelectParameters>
<asp:Parameter Name="paramCountry" />
</SelectParameters>冲突
public partial class ControlParaCodebb : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//设置Select命令及条件参数
//sqldsCustomer.SelectCommand = "SELECT [CustomerID], [CompanyName], [Address], [City], [Country] FROM [Customers] where country=@paramCountry";
//创建控件参数
ControlParameter ctlCountry = new ControlParameter("paramCountry", "dwnCountry", "SelectedValue");
if (!IsPostBack)
{
//将控件参数加入数据源控件
sqldsCustomer.SelectParameters.Add(ctlCountry);
}
}
}
<asp:SqlDataSource ID="sqldsCustmer" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT [CustomerID], [CompanyName], [Address], [City], [Country] FROM [Customers] WHERE ([Country] = @paramCountry)">
/* <SelectParameters>
<asp:Parameter Name="paramCountry" />
</SelectParameters>*/ 前面有sqldsCustomer.SelectParameters.Add(ctlCountry),就不要在这里设置参数
</asp:SqlDataSource>
2011-04-10
7、添加Cookie,Cookie名称为Country,值为USA
if (!IsPostBack)
{
Response.Cookies.Add(new HttpCookie("Country1", "
}
<SelectParameters>
<asp:CookieParameter CookieName="Country1" Name="paramCountry" />
</SelectParameters>
8、设置默认焦点及按钮
9、回车变换行
function enterToTab()
{
if(event.srcElement.type != 'button ' && event.srcElement.type != 'textarea '
&& event.keyCode == 13)
{
event.keyCode = 9;
}
}
<script type="text/javascript">
function textChanged(o){
if(event.keyCode == 13){
var win = window.open("", "_blank");
win.document.writeln("Hello World!");
}
}
</script>
两种定义TextBox方案:
1.<input type="text" onkeyup="textChanged(this)" onchange="textChanged(this)" runat="server" id="YourTextBox" />
2.<asp:TextBox ID="TextBox1" runat="server" onkeyup="textChanged(this)"></asp:TextBox>
<!DOCTYPE html PUBLIC "-//W
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>按回车光标自动跳至下一个文本框代码 - www.webdm.cn</title>
<meta http-equiv="content-type" content="text/html;charset=gb2312">
</head>
<body>
用户:<input type="text" name="input1"><br>
密码:<input type="text" name="input2"><br>
邮箱:<input type="text" name="input3">
<script language="javascript">
function document.onkeydown(){
if(event.keyCode==13)
event.keyCode=9;
}
</script>
</body>
</html>
<input id="text1" type="text" onkeypress="Do()" />
<input id="text2" type="text" />
<script>
function Do()
{
if(event.keyCode==13)
{
document.getElementById("text2").focus();
}
}
</script>
2011-04-10
审核程序1:先生成插入语句,再用sqlEmployees.Insert();
protected void btnInsert_Click(object sender, EventArgs e)
{
txtError.Visible = false;
if ((Convert.ToInt16(txtCity.Text)) >= (Convert.ToInt16(txtAddress.Text)))
{
txtError.Visible = true;
txtError.Text = "添加成功";
sqlEmployees.Insert();
}
else
{
txtError.Visible = true;
txtError.Text = "City>=Address"+":"+"City的值是:"+txtCity.Text+"Address的值是:"+txtAddress.Text;
//showMsg("数据审核错误,请改正");
}
}
protected void showMsg(string AlertMessage)
{
Literal txtMsg = new Literal();
txtMsg.Text = "<script>alert('" + AlertMessage + "')</script>" + "<BR/>";
Page.Controls.Add(txtMsg);
}
}
2011/4/10 用方向键移动焦点
这段代码保存成:focusTest.htm
执行的时候你先让文本框得到焦点,使用上下方向键控制切换焦点
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN ">
<html>
<head>
<title> test </title>
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 ">
<script language= 'javascript ' src= "MaskInput.js "> </script>
<style>
a:link
{
color: #000000;
text-decoration: none;
}
a:hover
{
color: #000000;
text-decoration: none;
}
A
{
color: #000000
text-decoration: none;
}
a:visited {
text-decoration: none;
color: #000000;
}
a:active {
color: #FF0000;
}
</style>
</head>
<body onkeyDown= "ChangeFocus() ">
<input tabindex= "1 ">
<input tabindex= "2 ">
<input tabindex= "3 ">
<input tabindex= "4 ">
<input tabindex= "5 ">
<input tabindex= "6 ">
<input tabindex= "7 ">
<input tabindex= "8 ">
<input tabindex= "9 ">
<input tabindex= "10 ">
<br>
<a href= "http://www.sina.com.cn " tabindex= "11 " target= '_blank '> test_link1 </a>
<br>
<a href= "http://www.sohu.com " tabindex= "12 " target= '_blank '> test_link2 </a>
<br>
<a href= "http://www.csdn.net " tabindex= "13 " target= '_blank '> test_link3 </a>
<br>
<a href= "file:///c|/ " tabindex= "14 " target= '_blank '> test_link4 </a>
<br>
<a href= "file:///d|/ " tabindex= "15 " target= '_blank '> test_link5 </a>
<br>
</body>
</html>
这段代码保存成:MaskInput.js
var onchangeObj = null; //判断对象是否发生了变化
function ChangeFocus()
{//用法只要先包含这个JS然后再 <body onkeydown= "ChangeFocus() "> </body>
// 如果处于选择文字状态
var objSelText = document.selection.createRange() ;
var nSelTextLength = objSelText.text.length ;
if (event.keyCode == 229 && nSelTextLength > = 2 && event.keyCode != 13 && event.keyCode != 27)
//中文输入状态下(注229是全角通用键值)
return true ;
if (event.keyCode != 229 && nSelTextLength > 0 && event.keyCode != 13 && event.keyCode != 27)
return true ;
var type = event.srcElement.type ;
if(event.keyCode == 13 && typeof(event.srcElement.href) != "undefined ") return true; //如果是链接就不转换焦点
if (( type == "button " || type == "image " || type == "submit " || type == "reset " || type == "password " ) && event.keyCode== 13)
return true ;
// 将回车键转为 Tab 键
//alert(event.keyCode);
if (event.keyCode == 13)
event.keyCode = 9 ;
//将右方向键没为TAB键
if(event.keyCode == 40)
event.keyCode = 9 ;
//将左方向键变为shift+tab的功能
//在这里是通过设每一个可能到焦点对象的tabindex来确定的
if(event.keyCode == 38 )
{
var nTab = event.srcElement.tabIndex ;
var n = 100 ;
var obj = event.srcElement ;
for (var i=0; i <document.all.length; i++)
{ z
if ((nTab - document.all(i).tabIndex) > 0 && (nTab - document.all(i).tabIndex) < n )
{
if (document.all(i).tagName != "undefined " && document.all(i).tabIndex > 0 && !(document.all(i).disabled))
{
obj = document.all(i) ;
n = nTab - obj.tabIndex ;
}
}
}
obj.focus() ;
return ;
}
}
好方法,方向键的好方法:
private void txtMInfo_KeyDown(object sender, KeyEventArgs e)
{
// 向后跳转
if ( e.KeyCode == Keys.Enter || e.KeyCode == Keys.Right )
{
SendKeys.Send("{TAB}");
}
// 向前回跳
else if ( e.KeyCode == Keys.Left || e.KeyCode == Keys.Up )
{
SendKeys.Send("+{TAB}");
}
}
UPDATE或DELETE后被影响的行:
DataSet ds=New DataSet();
或 DataSet ds=New DataSet(“表名”);
建立一数据表,再建立包括这一表的数据集
DataTable dt=ds.表名
提取数据集中的数据表
DataRow dr=dt.Row[n];
String dc=dr.Column[index].Tostring();
或
String dc=dr.Columns[“字段名”].Tostring();
string SqlStr = "select ID from UserAccount where ID='";
SqlStr += ((System.Web.UI.WebControls.Login)sender).UserName;
SqlStr += "' and Password='" + ((System.Web.UI.WebControls.Login)sender).Password + "'";
CREATE PROCEDURE [dbo].[a405sh3]
@dwdm char(8)='2800'
AS
select dwdm,dwmc,errfma,errtxt from a405error,a405check where substring(error1,errid,1)='1' and dwdm=@dwdm
GO
然后在sqlDatsourse中调用
DateTime tt1=DateTime.Parse(TexBox1.Text)
2011-03-13 回车变TAB
<head runat="server">
<title>无标题页</title>
<script type="text/javascript" language=javascript>
function document.onkeydown()
{
if(event.srcElement.type != 'button ' && event.srcElement.type != 'textarea '
&& event.keyCode == 13)
{
event.keyCode = 9;
}
}
</script>
</head>
protected void TextBox1_TextChanged(object sender, EventArgs e)
{
ny ny1 = new ny();
nyTableAdapters.zdTableAdapter adapter2 = new nyTableAdapters.zdTableAdapter();
var i= adapter2.GetDataByDwdm(Convert.ToInt16(TextBox1.Text)); //添加查询方法
//var emps = from p in ny1.zd
// where p.dwdm == Convert.ToInt16(TextBox1.Text)
// select p;
if (i == 0)
{
showMsg("单位名称不存在,请重新输入");
}
if (!IsPostBack) //第一次是接收参数,以后用TEXTBOX输入的值
{
string txt1 = Request.QueryString["dwdm"];
TextBox1.Text = txt1;
联系客服