Asp.Net Gridview : Bind Database Table

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.
📂 GitHub Repository
► goo.gl/z4nwbc
💖 Buy me a Coffee
➤ bit.ly/3L36ut4 (PayPal)
➤ bit.ly/3VF0iPT (Razorpay)
🌀 Related Videos
goo.gl/oxDoDK : Asp.Net - Insert Update Delete
goo.gl/qshuJk : Complete Asp.net Tutorial
goo.gl/TUhsm5 : Asp.net Login Page
goo.gl/ySUFf8 : Similar Mvc Tutorials
goo.gl/3ajHuA : Similar C# Video Tutorials
goo.gl/yHZcCo : Build Complete Asp.Net MVC App
goo.gl/ZXKqT9 : jQuery Ajax in Asp.net MVC
🔗 Find me in
Udemy : bit.ly/3RtyQSB
Facebook : / codaffection
GitHub : github.com/codaffection
Discord : / discord
Twitter : / codaffection
#AspNet #CodAffection

[@CodAffection]

goo.gl/RFY5C2 : Subscribe to CodAffection goo.gl/oxDoDK : Asp.Net CRUD Operations goo.gl/sdqHqu : Asp.Net Login Page goo.gl/UoNfs4 : Asp.Net Grid Inline CRUD

[@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.

[@csrajeshwarrao]

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

[@Joyddep]

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

[@NassosKranidiotis]

Thank you very much! That was very helpful.

[@nickpawsey]

This helped a lot! Thanks man

[@mglx6]

Thanks a lot!! from Chile

[@najarmahamud]

Great Tutorials :-) Tnx

[@miguelrivas3781]

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

[@lalit7000]

thank you... it helped me...

[@grbsql]

Thank you very much for sharing such excellent work

[@barthosouza7328]

Very helpful, nice explanation, thanks a lot

[@Buzca]

Thank you!

[@solankidisha337]

Thank you so much

[@phamanh-cy2vb]

how a helpful tutorial, many thanks from Vietnam

[@CodAffection]

you are welcome.

[@acolad_AD]

nice one very helpful.

[@numanduraklar5022]

Thank you man!!!

[@CodAffection]

you are welcome.

[@yousseftiko691]

THAANKS

[@shaznishiraz]

Thank You So much helped me :)

[@CodAffection]

glad you found the video helpful.

[@kennethmonteroponce8356]

Very Good, thank you, excellent video.

[@CodAffection]

my pleasure. thanks for the comment.

[@saimedianellai]

Thank you so much sir

[@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...

[@TheSclare]

Thank you so much.

[@CodAffection]

My Pleasure.

[@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

[@jancsovicsmark3409]

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

[@CodAffection]

Glad I could help!

[@premsagarshukla1766]

Thanks

[@anzimk1620]

Thankz a alot

[@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?

[@Spirittism]

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

[@kpeando]

Good video , from chile

[@CodAffection]

Glad you found the video helpful.

[@kpeando]

Thank you

[@kitsabee]

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

[@bunnygirl1615]

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

[@CodAffection]

😊

[@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

[@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

[@SunShine24024]

👍👍

[@akhterhussain5842]

I need help

[@elvingonzalez8932]

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

[@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.

[@fahadamin7176]

local host reload but grid view not showing #CodAffection

[@susmitahazra1886]

Sir I need a help

[@danielriojas9559]

te amo

[@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

[@mickeykutti5165]

Hiii

[@jayantacodingclass]

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

[@vrajkuvadiya3233]

speak slowly

[@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(); } }

[@RamdevDarak]

This helped a lot! Thanks man

[@ublweb1279]

Thank you very much! That was very helpful.

[@mickeykutti5165]

I need help