110,536
社区成员
发帖
与我相关
我的任务
分享用WebService实现对数据库进行操作(添加+删除+修改)
[WebMethod(Description="添加")]
public int Add(string id,string name,string title,string depar,string ass)
{
SqlConnection conn = new SqlConnection("hisdbConnectionString");
conn.Open();
string sql = "intsert into Doctor(dID,dName,Title,Department,Assistment) values(@dID,@dName,@Title,@Department,@Assistment)";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlParameter d = new SqlParameter("@dID", id);
cmd.Parameters.Add(d);
SqlParameter n= new SqlParameter("@dName", name);
cmd.Parameters.Add(n);
SqlParameter t = new SqlParameter("@Title", title);
cmd.Parameters.Add(t);
SqlParameter e = new SqlParameter("@Department", depar);
cmd.Parameters.Add(e);
SqlParameter a = new SqlParameter("@Assistment", ass);
cmd.Parameters.Add(a);
int result = cmd.ExecuteNonQuery();
conn.Close();
cmd.Dispose();
return result;
}
[WebMethod(Description = "更新")]
public int upda(string id, string name, string title, string depar, string ass)
{
SqlConnection conn = new SqlConnection("hisdbConnectionString");
conn.Open();
string sql = "update Doctor set dName=@dName,Title=@Title,Department=@Department,Assistment=@Assistment where dID=@dID";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlParameter d = new SqlParameter("@dID", id);
cmd.Parameters.Add(d);
SqlParameter n = new SqlParameter("@dName", name);
cmd.Parameters.Add(n);
SqlParameter t = new SqlParameter("@Title", title);
cmd.Parameters.Add(t);
SqlParameter e = new SqlParameter("@Department", depar);
cmd.Parameters.Add(e);
SqlParameter a = new SqlParameter("@Assistment", ass);
cmd.Parameters.Add(a);
int result = cmd.ExecuteNonQuery();
conn.Close();
cmd.Dispose();
return result;
}
[WebMethod(Description = "删除")]
public int del(string id)
{
SqlConnection conn = new SqlConnection("hisdbConnectionString");
conn.Open();
string sql = "delete * from Doctot where dID=@dID";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlParameter d = new SqlParameter("@dID", id);
cmd.Parameters.Add(d);
int result = cmd.ExecuteNonQuery();
conn.Close();
cmd.Dispose();
return result;
}
创建了一个web service不知道如何调用这些方法。
<body>
<form id="form1" runat="server">
<div style="height: 433px; width: 670px">
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
编号：<asp:TextBox ID="txt_1" runat="server"></asp:TextBox>
<br />
姓名：<asp:TextBox ID="txt_2" runat="server" ></asp:TextBox>
<br />
职称：<asp:TextBox ID="txt_3" runat="server" ></asp:TextBox>
<br />
科室：<asp:TextBox ID="txt_4" runat="server" ></asp:TextBox>
<br />
科室：<asp:TextBox ID="txt_5" runat="server" ></asp:TextBox>
<br />
<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="添加" />
<asp:Button ID="Button2" runat="server" onclick="Button2_Click" Text="更新" />
<asp:Button ID="Button3" runat="server" onclick="Button3_Click" Text="删除" />
</div>
</form>
</body>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public partial class _112 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string connstr = ConfigurationManager.ConnectionStrings["hisdbConnectionString"].ConnectionString;
SqlConnection conn = new SqlConnection(connstr);
try
{
conn.Open();
SqlDataAdapter ad = new SqlDataAdapter("Select * from Doctor", conn);
DataSet ds = new DataSet();
ad.Fill(ds);
this.GridView1.DataSource = ds;
this.GridView1.DataBind();
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
catch { }
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
//SELECT [pID], [pName], [pSex], [pDep], [pClass] FROM [pPerson]
int selectIndex = this.GridView1.SelectedIndex;
txt_1.Text = this.GridView1.DataKeys[selectIndex]["dID"].ToString();
txt_1.Enabled = false;
GridViewRow gvrow = this.GridView1.SelectedRow;
txt_2.Text = gvrow.Cells[2].Text.ToString();
txt_3.Text = gvrow.Cells[3].Text.ToString();
txt_4.Text = gvrow.Cells[4].Text.ToString();
txt_5.Text = gvrow.Cells[5].Text.ToString();
}
protected void Button1_Click(object sender, EventArgs e)
{
localhost.WebService1 web=new localhost.WebService1();
web.Add(txt_1.Text, txt_2.Text, txt_3.Text, txt_4.Text, txt_5.Text);
}
protected void Button2_Click(object sender, EventArgs e)
{
localhost.WebService1 web = new localhost.WebService1();
web.upda(txt_1.Text, txt_2.Text, txt_3.Text, txt_4.Text, txt_5.Text);
}
protected void Button3_Click(object sender, EventArgs e)
{
localhost.WebService1 web = new localhost.WebService1();
web.del(txt_1.Text);
}
}
点击按钮不能实现添加+删除+修改，请大神看看
...全文
请发表友善的回复…
发表回复
珠穆郎码疯@ 2019-06-19
- 打赏
- 举报
您这是什么语言写的啊？
以专业开发人员为伍 2017-05-21
- 打赏
- 举报
在你的 public int Add(string id,string name,string title,string depar,string ass) 方法的第一行设置断点，然后开始调试，单步跟踪，在各种调试窗口分析变量值......
学编程只会抄代码而不知道原理、不知如何调试，其实是等于没学，那样你除了只“求结果”以外连描述你遇到的问题都不会。
yang669933 2017-05-21
- 打赏
- 举报
谢谢，我尝试了，也找到问题了
