Click here to Skip to main content
15,914,500 members
Home / Discussions / Visual Basic
   

Visual Basic

 
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 
Hi!
I have a piece of code in which 2 entries are taken from the user:

1. Bank Name
2. Bank Logo (an image)

then, an sql query is created to store the information into a mysql database in which the field names and their datatypes are given below respectively:

1. Bank_Name - Varchar(50)
2. Bank_Logo - Long blob

both fields cannot contain null values. THe code is pasted below:

 <br />
<br />
Public Function InsertBank(StrQuery as string, name as String, image() as byte)<br />
{            <br />
            Dim Cn As New Odbc.OdbcConnection(ConString)<br />
            Dim cmd As New Odbc.OdbcCommand<br />
            cmd.CommandText = strQuery<br />
            <br />
            cmd.Parameters.Add("@BNAME", Odbc.OdbcType.VarChar)<br />
            cmd.Parameters.Add("@PIC", Odbc.OdbcType.Binary)<br />
            <br />
            cmd.Parameters("@BNAME").Value = name<br />
            cmd.Parameters("@PIC").Value = image<br />
<br />
            cmd.Connection = Cn<br />
            Cn.Open()<br />
            cmd.ExecuteNonQuery()<br />
            Cn.Close()<br />
}<br />


the strQuery which i am passing to the function is like below:

"Insert into tblBank (Bank_Name,Bank_Logo) values (@BNAME,@PIC)"

However, when i call the function i get an error that bank_name cannot contain null value. I have rechecked again and again, but the bank name does not have any null value, it is passing a value from the text box and it is passed perfectly well...i dunt know what the problem is...kindly help...its urgent!
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 
GeneralRe: vector Pin
Christian Graus27-Feb-08 23:18
protectorChristian Graus27-Feb-08 23:18 
GeneralRe: vector Pin
Colin Angus Mackay29-Feb-08 0:44
Colin Angus Mackay29-Feb-08 0:44 
GeneralRe: vector Pin
MidwestLimey29-Feb-08 5:58
professionalMidwestLimey29-Feb-08 5:58 
GeneralRe: vector Pin
Danisto2-Mar-08 19:36
Danisto2-Mar-08 19:36 
Questionvb code on dates Pin
Danisto27-Feb-08 21:58
Danisto27-Feb-08 21:58 
GeneralRe: vb code on dates Pin
Christian Graus27-Feb-08 22:58
protectorChristian Graus27-Feb-08 22:58 
GeneralRe: vb code on dates Pin
Paul Conrad28-Feb-08 6:43
professionalPaul Conrad28-Feb-08 6:43 
QuestionSearching a Specific Record from DB !! Pin
Vikrant Badhai27-Feb-08 21:27
Vikrant Badhai27-Feb-08 21:27 
AnswerRe: Searching a Specific Record from DB !! Pin
Christian Graus27-Feb-08 23:00
protectorChristian Graus27-Feb-08 23:00 
GeneralRe: Searching a Specific Record from DB !! Pin
Vikrant Badhai27-Feb-08 23:05
Vikrant Badhai27-Feb-08 23:05 
GeneralRe: Searching a Specific Record from DB !! Pin
Christian Graus27-Feb-08 23:10
protectorChristian Graus27-Feb-08 23:10 
GeneralRe: Searching a Specific Record from DB !! Pin
Thomas Krojer27-Feb-08 23:22
Thomas Krojer27-Feb-08 23:22 
GeneralRe: Searching a Specific Record from DB !! Pin
AndrewVos27-Feb-08 23:30
AndrewVos27-Feb-08 23:30 
GeneralRe: Searching a Specific Record from DB !! Pin
Dave Kreskowiak28-Feb-08 3:11
mveDave Kreskowiak28-Feb-08 3:11 
GeneralRe: Searching a Specific Record from DB !! Pin
Vikrant Badhai6-Mar-08 20:52
Vikrant Badhai6-Mar-08 20:52 

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.