Click here to Skip to main content
15,917,971 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: how can i use values form one form to another in vb.net Pin
tjskcp5-Mar-08 18:07
tjskcp5-Mar-08 18:07 
GeneralLighttpd & HTTPWEBREQUEST question Pin
Daniel Lopez28-Feb-08 17:35
Daniel Lopez28-Feb-08 17:35 
Questionmenu strip Pin
Tauseef A28-Feb-08 17:23
Tauseef A28-Feb-08 17:23 
GeneralRe: menu strip Pin
Xmen Real 28-Feb-08 17:38
professional Xmen Real 28-Feb-08 17:38 
Generalerror-cannot check the checkbox in datagrid after 2nd search Pin
Eunice (VB junior)28-Feb-08 14:51
Eunice (VB junior)28-Feb-08 14:51 
QuestionSave image in PostgresSQL DB Pin
nishkarsh_k28-Feb-08 8:56
nishkarsh_k28-Feb-08 8:56 
GeneralRe: Save image in PostgresSQL DB Pin
Christian Graus28-Feb-08 9:32
protectorChristian Graus28-Feb-08 9:32 
GeneralRe: Save image in PostgresSQL DB Pin
nishkarsh_k28-Feb-08 18:08
nishkarsh_k28-Feb-08 18:08 
Can you please give me any sample code to insert... I am having issues with it..

The code i am using is as follows


Dim inputFileStream As New FileStream("C:\test.gif", FileMode.Open, FileAccess.Read)
Dim reader As New BinaryReader(inputFileStream)
Dim bytes() As Byte

bytes = reader.ReadBytes(CInt(inputFileStream.Length))

inputFileStream.Close()

Dim Sql As String = "INSERT INTO im_prescription_image (st_image_name,im_image) VALUES (?,?)"
Dim Cmd As New Npgsql.NpgsqlCommand(Sql, cnn)
Cmd.Parameters.Add("@st_image_name", NpgsqlTypes.NpgsqlDbType.Varchar).Value = "as10000000000000"
Cmd.Parameters.Add("@im_image", bytes)

'cnn.Open()
Cmd.ExecuteNonQuery()
cnn.Close()



I am grtting the following error

Npgsql.NpgsqlException was unhandled
BaseMessage="syntax error at or near ",""
Code="42601"
Detail=""
ErrorSql="INSERT INTO im_prescription_image (st_image_name,im_image) VALUES (?,?)"
File="scan.l"
Hint=""
GeneralRe: Save image in PostgresSQL DB Pin
Christian Graus28-Feb-08 18:29
protectorChristian Graus28-Feb-08 18:29 
QuestionNeed Help... Dial, Connect and Use a BBS in VB.Net Pin
Scyrious28-Feb-08 5:03
Scyrious28-Feb-08 5:03 
GeneralRe: Need Help... Dial, Connect and Use a BBS in VB.Net Pin
Christian Graus28-Feb-08 9:38
protectorChristian Graus28-Feb-08 9:38 
GeneralRe: Need Help... Dial, Connect and Use a BBS in VB.Net Pin
Scyrious29-Feb-08 3:12
Scyrious29-Feb-08 3:12 
QuestionAdd records to databound datagridview Pin
David Mujica28-Feb-08 4:40
David Mujica28-Feb-08 4:40 
GeneralRe: Add records to databound datagridview Pin
Dave Kreskowiak29-Feb-08 3:21
mveDave Kreskowiak29-Feb-08 3:21 
AnswerWorking now Pin
David Mujica29-Feb-08 9:39
David Mujica29-Feb-08 9:39 
QuestionAcessing certificate store of local system Pin
shinlang28-Feb-08 3:51
shinlang28-Feb-08 3:51 
GeneralRe: Acessing certificate store of local system Pin
Dave Kreskowiak29-Feb-08 3:27
mveDave Kreskowiak29-Feb-08 3:27 
GeneralCan't find appropriate control Pin
cstrader23228-Feb-08 3:32
cstrader23228-Feb-08 3:32 
GeneralRe: Can't find appropriate control Pin
Xmen Real 28-Feb-08 3:42
professional Xmen Real 28-Feb-08 3:42 
GeneralRe: Can't find appropriate control Pin
cstrader23228-Feb-08 4:01
cstrader23228-Feb-08 4:01 
GeneralRe: Can't find appropriate control Pin
Xmen Real 28-Feb-08 4:36
professional Xmen Real 28-Feb-08 4:36 
GeneralRe: Can't find appropriate control Pin
cstrader23228-Feb-08 4:57
cstrader23228-Feb-08 4:57 
QuestionMySQL Database entry problem Pin
freefika28-Feb-08 3:05
freefika28-Feb-08 3:05 
GeneralRe: MySQL Database entry problem Pin
Dave Kreskowiak29-Feb-08 3:40
mveDave Kreskowiak29-Feb-08 3:40 
Questionvector Pin
Danisto27-Feb-08 23:13
Danisto27-Feb-08 23:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.