how to insert value from listview control into database

Try this one

 

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

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

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+