Overlooking internal security is a big mistake. Attacks can come from within, as well, and it does happen. If you want to use FTP you will either need to implement it yourself or use a free or commercial library. My other suggestions are still viable. This posting is provided "AS IS" with no warranties, and confers no rights. Software Design Engineer Developer Division Sustained Engineering Microsoft [My Articles] [My Blog]

You can set the RowFilter of the Datagrid in the ComboBox SelectedIndexChanged event. Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged 'ur selected order no m_orderNo = Integer.Parse(CType(ComboBox1.SelectedValue, String) CType(DataGrid1.DataSource, DataTable).DefaultView.RowFilter = "orderno = " + m_orderNo.ToString() End Sub

well, first of all I dont have rights to access a server machine where the sql server database is... so i have to go to thru this machine here they have set ms access project... and secondly this is what a client has requested to do... I can ask him if it is not at all possible to connect to sql server via access project in vb .net