using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data.SqlClient;
namespace WebService2
{
///
/// Service1 的摘要说明
///
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
// 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务,请取消对下行的注释。
// [System.Web.Script.Services.ScriptService]
public class Service1 : System.Web.Services.WebService
{
[WebMethod]
public string HelloWorld()
{
return "Hello World";
}
[WebMethod]
public int GetData(int a)
{
string strcon = " Data Source=.;Initial Catalog=Test;Persist Security Info=True;User ID=sa;Password=kong9393";
SqlConnection mycon;
mycon = new SqlConnection(strcon);
string sql = "SELECT age FROM [number] WHERE num="+a+"";
SqlCommand mysc = new SqlCommand(sql, mycon);
mycon.Open();
SqlDataReader rd = mysc.ExecuteReader();
int age=0;
while (rd.Read())
{
age = (int )rd["age"];
}
age = Convert.ToInt32(age );
return age ;
}
// 表为User,字段有 编号: int id,用户名:string UserName,密码:string UserPwd /// <summary> /// 添加 /// </summary>
/// 用户名 /// 密码 ///
[WebMethod]
public int Add(int num,int age)
{
SqlConnection conn = new SqlConnection("连接字符串");
conn.Open();
string sql = "intsert into number (num,age) values(@num,@age)";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlParameter parn = new SqlParameter("@num", num);
cmd.Parameters.Add(parn);
SqlParameter parp = new SqlParameter("@age", age);
cmd.Parameters.Add(parp);
int result = cmd.ExecuteNonQuery();
conn.Close();
cmd.Dispose();
return result; }
}
}