iam getting error in webservice using asp.net

Question

0.00/5 (No votes)

See more:

XML

Parser Error

Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: Could not create type 'JSONDemo.Service1'.

Source Error:


Line 1:  <%@ WebService Language="C#" CodeBehind="Service1.asmx.cs" Class="JSONDemo.Service1" %>

Source File: /Service1.asmx    Line: 1

Posted 20-Aug-14 17:35pm

harshavardhan12345678

Updated 25-Aug-14 18:49pm

v3

Add a Solution

Comments

ClimerChinna 21-Aug-14 0:29am

string sql = string.Format(@"INSERT INTO [TestDB].[dbo].[Table_1] ([UserName],[CountryId],[IsActive]) VALUES ({0},'{1}','{2}')", UserName, CountryId, IsActive);

use above statement it may help you

harshavardhan12345678 21-Aug-14 0:31am

countryId Int IsActive int

ClimerChinna 21-Aug-14 0:37am

if isactive is int why did you give string in function parameters
there also you need to use int

ClimerChinna 21-Aug-14 0:39am

look at solution2

harshavardhan12345678 21-Aug-14 0:45am

now iam getting page like this

Directory Listing -- /WebSite8/

Monday, August 18, 2014 06:39 PM App_Code
Thursday, August 21, 2014 10:13 AM App_WebReferences
Thursday, July 31, 2014 02:23 PM Style
Wednesday, July 30, 2014 04:14 PM 35,980 14 - 1.jpg
Wednesday, July 30, 2014 04:14 PM 56,617 2014-07-30 - 1 (2).jpg
Wednesday, July 30, 2014 04:17 PM 35,561 2014-07-30 - 1.jpg
Friday, August 01, 2014 07:17 AM 803 aboutus.aspx
Thursday, July 31, 2014 04:20 PM 279 aboutus.aspx.cs
Wednesday, July 30, 2014 04:43 PM 2,371 calculator.aspx
Thursday, July 24, 2014 12:35 PM 1,098 calculator.aspx.cs
Friday, August 01, 2014 07:16 AM 508 category.aspx
Thursday, July 31, 2014 04:12 PM 280 category.aspx.cs
Friday, August 01, 2014 07:19 AM 546 contactus.aspx
Thursday, July 31, 2014 04:16 PM 281 contactus.aspx.cs
Thursday, July 31, 2014 10:49 AM 2,289 Datalistaspx.aspx
Thursday, July 31, 2014 10:47 AM 804 Datalistaspx.aspx.cs
Wednesday, July 30, 2014 04:40 PM 3,309 EmployeDetails.aspx
Thursday, July 31, 2014 09:36 AM 1,676 EmployeDetails.aspx.cs
Friday, August 01, 2014 02:55 AM 4,213 Gridview.aspx
Thursday, July 31, 2014 09:54 AM 774 Gridview.aspx.cs
Wednesday, July 30, 2014 04:15 PM 123,451 IMG_2770.JPG
Monday, August 18, 2014 05:31 PM 3,202 loginpage.aspx
Monday, August 18, 2014 05:27 PM 466 loginpage.aspx.cs
Friday, August 01, 2014 06:57 AM 1,347 MasterPage.master
Thursday, July 31, 2014 02:05 PM 290 MasterPage.master.cs
Friday, August 01, 2014 07:22 AM 877 MMasterpage.aspx
Thursday, July 31, 2014 02:09 PM 280 MMasterpage.aspx.cs
Friday, August 01, 2014 06:52 AM 1,488 placeholder.aspx
Wednesday, July 30, 2014 04:32 PM 436 placeholder.aspx.cs
Friday, August 01, 2014 02:41 AM 893 QueryStringParams.aspx
Friday, August 01, 2014 02:39 AM 565 QueryStringParams.aspx.cs
Thursday, August 14, 2014 10:33 AM 3,048 Registrationpage.aspx
Thursday, July 24, 2014 02:30 PM 1,308 Registrationpage.aspx.cs
Thursday, August 21, 2014 10:13 AM 9,009 Web.config
Monday, July 21, 2014 09:28 PM 1,360 Web.Debug.config
Monday, August 18, 2014 06:39 PM 93 WebService.asmx
Friday, August 01, 2014 07:37 AM 2,534 website.publishproj
Version Information: ASP.NET Development Server 11.0.0.0

harshavardhan12345678 21-Aug-14 0:46am

i dont know about webservice thats y iam asking each n everything

ClimerChinna 21-Aug-14 0:47am

could you post code where you are calling above method

ClimerChinna 21-Aug-14 0:48am

have you selected start page for your website???

harshavardhan12345678 21-Aug-14 0:50am

yes

harshavardhan12345678 21-Aug-14 0:52am

please tell step by step ...process plsssssss

ClimerChinna 21-Aug-14 0:56am

first you need to create webmethod in webservice like below

[WebMethod]
public string Insertempdet(int CountryId, string UserName, int IsActive)
{
int rowsInserted;
SqlConnection conn = new SqlConnection(your connectionstring);
string sql = string.Format(@"INSERT INTO [TestDB].[dbo].[Table_1] ([UserName],[CountryId],[IsActive]) VALUES ({0},'{1}',{2})", UserName, CountryId, IsActive);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
conn.Open();
rowsInserted = cmd.ExecuteNonQuery();
conn.Close();
cmd = null;
return string.Format("Thank you, {0} number of rows inserted!", rowsInserted);
}

create an object for webservice in your page CS Code

WebService ws = new WebService();

then call the webmethod in respective event like below return value i was displaying in label

lblmsg.Text=ws.Insertempdet(countryId, username, isactive);

harshavardhan12345678 21-Aug-14 0:48am

getting error
System.InvalidOperationException: The ConnectionString property has not been initialized.
at System.Data.SqlClient.SqlConnection.PermissionDemand()
at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at WebService.InsertWebservice(Int32 CountryId, String UserName, String IsActive) in e:\mine\webserviceasp.net1\App_Code\WebService.cs:line 47

ClimerChinna 21-Aug-14 0:52am

post complete code of your page so that i can know whats the problem, i dont know why you are getting this error i have executed it but didn't get any error

harshavardhan12345678 21-Aug-14 0:54am

tell me process from start to end ...

ClimerChinna 21-Aug-14 0:57am

first you need to create webmethod in webservice like below

[WebMethod]
public string Insertempdet(int CountryId, string UserName, int IsActive)
{
int rowsInserted;
SqlConnection conn = new SqlConnection(your connectionstring);
string sql = string.Format(@"INSERT INTO [TestDB].[dbo].[Table_1] ([UserName],[CountryId],[IsActive]) VALUES ({0},'{1}',{2})", UserName, CountryId, IsActive);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
conn.Open();
rowsInserted = cmd.ExecuteNonQuery();
conn.Close();
cmd = null;
return string.Format("Thank you, {0} number of rows inserted!", rowsInserted);
}

create an object for webservice in your page CS Code

WebService ws = new WebService();

then call the webmethod in respective event like below return value i was displaying in label

lblmsg.Text=ws.Insertempdet(countryId, username, isactive);

ClimerChinna 21-Aug-14 1:02am

have you got the solution???

harshavardhan12345678 21-Aug-14 3:17am

sorry for late reply ... here no power for 2hours .. error is Error 1 The name 'UserName' does not exist in the current context E:\mine\webserviceasp.net1\Default.aspx.cs 17 39 webserviceasp.net1

ClimerChinna 21-Aug-14 3:31am

lblmsg.Text=ws.Insertempdet(countryId, username, isactive);

have you given the values for username,countryid,isactive

harshavardhan12345678 21-Aug-14 3:22am

iam getting error like this
public object Inserttblval(string p)
{
throw new NotImplementedException();
}

harshavardhan12345678 21-Aug-14 6:05am

i want this html value in json

harshavardhan12345678 21-Aug-14 3:59am

JSON Format

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.auto-style1
{
width: 100%;
}
.auto-style2
{
height: 26px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<script>
var text = '{"UserName":"John Johnson","CountryId":"16","IsActive":"7"}'

var obj = JSON.parse(text);

document.getElementById("demo").innerHTML =
obj.name + "<br>" +
obj.street + "<br>" +
obj.phone;
</script>
</form>
</body>
</html>

harshavardhan12345678 25-Aug-14 23:45pm

[WebMethod]
[ScriptMethod(UseHttpGet = true, ResponseFormat = ResponseFormat.Json)]
public string Inserttblval(string UserName, int CountryId, int IsActive)

{
int rowsInserted;
SqlConnection conn = new SqlConnection("Data Source=SREENI\\SQLEXPRESS;Initial Catalog=TestDB;User ID=sa;Password=sa123");
string sql = string.Format(@"INSERT INTO [TestDB].[dbo].[Table_1] ([CountryId],[UserName],[IsActive]) VALUES ({0},'{1}',{2})", CountryId,UserName, IsActive);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
conn.Open();
rowsInserted = cmd.ExecuteNonQuery();
conn.Close();
return string.Format("1 Row inserted");
}

error is

Error 3 The type or namespace name 'ScriptMethodAttribute' could not be found (are you missing a using directive or an assembly reference?) E:\mine\webserviceasp.net1\App_Code\WebService.cs 39 5 webserviceasp.net1

MONU MITTAL 21-Aug-14 0:37am

username varchar countyid int and isactive int

harshavardhan12345678 21-Aug-14 3:22am

iam getting error like this
public object Inserttblval(string p)
{
throw new NotImplementedException();
}

3 solutions

Solution 1

C#

public string InsertWebservice(int CountryId, string UserName, string IsActive)
{
using (SqlConnection conn = new SqlConnection(conStr))
{
string sql = string.Format(@"INSERT INTO [TestDB].[dbo].[Table_1] ([UserName],[CountryId],[IsActive]) VALUES ('{0}','{1}','{2}')", UserName, CountryId, IsActive);
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}

If this is not working, Check by debugging the function.

Posted 20-Aug-14 18:34pm

Gihan Liyanage

Comments

harshavardhan12345678 21-Aug-14 3:22am

iam getting error like this
public object Inserttblval(string p)
{
throw new NotImplementedException();
}

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ClimerChinna · Accepted Answer · 2014-08-20T18:38:00

Solution 2

use below code

public string InsertWebservice(int CountryId, string UserName, int IsActive)
    {
        int rowsInserted;
        using (SqlConnection conn = new SqlConnection(conStr))
       {
           string sql = string.Format(@"INSERT INTO [TestDB].[dbo].[Table_1] ([UserName],[CountryId],[IsActive]) VALUES ({0},'{1}',{2})", UserName, CountryId, IsActive);
           SqlCommand cmd = new SqlCommand();
           cmd.Connection = conn;
           cmd.CommandText = sql;
           cmd.CommandType = CommandType.Text;
           conn.Open();
           rowsInserted = cmd.ExecuteNonQuery();
           conn.Close();
           cmd = null;
       }
       return string.Format("Thank you, {0} number of rows inserted!", rowsInserted);
    }

Posted 20-Aug-14 18:38pm

ClimerChinna

Updated 20-Aug-14 18:41pm

v2

Comments

harshavardhan12345678 21-Aug-14 3:23am

iam getting error like this
public object Inserttblval(string p)
{
throw new NotImplementedException();
}

ClimerChinna 21-Aug-14 3:29am

this is not the function where we have worked up to now right, check remaining code in your page

ClimerChinna 21-Aug-14 3:32am

post complete code of your page

harshavardhan12345678 21-Aug-14 3:36am

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.auto-style1
{
width: 100%;
}
.auto-style2
{
height: 26px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>

<table align="center" class="auto-style1">
<tr>
<td>UserName</td>
<td>
<asp:TextBox ID="TextBox1" runat="server">
</td>
<td> </td>
</tr>
<tr>
<td>CountryId </td>
<td>
<asp:TextBox ID="TextBox2" runat="server">
</td>
<td> </td>
</tr>
<tr>
<td class="auto-style2">IsActive</td>
<td class="auto-style2">
<asp:TextBox ID="TextBox3" runat="server">
</td>
<td class="auto-style2"></td>
</tr>
<tr>
<td> </td>
<td>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" />
</td>
<td> </td>
</tr>
<tr>
<td>Result:</td>
<td>
<asp:Label ID="Label1" runat="server" Text="">
</td>
<td> </td>
</tr>
</table>

</div>
</form>
</body>
</html>

harshavardhan12345678 21-Aug-14 3:38am

protected void Button1_Click(object sender, EventArgs e)
{
WebService ws = new WebService();
Label1.Text = ws.Inserttblval("UserName,CountryId,IsActive").ToString();
}

ClimerChinna 21-Aug-14 4:38am

replave your button click event with below code

protected void Button1_Click(object sender, EventArgs e)
{
WebService ws = new WebService();
Label1.Text = ws.Inserttblval(int.Parse(TextBox1.Text),TextBox2.Text,int.Parse(TextBox3.Text));
}

ClimerChinna 21-Aug-14 5:40am

where is your json funtion from where you are getting these values UserName,CountryId,IsActive

harshavardhan12345678 21-Aug-14 5:42am

hello Sir you Tell I can Learn From uu

ClimerChinna 21-Aug-14 5:44am

with out knowing how to write json method why are you trying to use json.

harshavardhan12345678 21-Aug-14 5:47am

please tell sir . i want to know that ..

harshavardhan12345678 21-Aug-14 5:52am

sir how can we display values after click button [username , countryid,isactive]

harshavardhan12345678 21-Aug-14 6:05am

and the values are displaying in json format

harshavardhan12345678 21-Aug-14 5:00am

hello sir .. i want UserName,CountryId,IsActive in Json Format

ClimerChinna 21-Aug-14 6:09am

all the three at a time as a string means,its not possible

harshavardhan12345678 21-Aug-14 6:13am

oh k k
then what i do next

ClimerChinna 21-Aug-14 8:21am

add this webmethod to cs page

using System.Web.Services;
[WebMethod]
public static string GetValues(int countryid,string username,int isactive)
{
WebService ws = new WebService();
return ws.inserttblval(username, countryid, isactive);
}

add below Javascript method to aspx page in head part:

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.1/jquery-ui.min.js"></script>
<script type="text/javascript">

$(function () {
$("[id*=btnSubmit]").click(function () {
var obj = {};
obj.countryid = $.trim($("[id*=TextBox2]").val());
obj.username= $.trim($("[id*=TextBox1]").val());
obj.isactive= $.trim($("[id*=TextBox3]").val());
$.ajax({
type: "POST",
url: "execnonqueryex.aspx/GetValues",
data: JSON.stringify(obj),
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (r) {
alert(r.d);
document.getElementById('lblmsg').value = r.d;
}
});
return false;
});
});
</script>

harshavardhan12345678 21-Aug-14 9:16am

Error 6 'WebService' does not contain a definition for 'inserttblval' and no extension method 'inserttblval' accepting a first argument of type 'WebService' could be found (are you missing a using directive or an assembly reference?) E:\mine\webserviceasp.net1\App_Code\WebService.cs 30 19 webserviceasp.net1

ClimerChinna 21-Aug-14 9:21am

use below line
return ws.InsertWebservice(countryid,username,isactive)

harshavardhan12345678 21-Aug-14 9:22am

again getting same error

ClimerChinna 21-Aug-14 9:26am

use the method name which you have created in webservice in place of InsertWebService
try to solve small errors

harshavardhan12345678 21-Aug-14 9:34am

sry dont mind pls..im tired to get result...

harshavardhan12345678 21-Aug-14 9:50am

again getting error

harshavardhan12345678 21-Aug-14 9:51am

again getting same error

harshavardhan12345678 21-Aug-14 10:01am

getting error like this....
Input string was not in a correct format.

ClimerChinna 22-Aug-14 0:19am

send me the method which you have written in webservice so that i can check ,what could I do with the error

harshavardhan12345678 22-Aug-14 0:31am

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data.SqlClient;
using System.Collections;
using System.Data;
///

/// Summary description for WebService
///

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
// [System.Web.Script.Services.ScriptService]
public class WebService : System.Web.Services.WebService
{
private string conStr;

public WebService()
{

//Uncomment the following line if using designed components
//InitializeComponent();
}

[WebMethod]
public string HelloWorld()
{
return "Hello World";
}
[WebMethod]
public int Add(int num1, int num2)
{
return (num1 + num2);
}

[WebMethod]
public string Inserttblval(int CountryId, String UserName, int IsActive)
{
int rowsInserted;
SqlConnection conn = new SqlConnection("Data Source=SREENI\\SQLEXPRESS;Initial Catalog=TestDB;User ID=sa;Password=sa123");
string sql = string.Format(@"INSERT INTO [TestDB].[dbo].[Table_1] ([UserName],[CountryId],[IsActive]) VALUES ({0},'{1}',{2})", UserName, CountryId, IsActive);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
conn.Open();
rowsInserted = cmd.ExecuteNonQuery();
conn.Close();
cmd = null;
return string.Format("row inserted!", rowsInserted);
}
}

ClimerChinna 22-Aug-14 0:35am

in which line you are getting error input string not in correct format error

ClimerChinna 22-Aug-14 0:39am

ok i will send you complete code step by step just follow that

ClimerChinna 22-Aug-14 0:45am

look at solution3 and follow as it is dont change any thing

harshavardhan12345678 25-Aug-14 6:11am

hellooo

harshavardhan12345678 25-Aug-14 5:56am

hello sir give ur mailid ... my id nandyala.bhagyaraj@gmail.com

ClimerChinna · Accepted Answer · 2014-08-21T18:45:00

Solution 3

first you need to create webmethod in webservice like below

C#

[WebMethod]
public string Inserttblval(int CountryId, string UserName, int IsActive)
{
int rowsInserted;
SqlConnection conn = new SqlConnection(your connectionstring);
string sql = string.Format(@"INSERT INTO [TestDB].[dbo].[Table_1] ([UserName],[CountryId],[IsActive]) VALUES ({0},'{1}',{2})", UserName, CountryId, IsActive);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
conn.Open();
rowsInserted = cmd.ExecuteNonQuery();
conn.Close();
cmd = null;
return string.Format("Thank you, {0} number of rows inserted!", rowsInserted);
}

next in aspx page add below code

XML

<head runat="server">
    <title></title>
    <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>
    <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.1/jquery-ui.min.js"></script>
    <script type="text/javascript">

        $(function () {
            $("[id*=Button1]").click(function () {
                var obj = {};
                obj.countryid= $.trim($("[id*=TextBox2]").val());
                obj.username= $.trim($("[id*=TextBox1]").val());
                obj.isactive= $.trim($("[id*=TextBox3]").val());
                $.ajax({
                    type: "POST",
                    url: "Default.aspx/GetValues",
                    data: JSON.stringify(obj),
                    contentType: "application/json; charset=utf-8",
                    dataType: "json",
                    success: function (r) {
                        alert(r.d);
                        document.getElementById('Label1').value = r.d;
                    }
                });
                return false;
            });
        });
    </script>
</head>

XML

<body>
<form id="form1" runat="server">
<div>

<table align="center" class="auto-style1">
<tr>
<td>UserName</td>
<td>
<asp:TextBox ID="TextBox1" runat="server">
</td>
<td> </td>
</tr>
<tr>
<td>CountryId </td>
<td>
<asp:TextBox ID="TextBox2" runat="server">
</td>
<td> </td>
</tr>
<tr>
<td class="auto-style2">IsActive</td>
<td class="auto-style2">
<asp:TextBox ID="TextBox3" runat="server">
</td>
<td class="auto-style2"></td>
</tr>
<tr>
<td> </td>
<td>
<asp:Button ID="Button1" runat="server" Text="Button" />
</td>
<td> </td>
</tr>
<tr>
<td>Result:</td>
<td>
<asp:Label ID="Label1" runat="server" Text="">
</td>
<td> </td>
</tr>
</table>

</div>
</form>
</body>

add below code in CS Page

C#

using System.Web.Services;
public partial class Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    [WebMethod]
    public static string GetValues(int countryid,string username,int isactive)
    {
        WebService ws = new WebService();
        return ws.Inserttblval(countryid, username, isactive);
    }



}

accept solution if its working,

Posted 21-Aug-14 18:45pm

ClimerChinna

Updated 21-Aug-14 18:50pm

v7

Comments

harshavardhan12345678 22-Aug-14 0:55am

error in cs page.
return ws.<pre>Inserttblval(eno, ename, salary);

ClimerChinna 22-Aug-14 0:56am

remove <pre>

ClimerChinna 22-Aug-14 0:57am

check solution once again i have modified it

harshavardhan12345678 22-Aug-14 0:59am

after click button didn't show anything

harshavardhan12345678 22-Aug-14 0:59am

blank page

ClimerChinna 22-Aug-14 1:00am

have u added aspx code also same like above

harshavardhan12345678 22-Aug-14 3:14am

sorry for late reply. here power issue...
where is button code

harshavardhan12345678 22-Aug-14 3:28am

sir pls send button code

harshavardhan12345678 22-Aug-14 3:59am

hello sir .. every thing is okay , but did not get out put in json

harshavardhan12345678 22-Aug-14 4:04am

USERNAME ACCEPTING INTEGER VALUES ONLY . HOW CAN I CHANGE THAT

ClimerChinna 22-Aug-14 5:09am

for username problem change webservice to below method

[WebMethod]
public string Inserttblval(int CountryId, string UserName, int IsActive)
{
int rowsInserted;
SqlConnection conn = new SqlConnection(your connectionstring);
string sql = string.Format(@"INSERT INTO [TestDB].[dbo].[Table_1] ([CountryId],[UserName],[IsActive]) VALUES ({0},'{1}',{2})", CountryId,UserName, IsActive);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
conn.Open();
rowsInserted = cmd.ExecuteNonQuery();
conn.Close();
cmd = null;
return string.Format("Thank you, {0} number of rows inserted!", rowsInserted);
}

ClimerChinna 22-Aug-14 5:10am

here one thing you need to understand is for integers no need of (''),but for string you need to use single quotes,thats the error for username not accepting string,ok try to look at the above method you can understand easily....

harshavardhan12345678 25-Aug-14 5:18am

hi sir

ClimerChinna 25-Aug-14 5:34am

hi have you got the answer

harshavardhan12345678 25-Aug-14 5:36am

no sir , iam tired to know that, still trying but no use

harshavardhan12345678 22-Aug-14 3:46am

helllloooooooooooo sir

harshavardhan12345678 22-Aug-14 3:50am

hello sir . i want button code (cs)

ClimerChinna 22-Aug-14 5:04am

no need of button code it will execute, we have written it in javascript function

harshavardhan12345678 22-Aug-14 5:07am

oh k k ... in default.aspx page iam getting error like that, and in webservice again same xml code is running ....

ClimerChinna 22-Aug-14 5:12am

can you tell me what's the error you are geting now clearly

harshavardhan12345678 22-Aug-14 5:14am

did not get json format

ClimerChinna 22-Aug-14 5:16am

what, r u getting alert message showing number of records inserted or not

harshavardhan12345678 22-Aug-14 5:15am

always open in xml format only

ClimerChinna 22-Aug-14 5:17am

for username problem change webservice to below method

[WebMethod]
public string Inserttblval(int CountryId, string UserName, int IsActive)
{
int rowsInserted;
SqlConnection conn = new SqlConnection(your connectionstring);
string sql = string.Format(@"INSERT INTO [TestDB].[dbo].[Table_1] ([CountryId],[UserName],[IsActive]) VALUES ({0},'{1}',{2})", CountryId,UserName, IsActive);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
conn.Open();
rowsInserted = cmd.ExecuteNonQuery();
conn.Close();
cmd = null;
return string.Format("Thank you, {0} number of rows inserted!", rowsInserted);
}

harshavardhan12345678 22-Aug-14 5:25am

my question is if i give values in (username , countryid , isActive ) and i want to display the values in json format

ClimerChinna 22-Aug-14 5:06am

sorry for late reply,I have Left for lunch

harshavardhan12345678 22-Aug-14 5:09am

ok ok no problem

harshavardhan12345678 22-Aug-14 5:18am

my mailid= nandyala.bhagyaraj@gmail.com ... cantact me sir i can learn each n eveything from u

ClimerChinna 22-Aug-14 5:20am

tell me onething whether you got alert message or not on button click

harshavardhan12345678 22-Aug-14 5:21am

<string xmlns="http://tempuri.org/">Thank you, 1 number of rows inserted!

harshavardhan12345678 22-Aug-14 5:22am

i want display the Username , countryid, isactive in json format ....not 1row submitted like this

harshavardhan12345678 22-Aug-14 5:26am

my question is if i give values in (username , countryid , isActive ) and i want to display the values in json format

harshavardhan12345678 22-Aug-14 5:30am

Do U got it Wt Iam Saying

harshavardhan12345678 22-Aug-14 5:35am

hello sir busy aah

ClimerChinna 22-Aug-14 5:43am

displaying o/p in json format ,i too dont have idea,i need check that then i wil tel u

harshavardhan12345678 22-Aug-14 5:46am

I Can Understand your Problem... Ok Im Sorry for disturbing you . k dont mind Iam a fresher in small company , in my office iam only dotnet employee... once again sorrrrrryyyyy sir

ClimerChinna 22-Aug-14 5:49am

thats not a problem, as a fresher these confusions will be common, try to ask your question clearly so that you can find answer more quickly,in the start itself if u have ask me about json format may be i try to get that only

harshavardhan12345678 22-Aug-14 5:55am

okay thankq so much....

ClimerChinna 22-Aug-14 6:08am

could you tell me onething json format means how do you want your output whether on xml file or on a control or anything else

harshavardhan12345678 22-Aug-14 6:15am

json format means just like text

harshavardhan12345678 22-Aug-14 6:16am

json example {"employees":[
{"firstName":"John", "lastName":"Doe"},
{"firstName":"Anna", "lastName":"Smith"},
{"firstName":"Peter", "lastName":"Jones"}
]}

harshavardhan12345678 22-Aug-14 6:16am

xml example
<employees>
<employee>
<firstname>John <lastname>Doe

<employee>
<firstname>Anna <lastname>Smith

<employee>
<firstname>Peter <lastname>Jones

iam getting error in webservice using asp.net

3 solutions

Solution 2

Solution 3

Solution 1

Add your solution here

Preview 0

iam getting error in webservice using asp.net

3 solutions

Solution 2

Solution 3

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us