将c＃decimal转换为SQL ??? [英] CONVERT c# decimal to SQL ???
问题描述
我在c＃中有小数：
十进制amounT = 62.75;
我需要将其插入到SQL记录中货币价值。
string strSQL2 =" INSERT INTO trvlDetail（amountfield）"" VALUES（''" +
amounT +" ''）" ;;
我应该在SQL中使用CONVERT（如果是这样，怎么样？）或者什么是c＃中的
equivelent？
谢谢，
Trint
I have a decimal amount in c#:
decimal amounT = 62.75;
and I need INSERT it into a SQL record as a money value.
string strSQL2 = "INSERT INTO trvlDetail(amountfield) ""VALUES (''" +
amounT + "'') ";
Should I use a CONVERT in SQL (if so, how?) or what would be the
equivelent in c#?
Thanks,
Trint
推荐答案
你好Trint，
使用SqlParameter，它会为你转换
decimal amounT = 62.75;
SqlParameter param = new SqlParameter（@amounT ，amounT）;
string strSQL2 =" INSERT INTO trvlDetail（amountfield）VALUES（@ amounT）" ;;
SqlCommand insertCommand = new SqlCommand（strSQL2，SqlConnection1）;
insertCommand.Parameters.Add（param）;
SqlConnection1.Open（）;
inser tCommand.ExecuteNonQuery（）;
SqlConnection1.Close（）;
2005年4月20日星期三14:22:49 +0200，trint< tr **** *******@gmail.com>写道：
Hi Trint,
Use an SqlParameter, it will convert for you
decimal amounT = 62.75;
SqlParameter param = new SqlParameter(@amounT, amounT);
string strSQL2 = "INSERT INTO trvlDetail(amountfield) VALUES (@amounT)";
SqlCommand insertCommand = new SqlCommand(strSQL2, SqlConnection1);
insertCommand.Parameters.Add(param);
SqlConnection1.Open();
insertCommand.ExecuteNonQuery();
SqlConnection1.Close();
On Wed, 20 Apr 2005 14:22:49 +0200, trint <tr***********@gmail.com> wrote:
decimal amounT = 62.75;
decimal amounT = 62.75;
-
快乐编码！
Morten Wennevik [C＃MVP]
--
Happy coding!
Morten Wennevik [C# MVP]
嗨Trint，
使用SqlParameter，它将转换为你是
十进制amounT = 62.75;
SqlParameter param = new SqlParameter（@ amounT，amounT）;
string strSQL2 =" INSERT INTO trvlDetail（amountfield）VALUES（@ amounT）" ;;
SqlCommand insertCommand = new SqlCommand（strSQL2，SqlConnection1）;
insertCommand.Parameters.Add（param）;
SqlConnection1.Open（）;
insertCommand.ExecuteNonQuery（）;
SqlConnection1.Close（）;
2005年4月20日星期三14:22:49 +0200，trint< tr *********** @ gmail.com> ;写道：
Hi Trint,
Use an SqlParameter, it will convert for you
decimal amounT = 62.75;
SqlParameter param = new SqlParameter(@amounT, amounT);
string strSQL2 = "INSERT INTO trvlDetail(amountfield) VALUES (@amounT)";
SqlCommand insertCommand = new SqlCommand(strSQL2, SqlConnection1);
insertCommand.Parameters.Add(param);
SqlConnection1.Open();
insertCommand.ExecuteNonQuery();
SqlConnection1.Close();
On Wed, 20 Apr 2005 14:22:49 +0200, trint <tr***********@gmail.com> wrote:
decimal amounT = 62.75;
decimal amounT = 62.75;
-
快乐编码！
Morten Wennevik [C＃MVP]
--
Happy coding!
Morten Wennevik [C# MVP]
谢谢！
..Net程序员
< a href =mailto：tr *********** @ gmail.com> tr *********** @ gmail.com
***通过开发人员指南 http://www.developersdex.com ***
Thanks!
..Net programmer
tr***********@gmail.com
*** Sent via Developersdex http://www.developersdex.com ***
这篇关于将c＃decimal转换为SQL ???的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
