16,004,574 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Abhishek Jaiswall (Top 39 by date)
Abhishek Jaiswall
11-Sep-14 3:42am
View
what info u want ?
Abhishek Jaiswall
9-Sep-14 12:01pm
View
whatever i had written is enough for that question, I just need logic for my question.. Please suggest some.
Abhishek Jaiswall
9-Sep-14 12:00pm
View
Okay, got it, thanks!
now can you please give some relevant answer ?
Abhishek Jaiswall
9-Sep-14 11:58am
View
you mean to say i need to write it as
if (isWellIdExists(impexp.WellId) && isUploadedDateExists(impexp.UploadedDate))
{
int result = ExecuteQuery("UpdateImpExp");
}
else
{
int result = ExecuteQuery("InsertImpExpData",
SerialIDParameter,
WellIdParameter,
DateRecievedParameter,
DueDateParameter,
UploadedFootageParameter,
UploadedDateParameter,
PriorityParameter,
RemarkParameter);
}
Abhishek Jaiswall
5-Sep-14 13:09pm
View
yaa you are right!
Abhishek Jaiswall
29-Aug-14 5:17am
View
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
Abhishek Jaiswall
29-Aug-14 5:03am
View
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)
Abhishek Jaiswall
29-Aug-14 4:41am
View
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
Abhishek Jaiswall
29-Aug-14 4:24am
View
yeah, there was some other error, now its working fine. Thanks!
Abhishek Jaiswall
29-Aug-14 3:23am
View
Deleted
But its showing count 1 every time
its showing
DIFF
1
1
1
1
1
1
Abhishek Jaiswall
29-Aug-14 3:21am
View
Thanks Buddy! :)
Abhishek Jaiswall
29-Aug-14 0:02am
View
Still getting same error through this but, no worries. I have solved it my own. Thnks for your kind reply. #CHeers!
Abhishek Jaiswall
28-Aug-14 9:55am
View
I didn't get you!
Abhishek Jaiswall
28-Aug-14 9:54am
View
My datatype is date and dates are stored like this '3/3/12' ..
Abhishek Jaiswall
27-Aug-14 5:41am
View
Okay!
thanks :)
Abhishek Jaiswall
27-Aug-14 2:37am
View
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.
Abhishek Jaiswall
27-Aug-14 0:23am
View
I mean auto attach content on click.
(without using any upload or browse button)
Abhishek Jaiswall
26-Aug-14 9:05am
View
Thanks for your kind reply buddy, but i have solved it my own.
Abhishek Jaiswall
26-Aug-14 7:52am
View
I tried and defined IEmployeeRepository as public but still not working.
Abhishek Jaiswall
26-Aug-14 4:25am
View
Is code snippet mentioned in this link, going to auto add content in the mail?
Abhishek Jaiswall
26-Aug-14 2:43am
View
I hope now you will be getting my query!
Abhishek Jaiswall
26-Aug-14 2:42am
View
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.
Abhishek Jaiswall
23-Aug-14 1:44am
View
I want a simple scatter plot example using JSON data
Abhishek Jaiswall
23-Aug-14 1:44am
View
Yiu are right, buddy!
am looking for a sample example of Scatter plot using JSON data in it.
Abhishek Jaiswall
20-Aug-14 5:48am
View
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; });
});
Abhishek Jaiswall
18-Aug-14 14:08pm
View
What information you need to answer my query, please let me know ?
Abhishek Jaiswall
18-Aug-14 14:06pm
View
Its in MVc, and contains lots of coding files..
Abhishek Jaiswall
18-Aug-14 9:10am
View
Okay , thanks let me try this!
Abhishek Jaiswall
18-Aug-14 7:58am
View
it is in Home folder and spelling is correct.
Abhishek Jaiswall
18-Aug-14 5:47am
View
Hey!
okay :)
Abhishek Jaiswall
18-Aug-14 5:15am
View
I have solved this myself, meanwhile thanks! :)
Abhishek Jaiswall
18-Aug-14 4:51am
View
code is in C#
Abhishek Jaiswall
18-Aug-14 4:26am
View
No, i didn't get any helpful answer yet. Please suggest me how can i do that or give some reference URLs.
Thanks!
Abhishek Jaiswall
18-Aug-14 3:12am
View
Oops, sorry i want that in C#.
Abhishek Jaiswall
18-Aug-14 0:55am
View
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 ?'
Abhishek Jaiswall
17-Aug-14 23:50pm
View
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.
Abhishek Jaiswall
17-Aug-14 7:17am
View
what's that register script block?
Abhishek Jaiswall
17-Aug-14 7:14am
View
I want that in C#.
meanwhile thnks! :)
Abhishek Jaiswall
8-Aug-14 4:50am
View
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);
}
}
}
Show More