Spaces:
Sleeping
Sleeping
File size: 594 Bytes
fe612fa |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
import streamlit as st
import sqlite3
st.title("Task 2: Insert Data")
db_name = st.text_input("Enter database name:", "example.db")
table_name = st.text_input("Enter table name:", "students")
data = st.text_area("Enter data (e.g., 1, 'John Doe'):")
if st.button("Insert Data"):
try:
conn = sqlite3.connect(db_name)
cursor = conn.cursor()
cursor.execute(f"INSERT INTO {table_name} VALUES ({data})")
conn.commit()
st.success("Data inserted successfully!")
except Exception as e:
st.error(f"Error: {e}")
finally:
conn.close()
|