Database

roachae wrote:

my database table already has a row entry, so storing the images are going to be an update into that row, rather than an insert

UPDATE SomeTable
SET ImageColumn = @Image
WHERE KeyColumn = @Key

roachae wrote:

Like I said, the images are of signatures captured from a signature pad, so there's no real file there until someone signs the signature pad and the image is placed within the webform

roachae wrote:

How would I use File.ReadAllBytes? I'm not finding that anywhere

Seller
- Seller# int, identity, primary key, not null 
  (surrogate key)
- Name    varchar, unique key, not null 
  (Seller name if needed)
- Id      int, unique key, not null 
  (Id to show along with the product id)
...

Product
- Product# int, identity, primary key, not null
  (surrogate key)
- Seller#  int, foreign key, unique key (with Id), not null
  (Reference to seller)
- Id       varchar, unique key (with Seller#), not null
  (Id to show along with the seller id)
...

Seller# Name Id
------- ---- --
1       XYZ  05
 
Product# Seller# Id
-------- ------- ---------
1        1       123456
2        1       98765

Deepali Khalkar wrote:

I cannot read and write the data to the table made in SQL server 2005 to c# form

Deepali Khalkar wrote:

help me with the steps for database connectivity

select max(convert(int, substring(id, 4, 9999)))
from tablename
where id like '09a%'

SELECT a.*, b.* 
FROM sometable as a 
     INNER JOIN 
     [;DATABASE=C:\...\database.mdb;PWD=yourpwd].othertable b 
     ON a.column = b.column
WHERE ...