4

how to delare gridview in classlibrary

view full story
linux-howto

http://www.daniweb.com – hi 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 = 10.160.19.104;address=10.160.19.104;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"             GridView1.DataBind()             GridView1.Dispose()         End Function     End Class End Namespacethnx......... please help me..... thank you........ (General)