个人中心
文章发布
退出
作者热门文章
- Java 双重比较
- java - 比较器与 Apache BeanComparator
- Objective-C 完成 block 导致额外的方法调用？
- database - RESTful URI 是否应该公开数据库主键？
25
4
我的目标是将数据从 C# 发送到 SQL 服务器，但数据库端什么也没有发生。可能是什么问题？也许它在数据库端的数据类型错误？
获取字符串并发送的代码。
完整代码
namespace NIBP2PC
{
public partial class Form1 : Form
{
private delegate void displayDeleg(string message);
const string STX = "\u0002"; //Start
const string ETX = "\u0003"; //End
const string STARTMEAS = "01;;D7"; //Command Values
const string STOPMEAS = "X";
const string SETCYCLE0 = "03;;D9"; // Manual mode
const string SETCYCLE1 = "04;;DA"; // 1 min
const string SETCYCLE2 = "05;;DB"; // 2 min
const string SETCYCLE3 = "06;;DC"; // 3 min
const string SETCYCLE4 = "07;;DD"; // 4 min
const string SETCYCLE5 = "08;;DE"; // 5 min
const string SETCYCLE10 = "09;;DF"; // 10 min
const string SETCYCLE15 = "10;;D7"; // 15 min
const string SETCYCLE30 = "11;;D8"; // 30 min
const string SETMANO = "14;;DB"; // Manometer mode
const string SETREBOOT = "15;;DC"; // Reset Board
const string SETLEAK = "17;;DE"; // Leakage Test
const string READSTATUS = "18;;DF"; // Read Result
const string SETPMP100 = "19;;E0"; // Set start pressure 100mmHg
const string SETPMP120 = "20;;D8"; // Set start pressure 120mmHg
const string SETPMP140 = "21;;D9"; // Set start pressure 140mmHg
const string SETPMP160 = "22;;DA"; // Set start pressure 160mmHg
const string SETPMP180 = "23;;DB"; // Set start pressure 180mmHg
const string SETADULT = "24;;DC"; // Set Adult Mode
const string SETNEO = "25;;DD"; // Set Neo Mode
const byte INIT = 0; //Not measured up to now
const byte OK = 1; // Status Values
const byte RSTAT = 2; // Read Status
const byte RPRESS = 3;
byte V_Cycle;
byte V_Pumpup;
int V_Map;
// private VerticalProgressBar bar1 = new VerticalProgressBar();
public Form1()
{
InitializeComponent();
list_comport();
}
private void list_comport()
{
// Get a list of serial port names.
string[] ports = SerialPort.GetPortNames();
// Display each port name to the console.
foreach (string port in ports)
{
portToolStripMenuItem.DropDownItems.Add(port, null, new EventHandler(port_Click));
}
}
private void port_Click(object sender, EventArgs e)
{
if (serialPort1.IsOpen)
serialPort1.Close();
serialPort1.ReadBufferSize = 64;
serialPort1.ReceivedBytesThreshold = 2;
string Port = sender.ToString();
serialPort1.PortName = Port;
try
{
serialPort1.Open();
}
catch
{
MessageBox.Show("Serial port " + serialPort1.PortName +
" cannot be opened!", "RS232 tester",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
};
toolStripStatusLabel_Com.Text = Port;
Send_command(SETCYCLE0);
Send_command(SETADULT);
label_Status.Text = "IDLE";
label_Cycle.Text = "Manual";
label_Patient.Text = "Adult";
label_Pump.Text = "160 mmHg";
V_Cycle = 0;
V_Pumpup = 3;
Send_command(SETPMP160);
Send_command(READSTATUS); // Read status values
}
private void exitToolStripMenuItem_Click(object sender, EventArgs e)
{
Application.Exit();
}
private void aboutToolStripMenuItem_Click(object sender, EventArgs e)
{
AboutBox1 about = new AboutBox1();
about.Show();
}
private void button_Read_Click(object sender, EventArgs e)
{
Send_command(READSTATUS);
}
private void button_Cycle_Click(object sender, EventArgs e)
{
if (label_Status.Text == "IDLE")
{
if (V_Cycle < 8)
V_Cycle++;
else V_Cycle = 0;
switch (V_Cycle)
{
case 0:
Send_command(SETCYCLE0);
label_Cycle.Text = "Manual";
break;
case 1:
Send_command(SETCYCLE1);
label_Cycle.Text = "1 min";
break;
case 2:
Send_command(SETCYCLE2);
label_Cycle.Text = "2 min";
break;
case 3:
Send_command(SETCYCLE3);
label_Cycle.Text = "3 min";
break;
case 4:
Send_command(SETCYCLE4);
label_Cycle.Text = "4 min";
break;
case 5:
Send_command(SETCYCLE5);
label_Cycle.Text = "5 min";
break;
case 6:
Send_command(SETCYCLE10);
label_Cycle.Text = "10 min";
break;
case 7:
Send_command(SETCYCLE15);
label_Cycle.Text = "15 min";
break;
case 8:
Send_command(SETCYCLE30);
label_Cycle.Text = "30 min";
break;
default:
break;
}
}
}
private void Send_command(String command)
{
if (serialPort1.IsOpen)
{
serialPort1.Write(STX); // STX = 2
serialPort1.Write(command);
serialPort1.Write(ETX); // ETX = 3
}
}
private void button_Patient_Click(object sender, EventArgs e)
{
if (label_Status.Text == "IDLE")
{
if (label_Patient.Text == "Adult")
{
Send_command(SETNEO);
label_Patient.Text = "Neonate";
label_Pump.Text = "100 mmHg";
V_Pumpup = 0;
}
else if (label_Patient.Text == "Neonate")
{
Send_command(SETADULT);
label_Patient.Text = "Adult";
label_Pump.Text = "160 mmHg";
V_Pumpup = 3;
}
}
}
private void button_Pump_Click(object sender, EventArgs e)
{
if (label_Status.Text == "IDLE")
{
if (label_Patient.Text == "Neonate")
{
if (V_Pumpup < 2)
V_Pumpup++;
else
V_Pumpup = 0;
}
if (label_Patient.Text == "Adult")
{
if ((V_Pumpup < 4) && (V_Pumpup >= 2))
V_Pumpup++;
else
V_Pumpup = 2;
}
switch (V_Pumpup)
{
case 0:
Send_command(SETPMP100);
label_Pump.Text = "100 mmHg";
break;
case 1:
Send_command(SETPMP120);
label_Pump.Text = "120 mmHg";
break;
case 2:
Send_command(SETPMP140);
label_Pump.Text = "140 mmHg";
break;
case 3:
Send_command(SETPMP160);
label_Pump.Text = "160 mmHg";
break;
case 4:
Send_command(SETPMP180);
label_Pump.Text = "180 mmHg";
break;
}
}
}
private void button_Start_Click(object sender, EventArgs e)
{
if (label_Status.Text == "IDLE")
{
Send_command(STARTMEAS);
//Ser_Stat = RPRESS;
label_Status.Text = "MEASURE";
label_Statusstring.Text = "";
label_Sys.Text = "";
label_Dia.Text = "";
label_Pulse.Text = "";
}
}
private void button_Mano_Click(object sender, EventArgs e)
{
if (label_Status.Text == "IDLE")
{
Send_command(SETMANO);
label_Map.Text = "";
//Ser_Stat = RPRESS;
label_Status.Text = "Manometer";
}
}
private void button_Leak_Click(object sender, EventArgs e)
{
if (label_Status.Text == "IDLE")
{
if (label_Patient.Text == "Neonate")
{
button_Patient.PerformClick();
}
Send_command(SETLEAK);
//Ser_Stat = RPRESS;
label_Status.Text = "Leaktest";
label_Statusstring.Text = "";
label_Sys.Text = "";
label_Dia.Text = "";
label_Pulse.Text = "";
}
}
private void button_Break_Click(object sender, EventArgs e)
{
Send_command(STOPMEAS);
label_Status.Text = "IDLE";
V_Map = 0;
label_Sys.Text = "---";
label_Dia.Text = "---";
label_Pulse.Text = "---";
label_Map.Text = "---";
}
string buffer = "";
private void serialPort1_DataReceived(object sender, SerialDataReceivedEventArgs e)
{
while (serialPort1.BytesToRead > 0)
{
buffer += serialPort1.ReadTo("\r");
int index1 = buffer.IndexOf('\u0002');
int index2 = buffer.IndexOf('\u0003', index1 + 1);
string buf = "";
if ((index1 >= 0) && (index2 > index1))
{
buf = buffer.Substring(index1 + 1, (index2 - 1 - index1));
buffer = buffer.Remove(index1, (index2 - index1));
this.BeginInvoke(new displayDeleg(display), new object[] { buf });
}
}
}
private void display(string message)
{
label_Statusstring.Text = message;
label_Statusstring.ForeColor = Color.Black;
if (message.Length > 3)
{
if ((message.Substring(5, 1)).Contains("S"))
{
string temp = message.Substring(6, 1);
switch (temp)
{
case "3":
label_Status.Text = "MEASURE";
break;
case "4":
label_Status.Text = "Manometer";
break;
case "7":
label_Status.Text = "Leaktest";
break;
default:
label_Status.Text = "IDLE";
break;
}
label_Map.Text = message.Substring(0, 3);
if (label_Map.Text != "")
V_Map = Convert.ToInt16(label_Map.Text);
if (V_Map < 300) { }
bar1.Value = V_Map;
}
else
{
if ((message.Substring(0, 1)).Contains("S"))
{
string temp = message.Substring(1, 1);
switch (temp)
{
case "2":
label_Statusstring.ForeColor = Color.Red;
break;
case "3":
label_Status.Text = "MEASURE";
break;
case "4":
label_Status.Text = "Manometer";
break;
case "7":
label_Status.Text = "Leaktest";
break;
default:
label_Status.Text = "IDLE";
break;
}
}
label_Map.Text = message.Substring(21, 3);
label_Sys.Text = message.Substring(15, 3);
label_Dia.Text = message.Substring(18, 3);
label_Pulse.Text = message.Substring(26, 3);
SaveData(
message.Substring(15, 3),
message.Substring(18, 3),
message.Substring(26, 3));
}
}
else if (message.Contains("999"))
{
Send_command(READSTATUS);
label_Status.Text = "IDLE";
bar1.Value = 0;
}
}
private void SaveData(string sys, string dia, string pulse)
{
try
{
string connectionString = @"Data Source=PLUTO-PC\;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\spiediena_merisana.mdf;Integrated Security=True;User Instance=True";
using (SqlConnection connection = new SqlConnection(connectionString))
{
string queryString = "INSERT INTO merisana1 (sys, dia, pulse) VALUES (@sys, @dia, @pulse)";
SqlCommand command = new SqlCommand(queryString, connection);
command.Parameters.AddWithValue("@sys", sys);
command.Parameters.AddWithValue("@dia", dia);
command.Parameters.AddWithValue("@pulse", pulse);
command.Connection.Open();
command.ExecuteNonQuery();
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
}
private void timer1_Tick(object sender, EventArgs e)
{
toolStripStatusLabel_time.Text = DateTime.Now.ToLongTimeString();
}
}
public class VerticalProgressBar : ProgressBar
{
protected override CreateParams CreateParams
{
get
{
CreateParams cp = base.CreateParams;
cp.Style |= 0x04;
return cp;
}
}
}
}
最佳答案
你能试试这个吗:
private void SaveData(string sys, string dia, string pulse)
{
try
{
string connectionString = @"Data Source=(local);AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\spiediena_merisana.mdf;Integrated Security=True;User Instance=True";
using (SqlConnection connection = new SqlConnection(connectionString))
{
string queryString = "INSERT INTO merisana1 (sys, dia, pulse) VALUES (@sys, @dia, @pulse)";
SqlCommand command = new SqlCommand (queryString, connection);
command.Parameters.AddWithValue("@sys", sys);
command.Parameters.AddWithValue("@dia", dia);
command.Parameters.AddWithValue("@pulse", pulse);
command.Connection.Open();
command.ExecuteNonQuery();
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
}
关于c# - 无法将子字符串发送到数据库，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/16561504/
25
4
0
如何使用 SPListCollection.Add(String, String, String, String, Int32, String, SPListTemplate.QuickLaunchO
我刚刚开始使用 C++ 并且对 C# 有一些经验，所以我有一些一般的编程经验。然而，似乎我马上就被击落了。我试过在谷歌上寻找，以免浪费任何人的时间，但没有结果。 int main(int argc,
这个问题已经有答案了: In Java 8 how do I transform a Map to another Map using a lambda? (8 个回答) Convert a Map>
我正在使用 node + typescript 和集成的 swagger 进行 API 调用。我 Swagger 提出以下要求 http://localhost:3033/employees/sear
我是 C++ 容器模板的新手。我收集了一些记录。每条记录都有一个唯一的名称，以及一个字段/值对列表。将按名称访问记录。字段/值对的顺序很重要。因此我设计如下: typedef string
我需要这两种方法，但j2me没有，我找到了一个replaceall();但这是 replaceall(string,string,string); 第二个方法是SringBuffer但在j2me中它没
If string is an alias of String in the .net framework为什么会发生这种情况，我应该如何解释它: type JustAString = string
我有两个列表(或字符串):一个大，另一个小。 我想检查较大的(A)是否包含小的(B)。 我的期望如下: 案例 1. B 是 A 的子集 A = [1,2,3] B = [1,2] contains(A
我有一个似乎无法解决的小问题。 这里...我有一个像这样创建的输入... var input = $(''); 如果我这样做......一切都很好 $(this).append(input); 如果我
我有以下代码片段 string[] lines = objects.Split(new string[] { "\r\n", "\n" }, StringSplitOptions.No
这可能真的很简单，但我已经坚持了一段时间了。 我正在尝试输出一个字符串，然后输出一个带有两位小数的 double ，后跟另一个字符串，这是我的代码。 System.out.printf("成本:%.2
以下是 Cloud Firestore 列表查询中的示例之一 citiesRef.where("state", ">=", "CA").where("state", "= 字符串，我们在Stack O
我正在尝试检查一个字符串是否包含在另一个字符串中。后面的代码非常简单。我怎样才能在 jquery 中做到这一点？ function deleteRow(locName, locID) { if
这个问题在这里已经有了答案: How to implement big int in C++ (14 个答案) 关闭 9 年前。 我有 2 个字符串，都只包含数字。这些数字大于 uint64_t 的
我有一个带有自定义转换器的 Dozer 映射: com.xyz.Customer com.xyz.CustomerDAO customerName
这个问题在这里已经有了答案: How do I compare strings in Java? (23 个回答) 关闭 6 年前。 我想了解字符串池的工作原理以及一个字符串等于另一个字符串的规则是
我已阅读 this问题和其他一些问题。但它们与我的问题有些无关 对于 UILabel 如果你不指定 ? 或 ! 你会得到这样的错误: @IBOutlet property has non-option
这两种方法中哪一种在理论上更快，为什么？ (指向字符串的指针必须是常量。) destination[count] 和 *destination++ 之间的确切区别是什么？ destination[co
This question already has answers here: Closed 11 years ago. Possible Duplicates: Is String.Format a
我有一个Stream一个文件的，现在我想将相同的单词组合成 Map这很重要，这个词在 Stream 中出现的频率. 我知道我必须使用 collect(Collectors.groupingBy(..)
我是一名优秀的程序员,十分优秀！