data view related query
-
how do i find a record in a multi column table data view in vb.net and how can i move in that view....like move next, move previous etc. as it could be done in the recordset of vb
Hi Anz, Check it http://www.codeproject.com/vb/net/SQLEditor.asp[^] It can Help u See in article 'If the table contains a primary key, use that to find the record. For i As Integer = dca.GetLowerBound(0) To dca.GetUpperBound(0) dv.RowFilter = "COLUMN_NAME = '" & dca(i).ColumnName & "'" sSQLDataType = dv(0)("TYPE_NAME").ToString() If sSQLDataType.Equals("text") Or _ sSQLDataType.Equals("ntext") Or _ sSQLDataType.Equals("image") Then sTmp = "[" + dca(i).ColumnName + "] LIKE @" + _ RemoveIllegalChars(dca(i).ColumnName, _ m_RemoveChars) Else sTmp = "[" + dca(i).ColumnName + "] = @" + _ RemoveIllegalChars(dca(i).ColumnName, _ m_RemoveChars) End If If dca.GetLength(0) > 1 Then sSQL = sSQL + "(" + sTmp + ")" Else sSQL = sSQL + sTmp End If If i <> dca.GetUpperBound(0) Then sSQL = sSQL + " AND " Next
Pankaj Jain