Aplikasi android hotel sederhana pada Eclips

Main Activity.java

import android.media.ExifInterface;

import android.os.Bundle;

import android.app.Activity;

import android.view.Menu;

import android.view.View;

import android.widget.Button;

import android.widget.EditText;

import android.content.Intent;

import android.widget.Toast;

public class NamamobilActivity extends Activity {

Button Kamar1;

Button Kamar2;

Button Kamar3;

Button Kamar4;

Button Kamar5;

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.namamobil);

Kamar1 = (Button) findViewById(R.id.button1);

Kamar2 = (Button) findViewById(R.id.button2);

Kamar3= (Button) findViewById(R.id.button3);

Kamar4= (Button ) findViewById (R.id.button4);

Kamar5= (Button ) findViewById (R.id.button5);

        Kamar1.setOnClickListener(new View.OnClickListener()

        {

        public void onClick(View v) {

        // TODO Auto-generated method stub

        Intent i = new Intent(NamamobilActivity.this,AvanzaActivity.class);

        Toast.makeText(getApplicationContext(),"Berhasil Masuk",Toast.LENGTH_SHORT).show();

        

        startActivity(i);

        }

        });

        Kamar3.setOnClickListener(new View.OnClickListener()

        {

        public void onClick(View v) {

        // TODO Auto-generated method stub

        Intent i = new Intent(NamamobilActivity.this, XeniaActivity.class);

        Toast.makeText(getApplicationContext(),"Berhasil Masuk",Toast.LENGTH_SHORT).show();

        

        startActivity(i);

        }

        });

        Kamar2.setOnClickListener(new View.OnClickListener()

        {

        public void onClick(View v) {

        // TODO Auto-generated method stub

        Intent i = new Intent(NamamobilActivity.this, ApvActivity.class);

        Toast.makeText(getApplicationContext(),"Berhasil Masuk",Toast.LENGTH_SHORT).show();

        

        startActivity(i);

        }

        });

        Kamar4.setOnClickListener(new View.OnClickListener()

        {

        public void onClick(View v) {

        // TODO Auto-generated method stub

        Intent i = new Intent(NamamobilActivity.this,WisatActivity.class);

        Toast.makeText(getApplicationContext(),"Berhasil Masuk",Toast.LENGTH_SHORT).show();

        

        startActivity(i);

        }

        });

        Kamar5.setOnClickListener(new View.OnClickListener()

        {

        public void onClick(View v) {

        // TODO Auto-generated method stub

        Intent i = new Intent(NamamobilActivity.this,Kamar5.class);

        Toast.makeText(getApplicationContext(),"Berhasil Masuk",Toast.LENGTH_SHORT).show();

        

        startActivity(i);

        }

        });

}

@Override

public boolean onCreateOptionsMenu(Menu menu) {

// Inflate the menu; this adds items to the action bar if it is present.

getMenuInflater().inflate(R.menu.namamobil, menu);

return true;

}

}

Main Activity.XML

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"

    xmlns:tools="http://schemas.android.com/tools"

    android:layout_width="match_parent"

    android:layout_height="match_parent"

    android:paddingBottom="@dimen/activity_vertical_margin"

    android:paddingLeft="@dimen/activity_horizontal_margin"

    android:paddingRight="@dimen/activity_horizontal_margin"

    android:paddingTop="@dimen/activity_vertical_margin"

    tools:context=".NamamobilActivity" >

    <Button

        android:id="@+id/button1"

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:layout_centerHorizontal="true"

        android:layout_marginTop="62dp"

        android:text="1" />

    <TextView

        android:id="@+id/textView1"

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:layout_alignParentTop="true"

        android:layout_centerHorizontal="true"

        android:layout_marginTop="16dp"

        android:text="Kamar"

        android:textAppearance="?android:attr/textAppearanceLarge" />

    <Button

        android:id="@+id/button2"

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:layout_alignLeft="@+id/button1"

        android:layout_below="@+id/button3"

        android:layout_marginTop="24dp"

        android:text="3" />

    <Button

        android:id="@+id/button3"

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:layout_alignLeft="@+id/button1"

        android:layout_below="@+id/button1"

        android:layout_marginTop="23dp"

        android:text="2" />

    <Button

        android:id="@+id/button4"

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:layout_alignLeft="@+id/button2"

        android:layout_below="@+id/button2"

        android:layout_marginTop="33dp"

        android:text="4" />

    <Button

        android:id="@+id/button5"

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:layout_alignLeft="@+id/button4"

        android:layout_below="@+id/button4"

        android:layout_marginTop="28dp"

        android:text="5" />

</RelativeLayout>

Login Activity.java

import android.media.ExifInterface;

import android.os.Bundle;

import android.app.Activity;

import android.view.Menu;

import android.view.View;

import android.widget.Button;

import android.widget.EditText;

import android.content.Intent;

import android.widget.Toast;

public class LoginActivity extends Activity {

EditText Username;

EditText Password;

Button loginBtn;

    @Override

    protected void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_login);

        

        Username = (EditText) findViewById(R.id.editText1);

        Password = (EditText) findViewById(R.id.editText2);

        loginBtn = (Button) findViewById(R.id.button1);

        loginBtn.setOnClickListener(new View.OnClickListener() {

        public void onClick(View v) {

        // TODO Auto-generated method stub

        Intent i = new Intent(LoginActivity.this, NamamobilActivity.class);

        Toast.makeText(getApplicationContext(),"Login Berhasil",Toast.LENGTH_SHORT).show();

        

        startActivity(i);

        }

        });

    }

    @Override

    public boolean onCreateOptionsMenu(Menu menu) {

        // Inflate the menu; this adds items to the action bar if it is present.

        getMenuInflater().inflate(R.menu.login, menu);

        return true;

    }

    

}

Login.XML

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"

    xmlns:tools="http://schemas.android.com/tools"

    android:layout_width="match_parent"

    android:layout_height="match_parent"

    android:paddingBottom="@dimen/activity_vertical_margin"

    android:paddingLeft="@dimen/activity_horizontal_margin"

    android:paddingRight="@dimen/activity_horizontal_margin"

    android:paddingTop="@dimen/activity_vertical_margin"

    tools:context=".LoginActivity" >

    <Button

        android:id="@+id/button1"

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:layout_centerHorizontal="true"

        android:layout_centerVertical="true"

        android:text="Login" />

    <EditText

        android:id="@+id/editText2"

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:layout_above="@+id/button1"

        android:layout_alignLeft="@+id/editText1"

        android:layout_marginBottom="29dp"

        android:ems="10"

        android:inputType="textPassword" />

    <EditText

        android:id="@+id/editText1"

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:layout_above="@+id/editText2"

        android:layout_centerHorizontal="true"

        android:layout_marginBottom="29dp"

        android:ems="10" >

        <requestFocus />

    </EditText>

    <TextView

        android:id="@+id/textView1"

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:layout_above="@+id/editText1"

        android:layout_alignLeft="@+id/editText1"

        android:text="Username"

        android:textAppearance="?android:attr/textAppearanceLarge" />

    <TextView

        android:id="@+id/textView2"

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:layout_above="@+id/editText2"

        android:layout_alignLeft="@+id/editText2"

        android:text="Password"

        android:textAppearance="?android:attr/textAppearanceLarge" />

    <TextView

        android:id="@+id/textView3"

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:layout_alignParentLeft="true"

        android:layout_alignParentTop="true"

        android:text="Admin"

        android:textAppearance="?android:attr/textAppearanceLarge" />

</RelativeLayout>

Kamar4 Activity.java

import android.media.ExifInterface;

import android.os.Bundle;

import android.app.Activity;

import android.view.Menu;

import android.view.MenuItem;

import android.widget.TextView;

import android.widget.RadioButton;

import android.widget.RadioGroup;

import android.widget.RadioGroup.OnCheckedChangeListener;

public class XeniaActivity extends Activity {

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.Kamar4);

}

@Override

public boolean onCreateOptionsMenu(Menu menu) {

// Inflate the menu; this adds items to the action bar if it is present.

getMenuInflater().inflate(R.menu.Kamar4, menu);

return true;

}

Kamar4 Activity.XML

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"

    xmlns:tools="http://schemas.android.com/tools"

    android:layout_width="match_parent"

    android:layout_height="match_parent"

    android:paddingBottom="@dimen/activity_vertical_margin"

    android:paddingLeft="@dimen/activity_horizontal_margin"

    android:paddingRight="@dimen/activity_horizontal_margin"

    android:paddingTop="@dimen/activity_vertical_margin"

    tools:context=".Kamar4Activity" >

    <TextView

        android:id="@+id/textView1"

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:layout_alignParentTop="true"

        android:layout_centerHorizontal="true"

        android:layout_marginTop="32dp"

        android:text="Kamar 4"

        android:textAppearance="?android:attr/textAppearanceLarge" />

    <EditText

        android:id="@+id/editText1"

        android:layout_width="wrap_content"

        android:layout_height="wrap_content"

        android:layout_below="@+id/textView1"

        android:layout_centerHorizontal="true"

        android:layout_marginTop="41dp"

        android:ems="10"

        android:inputType="textPersonName"

        android:text="Rp 135.000" >

        <requestFocus />

    </EditText>

</RelativeLayout>

Maaf jika Webnya blm sempurna di karenakan masih banyak yg eror jadi yg saya tampilkan ini bisa dan nyambung,, database nya blm jdi karenakan masih eror dan blm nyambung ke aplikasi eclipsnya

Sorum mobil

Saya akan membuat aplikasi sorum mobil dan mempunyai 5 activity
Yang ada TextField,Button,Label. aplikasi ini dibuat dengan sangat sederhana

Contoh XML

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:paddingBottom="@dimen/activity_vertical_margin"
    android:paddingLeft="@dimen/activity_horizontal_margin"
    android:paddingRight="@dimen/activity_horizontal_margin"
    android:paddingTop="@dimen/activity_vertical_margin"
    tools:context=".LoginActivity" >

    <Button
        android:id="@+id/button1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_centerHorizontal="true"
        android:layout_centerVertical="true"
        android:text="Login" />

    <EditText
        android:id="@+id/editText2"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_above="@+id/button1"
        android:layout_alignLeft="@+id/editText1"
        android:layout_marginBottom="29dp"
        android:ems="10"
        android:inputType="textPassword" />

    <EditText
        android:id="@+id/editText1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_above="@+id/editText2"
        android:layout_centerHorizontal="true"
        android:layout_marginBottom="29dp"
        android:ems="10" >

        <requestFocus />
    </EditText>

    <TextView
        android:id="@+id/textView1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_above="@+id/editText1"
        android:layout_alignLeft="@+id/editText1"
        android:text="Username"
        android:textAppearance="?android:attr/textAppearanceLarge" />

    <TextView
        android:id="@+id/textView2"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_above="@+id/editText2"
        android:layout_alignLeft="@+id/editText2"
        android:text="Password"
        android:textAppearance="?android:attr/textAppearanceLarge" />

</RelativeLayout>

Contoh Source Code
package com.example.sorummobil;
import android.media.ExifInterface;
import android.os.Bundle;
import android.app.Activity;
import android.view.Menu;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.content.Intent;
import android.widget.Toast;
public class LoginActivity extends Activity {
EditText Username;
EditText Password;
Button loginBtn;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_login);
       
        Username = (EditText) findViewById(R.id.editText1);
        Password = (EditText) findViewById(R.id.editText2);
        loginBtn = (Button) findViewById(R.id.button1);
        loginBtn.setOnClickListener(new View.OnClickListener() {
        public void onClick(View v) {
        // TODO Auto-generated method stub
        Intent i = new Intent(LoginActivity.this, NamamobilActivity.class);
        Toast.makeText(getApplicationContext(),"Login Berhasil",Toast.LENGTH_SHORT).show();
       
        startActivity(i);
        }
        });

       
       
   
    }
   
   
   


    @Override
    public boolean onCreateOptionsMenu(Menu menu) {
        // Inflate the menu; this adds items to the action bar if it is present.
        getMenuInflater().inflate(R.menu.login, menu);
        return true;
    }
   
}

Contoh xml
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:paddingBottom="@dimen/activity_vertical_margin"
    android:paddingLeft="@dimen/activity_horizontal_margin"
    android:paddingRight="@dimen/activity_horizontal_margin"
    android:paddingTop="@dimen/activity_vertical_margin"
    tools:context=".NamamobilActivity" >

    <Button
        android:id="@+id/button1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_centerHorizontal="true"
        android:layout_marginTop="62dp"
        android:text="Avanza" />

    <Button
        android:id="@+id/button3"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignLeft="@+id/button1"
        android:layout_alignRight="@+id/button2"
        android:layout_below="@+id/button2"
        android:layout_marginTop="16dp"
        android:text="APV" />

    <Button
        android:id="@+id/button2"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignLeft="@+id/button1"
        android:layout_alignRight="@+id/button1"
        android:layout_below="@+id/button1"
        android:layout_marginTop="20dp"
        android:text="Xenia" />

    <TextView
        android:id="@+id/textView1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentTop="true"
        android:layout_centerHorizontal="true"
        android:layout_marginTop="16dp"
        android:text="NamaMobil"
        android:textAppearance="?android:attr/textAppearanceLarge" />

</RelativeLayout>

Contoh source Code
package com.example.sorummobil;

import android.media.ExifInterface;
import android.os.Bundle;
import android.app.Activity;
import android.view.Menu;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.content.Intent;
import android.widget.Toast;

public class NamamobilActivity extends Activity {
Button Avanza;
Button Xenia;
Button APV;

@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.namamobil);
Avanza = (Button) findViewById(R.id.button1);
Xenia = (Button) findViewById(R.id.button2);
APV = (Button) findViewById(R.id.button3);
        Avanza.setOnClickListener(new View.OnClickListener()
        {
        public void onClick(View v) {
        // TODO Auto-generated method stub
        Intent i = new Intent(NamamobilActivity.this,AvanzaActivity.class);
        Toast.makeText(getApplicationContext(),"Berhasil Masuk",Toast.LENGTH_SHORT).show();
       
        startActivity(i);
        }
        });
        Xenia.setOnClickListener(new View.OnClickListener()
        {
        public void onClick(View v) {
        // TODO Auto-generated method stub
        Intent i = new Intent(NamamobilActivity.this, XeniaActivity.class);
        Toast.makeText(getApplicationContext(),"Berhasil Masuk",Toast.LENGTH_SHORT).show();
       
        startActivity(i);
        }
        });
        APV.setOnClickListener(new View.OnClickListener()
        {
        public void onClick(View v) {
        // TODO Auto-generated method stub
        Intent i = new Intent(NamamobilActivity.this, ApvActivity.class);
        Toast.makeText(getApplicationContext(),"Berhasil Masuk",Toast.LENGTH_SHORT).show();
       
        startActivity(i);
        }
        });
}

@Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.namamobil, menu);
return true;
}

}

Contoh XML
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:paddingBottom="@dimen/activity_vertical_margin"
    android:paddingLeft="@dimen/activity_horizontal_margin"
    android:paddingRight="@dimen/activity_horizontal_margin"
    android:paddingTop="@dimen/activity_vertical_margin"
    tools:context=".AvanzaActivity" >

    <RadioGroup
        android:id="@+id/radioGroup1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_centerHorizontal="true"
        android:layout_marginBottom="30dp"
        android:layout_marginLeft="27dp" >

        <TextView
            android:id="@+id/textView1"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:text="Avanza"
            android:textAppearance="?android:attr/textAppearanceLarge" />
    </RadioGroup>

    <EditText
        android:id="@+id/editText1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_below="@+id/radioGroup1"
        android:layout_centerHorizontal="true"
        android:layout_marginTop="52dp"
        android:ems="10"
        android:inputType="number"
        android:text="200000000" />

</RelativeLayout>

Contoh Source Code
package com.example.sorummobil;
import android.media.ExifInterface;
import android.os.Bundle;
import android.app.Activity;
import android.view.Menu;
import android.view.MenuItem;
import android.widget.TextView;
import android.widget.RadioButton;
import android.widget.RadioGroup;
import android.widget.RadioGroup.OnCheckedChangeListener;
public class AvanzaActivity extends Activity {


@Override
protected void onCreate (Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.avanza);


 
   





       
}



@Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.avanza, menu);
return true;
}

}

Contoh XML
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:paddingBottom="@dimen/activity_vertical_margin"
    android:paddingLeft="@dimen/activity_horizontal_margin"
    android:paddingRight="@dimen/activity_horizontal_margin"
    android:paddingTop="@dimen/activity_vertical_margin"
    tools:context=".XeniaActivity" >

    <TextView
        android:id="@+id/textView1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentTop="true"
        android:layout_centerHorizontal="true"
        android:layout_marginTop="26dp"
        android:text="Xenia"
        android:textAppearance="?android:attr/textAppearanceLarge" />

    <EditText
        android:id="@+id/editText1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_below="@+id/textView1"
        android:layout_centerHorizontal="true"
        android:layout_marginTop="82dp"
        android:ems="10"
        android:inputType="number"
        android:text="400000000" >

        <requestFocus />
    </EditText>

</RelativeLayout>

Contoh Source Code
package com.example.sorummobil;
import android.media.ExifInterface;
import android.os.Bundle;
import android.app.Activity;
import android.view.Menu;
import android.view.MenuItem;
import android.widget.TextView;
import android.widget.RadioButton;
import android.widget.RadioGroup;
import android.widget.RadioGroup.OnCheckedChangeListener;

public class XeniaActivity extends Activity {

@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.xenia);


}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.xenia, menu);
return true;
}



}

Contoh XML
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:paddingBottom="@dimen/activity_vertical_margin"
    android:paddingLeft="@dimen/activity_horizontal_margin"
    android:paddingRight="@dimen/activity_horizontal_margin"
    android:paddingTop="@dimen/activity_vertical_margin"
    tools:context=".ApvActivity" >

    <TextView
        android:id="@+id/textView1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_alignParentTop="true"
        android:layout_centerHorizontal="true"
        android:layout_marginTop="33dp"
        android:text="Apv"
        android:textAppearance="?android:attr/textAppearanceLarge" />

    <EditText
        android:id="@+id/editText1"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_below="@+id/textView1"
        android:layout_centerHorizontal="true"
        android:layout_marginTop="35dp"
        android:ems="10"
        android:inputType="number"
        android:text="12000000" />

</RelativeLayout>


Contoh Source Code
package com.example.sorummobil;

import android.os.Bundle;
import android.app.Activity;
import android.view.Menu;

public class ApvActivity extends Activity {

@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.apv);
}

@Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.apv, menu);
return true;
}

}

Tugas Uas Pemrograman1

Selamat malam , kali ini saya akan membuat program penjualan jus  menggunakan aplikasi virtual basic dan membuat database pada ms.access akan tetapi di sini agak sederhana sekali programnya, sehingga perlu di ketik pada websitenya lalu di simpan, kita simak saja programnya.

Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.OleDb
Partial Class efril_

    Inherits System.Web.UI.Page
    Dim constring As String = ConfigurationManager.ConnectionStrings("efrilConnectionString").ConnectionString
    Dim xReader As OleDbDataReader
    Dim oConn As New OleDbConnection(constring)
    Dim Sql As String
    Protected Sub TextBox2_TextChanged(sender As Object, e As EventArgs) Handles TextBox2.TextChanged

    End Sub

    Protected Sub Button4_Click(sender As Object, e As EventArgs) Handles Button4.Click
        Dim Sql As String = "DELETE FROM Customer where namapaket = ('" & TextBox1.Text & "');"
        Dim oCmd As New OleDbCommand
        oConn.Open()
        oCmd.Connection = oConn
        oCmd.CommandText = Sql
        oCmd.ExecuteNonQuery()

    End Sub

    Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        Response.Redirect("efril")
    End Sub

    Protected Sub Button3_Click(sender As Object, e As EventArgs) Handles Button3.Click
        Dim sql As String = "INSERT INTO Customer VALUES ('" & TextBox2.Text & "','" & TextBox1.Text & "','" & TextBox3.Text & "');"
        Dim oCmd As New OleDbCommand
        oConn.Open()
        oCmd.Connection = oConn
        oCmd.CommandText = sql
        oCmd.ExecuteNonQuery()
    End Sub

    Protected Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click
        If Not Len(TextBox1.Text) = 0 Then
            oConn.Close()
            oConn.Open()
            Dim ocmd As New OleDbCommand("SELECT * FROM Customer where namapaket='" + TextBox1.Text + "'", oConn)
            xReader = ocmd.ExecuteReader
            If xReader.HasRows Then
                xReader.Read()
                TextBox2.Text = xReader("codepaket")
                TextBox3.Text = xReader("harga")
            Else
                TextBox2.Text = "Nama Barang Tidak Ada"

            End If
        End If
    End Sub
End Class