or
<telerik:RadDatePicker runat="server" Width="140px" DateInput-EmptyMessage="mm/dd/yyyy" MinDate="2000-01-01"></telerik:RadDatePicker><%@ Page Language="VB" %><%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %><!DOCTYPE html><script runat="server"> Protected Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load If Page.IsPostBack = False Then MultiPage.PageViews(0).Selected = True End If End Sub Protected Sub NextButton_Click(sender As Object, e As EventArgs) Handles NextButton.Click Dim TabIndex As Integer = 0 If TabIndexLabel.Text = 0 Then TabIndex = 1 End If TabIndexLabel.Text = TabIndex MultiPage.PageViews(TabIndex).Selected = True End Sub</script><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title></title></head><body> <form id="form1" runat="server"> <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> </telerik:RadScriptManager> <asp:Label ID="TabIndexLabel" runat="server" Text="0" Visible="false"></asp:Label> <telerik:RadSplitter ID="RadSplitter1" runat="server"> <telerik:RadPane ID="RadPane1" runat="server" Scrolling="None" Width="100px"> <asp:Button ID="NextButton" runat="server" Text="Next Tab" /> </telerik:RadPane> <telerik:RadPane ID="RadPane2" runat="server" Scrolling="None"> <telerik:RadMultiPage ID="MultiPage" runat="server"> <telerik:RadPageView ID="PV0" runat="server"> <telerik:RadSplitter ID="Splitter0" runat="server"> <telerik:RadPane ID="RadPane7" runat="server"> </telerik:RadPane> <telerik:RadPane ID="RadPane8" runat="server"> </telerik:RadPane> </telerik:RadSplitter> </telerik:RadPageView> <telerik:RadPageView ID="PV1" runat="server"> <telerik:RadSplitter ID="Splitter1" runat="server"> <telerik:RadPane ID="RadPane13" runat="server"> </telerik:RadPane> <telerik:RadPane ID="RadPane14" runat="server"> </telerik:RadPane> </telerik:RadSplitter> </telerik:RadPageView> </telerik:RadMultiPage> </telerik:RadPane> </telerik:RadSplitter> </form></body></html>I have a situation where where I need to only fired the needDatasource on a boolean statment. It works fine for what I am doing to load the page on a querystring value. Where the grid hiccups is when I try to use the Radgrid insert, the grid disappears becuase of the boolean statment, how can I set this statement when I postback to get at my template to insert data.
Dim fillGridNotes As Boolean = False Dim fillGridEmer As Boolean = False Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load If Not IsPostBack Then Dim rspId As String = Request.QueryString("RSP") If rspId = String.Empty Then 'Send to another page Else Dim userlogon As String = Split(Current.User.Identity.Name, "\")(1) HFUserId.Value = GetPersId(userlogon) HFRecruitId.Value = rspId LoadRSP(rspId) fillGridNotes = True End If End If End SubThis is where I cannot ge thte grid to open to allow me to fill out the form and then postback to fill the grid. Protected Sub myRadNotes_ItemCommand(sender As Object, e As Telerik.Web.UI.GridCommandEventArgs) Handles myRadNotes.ItemCommand If (e.CommandName = RadGrid.PerformInsertCommandName) Then fillGridNotes = True Dim editedItem As GridEditableItem = CType(e.Item, GridEditableItem) Dim notes As TextBox = DirectCast(editedItem.FindControl("txtNotes"), TextBox) Dim rspId As Integer = 16533 sql = "Insert tblRSPNotes (intRSPId, dtRSpNotesDateEntered, strRSPNotesDesc, intLoggedBy) VALUES (" & rspId & ", '" & Date.Now & "', '" & sanitizeString(notes.Text) & "', " & HFUserId.Value & ")" insertUpdateDelete(sql) myRadNotes.Rebind() End If End Sub Protected Sub myRadNotes_NeedDataSource(sender As Object, e As Telerik.Web.UI.GridNeedDataSourceEventArgs) Handles myRadNotes.NeedDataSource 'Load the Notes Grid If fillGridNotes = True Then sql = "Select intRspNotesId, CONVERT(varchar(10), dtRSPNotesDateEntered, 111) dtNotes, strRSPNotesDesc, mn.strFullname + ' ' + ISNULL(' ' + strRank, '') LoggedBy from tblRSPNotes n LEFT JOIN MNNGPersonnel..tblMNNatPersonnel mn on " _ & "mn.intPersonnelId = n.intLoggedBy where intRSPID in (Select intRSpId from tblRSp where intRecruitId = " & HFRecruitId.Value & ") Order by dtRSPNotesDateEntered DESC" myRadNotes.DataSource = getReader(sql) End If End Sub

Conversion failed when converting the nvarchar value 'ج' to data type int