Go Back   Velocity Reviews > General Computer Discussion > Software
User Name
Password
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread
Old 11-10-2007, 06:26 AM   #1
Default Must declare the scalar variable "@Product_ID".


hi friends.....
i'm using the following code to save an image to SQLSERVER2005using asp.net.
i got the error message Must declare the scalar variable "@Product_ID". while running the code
.
please help me..
its urgent



cn = New System.Data.OleDb.OleDbConnection(" Provider=SQLOLEDB;SERVER=SERVER\SQLEXPRESS;UID=sa; PASSWORD=kadavan2486;DATABASE=Hard1;Persist Security Info=True;")
cn.Open()
cm.Connection = cn
cm.Parameters.Clear()
cm.Parameters.Add("@Product_ID", OleDbType.BigInt, 4)
cm.Parameters.Add("@Img", OleDbType.VarBinary, img.Length)
cm.Parameters("@Product_ID").Value = 1
cm.Parameters("@Img").Value = img

cm.CommandText = "insert into Product_Small_Image(Product_ID,Img) values(@Product_ID ,@Img)"
cm.ExecuteNonQuery()
cn.Close()


iquad
iquad is offline   Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Passing value with out using variable in query string in PHP! Ali_ggl General Help Related Topics 0 11-29-2008 12:22 PM
How to set another machine's environment variable? vinay.babu Software 0 10-16-2008 12:54 PM
Variable scope toller Hardware 1 04-21-2008 08:28 PM
Variable Scope in asp.Net jansi_rk Software 1 09-18-2006 06:05 PM
What's available in variable speed VCR's ? E. Matthews DVD Video 3 10-20-2005 11:44 AM




SEO by vBSEO 3.3.2 ©2009, Crawlability, Inc.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46