Refer below code and modify as per your need.
C#
protected void btnData_Click(object sender, EventArgs e)
{
string[] split = { "\r\n" };
string[] splits = { " Valoare: " };
string febra = TextBox1.Text.Split(split, StringSplitOptions.None)[0].Split(splits, StringSplitOptions.None)[1];
string aiurea = TextBox1.Text.Split(split, StringSplitOptions.None)[1].Split(splits, StringSplitOptions.None)[1];
string respiratie = TextBox1.Text.Split(split, StringSplitOptions.None)[2].Split(splits, StringSplitOptions.None)[1];
string inghitire = TextBox1.Text.Split(split, StringSplitOptions.None)[3].Split(splits, StringSplitOptions.None)[1];
string paf = TextBox1.Text.Split(split, StringSplitOptions.None)[4].Split(splits, StringSplitOptions.None)[1];
string sunet = TextBox1.Text.Split(split, StringSplitOptions.None)[5].Split(splits, StringSplitOptions.None)[1];
String CS = ConfigurationManager.ConnectionStrings["MyDatabaseConnectionString2"].ConnectionString;
using (SqlConnection con = new SqlConnection(CS))
{
using (SqlCommand cmd = new SqlCommand("insert into Laringita2 values(@Nume_pacient,@Diagnostic,@CNP_pacient,@Data_curenta,@status,@camp_febra,@camp_aiurea,@camp_respiratie,@camp_inghitire,@camp_paf,@camp_sunet)", con))
{
cmd.Parameters.AddWithValue("@Nume_pacient", txtNume.Text);
cmd.Parameters.AddWithValue("@Diagnostic", txtDiagnostic.Text);
cmd.Parameters.AddWithValue("@CNP_pacient", txtCNP.Text);
cmd.Parameters.AddWithValue("@Data_curenta", txtData.Text);
cmd.Parameters.AddWithValue("@status", "nou");
cmd.Parameters.AddWithValue("@camp_febra", febra);
cmd.Parameters.AddWithValue("@camp_aiurea", aiurea);
cmd.Parameters.AddWithValue("@camp_respiratie", respiratie);
cmd.Parameters.AddWithValue("@camp_inghitire", inghitire);
cmd.Parameters.AddWithValue("@camp_paf", paf);
cmd.Parameters.AddWithValue("@camp_sunet", sunet);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}