[ASP.NET]数据写入数据库的问题
我是个新手,大家帮我看看是哪错了,总也写不到数据库中去
string lmmc = this.DropDownList2.SelectedValue;
string title = this.TextBox3.Text.Trim();
string writer = this.TextBox4.Text.Trim();
DateTime time = DateTime.Now;
string isjd = this.DropDownList1.SelectedValue;
string content = this.TextBox6.Text.Trim();
using (SqlConnection conn = new SqlConnection(SQLHelper.ConnectionString))
{
SqlCommand myCommand = new SqlCommand();
myCommand.CommandText = "insert into newsinfo(lmmc,title,writer,publishtime,isjd,content) values('" + lmmc + "','" + title + "','" + writer + "'," + time + ",'" + isjd + "','" + content + "')";
//string strsql = "insert into newsinfo(lmmc,title,writer,publishtime,isjd,content) values ('" + lmmc + "','" + title + "','" + writer + "'," + time + ",'" + isjd + "','" + content + "')";
myCommand.Connection = conn;
conn.Open();
myCommand.ExecuteNonQuery();
conn.Close();
}
string lmmc = this.DropDownList2.SelectedValue;
string title = this.TextBox3.Text.Trim();
string writer = this.TextBox4.Text.Trim();
DateTime time = DateTime.Now;
string isjd = this.DropDownList1.SelectedValue;
string content = this.TextBox6.Text.Trim();
using (SqlConnection conn = new SqlConnection(SQLHelper.ConnectionString))
{
SqlCommand myCommand = new SqlCommand();
myCommand.CommandText = "insert into newsinfo(lmmc,title,writer,publishtime,isjd,content) values('" + lmmc + "','" + title + "','" + writer + "'," + time + ",'" + isjd + "','" + content + "')";
//string strsql = "insert into newsinfo(lmmc,title,writer,publishtime,isjd,content) values ('" + lmmc + "','" + title + "','" + writer + "'," + time + ",'" + isjd + "','" + content + "')";
myCommand.Connection = conn;
conn.Open();
myCommand.ExecuteNonQuery();
conn.Close();
}
...全文
相关推荐
asp.net 转换Access数据库为Excel文件源码
**错误处理**:在实际应用中,一定要处理可能出现的异常,如数据库连接问题、权限问题、文件I/O错误等。
asp.net实验:数据库写入不成功
🏆本文收录于《CSDN问答解惑-专业版》专栏,主要记录项目实战过程中的Bug之前因后果及提供真实有效的解决方案,希望能够助你一臂之力,帮你早日登顶实现财富自由🚀;同时,欢迎大家关注&&收藏&&订阅!持续更新中,up!up!up!!
ASP.NET MVC与Azure数据库的完美结合
通过确保数据库迁移正确、配置Azure SQL数据库的访问权限和调整应用程序的连接字符串,您的ASP.NET MVC应用程序应该能够在Azure App Service上正常运行,完成所有数据库写入操作。这不仅解决了部署后出现的问题,也提升了应用程序的可靠性和稳定性。
jsp和asp.net共享session值示例代码
存放登录成功后的用户编号fieldname: power (int) - 存放用户的权限编号```登录成功后,ASP.NET应用应将Session值写入数据库。
asp.net将Excel数据写入Access数据库中
在IT行业中,将数据从Excel导入到数据库是常见的数据处理任务,特别是在数据分析、报表生成或系统集成等场景。本文将详细讲解如何使用ASP.NET技术将Excel数据写入Access数据库。


