C#应用——byte[]转short数组、C#调用cmd命令导出数据库

byte[]转short数组

publicshort[] byteArray2ShortArray(byte[] data, int items) {
　　short[] retVal =newshort[items];
　　for (int i =0; i < retVal.length; i++)
　　retVal[i] = (short) ((data[i *2]&0xff) | (data[i *2+1]&0xff) <<8);

　　return retVal;
}

C#调用cmd命令导出数据库

1. 在我的电脑——属性——高级系统设置——环境变量和系统变量中，增加C:\Program Files\MySQL\MySQL Server 8.0\bin后重新启动电脑。
2. 执行导出命令

 string mysqlPath = @"C:\Program Files\MySQL\MySQL Server 8.0\bin";
 string dbName = tbxDatabase.Text;
 string username = tbxUid.Text;
 ProcessStartInfo psi = new ProcessStartInfo();
 psi.FileName = "cmd.exe";
 psi.RedirectStandardInput = true;
 psi.RedirectStandardOutput = true;
 psi.RedirectStandardError = true; // 添加对错误消息的处理
 psi.UseShellExecute = false;
 psi.CreateNoWindow = false;

 Process process = Process.Start(psi);
 process.StandardInput.WriteLine($"cd {mysqlPath}");
 process.StandardInput.WriteLine($"mysqldump -h localhost -u {username} -p {dbName} > {exportFilePath}");
 
 process.StandardInput.Flush();
 process.StandardInput.Close();
 process.WaitForExit();
 var output = process.StandardOutput.ReadToEnd();
 string error = process.StandardError.ReadToEnd();

https://blog.csdn.net/fuhanghang/article/details/130848671