Cannot open database requested by the login. The login failed. Login failed for user 'IIS APPPOOL\DefaultAppPool'
Cannot open database requested by the login. The login failed. Login failed for user 'IIS APPPOOL\DefaultAppPool'
IIS 7 дээр вебээ байршуулаад нэвтрэх үед энэ алдаа гараад байвал Application Pools-ынхээ Identity-гаа NetworkService эсвэл LocalSystem болгож өөрчилнө. Ингэхийн тулд өөрчлөх гэж байгаа Pool-ийнхээ Advanced Settings руу орж өөрчилнө. Зургаа томруулж үзээрэй. Өөрчилсний дараа таны сонгосон NetworkService эсвэл LocalSystem байдлаар харагдана.
Read more...
Devxpress Tools won't appear in Visual Studio 2008 Toolbox
C:\Documents and Settings\
Дээрхи директороос доор нэр дурдсан файлуудыг устгах хэрэгтэй. Тэгээд Visual studio 2008 аа дахин ачааллаад гарч ирэх болно.
"toolbox.tbd", "toolboxIndex.tbd", "toolbox_reset.tbd", "toolboxIndex_reset.tbd"
Read more...
KeyDown event дээр keycode ийг тодорхойлох
private void dataGridView1_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Delete)
{
//Keys. тавиад ямар товчлуур дарахаар яах уу гэдгээ тодорхойлох л үлдлээ.
}
}
private void dataGridView1_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Delete)
{ //Keys. тавиад ямар товчлуур дарахаар яах уу гэдгээ тодорхойлох л үлдлээ.
}
}
Read more...
Formatting Dates, Times and Numbers in ASP.NET
| Format Description | Code Snippet | Output |
|---|---|---|
| Short date pattern (d) | DateTime.Now.ToString("d") | 11/8/2010 |
| Long date pattern (D) | DateTime.Now.ToString("D") | Monday, November 08, 2010 |
| Full date/time pattern - short time (f) | DateTime.Now.ToString("f") | Monday, November 08, 2010 3:39 PM |
| Full date/time pattern - long time (F) | DateTime.Now.ToString("F") | Monday, November 08, 2010 3:39:46 PM |
| General date/time pattern - short time (g) | DateTime.Now.ToString("g") | 11/8/2010 3:39 PM |
| General date/time pattern - long time (G) | DateTime.Now.ToString("G") | 11/8/2010 3:39:46 PM |
| Month/day pattern (M) | DateTime.Now.ToString("M") | November 08 |
| Round-trip date/time pattern (O) | DateTime.Now.ToString("O") | 2010-11-08T15:39:46.4804000-08:00 |
| RFC 1123 pattern (R) | DateTime.Now.ToString("R") | Mon, 08 Nov 2010 15:39:46 GMT |
| Sortable date/time pattern (s) | DateTime.Now.ToString("s") | 2010-11-08T15:39:46 |
| Short time pattern (t) | DateTime.Now.ToString("t") | 3:39 PM |
| Long time pattern (T) | DateTime.Now.ToString("T") | 3:39:46 PM |
| Universal sortable date/time pattern (u) | DateTime.Now.ToString("u") | 2010-11-08 15:39:46Z |
| Universal full date/time pattern (U) | DateTime.Now.ToString("U") | Monday, November 08, 2010 11:39:46 PM |
| Year/month pattern (Y) | DateTime.Now.ToString("Y") | November, 2010 |
| Format Description | Code Snippet | Output |
|---|---|---|
| Abbreviated month name, day and year | DateTime.Now.ToString("MMM d, yyyy") | Nov 8, 2010 |
| Day of the week name plus month name and day of month | DateTime.Now.ToString("dddd, MMMM d") | Monday, November 8 |
| Month/Day/Year, using exactly two digits for each | DateTime.Now.ToString("MM/dd/yy") | 11/08/10 |
| Format Description | Code Snippet | Output |
|---|---|---|
| Relative time for date more than a year ago | var birthDate = new DateTime(2008, 9, 1 9, 45, 0); birthDate.ToRelativeDateString() | on September 1, 2008 |
| Relative time for date several months ago | DateTime.Now.AddMonths(-6).ToRelativeDateString() | on May 8 |
| Relative time for date five days ago | DateTime.Now.AddDays(-5).ToRelativeDateString() | five days ago |
| Relative time for yesterday | DateTime.Now.AddDays(-1).ToRelativeDateString() | yesterday |
| Relative time for several hours ago | DateTime.Now.AddHours(-3.14159).ToRelativeDateString() | three hours ago |
| Relative time for more than five minutes ago | DateTime.Now.AddMinutes(-6.25).ToRelativeDateString() | six minutes ago |
| Relative time for less than five minutes ago | DateTime.Now.AddMinutes(-2.5).ToRelativeDateString() | a few minutes ago |
| Relative time for within past minute | DateTime.Now.AddSeconds(-15).ToRelativeDateString() | less than a minute ago |
| Universal format for date in current year | DateTime.Now.ToUniversalFormat() | Monday, Nov 8 at 3:39 PM |
| Universal format for date in other year | var birthDate = new DateTime(2008, 9, 1 9, 45, 0); birthDate.ToUniversalFormat() | Monday, Sep 1, 2008 at 9:45 AM |
Read more...
How to know DataGridViewCheckBoxCell is checked or unchecked C#
Datagridview дээр checkbox ашиглахаар түүний чагтлагдсан эсэхийг мэдэхийн тулд доорхи кодыг ашиглана.
DataGridViewCheckBoxCell CbxCell = (DataGridViewCheckBoxCell)Datagridview1.Rows[rowIndex].Cells["Status"];
if ((bool)CbxCell.Value == true)
{
//Do stuff
}
else
{
//Do Stuff
}Мөн DBNULL байж болох учраас шалгахдаа дараах байдлаар бас шалгаж болно:
if (!DBNull.Value.Equals(CbxCell.Value) && (bool)CbxCell.Value == true)
{
//Do stuff
}
else
{
//Do Stuff
}Read more...