How to Connect Oracle Databse with VB.Net
The text of this article is not in this database — only its details are. The old site it was published on is gone, but the Internet Archive kept a copy: How to Connect Oracle Databse with VB.Net
2 Comments
Join the conversation! Your thoughts help the community grow.
Sign in to leave a comment
It is the same account you read, post and publish with — and you will come straight back to this page.
crismic paulPosted May 1, 2012, 7:40 AM
i am making a project on asp.net with visual basic 2010 n oracle 11g database ....i just wanted to know how to connect/ insert data in vb textbox so that it gets saved in oracle table.... my codings are VISUAL BASIC 2010 : "......... <%@ Page Language="VB" AutoEventWireup="false" CodeFile="customer identification.aspx.vb" Inherits="customer_identification" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> <style type="text/css"> .style1 { width: 1189px; font-family: Broadway; color: #FFFFFF; font-size: xx-large; text-align: center; } .style2 { height: 261px; width: 1187px; } .style5 { width: 1189px; color: #FFFFFF; height: 28px; margin-top: 15px; text-align: center; } .style11 { color: #FFFFFF; } .style13 { text-align: left; font-family: "Britannic Bold"; font-size: xx-large; color: #FF3300; text-decoration: underline; width: 1186px; } .style14 { text-align: center; } .style15 { font-size: 40pt; } .style16 { width: 1185px; } .style17 { width: 1186px; } .style18 { width: 1187px; } .style19 { width: 1188px; } .style20 { color: #FFFFFF; width: 1185px; } .style21 { width: 1186px; color: #FFFFFF; } </style> </head> <body background="images/vista_wallpapers%20(27).jpg"> <form id="form1" runat="server"> <div class="style1"> <div> <asp:Image ID="Image1" runat="server" Height="186px" ImageUrl="~/images/Presentation1.jpg" Width="1191px" /> </div> <br /> <div style="background-image: url('images/wallpaper_1019.jpg')"> <span class="style15">CUSTOMER IDENTIFICATION</span></div> </div> <div class="style2" style="background-image: url('images/MEGA1.jpg')"> </div> <a href="javascript:__doPostBack('LinkButton1','')"> </a> <div> <div class="style5" style="background-image: url('images/vista_wallpapers (27).jpg')"> <a href="javascript:__doPostBack('LinkButton1','')"><asp:LinkButton ID="LinkButton10" runat="server" CssClass="style11" PostBackUrl="~/Default.aspx">HOME</asp:LinkButton> </a> | <asp:LinkButton ID="LinkButton1" runat="server" BorderStyle="None" CssClass="style11" PostBackUrl="~/customer identification.aspx">CUSTOMER IDENTIFICATION</asp:LinkButton> | <asp:LinkButton ID="LinkButton2" runat="server" CssClass="style11" PostBackUrl="~/downloading.aspx">DOWNLOADING</asp:LinkButton> | <asp:LinkButton ID="LinkButton3" runat="server" CssClass="style11" PostBackUrl="~/Printing.aspx"> PRINTING</asp:LinkButton> | <asp:LinkButton ID="LinkButton4" runat="server" CssClass="style11" PostBackUrl="~/Photocopy.aspx">PHOTOCOPY</asp:LinkButton> | <asp:LinkButton ID="LinkButton5" runat="server" CssClass="style11" PostBackUrl="~/Lamination.aspx">LAMINATION</asp:LinkButton> | <asp:LinkButton ID="LinkButton6" runat="server" CssClass="style11" PostBackUrl="~/spiralbinding.aspx">SPIRAL BINDING</asp:LinkButton> | <asp:LinkButton ID="LinkButton7" runat="server" CssClass="style11" PostBackUrl="~/buyingitems.aspx">BUYING ITEMS</asp:LinkButton> | <asp:LinkButton ID="LinkButton8" runat="server" CssClass="style11" PostBackUrl="~/photoprint.aspx">PHOTO PRINT</asp:LinkButton> | <asp:LinkButton ID="LinkButton9" runat="server" CssClass="style11" PostBackUrl="~/fax.aspx">FAX</asp:LinkButton> </div> </div> <p class="style16"> <span class="style11">Cr. SL.NO : </span> <asp:TextBox ID="TextBox1" runat="server" Width="93px"></asp:TextBox> <span class="style11"> CABIN NO : </span> <asp:DropDownList ID="DropDownList1" runat="server"> </asp:DropDownList> <span class="style11"> PURPOSE OF WORK : </span> <asp:DropDownList ID="DropDownList5" runat="server"> </asp:DropDownList> </p> <p class="style17"> <span class="style11">NAME : </span> <asp:TextBox ID="TextBox7" runat="server" Width="934px"></asp:TextBox> </p> <p class="style17"> <span class="style11">ADDRESS : </span> <asp:TextBox ID="TextBox4" runat="server" Width="937px"></asp:TextBox> </p> <p class="style21"> LOG IN TIME : <asp:TextBox ID="TextBox9" runat="server" Width="201px"></asp:TextBox> LOG OUT TIME : <asp:TextBox ID="TextBox10" runat="server" Width="192px"></asp:TextBox> DATE : <asp:TextBox ID="TextBox11" runat="server" Width="207px"></asp:TextBox> </p> <p class="style18"> <span class="style11">CUSTOMER IDENTIFICATION CARD : </span> <asp:DropDownList ID="DropDownList3" runat="server"> </asp:DropDownList> <span class="style11"> CARD NUMBER : </span> <asp:TextBox ID="TextBox5" runat="server" Width="442px"></asp:TextBox> <span class="style11"> </span> </p> <p class="style19"> <span class="style11">MOBILE NUMBER : </span> <asp:DropDownList ID="DropDownList4" runat="server"> </asp:DropDownList> <span class="style11"> </span> <asp:TextBox ID="TextBox6" runat="server" Width="200px"></asp:TextBox> <span class="style11"> COUNTRY : <asp:TextBox ID="TextBox8" runat="server" Width="439px"></asp:TextBox> </span> </p> <p class="style14"> <span class="style11">I agree to the rules written below </span> <asp:RadioButton ID="Agree" runat="server" CssClass="style11" /> <span class="style11"> I disagree to the rules written below </span> <asp:RadioButton ID="Disagree" runat="server" CssClass="style11" /> </p> <p class="style14"> <asp:Button ID="Button1" runat="server" Text="Insert" /> <asp:Button ID="Button2" runat="server" Text="Delete" /> </p> <p class="style14"> </p> </form> <div class="style13" style="background-image: url('images/wallpaper_1019.jpg')"> <em>RULES :</em></div> <p class="style20"> WRITE ABOUT RULES BRING FROM CYBER</p> </body> </html> ..............." ORACLE TABLE "........... CREATE TABLE "HR"."CUSTOMERID" ( "CSL.NO" NUMBER NOT NULL ENABLE, "CABIN NO" NUMBER NOT NULL ENABLE, "PURPOSE" VARCHAR2(50 BYTE) NOT NULL ENABLE, "NAME" VARCHAR2(50 BYTE) NOT NULL ENABLE, "ADDRESS" VARCHAR2(200 BYTE) NOT NULL ENABLE, "DATE" DATE DEFAULT NULL NOT NULL ENABLE, "CUSTOMER ID CARD" VARCHAR2(100 BYTE) NOT NULL ENABLE, "CARD NO" VARCHAR2(100 BYTE) NOT NULL ENABLE, "MOBILE NO" NUMBER, "COUNTRY" VARCHAR2(30 BYTE) NOT NULL ENABLE, "LOGIN TIME" TIMESTAMP (6) NOT NULL ENABLE, "LOGOUT ITME" TIMESTAMP (6) NOT NULL ENABLE, CONSTRAINT "CUSTOMERID_PK" PRIMARY KEY ("CSL.NO") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ENABLE ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "USERS" ; COMMENT ON COLUMN "HR"."CUSTOMERID"."DATE" IS 'TO_DATE(''15-NOV-05 10:56 A.M.'',''DD-MON-YY HH:MI A.M.'')'; ........." I have connected the table with visual basic but dont know how to insert ... i mean where to write the codings or what to write so that it will be saved... thanx
sovan naraPosted Jan 4, 2011, 10:24 AM
i'm not sure about how to connect from VB to Oracle? Is it like connect to Database?