Of course the value will not be inserted - but just wanted to make sure
that the problem is occurring on insertion..!
Thanks & Regards
Taleeb Anwar
*Hai Ab bhi Tera "Shwarma" Afsana Khwan Humara!!*
On Tue, Apr 10, 2012 at 6:23 PM, Dorababu Meka <dora.m...@gmail.com> wrote:
> How Can I insert data in to the table if I comment that line as per you
> said..
>
> Session value exists if I comment that line..
>
> On Tue, Apr 10, 2012 at 6:20 PM, Taleeb Anwar <taleeban...@gmail.com>
> wrote:
>
> > 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 <dora.m...@gmail.com>
> > 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 <tede_1...@gmx.de> 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
> > > > sqlite-users@sqlite.org
> > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > > >
> > >
> > >
> > >
> > > --
> > > *Thanks & Regards,*
> > > **
> > > *M.Dorababu*
> > > **
> > > **
> > > _______________________________________________
> > > sqlite-users mailing list
> > > sqlite-users@sqlite.org
> > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> > >
> > _______________________________________________
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
>
>
>
> --
> *Thanks & Regards,*
> **
> *M.Dorababu*
> **
> **
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
