To enter data into database, assuming you have two fields
"myField1":nvarchar(50)
"myField2":datetime
And are using MS Sql:
using (SqlConnection con = new SqlConnection(strConnect))
{
con.Open();
using (SqlCommand com = new SqlCommand("INSERT INTO myTable (myField1, myField2) " +
"VALUES (@MF1, @MF2)", con))
{
com.Parameters.AddWithValue("@MF1", "Test");
com.Parameters.AddWithValue("@MF2", DateTime.Now);
com.ExecuteNonQuery();
}
}
To read it out, a TextBox is not the best choice, somethign that displays rows fo data would be better: try a DataGridView:
using (SqlConnection con = new SqlConnection(strConnect))
{
DataSet ds = new DataSet();
SqlDataAdapter adp = new SqlDataAdapter("SELECT * FROM myTable", con);
adp.Fill(ds);
myDataGridView.DataSource = ds;
}