Code:
[ScriptService]
public partial class Default2 : System.Web.UI.Page
{
[WebMethod]
[ScriptMethod(UseHttpGet = true, ResponseFormat = ResponseFormat.Json)]
public static string GetStudent()
[code]....
And this is my HTML.What I'm trying to do is populate the JQuery DataTable using the returned JSON Formated data of the WebMethod. But its not working,
I have a 2007 excel addin app (VS2005) which calls a web service (also developed in VS2005). When the webservice returns a large amount of data I get the following exception
System.InvalidOperationException: There is an error in XML document (1, 14493956). ---> System.Xml.XmlException: ' ', hexadecimal value 0x1C, is an invalid character. Line 1, position 14493956.
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
[code]...
I know how to call a simple old fashion asmx webservice webthod that returns a single value as a function return result. But what if I want to return multiple output params? My current approach is to separate the params by a dividing character and parse them on teh client. Is there a better way.
Here's how I return a single function result. How do I return multiple output values?
<asp:ScriptManager ID="ScriptManager1" runat="server">
<Services>
<asp:ServiceReference Path="WebService.asmx" />
[code]....
I have as script that runs a stored procedure to fetch a comment along with it's id. There are multiple comments and I want to display them but I am having problem with display all the records. Here is my code:
Using con
Using sda As New SqlDataAdapter()
Try
cmd.Connection = con
Catch ex As Exception
Response.Write("Error" & ex.Message)
[code]...
How do I make it so that the returned results will be like this:
6 First Comment
7 Second Comment
I have a simple web method written in the code-behind (not a separate asmx) of a test aspx page.
All it does is return a DataTable(or DataSet) both are failing, gives a blank 500 error saying "There was an error processing the request"
If I switch the return variable type to String, it works fine
I think my issue has to do with the version of the System.Web.Extensions, is that the assembly that actually contains the JSON communication implementation?
I've read all kinds of tutorials about how it should be possible to return the DataTable to javascript and then read the properties with javascript syntax.
For some reason it isn't working for me.
My web extensions is imported through my web.config with the following version
<add
assembly="System.Web.Extensions,
Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
(function () {
var linechartResize;
linechartResize = function () {
$("#linechart-2").sparkline([160, 240, 250, 280, 300, 250, 230, 200, 280, 380, 400, 360, 300, 220, 200, 150, 100, 100, 180, 180, 200, 160, 220, 140], {
type: "line",
width: "100%",
height: "226",
[Code] ....
In the above javaScript function i am supplying numeric array . I want those values from C# method which gets the those values from database....
can datatable pass to web service as input parameter? i have a scenario to pass values as datatable to web service. eg as follows
when Invoice or Bill is entered, I want to send the entered data as datatable to web service to insert into another application.
How do I run a webmethod with jQuery. Asp.Net
the method load it the GridView
[WebMethod]
public void GetGrid()
{
DataProviderDataContext db = new DataProviderDataContext();
GridView1.DataSource = db.Employees.ToList();
GridView1.DataBind();
[code]...
I'm trying to populate a drop down list from a datatable. Is this correct way of doing it?
public ViewResult Index()
{
ViewData["CampaignList"] = List;
return View();
}
public IEnumerable<SelectListItem> List
{
get
{
DataTable dt = CampaignRow.GetList(DB, 100, true);
List<SelectListItem> list = new List<SelectListItem>();
foreach (DataRow row in dt.Rows)
{
list.Add(new SelectListItem
{
Text = Convert.ToString(row["CampaignName"]),
Value = Convert.ToString(row["CampaignId"]),
});
}
return list;
}
}
how can i stylize drop down list? how can i add an empty first value ie "select campaign"
This is my GET Method to get my data from my DataTable
Private Function GetData() As PagedDataSource
' Declarations
Dim dt As New DataTable
Dim dr As DataRow
Dim pg As New PagedDataSource
' Add some columns
dt.Columns.Add("Column1")
dt.Columns.Add("Column2")
' Add some test data
For i As Integer = 0 To 10
dr = dt.NewRow
dr("Column1") = i
dr("Column2") = "Some Text " & (i * 5)
dt.Rows.Add(dr)
Next
' Add a DataView from the DataTable to the PagedDataSource
pg.DataSource = dt.DefaultView
' Return the DataTable
Return pg
End Function
It returns the DataTable as "pg"
What changes must I make to this GET method to get the records from a table in my database?
C# examples will also do but would be great to see a reply with my code and then the changes....
I cannot call webmethod from jquery. I think its about web.config file. How can i set web.config file for web services and webmethod?
View 1 RepliesI have a table say, Student.
I have a class 'Student'.
I want to populate IList<Student> with objects of Student class from Student table in database.
Is it possible to implement this?
If yes then how to implement this.
I have a Data table object that is populated with a sql call. The table has two columns in int. "CustId" and CustomerName"
using C# in the code behind, how can I populate my drop down list box in C# using the DataTable object?
My code looks something like this, but it does not work.
DataTable MyTable=PopulateTable(); // method call
customerDropDownListBox.DataSource=MyTable;
How to populate google charts using ASP.NET Dataset/Datatable
View 1 RepliesI have a DropDownList and I want to populate using a DataTable.
[Code]....
But when appear the DropDownList show System.Data.DataRow why this don't show the real result of the DataTable ?
This is what i want to do with my website. I want to pull data from an access query and and load it into a listview table. The user will sort through the data on the website and remove the rows she doesn't want. After the user is done, they will click a send button that will email the data to the appropriate party.I have read the access query data into a data table. I have the list view table built, but I am unsure how bind the data table into the listview table. Is this the best route to go? Will binding the datatable to the listview table allow the user to delete rows out of the datatable?
Protected Sub btnView_Click(sender As Object, e As System.EventArgs) Handles btnView.Click
Dim query As New QueryBuilder.SelectQuery("qryVendorReport")
'Fill data table with vendor information
Dim sample As String = ""
Dim results As New DataTable
results = (db.fillTable(query.toSelectQuery))
[code]...
how to bind the results datatable to lvdatasource. I tried a few different ways to do this with no luck. Maybe the syntax I trying to use is incorrect.
I am using a webform and trying to use a $.ajax call a webmethod on my code behind to format and return some data. It sounded easy but I need the help of an expert. Here is what I have and perhaps someone could steer me in the right direction to solving this problem. for the time being all I want the [webmethod] to return is some dummy data so the jqgrid displays, after I get it displaying correctly I will work on the data column format. So for this sample to work correctly user would open web from and click on button "Load Grid" when this is clicked it calls the the [webmethod] on the server, the sever then gets the data and passes it back to the jquery .ajax call and then it gets loaded into the jqGrid.
[Code]....
and the codebehind
[Code]....
I am trying to implement your code in "Calling ASP.Net WebMethod using jQuery AJAX", but the alert is giving me the value "Undefined".
I believe my website (asp.net c#) is not correctely configured for webmethods.
My problem is that I have a jqury function basically I want to add gridview row into data base .so that pupose I am doing that by accessing webmethod ,but the web method can’t call from that code .
My data can’t save into data base I will check it.value should be passed but problem is that this function can’t call webmethod I will check it doing debudg.
my function should be call webmethod
Following my code
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js" type="text/javascript"> </script>
<script type="text/javascript">
$(function () {
[Code].....
I have created the templatefields in my dynamically created gridview, however, how do i get the values from my dataTable (which populates my gridview) to load into the templatefields I have created?
View 1 Repliesmy page Evaluation.aspx has this code
[Code]....
and I am calling the webmethod by javascript like this
[Code]....
The result is, I get the error function running and I get "undefined error" alert.Am I calling the procedure correctly? I put a breakpoint on the webmethod and it.
I am new to jqGrid and I have found it difficult to follow the documentation jqGrid Documentation / I cannot figure out how to call a WebMethod when setting up the JQGrid. I have been successful in making an Ajax call to get the data and then setting up the JQGrid with local data. I think its an extra step in the setup process and that I should be able to provide the path to the webmethod using the url property. The editurl property is the same way. I am never actually receiving the post to the server. Attempted JQGrid Setup
function GetData()
{
$('#list').jqGrid({
type: "POST",
url: "Default.aspx/GetUsersJSON",
datatype: "json",
height: 250,
colName: ['Username', 'Email'],
colModel: [
...
}).jqGrid(
'navGrid',
'#pager',
{
edit: true,
add: true,
del: true
});
}
WebMethod
[WebMethod]
public static string GetUsersJSON()
{
var users = new List();
using(UserAdministrationSandboxDataContext uasd = new UserAdministrationSandboxDataContext())
{
users = uasd.GetUserList();
}
JavaScriptSerializer serializer = new JavaScriptSerializer();
return serializer.Serialize(users);
}
Current Code I got it working correctly now, but I still have one final question. Why did I have to set the 'repeatitems: false' in order to display the content? Some of the caveats to get this to work include the different ways to setup the ajax request. (Ajax: type) is (jqgrid : mtype) (Ajax: contentType) is (jqgrid : ajaxGridOptions: { contentType: })
And finally understanding the documentation from the documentation on how to setup the JSONReader.
function GetUserDataFromServer()
{
$('#list').jqGrid({
url: "Default.aspx/GetUsersJSON",
mtype: 'POST',
ajaxGridOptions: { contentType: "application/json" },
datatype: "json",
serializeGridData: function (postData)
{
return JSON.stringify(postData);
},
jsonReader: {
root: function (obj) { return obj.d; },
page: function (obj) { return 1; },
total: function (obj) { return 1; },
records: function (obj) { return obj.d.length; },
id:'0',
cell:'',
repeatitems: false
},
datatype: "json",
height: 250,
colName: ['Username', 'Email'],
colModel: [
{
name: 'Username',
index: 'Username',
width: 100,
editable: true
},
{
name: 'Email',
index: 'Email',
width: 220,
editable: true
},
{
name: 'IsLockedOut',
index: 'IsLockedOut',
width: 100,
editable: true,
edittype: 'checkbox'
}
],
caption: "Users"
})
}
Web Method
[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Json)]
public static List GetUsersJSON()
{
using (UserAdministrationSandboxDataContext uasd = new UserAdministrationSandboxDataContext())
{
return uasd.GetUserList();
}
}
One JSON Object from the List
{"__type":"UserAdministrationSandbox.UserData","PKID":"00000000-0000-0000-0000-000000000001","Username":"TestUser","ApplicationName":"Test","Email":"TestUser@test.com","Comment":"TestUser","Password":"D41D8CD98F00B204E9800998ECF8427E","PasswordQuestion":"Is this a blank Password?","PasswordAnswer":null,"IsApproved":true,"LastActivityDate":"/Date(1298869200000)/","LastLoginDate":"/Date(1298869200000)/","LastPasswordChangedDate":"/Date(1298869200000)/","CreationDate":"/Date(1298869200000)/","IsOnLine":false,"IsLockedOut":false,"LastLockedOutDate":"/Date(1298869200000)/","FailedPasswordAttemptCount":0,"FailedPasswordAttemptWindowStart":null,"FailedPasswordAnswerAttemptCount":null,"FailedPasswordAnswerAttemptWindowStart":null}
I have a web Method in my C# that is called via Jquery ajax method. The web method should return an object back to the Jquery which will be used to populate. I have tried returning a JsonResult object, the actual object and nothing seems to work! I'm not using MVC (Unfortunately). Is there a way that I can return an object from my web method which can be used by my AJAX method? here is the link for my JQuery AJAX method [URL]
View 1 RepliesI use this test code and it works well :
JQuery
$(document).ready(function () {
$("#Result").click(function () {
$.ajax({
type: "POST",
url: "test-JQuery-Page-Methods.aspx/GetInfo",
data: {},
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (msg) {
$("#Label1").text(msg.d);
}
});
});
});
.VB
<WebMethod()> Public Shared Function GetInfo() As String
Return "test"
End Function
Now i try to pass an argument to the function but something is wrong in my code and i dont know what is wrong... :
JQuery
$(document).ready(function () {
$("#Result").click(function () {
var textj = 'test';
var jsonText = JSON.stringify(textj);
$.ajax({
type: "POST",
url: "test-JQuery-Page-Methods.aspx/GetInfo",
data: jsonText,
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (msg) {
$("#Label1").text(msg.d);
}
});
});
});
.VB
<WebMethod()> Public Shared Function GetInfo(ByVal infostring As String) As String
Return infostring
End Function
I have 2 web pages edit.aspx and webmethods.apx. In edit.aspx there is some jquery code to get some data :
[Code]....
With this I try to get a Json object from the webmethods.aspx page :
[Code]....
I get an error back that says "Parser Error", I even did put an breakpoint on the webmethod but it is like it's never triggered. Is my url wrong if I'm in the following url :
[Code]....
Should I use something like ../WebMethods.aspx?