Questions on UI for ASP.NET AJAX Forum

1 answer

195 views

Hi,

I have taken a RAD Grid having 3 combo box columns, I wan to implement batch update and need to update the database on code behind, please let me know which event of grid should I handel for inserting new item (single row) & batch update modified items to database (only modified rows). also please let me know how can i get the values from grid to insert in database for insert new row or for bulk update.

below is my code

.aspx page
<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False"
        CellSpacing="-1" GridLines="Both" onneeddatasource="RadGrid1_NeedDataSource"
        onprerender="RadGrid1_PreRender">
        <MasterTableView EditMode = "Batch" CommandItemDisplay ="TopAndBottom">
            <Columns>
                <telerik:GridBoundColumn DataField="trans"
                    FilterControlAltText="Filter column column" HeaderText="TransactionID"
                    UniqueName="column">
                </telerik:GridBoundColumn>
                <telerik:GridTemplateColumn DataField="EmployeeName"
                    FilterControlAltText="Filter EmployeeName column"
                    UniqueName="EmployeeName" HeaderText="Employee Name">
                    <EditItemTemplate>
                        <telerik:RadComboBox ID="RCBEmployee" Runat="server"
                            EmptyMessage="Select Employee">
                        </telerik:RadComboBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <%# Eval("EmployeeName") %>
                    </ItemTemplate>
                </telerik:GridTemplateColumn>
                <telerik:GridTemplateColumn DataField="Department"
                    FilterControlAltText="Filter Department column" UniqueName="Department"
                    HeaderText="Department">
                    <EditItemTemplate>
                        <telerik:RadComboBox ID="rcbdept" Runat="server">
                        </telerik:RadComboBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                         <%# Eval("Department") %>
                    </ItemTemplate>
                </telerik:GridTemplateColumn>
                <telerik:GridTemplateColumn DataField="Skill"
                    FilterControlAltText="Filter Skill column" UniqueName="Skill"
                    HeaderText="Skill">
                    <EditItemTemplate>
                        <telerik:RadComboBox ID="RCBSkill" Runat="server">
                        </telerik:RadComboBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <%# Eval("Skill") %>
                    </ItemTemplate>
                </telerik:GridTemplateColumn>
            </Columns>
        <BatchEditingSettings EditType ="Row" />
        </MasterTableView>
    </telerik:RadGrid>

ASPX.CS

protected void RadGrid1_NeedDataSource(object sender, GridNeedDataSourceEventArgs e)
    {
        RadGrid1.DataSource = PopulateGrid();
    }
protected void RadGrid1_PreRender(object sender, EventArgs e)
    {
       //Populating Employee
        RadComboBox combo = RadGrid1.FindControl(RadGrid1.MasterTableView.ClientID + "_EmployeeName").FindControl("RCBEmployee") as RadComboBox;
        combo.DataSource = PopulateEmoloyee();
        combo.DataTextField = "EmployeeName";
        combo.DataValueField = "EmployeeID";
        combo.DataBind();
//populating Department
        RadComboBox combodept = RadGrid1.FindControl(RadGrid1.MasterTableView.ClientID + "_Department").FindControl("rcbdept") as RadComboBox;
        combodept.DataSource = PopulateDepartment();
        combodept.DataTextField = "Department";
        combodept.DataValueField = "deptid";
        combodept.DataBind();
}

Grid

answered on 23 Jun 2014

3 answers

291 views

Open Word,Excel & PDF

Hi All,

I have to convert a varbinary data into selected (it may be word/excel/PDF) document type and show the content in browser itself. May i know which control in Rad will be use for this requirement?

Ajax

answered on 23 Jun 2014

1 answer

484 views

Binding RadComboBox with ObjectDataSource trough DataValueField="Property.Property"

Hi, I'm trying to bind a RadComboBox with an ObjectDataSource (odsFuenteEmisionAlcance) that returns a List of Objects like these:

List<FuenteEmisionAlcance>

public class FuenteEmisionAlcance

{

private FuenteEmision m_FuenteEmision;

private Alcance m_Alcance;

public FuenteEmision FuenteEmision

{

get { return m_FuenteEmision; }

set { m_FuenteEmision = value; }

}

public Alcance Alcance

{

get { return m_Alcance; }

set { m_Alcance = value; }

}

This is my ComboBox

<telerik:RadComboBox ID="rcbFuenteEmision" runat="server" AutoPostBack="True" DataSourceID="odsFuenteEmisionAlcance" DataTextField="FuenteEmision.Nombre" DataValueField="FuenteEmision.Id" ZIndex="100000" CausesValidation="False" OnSelectedIndexChanged="rcbFuenteEmision_SelectedIndexChanged" EmptyMessage="--Seleccione--" OnClientSelectedIndexChanged="OnClientSelectedIndexChanged" OnDataBinding="rcbFuenteEmision_DataBinding"></telerik:RadComboBox

I'm trying to use the DataTextField and DataValueField values from the Property FuenteEmision, but somehow is not getting it, this is what I get:

[NotSupportedException: Object of type HUC.FuenteEmisionAlcance does not have a FuenteEmision.Nombre property.]

Like I show before the object FuenteEmisionAlcance does a have a FuenteEmision property, the combo is able to find it, i've tried using only DataTextField="FuenteEmision" and DataValueField="FuenteEmision" just to try and it does find it, but when it comes to find a property from the property it crashes, is this impossible? or there is another way I can acomplish this.

ComboBox

answered on 23 Jun 2014

1 answer

96 views

trxtbox ItemTemplate in GridTemplateColumn programatically

hello

I want to add GridTemplateColumn and Textbox as itemtemplate programatically.

I used the below code but it just generate the GridTemplate columns with blank rows without textbox as shown in attached image

Please help me to solve this problem.



Protected

Sub btnFurnaceAdd_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnFurnaceAdd.Click

num = gdFurnace.Items.Count + 1

Dim dt As New DataTable()

gdFurnace.DataSource = addBlankLines(dt, num)

gdFurnace.Rebind()

For i = 0 To 8

Dim col As New GridTemplateColumn

col.HeaderText = "Column" + i.ToString

col.UniqueName = i.ToString

col.ItemTemplate = New MyTemplate(col.UniqueName)

col.HeaderStyle.Font.Bold = True

gdFurnace.MasterTableView.Columns.Add(col)

Next

End

Sub



 Private Function addBlankLines(ByVal dt As DataTable, ByVal num As Integer) As DataTable

 Dim count As Integer = 0

        If num <> 0 Then

            Dim drBlank As DataRow = Nothing

            For i As Integer = 0 To num - 1

                drBlank = dt.NewRow()

                dt.Rows.Add(drBlank)

     Next

        End If

        Return dt



    End Function





Private Class MyTemplate

 Implements ITemplate

        Protected lControl As LiteralControl

        Protected validatorTextBox As RequiredFieldValidator

        Protected searchGoogle As HyperLink

        Protected textBox As TextBox

        Protected boolValue As CheckBox

        Private colname As String



        Public Sub New(ByVal cName As String)

colname = cName



        End Sub

        Public Sub InstantiateIn(ByVal container As System.Web.UI.Control) Implements ITemplate.InstantiateIn

lControl = New LiteralControl()

            lControl.ID = "lControl"

            AddHandler lControl.DataBinding, AddressOf lControl_DataBinding

            textBox = New TextBox()

            textBox.ID = "templateColumnTextBox"

            validatorTextBox = New RequiredFieldValidator()

            validatorTextBox.ControlToValidate = "templateColumnTextBox"

            validatorTextBox.ErrorMessage = "*"

            searchGoogle = New HyperLink()

searchGoogle.ID = "searchGoogle"

            AddHandler searchGoogle.DataBinding, _

                       AddressOf searchGoogle_DataBinding

            boolValue = New CheckBox()

            boolValue.ID = "boolValue"

            AddHandler boolValue.DataBinding, _

                       AddressOf boolValue_DataBinding

            boolValue.Enabled = False

            Dim table As New Table()

 Dim row1 As New TableRow()

            Dim row2 As New TableRow()

            Dim cell11 As New TableCell()

            Dim cell12 As New TableCell()

            Dim cell21 As New TableCell()

            Dim cell22 As New TableCell()

            row1.Cells.Add(cell11)

            row1.Cells.Add(cell12)

            row2.Cells.Add(cell21)

row2.Cells.Add(cell22)

            table.Rows.Add(row1)

            table.Rows.Add(row2)

            cell11.Text = colname + ": "

            cell12.Controls.Add(lControl)

            cell21.Text = "Search Google for: "

            cell22.Controls.Add(searchGoogle)

            container.Controls.Add(textBox)

            container.Controls.Add(validatorTextBox)

            container.Controls.Add(table)

container.Controls.Add(New LiteralControl("<br />"))

            container.Controls.Add(boolValue)



        End Sub

        Sub boolValue_DataBinding(ByVal sender As Object, ByVal e As EventArgs)

 Dim cBox As CheckBox = DirectCast(sender, CheckBox)

            Dim container As GridDataItem = DirectCast(cBox.NamingContainer, GridDataItem)

            cBox.Checked = DirectCast((DirectCast(container.DataItem, DataRowView))("Bool"), Boolean)



        End Sub

        Sub searchGoogle_DataBinding(ByVal sender As Object, ByVal e As EventArgs)

Dim link As HyperLink = DirectCast(sender, HyperLink)

            Dim container As GridDataItem = DirectCast(link.NamingContainer, GridDataItem)

            link.Text = (DirectCast(container.DataItem, DataRowView))(colname).ToString()

            link.NavigateUrl = "http://www.google.com/search?hl=en&q=" + _

                   (DirectCast(container.DataItem, DataRowView))("ContactName").ToString() + "&btnG=Google+Search"



        End Sub

        Public Sub lControl_DataBinding(ByVal sender As Object, ByVal e As EventArgs)

Dim l As LiteralControl = DirectCast(sender, LiteralControl)

            Dim container As GridDataItem = DirectCast(l.NamingContainer, GridDataItem)

            l.Text = (DirectCast(container.DataItem, DataRowView))(colname).ToString() + "<br />"



        End Sub

    End Class

General Discussions

answered on 23 Jun 2014

10 answers

771 views

SelectedItems count always 0

Hi,

I am trying to access the selected row in my grid, but SelectedItems or SelectedIndexes is always empty. Anyone had this issue before?

And the event SelectedIndexChanged is never fired....

Grid

answered on 23 Jun 2014

1 answer

150 views

[Solved] RADGrid Sorting Move Up and Down Button Hide/Show

Hi,
I am using this post http://www.telerik.com/forums/radgrid-rows-sorting-move-up-and-move-down-button#e2TZo8jWa0CwWCpvuifTow

to acheive the sorting functionality.

I would like to know how to hide the Up button when it reaches the first position as it cannot be moved up further.

Similarly to hide the down button when it reaches the last position as it cannot be moved down further

Please advise.

Grid

answered on 23 Jun 2014

1 answer

96 views

Add <p> tag after pressing enter key in <h2> tag al last text

Hello ,

I want that when the pressing enter key at the last of the heading tag then i want to add a <br/> at the last but the editor add the new <p> tag

For Example:

<h2>demo test</h2>
<p>Demo paragraph</p>

Then I pressing enter key at the last of the <h2> tag like after the :
"demo test "pressing enter key here" "
then he editor will show the content like this:

<h2>demo test</h2>
<p></p>
<p>demo paragraph></p>

but i want the result like this:
<h2>demo test <br/></h2>
<p>demo paragraph></p>

Editor

answered on 23 Jun 2014

1 answer

178 views

Problem with AsyncUpload and User Control .ascx files

I am having issues using the AsynUpload control and .ascx files. It's almost like it doesn't work with them at all. I try to use the clientside development and the server side development and either I get errors or it just doesn't fire. What can I do to alleviate this issue?

AsyncUpload

answered on 23 Jun 2014

1 answer

182 views

How can i acces the NestedViewTemplate data with a button

Morning.

I want to acces the data of a NestedViewTemplate item with a button for each row there, here is a image so i can explain better:

i want to put a button where the red scuare is to acces the data that inside the blue scuare.

Grid

answered on 23 Jun 2014

2 answers

169 views

RadDatePicker - DatePopupButton-ToolTip does not work

Hello!

The property DatePopupButton-ToolTip of RadDatePicker does not work.
"Open the calendar popup." cannot be changed to empty string.

Please don't give me an answer with the javascript method. This is not the solution!
Maybe you have at least a css rule!

Thanks!

Ajax

answered on 22 Jun 2014