Merhabalar dropdownlistten gelen id numarasını veri tabanıma kayıt etmek istiyorum ama bi türlü yapamadım anlayan varmı acaba ?
web formdaki kodlar;<-----------------------------------------
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Altkatagoriekleme.aspx.cs" Inherits="İnternet_Sitemiz.Altkatagoriekleme" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<meta name="viewport" content="width=device-width, initial-scale=1" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<link href="Bootstraptemelkodları/css/bootstrap.css" rel="stylesheet" />
<script src="Bootstraptemelkodları/js/bootstrap.bundle.min.js"></script>
<script src="Bootstraptemelkodları/jquery/jquery-3.3.1.min.js"></script>
<script src="Bootstraptemelkodları/jquery/popper.min.js"></script>
<style>
body {
margin: 0;
padding: 0;
background-color: #189fb9;
height: 100vh;
}
#login .container #login-row #login-column #login-box {
}
#login .container #login-row #login-column #login-box #login-form {
padding: 20px;
}
#login .container #login-row #login-column #login-box #login-form #register-link {
margin-top: -85px;
}
</style>
<title>Ürün Ekle</title>
</head>
<body>
<form id="form1" runat="server">
<div id="login">
<h3 class="text-center text-white pt-5">Alt Katagori Ekle </h3>
<asp:Button ID="Üründüzenlemeyegeridön1" runat="server" Text="Geridön <-" class="btn btn-info btn-md" OnClick="Üründüzenlemeyegeridön_Click" />
<div class="container">
<div id="login-row" class="row justify-content-center align-items-center">
<div id="login-column" class="col-md-6">
<div id="login-box" class="col-md-12">
</div>
<div class="form-group">
</div>
<div class="form-group">
<label for="username" class="text-info">Resim Ekleyiniz</label><br>
<asp:FileUpload ID="altkatagoriresmi" runat="server" />
</div>
</div>
<div class="form-group">
<label for="username" class="text-info">Ürün Katagorisi Seçiniz</label><br>
<asp:DropDownList ID="altkatagoridropdown" runat="server" DataSourceID="SqlDataSource1" DataTextField="Katogoriadı" DataValueField="Katogoriadı" AutoPostBack="True" OnSelectedIndexChanged="altkatagoridropdown_SelectedIndexChanged"></asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:BirgrafikConnectionString %>" SelectCommand="SELECT * FROM [Katogoriler]"></asp:SqlDataSource>
</div>
<div>
<label for="username" class="text-info"></label><br>
<asp:Button ID="Katagoriseç" runat="server" Text="Onayla" OnClick="Katagoriseç_Click" />
</div>
<div>
<label for="username" class="text-info"></label><br>
<asp:Label ID="katogorionay" runat="server" Text=""></asp:Label>
</div>
<div>
<label for="username" class="text-info"></label><br>
<asp:ListBox ID="Katogorseçimonay" runat="server"></asp:ListBox>
</div>
<div class="form-group">
<label for="username" class="text-info">Ürününün Adını Giriniz</label><br>
<asp:TextBox ID="altkatagori" runat="server" class="form-control"></asp:TextBox>
<div class="form-group">
<asp:Button ID="altkatagorikayıtbutonu" runat="server" Text="Kaydet" class="btn btn-info btn-md" OnClick="altkatagorikayıtbutonu_Click" />
</div>
<div id="register-link" class="text-right">
<asp:Label ID="labelbasarılı" runat="server" Text=""></asp:Label>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</form>
</body>
</html>
.aspx.cs deki kodlar şu şekilde; <---------------------------------
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
namespace İnternet_Sitemiz
{
public partial class Altkatagoriekleme : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Üründüzenlemeyegeridön_Click(object sender, EventArgs e)
{
Response.Redirect("Üründüzenleme.aspx");
}
protected void altkatagorikayıtbutonu_Click(object sender, EventArgs e)
{
SqlConnection bag = new SqlConnection(@"data source=DESKTOP-OMECOEP;initial catalog=Birgrafik;integrated security=True;MultipleActiveResultSets=True");
bag.Open();
SqlCommand komut = new SqlCommand("Insert into TemelÜrünKatagorisi (Altkatogoriadı) values (@Altkat,)", bag);
komut.Parameters.AddWithValue("@Altkat", altkatagori.Text);
SqlCommand komut2 = new SqlCommand("insert into TemelÜrünKatagorisi(KagoriID) values (@drop)", bag);
komut2.Parameters.AddWithValue("@drop", altkatagoridropdown.SelectedItem.Text);
SqlDataReader oku = komut.ExecuteReader();
SqlDataReader oku2 = komut2.ExecuteReader();
if (oku.Read() && oku2.Read())
{
labelbasarılı.Text = " Kayıt Yapılamadı";
}
else
{
labelbasarılı.Text = " Kayıt Başarılı";
}
}
protected void altkatagoridropdown_SelectedIndexChanged(object sender, EventArgs e)
{
}
protected void Katagoriseç_Click(object sender, EventArgs e)
{
}
}
}
