<asp:DetailsView DataKeyNames="Articles_id" ID="dtlv_articles" runat="server" DefaultMode="Insert"  
        AutoGenerateRows="False"  OnItemInserted="dtlv_articles_Inserted"   >
     
       <Fields>
      <asp:BoundField DataField="Article_name" HeaderText="Article_name:" />
         <asp:TemplateField>
                <InsertItemTemplate>
                  <asp:TextBox ID="Article_name" runat="server"
                  Text='<%# Bind("Article_name") %>' /> 
                  <asp:Button ID="Button1" runat="server" CommandName="Insert"
                  Text="вставить" /> 
        </InsertItemTemplate>
       </asp:TemplateField>
                </Fields>
       </asp:DetailsView>

namespace TG.TopGun.BLL.Articles
{

    public class Articles
    {
        private int article_id;

        public int Article_id
        {
            get { return article_id; }
            set { article_id = value; }
        }

        string article_name;

        public string Article_name
        {
            get { return article_name; }
            set { article_name = value; }
        }

        string article_text;

        public string Article_text
        {
            get { return this.article_text; }
            set { this.article_text = value; }
        }

        string article_author;

        public string Article_author
        {
            get { return article_author; }
            set { article_author = value; }
        }

        DateTime article_date;

        public DateTime Article_date
        {
            get { return this.article_date; }
            set { this.article_date = value; }
        }


     

        public Articles(int id, string name, string text,string author, DateTime date)
        {
            this.Article_id = id;
            this.Article_name = name;
            this.Article_text = text;
            this.Article_author = author;
            this.Article_date = date;
        }

      
        
        
        public static Articles GetArticlesFromArticlesDetails(ArticlesDetails record)

        { 

        if (record==null)
            return null;
        else { return new Articles(record.Id, record.Name, record.Text, record.Author, record.Date); }
                
        }


        public static List<Articles> GetArticlesCollectionFromArticleDetailCollection(List<ArticlesDetails> recordset)
        { 
         List<Articles> articles = new List<Articles>();
         foreach (ArticlesDetails record in recordset)
            articles.Add(GetArticlesFromArticlesDetails(record));
         return articles;
             
        }


      public static List<Articles> GetArticles()
        {
            List<Articles> articles2;
            List<ArticlesDetails> recordset = ArticlesSqlProvider.GetArticles();
            articles2= GetArticlesCollectionFromArticleDetailCollection(recordset);
            return articles2;
                   

        }



    

      public static void InsertTest(string Name)
      {
          ArticlesDetails article = new ArticlesDetails(Name);
          ArticlesSqlProvider.InsertTest(article);
      }

 public ArticlesDetails(string name) {

           this.Name = name;
       }

  public static void InsertTest(ArticlesDetails article)
        {



            string conStr = Globals.Settings.Articles.ConnectionString;
            string command = "Insert Into Test (name) Values (@Article_name);";
            using (SqlConnection con = new SqlConnection(conStr))
            {

                SqlCommand com = new SqlCommand(command, con);
                com.Parameters.Add("@Article_name", SqlDbType.VarChar).Value = article.Name;
             
                con.Open();
                int i = com.ExecuteNonQuery();

            }
        }           

 protected void Page_Load(object sender, EventArgs e)
    {
      
        {

            ViewArticles.DataSource = getArticles;

            dtlv_articles.DataSource = insertTest;
            ViewArticles.DataBind();
                   
        

        }
    }
  
    protected void dtlv_articles_Inserted(object sender, DetailsViewInsertedEventArgs e)
    {
        
             Label1.Text = "Запись завершена";
    }