Though I don't know much about .NET...still Try the following Comment the execute non query. Now Click on button 1 (no values will be inserted) and then on button 2. Is session value retained or lost?
Thanks & Regards Taleeb Anwar *Hai Ab bhi Tera "Shwarma" Afsana Khwan Humara!!* On Tue, Apr 10, 2012 at 5:40 PM, Dorababu Meka <[email protected]> wrote: > This is my code that I have written in .Net > > protected void Page_Load(object sender, EventArgs e) > { > > if (!IsPostBack) > { > Session["x"] = "session value"; // assigning Session > } > } > > My code to insert data to the Database is as follows > > protected void Button1_Click(object sender, EventArgs e) > { > string path = Server.MapPath("bin/sampldb.db"); > SQLiteConnection conn = new SQLiteConnection("Data Source=" + path > + ""); > try > { > conn.Open(); > SQLiteCommand cmd = new SQLiteCommand(); > cmd.Connection = conn; > string txt = "insert into stu values(" + TextBox1.Text + ",'" + > TextBox2.Text + "')"; > cmd.CommandType = CommandType.Text; > cmd.CommandText = txt; > cmd.ExecuteNonQuery(); > conn.Close(); > > } > catch (Exception ex) > { > Label1.Visible = true; > Label1.Text = "Error:" + ex.Message; > } > } > > My code to test whether Session exists or not after Inserting data is as > follows > > protected void Button2_Click(object sender, EventArgs e) > { > if (Session["x"] != null) // Here after Inserting data and > clicking on the next button available my Session value is getting Null > { > Label1.Visible = true; > Label1.Text = Session["x"].ToString(); > } > } > > This is the over all code I have written in my application > > On Tue, Apr 10, 2012 at 5:35 PM, TeDe <[email protected]> wrote: > > > Am 10.04.2012 11:17, schrieb Dorababu Meka: > > > Hi I am using SQLLITE database in my .net application. Unfortunately > if I > > > perform any operation like Insert and performing other operations like > > > getting data from database my Session which was assigned before is > > getting * > > > NULL.* Is this a bug or what, have you fixed this in later versions, if > > so > > > please let me know. > > > > > > I am using Visual Studio 2010.. > > > > > We have been using System.Data.SQLite for many years, without major > > bugs. So its unlikely you found one. Instead the way you are using the > > Framework might be somehow erroneous. > > > > If you ask these kind of questions, please post some lines of relevant > > code. With such an unspecific information, nobody is able to help you. > > > > Thomas > > _______________________________________________ > > sqlite-users mailing list > > [email protected] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > *Thanks & Regards,* > ** > *M.Dorababu* > ** > ** > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
