Select data from database with class C#

Sign in to answer this question.

• GB

  Goran Bibic6y agoPosted Nov 23, 2019, 3:22 AM

  Magesh R

   

  That is not that what I want
• 

  Mageshwaran R6y agoPosted Nov 22, 2019, 10:37 AM

  Hi,

  Please refer the below link, it might helps you 

  https://www.c-sharpcorner.com/UploadFile/009464/make-edit-update-and-delete-operation-in-gridview-in-Asp-Net/ 
• 

  Jaimin Shethiya6y agoPosted Nov 22, 2019, 4:52 AM

  Hello Goran,
  
  please refer below link for.
  this is convert datatable to generic list so helping for you.
  
  https://stackoverflow.com/questions/208532/how-do-you-convert-a-datatable-into-a-generic-list
  
  let me know if you have needed any other help.
  
  Thanks
• GB

  Goran Bibic6y agoPosted Nov 22, 2019, 4:25 AM

  Like this

   

  1. using System;  
  2. using System.Collections.Generic;  
  3. using System.Data;  
  4. using System.Data.SqlClient;  
  5. using System.Linq;  
  6. using System.Text;  
  7. using System.Threading.Tasks;  
  8.   
  9. namespace BSS  
  10. {  
  11.     class Podaci_o_korisniku  
  12.     {  
  13.         private string Ovlasteno_Lice;  
  14.   
  15.         public string Name  
  16.         {  
  17.             get{return ovlasteno_Lice; }  
  18.             set{ ovlasteno_Lice = value;}  
  19.         }  
  20.   
  21.         public static void Podaci()  
  22.         {  
  23.            // Ovlasteno_Lice = Name;  
  24.   
  25.             SqlConnection con2 = new SqlConnection(Con);  
  26.             con2.Open();  
  27.             SqlCommand cmd = con2.CreateCommand();  
  28.             cmd.CommandType = CommandType.Text;  
  29.             cmd.CommandText = "select ovlasteno_lice from dbo.podaci_o_korisniku";  
  30.             cmd.ExecuteNonQuery();  
  31.             DataTable dt = new DataTable();  
  32.             SqlDataAdapter da = new SqlDataAdapter(cmd);  
  33.             da.Fill(dt);  
  34.             foreach (DataRow dr in dt.Rows)  
  35.             {  
  36.                 ovlasteno_lice.Items.Add(dr["ovlasteno_lice"].ToString());  
  37.             }  
  38.             con2.Close();  
  39.         }  
  40.   
  41.   
  42.     }  
  43.   
  44. } 
      

   
• GB

  Goran Bibic6y agoPosted Nov 22, 2019, 4:25 AM

  Rajanikant Hawaldar

   

  Not that
• 

  Rajanikant Hawaldar6y agoPosted Nov 22, 2019, 3:52 AM

  https://www.codeproject.com/Articles/24656/A-Detailed-Data-Binding-Tutorial

  https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/linq/walkthrough-simple-object-model-and-query-csharp

  https://www.c-sharpcorner.com/UploadFile/rohatash/bind-database-values-to-generic-list-using-Asp-Net/

  https://www.c-sharpcorner.com/UploadFile/009464/bind-grid-view-with-database-in-mvc-5-in-C-Sharp/

  https://www.tutorialspoint.com/asp.net/asp.net_data_binding.htm