colModel: [
{
// سایر ستون‌ها
name: 'myac', width: 80, fixed: true, sortable: false,
resize: false, formatter: 'actions',
formatoptions: {
keys: true
}
}
], 
colModel: [
{
name: 'Id', index: 'Id', align: 'right', width: 70,
editable: false
},
{
name: 'Name', index: 'Name', align: 'right', width: 100,
editable: true, edittype: 'text',
editoptions: {
maxlength: 40
},
editrules: {
required: true
}
},
{
name: 'Supplier.Id', index: 'Supplier.Id', align: 'right', width: 110,
editable: true, edittype: 'select',
editoptions: {
dataUrl: '@Url.Action("SuppliersSelect","Home")'
},
editrules: {
required: true
}
},
{
name: 'Category.Id', index: 'Category.Id', align: 'right', width: 110,
editable: true, edittype: 'select',
editoptions: {
dataUrl: '@Url.Action("CategoriesSelect","Home")'
},
editrules: {
required: true
}
},
{
name: 'Price', index: 'Price', align: 'center', width: 100,
formatter: 'currency',
formatoptions:
{
decimalSeparator: '.',
thousandsSeparator: ',',
decimalPlaces: 2,
prefix: '$'
},
editable: true, edittype: 'text',
editrules: {
required: true,
number: true,
minValue: 0
}
},
{
name: 'myac', width: 80, fixed: true, sortable: false,
resize: false, formatter: 'actions',
formatoptions: {
keys: true
}
}
], public ActionResult SuppliersSelect()
{
var list = ProductDataSource.LatestProducts;
var suppliers = list.Select(x => new SelectListItem
{
Text = x.Supplier.CompanyName,
Value = x.Supplier.Id.ToString(CultureInfo.InvariantCulture)
}).ToList();
return PartialView("_SelectPartial", suppliers);
} @model IList<SelectListItem>
@Html.DropDownList("srch", Model) $('#list').jqGrid({
caption: "آزمایش چهارم",
//url from wich data should be requested
url: '@Url.Action("GetProducts","Home")',
//url for edit operation
editurl: '@Url.Action("EditProduct","Home")', [HttpPost]
public ActionResult EditProduct(Product postData)
{
//todo: Edit product based on postData
return Json(true);
} $('#list').navGrid(
'#pager',
//enabling buttons
{ add: true, del: true, edit: false, search: false },
//edit options
{},
//add options
{ width: 'auto', url: '@Url.Action("AddProduct","Home")' },
//delete options
{ url: '@Url.Action("DeleteProduct","Home")' }
); [HttpPost]
public ActionResult DeleteProduct(string id)
{
//todo: Delete product
return Json(true);
}
[HttpPost]
public ActionResult AddProduct(Product postData)
{
//todo: Add product to repository
return Json(true);
} var lastSel;
function inlineEdit() {
$('input[name=rdEditApproach]').attr('disabled', true);
$('#list').navGrid(
'#pager',
//enabling buttons
{ add: true, del: true, edit: false, search: false },
//edit options
{},
//add options
{ width: 'auto', url: '@Url.Action("AddProduct","Home")' },
//delete options
{ url: '@Url.Action("DeleteProduct","Home")' }
);
//add onSelectRow event to support inline edit
$('#list').setGridParam({
onSelectRow: function (id) {
if (id && id != lastSel) {
//save changes in row
$('#list').saveRow(lastSel, false);
lastSel = id;
}
//trigger inline edit for row
$('#list').editRow(id, true);
}
});
}; function formEdit() {
$('input[name=rdEditApproach]').attr('disabled', true);
$('#list').navGrid(
'#pager',
//enabling buttons
{ add: true, del: true, edit: true, search: false },
//edit option
{
width: 'auto', checkOnUpdate: true, checkOnSubmit: true,
beforeShowForm: function (form) {
centerDialog(form, $('#list'));
}
},
//add options
{
width: 'auto', url: '@Url.Action("AddProduct","Home")',
reloadAfterSubmit: false, checkOnUpdate: true, checkOnSubmit: true,
beforeShowForm: function (form) {
centerDialog(form, $('#list'));
}
},
//delete options
{
url: '@Url.Action("DeleteProduct","Home")', reloadAfterSubmit: false
})
.jqGrid('navButtonAdd', "#pager", {
caption: "حذف ردیف‌های انتخابی", title: "Delete Toolbar", buttonicon: 'ui-icon ui-icon-trash',
onClickButton: function () {
var idsList = jQuery("#list").jqGrid('getGridParam', 'selarrrow');
alert(idsList);
//jQuery("#list").jqGrid('delGridRow',idsList,{reloadAfterSubmit:false});
}
});
};
function centerDialog(form, grid) {
var dlgDiv = $("#editmod" + grid[0].id);
var parentDiv = dlgDiv.parent(); // div#gbox_list
var dlgWidth = dlgDiv.width();
var parentWidth = parentDiv.width();
var dlgHeight = dlgDiv.height();
var parentHeight = parentDiv.height();
var parentTop = parentDiv.offset().top;
var parentLeft = parentDiv.offset().left;
dlgDiv[0].style.top = Math.round( parentTop + (parentHeight-dlgHeight)/2 ) + "px";
dlgDiv[0].style.left = Math.round( parentLeft + (parentWidth-dlgWidth )/2 ) + "px";
} 
public static void RegisterRoutes(RouteCollection routes)
{
routes.IgnoreRoute("{resource}.axd/{*pathInfo}");
routes.Add(
new Route("{controller}.aspx/{action}/{id}", new MvcRouteHandler())
{
Defaults = new RouteValueDictionary(new
{
controller = "Home",
action = "Index",
id = UrlParameter.Optional
})
});
Right-click on a web site -> Properties -> Home Directory tab -> click on the Configuration button -> Mappings tab
C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\aspnet_regiis.exe /i
public class SourceType1 //poco class
{
public string Name
public string JobTitle
public string PetsName
}
public class SourceType2
{
public string BankName
public decimal CreditCardBalance
public DateTime SignupDate
}
public class Destination
{
public string Job
public string Balance //thousand seprator
}
var container = BootstrapContainer(); var finder = container.Resolve<IDuplicateFinder>(); var processor = container.Resolve<IArgumentsParser>(); Execute( args, processor, finder ); container.Dispose();
public class ExampleClass
{
private readonly IService _service;
public ExampleClass()
{
_service = Container.Resolve<IService>();
}
public void DoSomething(int id)
{
_service.DoSomething(id);
}
}public class ExampleClass
{
private IService _service;
public ExampleClass(IService service)
{
_service = service;
}
public void DoSomething(int id)
{
_service.DoSomething(id);
}
}public class Search
{
IDinner _dinner;
public Search(): this(new Dinner())
{ }
public Search(IDinner dinner)
{
_dinner = dinner;
}
}string query = @"SELECT * FROM USER_PROFILE
WHERE LOGIN_ID = '"+loginId+@"' AND PASSWORD = '"+password+@"'";
protected void btnSearch_Click(object sender, EventArgs e)
{
String cmd = @"SELECT [CustomerID], [CompanyName], [ContactName]
FROM [Customers] WHERE CompanyName ='" + txtCompanyName.Text
+ @"'";
SqlDataSource1.SelectCommand = cmd;
GridView1.Visible = true;
}
SqlCommand cmd = new SqlCommand("SELECT UserID FROM Users WHERE UserName=@UserName AND Password=@Password");
cmd.Parameters.Add(new SqlParameter("@UserName", System.Data.SqlDbType.NVarChar, 255, UserName));
cmd.Parameters.Add(new SqlParameter("@Password", System.Data.SqlDbType.NVarChar, 255, Password));
dr = cmd.ExecuteReader();
if (dr.Read()) userId = dr.GetInt32(dr.GetOrdinal("UserID"));
var products = from p in db.products
where p.description.StartsWith(_txtSearch.Text)
select new
{
p.description,
p.price,
p.stock
};
exec sp_executesql N'SELECT [t0].[description], [t0].[price], [t0].[stock]
FROM [dbo].[products] AS [t0]
WHERE [t0].[description] LIKE @p0',N'@p0 varchar(5)',@p0='sony%'
db.Log = Console.Out;
public bool Validate(string loginId, string password)
{
DataClassesDataContext db = new DataClassesDataContext();
var validUsers = from user in db.USER_PROFILEs
where user.LOGIN_ID == loginId
&& user.PASSWORD == password
select user;
if (validUsers.Count() > 0) return true;
else return false;
}
SELECT [t0].[LOGIN_ID], [t0].[PASSWORD]
FROM [dbo].[USER_PROFILE] AS [t0]
WHERE ([t0].[LOGIN_ID] = @p0) AND ([t0].[PASSWORD] = @p1)
string sql = "select * from Trade where DealMember='" + this.txtParams.Text + "'";
var trades = driveHax.ExecuteQuery<Trade>(sql);
IEnumerable<Customer> results = db.ExecuteQuery<Customer>(
"SELECT contactname FROM customers WHERE city = {0}", "Tehran");
.UseStartup<Startup>()
{
"MVC Action": {
"prefix": "mvcAction",
"body": [
"public IActionResult ${1:ActionName}()",
"{",
" $0 ",
" return View();",
"}"
],
"description": "Creates a simple MVC action method."
}
} 
<PackageReference Include="DNTPersianUtils.Core" Version="2.2.0" />
> dotnet add package DNTPersianUtils.Core
<ItemGroup>
<DotNetCliToolReference Include="Microsoft.DotNet.Watcher.Tools" Version="1.0.0" />
</ItemGroup> >dotnet watch run ?[90mwatch : ?[39mStarted Hosting environment: Production Content root path: D:\vs-code-examples\FirstAspNetCoreProject Now listening on: http://localhost:5000 Application started. Press Ctrl+C to shut down.
در صورت نصب ابزارهای جدید که توسط فریم ورک دات نت 3.5 پشتیبانی می‌شوند نیاز است این فریم ورک را نصب نماید از جمله این برنامه‌ها که در زمان نصب شما را ملزم به نصب نسخه دات نت 3.5 خواهند کرد SQL Server Manangement Studio و ... خواهند بود. عمدتا دو راه موجود است...
mysite.com/reporting
using System.ComponentModel.DataAnnotations;
namespace SampleProject.Models
{
public class Channel
{
public string ChannelTitle { get; set; }
[Required]
public string ChannelUrl { get; set; }
}
} using System.Collections.Generic;
namespace SampleProject.Models
{
public static class ChannelDataSource
{
static ChannelDataSource() => Channels = new List<Channel>();
public static List<Channel> Channels { get; private set; }
public static void Add(Channel channel) => Channels.Add(channel);
}
} using SampleProject.Models;
using System.Linq;
using System.Web.Mvc;
namespace SampleProject.Controllers
{
public class ChannelController : Controller
{
// GET: Channel
public ActionResult Index()
{
var channels = ChannelDataSource.Channels;
return View(channels);
}
public ActionResult Channel(string channelUrl)
{
if (string.IsNullOrWhiteSpace(channelUrl))
{
return new HttpNotFoundResult("channel not found!");
}
var channel = ChannelDataSource.Channels.SingleOrDefault(ch => ch.ChannelUrl == channelUrl.ToLower());
if (channel == null)
{
return new HttpNotFoundResult("channel not found!");
}
return View(channel);
}
public ActionResult Create() => View();
[HttpPost]
[ValidateAntiForgeryToken]
public ActionResult Create(Channel channel)
{
if (!ModelState.IsValid)
{
ModelState.AddModelError(string.Empty, "Please check your inputs!");
return View(channel);
}
ChannelDataSource.Add(channel);
TempData["Message"] = "Channel added successfully!";
return RedirectToAction(nameof(Index));
}
}
} using System.Web.Mvc;
using System.Web.Routing;
namespace SampleProject
{
public class RouteConfig
{
public static void RegisterRoutes(RouteCollection routes)
{
routes.IgnoreRoute("{resource}.axd/{*pathInfo}");
routes.MapRoute(
name: "ChannelUrls",
url: "{channelurl}",
defaults: new { controller = "Channel", action = "Channel", id = UrlParameter.Optional }
);
routes.MapRoute(
name: "Default",
url: "{controller}/{action}/{id}",
defaults: new { controller = "Channel", action = "Index", id = UrlParameter.Optional }
);
}
}
} using System.Collections.Generic;
using System.Linq;
using System.Web.Routing;
namespace SampleProject.Models
{
public static class Utility
{
public static List<string> GetAllAreaNames()
{
var areaNames = RouteTable.Routes.OfType<Route>()
.Where(d => d.DataTokens != null)
.Where(d=> d.DataTokens.ContainsKey("area"))
.Select(r => r.DataTokens["area"].ToString().ToLower())
.ToList();
return areaNames;
}
}
} using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Web.Mvc;
using SampleProject.Models;
namespace SampleProject.CustomValidators
{
public class CheckForAreaExisting : ValidationAttribute, IClientValidatable
{
public List<string> AreaNames
{
get
{
return Utility.GetAllAreaNames();
}
}
public IEnumerable<ModelClientValidationRule> GetClientValidationRules(ModelMetadata metadata, ControllerContext context)
{
var rule = new ModelClientValidationRule
{
ValidationType = "checkforareaexisting",
ErrorMessage = FormatErrorMessage(metadata.GetDisplayName())
};
rule.ValidationParameters.Add("areanames", string.Join(",", AreaNames));
yield return rule;
}
public override bool IsValid(object value)
{
if (value != null)
{
return Utility.GetAllAreaNames()
.SingleOrDefault(area => area == value.ToString().ToLower()) == null;
}
return true;
}
}
} jQuery.validator.addMethod("checkforareaexisting",
function (value, element, param) {
var isValueOneOfTheAreaNames = $.inArray(value.toLowerCase(), param.areaNames) === -1;
return isValueOneOfTheAreaNames;
});
$.validator.unobtrusive.adapters.add('checkforareaexisting', ['areanames'], function (options) {
options.rules['checkforareaexisting'] = { areaNames: options.params.areanames.split(',') };
options.messages['checkforareaexisting'] = options.message;
}); <!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width" />
<title>_Layout</title>
<style>
</style>
</head>
<body>
<div>
@RenderBody()
</div>
<script src="~/Scripts/Jquery.js"></script>
<script src="~/Scripts/jquery.validate.min.js"></script>
<script src="~/Scripts/jquery.validate.unobtrusive.min.js"></script>
<script src="~/Scripts/CustomValidation.js"></script>
</body>
</html> using SampleProject.CustomValidators;
using System.ComponentModel.DataAnnotations;
namespace SampleProject.Models
{
public class Channel
{
public string ChannelTitle { get; set; }
[Required]
[CheckForAreaExisting(ErrorMessage = "You can't use this url for your channel!")]
public string ChannelUrl { get; set; }
}
} [HttpPost]
public ActionResult CheckForAreaExisting(string channelUrl)
{
var isValueOneOfTheAreaNames = Utility.GetAllAreaNames()
.SingleOrDefault(area => area == channelUrl.ToLower()) == null;
return Json(isValueOneOfTheAreaNames);
} using System.ComponentModel.DataAnnotations;
using System.Web.Mvc;
namespace SampleProject.Models
{
public class Channel
{
public string ChannelTitle { get; set; }
[Required]
[Remote("CheckForAreaExisting", "Channel",
ErrorMessage = "You can't use this url for your channel!",
HttpMethod = "Post")]
public string ChannelUrl { get; set; }
}
}