-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathDeviceInfoForm.cs
More file actions
70 lines (64 loc) · 2.34 KB
/
DeviceInfoForm.cs
File metadata and controls
70 lines (64 loc) · 2.34 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Diagnostics; // For Process (running ADB)
using System.IO; // For File.ReadAllText, File.ReadAllLines
using System.Windows.Forms; // For Windows Forms controls like TextBox
using System.Data.SqlClient;
using static System.Windows.Forms.VisualStyles.VisualStyleElement;
namespace FinalADB
{
public partial class DeviceInfoForm : Form
{
public DeviceInfoForm()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
string command = "adb shell getprop";
string outputFile = "device.txt";
var process = new Process
{
StartInfo = new ProcessStartInfo
{
FileName = "cmd.exe",
Arguments = $"/c {command} > {outputFile}",
RedirectStandardOutput = false,
UseShellExecute = true,
CreateNoWindow = true
}
};
process.Start();
process.WaitForExit();
if (File.Exists(outputFile))
{
textBox1.Text = File.ReadAllText(outputFile);
}
}
private void button2_Click(object sender, EventArgs e)
{
string[] lines = File.ReadAllLines("device.txt");
using (SqlConnection con = new SqlConnection("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=C:\\Users\\Spark\\OneDrive\\Documents\\FinalADB.mdf;Integrated Security=True;Connect Timeout=30"))
{
con.Open();
foreach (var line in lines)
{
SqlCommand cmd = new SqlCommand("INSERT INTO DeviceInfoTable (RawData) VALUES (@data)", con);
cmd.Parameters.AddWithValue("@data", line);
cmd.ExecuteNonQuery();
}
MessageBox.Show("Saved to database");
}
}
private void DeviceInfoForm_Load(object sender, EventArgs e)
{
}
}
}