Asp.Net Gridview : Bind Database Table

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

[@mglx6]

Thanks a lot!! from Chile

[@bunnygirl1615]

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

[@CodAffection]

😊

[@barthosouza7328]

Very helpful, nice explanation, thanks a lot

[@jancsovicsmark3409]

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

[@CodAffection]

Glad I could help!

[@ublweb1279]

Thank you very much! That was very helpful.

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

[@grbsql]

Thank you very much for sharing such excellent work

[@RamdevDarak]

This helped a lot! Thanks man

[@kennethmonteroponce8356]

Very Good, thank you, excellent video.

[@CodAffection]

my pleasure. thanks for the comment.

[@miguelrivas3781]

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

[@acolad_AD]

nice one very helpful.

[@phamanh-cy2vb]

how a helpful tutorial, many thanks from Vietnam

[@CodAffection]

you are welcome.

[@najarmahamud]

Great Tutorials :-) Tnx

[@kpeando]

Good video , from chile

[@CodAffection]

Glad you found the video helpful.

[@kpeando]

Thank you

[@Joyddep]

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

[@anzimk1620]

Thankz a alot

[@numanduraklar5022]

Thank you man!!!

[@CodAffection]

you are welcome.

[@premsagarshukla1766]

Thanks

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

[@yousseftiko691]

THAANKS

[@saimedianellai]

Thank you so much sir

[@Buzca]

Thank you!

[@shaznishiraz]

Thank You So much helped me :)

[@CodAffection]

glad you found the video helpful.

[@solankidisha337]

Thank you so much

[@lalit7000]

thank you... it helped me...

[@Spirittism]

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

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

[@kitsabee]

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

[@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 : ruclips.net/video/CtDE9gTwmyo/видео.html

[@manishkumar-mu2if]

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

[@CodAffection]

try this : ruclips.net/video/WJ-CdeTGxp8/видео.html

[@avaniprajapati2642]

Very easy to contact connection string

[@jayantacodingclass]

Gridview to textbox retrieve data -ruclips.net/video/heXzCxdQjO0/видео.html

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

[@elvingonzalez8932]

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

[@susmitahazra1886]

Sir I need a help

[@fahadamin7176]

local host reload but grid view not showing #CodAffection

[@mickeykutti5165]

I need help

[@SunShine24024]

👍👍

[@mickeykutti5165]

Hiii

[@vrajkuvadiya3233]

speak slowly

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

[@NassosKranidiotis]

Thank you very much! That was very helpful.

[@nickpawsey]

This helped a lot! Thanks man

[@TheSclare]

Thank you so much.

[@CodAffection]

My Pleasure.

[@akhterhussain5842]

I need help