How to connect db in asp.net in our application

I suggest that you learn Entity Framwork (EF). That will take time to learn but it will save time in the future. Since I use it for ASP.Net applications I have no samples of using a database in ASP.Net applications without EF. I have a simple application that uses SQLite in a WPF application that might help.

You do not say whether you are using SQL Server or some other database. I assume you have already created the database. You will need to have a connection string for the database. The format of the connection string depends on what type of database it is. You can probably use Visual Studio's SQL Server Object Explorer to get the connection string.

The following will read a table from a SQLite database into a List collection where ClipText is the table name and is also a C# class and Description and Data are fields in the table.

List ctl = new List();
//
using (SqliteConnection connection = new SqliteConnection(cs))
{
    connection.Open();
    var command = connection.CreateCommand();
    command.CommandText = @"SELECT Description, Data FROM ClipText";
    using (SqliteDataReader reader = command.ExecuteReader())
    {
        while (reader.Read())
        {
            var name = reader.GetString(0);
            ClipText ct = new ClipText();
            ct.Description = reader["Description"].ToString();
            ct.Data = reader["Data"].ToString();
            ctl.Add(ct);
        }
    }
}

I am not sure how to get the data into the HTML withour using EF. As I said, I use EF.

it seems you are at the beginning level of learing aspnet.if so then you should first practice using ado.net as it is the basic tool to connect with your db then move further.there are several ways of connecting your app to db.

Hello Krishna

You can create API using .net and call it from the HTML using jQuery Ajax call or you can use a javascript library like angular or react native to call API.

Simple steps you can try:

1. Create an API project in asp.net or .net core. 
2. Create a Database connection from the API project and write API code to get expected data.
3. Write javascript code call API and bind the data to HTML.

Thanks

Vishal Joshi

Hi, could you please find link to connect to DB using C#  code.

https://www.c-sharpcorner.com/article/how-to-connect-sql-database-in-asp-net-using-c-sharp-and-insert-and-view-the-data-usi/