Comments by Abhishek Jaiswall (Top 39 by date)

Here's a query
with single operation, in place of one condition of sorting data I want several but only 1 condition gets applied at a time

SELECT
--COUNT(DIFF)
Count(DATEDIFF(D, MinDate, MaxDate)/30) AS DIFF

FROM (
SELECT

MAX(TDate) AS MaxDate,
MIN(TDate) AS MinDate
FROM EDATA

Where ID>2

GROUP BY TCard
)a
Group by DATEDIFF(D, MinDate, MaxDate)/30

I applied just 1 condition as,
SELECT
--COUNT(DIFF)
Count(DATEDIFF(D, MinDate, MaxDate)/30) AS DIFF

FROM (
SELECT

MAX(TDate) AS MaxDate,
MIN(TDate) AS MinDate
FROM EDATA

Where ID>2

GROUP BY TCard
)a
Group by DATEDIFF(D, MinDate, MaxDate)/30

now what if i want to apply many conditions. and sort data according to 1 condition like name, age, gender etc. (1 condition at a time)

I have one more question,
if i want to apply some more functionality(query operations) in that query for some extended functionality, then in case where am suppose to use WHERE clause (conditions can be several).
like if i want to sort data before doing date difference operation on the basic of Name, gender etc. from that

yeah, there was some other error, now its working fine. Thanks!

Thanks Buddy! :)

Still getting same error through this but, no worries. I have solved it my own. Thnks for your kind reply. #CHeers!

I didn't get you!

My datatype is date and dates are stored like this '3/3/12' ..

Okay!
thanks :)

explanation: Suppose i have website (contains blog) and there is a Email option after every blog. So if someone click on Email option then the content of that blog gets automatically gets attached with email. content can be a image file, pdf, doc anything.
I want to know how to do that using C# ASP.NET.
I hope now you will be getting my query.
Thanks.

I mean auto attach content on click.
(without using any upload or browse button)

Thanks for your kind reply buddy, but i have solved it my own.

I tried and defined IEmployeeRepository as public but still not working.

Is code snippet mentioned in this link, going to auto add content in the mail?

I hope now you will be getting my query!

My question is-
how to attach content to the mail automatically.
explanation: Suppose i have website (contains blog) and there is a mail option after every blog. So if some click on mail option then the content of that blog gets auto attached with email. content can be a image file, pdf, doc anything.
I want to know how to do that using C# ASP.NET.

I want a simple scatter plot example using JSON data

Yiu are right, buddy!
am looking for a sample example of Scatter plot using JSON data in it.

I tried this but its not displaying anything (neither chart nor its responsiveness)

<script src="http://d3js.org/d3.v3.min.js" type="text/javascript"></script>
<div id="chart-container"></div>
<link rel="Stylesheet" href="../../Content/Chart-Container.css" />

<script>
$(function(){
var json = [
{ "EmpID": 1, "Salary": 21 },
{ "EmpID": 2, "Salary": 12 },
{ "EmpID": 3, "Salary": 11 },
{ "EmpID": 4, "Salary": 15 },
{ "EmpID": 5, "Salary": 14 },
{ "EmpID": 6, "Salary": 19 },
{ "EmpID": 7, "Salary": 16}]

var $container = $('.chart-container'),
width = $container.width(),
height = $container.height(),
x = d3.scale.linear()
.domain([0, d3.max(json, function (d) { return d.Salary; })])
.range([0, width]);
y = d3.scale.ordinal().domain(d3.range(json.length))
.rangeBands([0, height], 0.1);

svg = d3.select('.chart-container')
.append("svg")
.attr("width", '100%')
.attr("height", '100%')
.attr('viewBox', '0 0 ')
.attr('preserveAspectRatio', 'xMinYMin')
.append("g")
.attr("transform", "translate(20,0)");

// Definig color Property
var color = d3.scale.ordinal()
.range(["#98abc5", "#8a89a6", "#7b6888", "#6b486b", "#a05d56", "#d0743c", "#ff8c00"]);

// for Values rep
var bars = svg.selectAll(".bar")
.data(json)
.enter().append("g")
.attr("class", "bar")
.attr("transform", function (d, i) { return "translate(" + 0 + "," + y(i) + ")"; });

bars.append("rect")
.attr("fill", function (d, i) { return color(i); })
.attr("width", function (d) { return x(d.Salary); })
.attr("height", y.rangeBand());

bars.append("text")
.attr("x", function (d) { return x(d.Salary); })
.attr("y", 0 + y.rangeBand() / 2)
.attr("dx", -18)
.attr("dy", ".35em")
.attr("text-anchor", "end")
.text(function (d) { return d.Salary; });
});

What information you need to answer my query, please let me know ?

Its in MVc, and contains lots of coding files..

Okay , thanks let me try this!

it is in Home folder and spelling is correct.

Hey!
okay :)

I have solved this myself, meanwhile thanks! :)

code is in C#

No, i didn't get any helpful answer yet. Please suggest me how can i do that or give some reference URLs.
Thanks!

Oops, sorry i want that in C#.

I can write Sqldatasource on codebehind or on webconfig file too right! What I want to know is what does that means- 'Add register script block on aspx page ?'

I have a data table stored in my sql server and i wanna convert it into JSON for creating a chart from the JSON data(using D3JS). but for now I only want to convert sql server data into JSON.
suppose my table name is salary (EmpName, Salary) now my query is how to parse this data table into JSON for further use.

what's that register script block?

I want that in C#.
meanwhile thnks! :)

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Data;
using System.Data.Entity;

namespace CRUDs.Controllers
{
public class EmployeeController : Controller
{
private CRUDsEntities db = new CRUDsEntities();
//
// GET: /Employee/

public ActionResult Index()
{
return View(db.Employees.ToList());
}

//
// GET: /Employee/Details/5

public ActionResult Details(string id = null)
{
// Employee Emp = db.Employees.Find(id);
var Emp = (from E in db.Employees where E.EmployeeId == id select E);
if (Emp == null)
{
// return HttpNotFound();
}
return View(Emp);
}

//
// GET: /Employee/Create

public ActionResult Create()
{
return View();
}

//
// POST: /Employee/Create

[HttpPost]
[ValidateAntiForgeryToken]
public ActionResult Create(Employee Emp)
{
try
{
// TODO: Add insert logic here

if (ModelState.IsValid)
{
db.Employees.Add(Emp); // ObjectSet
db.SaveChanges();
return RedirectToAction("Index");
}
}
catch
{
return View(Emp);
}
}

//
// GET: /Employee/Edit/5

public ActionResult Edit(string id = null)
{
// Employee Emp = db.Employees.Find(id);
var Emp = (from E in db.Employees where E.EmployeeId == id select E);
if (Emp == null)
{
// return HttpNotFound();
}
return View(Emp);
}

//
// POST: /Employee/Edit/5

[HttpPost]
[ValidateAntiForgeryToken]
public ActionResult Edit(Employee Emp)
{
try
{
// TODO: Add update logic here

if (ModelState.IsValid)
{
db.Entry(Emp).State = EntityState.Modified; // ObjectSet
db.SaveChanges();
return RedirectToAction("Index");
}
}
catch
{
return View(Emp);
}
}

//
// GET: /Employee/Delete/5

public ActionResult Delete(String id = null)
{
// Employee Emp = db.Employees.Find(id);
var Emp = (from E in db.Employees where E.EmployeeId == id select E);
if (Emp == null)
{
// return HttpNotFound();
}
return View(Emp);
}

//
// POST: /Employee/Delete/5

[HttpPost, ActionName("Delete")]
[ValidateAntiForgeryToken]
public ActionResult DeleteConfirmed(String id)
{
try
{
// TODO: Add delete logic here

// Employee Emp = db.Employees.Find(id);
var Emp = (from E in db.Employees where E.EmployeeId == id select E);
db.Employees.Remove(Emp); // ObjectSet
db.SaveChanges();
return RedirectToAction("Index");
}
catch
{ }
}

protected override void Dispose(bool disposing)
{
db.Dispose();
base.Dispose(disposing);
}
}
}