I am binding the asp grid to object datasourcecontrol but the rows are not displaying only columns are displaying following is my code...
DEFAULT.aspx
[Code]....
Default.aspx.vb
[Code]....
I'm trying to bind both GridView and DetailsView to a single ObjectDataSource declaratively (in markup). I'm getting the error read as below when I tried to run it.
"The DataSourceID of 'DetailsView1' must be the ID of a control of type IDataSource. A control with ID 'ReservationsDataSource' could not be found."
It works when I bind GridView and DetailsView each seperately to my ObjectDataSource. Is it I can't bind two pagable data web controls to a single datasource?? or there is a trick needed to be done for this to work.
FYI, I'm trying to create a Master/DetailsView of my data. DetailsView of my application should show the record selected in GridView and it should be editable.
I'm doing research on framework development for my company. SInce I will be developing a framework I can not simply declaire all my control in the code in front. Receiently I've been having trouble binding the controls from my ListView to my ObjectData Source. Basicly the properties in my DataObjectTypeName are not populated when the ObjectDataSource "Update" command is thrown. I recieve no error, I just get null values. All I need is an equivalent to this statement for code-behind ...
<%# Bind("AbstractText") %>This would solve all my issues. Ofcouse I will most likely need to bind the control's ID somewhere but that is not an issue. How do I Bind a control to a property in my DataObjectTypeName from the code-behind?
I have a Gridview in the markup and I add an ObjectDataSource to the mark up which will be the gridviews data source. Is this a redundant way of binding controls? I believe using this method is good for small sites with little customisation etc. but, for large sites (multi lingual, hundreds of pages etc) I have been taught to create the controls in the mark up or code behind, then bind the controls on PreRender in the code behind. My new boss thinks this method is old school and the current way of using an objectdatasource in the mark up is the best way to do it.
View 10 RepliesI am trying to bind a DataTable into a ObjectDataSource. This ObjectDataSource data will be used to bind into my LocalReport in ReportViewer. I have already successfully binded my data into the DataTable. My problem now is how do i bind the data in my DataTable into the ObjectDataSource so that it can be used in my report?
Here is my current codes:
ASPX:
[Code]....
VB:
[Code]....
I see from google that this is a common problem. I have a SQL server database that contains 26 rows of data. Two columns, the first is PK and an identity column (keys numbered 1 to 26) and the second column is a text field (nchar(10)) containing a letter of the alphabet (A..Z). The letters were inserted randomly to simulate sql being unsorted by default. I have a query that returns all of the data ordered by the letter column ascending. If I execute the query in sql server I get 26 rows orderd A..Z.
I have a gridview that is set up for paging (page size = 15) and sorting. When sorting is disabled, all data is correctly displayed on the gridview, 15 rows on the first page, 11 rows on the second page.
If I enable sorting, I get 15 rows on the first page and 11 rows on the second page, however on closer examination I find two letters missing and two letters duplicated on both pages. If I navigate to page two, then back to page 1 I find that the data is then shown correctly and the missing letters are back.
Has anyone struck this issue? I am thinking that the sort is not being initialized correctly, but am not sure where to look.
I am developing an application in C# and Sql Server.
View 3 RepliesI have the following problem, i am using gridview to display some table info,, and during RowDataBound event i am binding another DataList control placed on gridview template column,,, the problem is that the DataBind() event of the gridview gives "Index 1 is either negative or above rows count." error.
I debugged alot,, when you disable the DataList binding it works,, but why the 2 not working together i dont know!!.
Below my Code in
Code Behind:
using System;
So I've been teaching myself ASP.NET and VB for about 3 weeks now, having trouble with datatables, not sure how to get the rows to line up like I think they should. My code:
[Code]....
Which gives me the data output I want, but the days are adding rows underneath the previous day instead of lining up side-by-side. The idea is that once it's working I'll replace the specific dates with calendar controls. The gridview currently outputs like this:
i hav a gridview ... now i need to add certain number of rows... say 5 rows .... which would b blank .. the rows consist of itemtemplate of textboxes.. here is the grid ...
[Code]....
now i am binding this gridview with certain data say :
[Code]....
now the problem is if the row contains 2 data originally ... then it alwz shows up with only two rows with binded data... but what i want is 2 (databinded rows ) + 5 (empty rows with textbox ) = 7 grid view rows .... now how to do it ... after i hav binded the textbox with data already....with some empty columns corresponding to the above code ?
Im struggling with a way to bind multiple rows of sql data to specific controls, what im trying to acheive is having a list of questions / answers in my SQL db and loading them into my web form to build a questionaire.
The data i load into the form depends on criteria like which questionaire is it (there will be 2 seperate ones) and what language should it be loaded in, this will be controlled using drop down lists and passing these parameters to the SQL select statement.
The problem i have is i am unsure which method to pull the data out of the question column in my table, and bind it to seperate controls row by row, should i use a SQLDataReader or load the data into a dataset, or run a stored procedure to pull the data?
Which is the best way to get data from sql and bind it to controls in this situation?
For example:
label1.text = sqlcolumn1.row1.value;
label2.text = sqlcolum1.row2.value;
Etc...
I have an ODS control populating a Telerik grid. The ODS definition is pretty simple. It's set to call a method on a static class that has one parameter (entityID). I set this parameter in the OnSelecting event. When I test this, the world is a happy place and all is fine.
Then, I pass a query string to the page (which sets various unrelated values for the page, we'll say parameters X and Y). The page call's Telerik's radgrid.Rebind() event. When this happens, an error is throw from the ODS saying that the underlying method (the static data procedure) does not support parameters X and Y.
So, why is ODS thinking it should be using any querystring values at all when I have explicitly set the entityID parameter (of type Asp:Parameter)? How do I stop this from happening?
The Html:
[Code]....
The OnSelecting:
[Code]....
I see this odsList_OnSelecting being hit and the inspection of e.InputParameters only contains my expected single entry.
I have an ObjectDataSource that is bound to a GridView. The object accepts a parameter from a TextBox. The problem I have is when I use a CustomerValidator with a ServerValidate event, the ObjectDataSource would still attempt to perform a DataBind despite the fact the the customer validator has returned false. The following is the code in the ASPX page.
<asp:TextBox ID="sittingDate" runat="server" />
<asp:CustomValidator ID="DateValidator" runat="server" ControlToValidate="sittingDate" OnServerValidate="DateValidator_ServerValidate" />
<asp:ObjectDataSource ID="BatchDataSource" runat="server" OldValuesParameterFormatString="original_{0}"
SelectMethod="GetOrCreateSittingBatch" TypeName="BatchBLL" OnSelected="BatchDataSource_Selected" OnSelecting="BatchDataSource_Selecting">
<SelectParameters>
<asp:ControlParameter ControlID="sittingDate" Name="batchDate" PropertyName="Text"
Type="DateTime" />
</SelectParameters>
</asp:ObjectDataSource>
<asp:GridView ID="BatchGridView" runat="server" DataSourceID="BatchDataSource">
In the Custom Validator I have
protected void DateValidator_ServerValidate(object source, ServerValidateEventArgs args)
{
/Ensure that the entered data is a date.
string input = args.Value;
DateTime result;
args.IsValid = DateTime.TryParse(input.TrimEnd(), out result);
}
How do I stop the ObjectDataSource from data binding when validation has failed?
how can i access the my sqldatasource selected datasource for modification and adding for example new datacolumns before binding??where is the best place to perform these modifications ?i guess SqlDataSource1_Selected is the right place, but i don't know how ?
View 1 RepliesReferring [URL] .... its a good functionality but instead of removing duplicate rows i need to make the cell of the column containing duplicate value blank
View 1 RepliesI have Gridview Structure Like
CustId   EmailId CheckBox(select) .. I want to display 10 records after that i want to display next to that records
CustId   EmailId CheckBox | CustId   EmailId CheckBox CustId   EmailId CheckBox |
How can I display vertically..
I have a set of dataset with different column retrieved from DB. I need to present the datasets in one GridView (or other ListView etc...) without specifying the column_header. It should present automaticly since the GridView is bind to the DataSet.
In additional, I want this GridView to handle multiple rows edit and update the dataset, idealy, show data in textboxs in initially.How could I set the GridView to edit_model without hardcode column_header and textboxs in 'itemtemplate' or filed.
How could I achieve the bulk edit and update, so that I can assign 'mydataview1.table' to the dataset.
Listview and objectdatasource binding?
[URL]
I have a gridview and the gridview contains some boundfield, templatefield, checkbox and an update command button.
When I click the update button, I want to update only 2 columns. So I made rest of columns readonly=true.
BUT, there is a template field and I am changing the value of the template field from code behind. like below
[Code]....
I do not want to update the above column. so when I click update button, the rows having value more than 0 is working fine.
BUT The rows displaying "Expired" (value less than 0) showing error. It says "Object reference not set to an instance of an object."
I need to produce a from where I can add multiple parts. Each time a user enters a part number, the description should be populated. The user can then click add and this part and description will be shown below. They have the option to add as many parts as they require. Once all parts are added the user fills in some general info eg description and then once a submit button is clicked all part info will be inserted into a table and general info will be inserted into another table with one unique ID.
View 5 RepliesI tried binding a ListBox to an Object Data Source, but I can’t get the field to show up in the Data Source Configuration Wizzard for the ListBox. I got it working programatically populating the listbox using the DataReader but I’d like to be able to use the Object Data Source (Unless there are compelling reasons not to that I haven’t heard of yet.)
The code:
[code]....
This has been covered a couple of times, without a suitable answer:[URL]
I have created a custom paging data class that is used with an ObjectDataSource. In intial tests, I found it was performing worse than my old SqlDataSource code. Whilst investigating, I found that for every page load, the ObjectDataSource is being created and binding twice.
Investigating the links above led me to believe this could be a bug (or unexplained behavior) in regards to changing my GridView's column visibility in the OnDataBound event like so:
protected void gvContacts_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType != DataControlRowType.Pager && e.Row.Cells[0].Text != gvContacts.EmptyDataText)
{
e.Row.Cells[0].Visible = false;
if (Convert.ToInt16(lstSearchType.SelectedValue) == ADDRESS)
{
gvContacts.Columns[2].ItemStyle.Width = Unit.Percentage(30);
gvContacts.Columns[3].Visible = true;
gvContacts.Columns[3].ItemStyle.Width = Unit.Percentage(20);
}
else
{
gvContacts.Columns[2].ItemStyle.Width = Unit.Percentage(50);
gvContacts.Columns[3].Visible = false;
}
}
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes["ID"] = "contact_" + e.Row.Cells[0].Text;
e.Row.Attributes["onclick"] = "javascript:selectRow($(this).attr('id').replace('contact_',''),2);";
e.Row.Attributes["ondblclick"] = "javascript:openContact($(this).attr('id').replace('contact_',''),''); selectRow($(this).attr('id').replace('contact_',''),2);";
//E-mail link
if (e.Row.Cells[4].Text != " ")
{
e.Row.Cells[4].Text = "<a href="mailto:" + e.Row.Cells[4].Text + "">" + e.Row.Cells[4].Text + "</a>";
}
//Birthday highlight
if (e.Row.Cells[6].Text != " ")
{
DateTime dt = Convert.ToDateTime(e.Row.Cells[6].Text);
DateTime now = DateTime.Now;
if (dt.Day == now.Day && dt.Month == now.Month)
{
e.Row.Cells[6].BackColor = System.Drawing.Color.FromArgb(255, 230, 160);
}
}
}
}
I use this event to customize the display of certain fields, as well as hide columns that are not pplicable during some search types. When I disable the event, the ODS stops binding twice. I can't really think of a way to get around this behavior. Has anyone else see this issue or developed a work around?
CheckPara is my OnDataBinding procedure SqlDataSource1 is ObjectDataSource (it's only confusing name)
Language is Nemerle, but if you know C# you can read it easy
protected virtual CheckPara(_ : object, _ : System.EventArgs) : void
{
foreach(x is Parameter in SqlDataSource1.SelectParameters)
when(x.DefaultValue=="") //Cancel binding
}
so how can I cancel binding when there is not fully configurated ObjectDataSource ? Or... how can I run binding only when I done with all parameters ?
I want to bind an ObjectDataSource to a property in my asp page and I want to do it in the page's aspx code, not in code-behind. I've already done it in code-behind, as follows:
[Code]....
I'd prefer to get rid of the ugly code-behind and just do this in mark-up. Something like
[Code]....
This gives me a run-time error: Cannot create an object of type 'System.Object' from its string representation 'SelectedBook' for the 'DataSource' property.Is there a way of doing this declaratively and not in code-behind? Further, what if what I want is to actually use a child property of the property in question? For example, if my Book object has a ReaderComments collection, can I databind to it decaratively in the aspx mark-up?
I have a gridview databound to an objectdatasource. Everything worked great until I changed 2 columns from asp:BoundField to asp:TemplateField. These are the UPC column and the Part column. I wanted to show a link button for each of these fields that take the user to another page. Now asp.net expects these two fields to be parameters on the update store procedure. Why is this? How do I get it to not assume these columns need to be passed to the store procedure?
Here is the code for the grid view:
[code]....