ASP.NET程序中常用小技巧

登录:
  private void btnLogin_Click(object sender, System.EventArgs e)
  {
   try
   {
    string sqlstr = "server = 192.168.0.57;uid = sa;pwd = sa;database = gaochao";
    string sqlcom = "select * from chao where Name = '"+txtName.Text.Trim()+"' and Class = '"+txtPassWord.Text.Trim()+"'";
    SqlConnection con = new SqlConnection (sqlstr);
    SqlCommand com = new SqlCommand (sqlcom,con);
    con.Open ();
    SqlDataReader dr = com.ExecuteReader();
    if(dr.Read())
    {
     Response.Write("<script>window.alert('登陆成功')</script>");
    }
    else
    {
     Response.Write("<script>window.alert('登陆失败')</script>");
    }
    con.Close();
   }
   catch(Exception ex)
   {
    Response.Write(ex.Message);
   }
  }



数据帮定
  private void dgBind()
  {
   string sqlcom = "select * from Student";
   SqlConnection con = new SqlConnection (sqlstr);
   SqlCommand com = new SqlCommand (sqlcom,con);
   SqlDataAdapter da = new SqlDataAdapter (com);
   DataSet ds = new DataSet ();
   da.Fill(ds);
   this.DataGrid1.DataSource = ds;
   this.DataGrid1.DataBind();
  }

 /// <summary>
  /// 取消事件
  /// </summary>
  /// <param name="source"></param>
  /// <param name="e"></param>
  private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   this.DataGrid1.EditItemIndex = -1;
   dgBind();
  }
  /// <summary>
  /// 编辑事件
  /// </summary>
  /// <param name="source"></param>
  /// <param name="e"></param>
  private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   this.DataGrid1 .EditItemIndex = e.Item .ItemIndex;
   dgBind();
  }
  /// <summary>
  /// 更改事件
  /// </summary>
  /// <param name="source"></param>
  /// <param name="e"></param>
  private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   string sqlcom = "update Student set Age = '"+((TextBox)e.Item .Cells[2].Controls[0]).Text+"',Sex = '"+((TextBox)e.Item .Cells[3].Controls[0]).Text+"', Class = '"+((TextBox)e.Item .Cells[4].Controls[0]).Text+"', Addr = '"+((TextBox)e.Item .Cells[5].Controls[0]).Text+"' where ID = '"+DataGrid1.DataKeys[e.Item .ItemIndex]+"'";
   SqlConnection con = new SqlConnection (sqlstr);
   SqlCommand com = new SqlCommand (sqlcom,con);
   SqlDataAdapter da = new SqlDataAdapter (com);
   DataSet ds = new DataSet ();
   da.Fill(ds);
   DataGrid1.EditItemIndex = -1;
   dgBind();
   Response.Write("<script>window.alert('更新成功')</script>");
  }
  /// <summary>
  /// 删除事件
  /// </summary>
  /// <param name="source"></param>
  /// <param name="e"></param>
  private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   string sqlcom = "delete Student where ID = "+Convert.ToInt32(DataGrid1.DataKeys[e.Item .ItemIndex].ToString())+"";
   SqlConnection con = new SqlConnection (sqlstr);
   SqlCommand com = new SqlCommand (sqlcom,con);
   SqlDataAdapter da = new SqlDataAdapter (com);
   DataSet ds = new DataSet ();
   da.Fill(ds);
   dgBind();

  }
一 ,打开新窗口并传递参数
(1)response.write("＜script＞window.open(’*.aspx?id="+this.DropDownList1.SelectIndex+"&id1="+...+"’)＜/script＞")
　　接收参数：

string a = Request.QueryString("id");
string b = Request.QueryString("id1");

(2)Button跳转新页面
Response.Redirect("SaleOrderBackAdd.aspx?rsoId=" + rsoId.ToString()+"&Type=0");

 Response.Write("<script>window.alert('合同" + mylabel.Text + " 未分配仓位');window.location='/XTMYWeb/Base/StoreRoom/StoreRoomShelfAllot.aspx';</script>");   //先提示后跳转页面

(3)Button打开新页面
 private void Page_Load(object sender, System.EventArgs e)
  {
       if(!IsPostBack)
       {
            Button1.Attributes.Add("onclick","window.open('../Sale/ShowJobOrder.aspx?rsoId="+rsoId.ToString()+"&url=SaleOrderShow.aspx','新页面名称,'top=100%,left=80,toolbar=no, menubar=no,scrollbars=yes,"
     +"resizable=yes, location=no, status=no, width=610,height=400');return false;");
        }
  }

(4)DataGrid打开新页面(也可以做打印)
(a)
把此列转换为模板列

(b)
 <asp:TemplateColumn HeaderText="合同编号">
         <HeaderStyle Width="9%"></HeaderStyle>
         <ItemTemplate>
          <a style="CURSOR: hand" onmouseover="this.style.color='#FF0000'" onmouseout="this.style.color='#000000'" onmousemove="this.style.color='#FF0000'"
          href='SaleOrderShow.aspx?rsoId=<%# DataBinder.Eval(Container, "DataItem.rsoId") %>' target="_blank">
           <%# DataBinder.Eval(Container, "DataItem.rsoCode") %>//该列的绑定字段
          </a>
         </ItemTemplate>
        </asp:TemplateColumn>

(4)在后台做打印控制
(1),首先给datagrid/gridView添加一个"选择"列
(2)后台写事件代码:
datagrid:
private void dgdList_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
  {
   int OrderID = int.Parse(dgdList.Items[e.Item.ItemIndex].Cells[10].Text.Trim());
   Response.Write("<script>window.open('../Print/batchSale/PrintbatchSalePick.aspx?BPickID="+OrderID+"','查看','top=100,left=100,toolbar=no,menubar=no,scrollbar=yes,resizable=yes,location=no,status=no,width=1000,height=800');</script>");  
  }
gridView:
    protected void gvSaleOrder_SelectedIndexChanged(object sender, EventArgs e)
    {
        int id = Convert.ToInt32(gvSaleOrder.DataKeys[gvSaleOrder.SelectedIndex].Value.ToString());
        Tools.Common.JavaScript.OpenWindow(this,"http://www.cnblogs.com/print/PrintSaleOrder2.aspx?id="+id);
    }

(5)接收参数
  private int rsoId
  {
         get
            {
                try
                   {
                       return Convert.ToInt32(Request.QueryString["rsoId"]);
                   }
                catch
                   {
                       return 0;
                   }
            }
  }

(6)
控制摸板列字段里TextBox的readonly属性
<1>点开摸板列里TextBox控件的属性,选择最上面的DataBindings属性
<2>在新窗口找到ReadOnly并在"自定义绑定表达式"里写上方法.例如:a==1?true:false
<3>在cs里写属性.例如:
 public int a
{
   set
      {
            b=0;
      }
   get
      {
            return b;
      }
}

(6)DataGrad/GradView根据绑定列的值做不同的显示
例如: 
(1),先把该列转换为摸板列
(2),编辑该列绑定方式
 <asp:TemplateColumn HeaderText="有货架">
                                            <HeaderStyle Width="7%" />
                                            <ItemTemplate>
                                                <asp:Label ID="Label1" runat="server" Text='<%# Convert.ToInt32(DataBinder.Eval(Container, "DataItem.IsShelf")) == 0 ? "否":"是" %>'>
              </asp:Label>
                                            </ItemTemplate>
                                        </asp:TemplateColumn>

(7) 保存隐藏参数
<td>
<input id="OutStoreroomName" runat="server" name="OutStoreroomNameID" readonly=""
                                    size="1" style="width: 24px; height: 20px" type="hidden" />
</td>
OutStoreroomName.Value="1";      //后台绑数据
二,Button的提示
(1)
Button1.Attributes.Add("onclick","return confirm(’确认?’)");
button.attributes.add("onclick","if(confirm(’are you sure...?’)){return true;}else{return false;}")

(2)
btnDel.Attributes.Add("onclick",   "return   confirm('确定删除该记录吗？');");

(3)DataGrid列删除提示
 private void dgBank_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
  {
      if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
      {
          (e.Item.Cells[4].Controls[0] as LinkButton).Attributes.Add("onclick","return confirm('确定要删除吗！');");
      }
  }

三,获取参数值
1,取DataGrid列值:

(1)取主键值
int ID = Convert.ToInt32(dgBank.DataKeys[e.Item .ItemIndex]);

(2)取列值
string Memo=(dgProduct.Items[i].Cells[7].Controls[1] as TextBox).Text;
int a = Convert.ToInt32((e.Item.Cells[2].Controls[0] as TextBox).Text);
string b = (e.Item.Cells[1].Controls[0] as TextBox).Text.Trim();
int c = Convert.ToInt32(e.Item.Cells[8].Text);   //只读列
int d = Convert.ToInt32((e.Item.Cells[6].Controls[1] as DropDownList).SelectedValue.ToString());   //内嵌DropDownList控件

(3)循环DataGrid列表取值
(a)
 private int rsoId()
  {
      int r = 0;
      int rsoId = -1;
      for(int i = 0; i < dgSaleOrder.Items.Count; i++)
      {
          if((dgSaleOrder.Items[i].Cells[0].FindControl("CheckBox") as CheckBox).Checked)
             {
                 rsoId =Convert.ToInt32( dgSaleOrder.DataKeys[dgSaleOrder.Items[i].ItemIndex].ToString());
                 r++;
             }
      }
      if(r == 0)
      {
          MessageBox.Show(this,"请选择一条数据");
          return false;
      }
      if(r>1)
      {
          MessageBox.Show(this,"选择请不要多于一条数据");
          return false;
      }
      else
      {
         return rsoId;
      }
}

(b)
 private string rsoId()
  {
       string rsoId = "";
      for(int i = 0; i < dgSaleOrder.Items.Count; i++)
      {
          if((dgSaleOrder.Items[i].Cells[0].FindControl("CheckBox") as CheckBox).Checked)
             {
                 rsoId+ =dgSaleOrder.DataKeys[dgSaleOrder.Items[i].ItemIndex]+",";
             }
      }
      if(rsoId == "")
      {
          MessageBox.Show(this,"请选择一条数据");
          return false;
      }

      else
      {
         rsoId= rsoId.Remove(rsoId.Length - 1,1);
         return rsoId;
      }
}

2,GridView 自段取值
(1)取主键值
int StoreMoveID = Convert.ToInt32(grvOperStoreMove.DataKeys[grvOperStoreMove.SelectedIndex].Value.ToString());

(2)取多个主键值
 int RetailContractLadeID = Convert.ToInt32(GrvOperRetailContractLade.DataKeys[GrvOperRetailContractLade.SelectedIndex].Values["RetailContractLadeID"].ToString());

 int RetailContractTypeID = Convert.ToInt32(GrvOperRetailContractLade.DataKeys[GrvOperRetailContractLade.SelectedIndex].Values["RetailContractTypeID"].ToString());

(3)循环取主键值
gvBaseBank.DataKeys[gvBaseBank.Rows[i].DataItemIndex].Value.ToString()
(4)取列值
string RetailContractCode = grwOperRetailBContract.Rows[grwOperRetailBContract.SelectedIndex].Cells[1].Text;   //选中取值
 model.productID = Convert.ToInt32(grvOperStoreMoveDetail.Rows[i].Cells[0].Text);
四,表格点击改变颜色

if (e.Item.ItemType == ListItemType.Item ||e.Item.ItemType == ListItemType.AlternatingItem)
{
　e.Item.Attributes.Add("onclick","this.style.backgroundColor=’#99cc00’;
　　　 this.style.color=’buttontext’;this.style.cursor=’default’;");
}
 
写在DataGrid的_ItemDataBound里

if (e.Item.ItemType == ListItemType.Item ||e.Item.ItemType == ListItemType.AlternatingItem)
{
e.Item.Attributes.Add("onmouseover","this.style.backgroundColor=’#99cc00’;
　　　this.style.color=’buttontext’;this.style.cursor=’default’;");
e.Item.Attributes.Add("onmouseout","this.style.backgroundColor=’’;this.style.color=’’;");
}

五,Datagrid增加自动编号列
(正序)
1<asp:DataGrid id="DataGrid1" runat="server">
2    <Columns>
3     <asp:TemplateColumn>
4      <ItemTemplate>
5       <%# Container.ItemIndex + 1%>
6      </ItemTemplate>
7     </asp:TemplateColumn>
8    </Columns>
9 </asp:DataGrid>
(倒序)
<asp:DataGrid id="DataGrid1" runat="server" AllowPaging="True">
2                            <Columns>
3                                   <asp:TemplateColumn>
4                                          <ItemTemplate>
5                                                 <%# RowsCount - DataGrid1.CurrentPageIndex * DataGrid1.PageSize - Container.ItemIndex %>
6                                          </ItemTemplate>
7                                   </asp:TemplateColumn>
8                            </Columns>
9                     </asp:DataGrid>
五,GridView自动序号
(倒序)

<asp:TemplateField HeaderStyle-Width="30px" HeaderText="序号" ItemStyle-HorizontalAlign="center">
     <ItemTemplate>
         <asp:Label ID="Label1" runat="server" Text='<%#((Container as GridViewRow).DataItem as System.Data.DataRowView).Row.Table.Rows.Count - (Container as GridViewRow).RowIndex%>'></asp:Label>
     </ItemTemplate>
</asp:TemplateField>

(正序)

<asp:TemplateField HeaderStyle-Width="30px" HeaderText="序号" ItemStyle-HorizontalAlign="center">
     <ItemTemplate>
         <asp:Label ID="Label1" runat="server" Text='<%#(Container as GridViewRow).RowIndex + 1%>'></asp:Label>
     </ItemTemplate>
</asp:TemplateField>

六,一个按钮实现添加和更改两个功能

 private void Page_Load(object sender, System.EventArgs e)
 {
      if (!Page.IsPostBack)
      {
          if (Request.QueryString["U_ID"] == null || Request.QueryString["U_ID"].ToString() == string.Empty || Convert.ToInt32(Request.QueryString["U_ID"]) < 1)
          {
              btnSave.CommandName ="insert";
               btnSave.Text="添加";
           }
            else
            {
               btnSave.CommandName="update";
               btnSave.Text="更改";
            }
      }
 }

 private void btnSave_Click(object sender, System.EventArgs e)
 {
         if(Page.IsValid)
            {
                if(btnSave.CommandName == "insert")
                      {
                          Add();  
                      }
                else
                      {
                          Edit(); 
                      }
            }
  }

七,关于日期格式
1,页面按钮显示:
lblsendtime.Text = Convert.ToDateTime(m_table.Rows[0]["sendtime"]).ToString("yyyy-MM-dd");   //2007-04-05
lblsendtime.Text = Convert.ToDateTime(m_table.Rows[0]["sendtime"]).ToString("yyyy年MM月dd日 ddd");   
 //2007年04月05日 星期五

2,DataGrid列显示时间:
{0:yyyy-mm-dd}

八,CheckBox (全选或全不选)
  private void btnSelectAll_Click(object sender, System.EventArgs e)
  {
         for(int i = 0; i < dgMessage.Items.Count; i++)
            {
                   if(((CheckBox)dgMessage.Items[i].Cells[0].FindControl("CheckBox1")).Checked)
                      {
                             ((CheckBox)dgMessage.Items[i].Cells[0].FindControl("CheckBox1")).Checked = false;
                       }
                   else
                      {
                             for(int r = 0; r < dgMessage.Items.Count; r++)
                                {
                                       ((CheckBox)dgMessage.Items[r].Cells[0].FindControl("CheckBox1")).Checked = true;
                                 }
                             return;
                       }
            }
  }

九,对一组以逗号分隔的字符串ID值循环
string strID;
string[] strID = importIDs.Split(',');
for(int i = 0;i < strID.Length; i++)
   {
      Update saleOrder set name=**  where rsoId=strID[i]
   }

十,绑定DropDownList控件
 private void drpOrderStatusBind()
  {
   QuMeiXJ.BLL.batchSaleStatus bll = new QuMeiXJ.BLL.batchSaleStatus();
   DataSet ds = bll.GetList("1=1");
   drpOrderStatus.DataTextField = "bathSaleSName";
   drpOrderStatus.DataValueField = "bathSaleSID";
   drpOrderStatus.DataSource = ds;
   drpOrderStatus.DataBind();
   drpOrderStatus.Items.Insert(0,new ListItem("全部","-1"));
  }

十,在DataGrid里绑定DropDownList控件
(1),将要绑定的列转换为摸板列,在EditItemTemplate里放入DropDownList,在ItemTemplate里放Label
(2),在CS里写绑定数据属性:
    public DataTable drpDepNameU
    {
        get
        {
            XTMYSale.BLL.ConfDep bll = new XTMYSale.BLL.ConfDep();
            return bll.GetList("1=1").Tables[0];
        }
    }
(3),设置页面:       
<asp:TemplateColumn HeaderText="所属部门">
    
<EditItemTemplate>
         <asp:DropDownList ID="DropDownList1" runat="server" DataSource="<%#drpDepNameU%>"
           DataTextField="DepName" DataValueField="DepID">
         </asp:DropDownList>
</EditItemTemplate>
 </asp:TemplateColumn>

十,事务
 SqlConnection m_cn = new SqlConnection();
   m_cn.ConnectionString = SqlHelper.connectionString;
   m_cn.Open();
   SqlTransaction myTran = m_cn.BeginTransaction();
   try
   {
    SqlParameter[] parameters = {
        new SqlParameter("@buyOrderID", SqlDbType.VarChar,200)};
    parameters[0].Value = buyOrderID;
    SqlHelper.ExecuteNonQuer(myTran,CommandType.StoredProcedure,"UP_buyOrder_Delete",parameters);
    
    myTran.Commit();
    return true;

   }
   catch
   {
    myTran.Rollback();
    return false;
   }
   finally
   {
    myTran.Dispose();
    m_cn.Close();
    m_cn.Dispose();
   }

十一,根据条件转换字符
例:把逗号转化为换行
m_table.Rows[i]["备注"] = m_table.Rows[i]["备注"].ToString().Replace(",","<br>").Replace("，","<br>");

十二,ArrayList的使用
    private System.Collections.ArrayList getList()
    {
        int oldNum;
        int newNum;
        System.Collections.ArrayList m_lst = new ArrayList();
        for (int j = 0; j < grvOperStoreMoveDetail.Rows.Count; j++)
        {
            oldNum = int.Parse(grvOperStoreMoveDetail.Rows[j].Cells[4].Text);
            try
            {
                newNum = int.Parse((grvOperStoreMoveDetail.Rows[j].Cells[6].Controls[1] as TextBox).Text);
            }
            catch
            {
                Tools.Common.JavaScript.MessageBox(this, "输入数据不正确！");
                return null;
            }
            if (newNum > oldNum)
            {
                Tools.Common.JavaScript.MessageBox(this, "产品:" + grvOperStoreMoveDetail.Rows[j].Cells[1].Text + "入库数不能大于产品数！");
                return null;
            }
            else if (newNum != 0)
            {

                XTMYSale.Model.OperStoreInDetail model = new XTMYSale.Model.OperStoreInDetail();
                model.OrderDetailID = Convert.ToInt32(grvOperStoreMoveDetail.Rows[j].Cells[7].Text);
                model.productID = Convert.ToInt32(grvOperStoreMoveDetail.Rows[j].Cells[0].Text);
                model.productNum = Convert.ToInt32((grvOperStoreMoveDetail.Rows[j].Cells[6].Controls[1] as TextBox).Text);
                model.productWholesalePrice = Convert.ToDecimal(grvOperStoreMoveDetail.Rows[j].Cells[5].Text);
                model.productMaterial = grvOperStoreMoveDetail.Rows[j].Cells[3].Text.Replace("&nbsp;", "");
                model.StoreroomShelfID = 0;
                if (model != null)
                {
                    m_lst.Add(model);
                }
                else
                {
                    return null;
                }
            }

        }
        return m_lst;
    }