通过Web服务更新表 [英] Update a table via Web service

问题描述

如何在Silverlight应用程序中通过WCF Web服务更新表?

how to update a table via WCF web service in Silverlight Application?

推荐答案

从7开始使用WCF连接SQL Server的7个简单步骤SilverLight [ ^ ]

示例文章1

Hi,


7 Simple Steps to Connect SQL Server using WCF from SilverLight[^]

Sample article 1

问题是将EmployeeID作为SQL参数传递给Web服务下的此功能.


Public Sub UpdateEmpShiftDetails(employeeID作为字符串，month作为整数，year作为整数，D1作为字符串，D2作为字符串，companyID作为字符串，divisionID作为字符串，departmentID作为字符串，sectionID作为字符串)
Dim connString As String =数据源= STORM-SERVER；初始目录= HRNET1；持久性安全信息=真实；用户ID = sa；密码= its @ 123"
''Dim qry As String ="SELECT Temper_id，attn_year，attn_month，day1，day2 FROM TNA_SHIFT_ROSTERING_DAILY"
Dim upd As String ="UPDATE TNA_SHIFT_ROSTERING_DAILY SET day1 = @ day1，"& _
"day2 = @ day2，"& _
"WHERE employee_id = @employee_id和& _
"attn_month = @ attn_month和"& _
"attn_year = @ attn_year"

昏暗的conn作为新的SqlConnection(connString)
试试
conn.Open()

''更新员工
昏暗的cmd作为新的SqlCommand(upd，conn)
cmd.Parameters.Add("@ day1"，SqlDbType.VarChar，5).Value = D1
cmd.Parameters.Add("@ day2"，SqlDbType.VarChar，5).Value = D2
cmd.Parameters.Add("@ employee_id"，SqlDbType.VarChar，10).Value = employeeID
cmd.Parameters.Add("@ attn_year"，SqlDbType.Int).Value =年
cmd.Parameters.Add("@ attn_month"，SqlDbType.Int).Value = month

昏暗的结果= cmd.ExecuteNonQuery()



异常捕获
Console.WriteLine(错误:" + e.Message)
终于
conn.Close()
结束尝试
结束Sub

the problem was passing the EmployeeID as SQL Parameters in this function under web service.


Public Sub UpdateEmpShiftDetails(employeeID As String, month As Integer, year As Integer, D1 As String, D2 As String, companyID As String, divisionID As String, departmentID As String, sectionID As String)
Dim connString As String = "Data Source=STORM-SERVER;Initial Catalog=HRNET1;Persist Security Info=True;User ID=sa;Password=its@123"
''Dim qry As String = "SELECT employee_id,attn_year,attn_month,day1,day2 FROM TNA_SHIFT_ROSTERING_DAILY"
Dim upd As String = "UPDATE TNA_SHIFT_ROSTERING_DAILY SET day1 = @day1, " & _
" day2 = @day2, " & _
"WHERE employee_id = @employee_id and " & _
"attn_month=@attn_month and " & _
"attn_year=@attn_year"

Dim conn As New SqlConnection(connString)
Try
conn.Open()

'' Update employees
Dim cmd As New SqlCommand(upd, conn)
cmd.Parameters.Add("@day1", SqlDbType.VarChar, 5).Value = D1
cmd.Parameters.Add("@day2", SqlDbType.VarChar, 5).Value = D2
cmd.Parameters.Add("@employee_id", SqlDbType.VarChar, 10).Value = employeeID
cmd.Parameters.Add("@attn_year", SqlDbType.Int).Value = year
cmd.Parameters.Add("@attn_month", SqlDbType.Int).Value = month

Dim result = cmd.ExecuteNonQuery()



Catch e As Exception
Console.WriteLine("Error: " + e.Message)
Finally
conn.Close()
End Try
End Sub

这篇关于通过Web服务更新表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！