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() <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./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()" /> 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 好方法,方向键的好方法: private void txtMInfo_KeyDown(object sender, KeyEventArgs e)
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; |
|