Skip to content

Instantly share code, notes, and snippets.

View ggface's full-sized avatar
🏠
Working from home

Ivan Novikov ggface

🏠
Working from home
View GitHub Profile
@ggface
ggface / gist:5856127
Created June 25, 2013 05:25
Проверка на минимальную длину. ASP.net TextBox Validation.
<asp:TextBox ID="txtPassword" runat="server" TextMode="Password" />
<asp:RegularExpressionValidator ID="valPassword" runat="server"
ControlToValidate="txtPassword"
ErrorMessage="Minimum password length is 5"
ValidationExpression=".{5}.*" />
@ggface
ggface / gist:5711658
Created June 5, 2013 04:43
DevExpress Grid - DetailRow - Save keyValue to session
/// gvObjectElement as ASPxGridView
/// <dx:ASPxGridView ID="gvObjectElement" runat="server" AutoGenerateColumns="False"
/// DataSourceID="dsObjectElement" KeyFieldName="C_OBJECT_ELEMENT"
/// OnDetailRowExpandedChanged="gvObjectElementDetailRowExpandedChanged">
protected void gvObjectElementDetailRowExpandedChanged(object sender, ASPxGridViewDetailRowEventArgs e)
{
var grid = (ASPxGridView) sender;
Session[GRID_DETAIL_INDEX] = Convert.ToInt32(grid.GetRowValues(e.VisibleIndex, grid.KeyFieldName));
}
@ggface
ggface / gist:5480810
Created April 29, 2013 10:21
Шляпа для бинда визибла
Visible='<%# Eval("DMR")=="Yes" %>'
--ну и с сервака
ImageUrl="<%# GetIconImageUrl(Container) %>"
protected string GetIconImageUrl(GridViewDataItemTemplateContainer container) {
Quote quote = (Quote)grid.GetRow(container.VisibleIndex);
return String.Format("Images/{0}.gif", quote.Change > 0 ? "Up" : "Down");
}
/* begin table creation */
create table department
(dept_id smallint unsigned not null auto_increment,
name varchar(20) not null,
constraint pk_department primary key (dept_id)
);
create table branch
(branch_id smallint unsigned not null auto_increment,
@ggface
ggface / gist:5354428
Created April 10, 2013 13:03
Добавляем поле для хранения MD5 пароля
ALTER TABLE [D_USER] ADD [PWD] uniqueidentifier NOT NULL DEFAULT newid()
@ggface
ggface / gist:5243178
Created March 26, 2013 04:39
Ищем поля в таблице с условием, что поле не может быть равно null.
SELECT [SC].[NAME]
FROM sysobjects AS [SO]
JOIN syscolumns AS [SC] ON ([SO].[ID] = [SC].[ID])
AND ([SO].[XTYPE] = 'U')
AND ([SO].[NAME] = 'D_OBJECT') -- 'D_OBJECT' имя таблицы
WHERE ([SC].[ISNULLABLE] = 0)
@ggface
ggface / gist:5235100
Created March 25, 2013 05:26
Поле грида для вывода валюты
<dx:GridViewDataTextColumn Caption="Текущие цены" FieldName="COST_EXPL_NOW" FixedStyle="None"
SortOrder="None" UnboundType="Bound" VisibleIndex="5">
<PropertiesTextEdit DisplayFormatString="{0:C2}" />
</dx:GridViewDataTextColumn>
@ggface
ggface / gist:4631927
Last active December 11, 2015 17:08
How are you going to delete records into DataTable when you use for loop?
DataTable usedKeys;
DataTable allKeys;
// …
// Here you must fill <allKeys> and <usedKeys>
// add PrimaryKey
allKeys.PrimaryKey = new[] { usedKeys.Columns["FIELD_NAME"] };
// processing
@ggface
ggface / gist:4604957
Created January 23, 2013 12:18
Fastreport custom value into memo ect.
type
TMyLang = record
key, ru, kz:string;
end;
TArrMyLang = array of TMyLang;
TfrxReport.OnGetValue ->VarName:string