Article.css类
- C# code
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类
- C# code
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方法,如何将数据写入数据库
------解决方案--------------------------------------------------------
insert into 表名(列名) values(列值)