Select data from database with class C#

Question

Need to select data from dbo.customers

Id
Name
Surname
tax

to class,becose need to use in my app.
Now I every time in form create string select from etc...
I dont want that.
Want to use data with class
Some exaples or link
Thank you

Mageshwaran R · Answer

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 Shethiya · Answer

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

Goran Bibic · Answer

Like this using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Linq; using System.Text; using System.Threading.Tasks; namespace BSS { class Podaci_o_korisniku { private string Ovlasteno_Lice; public string Name { get { return ovlasteno_Lice; } set { ovlasteno_Lice = value;} } public static void Podaci() { // Ovlasteno_Lice = Name; SqlConnection con2 = new SqlConnection(Con); con2.Open(); SqlCommand cmd = con2.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = select ovlasteno_lice from dbo.podaci_o_korisniku ; cmd.ExecuteNonQuery(); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); foreach (DataRow dr in dt.Rows) { ovlasteno_lice.Items.Add(dr[ ovlasteno_lice ].ToString()); } con2.Close(); } } }

Rajanikant Hawaldar · Answer

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

Goran Bibic · Answer

Magesh R That is not that what I want

Goran Bibic · Answer

Rajanikant Hawaldar Not that