Loop through Data

Hello Ramco,

// database table class
public class Gallery
{
	public int ID { get; set; }
	
	public string URL { get; set; }
}

//Fetching the data from the database side code.
public class GalleryService
{
	public List ReadGallaryData(string connectionString)
	{
		string queryString =
			"SELECT ID, URL FROM dbo.Gallery;";

		using (SqlConnection connection =
				   new SqlConnection(connectionString))
		{
			SqlCommand command =
				new SqlCommand(queryString, connection);
			connection.Open();

			SqlDataReader reader = command.ExecuteReader();
			
			var gallaries = new List();
			
			// Call Read before accessing data.
			while (reader.Read())
			{
				gallaries.Add(new Gallery
				{
					ID = reader[0],
					URL = reader[1]
				});            
			}

			// Call Close when done reading.
			reader.Close();
			
			return gallaries;
		}
	}
}


// API side code
[HttpGet]
public IActionResult> Get()
{
	var response = _gallaryService.ReadGallaryData();
	return Ok(response);
}

Thanks

Hello Ramco,

Prepare the list variable in the javascipt side or if you are using angular/react then prepare the list in the componenet side, and use that object in the html side for render and showing the data.

Thanks

Using .NET 6.0 Web API, you can achieve the same functionality by creating a Web API project that connects to your database and serves the image URLs. Here's a basic outline of how you can do this:

1. Set up your database: Make sure you have a database table with columns for image URLs.

2. Create a .NET Web API project: You can create a new .NET Web API project using Visual Studio or the .NET CLI.

3. Set up Entity Framework Core: Use Entity Framework Core to interact with your database from the API project.

4. Create a Controller: Implement a controller that retrieves the image URLs from the database and returns them as JSON.

sample UI code