111,098
社区成员




<connectionStrings>
<add name="CourseSystemApplicationFin.Properties.Settings.CourseSystemDBConnectionString1"
connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\CourseSystemDB.mdf;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
[/quote]是这样的?我不太懂sql server,但是我会mysql,不是应该设置数据库的权限名,密码,IP,table以及编码方式等等嘛
<connectionStrings>
<add name="CourseSystemApplicationFin.Properties.Settings.CourseSystemDBConnectionString1"
connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\CourseSystemDB.mdf;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
[/quote]你这个根本没有你database的名字,你怎么可能加的进去。string dataDir = AppDomain.CurrentDomain.BaseDirectory;
if (dataDir.EndsWith(@"\bin\Debug\") || dataDir.EndsWith(@"\bin\Release\"))
{
dataDir = System.IO.Directory.GetParent(dataDir).Parent.Parent.FullName;
AppDomain.CurrentDomain.SetData("DataDirectory", dataDir);
}
然后就能行了。
不过不太懂代码的意思。string constr = "server=.;database=myschool;integrated security=SSPI";
//string constr = "server=.;database=myschool;uid=sa;pwd=sa";
//string constr = "data source=.;initial catalog=myschool;user id=sa;pwd=sa";
SqlConnection con = new SqlConnection(constr);
//con.ConnectionString = constr;
<connectionStrings>
<add name="CourseSystemApplicationFin.Properties.Settings.CourseSystemDBConnectionString1"
connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\CourseSystemDB.mdf;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
[/quote]是这样的?我不太懂sql server,但是我会mysql,不是应该设置数据库的权限名,密码,IP,table以及编码方式等等嘛
<connectionStrings>
<add name="CourseSystemApplicationFin.Properties.Settings.CourseSystemDBConnectionString1"
connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\CourseSystemDB.mdf;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
[/quote]
<connectionStrings>
<add name="CourseSystemApplicationFin.Properties.Settings.CourseSystemDBConnectionString1"
connectionString="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\CourseSystemDB.mdf;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>
using (SqlConnection conn = new SqlConnection(connectionString))
{
string selectSqlString = insert into stu_cour_conn(stu_id,cour_id) values('"+user_id+"','"+cour_id+"');
SqlCommand cmd = new SqlCommand(selectSqlString,conn);
try
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
int i = cmd.ExecuteNonQuery();
MessageBox.Show(string.Format("成功修改{0}条记录", i));
conn.Close();
}
}
catch(Exception ex)
{
MessageBox.Show(string.Format("操作失败:{0}", ex.Message));
}
}
//应该是sql语句错误 INSERT INTO 表名(列1,列2,列3) VALUES(值1,值2,值3);