ado.net insert into kod örneği

        SqlConnection con=new SqlConnection (ConfigurationManager.ConnectionStrings["Baglan"].ConnectionString);

        con.Open();

        SqlCommand com = new SqlCommand("INSERT TBL_MAKALE
        (KAT_ID,BASLIK,ICERIK,EKLENME_TARIH)VALUES(@KAT_ID,@BASLIK,@ICERIK,@EKLENME_TARIH)"
, con);

        com.Parameters.AddWithValue("@KAT_ID", DropDownList1.SelectedValue);

        com.Parameters.AddWithValue("@BASLIK",txtBaslik.Text);

        com.Parameters.AddWithValue("@ICERIK", FCKeditor1.Value);

        com.Parameters.AddWithValue("@EKLENME_TARIH",DateTime.Now.ToString());

        com.ExecuteNonQuery();

        com.Dispose();

        con.Close();

        Response.Redirect("Default.aspx");