protected void btn_Submit_Click(object sender, ImageClickEventArgs e)
{
db = new DatabaseMethods();
int a = db.InsertWithLastId("Insert into Makale (Baslik , Tarih , Icerik , KategoriID , Ozet) values ( '" + txt_Title.Text + "' , GETDATE() , '" + txt_main.Text + "' , " + ddl_Category.SelectedItem.Value + " , '" + txt_abstract.Text + "'); SELECT SCOPE_IDENTITY() as LastInsertedId;");
foreach (ListItem item in lb_Selected.Items)
{
db.Insert("Insert into MakaleEtiket values(" + a + "," + item.Value + ")");
}
//Response.Redirect("Admin.aspx");
db.CloseConnection();
}