Deleting rows

When you bring in SQL records onto an .aspx page, is it possible to delete a row off the page (using VB) without deleting the record itself from the SQL table? <img border="0" src="/forum/emoticons/confused.gif" height="22" width="15" alt="confused" />

Yes. The dataset is disconnected record. If u delete the record from dataset then it's temporarily deleted. It wont effect your database record. <br><br>Unless u commit to database, such as using Sqlcommand or use SqlCommandBuilder<br>I am not a VB programmer, so I will show you the C# does.<br><br>1. use sqlcommand<br>SqlConnection con;<br>SqlCommand cmd;<br>string DeleteSQL;<br>DeleteSQL = "DELETE authors WHERE au_id = '123';<br>con = new SqlConnection("Server=localhost;Database=pubs;uid=xxx;pwd=xxx");<br>cmd = new SqlCommand(DeleteSQL, con);<br>con.Open();<br>cmd.ExecuteNonQuery();<br><br>2. SqlCommandBuilder<br>SqlCommandBuilder objCB= New SqlClient.SqlCommandBuilder(yourSQLDataAdapter)<br>yourSQLDataAdapter.Update(yourDataSet)<br><br>Hope this help