01.
Connect_Base.connectionsql_1();
02.
using
(SqlConnection connection =
new
SqlConnection(Connect_Base.strcon))
03.
{
04.
String query =
"INSERT INTO count_email (mem_id,fname,lname,email,Count) VALUES (@mem_id,@fname,@lname, @email,@Count)"
;
05.
06.
using
(SqlCommand command =
new
SqlCommand(query, connection))
07.
{
08.
command.Parameters.AddWithValue(
"@mem_id"
, label6.Text);
09.
command.Parameters.AddWithValue(
"@fname"
, label7.Text);
10.
command.Parameters.AddWithValue(
"@lname"
, label8.Text);
11.
command.Parameters.AddWithValue(
"@email"
, textBox3.Text);
12.
command.Parameters.AddWithValue(
"@Count"
,
""
);
13.
14.
connection.Open();
15.
command.ExecuteNonQuery();