capturing images from imaging devices

Question

I am at the moment trying to solve a problem that involves imaging .This being a web based application now has a new business need that involves capturing images from imaging devices such as cameras , scanners , web cams . The web application needs to be modified for this new functionality to take effect .The web application was written using the visual studio frame work in the c# programming language . Please do tell if you may know of how to make changes to add an imaging functionality into such an application . in the mean time , i do have a request .I would like to have an application that has been written in c# for the purpose of a web cam sent to my inbox as an attachment to an email , i have been trying to download what is there in the site , but nothing seems to be moving . I would like to use the application as a building block for problem solving as per my imaging issue .

Regards

Emmanuel

Answer 1

Correct sSql string is follows..
sSQL = "Insert into Transaction_Line (TransL_id,Trans_id, TL_dt, Pro_id, Quantity)" & _
"values('" & TransLid & "', '" & transID & "', '" & TLdte & "', '" & proID & "', '" & quan & "')"

Change transID Position in values it will be in 2nd position.
 

Answer 2

hi

i think you have taken date field value int not datetime or varchar . That's why you are getting this error.

please change it to datetime.

Don't forget to Mark Do you like this Answer  that solved your problem!

Answer 3

TransL_id: Varchar(25)
Trans_id: int
Pro_id: Varchar(15)
Quantity: numeric(4, 0)
Total_price: numeric(10, 2)
TL_dt: varchar(50)
Share_h_id: varchar(10)

For the TL_dt  tried a dateandtime format but its not working at all it always retrieves an error... therefore i tried the varchar instead

Answer 4

Hi,
The error is  coming due to this sentence,
sSQL = "Insert into Transaction_Line (TransL_id,Trans_id, TL_dt, Pro_id, Quantity)" & _
"values('" & TransLid & "', '" & TLdte & "', '" & proID & "', '" & quan & "', '" & transID & "')"
 
In that u r trying to insert..
TransL_id (int)- > TransLid (int),
Trans_id (int) - > TLdte (date),
TL_dt (date) -> proID (int),
Pro_id - > quan ,
Quantity - > transID

Answer 5

Can you also post Transaction_Line table structure (Fields with DataType) ?