是用来把FREETEXTBOX中的内容保存到数据库的
using System.Data .SqlClient;public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ } protected void Button1_Click(object sender, EventArgs e)
{
string con = "\'server=local;database=DataBase;uid=sa;pwd=\'";
string com="\"insert into test (contect) values(\'\"+FreeTextBox1.Text+\"\')\"";
SqlConnection myConn = new SqlConnection(con);
myConn.Open();
SqlCommand myCmd = new SqlCommand(com,con);
SqlDataReader sqlreader;
sqlreader = myCmd.ExecuteReader();
myConn.Close();
}
}提示错误:
错误 CS1502: 与“System.Data.SqlClient.SqlCommand.SqlCommand(string, System.Data.SqlClient.SqlConnection)”最匹配的重载方法具有一些无效参数
参数“2”: 无法从“string”转换为“System.Data.SqlClient.SqlConnection”
using System.Data .SqlClient;public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ } protected void Button1_Click(object sender, EventArgs e)
{
string con = "\'server=local;database=DataBase;uid=sa;pwd=\'";
string com="\"insert into test (contect) values(\'\"+FreeTextBox1.Text+\"\')\"";
SqlConnection myConn = new SqlConnection(con);
myConn.Open();
SqlCommand myCmd = new SqlCommand(com,con);
SqlDataReader sqlreader;
sqlreader = myCmd.ExecuteReader();
myConn.Close();
}
}提示错误:
错误 CS1502: 与“System.Data.SqlClient.SqlCommand.SqlCommand(string, System.Data.SqlClient.SqlConnection)”最匹配的重载方法具有一些无效参数
参数“2”: 无法从“string”转换为“System.Data.SqlClient.SqlConnection”
应该是
SqlCommand myCmd = new SqlCommand(com,myConn );
加\'做什么的难道你的数据库是05?