WebGrid general questions

Datetime, Events, and Text fields.

admin — Sun, 03 Sep 2006 17:45:47 GMT

Customer question:

1. Can I override the default value field that webgrid automatically assings. Example: I have a DB where a text field is use as a timedate field and user controls have been used to format the date that is input into the field.
Answer:

Yes, you can. There are properties to set datetime format is this is desired for DateTime column, also there are events to modify data, please see Webgrid event documentation for further information.

2. In VS 2005 I simply edit the grids template and put a label with a calendar control in the template and that formats the date. Any way to do this in webgrid?

A calendar is automatically assign to a datetime column as default, if you want to put in your own calendar you can use property called "BeforeEditHtml" or "AfterEditHtml" property to insert your calendar control if you want to use your own.

3. Also I have another text field that is populated simularly but using a dropdown box to control the selection. Is this possible. What I have run into is webgrid assigning the text as a text field (imagine that)and I do not see how to override this or if it is possible.

I am not sure what you want here, but I give it a try.

dropdown boxes are foreignkey columns in WebGrid, you can cast your text field as an foreignkey column, and use "datasource" and "valuecolumn" property to populate and display content for the dropdown boxes.

How Change DateTime Picker

megalomax — Fri, 18 Jun 2010 16:44:19 GMT

Hi.

I readin post http://forums.webgrid.com/forums/thread/1307.aspx

I tray change CalendarClientScript="datepicker" but not work.

El tipo 'WebGrid.DateTime' no tiene ninguna propiedad pública cuyo nombre sea 'CalendarClientScript'.

template in the editor for web based application

SVK — Fri, 13 Aug 2010 07:57:07 GMT

i have seen the webgrid editor. i have a web application and need to use it in the web page

besides inserting images , does the editor have facility for creating templates in htm format and saving it & inserting it in the editor for later use

How to catch an exception generated by the database?

Laszlo — Tue, 18 May 2010 11:08:22 GMT

Hi,

in my database scheme some tables have unique idexes defined. (It seems that setting the “UniqueValueRequired” property to “true” doesn’t work with foreign key columns.)

If the user tries to save a record that would generate duplicate row values an exception is raised by MS SQL. The exception is catched by the “Athem_error” function but it’s not recognized by the WebGrid control.
As default “Anthem_error” displays a popup with the error description while WebGrid continuously shows the AJAX loader GIF over the detail view of the record. WebGrid still display the GIF also after closing the error popup – it does the same until the next refresh.

What would be the best way to notify the WebGrid control about a database generated exception, which is considered as AJAX error? (I would handle these errors as I do it with all the other ones: the WebGrid controls would remain in detail view keeping the actual values of the controls, and it would display a SystemMessage with some info on the problem.)

Many thanks in advance.

WebGrid Photoalbum - How to access control from Template column

Reena — Tue, 11 May 2010 12:37:33 GMT

Hi,

I am using webgrid's photoalbum.

I have taken a , in that i have used a columntemplate and placed an asp image button inside it.I tried a lot but i am unable to access this image button at GridRowBound event the row or cell are not providing the find control event.

Actually i have to assign image path at runtime.

and if i am using the image column than it is it always refering the path of upload folder in the application.

So please solve my prblem...either let me know how can i find a control from template column (which will be better option) or if we can assign images of our own path to image column.

please ,its very urgent.

Chart won't refresh

cashdesk — Mon, 08 Mar 2010 11:03:31 GMT

Hi there,

I am just trying out WebGrid to see if it is something my organisation can use.

I have a chart on a webpage and I pass this page an ID which is used to search the database. When the record is returned in a DataTable I use that as the DataSource for my WebGrid.

I pass in one ID which should return 1 record, and it does this. When I pass in a new ID which returns 3 records, it still only shows the first record. I have stepped through the code and can confirm that no matter how many records are returned, only the first set of results is ever shown.

I close down the app, re-open it and pass in an ID which returns 3 records. This works fine. I then pass in an ID that returns one record, but 3 are still shown.

I have tried calling MyWebGrid.Rows.Clear() before binding the new records but that just gives an empty chart. I tried setting CacheGridStructure to false but that didn't help, either. I set EnableViewState in my page to false, but to no avail.

Any help would be greatly appreciated..

Chart error

fernandopablo — Sat, 27 Mar 2010 08:17:47 GMT

I have this error when I page a chart.

Error de desbordamiento.
Descripción: Excepción no controlada al ejecutar la solicitud Web actual. Revise el seguimiento de la pila para obtener más información acerca del error y dónde se originó en el código.

Detalles de la excepción: System.OverflowException: Error de desbordamiento.

Error de código fuente:

Se ha generado una excepción no controlada durante la ejecución de la solicitud Web actual. La información sobre el origen y la ubicación de la excepción pueden identificarse utilizando la excepción del seguimiento de la pila siguiente.

Seguimiento de la pila:

[OverflowException: Error de desbordamiento.]
System.Drawing.Graphics.CheckErrorStatus(Int32 status) +1048649
System.Drawing.Graphics.DrawLine(Pen pen, Int32 x1, Int32 y1, Int32 x2, Int32 y2) +69
WebGrid.Util.Chart.RenderLineChart(Bitmap bitmap, Rectangle drawArea) +1619
WebGrid.Util.Chart.Render() +1844
WebGrid.Chart.RenderLabelView(WebGridHtmlWriter writer, RowCell cell) +4856
WebGrid.Column.DesignRenderGrid(WebGridHtmlWriter writer, RowCell cell) +5124
WebGrid.Column.Render(WebGridHtmlWriter writer, RowCell cell) +70
WebGrid.Design.Rendering.CreateRows(Grid grid, Boolean tree, String parentValue, Int32 level, WebGridHtmlWriter writer, Int32[] sortedColumnID, Int32 numberOfRowsDrawn) +3160
WebGrid.Design.Rendering.RenderGrid(Grid& grid, WebGridHtmlWriter& writer) +5854
WebGrid.Design.DesignRender.Render(WebGridHtmlWriter mywriter) +5433
WebGrid.Design.DesignRender.Render() +73
WebGrid.Grid.OnPreRender(EventArgs e) +2833
System.Web.UI.Control.PreRenderRecursiveInternal() +80
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +842

--------------------------------------------------------------------------------
Información de versión: Versión de Microsoft .NET Framework:2.0.50727.3603; Versión ASP.NET:2.0.50727.3053

Error with webgrid.dll

fernandopablo — Mon, 26 Apr 2010 09:19:54 GMT

I'm triying public my proyect and I have this error:

Can you help me , please?

"Unable to update auto-refresh reference 'webgrid.dll'. Cannot find assembly 'C:\Documents and Settings\Program Files\WebGrid - The plug and play data grid\WebGrid.dll'."

Chart Control with decimal values

Dominik — Mon, 01 Feb 2010 11:40:34 GMT

Hi,

Is it possible to show decimal values in a Chart Control?

I'm using AddDataArray method to add ChartValue elements with decimal values to my Chart, but when the chart is shown, decimal values are lost...

Is it possible to show Percent symbol (%) with decimal values also?

Problem with chart

fernandopablo — Tue, 09 Feb 2010 14:09:01 GMT

I need input values to chart of a webgrid,

Can you tell me how Can I assigned values to chart, please?

Thanks in advance.

Regards

PopupExtender

Laszlo — Wed, 17 Feb 2010 17:39:06 GMT

Hi,

I would have a question on the PopupExteder functionality: how to show the popup window on creating a new record? It's not presented in the adequate demo (only the case when it's triggered by clicking on the edit button).

Thank you in advance.

creating a new record inserts TWO new rows into database?

stone — Thu, 24 Jul 2008 00:00:16 GMT

Hi,

hope someone can shed light on this problem I am having.

This can be reproduced quite easily.

I have a simple database table with two columns, say id (int, not null, identity PK) and name (varchar).

Bind it up to a WebGrid and accept all defaults.

On creating a new row (by clicking new row button, entering Edit mode and saving) seems to perform the insert twice, raising the OnInsertUpdate events twice.

Is this a feature? If so, how is it avoided? Any help on this would be greating appreciated.

I will upload debug/set up if required.

Many thanks.

Stone.

Create a Chart Control Dinamically

Dominik — Wed, 03 Feb 2010 12:53:16 GMT

Hi all,

Is it possible to create a Chart control Dinamically?

I only can see a blank box instead of the chart...

Imposible to move webgrid in contentpanel page aspx.

fernandopablo — Wed, 03 Feb 2010 13:49:09 GMT

I have some webgrids in a contenpanel, I have changed the propieties position to relative but for me is imposible to move the webgrids,

Any idea please.

Thanks in advance.

Change the properties of columns

fernandopablo — Mon, 01 Feb 2010 10:30:42 GMT

I need to change the properties of columns in a webgrid, How can I do that? I dont see any properties for the colums

Is WebGrid free?

Wedge — Mon, 01 Feb 2010 08:04:51 GMT

According to the links below the WebGrid is free

http://dotnetslackers.com/DataSet/re-103065_WebGrid_Ajax_Data_Grid_available_for_free.aspx
http://www.theserverside.net/news/thread.tss?thread_id=58170

But price on the site is 399 euro
http://webgrid.com/Purchase.aspx

Which one is true?
Are there different licences ?

ContextMenu WebGrid demo disable???

megalomax — Mon, 11 Jan 2010 14:54:35 GMT

Hi, as it can be disabled ContextMenu WebGrid demo??

Export columns Foreignkey only ID, Name???

megalomax — Sun, 10 Jan 2010 20:44:55 GMT

Hi, I have a grid with columns type ForeignKey. for example.

DisplayIndex="20" EditAlign="Right" GridAlign="Left" IsInDataSource="True"
LoadColumnDataSourceData="False" Primarykey="False" Required="True"
SortExpression="Cost_Type_Name" Title="Cost Type"
ValueColumn="Cost_Type_Name" Visibility="Both" NullText="Choice Option"
Searchable="true">

when I export to excel the grid, I only export my ID number field, not the name.

for example

Job Number Cost Type
JO9O868 2

How do I print my name not the id.

some example??

Question, as can be exported to word???

thanks.

Slider orientation

robokopp — Thu, 07 Jan 2010 09:00:25 GMT

Hi,
do you plan to add the possibility of vertical orientation of Pager Slider ?

System message - For full version register at WebGrid Support Account.

Priyadharsini — Wed, 06 Jan 2010 06:15:34 GMT

Hi Olav,

I have been using webgrid from 2.7 version and had a licence key for the same. Recently i updated to the latest 3.3.1 version and had the same licence key. But now, while navigating to pages at times i get a system message saying - For full version register at WebGrid Support Account. I also tried with no licence key as, .
Though i get the pages for few times, on continous navigations i again get the same system error message. Kindly let me know if there is any way to suppress this message.

Many Thanks,
Priya.

WG:ColumnTemplate

Sadeesh — Tue, 05 Jan 2010 14:46:56 GMT

Hi

I had use the column template for my process, But i cann't able to update changes in the record.

<WG:ColumnTemplate ColumnId="templatecolumn" Visibility="Detail" AllowEdit="true" AllowEmpty="false" DisplayIndex="5"
        HideDetailTitle="true">
        <DetailViewTemplate>

        </DetailViewTemplate>
</WG:ColumnTemplate>

if any possible ways....... share with me

Value of a ForeignKey column in OnBeforeUpdateInsert

Laszlo — Mon, 04 Jan 2010 16:10:31 GMT

Hi,

I have a problem with accessing the values of foreign keys in the OnBeforeUpdateInsert event handler. I created an in-memory data set to store some filter expressions. I use a WebGrid component, ”GridSearch”, to maintain the data in the data set. Among others, there are foreign key columns (”Fields” and ”Relation”) and simple text columns (”Value” and ”FilterExpr”) in the data set.

Everything works fine with this setup, I can add and edit the records in the WebGrid, exepting one thing: when I try to read the actual value of the foreign key columns in the OnBeforeUpdateInsert handler I get ”null” while the values of the simple text columns are accessible and correct.

Can you please advise me what can I do to get the correct values also in case of the foreign keys?

Thank you in advance.

Below please find some extracts from my code:

protected void Page_Load(object sender, EventArgs e)

{

if (IsPostBack == false)

{

DataColumn myDataColumn;

DataTable dttFilter = new DataTable("dttFilter");

/* Create an auto-incrementing key field */

myDataColumn = new DataColumn();

myDataColumn.AllowDBNull = false;

myDataColumn.AutoIncrement = true;

myDataColumn.AutoIncrementSeed = 1;

myDataColumn.AutoIncrementStep = 1;

myDataColumn.ColumnName = "ID";

myDataColumn.DataType = System.Type.GetType("System.Int32");

myDataColumn.Unique = true;

dttFilter.Columns.Add(myDataColumn);

/* Primary key on ID */

DataColumn[] PK1 = new DataColumn[1];

PK1[0] = dttFilter.Columns["ID"];

dttFilter.PrimaryKey = PK1;

...

/* Create a string field for a foreign key column */

myDataColumn = new DataColumn();

myDataColumn.AllowDBNull = true;

myDataColumn.ColumnName = "Relation";

myDataColumn.DataType = System.Type.GetType("System.String");

dttFilter.Columns.Add(myDataColumn);

/* Create a standard string field */

myDataColumn = new DataColumn();

myDataColumn.AllowDBNull = true;

myDataColumn.ColumnName = "Value";

myDataColumn.DataType = System.Type.GetType("System.String");

dttFilter.Columns.Add(myDataColumn);

/* Set the data source of the grid */

DataSet TmpDataSet = new DataSet();

TmpDataSet.Add(dttFilter);

GridSearch.DataSource = TmpDataSet.Tables[0];

GridSearch.DataBind();

}

WebGrid.Data.Table fktable;

fktable = new WebGrid.Data.Table(GridSearch, true);

StringDictionary relations = new StringDictionary();

relations.Add(" = ", " = ");

relations.Add(" < ", " < ");

relations.Add(" > ", " > ");

relations.Add(" <> ", " <> ");

relations.Add(" like ", " like ");

fktable.DataSource = relations;

((WebGrid.Foreignkey)GridSearch["Relation"]).Table = fktable;

...

}

protected void GridSearch_BeforeUpdateInsert(object sender,

WebGrid.Events.BeforeUpdateInsertEventArgs e)

{

WebGrid.Grid wg = (WebGrid.Grid)sender;

...

=> wg.Rows[0]["Relation"].Value is null !

=> (or e.Row["Relation"].Value is null)

=> but:

=> wg.Rows[0]["Value"].Value is accessible and correct

=> (and e.Row["Value"].Value is accessible and correct)

...

}

OverrideSystemMessage

robokopp — Mon, 21 Dec 2009 17:07:21 GMT

Hi,
how can i override System Message ID "PagerStatus" ?

filter a foreignkey column with value from another foreignkey column

mark — Fri, 18 Dec 2009 06:14:28 GMT

Hi,

I have a grid with two foreignkey columns and I’m trying to use the value of Foreignkey1 (FK1) to filter the data on foreignkey2 (FK2).

I’m using the columnpostback and in the code behind i can get the value I need from FK1:
Dim key As String = wgDustMon.Rows(e.EditIndex)(e.ColumnName).PostBackValue

Using the FK1 key value I can create my filterexpression and add it to the FK2 column:
Dim filterString As String = "(EXISTS (SELECT DISTINCT Mid FROM [Monloc] WHERE ([Monloc].[JobNoID]= " & key & ") AND [MonLoc].[MediumID] = 5))"
DirectCast(wgDustMon("FK2"), WebGrid.Columns.Foreignkey).FilterExpression = filterString

I have used the debug mode of the grid and from what I can tell, the SQL is being generated correctly (the WHERE clause is there and it updates as I change FK1).

The problem is that the dropdown for FK2 is not being filtered.

I had a look through the docs but I can’t figure how to refresh/reload the data on FK2 to use the filter.

How do I get FK2 to update?

Thanks

Mark

Columns per files

fernandopablo — Tue, 15 Dec 2009 15:12:24 GMT

I have any questions for you,

It possible to change the columns per files, I need change the orden of files and columns.

also, It is possibe can assign a color to a cell as its value?