how do I Insert selected value of listview to database?

mahnaz af

11y1.1k.NET

Hi everyone,

i want to insert selected value of listview to database but this code does not work.please help me.

GroupItemCount="3">

border-color: #999999; border-style: none; border-width: 1px;" id="tblProduct">

font-family: Verdana, Arial, Helvetica, sans-serif; color: #BA2323">

...??????? ?????

protected void ListView1_SelectedIndexChanging(object sender, ListViewSelectEventArgs e)

{

ListViewItem item = (ListViewItem)ListView1.Items[e.NewSelectedIndex];

if (Session["username"] == null)

{

Response.Write("???? ???? ????? ???? ???? ?????? ??? ????");

}

else

{

DataSet1 ds = new DataSet1();

DataSet1TableAdapters.tblFactorTableAdapter ta = new DataSet1TableAdapters.tblFactorTableAdapter();

DataSet1TableAdapters.tblOrderTableAdapter t6 = new DataSet1TableAdapters.tblOrderTableAdapter();

DataSet1TableAdapters.tblOrderTableAdapter ta7 = new DataSet1TableAdapters.tblOrderTableAdapter();

ta.FillByUser(ds.tblFactor, Session["username"].ToString(), false);

Label pidlabel = (Label)item.FindControl("lblpid");

int pid = Convert.ToInt32(pidlabel);

Label pricelabel = (Label)item.FindControl("lblprice");

decimal price = Convert.ToDecimal(pricelabel);

TextBox textbx = (TextBox)item.FindControl("txtcount");

int count = Convert.ToInt32(textbx);

// Response.Write("tedad=" + tedad);

decimal finalprice = price * count;

if (ds.tblFactor.Rows.Count > 0)

{

int fid = int.Parse(ds.tblFactor.Rows[0]["fid"].ToString());

ta7.InsertQuery(fid, pid, price, finalprice, count);

}

else

{

PersianCalendar pc = new PersianCalendar();

string tarikh = pc.GetYear(DateTime.Now) + "/" + pc.GetMonth(DateTime.Now) + "/" + pc.GetDayOfMonth(DateTime.Now);

string saat = DateTime.Now.Hour + ":" + DateTime.Now.Minute;

ta.Insert(tarikh, saat, Session["username"].ToString(), false);

ta.FillByUser(ds.tblFactor, Session["username"].ToString(), false);

int fid = int.Parse(ds.tblFactor.Rows[0]["fid"].ToString());

ta7.InsertQuery(fid, pid, price, finalprice, count);

}

4 Replies

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

mahnaz af11y ago
links aren't useful for me.please tell me how call function ListView1_ItemInserting() to add data to data base?
i use from button(insert) in insertitemtemplate but this don't work;
i have one listview and i want insert the value of colum that i selected to database.
plesae guide me that how do this work?please...
Nilesh Jadav11y ago
http://stackoverflow.com/questions/13451012/how-to-insert-the-selected-value-in-this-form-to-the-database

http://stackoverflow.com/questions/22399751/how-to-move-data-from-listview-and-insert-into-database
mahnaz af11y ago
thanks for your guide;
but i don't know to call function ListView1_ItemInserting() to insert data to data base:

protected void ListView1_ItemInserting(object sender, ListViewInsertEventArgs e)
{
DataSet1 ds = new DataSet1();
DataSet1TableAdapters.tblFactorTableAdapter ta = new DataSet1TableAdapters.tblFactorTableAdapter();
DataSet1TableAdapters.tblOrderTableAdapter t6 = new DataSet1TableAdapters.tblOrderTableAdapter();
DataSet1TableAdapters.tblOrderTableAdapter ta7 = new DataSet1TableAdapters.tblOrderTableAdapter();
ta.FillByUser(ds.tblFactor, Session["username"].ToString(), false);
string pid1 = "", price1 = "", count1 = "";
Label lbl = (e.Item.FindControl("lblpid")) as Label;
if (lbl != null)
pid1 = lbl.Text;
int pid2 = Convert.ToInt32(pid1);
lbl = (e.Item.FindControl("lblprice")) as Label;
if (lbl != null)
price1 = lbl.Text;
decimal price2 = Convert.ToDecimal(price1);
TextBox txt = (e.Item.FindControl("txtcount")) as TextBox;
if (txt != null)
count1 = txt.Text;
int count2 = Convert.ToInt32(count1);
decimal finalprice1 = count2 * price2;
if (ds.tblFactor.Rows.Count > 0)
{
int fid = int.Parse(ds.tblFactor.Rows[0]["fid"].ToString());
ta7.InsertQuery(fid, pid2, price2, finalprice1, count2);
}
else
{
PersianCalendar pc = new PersianCalendar();
string tarikh = pc.GetYear(DateTime.Now) + "/" + pc.GetMonth(DateTime.Now) + "/" + pc.GetDayOfMonth(DateTime.Now);
string saat = DateTime.Now.Hour + ":" + DateTime.Now.Minute;
ta.Insert(tarikh, saat, Session["username"].ToString(), false);
ta.FillByUser(ds.tblFactor, Session["username"].ToString(), false);
int fid = int.Parse(ds.tblFactor.Rows[0]["fid"].ToString());
ta7.InsertQuery(fid, pid2, price2, finalprice1, count2);
}
}
Nilesh Jadav11y ago
Hey Mahnaz

Try this links might it work :

http://www.dbtutorials.com/advanced/listview-inserting/

http://www.codeproject.com/Questions/118912/listbox-multiple-selected-values

Thank you