I have an invoke function that I call. It On the client side it reads a file and then sends the line to the server side function here and waits for a return.
Here is the server side code:
[Invoke]
public string UpdatePriorty(string Item)
{
//string ConnectionString = ConfigurationManager.ConnectionStrings.CurrentConfiguration("ClaimIQ");
SqlConnection myConnection = new SqlConnection("Server=10.0.2.30;Database=ClaimIQ;User ID=ClaimIQUser;Password=Pl@n0TX!~");
SqlCommand myCommand = new SqlCommand();
//string Total = "0";
myCommand.Connection = myConnection;
myCommand.CommandText = "Update Tickets set isHighPriority = 'true' where AccountNumber = @AccountNumber";
myCommand.Parameters.Add("@AccountNumber", SqlDbType.VarChar, 50).Value = Item;
...
Go to the complete details ...