C#

manu v nath wrote:

For a desktop application sql server is not a recommended DB.

manu v nath wrote:

You have setup SQL server in client machine also for desktop app

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

lukeer wrote:

Customer doesn't like to be forced to click twice

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

lukeer wrote:

But it still shows a value as one line.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

amjegan wrote:

all request will get a response in two mins and only one service hit will happen.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

amjegan wrote:

Now I want a technique where first request will acquire lock and get the
response. All the other request should be waiting for this and once first
request release the lock, this response should be assigned to all other pending
request (as the output response will be same) and make them all released at the
same time.So ultimately, all request will get a response in two mins and only
one service hit will happen.

using (var con = new SqlConnection("<YOUR CONNECTION STRING HERE>"))
using (var cmd = new SqlCommand("update testreport set patientname = @patientname, address = @address, testreports = @testreports, reportno = @reportno, date = @date, takentest = @takentest where patientid = @patientid", con))
{
   cmd.Parameters.AddWithValue("@patientname", textBox2.Text);
   cmd.Parameters.AddWithValue("@address", textBox3.Text);
   cmd.Parameters.AddWithValue("@testreports", textBox5.Text);
   cmd.Parameters.AddWithValue("@reportno", textBox6.Text);
   cmd.Parameters.AddWithValue("@date", dateTimePicker1.Value);
   cmd.Parameters.AddWithValue("@takentest", textBox4.Text);
   cmd.Parameters.AddWithValue("@patientid", textBox1.Text);
   
   con.Open();
   cmd.ExecuteNonQuery();
}