Duyuruyu Kapat
Facebook Gözat
Twitter Gözat

ASP .NET'de bir form yaptım ama veri tabanına kayıt yaptıramadım

Konu, 'ASP.NET / Silverlight / Moonlight' kısmında myth_hero tarafından paylaşıldı.

  1. myth_hero

    myth_hero Üye

    Kayıt:
    6 Ocak 2008
    Mesajlar:
    32
    Beğenilen Mesajlar:
    0
    S.a

    ASP .NET de bir formum var kullandığım program microsoft web devoloper kodlar aşağıda eksik hata falan var mı ve nasıl kayıt yapabilirim
    şimdiden teşekkürler
     
  2. myth_hero

    myth_hero Üye

    Kayıt:
    6 Ocak 2008
    Mesajlar:
    32
    Beğenilen Mesajlar:
    0
    kodlar burada

    PHP:
    <%@PageLanguage="VB"MasterPageFile="~/MasterPage3.master"AutoEventWireup="True"CodeFile="basvur.aspx.vb"Inherits="basvur2" %>
    <%@
    RegisterAssembly="AjaxControlToolkit"Namespace="AjaxControlToolkit"TagPrefix="cc1" %>
    <%@
    Registerassembly="FlashControl"namespace="Bewise.Web.UI.WebControls"tagprefix="Bewise" %>
    <
    asp:ContentID="Content2"runat="server"contentplaceholderid="ContentPlaceHolder1">
     
     
    <
    asp:SqlDataSourceID="SqlDataSource1"runat="server"
    ConnectionString="<%$ ConnectionStrings:TekMConnectionString %>"
    SelectCommand="SELECT * FROM [basvuru]"
    InsertCommand="insert into basvuru(ad,soyad,cinsiyet,dogumtarih,medenidurum,telev,telis,gsm,email,sehir,adres,askerlik,egitim,sonmezunokul,mezunyil,dil1,derece1,dil2,derece2,dil3,derece3,bildigibilsistemdil,kullandigipaketpro,isdeneyimfirma1,isdeneyimgorev1,isdeneyimgiris1,isdeneyimcikis1,isdeneyimfirma2,isdeneyimgorev2,isdeneyimgiris2,isdeneyimcikis2,isdeneyimfirma3,isdeneyimgorev3,isdeneyimgiris3,isdeneyimcikis3,istedigipozisyon,kendinitanit)values ('@ad','@soyad','@cinsiyet','@dogumtarih','@medenidurum','@telev','@telis','@gsm','@email','@sehir','@adres','@askerlik','@egitim','@sonmezunokul','@mezunyil','@dil1','@derece1','@dil2','@derece2','@dil3','@derece3','@bildigibilsistemdil','@kullandigipaketpro','@isdeneyimfirma1','@isdeneyimgorev1','@isdeneyimgiris1','@isdeneyimcikis1','@isdeneyimfirma2','@isdeneyimgorev2','@isdeneyimgiris3','@isdeneyimcikis2','@isdeneyimfirma3','@isdeneyimgorev3','@isdeneyimgiris3','@isdeneyimcikis3','@istedigipozisyon','@kendinitanit')">
    <
    InsertParameters>
    <
    asp:ParameterName="ad"Type="String"/>
    <
    asp:ParameterName="soyad"Type="String"/>
    <
    asp:ParameterName="cinsiyet"Type="String"/>
    <
    asp:ParameterName="dogumtarih"Type="String"/>
    <
    asp:ParameterName="medenidurum"Type="String"/>
    <
    asp:Parametername="telev"Type="Int16"/>
    <
    asp:ParameterName="telis"Type="Int16"/>
    <
    asp:ParameterName="gsm"Type="Int16"/>
    <
    asp:ParameterName="email"Type="String"/>
    <
    asp:ParameterName="sehir"Type="String"/>
    <
    asp:ParameterName="adres"Type="String"/>
    <
    asp:ParameterName="askerlik"Type="String"/>
    <
    asp:ParameterName="egitim"Type="String"/>
    <
    asp:ParameterName="sonmezunokul"Type="String"/>
    <
    asp:ParameterName="mezunyil"Type="String"/>
    <
    asp:Parametername="dil1"Type="String"/>
    <
    asp:ParameterName="derece1"Type="String"/>
    <
    asp:ParameterName="dil2"Type="String"/>
    <
    asp:ParameterName="derece2"Type="String"/>
    <
    asp:ParameterName="dil3"Type="String"/>
    <
    asp:ParameterName="derece3"Type="String"/>
    <
    asp:ParameterName="bildigibilsistemdil"Type="String"/>
    <
    asp:ParameterName="kullandigipaketpro"Type="String"/>
    <
    asp:Parametername="isdeneyimfirma1"Type="String"/>
    <
    asp:ParameterName="isdeneyimgorev1"Type="String"/>
    <
    asp:ParameterName="isdeneyimgiris1"Type="String"/>
    <
    asp:ParameterName="isdeneyimcikis1"Type="String"/>
    <
    asp:Parametername="isdeneyimfirma2"Type="String"/>
    <
    asp:ParameterName="isdeneyimgorev2"Type="String"/>
    <
    asp:ParameterName="isdeneyimgiris2"Type="String"/>
    <
    asp:ParameterName="isdeneyimcikis2"Type="String"/>
    <
    asp:Parametername="isdeneyimfirma3"Type="String"/>
    <
    asp:ParameterName="isdeneyimgorev3"Type="String"/>
    <
    asp:ParameterName="isdeneyimgiris3"Type="String"/>
    <
    asp:ParameterName="isdeneyimcikis3"Type="String"/>
    <
    asp:ParameterName="istedigipozisyon"Type="String"/>
    <
    asp:ParameterName="kendinitanit"Type="String"/>
    </
    InsertParameters>
    </
    asp:SqlDataSource>
     
  3. myth_hero

    myth_hero Üye

    Kayıt:
    6 Ocak 2008
    Mesajlar:
    32
    Beğenilen Mesajlar:
    0
    PHP:
    <asp:FormViewID="FormView1"runat="server"Width="100%"DataSourceID="SqlDataSource1"
    DefaultMode="Insert">
    <
    InsertItemTemplate>
    <
    tablestyle="width:100%;">
    <
    tr>
    <
    tdwidth="20%">
    &
    nbsp;</td>
    <
    tdcolspan="6"style="background-image: url('resim/alt2.gif')">
    1-) KiŸisel Bilgileriniz</td>
    <
    tdwidth="20%">
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdclass="style5">
    Adnz
    </td>
    <
    tdclass="style10">
    :</
    td>
    <
    tdcolspan="4">
    <
    asp:TextBoxID="TextBox2"runat="server"Text='<%# Bind("ad") %>'></asp:TextBox>
    </
    td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdclass="style5">
    Soyadnz</td>
    <
    tdclass="style10">
    :</
    td>
    <
    tdcolspan="4">
    <
    asp:TextBoxID="TextBox3"runat="server"Text='<%# Bind("soyad") %>'></asp:TextBox>
    </
    td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdclass="style5">
    Cinsiyetiniz</td>
    <
    tdclass="style10">
    :</
    td>
    <
    tdcolspan="4"class="style8">
    <
    asp:RadioButtonListID="RadioButtonList1"runat="server"Height="16px"Width="63px"
    SelectedValue='<%# Bind("cinsiyet") %>'>
    <
    asp:ListItemValue="Bay"></asp:ListItem>
    <
    asp:ListItemValue="Bayan"></asp:ListItem>
    </
    asp:RadioButtonList>
    </
    td>
    <
    td>
    </
    td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdclass="style5">
    Do§um Tarihi</td>
    <
    tdclass="style10">
    :</
    td>
    <
    tdcolspan="4">
    <
    asp:TextBoxID="TextBox34"runat="server"Text='<%# Bind("dogumtarih") %>'></asp:TextBox>
    </
    td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdclass="style5">
    Medeni Haliniz
    </td>
    <
    tdclass="style10">
    :</
    td>
    <
    tdcolspan="4">
    <
    asp:RadioButtonListID="RadioButtonList2"runat="server"Width="16px"
    SelectedValue='<%# Bind("medenidurum") %>'>
    <
    asp:ListItemValue="Bekar"></asp:ListItem>
    <
    asp:ListItemValue="Evli"></asp:ListItem>
    <
    asp:ListItemValue="Dul"></asp:ListItem>
    </
    asp:RadioButtonList>
    </
    td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdclass="style5">
    Telefon Ev
    </td>
    <
    tdclass="style10">
    :</
    td>
    <
    tdcolspan="4">
    <
    asp:TextBoxID="TextBox5"runat="server"Text='<%# Bind("telev") %>'></asp:TextBox>
    </
    td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdclass="style5">
    Telefon ˜Ÿ
    </td>
    <
    tdclass="style10">
    :</
    td>
    <
    tdcolspan="4">
    <
    asp:TextBoxID="TextBox6"runat="server"Text='<%# Bind("telis") %>'></asp:TextBox>
    </
    td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdclass="style5">
    GSM</td>
    <
    tdclass="style10">
    :</
    td>
    <
    tdcolspan="4">
    <
    asp:TextBoxID="TextBox7"runat="server"Text='<%# Bind("gsm") %>'></asp:TextBox>
    </
    td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdclass="style5">
    E-Posta</td>
    <
    tdclass="style10">
    :</
    td>
    <
    tdcolspan="4">
    <
    asp:TextBoxID="TextBox8"runat="server"Width="190px"Text='<%# Bind("email") %>'></asp:TextBox>
    </
    td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdclass="style5">
    YaŸad§nz il
    </td>
    <
    tdclass="style10">
    :</
    td>
    <
    tdcolspan="4">
    &
    nbsp;</td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdclass="style5">
    Adres</td>
    <
    tdclass="style10">
    :</
    td>
    <
    tdcolspan="4">
    <
    asp:TextBoxID="TextBox9"runat="server"Height="86px"TextMode="MultiLine"Width="221px"
    Text='<%# Bind("adres") %>'></asp:TextBox>
    </
    td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdclass="style5">
    Askerlik Durumunuz</td>
    <
    td>
    :</
    td>
    <
    tdcolspan="4">
    <
    asp:RadioButtonListID="RadioButtonList3"runat="server"SelectedValue='<%# Bind("askerlik") %>'>
    <
    asp:ListItemValue="Yapld"></asp:ListItem>
    <
    asp:ListItemValue="Muaf"></asp:ListItem>
    <
    asp:ListItemValue="Tecilli"></asp:ListItem>
    </
    asp:RadioButtonList>
    </
    td>
    <
    td>
    </
    td>
    </
    tr>
    <
    tr>
    <
    tdclass="style6">
    </
    td>
    <
    tdclass="style11">
    E§itim Dereceniz
    </td>
    <
    tdclass="style6">
    :</
    td>
    <
    tdclass="style12"colspan="4">
    <
    asp:DropDownListID="DropDownList4"runat="server"SelectedValue='<%# Bind("egitim") %>'>
    <
    asp:ListItemValue="˜lk”§retim"></asp:ListItem>
    <
    asp:ListItemValue="Lisans"></asp:ListItem>
    <
    asp:ListItemValue="Yksek Lisans"></asp:ListItem>
    </
    asp:DropDownList>
    </
    td>
    <
    tdclass="style6">
    </
    td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdclass="style5">
    Son Mezun Oldu§unuz Okul</td>
    <
    tdclass="style10">
    :</
    td>
    <
    tdcolspan="4">
    <
    asp:TextBoxID="TextBox10"runat="server"Width="202px"Text='<%# Bind("sonmezunokul") %>'></asp:TextBox>
    </
    td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdclass="style5">
    Mezuniyet Yl
    </td>
    <
    tdclass="style10">
    :</
    td>
    <
    tdcolspan="4">
    <
    asp:TextBoxID="TextBox11"runat="server"Width="96px"Text='<%# Bind("mezunyil") %>'></asp:TextBox>
    </
    td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    </
    td>
    <
    tdcolspan="6"style="background-image: url('resim/alt2.gif')">
    2-) Bildi§iniz Diller
    </td>
    <
    td>
    </
    td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdclass="style5">
    Yabanci Dil 1</td>
    <
    tdclass="style10">
    :</
    td>
    <
    tdcolspan="2"class="style13">
    <
    asp:TextBoxID="TextBox12"runat="server"Width="128px"Text='<%# Bind("dil1") %>'></asp:TextBox>
    </
    td>
    <
    tdcolspan="2">
    <
    asp:DropDownListID="DropDownList5"runat="server"SelectedValue='<%# Bind("derece1") %>'>
    <
    asp:ListItemValue="AZ"></asp:ListItem>
    <
    asp:ListItemValue="ORTA"></asp:ListItem>
    <
    asp:ListItemValue="˜Y˜"></asp:ListItem>
    <
    asp:ListItemValue="€OK ˜Y˜"></asp:ListItem>
    </
    asp:DropDownList>
    </
    td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdclass="style5">
    Yabanci Dil 2</td>
    <
    tdclass="style10">
    :</
    td>
    <
    tdcolspan="2"class="style13">
    <
    asp:TextBoxID="TextBox13"runat="server"Text='<%# Bind("dil2") %>'></asp:TextBox>
    </
    td>
    <
    tdcolspan="2">
    <
    asp:DropDownListID="DropDownList6"runat="server"SelectedValue='<%# Bind("derece2") %>'>
    <
    asp:ListItemValue="AZ"></asp:ListItem>
    <
    asp:ListItemValue="ORTA"></asp:ListItem>
    <
    asp:ListItemValue="˜Y˜"></asp:ListItem>
    <
    asp:ListItemValue="€OK ˜Y˜"></asp:ListItem>
    </
    asp:DropDownList>
    </
    td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdclass="style5">
    Yabanci Dil 3</td>
    <
    tdclass="style10">
    :</
    td>
    <
    tdcolspan="2"class="style13">
    <
    asp:TextBoxID="TextBox14"runat="server"Text='<%# Bind("dil3") %>'></asp:TextBox>
    </
    td>
    <
    tdcolspan="2">
    <
    asp:DropDownListID="DropDownList7"runat="server"SelectedValue='<%# Bind("derece3") %>'>
    <
    asp:ListItemValue="AZ"></asp:ListItem>
    <
    asp:ListItemValue="ORTA"></asp:ListItem>
    <
    asp:ListItemValue="˜Y˜"></asp:ListItem>
    <
    asp:ListItemValue="€OK ˜Y˜"></asp:ListItem>
    </
    asp:DropDownList>
    </
    td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdcolspan="6"style="background-image: url('resim/alt2.gif')">
    3-) Bilgisayar Bilginiz
    </td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdclass="style5">
    Bildi§iniz Bilgisayar Sistemleri ve Dilleri</td>
    <
    tdclass="style10">
    :</
    td>
    <
    tdcolspan="4">
    <
    asp:TextBoxID="TextBox15"runat="server"Height="55px"TextMode="MultiLine"Width="221px"
    Text='<%# Bind("bildigibilsistemdil") %>'></asp:TextBox>
    </
    td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdclass="style5">
    Kulland§nz Bilgisayar Paket Programlar</td>
    <
    tdclass="style10">
    :</
    td>
    <
    tdcolspan="4">
    <
    asp:TextBoxID="TextBox16"runat="server"Height="55px"TextMode="MultiLine"Width="221px"
    Text='<%# Bind("kullandigipaketpro") %>'></asp:TextBox>
    </
    td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdcolspan="6"style="background-image: url('resim/alt2.gif')">
    4-) ˜Ÿ Deneyimleriniz
    </td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdclass="style17">
    F˜rma Ad</td>
    <
    tdclass="style16">
    &
    nbsp;</td>
    <
    tdclass="style15">
    G”reviniz</td>
    <
    tdcolspan="2"class="style15">
    GiriŸ Tarihi</td>
    <
    tdclass="style14">
    €kŸ Tarihi</td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    tdclass="style7">
    </
    td>
    <
    tdclass="style9"colspan="2">
    <
    asp:TextBoxID="TextBox17"runat="server"Text='<%# Bind("isdeneyimfirma1") %>'></asp:TextBox>
    </
    td>
    <
    tdclass="style8">
    <
    asp:TextBoxID="TextBox18"runat="server"Text='<%# Bind("isdeneyimgorev1") %>'></asp:TextBox>
    </
    td>
    <
    tdclass="style7"colspan="2">
    <
    asp:TextBoxID="TextBox19"runat="server"Text='<%# Bind("isdeneyimgiris1") %>'></asp:TextBox>
    </
    td>
    <
    tdclass="style7">
    <
    asp:TextBoxID="TextBox20"runat="server"Text='<%# Bind("isdeneyimcikis1") %>'></asp:TextBox>
    </
    td>
    <
    tdclass="style7">
    </
    td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdclass="style9"colspan="2">
    <
    asp:TextBoxID="TextBox21"runat="server"Text='<%# Bind("isdeneyimfirma2") %>'></asp:TextBox>
    </
    td>
    <
    tdclass="style8">
    <
    asp:TextBoxID="TextBox22"runat="server"Text='<%# Bind("isdeneyimgorev2") %>'></asp:TextBox>
    </
    td>
    <
    tdcolspan="2">
    <
    asp:TextBoxID="TextBox23"runat="server"Text='<%# Bind("isdeneyimgiris2") %>'></asp:TextBox>
    </
    td>
    <
    td>
    <
    asp:TextBoxID="TextBox24"runat="server"Text='<%# Bind("isdeneyimcikis2") %>'></asp:TextBox>
    </
    td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdclass="style9"colspan="2">
    <
    asp:TextBoxID="TextBox25"runat="server"Text='<%# Bind("isdeneyimfirma3") %>'></asp:TextBox>
    </
    td>
    <
    tdclass="style8">
    <
    asp:TextBoxID="TextBox26"runat="server"Text='<%# Bind("isdeneyimgorev3") %>'></asp:TextBox>
    </
    td>
    <
    tdcolspan="2">
    <
    asp:TextBoxID="TextBox27"runat="server"Text='<%# Bind("isdeneyimgiris3") %>'></asp:TextBox>
    </
    td>
    <
    td>
    <
    asp:TextBoxID="TextBox28"runat="server"Text='<%# Bind("isdeneyimcikis3") %>'></asp:TextBox>
    </
    td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdcolspan="6"style="background-image: url('resim/alt2.gif')">
    5-)Ek B˜lgileriniz</td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdclass="style5">
    €alŸmak ˜stedi§iniz Pozisyon</td>
    <
    tdclass="style10">
    :</
    td>
    <
    tdcolspan="4">
    <
    asp:DropDownListID="DropDownList8"runat="server"SelectedValue='<%# Bind("istedigipozisyon") %>'>
    <
    asp:ListItem></asp:ListItem>
    <
    asp:ListItemValue="Teknik Servis"></asp:ListItem>
    <
    asp:ListItemValue="Muhasebe"></asp:ListItem>
    <
    asp:ListItemValue="SatŸ Eleman"></asp:ListItem>
    <
    asp:ListItemValue="MŸteri Hizmetleri"></asp:ListItem>
    </
    asp:DropDownList>
    </
    td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdclass="style5">
    Kendinizi ksaca tantn</td>
    <
    tdclass="style10">
    :</
    td>
    <
    tdcolspan="4">
    <
    asp:TextBoxID="TextBox33"runat="server"Height="175px"TextMode="MultiLine"Width="350px"
    Text='<%# Bind("kendinitanit") %>'></asp:TextBox>
    </
    td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    <
    tr>
    <
    td>
    &
    nbsp;</td>
    <
    tdcolspan="6"style="text-align: center">
    <
    asp:LinkButtonID="InsertButton"runat="server"ForeColor="#FF9933">BaŸvur</asp:LinkButton>
    </
    td>
    <
    td>
    &
    nbsp;</td>
    </
    tr>
    </
    table>
    </
    InsertItemTemplate>
    </
    asp:FormView>
     
    </
    asp:Content>
    <
    asp:ContentID="Content3"runat="server"contentplaceholderid="head">
     
    </
    asp:Content>