摘要：import excelCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-- //import excel by filepath and sheetname public DataTable ExcelDataSource(string filepath... 阅读全文

摘要：授权： GRANT INSERT/UPDATE/SELECT/ALL ON tablename TO username privilege granted收权： REVOKE INSERT/UPDATE/SELECT/ALL ON tablename TO username privilege revoked 阅读全文

摘要：配置： profile name account调用： EXEC msdb.dbo.sp_send_dbmail @profile_name=profile name @recipients=recipient email address @subject=subject @body=body @body_format='HTML'/Others 阅读全文

摘要：Create trigger [triggername] on [table1] for [动作名][Insert/Update/Delete] As ......系统参数： Deleted:table1执行动作前的记录。 Inserted:table1执行动作后的记录。 @@rowcount:表示变化记录的条数。trigger存在table1中。 阅读全文

摘要：gridviewCode highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--public static void GroupRows(GridView GridView1, int cellNum) { int i = 0, rowSpanNum = 1; whi... 阅读全文