i wanted to retrieve things from the data base and perform mathmatical operations on it then post it to the user, so i was told to use the bullited list and bind it to the object dataSource
how to perform such thing??
I am trying to create FormView that has details aboout author. But some details about his books like pubdate, title resides in some other table. In the source page:
<asp:Label id"AuthorName" Text='<% #Bind("au_fname")%>' runat="server/>
but this field has to be obtained from other table:
<asp:Label id="AuthorTitle" Text='<% #Bind("title")%>' runat="server"/>
the title resides in titleauthor table, can we use two connections(author, titlesauthor) simultaneously.
I have extended GridView in order to have consistent look & feel, paging and sorting. However, when the page is first time loaded, the select method is getting called twice. It works fine when i move between pages in pagination.
Note, i am using Asp.net 2.0.
I populate a DetailsView from an ObjectDataSource that is coded in a class - meaning that the ods Select, Update, Insert and Delete are class methods. The selected record is set to come from a GridView.SelectedValue.
My problem is that when the page loads the code crashes. I am pretty sure I know why: the DetailsView is pulling from a class object and instead of using the existing class object it instansiates a new one which is empty.
Here is the details view code:
[Code]....
Here is the odsDetailsView_1:
[Code]....
As you can see from the code the odsDetailsView gets it's information from a class object "Match". The detailsview is not controlled by any code behind.
I have the web page that meet the problem. There exists a gridview and filtering. When Select all by using function A, it is OK. when Filter by using function B, it cannot filter and return no rows. When Select all again, it is OK. I have tested that function B can return the corrected filtered rows. But when databind in the web page, it cannot show and no error?
<ContentTemplate>
<asp:GridView ID="gvwBOM" runat="server" DataKeyNames="ProductID"
AutoGenerateColumns="False" DataSourceID="objBOM" AllowPaging="True"
AllowSorting="True" BorderWidth="0px" CellPadding="3" CellSpacing="1" CssClass="grid-view"
OnRowCreated="gvwBOM_RowCreated"
OnRowCommand="gvwBOM_RowCommand"
OnDataBound="gvwBOM_DataBound" >
.........
<asp:ObjectDataSource ID="objBOM" runat="server"
SelectMethod="GetALTBOMs"
SelectCountMethod="GetALTBOMsCount"
EnablePaging="true"
SortParameterName="SortExpression"
TypeName="QI.BLL.WMS.ALTBOM" >
private void FillGridView(string filter)
{
if(filter == "0")
{
objDataSourceSelect="Afunction";
this.objBOM.SelectParameters.Clear();
}
else
{
objDataSourceSelect="Bfunction";
this.objBOM.SelectParameters.Clear();
this.objBOM.SelectParameters.Add("productSupplimentID", ddlTmp.SelectedValue);
}
this.objBOM.SelectMethod = objDataSourceSelect;
this.objBOM.SelectCountMethod = objDataSourceSelect + "Count";
this.gvwBOM.DataBind();
}
i made a small n-tier webapplication, a DATA project with my business objects a DA project with my datacces logic and a GUI project woth my website. For the CRUD operations on my main tables I use a lot of listviews, that works fine but when data grows its slows down.I used already used optimal paging & shared collection's to preventing database acces if data is already loaded en that helps alot.But I see when a user select the EDIT command the select of my listview is performed what is not needed, also when the user than select cancel the select is again called , is this normal behavior or do I made a mistake in program logic somewhere because this behavior is slowing my application down.
View 1 RepliesI have a situation where I want to show the selected records out of total records for a product of an employee
1) There is a checkbox list bind to <List> of objects from object datasource (For total items in list)
2) Now I want to check the selected items for a particular record in this list
3) For this purpose I have another list of <List> selected items returned by data access layer (For selected items for that employee )
4) How do I bind the selected objects with the total items list ?
5) In spaghetti coding model it was all too easy just by binding the checkbox list with a sql data source and running a for each on form load
I have got the following code:
[Code]....
This should give me the friends of the user currently logged in in the Repeater, but gives me an exception on the runtime that an instance needs to be initialized, can you please suggest a solution...
Also, what should be the value of the NavigateUrl property of a Hyperlink in an ItemTemplate if the url is:
"http://domain.com/viewprofile.aspx?id=" + 'THE UserID property of the current element in the list'
I am having a button inside a datagrid and in the button content i have placed a image.I tried to change the souce of the image from datagrid list but the image is not binding. I used MVVM Model .
View 2 Replies[Code]....
I am getting error of in Foreach loop
[Code]....
How to resolve this situation or any other alternative to cum out of this problem.
datalist not bind when i click asign classs button then enter some value and save.. datalist is bind when i click free class button then enter some value and save ... data list is not bind and show show that record...but it will save in database
why data list is not bind in free class button?
i bind through datalist.databind()
i m unable to bind data inside checkbox list. this is my code
protected void dlBreeds_ItemDataBound(object sender, DataListItemEventArgs e)
{
try
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
CheckBoxList cbl = e.Item.FindControl("cblAnimaltype") as CheckBoxList;
if (cbl != null)
{
cbl.DataTextField = DataBinder.Eval(e.Item.DataItem, "BGName").ToString();
cbl.DataValueField = DataBinder.Eval(e.Item.DataItem, "ID").ToString();
}
}
}
catch (Exception ex)
{
pnlStatus.Visible = true;
lblMessage.Text = ex.Message.ToString();
}
}
protected void BindAnimals()
{
//*********************************************************************************
// Purpose : To bind breeds in listbox
// Inputs : Nothing
// Returns : Nothing
//*********************************************************************************
DataSet ds = new DataSet();
try
{
ds = InvertebrateProviders.GetBreedsName_Invertebrate(1);
if (ds.IsInitialized)
{
DataView dv = ds.Tables[0].DefaultView;
dv.RowFilter = "ID<>0";
dlBreeds.DataSource = dv;
dlBreeds.DataBind();
}
}
catch(Exception ex)
{
pnlStatus.Visible = true;
lblMessage.Text = ex.Message.ToString();
}
}
<asp:DataList id="dlBreeds" runat="server" DataKeyField="BGName" OnItemDataBound="dlBreeds_ItemDataBound" RepeatDirection="Vertical">
<ItemTemplate>
<asp:Panel ID="pnbBreed" BorderColor="#7f9db9" Height="129px" Width="220px" ScrollBars="Vertical" BorderWidth="1px"
BorderStyle="solid" runat="server" Visible="true">
<asp:CheckBoxList ID="cblAnimaltype" DataTextField='<%#Eval("BGName") %>' DataValueField='<%#Eval("ID") %>' AutoPostBack="True" runat="server" Height="129px" CellPadding="0" CellSpacing="0"
OnSelectedIndexChanged="cblAnimaltype_SelectedIndexChanged" Width="200px" >
</asp:CheckBoxList></asp:Panel>
<asp:CheckBoxList ID="cblBreeds" Height="90px" Width="200px" runat="server" ></asp:CheckBoxList>
</ItemTemplate>
</asp:DataList>
I would like to bind a multi domensional arry to a data control (at the moment any data control will do - I just want to present the data).
suppose I have the following array:
string[,] strArr = new string[5,3];
strArr[0,0] = "0,0";
strArr[0, 1] = "0,1";
strArr[0, 2] = "0,2";
strArr[1, 0] = "1,0";
strArr[1, 1] = "1,1";
strArr[1, 2] = "1,2";
strArr[2, 0] = "2,0";
strArr[2, 1] = "2,1";
strArr[2, 2] = "2,2";
strArr[3, 0] = "3,0";
strArr[3, 1] = "3,1";
strArr[3, 2] = "3,2";
strArr[4, 0] = "4,0";
strArr[4, 1] = "4,1";
strArr[4, 2] = "4,2";
can you provide an example of how to dind this array to any of the standard data controls?
I am attempting to bind data from a dropdown list that was populated from another datasourceID. I've bolded what I believe is relevant to this issue in the code below. But basicly its binding the proper county on the pull down menu but when I hit form submit it dosnt postback that info instead its null.
[code]....
This is my query
EXEC sp_configure 'show advanced options', 1
RECONFIGURE
GO
EXEC sp_configure 'ad hoc distributed queries', 1
RECONFIGURE
GO
insert into OPENROWSET( 'Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;
Database=D:TestDBFirst.xls;;HDR=YES',
'SELECT * FROM [Sheet1$]')
select * from MasterData
And this error comes
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error".Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
how to bind video object to gridview.
i have tried this
<asp:Label ID="lblAns" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "Answer")%>'></asp:Label>
but it is not working.
I am developing on application in that i have taken one list box and getting data to it using an object source.up to this stage it is fine.I need to compare these value what i get into list box and need to represent data in to a report viewer ..how to get these values from objectsource.i m new to c# i placing the code.
[Code]....
If I have a list of contacts List<Contact> and a Contact object has an Office object property, I want to display a grid with columns
Contact Id, First Name, Last Name, Office Name
Where the sources of the above columns are respectively:
Contact.ContactId, Contact.FirstName, Contact.LastName, Contact.Office.OfficeName
I'm fine with binding the first 3, but was wondering whether I can bind the OfficeName using either Bind or Eval or whether I need to hook into the events and set the value there.
I need to bound GridView and List and I am having some problems and need help, couldn't figure out what's wrong.My object is this:
[Code]....
So i need to show this in gridview if possible
i hv a list box contain three items say ram,rajeev and suresh.i hv to bind their ages in single grid view in the fomat
i hv a table child with fields name and age
name age
ram 5
rajeev 1
suresh 10
I have an object data source that is being used by an rdlc report, and the object data source uses a filter that is built from session variables passed to the page.
The report displays correctly, with the filter applied; however, I want to mark each of the rows as "printed" in a bit field in the database table.
In the table adapter, I have the following Update command that is used by the object data source:
UPDATE dbo.WorkOrder
SET boolWorkOrderPrinted = 'True'
WHERE (WorkOrderID = @Original_WorkOrderID)
And in the Page Load event, I run:
ObjectDataSource1.Update();
However, no records are updated.
I have a List<HybridDictionary> _Reasons.
I need to bind the list to a dropdown.
I tried the code as try
{
this.ddlReason.DataSource = _Reasons;
ddlReason.DataValueField = "Key";
ddlReason.DataTextField = "Value";
this.ddlReason.DataBind();
}
catch
{
//Log Entry
}
finally
{
}
But it not work.
when bind list of strings to listview , what value needs to supply for Datakey or what should be done so ListViewUpdateEventArgs.newValues in ItemUpdating event can be accessed without empty?
[Code]....
Is it possible to bind two separated datasources to one dropdown list such that they are both alphabetically sorted and seprated by some sort of line. I know there is a way to insert elemets manually, but I'm not sure of the 2 separate datasources. I've serached this forum and while there were several posts none of them offered any workable solution.
View 5 RepliesTraditionally with an Object Data Source, the wired up class will have its public properties available for binding (i.e. Gridview columns, etc.) which works well. But what if one of my wired up business objects has a property that is an object itself; can I drill down to a property on that object property and still use it?
So in additiona to the traditional:MyBusniessObject.OrderID...I want to use:MyBusniessObject.Customer.NameID
Your 1st response might be to just wire up the 'Customer' class, but I need properties both on 'MyBusinessObject'and 'Customer'. I do not think this can be done, as the ODS will not display properties on an object instance property. I have tried manually typing in the drilled down value as well, but that wasn't a success either.