|
You need a full install of Visual Studio. What version do you have?
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
jQuery Datatable using webservice
Published: September 04, 2010 By Sumit Dutta
Visited: 4918
In this article I will explore how to prepare datatable using jQuery and webservice. Webservice will return data as JSON which will be binded to jQuery Datatable.
jQuery DataTable
Let's see how we can do this:
Step 1: Download jQuery 1.4.2 and jQuery Datatable
Step 2: Add jquery-1.4.2.min.js and jquery.dataTables.min.js in the page
<script src="jquery-1.4.2.min.js" type="text/javascript"></script>
<script src="jquery.dataTables.min.js" type="text/javascript"></script>
Step 3: Add the below style in the page.
.myGrid
{
width: 100%;
margin: 0px 0 0px 0;
border: solid 1px #525252;
border-collapse: collapse;
width: 600px;
}
.myGrid td
{
padding: 2px;
border: solid 1px #c1c1c1;
color: Black;
font-family: Arial,Helvetica,sans-serif;
font-size: 0.9em;
width:40px;
}
.myGrid th
{
color: #fff;
background: url(images/grid_header.png) repeat-x top;
font-family: Arial,Helvetica,sans-serif;
font-size: 0.9em;
}
Step 4: Add below html content inside body tag
By
Recipie Name
Preparation Time
Cooking Time
Loading....
Step 5: Add below javascript in the page.
<script language="javascript" type="text/javascript">
$(document).ready(function() {
function renderTable(result) {
var dtData = [];
$.each(result, function() {
dtData.push([
this.by,
this.Recipiename,
this.preparationtime,
this.cookingtime
]);
});
$('#grid').dataTable({ //grid is the id of the table
'aaData': dtData,
'bPaginate': false,
'bInfo': false,
'bFilter': false
});
}
$.ajax({
type: "GET",
url: "JsonWebService.asmx/GetRecipie",
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function(response) {
renderTable(response.d);
},
failure: function(errMsg) {
$('#errorMessage').text(errMsg); //errorMessage is id of the div
}
});
});
</script>
Step 6: Create an asmx file and create below class.
public class Recipie
{
public string by;
public string Recipiename;
public string preparationtime;
public string cookingtime;
}
Step 7: Add below name space in the asmx.cs file
using System.Web.Script.Services;
using System.Data;
using System.Data.SqlClient;
Step 8: Create below webmethod in the asmx.cs file to get data from database and return List to jQuery
[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Json, UseHttpGet = true)]
public List GetRecipie()
{
string strQuery = "SELECT * FROM Recipie";
DataTable dtRecipie = null;
Recipie objRecipie;
SqlConnection con = GetConnection("Data Source=(local);Initial Catalog=DataTable;Integrated Security=SSPI");
using(con)
{
con.Open();
using (SqlDataAdapter sqlAdapter = new SqlDataAdapter(strQuery, con))
{
dtRecipie = new DataTable();
sqlAdapter.Fill(dtRecipie);
}
}
List drlist = new List();
foreach (DataRow row in dtRecipie.Rows)
{
objRecipie = new Recipie();
objRecipie.by = row["by"].ToString();
objRecipie.Recipiename = row["Recipiename"].ToString();
objRecipie.preparationtime = row["preparationtime"].ToString();
objRecipie.cookingtime = row["cookingtime"].ToString();
drlist.Add(objRecipie);
}
return drlist;
}
Step 9 : Add below method to get SqlConnection
private SqlConnection GetConnection(string m_conString)
{
SqlConnection con = new SqlConnection(m_conString);
return con;
}
This ends the article of creating datatable using jquery and webservice.
|
|
|
|
|
Seriously? This forum is for asking questions, not posting code blocks. Besides, even if you posted this as an article it would fail as it's just a code dump.
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
modified 19-Apr-12 11:31am.
|
|
|
|
|
Hi All,
I need a open source solution to open pdf file in web browser and draw a line then store into same pdf file. Please suggest your views.
Thanks in advance
|
|
|
|
|
Manipulate (Add/Edit) PDF using .NET[^].
Presumably you didn't bother to search for yourself.
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
Thanks for the reply, but our team not able to find a control to edit pdf on web page. We appropriate if you provide a weblink.
|
|
|
|
|
I am using Jquery to delete rows from gridview. I can get record ID but in order to hide a row I need to know row_id
$(this).parents("#.record");. It's always empty. Why? my grid inside wizard control and masterpage.
... $("#.delterm").click(function () {
var record_id = $(this).attr("id");
var tr_id = $(this).parents("#.record");....
modified 18-Apr-12 8:58am.
|
|
|
|
|
How would any of us know why it is empty? We cannot see your code. Just use "View Source" in the browser, check to find the correct ID, then use jQuery to find it using the correct ID.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
|
Good for you. Now go away and research other career options. Something that doesn't require much thought or effort. You seem to be good at that.
Failure is not an option; it's the default selection.
|
|
|
|
|
|
Please do not ask for urgent help. It is rude. This is a volunteer site.
Have you tried using the datepicker control from the AjaxControlToolkit? Start with that since it is already built.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Use Simple AJAX Control Toolkit CalendarExtender control...and put the TargetControlProperty as the ID of TextBox where you need the Date
- Happy Coding -
Vishal Vashishta
|
|
|
|
|
How a web page looks similar (web page contains div tags, css) in all browsers(e.g IE, CHROME etc)?
|
|
|
|
|
you need to program it such a way that it is compatible all main browsers
|
|
|
|
|
Is this a question? If you want your page to look similar in all browsers just follow standard HTML and CSS practices.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Is it possible to restrict the user from changing virtual directory name while installing a web application using a web setup?
Regards
|
|
|
|
|
A side point, your code should not care what the virtual directory name is so you may want to look at how you are doing things instead.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
but this is a typical scenario....
|
|
|
|
|
Quote: but this is a typical scenario....
What is? Restricting people from changing the directory name? It isn't in my experience. It may be in yours but I am not sure how to restrict that.
However, my point still stands, your code should not care what the virtual directory name is. Unless there is some real specific reason to, your code should reference paths using ~ for .net controls, etc.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
It's been awhile, but in the properties some where (F4), you can turn off the virtual directory input so it doesn't show during installation.
But I don't see the point in that. Are you going to set it for them?
That installation program is old school and out of date, and only works with metadata and IIS 6 compatibility and management installed with IIS 7+.
|
|
|
|
|
At last I have found this. Just removing installation folder node from user interface editor will do this for us.
Thanks for your support.
Regards
Sebastian
|
|
|
|
|
Oh, you found it finally, You would never know that it was there unless someone tells you, I could not remember the name of the property.
|
|
|
|
|
 Yes. Thanks for your time. 
|
|
|
|
|
Trying to see which ad hoc reporting tool is best for me and my company.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
