If data is not in Access DB then create pop up..

Question

So I am querying my Access DB and need a pop up window to alert if the detail is not in the Access db. it would have to be something like if ( firstname not in Access DB) { messagebox.show("user not found"); }

Amit Mohanty · Answer

You can use Linq for this. string strQuery = "select *, from Students WHERE Firstname LIKE '" + tbsearchid.Text + "' OR " + "ID1 like '" + tbsearchid.Text + "'" ; OleDbConnection OleDbCon = new OleDbConnection( "Your Connection String" ); if (OleDbCon.State == ConnectionState.Closed) { OleDbCon.Open(); } OleDbCommand OleDbCmd = new OleDbCommand(strQuery, OleDbCon); OleDbDataAdapter OleDbDa = new OleDbDataAdapter(OleDbCmd); DataTable dtData = new DataTable(); OleDbDa.Fill(dtData); if (dtData.Rows.Count > 0) { string userName = "John Grisham" ; bool contains = dtData.AsEnumerable().Any(row => userName == row.Field string >( "Firstname" )); if (contains) { // Your Code. } else MessageBox.Show( "User Not Found !!!" ); } else MessageBox.Show( "No User Found !!!" );

Rajanikant Hawaldar · Answer

write query to check rowcount if row count is more then 0 then data is available using System; using System.Data.OleDb; namespace AccessDBSample { class Program { static void Main( string [] args) { // Connection string and SQL query string connectionString = @ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Mahesh\Data\Dev.mdb" ; string strSQL = "select *, from Students WHERE Firstname LIKE '" + tbsearchid.Text + "' OR " + "ID1 like '" + tbsearchid.Text + "'" "; // Create a connection using (OleDbConnection connection = new OleDbConnection(connectionString)) { // Create a command and set its connection OleDbCommand command = new OleDbCommand(strSQL, connection); // Open the connection and execute the select command. try { // Open connecton connection.Open(); // Execute command using (OleDbDataReader reader = command.ExecuteReader()) { while (reader.Read()) { if (! string .IsNullOrWhiteSpace(reader[ "username" ])) { //bind your data here } else { MessageBox.Show( "User not found" ); } } } } catch (Exception ex) { MessageBox.Show(ex.Message); } // The connection is automatically closed becasuse of using block. } } } } Thanks