Learn how to integrate database features into your project using the Global Query Class, Part 9

Code for Database and Code of ChatGPT
public class QueryClass
{
    SqlConnection Conn = new SqlConnection();
    public string ConnString = "Data Source=.;Initial Catalog=db_DCMS;User ID=sa;Password='abc'";
    public SqlConnection OpenConnection()
    {
        try
        {
            if (Conn.State != ConnectionState.Open)
            {
                Conn.ConnectionString = ConnString; // Assign the connection string
                Conn.Open();
            }
        }
        catch (Exception ex)
        {
            // Handle exceptions
        }

        return Conn;
    }

    public DataTable SelectData(string query)
    {
        SqlDataAdapter da = new SqlDataAdapter(query, OpenConnection());
        DataTable dt = new DataTable();
        da.Fill(dt);
        return dt;
    }

    // for insert/delete/update SQL queries
    public void Execute(string query)
    {
        SqlCommand cmd = new SqlCommand(query, OpenConnection());
        cmd.ExecuteNonQuery();
    }

}

CHAT CPT CODE FOR  IF AND ELSE
DataTable dt = qry.SelectData("Select * from Users where username='"+acc.username+"'");
if (dt.Rows.Count != 0)
{
   DataRow dr = dt.Rows[0];
   if (dr["Password"].ToString() == acc.password)
   {
       // Password matches, proceed
       return View("Success");
   }
   else
   {
       // Password does not match
       ViewData["ErrorMsg"] = "Password does not match. Please try again.";
       return View("Error");
   }

}
else
{
   //username not match

   return View("Error");
}

• #people_blogs
• #mvc_net_core_database_integration
• #adding_database_to_mvc_net_core_project
• #entity_framework_core_in_mvc_project
• #database_connectivity_in_net_core_mvc
• #mvc_project_with_entity_framework_core
• #mvc_net_core_80_database_tutorial
• #crud_operations_in_mvc_net_core
• #mvc_net_core_database_connectivity
• #database_integration_in_net_core_mvc
• #mvc_net_core_entity_framework_basics