Insert password into "users"
Tue Dec 14 2021 14:39:24 GMT+0000 (Coordinated Universal Time)
Saved by
@jason017
Random random = new Random();
int num = random.Next(10000000);
string numy = num.ToString();
string connectionString = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=cms;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
SqlConnection connection = new SqlConnection(@connectionString);
string query = "INSERT INTO users (ID,Password) VALUES('"+numy+"','01')";
SqlCommand command = new SqlCommand(query, connection);
try
{
connection.Open();
command.ExecuteNonQuery();
MessageBox.Show("Records Inserted Successfully");
}
catch (SqlException x)
{
MessageBox.Show("Error Generated. Details: " + x.ToString());
}
finally
{
connection.Close();
}
content_copyCOPY
Comments
@jason017 - Tue Dec 14 2021 17:14:33 GMT+0000 (Coordinated Universal Time)qs