Article.css类using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
namespace HeavenModels.Models
{
public class Article
{
public int ID { get; set; }
public int ClassID { get; set; }
public string Title { get; set; }
public string Author { get; set; }
public string CopyFrom { get; set; }
public string Keyword { get; set; }
public int Hits { get; set; }
public DateTime UpdateTime { get; set; }
public int OnTop { get; set; }
public int Elite { get; set; }
public int Status { get; set; }
public string Content { get; set; }
public string DefaultPicUrl { get; set; }
public int Deleted { get; set; } }
}ArticleDataContext.cs类using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
namespace HeavenModels.Models
{
public class ArticleDataContext
{
public static string connectionString = ConfigurationManager.ConnectionStrings["HeavenDB"].ConnectionString; public static string Admin_Article_Add()
{
.....
} public static IEnumerable<Article> GetArticleList()
{
List<Article> articles = new List<Article>(); using (SqlConnection connection = new SqlConnection(connectionString))
{
string commandText = "select * from He_Article";
using (SqlCommand command = new SqlCommand(commandText, connection))
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Article article = new Article(); article.ID = (int)reader["ID"];
article.ClassID = (int)reader["ClassID"];
article.Title = (string)reader["Title"];
article.Author = (string)reader["Author"];
article.CopyFrom = (string)reader["CopyFrom"];
article.Keyword = (string)reader["Keyword"];
article.Hits = (int)reader["Hits"];
article.UpdateTime = (DateTime)reader["UpdateTime"];
article.OnTop = (int)reader["OnTop"];
article.Elite = (int)reader["Elite"];
article.Status = (int)reader["Status"];
article.Content = (string)reader["Content"];
article.DefaultPicUrl = (string)reader["DefaultPicUrl"];
article.Deleted = (int)reader["Deleted"]; articles.Add(article);
}
connection.Close();
}
}
return articles;
} }
}
请问Admin_Article_Add方法,如何将数据写入数据库
using System.Collections.Generic;
using System.Linq;
using System.Web;
namespace HeavenModels.Models
{
public class Article
{
public int ID { get; set; }
public int ClassID { get; set; }
public string Title { get; set; }
public string Author { get; set; }
public string CopyFrom { get; set; }
public string Keyword { get; set; }
public int Hits { get; set; }
public DateTime UpdateTime { get; set; }
public int OnTop { get; set; }
public int Elite { get; set; }
public int Status { get; set; }
public string Content { get; set; }
public string DefaultPicUrl { get; set; }
public int Deleted { get; set; } }
}ArticleDataContext.cs类using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data.SqlClient;
namespace HeavenModels.Models
{
public class ArticleDataContext
{
public static string connectionString = ConfigurationManager.ConnectionStrings["HeavenDB"].ConnectionString; public static string Admin_Article_Add()
{
.....
} public static IEnumerable<Article> GetArticleList()
{
List<Article> articles = new List<Article>(); using (SqlConnection connection = new SqlConnection(connectionString))
{
string commandText = "select * from He_Article";
using (SqlCommand command = new SqlCommand(commandText, connection))
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Article article = new Article(); article.ID = (int)reader["ID"];
article.ClassID = (int)reader["ClassID"];
article.Title = (string)reader["Title"];
article.Author = (string)reader["Author"];
article.CopyFrom = (string)reader["CopyFrom"];
article.Keyword = (string)reader["Keyword"];
article.Hits = (int)reader["Hits"];
article.UpdateTime = (DateTime)reader["UpdateTime"];
article.OnTop = (int)reader["OnTop"];
article.Elite = (int)reader["Elite"];
article.Status = (int)reader["Status"];
article.Content = (string)reader["Content"];
article.DefaultPicUrl = (string)reader["DefaultPicUrl"];
article.Deleted = (int)reader["Deleted"]; articles.Add(article);
}
connection.Close();
}
}
return articles;
} }
}
请问Admin_Article_Add方法,如何将数据写入数据库
解决方案 »
- 关于VS2005中的问题
- 我把新做好的网站上传到asp.net空间的子目录下,怎么不行啊?急...
- .net生成静态页问题,谁有源码能否提供一下,在网上找了老出错
- [高手请看]OleDbDataReader奇怪的问题
- 请教一下formview中的问题
- 向Access数据库插数据,总是报错,怎么解决啊?(急,急,急!)
- 来个 dnn5.o的安装视频 或详细的安装步骤
- 请问web.config里的数据库路径怎么才能改成相对路径?
- bonnie168(虚拟过客.net)进来领分
- 我用 DataSet ds = new ..ds.ReadXml( sXml );读后表中却不显示正确的记录集,例如我取第一个字段数据::
- 权限问题,求各位大虾帮忙看看,在线等,急急急。。。
- 在与 SQL Server 建立连接时出现与网络相关的或特定于实例的错误。未找到或无法访问服务器。请验证实例名称是否正确并且 SQL Server 已配置为允许
Mvc中不是这样用的
建议你看看Mvc的教程
www.asp.net
insert into 表名(列名) values(列值)
http://terrylee.blog.51cto.com/342737/67778