How to use SqlParameter with Update Query

[None]

Hi,

I have to update my table using SqlParameter. Below is my code for
update.

cmdText = "update docs set Content = @content where DirName='" +
DirName.Replace ("'","''") + "' and LeafName='Hidde n.txt'"
SqlCommand cmd = new SqlCommand();
cmd.CommandText = cmdText;
cmd.Connection = con;
SqlParameter objParam = new SqlParameter("@ content", SqlDbType.Image ,
binFile.Length) ;
objParam.Direct ion = ParameterDirect ion.Input;
objParam.Value = binFile;
cmd.Parameters. Add(objParam);
int i = cmd.ExecuteNonQ uery()

when i execute this code it's returing i valu -1.(No records affected).
What is the problem in my code. If anbody knows please let me know to
solve it.
Thanks,
Vinoth

vi****@gsdindia .com

[Morten Wennevik]

Hi Vinoth,

Try using SqlParameters for all parameters.

"UPDATE docs SET Content = @content WHERE DirName = @dirname AND LeafName = @leafname"

This makes it much easier to debug.
You might also want to check out the ado.net newsgroup

microsoft.publi c.dotnet.framew ork.adonet
On Wed, 03 Aug 2005 07:58:57 +0200, None <vi********@gma il.com> wrote:

Hi,

I have to update my table using SqlParameter. Below is my code for
update.

cmdText = "update docs set Content = @content where DirName='" +
DirName.Replace ("'","''") + "' and LeafName='Hidde n.txt'"
SqlCommand cmd = new SqlCommand();
cmd.CommandText = cmdText;
cmd.Connection = con;
SqlParameter objParam = new SqlParameter("@ content", SqlDbType.Image ,
binFile.Length) ;
objParam.Direct ion = ParameterDirect ion.Input;
objParam.Value = binFile;
cmd.Parameters. Add(objParam);
int i = cmd.ExecuteNonQ uery()

when i execute this code it's returing i valu -1.(No records affected).
What is the problem in my code. If anbody knows please let me know to
solve it.
Thanks,
Vinoth

vi****@gsdindia .com

--
Happy coding!
Morten Wennevik [C# MVP]