howto cause SqlDataSource to pass varchar vs. nvarchar

[nate]

How do I cause the update method of the SqlDataSource to pass a string as a
varchar vs. a nvarchar.
My database has varchars and when the update happens it errors out due to
the proceedure sending the update params as nvarchar.

 

[nate]

I guess that in addition, there is also an issue with the compilation of the
update string in general. For example when I run an update, I get an error
because an nvarchar(4000) is specified in the update string when really the
field is defined in the DB as nvarchar(100). The value being passed in
doesn't have anything in it either. In other words I don't fill in the text
box on the formview.

Isn't there some way to control the way that the db strings get compiled?

BTW.. What am I doing wrong in my other posts? I have posted maybe three
times within the last few months and never got any kind of response. Are my
questions just that retarded? Or do I have to get an msdn subscription.. Do
the msdn subscriber newsgroup QandA's show up in the non-msdn lists?