protected override void OnNavigatedFrom(NavigationEventArgs e) { if (dbConn != null) { /// Close the database connection. dbConn.Close(); } } private void Click_Login(object sender, RoutedEventArgs e) { dbConn = new SQLiteConnection(DB_PATH); SQLiteCommand sqCommand = new SQLiteCommand(dbConn); if (txtEmailaddress.Text != "") { sqCommand.CommandText = "SELECT * FROM Task Where Email=" + "\'" + txtEmailaddress.Text + "\'" + "and Password=" + "\'" + txtPassword.Password + "\'"; sqCommand.ExecuteNonQuery(); SQLiteDataReader reader = sqCommand.ExecuteReader();// exeception throws here } }
I am using Visual Studio 2012. Please help me how to solve in this issue
nagaraj mPosted Jul 4, 2013, 5:24 AM
Anyway i have to say special thanks to you, because you are supporting me too..,
Posted Jul 3, 2013, 9:35 AM
nagaraj mPosted Jul 3, 2013, 9:08 AM
using (var dbConn = new SQLiteConnection(DB_PATH))
{
var existing = dbConn.Query
if (existing != null)
{
NavigationService.Navigate(new Uri("/Input.xaml?selectedItem=", UriKind.Relative));
}
else
{
MessageBox.Show("invalid login");
}
}
Posted Jul 2, 2013, 3:08 AM
Just attached the dll's.
Please try and let me know, does it working for your application?
nagaraj mPosted Jul 2, 2013, 2:28 AM
Posted Jul 2, 2013, 2:16 AM
Download the dll and add it your project.
nagaraj mPosted Jul 2, 2013, 1:40 AM
Posted Jul 2, 2013, 12:55 AM
https://code.google.com/p/csharp-sqlite
or
http://sterling.codeplex.com
Posted Jul 2, 2013, 12:43 AM
You need to use a webservice for CRUD operations from Silverlight applications. The webservice in turn uses the SQLite assemblies.
Please let me know, if you need any help on this.
nagaraj mPosted Jul 1, 2013, 9:23 AM
Posted Jul 1, 2013, 9:22 AM
nagaraj mPosted Jul 1, 2013, 9:20 AM
Posted Jul 1, 2013, 9:08 AM
nagaraj mPosted Jul 1, 2013, 8:55 AM
Posted Jul 1, 2013, 8:49 AM
Make sure, the sqlLite.dll's are present in bin\debug directory.
nagaraj mPosted Jul 1, 2013, 8:47 AM
nagaraj mPosted Jul 1, 2013, 3:02 AM
Posted Jul 1, 2013, 2:53 AM
nagaraj mPosted Jul 1, 2013, 2:51 AM
I need to set user login.
Posted Jul 1, 2013, 2:38 AM
Do you have sqlLite.dll reference added in your project and it is available in your mobile devices also?
Which version SQLLite are you using and from where you downloaded the dll's?
nagaraj mPosted Jul 1, 2013, 2:11 AM
nagaraj mPosted Jul 1, 2013, 2:10 AM
The type or namespace name 'SQLiteDataReader' could not be found (are you missing a using directive or an assembly reference?)
Posted Jul 1, 2013, 1:25 AM