how to insert value from listview control into database

Question

hi, i want to insert data from listview control into database on button click . the application is in universal windows application.

Hubert Hermanutz · Answer

Hi, one possibility will be to use DataAdapter as ItemSource like -------------------------------- snippet for XAML ------------------------------------- -------------------------------- snippet for fill ------------------------------------------ SqlConnection con = new SqlConnection(...); myAdapter = new SqlDataAdapter("Select * from TestTable", con); // myDataTable = new System.Data.DataTable(); myAdapter.Fill(myDataTable); //fill ListView this.ctlListView.ItemsSource = myDataTable.DefaultView; -------------------------------- snippet for write back changes ------------------------------------------ private void onBtnSave_Clicked(object sender, RoutedEventArgs e) { SqlConnection con = new SqlConnection(...); con.Open(); //define update command... myAdapter.UpdateCommand = new SqlCommand("UPDATE TestTable SET FieldOne = @FieldOne WHERE Id = @Id", con); SqlParameter p = myAdapter.UpdateCommand.Parameters.Add("@FieldOne", System.Data.SqlDbType.NVarChar, -1, "FieldOne"); p = myAdapter.UpdateCommand.Parameters.Add("@Id", System.Data.SqlDbType.Int); p.SourceColumn = "Id"; p.SourceVersion = System.Data.DataRowVersion.Original; //update changes myAdapter.Update(myDataTable.Select(null, null, System.Data.DataViewRowState.ModifiedCurrent)); } regards, Hubert Hermanutz

Anbu Mani · Answer

Try this one http://www.c-sharpcorner.com/article/xamarin-androidlist-view-using-sql-server-database/

Amit Kumar · Answer

Hi, Use this link. below both lines are single line. https://forums.asp.net/t/1747018.aspx?How+to+insert+a+record+into+a+listview+control+of+asp+net+using+c+

how to insert value from listview control into database

Answers (3)