INTERVIEW QUESTIONS MICROSOFT VB.NET DETAILS

Question: Sir my name is riyaz and my question is Object class in VB.net supports all classes in .net frameworks
iam creating DLL where i created a function

Public Sub BindListControl( ByVal Lst As Listbox, ByVal sql As String, ByVal TextField As String, Optional ByVal ValueFld As String = "")
Dim ds As New DataSet
Dim Ad As New SqlDataAdapter
Dim Cmd As New SqlCommand

Try
If cnn2.State = ConnectionState. Closed Then OpenConnection2( )

With Cmd
.Connection = cnn2
.CommandType = CommandType. Text
.CommandText = sql
End With
Ad = New SqlDataAdapter( Cmd)
Ad.Fill(ds, "tmp")
Lst.DataTextField = TextField
If ValueFld <> "" Then
Lst.DataValueField = ValueFld
End If
Lst.DataSource = ds
Lst.DataBind( )

Catch ex As Exception
Current.Response. Write(ex. Message)
Finally
ds.Dispose()
Ad.Dispose()
Cmd.Dispose( )
'cnn2.Close( )
End Try
End Sub
------------ --------- --------- --------- --------- --------- -
and Then i replaced function with Object
------------ --------- --------- --------- --------- --------- -

Public Sub BindListControl( ByVal Lst As Object, ByVal sql As String, ByVal TextField As String, Optional ByVal ValueFld As String = "")
Dim ds As New DataSet
Dim Ad As New SqlDataAdapter
Dim Cmd As New SqlCommand

Try
If cnn2.State = ConnectionState. Closed Then OpenConnection2( )

With Cmd
.Connection = cnn2
.CommandType = CommandType. Text
.CommandText = sql
End With
Ad = New SqlDataAdapter( Cmd)
Ad.Fill(ds, "tmp")
Lst.DataTextField = TextField
If ValueFld <> "" Then
Lst.DataValueField = ValueFld
End If
Lst.DataSource = ds
Lst.DataBind( )

Catch ex As Exception
Current.Response. Write(ex. Message)
Finally
ds.Dispose()
Ad.Dispose()
Cmd.Dispose( )
'cnn2.Close( )
End Try
End Sub
------------ --------- --------- --------- --------- --------- -
It will sucessfully work but if do it in c# as

public void BindListBox( ListBox Lst, string sqlquery, string TextField, string value)
{
//ListBox Lst;
//Lst = (ListBox)sender;
SqlConnection con = new SqlConnection( );
con.ConnectionStrin g = cnnstring;
con.Open();
if (con.State.ToString () == "Open")
{
SqlDataAdapter adapater = new SqlDataAdapter( sqlquery, con);
DataSet Ds = new DataSet();
SqlCommandBuilder cmd = new SqlCommandBuilder( adapater) ;
try
{

adapater.Fill( Ds, "temp");
Lst.DataTextField = TextField;
if (value != null)
{
Lst.DataValueField = value;
}
Lst.DataSource = Ds;
Lst.DataBind( );


}

catch (Exception ex)
{
Response.Write( ex.Message. ToString( ));
}
finally
{
con.Close();
adapater.Dispose( );
cmd.Dispose( );
}

}
else
{
Response.Write( "Connection Not Available");
}
}
--------------------------------------
It will work with ListBox control
-----------------------------------
if i replace ListBox with Object it will through Error that object does not contain defination for DataTextField, DataSource, DataBind( )
so sir it will work in vb.net why not in c# is any alternate way to do this or any other syntax
please send me response as earily as possible
Thank u sir

Answer: No answer available currently.