jQuery Datatable using webservice - ASP.NET Discussion Boards

Hi,

I have downloaded the abcpdf, but all its examples are saying about AddImage method. It takes the url, but I already have html string that has to be converted in to pdf.

In that situation how can I use that string to generate my pdf file.

Thanks,
Abdul

Thanks & Regards,

Abdul Aleem Mohammad
St Louis MO - USA

Its doable with abcpdf. But i don't remember the exact code. Can you please refer there help, which will be automatically installed.

SQL

I have a C# web form 2010 application that I obtained from a contract shop that wrote this application for my small company.  it is now my job to support this application.  I can get the application to execute from my visual studio.net 2010 professional ide. However my problem is the project file that contains the 'web' component is unavailable to me? i know the files are there since I can see the code through windows explorer.

 Thus can you tell me what I need to do so I can open the 'unavailable' files in the visual studio.net 2010 ide?

jassiedog wrote:
However my problem is the project file that contains the 'web' component is unavailable to me?

Could you rephrase the question, and provide a little more detail, What is the web component?

If it says the files are unavailable it means that they are not there: the contract shop has not supplied them by the sound of it.

"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

Looks like the shop does not give you the web part of Visual Studio 2010.

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 () {
                  //Get the Id of the record to delete
                  var record_id = $(this).attr("id");
                  //Get the GridView Row reference
                  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.

i need now, urgent

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.

Following Links ay help you:

http://www.w3schools.com/aspnet/control_calendar.asp[^]

DateTimePicker Web Control[^]

http://www.c-sharpcorner.com/uploadfile/puranindia/calendar-control-in-Asp-Net/[^]

Happy Coding... Smile | :)

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....