摘要:
1.增加字段 alter table docdsp add dspcodechar(200)2.删除字段 ALTER TABLE table_NAME DROP COLUMNcolumn_NAME3.修改字段类型 ALTER TABLE table_name ALTER COLUMNcolumn_name new_data_type4.sp_rename 改名EXEC sp_rename '[dbo].[Table_1].[filedName1]', 'filedName2', 'COLUMN'更改当前数据库中用户创建对象(如表、列或用户定义数据 阅读全文
摘要:
select p.product_id,max(i.ImagesPath) ImagesPath from teapp as p,Base_Images as iwhere p.Product_id=i.Product_Id group by p.product_id 阅读全文
摘要:
aspx:<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"Width="100%" OnRowDataBound="GridView1_RowDataBound">aspx.cs:protected void GridView1_RowDataBound(object sender, Grid... 阅读全文
摘要:
aspx:<div><asp:CheckBox ID="cbAll" runat="server" AutoPostBack="True" OnCheckedChanged="cbAll_CheckedChanged" Text="全选 " /><asp:Button ID="Button1" runat="server" OnClick="Button1_Click... 阅读全文
摘要:
//SQL2000 分布储存过程set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER PROCEDURE [dbo].[futures_GetPagedReCord] @tblName varchar(255), -- 表名@strGetFields varchar(1000) = '*', -- 需要返回的列 @fldName varchar(255)... 阅读全文
摘要:
//SQL2005 分页存储过程set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER PROCEDURE [dbo].[P_GetPagedReCord] (@startIndex INT, -- 开始索引号 @endindex INT, -- 结束索引号 @tblName varchar(255), -- 表名 @fldName varchar(255... 阅读全文
摘要:
protected void btnImport_Click(object sender, EventArgs e) { int j = 1; DateTime str_date; DataSet ds; string IsXls = System.IO.Path.GetExtension(FileUpload.FileName).ToString().ToLower();//System.IO.... 阅读全文
摘要:
页面:CommandArgument='<%# Eval("Id")+","+Eval("Name")%>'以逗号间隔参数代码:string[] arg = e.CommandArgument.ToString().Split(',');string id = arg[0];string name = arg[1];多个参数同样采取此种方法 阅读全文
摘要:
(1)DataList中添加按钮,并为其添加 CommandArgument属性与CommandName属性...<asp:Button ID="Button1" runat="server" Text="Button" CommandArgument='<%# Eval("ID") %>' CommandName="del"/>(2)DataList有个事件OnItemC... 阅读全文
摘要:
获取(.)点前一个字符string s = "123_u.jpg";string strKzm = s.Substring(s.LastIndexOf(".")-1);//获取文件扩展名string strImgNo1 = strKzm.Substring(0, 1);Response.Write(strImgNo1);计算字符串字节大小string str = "ABC";int s= Syst... 阅读全文