| |
|
Dim byFile() as Byte = GetPhoto(“C:\test.txt“)
SqlConnection conn = new SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=TESTDATABASE;");
SqlCommand cmd = new SqlCommand("INSERT INTO DOCS ([Document]) " +
"Values(@File)", Conn);
cmd .Parameters.Add(“@File", SqlDbType.Image, photo.Length).Value = byFile;
conn.Open(); // Open Connection
cmd.ExecuteNonQuery(); //Execute Query
conn.Close(); //Close Connection |