Asp.Net Gridview : Bind Database Table

🍒 Related Videos
Asp.Net Core MVC Tutorials: • Asp.Net Core MVC Tutorial
MVC Login & User Registration: • Asp.Net Core MVC & Ide...
CRUD in Asp Web Form: • C# Asp.Net Web Form CR...
GridView CRUD in Asp Web Form : • Asp.Net Web Form Gridv...
MySQL CRUD in Asp Web Form: • Asp.Net Web Form CRUD ...
jQuery DataTable Playlist with Asp Web Form: • jQuery Datatable and A...
Login in Asp Web Form: • How to Create Login Pa...
More Asp.Net Web Form Tutorials: • Asp WebForm MVC Tutori...
📂 GitHub Repository
► goo.gl/z4nwbc
💖 Channel Support
➤ Paypal: bit.ly/3L36ut4
➤ UPI App: geni.us/ScanQR...
➤ Amazon: geni.us/Amazon...
💌 For Business Inquiries
➤ [e-mail]
🚶‍♂️ Follow us
Facebook : / codaffection
Discord : / discord
Twitter : / codaffection
---
How to Bind Database Table in Asp.Net Gridview
In this video, we have discussed how to bind or display database table in asp.net gridview using SQL Server. In the last column, we have shown a link button to select a row.
#AspNet #CodAffection

[@CodAffection]

goo.gl/bPcyXW : Buy me a Coffee bit.ly/30fPDMg : AspNet Core MVC Tutorials bit.ly/3yTsztF : More AspNet Web Form Tutorials bit.ly/36IA1cH : CRUD in AspNet Core MVC bit.ly/2Z7PI3e : CRUD in Asp Web Form bit.ly/2TA9N14 : GridView CRUD in Asp Web Form bit.ly/2Z784pi : MySQL CRUD in Asp Web Form bit.ly/3Z5uWUR : jQuery DataTable Playlist with Asp Web Form bit.ly/2MlkMuM : Login in Asp Web Form

[@coledalton5581]

i know Im kinda randomly asking but do anyone know of a good website to stream newly released series online ?

[@zevsawyer7457]

@Cole Dalton Try FlixZone. Just google for it :)

[@malcolmvivaan7841]

@Zev Sawyer Definitely, been using flixzone for since april myself =)

[@coledalton5581]

@Zev Sawyer thank you, signed up and it seems like they got a lot of movies there :) I appreciate it !!

[@zevsawyer7457]

@Cole Dalton Happy to help :D

[@fabiandibia1858]

One of the best Online tutorial I have ever seen. Not too great English but the message was crystal clear. Well delivered and Thank you for this.

[@CodAffection]

glad you found the video helpful.

[@jontelletxea809]

You are my father! You saved my life! :)

[@vidhyaarumugam341]

Thank for the video ... my job is still there for me bcaz of u people...

[@csrajeshwarrao]

This Post may be 3 years back but it helped me. :) Thank you

[@bunnygirl1615]

thank you so much it solved my biggest problem 1.4K liker congratz

[@CodAffection]

😊

[@barthosouza7328]

Very helpful, nice explanation, thanks a lot

[@TheYosi277]

you recommended to do the SQL class you did as a static class so i wont create a instence of the data base every function?

[@jancsovicsmark3409]

Thank you so much! You helped me a lot! 🙂

[@CodAffection]

Glad I could help!

[@grbsql]

Thank you very much for sharing such excellent work

[@mglx6]

Thanks a lot!! from Chile

[@marrohom5]

Thats great!, I have a doubt, how can I assign an ID to the table generated, I would like to add styles on it with JS... Thanks

[@NassosKranidiotis]

Thank you very much! That was very helpful.

[@phamanh-cy2vb]

how a helpful tutorial, many thanks from Vietnam

[@CodAffection]

you are welcome.

[@kennethmonteroponce8356]

Very Good, thank you, excellent video.

[@CodAffection]

my pleasure. thanks for the comment.

[@manishkumar-mu2if]

sir how to copy string connectionstring = @"?" from sql database table ?

[@CodAffection]

try this : kzbin.info/www/bejne/jXuQdJebiayrppo

[@avaniprajapati2642]

Very easy to contact connection string

[@miguelrivas3781]

You are amazing, thank you for sharing this video!!

[@Spirittism]

In Windows form, there is a cell click that automatically selects all rows, is that possible in asp.net?

[@Joyddep]

Got what i was looking for! Thanks a lot bro :)

[@najjmahamud]

Great Tutorials :-) Tnx

[@kitsabee]

How can I capture this value in the client side javascript?

[@nickpawsey]

This helped a lot! Thanks man

[@acolad_AD]

nice one very helpful.

[@kpeando]

Good video , from chile

[@CodAffection]

Glad you found the video helpful.

[@kpeando]

Thank you

[@siddanatibhargav3070]

hey hello bro in sql we write a qurey like select column1,column2,... tablename where column4=data; it gives the data in table when column is a country name is equal to india then it gives all columns have country is india it gives that data.but how to implement in asp.net i mean when user given a input that input is accepted by the database and give r display the data. how to work with this in asp.net

[@CodAffection]

hope I understood your question. you can stored procedure with parameter. you can see them here : kzbin.info/www/bejne/eaWndmydidygr9E

[@mickeykutti5165]

When I click the design button all columns are displaying like databound databound..... What's the error plz help me

[@tanujgarg792]

it will show databound until the data you want to show has been bonded.

[@saimedianellai]

Thank you so much sir

[@shaznishiraz]

Thank You So much helped me :)

[@CodAffection]

glad you found the video helpful.

[@burhanaditya5072]

Can you do it with innerjoin table sir?

[@CodAffection]

sure, mention column name from join result

[@burhanaditya5072]

Dotnet Mob I still have trouble. When operating a crud with an innerjoin table. Whether the actual innerjoin requires a key relationship? Maybe next time you can explain it?

[@CodAffection]

Yes. SELECT * FROM table as t1 INNER JOIN table as t2 ON t1.Key = t2.Key

[@burhanaditya5072]

Dotnet Mob Can inner join be done by using stored procedure only? I've been doing innerjoin with view options

[@CodAffection]

sure

[@numanduraklar5022]

Thank you man!!!

[@CodAffection]

you are welcome.

[@anzimk1620]

Thankz a alot

[@premsagarshukla1766]

Thanks

[@lalit7000]

thank you... it helped me...

[@susmitahazra1886]

Sir I need a help

[@akhterhussain5842]

I need help

[@Buzca]

Thank you!

[@yousseftiko691]

THAANKS

[@elvingonzalez8932]

Please do the same in a form desktop program with c# .NET only not asp.net please

[@fahadamin7176]

local host reload but grid view not showing #CodAffection

[@TheSclare]

Thank you so much.

[@CodAffection]

My Pleasure.

[@jayantacodingclass]

Gridview to textbox retrieve data -kzbin.info/www/bejne/npa7q3aumbadhZI

[@vrajkuvadiya3233]

speak slowly

[@mickeykutti5165]

Hiii

[@SunShine24024]

👍👍

[@danielriojas9559]

te amo

[@MK-kl4es]

13 protected void Page_Load(object sender, EventArgs e) { table.Columns.Add("1", typeof(int)); table.Columns.Add("2", typeof(string)); table.Columns.Add("3", typeof(string)); table.Columns.Add("3", typeof(string)); table.Columns.Add("4", typeof(string)); table.Columns.Add("5", typeof(string)); table.Columns.Add("6", typeof(string)); string path = Server.MapPath("~/text/people.txt"); string[] dataa = File.ReadAllLines(ppath); foreach (string p in dataa) { string[] kolone = p.Split(';'); table.Rows.Add(kolone); } GridView1.DataSource = table; GridView1.DataBind(); List place = new List(); foreach (string p in dataa) { string[] rows = p.Split(';'); place.Add(rows[6]); } DropDownList1.Items.Add(new ListItem(String.Empty, "-1")); foreach (string m in place) { ListItem item = new ListItem(m); if (!DropDownList1.Items.Contains(item)) { DropDownList1.Items.Add(item); } } } protected void Button1_Click(object sender, EventArgs e) { DataTable temp = table.Copy(); for (int i = 0; i < temp.Rows.Count; i++) { if (!temp.Rows[i][1].ToString().Contains(TextBox1.Text) || !temp.Rows[i][2].ToString().Contains(TextBox2.Text) || !temp.Rows[i][3].ToString().Contains(TextBox3.Text) || !temp.Rows[i][4].ToString().Contains(TextBox4.Text) || !temp.Rows[i][5].ToString().Contains(TextBox5.Text) || !temp.Rows[i][6].ToString().Contains(DropDownList1.SelectedItem.Text)) { temp.Rows.RemoveAt(i); i--; } } GridView1.DataSource = temp; GridView1.DataBind(); }

[@MK-kl4es]

78 protected void insert() { XmlTextReader reader = new XmlTextReader(Server.MapPath("/XMLL/XMLFile1.xml")); DataSet ds = new DataSet(); ds.ReadXml(reader); DataView dv = new DataView(ds.Tables[0]); DataTable dt = dv.Table; dt.DefaultView.Sort = "citano DESC"; dt = dt.DefaultView.ToTable(true); reader.Close(); GridView1.DataSource = dt; GridView1.DataBind(); } SqlConnection con = new SqlConnection(""); protected void btnPosalji_Click(object sender, EventArgs e) { SqlCommand com = new SqlCommand("INSERT INTO table values(@item1, @item2, @item3, @item4)", con); com.Parameters.AddWithValue("@item1", tb1.Text); com.Parameters.AddWithValue("@item2", tb2.Text); com.Parameters.AddWithValue("@item3", tb3.Text); com.Parameters.AddWithValue("@item4", DateTime.Now.ToShortDateString()); con.Open(); com.ExecuteNonQuery(); }

[@MK-kl4es]

15 public void insert() { if (DropDownList1.SelectedIndex > -1) { string pathh= Server.MapPath($"~/TXT/{DropDownList1.SelectedValue}.txt"); string[] liness = File.ReadAllLines(putanja); foreach (string line in liness) { if (line.StartsWith("SMER")) { string smer = line.Remove(0, 5); DropDownList2.Items.Add(smer); } } } } protected void Button1_Click(object sender, EventArgs e) { GridView1.DataSource = null; GridView1.DataBind(); DataSet ds = new DataSet(); ds.Tables.Add(new DataTable()); ds.Tables.Add(new DataTable()); ds.Tables[0].Columns.Add("RBR", typeof(string)); ds.Tables[0].Columns.Add("Polazak", typeof(string)); ds.Tables[1].Columns.Add("RBR", typeof(string)); ds.Tables[1].Columns.Add("Polazak", typeof(string)); if (DropDownList1.SelectedIndex > -1 && DropDownList2.SelectedIndex > -1) { string pathh = Server.MapPath($"~/TXT/{DropDownList1.SelectedValue}.txt"); string[] liness = File.ReadAllLines(pathh); int i = -1, j = 0; foreach (string line in liness) { if (line.StartsWith("SMER")) { i++; j = 0; } else { j++; ds.Tables[i].Rows.Add(j, line); } } if (DropDownList2.SelectedIndex == 0) { GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } else if (DropDownList2.SelectedIndex == 1) { GridView1.DataSource = ds.Tables[1]; GridView1.DataBind(); } }

[@ublweb1279]

Thank you very much! That was very helpful.

[@RamdevDarak]

This helped a lot! Thanks man

[@solankidisha337]

Thank you so much

[@mickeykutti5165]

I need help