i wants to create an dll file for displaying selected data form database by using a gridview.
for this iam creating a dll file , in that how to declare gridview1 ,,,,
here my codeing is given below .....
please correct errors....

Imports System
Imports Microsoft.VisualBasic
Imports System.Web
Namespace mylib
 Public Class gridcalendar                                        'Displays gridcalendar
        Public Function griscal(ByVal dateofarrival As String)
            Dim dateofdeparture As String
            Dim conn As New SqlClient.SqlConnection("server =;address=;network=DBMSSOCN;database=apcms;User ID=sudhaar;Password=sudhaar")
            Dim adp As SqlClient.SqlDataAdapter
            Dim ds As New DataSet
            Dim str As String
            str = "select g.room_no as 'Room No',convert(varchar(11),g.date_of_arr,106) AS 'Arrival Date',convert(varchar(11),g.date_of_dept,106) As 'Departure Date',convert(varchar,datediff(dd,g.date_of_arr,g.date_of_dept)+1 ,100) as 'Days' ,g.status as 'Status', r.total_beds AS 'Beds' from guesthouse g,rooms r WHERE g.status<>'Checkedout' and g.status<>'Cancelled' and month(date_of_arr) between month(CONVERT(datetime,'" & dateofarrival.ToString & "',101)) and month(CONVERT(datetime,'" & dateofdeparture.ToString & "',101))and r.room_no=g.room_no order by g.room_no,g.date_of_arr"
            adp = New SqlClient.SqlDataAdapter(str, conn)
            adp.Fill(ds, "guesthouse")
            GridView1.DataSource = ds
            GridView1.Caption = "BOOKING CALENDAR"
        End Function
    End Class
End Namespace

please help me.....
thank you........