visual studio 2013数据库.mdf添加查询 [英] visual studio 2013 database .mdf add query
本文介绍了visual studio 2013数据库.mdf添加查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
你好我想在vs 2013中做一个简单的添加到.mdf数据库文件
i am getting
sqlexception error and它在这上面说
附加信息:@ProductType'附近的语法不正确。
[code]
private void btnAddProd_Click( object sender,RoutedEventArgs e)
{
// 验证方法
product = new 产品(txtProductName.Text,txtProductCost.Text,txtProductType.Text);
// 与SQL的连接
using (SqlConnection conn = new SqlConnection( @ 数据源=(LocalDB)\ v11.0; AttachDbFilename ='E:\Visual Studio 2013 \Projects\WpfApplication1 \WpfApplication1 \ musicicStore.mdf'; Integrated Security = True ))
{
SqlCommand cmd = new SqlCommand( INSERT INTO Products(ProductName,ProductCost,ProductType)值(@ ProductName,@ ProductCost,@ ProductType,conn);
cmd.Parameters.AddWithValue(< span class =code-string> @ ProductName,txtProductName.Text); // product.ProductName
cmd.Parameters.AddWithValue( @ ProductCost,txtProductCost.Text);
cmd.Parameters.AddWithValue( @ ProductType,txtProductType.Text);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
[/ code]
解决方案
你错过了关闭的SQL命令!!!
SqlCommand cmd = new SqlCommand( INSERT INTO Products(ProductName,ProductCost,ProductType)值(@ ProductName,@ ProductCost,@ ProductType),conn);
hello i am trying to do a simple add to a .mdf database file in vs 2013
i am getting
sqlexception error and it says on this
"Additional information: Incorrect syntax near '@ProductType'."
[code]
private void btnAddProd_Click(object sender, RoutedEventArgs e)
{
//validate method
product = new Product(txtProductName.Text, txtProductCost.Text, txtProductType.Text);
//connection to SQL
using (SqlConnection conn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename='E:\Visual Studio 2013\Projects\WpfApplication1\WpfApplication1\musicStore.mdf';Integrated Security=True"))
{
SqlCommand cmd = new SqlCommand("INSERT INTO Products(ProductName, ProductCost, ProductType) Values(@ProductName, @ProductCost, @ProductType", conn);
cmd.Parameters.AddWithValue("@ProductName", txtProductName.Text); // product.ProductName
cmd.Parameters.AddWithValue("@ProductCost", txtProductCost.Text);
cmd.Parameters.AddWithValue("@ProductType", txtProductType.Text);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
[/code]
解决方案
You are missing the closing ) of your SQL command!!!
SqlCommand cmd = new SqlCommand("INSERT INTO Products(ProductName, ProductCost, ProductType) Values(@ProductName, @ProductCost, @ProductType)", conn);
这篇关于visual studio 2013数据库.mdf添加查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文