1. 在页面上显示出来的时间格式
<asp:BoundField DataField="SEndDate" HeaderText="截止日期:" SortExpression="SEndDate" DataFormatString="{0:yyyy-MM-dd}">
update student
set sex=(case wehn sex='男' then '女' else '男' end)
可以不用(),update 表 set 列 = (....) 后面无where
3. 连接地址传送参数
<asp:GridView ID="GridView1" runat="server" Width="760px" AutoGenerateColumns="False" DataSourceID="objdsSupList" AllowPaging="True">
<Columns>
<asp:BoundField DataField="SId" ShowHeader="False" SortExpression="SId" Visible="False" />
<asp:HyperLinkField DataNavigateUrlFields="SId" DataNavigateUrlFormatString="suplist.aspx?id={0}"
DataTextField="STitle" ShowHeader="False">
<ItemStyle HorizontalAlign="Left" Width="600px" />
</asp:HyperLinkField>
<asp:BoundField DataField="SWriteDate" ShowHeader="False" SortExpression="SWriteDate" />
</Columns>
</asp:GridView>
<asp:ObjectDataSource ID="objdsSupList" runat="server" SelectMethod="getSupplyIfoByTypeName"
TypeName="FarmProduceBLL.SupplyInfoManager">
<SelectParameters>
<asp:QueryStringParameter Name="sid" QueryStringField="id" Type="int32" />
</SelectParameters>
</asp:ObjectDataSource>
4. sql中带参数传到command中
(1) string sql = "UPDATE TBL_SupplyInfo SET sState=1 WHERE sId = '"+ id +"' ";
(2) string sql = "UPDATE [FarmDB].[dbo].[TBL_SupplyInfo] SET [sState]=@sState WHERE [sId] = @sId ";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@sState",SqlDbType.Int),
new SqlParameter("@sId",SqlDbType.Int)
};
para[0].Value = sState;
para[1].Value = id;
SqlConnection con = new SqlConnection(strCon);
SqlCommand cmd = new SqlCommand(sql,con);
//cmd.Parameters.Add(pa).Value = id;
cmd.CommandType = CommandType.Text; //先制定commandType为Text,执行的是sql语句而不是存储过程
foreach(SqlParameter pa in para)
{
cmd.Parameters.Add(pa);
}
(3)
SqlParameter[] pa = new SqlParameter("@sState",SqlDbType.Int);
SqlParameter[] pb = new SqlParameter("@sID",SqlDbType.Int);
cmd.Parameters.Add(pa).Value = state;
cmd.Parameters.Add(pb).Value = id;
5. sql 一次添加多行
insert Student select 'wc',2,'旺财',0 union all
select 'rh',3,'如花',0 union all
select 'aj',4,'啊九',0 union all
select 'aq',5,'啊七',0 union all
select 'ab',9,'啊八',0