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+