How to delete row from datatable

Question

hi, all I want to delete row which point value = 1 form datatable.

Riya Sehgal · Answer

Hi, Normal 0 false false false EN-US X-NONE X-NONE /* Style Definitions */ table.MsoNormalTable{mso-style-name:"Table Normal";mso-tstyle-rowband-size:0;mso-tstyle-colband-size:0;mso-style-noshow:yes;mso-style-priority:99;mso-style-qformat:yes;mso-style-parent:"";mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-para-margin-top:0in;mso-para-margin-right:0in;mso-para-margin-bottom:10.0pt;mso-para-margin-left:0in;line-height:115%;mso-pagination:widow-orphan;font-size:11.0pt;font-family:"Calibri","sans-serif";mso-ascii-font-family:Calibri;mso-ascii-theme-font:minor-latin;mso-hansi-font-family:Calibri;mso-hansi-theme-font:minor-latin;} You can try with below code. sqlcmd = New SqlCommand("select * from emp", sqlcon) sqlcon.Open() da = New SqlDataAdapter(sqlcmd) dt.Clear() da.Fill(dt) If dt.Rows.Count > 0 Then 'Here i delete "First" row and bind it in grid view dt.Rows(1).Delete() GridView1.DataSource = dt GridView1.DataBind() End If

How to delete row from datatable

Answers (1)