将VS2010与SQLSERVER 2012一起使用 [英] Using VS2010 with SQLSERVER 2012
本文介绍了将VS2010与SQLSERVER 2012一起使用的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
您好,我在将数据从我的应用程序插入数据库时遇到了一些问题。连接或尝试插入数据库时,我没有收到任何错误,但数据没有插入。我使用Visual Studio 2010和C#以及SQL SERVER Management Studio 2012.这是我的代码:
使用系统;
使用 System.Collections.Generic;
使用 System.Linq;
使用 System.Web;
使用 System.Web.Configuration;
使用 System.Data;
使用 System.Data.SqlClient;
< summary>
摘要说明 for 来源
< / 摘要 >
public class 来源
{
private string conString;
public int mSourceID;
public string mSourceName;
public int mActive;
public Sources()
{
conString = WebConfigurationManager.ConnectionStrings [ dbconstring]。ConnectionString;
mSourceID = 0 ;
mSourceName = ;
mActive = 0 ;
}
public void insertData()
{
使用(SqlConnection con = new SqlConnection(conString))
{
con.Open();
尝试
{
使用(SqlCommand cmd = new SqlCommand( INSERT INTO dbo.Sources(SourceID,SourceName,Active )VALUES(@ SourceID,@ SourceName,@ Active),con))
{
cmd.Parameters.Add( new SqlParameter( SourceID,mSourceID));
cmd.Parameters.Add( new SqlParameter( SourceName,mSourceName));
cmd.Parameters.Add( new SqlParameter( 活跃,mActive));
}
}
catch (Ex Ex)
{
Console.WriteLine( 无法保存数据。错误 - + Ex.Message);
}
}
}
}
protected void btnOk_Click( object sender, ImageClickEventArgs e)
{
来源src = 新来源();
src.mSourceID = 1 ;
src.mSourceName = aboa;
src.mActive = 0 ;
src.insertData();
}
解决方案
您忘了执行查询:
使用(SqlCommand cmd = new SqlCommand( INSERT INTO dbo.Sources(SourceID,SourceName,Active)VALUES(@ SourceID,@ SourceName,@ Active),con))
{
cmd.Parameters.Add( new SqlParameter( SourceID,mSourceID));
cmd.Parameters.Add( new SqlParameter( SourceName,mSourceName));
cmd.Parameters.Add( new SqlParameter( 活跃,mActive));
cmd.ExecuteNonQuery(); // < ----添加此行
}
Hello, i'm having a little problem inserting data from my application into my database. I do not get any errors while connecting or trying to insert into the database but data just doesn't get inserted. I use Visual Studio 2010 with C# And SQL SERVER Management Studio 2012. Here is my code:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Configuration;
using System.Data;
using System.Data.SqlClient;
<summary>
Summary description for Sources
</summary>
public class Sources
{
private string conString;
public int mSourceID;
public string mSourceName;
public int mActive;
public Sources()
{
conString = WebConfigurationManager.ConnectionStrings["dbconstring"].ConnectionString;
mSourceID = 0;
mSourceName = "";
mActive = 0;
}
public void insertData()
{
using (SqlConnection con = new SqlConnection(conString))
{
con.Open();
try
{
using (SqlCommand cmd = new SqlCommand("INSERT INTO dbo.Sources(SourceID, SourceName, Active) VALUES(@SourceID, @SourceName, @Active)", con))
{
cmd.Parameters.Add(new SqlParameter("SourceID", mSourceID));
cmd.Parameters.Add(new SqlParameter("SourceName", mSourceName));
cmd.Parameters.Add(new SqlParameter("Active", mActive));
}
}
catch (Exception Ex)
{
Console.WriteLine("Unable To Save Data. Error - " + Ex.Message);
}
}
}
}
protected void btnOk_Click(object sender, ImageClickEventArgs e)
{
Sources src = new Sources();
src.mSourceID = 1;
src.mSourceName = "aboa";
src.mActive = 0;
src.insertData();
}
解决方案
You forgot to execute the query:
using (SqlCommand cmd = new SqlCommand("INSERT INTO dbo.Sources(SourceID, SourceName, Active) VALUES(@SourceID, @SourceName, @Active)", con)) { cmd.Parameters.Add(new SqlParameter("SourceID", mSourceID)); cmd.Parameters.Add(new SqlParameter("SourceName", mSourceName)); cmd.Parameters.Add(new SqlParameter("Active", mActive)); cmd.ExecuteNonQuery(); // <---- ADD THIS LINE }
这篇关于将VS2010与SQLSERVER 2012一起使用的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文