4 answers

301 views

How to get data from remote mysql in grid ??

Hii,

I have a grid and i want the data from my remote mysql. I have tested the connection but i am not aware as how to get the data in the grid.

Like this is my connection-
string connString = "Server=174.121.35.162;Database=funiks_phonebook;Uid=funiks_phonebook;Pwd=phonebook;Port = 3306;";
MySqlConnection conn = new MySqlConnection(connString);
MySqlCommand command = conn.CreateCommand();
command.CommandText = "select contactname,phno from phonebook";

Now i want to get these values in my grid, please advise, Please stretch it so that i can change the values and update the table as well.

It will be very helpful.

GridView

answered on 24 Oct 2012

2 answers

202 views

get data from dataset

I've created dataset using 'Add new Data source' - ShoppingMallDataSet
Then I what to get data from table TClient. So I've created global variable BindingSource bs and initialize it in method GetData

void GetData(){

using(ShoppingMallDataSet smds = new ShoppingMallDataSet())

{

using (var conn = new SqlConnection(connection_string))

{

using (var adapter = new ShoppingMallDataSetTableAdapters.TClientTableAdapter() { Connection = conn })

{

adapter.Fill(smds.TClient);

bs.DataSource = smds.TClient;

}

and here its using in code

.....

rgv.MasterTemplate.DataSource = bs;

GetData();

DataSource is not null but rgv has neither rows no columns. Where is the problem?

GridView

answered on 23 Oct 2012

5 answers

254 views

RadMenuComboItem and Databinding

I have a RadMenu with a sub RadMenuComboItem that I would like to DataBind to. Under the childen collection//RadDropDownList Element - Datasource is greyed out in the editor and if I try the following the code, it runs but nothing is populated in the Combobox.

this.radMenuComboTheme.ComboBoxElement.BindingContext = this.BindingContext;
this.radMenuComboTheme.ComboBoxElement.DataMember = "Theme_Name";
this.radMenuComboTheme.ComboBoxElement.ValueMember = "Theme_Value";
this.radMenuComboTheme.ComboBoxElement.DataSource = applicationThemes;

According to the documentation :

The RadMenuComboItem allows you to put a drop-down list on a menu. To add items to the combo box work with the Items collection of the RadMenuComboItem.ComboBoxElement property. Because the ComboBoxElement returns a RadDropDownListElement, you can also use data binding to put items in the drop-down list from any data source.

What am I missing?

Menu

answered on 23 Oct 2012

7 answers

413 views

How to Show merge Cell in Grid

Hi
I have some data and i want to group one column or show as merge cell in grid Like bellow
From :

Id	Name	ItemToBuy
1	mike	Toshiba portage
1	mike	Dell Latitude
2	nancy	Toshiba portage
2	nancy	Sony vioa
3	rosa	Asus
3	rosa	Hp
4	farid	Sony vioa

//------------------------------------------------------Show in grid like bellow

Id	Name	ItemToBuy
1	mike	Toshiba portage
		Dell Latitude
2	nancy	Toshiba portage
		Sony vioa
3	rosa	Asus
		Hp
4	farid	Sony vioa //---------------------------------------- i dont want to use Hierarchical structure

GridView

answered on 23 Oct 2012

1 answer

199 views

How to merge 2 columns in radgridview

Hi,

How to merge 2 columns and have a single header Text for the merged columns

Ex:

current o/p
Col1 Col2 col3 col4
r1c1 r1c2 r1c3 r1c4
r2c1 r2c2 r2c3 r2c4
r3c1 r3c2 r3c3 r3c4

current o/p
Col1 MergedCol col4
r1c1 r1c2r1c3 r1c4
r2c1 r2c2r2c3 r2c4
r3c1 r3c2r3c3 r3c4

GridView

answered on 23 Oct 2012

1 answer

115 views

Using custom AppointmentMappingInfo fields with a non-Telerik edit appt form.

I have a Telerik Radscheduler embedded in a non-Telerik program that uses a non-Telerik edit appointment form. I want to add a custom field to AppointmentMappingInfo to pass in a field that is an ID that is used to tell the non-Telerik program what appointment information to load into the form.

I followed this tutorial: http://www.telerik.com/help/winforms/scheduler-data-binding-binding-to-custom-fields.html to implement it, however it seems this will only work if you use a customized version of the Telerik edit appointment form since the custom Appointment is passed as an IEvent into the custom form's LoadSettingsFromEvent() function. How can I get access to my custom appointments when I'm using a non-Telerik edit appointment form?

Thanks.

Scheduler and Reminder

answered on 23 Oct 2012

1 answer

219 views

Disable move event for specific appointment

Hi,

is there a way to disable the move event for a specific appointment?

It seems that the recurring events already have this built in, but is there any way I can add this to my custom appointments?

Regards,
Philip

Scheduler and Reminder

answered on 23 Oct 2012

2 answers

130 views

RadGridView Cell Replicates in other Cells when Scrolling

I was able to create Customcell element from the following post.
http://www.telerik.com/community/forums/winforms/gridview/show-mulitple-images-in-a-gridview-column.aspx

But when I perform scroll in Gridview, the same CustomCell with 3 Buttons replicate itself in other cells.
Here is my code for CreateCell Event.

private void gvProductDetail_CreateCell(object sender, GridViewCreateCellEventArgs e)
        {
            if (e.Column.GetType().Name == "GridViewCommandColumn")
            {
                GridViewCommandColumn dataColumn = e.Column as GridViewCommandColumn;

                if (e.Row is GridDataRowElement && dataColumn != null)
                {
                    CustomGridDataCell cell = new CustomGridDataCell(e.Column, e.Row);
                    e.CellElement = cell;
                }
            }
        }

Someone at telerik Please guide Me. I know it has something to do with Virtualize Cell format you guys are using but Can't figure out a way to solve the issue. Thanks in Advance.

GridView

answered on 23 Oct 2012

1 answer

88 views

RadGridview : CustomCell Replicates in other Cell when Scrolling

I was able to create Customcell element from the following post.
http://www.telerik.com/community/forums/winforms/gridview/show-mulitple-images-in-a-gridview-column.aspx

But when I perform scroll in Gridview, the same CustomCell with 3 Buttons replicate itself in other cells.
Here is my code for CreateCell Event.

private void gvProductDetail_CreateCell(object sender, GridViewCreateCellEventArgs e)
{
if (e.Column.GetType().Name == "GridViewCommandColumn")
{
GridViewCommandColumn dataColumn = e.Column as GridViewCommandColumn;

if (e.Row is GridDataRowElement && dataColumn != null)
{
CustomGridDataCell cell = new CustomGridDataCell(e.Column, e.Row);
e.CellElement = cell;
}
}
}

Please guide Me. Thanks in Advance.

GridView

answered on 23 Oct 2012

1 answer

79 views

Telerik Generation Support

Hello guys,

Need to know one thing before buy 2012.

What if a project was built under, say, Telerik 2011 and now we install VS2012 (with your last package) and want to use the same sources?
Will it work smoothly?
What VS Designer thinks about all that?

What is the portability between versions both in controls and their operability under VS2012 designer?

Thanks

General Discussions

answered on 23 Oct 2012