Questions on UI for ASP.NET AJAX Forum

0 answers

56 views

Popup Edit Form in RadGrid with CheckBoxList

Hi Guys,
I'm not sure anybody have had this issue.
Using Popup Edit Form in RadGrid with CheckBoxList ,I want for all those selected CheckBoxes in CheckBoxlist (for each one)Run a Strored procedure which has been binded to ObjectDataSource.
I don't know how???
Thanks,
:)

General Discussions

asked on 18 Mar 2011

5 answers

145 views

Duplicate ClientIds with EnableAutomaticLoadOnDemand

Hi All,

I have created a custom template which contains a checkbox and a label for the RadComboBox multi select capability. When I enable AutomaticLoadOnDemand property to true, for the first request the markup is generated for first 10 items and for consecutive requests the checkbox client id's are same as the checkboxes that were requested for the first time. Is there anyway I can maintain the different id's for checkbox controls?

Thanks in advance!!!

ComboBox

answered on 18 Mar 2011

0 answers

78 views

Refresh Grid on Window Close. Again :(

I have accomplished this many times before. For some reason I just can't get this working. The main difference is that I am binding the grid from a datatable and not a sqldatasource. Can someone look at this with fresh eyes? Thanks.

Parent Page ASPX:

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="user_lookup_site.aspx.vb" Inherits="_Default" %>

<%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head id="Head1" runat="server">

<title>Aeries Global System Manager</title>

<link rel="stylesheet" type="text/css" href="~/includes/ITC_Main.css" />

<telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">

<script type="text/javascript">

function refreshGrid(arg) {

if (!arg) {

$find("<%= RadAjaxManager1.ClientID %>").ajaxRequest("Rebind");

}

else {

$find("<%= RadAjaxManager1.ClientID %>").ajaxRequest("RebindAndNavigate");

}

</script>

</telerik:RadCodeBlock>

</head>

<body>

<form id="form1" runat="server">

<div id="header">

<table cellpadding="0" cellspacing="0" style="width: 100%; height: 40px;">

<tr>

<td style="width: 200px; vertical-align: middle; text-align: center;">

<img alt="" src="../../images/aalogo.gif" style="width: 169px; height: 35px" /></td>

<td style="text-align: center;">

<datelbl:ShowDate ID="ShowDate1" runat="server" />

</td>

<td style="width: 300px; text-align: center;">

<table cellpadding="2" cellspacing="0"

style="width: 292px; height: 40px; background-image: url('../../images/headerinset.gif'); text-align: center;">

<tr>

<td style="font-weight: bold; font-size: small; font-family: Arial, Helvetica, sans-serif; color: #00B000; text-align: center;">

Logged in as:

<asp:LoginName ID="LoginName1" runat="server" Font-Names="Arial"

Font-Size="Small" ForeColor="#597791"

meta:resourcekey="LoginName1Resource1" />

<asp:LoginStatus ID="LoginStatus1" runat="server" CssClass="login"

meta:resourcekey="LoginStatus1Resource1" />

</td>

</tr>

</table></td>

<td style="text-align: center; vertical-align: middle; width: 175px;">

<img alt="" src="../../images/aatusdlogo.gif" style="width: 152px; height: 36px" /></td>

</tr>

</table>

</div>

<div id="subheader">

</div>

<div>

<table cellpadding="0" cellspacing="0" style="width: 100%">

<tr>

<td style=

"width: 250px; background-image: url('../../images/menuback.gif'); background-color: #E6E6E6; border-bottom-style: solid; border-bottom-width: thin; border-bottom-color: #000000;"

valign="top">

<telerik:RadPanelBar ID="rpb_AA_Menu" Runat="server" DataFieldID="DataFieldID"

DataFieldParentID="DataFieldParentID"

DataNavigateUrlField="DataNavigateUrlField" DataSourceID="sds_AA_Menu"

DataTextField="DataTextField" DataValueField="DataTextField" Width="250px"

PersistStateInCookie="True" Skin="Office2007">

<DataBindings>

<telerik:RadPanelItemBinding SelectedImageUrlField="ImageURL"

ExpandedImageUrlField="ImageURL" HoveredImageUrlField="ImageURL"

ImageUrlField="ImageURL" />

<telerik:RadPanelItemBinding ImageUrlField="ImageURL" />

</DataBindings>

</telerik:RadPanelBar>

</td>

<td valign="top"

style="background-color: #FFFFFF; border-bottom-style: solid; border-bottom-width: thin; border-bottom-color: #000000;">

<table cellpadding="0" cellspacing="0" style="width: 100%">

<tr>

<td style="padding: 10px">

<h1>

ABI

User Manager - User Lookup by Site</h1>

<h2>

Database</h2>

<telerik:RadComboBox ID="rcb_Database" Runat="server"

DataSourceID="sds_Database" DataTextField="DatabaseName"

DataValueField="DatabaseName" AppendDataBoundItems="True">

<Items>

<telerik:RadComboBoxItem Value = "" Text="Select" />

</Items>

</telerik:RadComboBox>

<h2>

Site </h2>

<telerik:RadComboBox ID="rcb_Site" Runat="server"

DataSourceID="sds_Site" DataTextField="Name"

DataValueField="IDSite" AppendDataBoundItems="True"

AutoPostBack="True" Height="300px" Width="250px">

<Items>

<telerik:RadComboBoxItem Value = "" Text="Select" />

</Items>

</telerik:RadComboBox>

<table cellpadding="0" cellspacing="0" style="width: 100%">

<tr>

<td>

</td>

</tr>

<tr>

<td>

</td>

</tr>

</table>

<telerik:RadGrid ID="rgd_ABIUser" runat="server" GridLines="None" AutoGenerateColumns="False" Width="700px">

<MasterTableView DataKeyNames="ID">

<CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings>

<RowIndicatorColumn>

<HeaderStyle Width="20px"></HeaderStyle>

</RowIndicatorColumn>

<ExpandCollapseColumn>

<HeaderStyle Width="20px"></HeaderStyle>

</ExpandCollapseColumn>

<Columns>

<telerik:GridBoundColumn DataField="SC" HeaderText="Site"

SortExpression="SC" UniqueName="SC" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ID" HeaderText="User"

SortExpression="ID" UniqueName="ID" HeaderStyle-HorizontalAlign="Center" ItemStyle-Width="175px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="PW" HeaderText="Password"

SortExpression="PW" UniqueName="PW" HeaderStyle-HorizontalAlign="Center" ItemStyle-Width="175px">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SN" HeaderText="TCH#"

SortExpression="SN" UniqueName="SN" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="TG" HeaderText="Group"

SortExpression="TG" UniqueName="TG" ItemStyle-HorizontalAlign="Center" HeaderStyle-HorizontalAlign="Center">

</telerik:GridBoundColumn>

<telerik:GridTemplateColumn UniqueName="TemplateColumn">

<ItemTemplate>

<asp:Button ID="btn_ModifyPerms" runat="server" Text="Modify" onclick="btn_ModifyABIUser_Click" />

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

<p>

</p>

<p>

</p>

</td>

</tr>

</table>

</td>

</tr>

</table>

</div>

<div id="footer">

</div>

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" OnAjaxRequest="RadAjaxManager1_AjaxRequest">

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="RadAjaxManager1">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="rgd_ABIUser" />

</UpdatedControls>

</telerik:AjaxSetting>

<telerik:AjaxSetting AjaxControlID="rgd_ABIUser">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="rgd_ABIUser" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManager>

<asp:SqlDataSource ID="sds_AA_Menu" runat="server"

ConnectionString="<%$ ConnectionStrings:AeriesAdmin_ConnectionString %>"

SelectCommand="SELECT [DataFieldID], [DataFieldParentID], [DataTextField], [DataNavigateUrlField], [ImageURL], [UserLevel] FROM [AA_Menu] WHERE ([UserLevel] LIKE '%' + @UserLevel + '%')">

<SelectParameters>

<asp:SessionParameter Name="UserLevel" SessionField="RoleName" Type="String" />

</SelectParameters>

</asp:SqlDataSource>

<telerik:RadScriptManager ID="rsm_AeriesAdmin" Runat="server">

</telerik:RadScriptManager>

<telerik:RadFormDecorator ID="rfd_AeriesAdmin" Runat="server" Skin="WebBlue" />

<asp:SqlDataSource ID="sds_Database" runat="server"

ConnectionString="<%$ ConnectionStrings:AeriesAdmin_ConnectionString %>"

SelectCommand="SELECT DISTINCT [DatabaseName] FROM [vw_AA_Databases] ORDER BY [DatabaseName]"></asp:SqlDataSource>

<asp:SqlDataSource ID="sds_Site" runat="server"

ConnectionString="<%$ ConnectionStrings:AeriesAdmin_ConnectionString %>"

SelectCommand="SELECT [IDSite], [Name] FROM [vw_ITC_Sites] ORDER BY [Name]">

</asp:SqlDataSource>

<br />

</form>

</body>

</html>

Parent Page VB

Imports System.Data

Imports System.Data.SqlClient

Imports Telerik.Web.UI

Imports System.CodeDom

Imports System.Web

Imports System.Web.Security

Imports System.Web.Security.Roles

Imports System.Web.Security.Membership

Imports System.Security

Imports System.Security.Principal.WindowsIdentity

Imports System.Drawing

Imports System.Threading

Partial Class _Default

Inherits System.Web.UI.Page

'Protected Sub RadPanelBar1_DataBound1(ByVal sender As Object, ByVal e As System.EventArgs) Handles rpb_AA_Menu.DataBound

' rpb_AA_Menu.Items(0).Expanded = True

' rpb_AA_Menu.Items(1).Expanded = True

'End Sub

'Protected Sub Page_PreLoad(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.PreLoad

' Dim ActiveDirID As String = "ActiveDirID"

'    Dim connectionString As String = DirectCast(ConfigurationManager.ConnectionStrings("AeriesAdmin_ConnectionString").ConnectionString, String)

'    Dim queryString As String = "SELECT ActiveDirID, RoleName, FullName, UserName FROM vw_ADSI WHERE UserName = @UserName"

' Using myConnection As New SqlConnection(connectionString)

' Dim myCommand As New SqlCommand(queryString, myConnection)

' myConnection.Open()

' myCommand.Parameters.AddWithValue("@UserName", User.Identity.Name)

' Dim MyReader As SqlDataReader = myCommand.ExecuteReader

' MyReader.Read()

' Session("UserName") = MyReader("UserName")

' Session("ActiveDirID") = MyReader("ActiveDirID")

' Session("RoleName") = MyReader("RoleName")

' myConnection.Close()

' End Using

' End Sub

'**********************************************************************

'Format combo boxes

'**********************************************************************

Protected Sub rcb_Site_SelectedIndexChanged(o As Object, e As Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs) Handles rcb_Site.SelectedIndexChanged

rgd_ABIUser.DataSource = GetUser()

rgd_ABIUser.DataBind()

End Sub

Private Function GetUser() As DataTable

Dim DatabaseName As String = rcb_Database.SelectedValue

Dim SC As String = rcb_Site.SelectedValue

Dim connectionString = New SqlConnection("server=DO-IT-AB\MSSQLAB;database=AeriesAdmin;UID=XXX;PWD=XXX;")

Dim command = New SqlCommand("aa_abi_users_by_site", connectionString)

command.CommandType = CommandType.StoredProcedure

command.Parameters.Add("@DBName", SqlDbType.VarChar).Value = DatabaseName

command.Parameters.Add("@SC", SqlDbType.VarChar).Value = SC

command.Connection.Open()

Dim myDataAdapter As New SqlDataAdapter(command)

Dim myDataSet As New DataSet

Dim dtData As New DataTable

myDataAdapter.Fill(myDataSet)

Return myDataSet.Tables(0)

command.Connection.Close()

End Function

Protected Sub btn_ModifyABIUser_Click(sender As Object, e As System.EventArgs)

Dim ID_item As GridDataItem = DirectCast(TryCast(sender, Button).NamingContainer, GridDataItem)

Dim ID As String = ID_item.OwnerTableView.DataKeyValues(ID_item.ItemIndex)("ID")

Session("ID") = ID

Session("DataBase") = rcb_Database.SelectedValue

Session("Site") = rcb_Site.SelectedValue

Dim windowManager As New RadWindowManager()

Dim RadWindow As New RadWindow()

RadWindow.NavigateUrl = "user_mod_modal.aspx"

RadWindow.ID = "RadWindow1"

RadWindow.VisibleOnPageLoad = True

RadWindow.Height = 375

RadWindow.Width = 550

RadWindow.Modal = True

windowManager.Windows.Add(RadWindow)

Me.form1.Controls.Add(RadWindow)

End Sub

Protected Sub RadAjaxManager1_AjaxRequest(ByVal sender As Object, ByVal e As Telerik.Web.UI.AjaxRequestEventArgs) Handles RadAjaxManager1.AjaxRequest

If e.Argument = "Rebind" Then

rgd_ABIUser.MasterTableView.SortExpressions.Clear()

rgd_ABIUser.MasterTableView.GroupByExpressions.Clear()

rgd_ABIUser.DataSource = GetUser()

rgd_ABIUser.Rebind()

ElseIf e.Argument = "RebindAndNavigate" Then

rgd_ABIUser.MasterTableView.SortExpressions.Clear()

rgd_ABIUser.MasterTableView.GroupByExpressions.Clear()

rgd_ABIUser.MasterTableView.CurrentPageIndex = rgd_ABIUser.MasterTableView.PageCount - 1

rgd_ABIUser.DataSource = GetUser()

rgd_ABIUser.Rebind()

End If

End Sub

End Class

Modal form ASPX

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="user_mod_modal.aspx.vb" Inherits="_Default" EnableEventValidation="false" %>

<%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head id="Head1" runat="server">

<title>Aeries Global System Manager</title>

<link rel="stylesheet" type="text/css" href="~/includes/ITC_Main.css" />

<telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">

<script type="text/javascript">

function CloseAndRebind(args) {

GetRadWindow().BrowserWindow.refreshGrid(args);

GetRadWindow().close();

}

function GetRadWindow() {

var oWindow = null;

if (window.radWindow) oWindow = window.radWindow; //Will work in Moz in all cases, including clasic dialog

else if (window.frameElement.radWindow) oWindow = window.frameElement.radWindow; //IE (and Moz as well)

return oWindow;

}

function CancelEdit() {

GetRadWindow().close();

}

</script>

</telerik:RadCodeBlock>

</head>

<body>

<form id="form1" runat="server">

<div id="header">

<table cellpadding="0" cellspacing="0" style="width: 100%; height: 40px;">

<tr>

<td style="width: 213px">

<img alt="" src="../../images/aalogo.gif" /></td>

<td style="text-align: right">

<img alt="" src="../../images/aatusdlogo.gif" /></td>

</tr>

</table>

</div>

<div id="subheader">

</div>

<div>

<table cellpadding="0" cellspacing="0" style="width: 100%">

<tr>

<td valign="top"

style="background-color: #FFFFFF; border-bottom-style: solid; border-bottom-width: thin; border-bottom-color: #000000;">

<table cellpadding="0" cellspacing="0" style="width: 100%">

<tr>

<td style="padding: 10px">

<table align="center" cellpadding="0" cellspacing="0">

<tr>

<td style="font-size: large; font-weight: bold; color: #7698BA; text-align: center">

Modify ABI User Details</td>

</tr>

<tr>

<td>

<asp:Label ID="Label1" runat="server" Text="Label"

style="color: #FFFFFF"></asp:Label>

</td>

</tr>

<tr>

<td>

<telerik:RadGrid ID="rgd_ABIUser" runat="server" GridLines="None" AutoGenerateColumns="False" Width="400px">

<MasterTableView DataKeyNames="ID">

<RowIndicatorColumn>

<HeaderStyle Width="20px"></HeaderStyle>

</RowIndicatorColumn>

<ExpandCollapseColumn>

<HeaderStyle Width="20px"></HeaderStyle>

</ExpandCollapseColumn>

<Columns>

<telerik:GridTemplateColumn DataField="SC" HeaderText="Site" SortExpression="SC" UniqueName="SC">

<ItemTemplate>

<asp:Label ID="Label2" runat="server" Text='<%# Bind("SC") %>'></asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="ID" HeaderText="User" SortExpression="ID" UniqueName="ID">

<ItemTemplate>

<asp:Label ID="Label3" runat="server" Text='<%# Bind("ID") %>'></asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="PW" HeaderText="Password" SortExpression="PW" UniqueName="PW">

<ItemTemplate>

<asp:TextBox ID="tbx_Password" Text='<%# Bind("PW") %>' runat="server"></asp:TextBox>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="SN" HeaderText="TCH#" SortExpression="SN" UniqueName="SN" >

<ItemTemplate>

<asp:TextBox ID="tbx_TchNo" Text='<%# Bind("SN") %>' runat="server" style="text-align:center;" Width="30px"></asp:TextBox>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="TG" HeaderText="Group" SortExpression="TG" UniqueName="TG">

<ItemTemplate>

<asp:TextBox ID="tbx_TG" Text='<%# Bind("TG") %>' runat="server" style="text-align:center;" Width="20px"></asp:TextBox>

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

</td>

</tr>

<tr>

<td style="text-align: center">

<asp:Button ID="btn_UpdateUser" OnClick="btn_UpdateUser_Click" runat="server" Text="Update" />

</td>

</tr>

</table>

<br />

</td>

</tr>

</table>

</td>

</tr>

</table>

</div>

<div id="footer">

</div>

<telerik:RadScriptManager ID="rsm_AeriesAdmin" Runat="server">

</telerik:RadScriptManager>

<br />

</form>

</body>

</html>

Modal form VB

Imports System.Data

Imports System.Data.SqlClient

Imports Telerik.Web.UI

Imports System.CodeDom

Imports System.Web

Imports System.Web.Security

Imports System.Web.Security.Roles

Imports System.Web.Security.Membership

Imports System.Security

Imports System.Security.Principal.WindowsIdentity

Partial Class _Default

Inherits System.Web.UI.Page

Protected Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load

If Not Page.IsPostBack Then

rgd_ABIUser.DataSource = GetUser()

rgd_ABIUser.DataBind()

End If

End Sub

Private Function GetUser() As DataTable

Dim DatabaseName = Session("DataBase")

Dim Site = Session("Site")

Dim IDUser As String = Session("ID")

Dim connectionString = New SqlConnection("server=DO-IT-AB\MSSQLAB;database=AeriesAdmin;UID=XXX;PWD=XXX;")

Dim command = New SqlCommand("aa_abi_users_by_id", connectionString)

command.CommandType = CommandType.StoredProcedure

command.Parameters.Add("@DBName", SqlDbType.VarChar).Value = DatabaseName

command.Parameters.Add("@ID", SqlDbType.VarChar).Value = IDUser

command.Connection.Open()

Dim myDataAdapter As New SqlDataAdapter(command)

Dim myDataSet As New DataSet

Dim dtData As New DataTable

myDataAdapter.Fill(myDataSet)

Return myDataSet.Tables(0)

command.Connection.Close()

End Function

Protected Sub btn_UpdateUser_Click(ByVal sender As Object, ByVal e As System.EventArgs)

For Each item As GridDataItem In rgd_ABIUser.MasterTableView.Items

Dim tbx_Password As TextBox = DirectCast(item("PW").FindControl("tbx_Password"), TextBox)

Dim PW As String = tbx_Password.Text

Dim tbx_TchNo As TextBox = DirectCast(item("SN").FindControl("tbx_TchNo"), TextBox)

Dim SN As String = tbx_TchNo.Text

Dim tbx_TG As TextBox = DirectCast(item("TG").FindControl("tbx_TG"), TextBox)

Dim TG As String = tbx_TG.Text

Dim DatabaseName As String = Session("DataBase")

Dim Val = Session("Site")

Dim Site As Integer = Convert.ToInt32(Val)

Dim IDUser As String = Session("ID")

Dim connectionString = New SqlConnection("server=DO-IT-AB\MSSQLAB;database=AeriesAdmin;UID=XXX;PWD=XXX;")

Dim command = New SqlCommand("aa_abi_users_update", connectionString)

command.CommandType = CommandType.StoredProcedure

command.Parameters.Add("@DBName", SqlDbType.VarChar).Value = DatabaseName

command.Parameters.Add("@IDSite", SqlDbType.Int).Value = Site

command.Parameters.Add("@IDUser", SqlDbType.VarChar).Value = IDUser

command.Parameters.Add("@PW", SqlDbType.VarChar).Value = PW

command.Parameters.Add("@SN", SqlDbType.VarChar).Value = SN

command.Parameters.Add("@TG", SqlDbType.VarChar).Value = TG

command.Connection.Open()

command.ExecuteNonQuery()

command.Connection.Close()

Next

If Session("DataBase") IsNot Nothing Then

Session.Remove("DataBase")

End If

If Session("Site") IsNot Nothing Then

Session.Remove("Site")

End If

If Session("IDUser") IsNot Nothing Then

Session.Remove("IDUser")

End If

Label1.Text = "<script type='text/javascript'>CloseAndRebind()</" + "script>"

End Sub

End Class

Grid

asked on 18 Mar 2011

4 answers

232 views

Find Control external button click event

I would like to get the value of a textbox in a GridTemplateColumn. I have tried and tried to find an answer to this question. Please DO NOT refer me to any of the following:

http://www.telerik.com/help/aspnet-ajax/grdaccessingcellsandrows.html

http://demos.telerik.com/aspnet-ajax/grid/examples/programming/accessingcellsandrows/defaultcs.aspx

http://www.telerik.com/community/forums/aspnet-ajax/grid/retrieving-value-from-radgrid-in-editmode-on-a-external-button-click.aspx

http://www.telerik.com/community/forums/aspnet-ajax/grid/button-click-event-and-radgrid.aspx

I have been to dozens and dozens of these links and NONE of them provide a simple, straight forward example to solve this. I have left several posts requesting similar examples with no resolution. Here is the code I am attempting to use:

ASPX:

<telerik:RadGrid ID="rgd_ABIUser" runat="server" GridLines="None" AutoGenerateColumns="False" Width="400px" style="height: 46px">

<MasterTableView DataKeyNames="ID">

<RowIndicatorColumn>

<HeaderStyle Width="20px"></HeaderStyle>

</RowIndicatorColumn>

<ExpandCollapseColumn>

<HeaderStyle Width="20px"></HeaderStyle>

</ExpandCollapseColumn>

<Columns>

<telerik:GridTemplateColumn DataField="SC" HeaderText="Site" SortExpression="SC" UniqueName="SC">

<ItemTemplate>

<asp:TextBox ID="tbx_Site" Text='<%# Bind("SC") %>' runat="server" Width="30px"></asp:TextBox>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="ID" HeaderText="User" SortExpression="ID" UniqueName="ID">

<ItemTemplate>

<asp:TextBox ID="tbx_UserID" Text='<%# Bind("ID") %>' runat="server"></asp:TextBox>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="PW" HeaderText="Password" SortExpression="PW" UniqueName="PW">

<ItemTemplate>

<asp:TextBox ID="tbx_Password" Text='<%# Bind("PW") %>' runat="server"></asp:TextBox>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="SN" HeaderText="TCH#" SortExpression="SN" UniqueName="SN" >

<ItemTemplate>

<asp:TextBox ID="tbx_TchNo" Text='<%# Bind("SN") %>' runat="server" Width="30px"></asp:TextBox>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="TG" HeaderText="Group" SortExpression="TG" UniqueName="TG">

<ItemTemplate>

<asp:TextBox ID="tbx_TG" Text='<%# Bind("TG") %>' runat="server" Width="20px"></asp:TextBox>

</ItemTemplate>

</telerik:GridTemplateColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

Here is my ASPX.VB

Protected Sub btn_UpdateUser_Click(sender As Object, e As System.EventArgs) Handles btn_UpdateUser.Click

For Each item As GridDataItem In rgd_ABIUser.Items

'Here is one way I have seen to get the value

Dim txtBox As TextBox = DirectCast(item("PW").FindControl("tbx_Password"), TextBox)

Dim PW As String = txtBox.Text

'Here is a different way I have seen to get the value

Dim SN As String = DirectCast(TryCast(item.FindControl("tbx_TchNo"), TextBox).Text, String)

Dim TG As String = DirectCast(TryCast(item.FindControl("tbx_TG"), TextBox).Text, String)

Dim DatabaseName As String = Session("DataBase")

Dim Val = Session("Site")

Dim Site As Integer = Convert.ToInt32(Val)

Dim IDUser As String = Session("ID")

Dim connectionString = New SqlConnection("server=DO-IT-AB\MSSQLAB;database=XXXX;UID=XXXX;PWD=XXX;")

Dim command = New SqlCommand("aa_abi_users_update", connectionString)

command.CommandType = CommandType.StoredProcedure

command.Parameters.Add("@DBName", SqlDbType.VarChar).Value = DatabaseName

command.Parameters.Add("@IDSite", SqlDbType.Int).Value = Site

command.Parameters.Add("@IDUser", SqlDbType.VarChar).Value = IDUser

command.Parameters.Add("@PW", SqlDbType.VarChar).Value = PW

command.Parameters.Add("@SN", SqlDbType.VarChar).Value = SN

command.Parameters.Add("@TG", SqlDbType.VarChar).Value = TG

command.Connection.Open()

command.ExecuteNonQuery()

command.Connection.Close()

Next

Any help much appreciated.

Grid

answered on 18 Mar 2011

2 answers

73 views

Passing search value from one grid to another

I am looking for an efficient way to take the filtered value from one RadGrid and pass that value to another RadGrid (to update the data).

A quick search yielded no results, is this something any of you have tried before? If so, can you point me in the right direction?

Thanks!

Grid

answered on 18 Mar 2011

1 answer

81 views

Menu with AJAX onRequestStart

Hello,

I have a menu that when a user clicks an item it postback using the RadAjaxPanel.

Well in certain items i need to cancel the ajax request for like the 'DOWNLOAD FILE' item but leave it on for other items.

Im using the Panels onRequestStart but all it returns in the eventtarget is my menu ID is there anyway to find the ITEM within the menu that triggered the AJAX?

Or should i make a custom menu items with buttons?

CODE:

<script type="text/javascript">

function onRequestStart(sender, args) {

if (args.get_eventTarget().indexOf("ExportToExcelButton") >= 0 ||

args.get_eventTarget().indexOf("ExportToWordButton") >= 0 ||

args.get_eventTarget().indexOf("ExportToCsvButton") >= 0 ||

args.get_eventTarget().indexOf("ExportToPdfButton") >= 0) {

args.set_enableAjax(false);

}

if (args.get_eventTarget().indexOf("FilesMenu") >= 0)

{

alert("ET: " + args.get_eventTarget());

alert("EA: " + args.get_eventArgument());

alert("ETE ID: " +args.get_eventTargetElement().id);

args.set_enableAjax(false);

}

</script>

Menu

answered on 18 Mar 2011

1 answer

57 views

New Docs, not a great start

I don't know whether or not it is by design, but I have VS2008 and VS2010 on my machine and the MSDN help, part of VS 2008 was updated with the new docs for JustCode but not for those for RadControls for ASP.NET AJAX.

When I click on the link to open the docs in a browser and navigate to the API Reference | Telerik.Web.UI Namespace the top of the page indicates a missing reference...

[Missing <summary> documentation for "N:Telerik.Web.UI"]

And the page looks like ss1.gig. Note the twin vertical scrollbars.

SS2.gif shows that the right-hand pane is in a little container of its own.

I initially thought it might just be Chrome, but I got the same thing in IE8.

--
Stuart

Documentation and Tutorials

answered on 18 Mar 2011

3 answers

240 views

Boarder missing around the table inserted into the word processor

Hello,

I insert table in the Word Processor of RadEditor but table border is missing.
How could i setting the border of table insert into word Processor.

Important thing is table appears the dashed line instead of a solid line.
Please help me as soon as possible.
Thanks.

Best Regards
Mutum Jiten Singh
Akhil Systems Pvt. Ltd.

Editor

answered on 18 Mar 2011

1 answer

103 views

show/hide grids

Hello,

Attached is a screen shot of my page.
But what I am wanting to do, and I have not been able to do so.
Is when the user select a node from the treeview I want to display the appropriate grid.
For each node there is a new grid, and depending on which node they choose I want to show that grid, and hide the others.

I have each grid in a RadAjaxPanel, and I have tried setting visiblity to true and false for the panel, and or the grids but it does not seem to work.
I have also tried a snippet of code I found on these forums, but that too does not work for me.

 if (RadGridOSPProposal.Style["display"] != null && RadGridOSPProposal.Style["display"].ToString() == "none")
                    RadGridOSPProposal.Style["display"] = "";
                else
                    RadGridOSPProposal.Style.Add("display", "none");

Thanks for any help, code samples are alway welcome.
KS

Grid

answered on 18 Mar 2011

1 answer

52 views

Change the dayview date in codebehind

upon clicking an event from my monthview, I want to change the date of the dayview I have to that day. I have am trying to pass in the startdate from the database (i.e. dt.Rows[0]["startDate"].ToString()) to the DataStartField. Is there a different method to the madness? SelectedDate but that did not work either.

Thanks,
Mike

Scheduler

answered on 18 Mar 2011