![]() Private void AddToDatatable_Click(object sender, EventArgs e) SQLiteCommandBuilder commandBuilder = new SQLiteCommandBuilder(sQLiteDataAdapter) ![]() Using (SQLiteDataAdapter sQLiteDataAdapter = new * from t1", connection)) Private void Save_Click(object sender, EventArgs e) Using (SQLiteCommand command = new SQLiteCommand(selectSql, connection)) Using (SQLiteConnection connection = new Source=d:\test\db\hello.db")) Private void Form1_Load(object sender, EventArgs e) So we should save the data input of textbox and datagridview to a datatable, and then use the DataAdapter to write the datatable changes to the database. The data in the textbox and the data in the datagridview should come from the same data source. + double.Parse(tb_Other.Text)))))).ToString()) (double.Parse(tb_LOA.Text) + double.Parse(tb_Long_LOA.Text) + (double.Parse(tb_Late.Text) + double.Parse(tb_Early.Text) + ![]() (double.Parse(tb_Personal.Text) + double.Parse(tb_Qday.Text) + Tb_Total.Text = (double.Parse(tb_Sick.Text) + double.Parse(tb_Vac.Text) + Tb_Over_Under.Text = (double.Parse(tb_Roll.Text) - double.Parse(tb_Required_Roll.Text)).ToString(), private void btn_Save_Click(object sender, EventArgs e)ĭateTimePicker1.Value, tb_Leader_Present.Text, tb_Leader_Online.Text, Below is textbox code.īasically I wont to mix the 2 together. When I select it will populate both textboxes and Datagridview, I can save and populate the textboxes but not Lets say I have 2 panels one is Textboxes and the other is a Datagridview I save to a database. Is it possible to have a Sqlite database that will save information from textboxes and a Datagridview?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |