guys i am getting error: System.ArgumentException: Cannot convert 2012-13 to System.Int32
i am creating 1 webmethod in asmx....in which
deptCode="IT"
deptYear="2012-13"......
here is full webmethod
kindly suggest....
Public Function GetdepartdetailsByDeptCode(ByVal deptCode As String, ByVal deptYear As Integer) As User()
Dim arrUser As User() = Nothing
Dim constr As String
constr = ""
Dim con As New OleDbConnection(constr)
con.Open()
Dim sql As String = ("select Scheme_type ,scheme_name ,total_fund ,Allotment_amt ,expense ,osp ,tsp ,scsp ,GOIALLOT ,GOIRECEPT ,SECTOR ,nature ,status from schemes where department_code='" + deptCode + "' and yr='" + deptYear + "'")
Dim cmd As New OleDbCommand(sql, con)
cmd.CommandType ...
Go to the complete details ...