常用代码sql C#常用代码.docVIP

0.用session判断是否登陆 if(Session[login] == null)?? {??? Response.Redirect(error.aspx);?? } 1. 打开新的窗口并传送参数：传送参数：response.write(scriptwindow.open(*.aspx?id=+this.DropDownList1.SelectIndex+id1=+...+)/script) 接收参数：string a? = Request.QueryString(id);string b? = Request.QueryString(id1); 2.为按钮添加对话框 Button1.Attributes.Add(onclick,return confirm(确认?)); button.attributes.add(onclick,if(confirm(are you sure...?)){return true;}else{return false;}) 3.删除表格选定记录 int intEmpID = (int)MyDataGrid.DataKeys[e.Item.ItemIndex];string deleteCmd = DELETE from Employee where emp_id = + intEmpID.ToString() 4.删除表格记录警告private void DataGrid_ItemCreated(Object sender,DataGridItemEventArgs e){switch(e.Item.ItemType){? case ListItemType.Item :? case ListItemType.AlternatingItem :? case ListItemType.EditItem:??? TableCell myTableCell;??? myTableCell = e.Item.Cells[14];??? LinkButton myDeleteButton ;??? myDeleteButton = (LinkButton)myTableCell.Controls[0];??? myDeleteButton.Attributes.Add(onclick,return confirm(您是否确定要删除这条信息););??? break;? default:? break;} } 5.点击表格行链接另一页 private void grdCustomer_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e){//点击表格打开if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)e.Item.Attributes.Add(onclick,window.open(Default.aspx?id= + e.Item.Cells[0].Text + ););} 双击表格连接到另一页在itemDataBind事件中if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)? {string OrderItemID =e.item.cells[1].Text;...e.item.Attributes.Add(ondblclick, location.href=../ShippedGrid.aspx?id= + OrderItemID + );}双击表格打开新一页if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)? {string OrderItemID =e.item.cells[1].Text;...e.item.Attributes.Add(ondblclick, open(../ShippedGrid.aspx?id= + OrderItemID + ));}★特别注意：【?id=】 处不能为 【?id =】 6.表格超连接列传递参数asp:HyperLinkColumn Target=_blank? headertext=ID号 DataTextField=id NavigateUrl=aaa