LinkTr Forumları (Arşiv Ana sayfa) => ASP - ASP.NET

Konu: ASP.Net ile Veritabanına Kayıt Eklemek

Sayfa: [ 1 ]

CaN_PoLaT 10.02.2009 00:02:05
Kod:
    <%@ Page Language=”VB” Debug=”true” %>
    <%@ import Namespace=”System.Data.OleDb” %>
    <script runat=”server”>

        Sub ekle(sender As Object, e As EventArgs)
        dim db_baglanti as OleDbConnection
        dim ad1 as string
        dim soyad1 as string

       
       
        ad1=ad.text
        soyad1=soyad.text
       
       
       
        db_baglanti = New OleDbConnection(”Provider=Microsoft.Jet.OLEDB.4.0; DATA Source=” & Server.MapPath(”ProjeTL-4Akayit.mdb”))
        db_baglanti.Open()
       
        dim db_komut as OleDbCommand
          db_komut= New OleDbCommand( “Insert INTO deneme ( numara, gorus) Values( ‘”& ad1 &”‘,’”& soyad1 &”‘)”, db_baglanti )
            db_komut.ExecuteNonQuery
        msgbox(”Görüşleriniz Eklendi.”)
        ad1=”"
        soyad1=”"
        db_baglanti.Close()
       
        end sub
       
     

    </script>
    <html>
    <head>
    <script language=”JavaScript” type=”text/JavaScript”>
    <!–
    function MM_reloadPage(init) {   //reloads the window if Nav4 resized
      if (init==true) with (navigator) {if ((appName==”Netscape”)&&(parseInt(appVersion)==4)) {
        document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
      else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
    }
    MM_reloadPage(true);
    //–>
    </script>
    <style type=”text/css”>
    <!–
    .style1 {
    font-family: Verdana;
    font-size: 14pt;
    }
    –>
    </style>
    </head>
    <body>
    <div id=”Layer1″ style=”position:absolute; left:121px; top:15px; width:801px; height:31px; z-index:1″>
      <table width=”804″ border=”1″>
        <tr>
          <td><span class=”style1″>1001 Fikret Öztürk </span></td>
        </tr>
      </table>
    </div>
    <div id=”Layer2″ style=”position:absolute; left:122px; top:57px; width:802px; height:362px; z-index:2″>
      <table width=”800″ height=”361″ border=”1″ id=”table1″>
        <tr>
          <td> </td>
        </tr>
      </table>
    </div>
    <p><img src=”1001.jpg” width=”96″ height=”112″ border=”2″></p>
    <p> </p>
    <p> </p>
    <p> </p>
    <p> </p>
    <p> </p>
    <p> </p>
    <p> </p>
    <p> </p>
    <form runat=”server”>
      Numaranız: 
      <asp:TextBox id=”ad” runat=”server”></asp:TextBox>
      <br />
      <br />
      Gorusunuz: 
      <asp:TextBox id=”soyad” runat=”server” TextMode=”MultiLine” Height=”25″></asp:TextBox>
      <br />
      <asp:Button id=”Button1″ onclick=”ekle” runat=”server” Text=”Bilgileri Ekle”></asp:Button>
      <br />
    </form>
    <p> </p>
    <p> </p>
    <p> </p>
    <p> </p>
    <p> </p>
    </body>
    </html>

Mustafa coşkun.


Sayfa: [ 1 ]