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

J Vs

7y761Windows Forms

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");

}

2 Replies

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

Amit Mohanty7y ago
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 Hawaldar7y ago
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