Listview with database.

Saudie Esmail

12y1.6kC#

how can save the items in listview?? I tried this

private void btnSave_Click(object sender, EventArgs e)

{

try

{

con.Close();

con.Open();

foreach (ListViewItem Itm in listView1.Items)

cmd = new MySqlCommand("INSERT into sched_tbl (Day,Coursecode,Time,room)" + " VALUE('" + Itm.SubItems[0].Text + "','" + Itm.SubItems[1].Text + "','" + Itm.SubItems[2].Text + "','" + Itm.SubItems[3].Text + "')", con);

dt = cmd.ExecuteReader();

con.Close();

MessageBox.Show("good");

}

catch (Exception ex)

{

MessageBox.Show(ex.Message);

}

con.Close();

}

It work but my problems is only the first item is saved in my database..

I need help.. thanks :(

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ankur Jain12y ago
Accepted answer
H!,

Try like this...

private void btnSave_Click(object sender, EventArgs e)
{
try
{
con.Close();

string sql;
string Day;
string CourseCode;
DateTime Time;
int Room;
for(int i=0;i
{
Day +=Convert.ToString(listView1.Item[i].SubItems[1].Text);
CourseCode += Convert.ToString(listView1.Items[i].SubItems[2].Text);
Time +=Convert.ToDateTime(listView1.Items[i].SubItems[3].Text);
Room += Convert.ToInt32(listView1.Items[i].SubItems[4].Text);
}
sql ="";
sql +="INSERT into sched_tbl (Day,Coursecode,Time,room)";
sql += "VALUES ('"+ Day +"','"+CourseCode +"', '"+ Time +"','"+Room +"')";

clsConnection clsCn = new clsConnection();
SqlConnection cn = null;
SqlCommand cmd = new SqlCommand();

clsCn.fnc_ConnectToDB(ref cn);

cmd.Connection = cn;
cmd.CommandText = sql;
cmd.ExecuteNonQuery();

this.Close();
con.Close();

}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}

}

Note no more "+=" and you add the ListViewItems one by one.

if it helps, please mark it as answer
Sanjay Kumar12y ago
Hi

http://sqlneed.blogspot.in/2014/04/How-to-load-data-into-listview-from-database.html

http://www.c-sharpcorner.com/UploadFile/mgold/ListViewInCSharp11172005021741AM/ListViewInCSharp.aspx