my question is that I need to show a tab two times in my web page ,,, each time this tab will be showed it will have different data will be called from a database while the page loaded >>>> when I use my code I can show the tab one time only
I will insert my code here look at it and tell me where the error
[code]...
I have sqldatabase tables.I am reading table data and putting in a tabconatiner(wth tabs containing textbox, checkbox etc) specific to a client. If a client has more than one row i want to iterate through the rows and read each row data. Basically I want to use a button-click to read the next row data at put it in the tabs and so on. I used sqldatareader and a while loop.I can read the data but while loop iterates through the rows and show the last row data / i want to use a button to go to the next row and show data.
SqlDatareader reader=null;
reader=cmd.ExecuteReader();
while(reader.Read())
{
txtboxName.Text=reader["Name"].ToString();
}
protected button_Click(Object sender,EventsArgs e)
{
//I want to read row data in this button click
}
I have a formview and within it I have a dropdown list which brings back a list of value from my database,
View 2 RepliesI have this grid view
[Code]....
The first page show up just fine, when i try to go to the second page of the GV i get this errorThe GridView 'GVCreditMemos' fired event PageIndexChanging which wasn't handled.
I'm trying to follow this article on cascading dropdown list in a GridView control in edit mode (except I'm using C#) [URL] I keep getting this error message "ProjectID is neither a DataColumn nor a DataRelation for table DefaultView."
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if ((e.Row.RowState & DataControlRowState.Edit) == DataControlRowState.Edit)
{
DataRowView dv = (DataRowView)e.Row.DataItem;
//// Preselect correct value in Projects list
DropDownList listProjects = (DropDownList)e.Row.FindControl("DropDownList1");
listProjects.SelectedValue = dv["ProjectID"].ToString(); // *****************this is where I get the error *********
// Databind list of categories in dependent drop-down list
DropDownList listCategories = (DropDownList)e.Row.FindControl("DropDownList2");
SqlDataSource dsc = (SqlDataSource)e.Row.FindControl("sdsDDL2");
dsc.SelectParameters["ProjectName"].DefaultValue = dv["ProjectName"].ToString();
listCategories.DataBind();
listCategories.SelectedValue =(dv["CategoryID"].ToString());
}
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ttuser %>" SelectCommand="SELECT
TE.TimeEntryID,
P.ProjectName,
CAT.CategoryName,
TE.TimeEntryDescription,
TE.TimeEntryDuration,
TE.TimeEntryDate
FROM dbo.aspnet_starterkits_TimeEntry TE inner join
dbo.aspnet_starterkits_ProjectCategories CAT on
TE.CategoryID=CAT.CategoryID inner join
dbo.aspnet_starterkits_Projects P on
CAT.ProjectID=P.ProjectID
Where TimeEntryUserID=(SELECT UserId FROM dbo.aspnet_Users WHERE
UserName=@UserName) AND
TE.TimeEntryDate=@WeekEnding
" OldValuesParameterFormatString="original_{0}" UpdateCommand="UPDATE dbo.aspnet_starterkits_TimeEntry
SET
TimeEntryDescription=@TimeEntryDescription,
TimeEntryDuration=@TimeEntryDuration,
TimeEntryDate=@TimeEntryDate
WHERE
TimeEntryID=@original_TimeEntryID">
<SelectParameters>
<asp:ControlParameter ControlID="UserList" Name="UserName"
PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="WeekEnding2" Name="WeekEnding"
PropertyName="Text" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="TimeEntryDescription" />
<asp:Parameter Name="TimeEntryDuration" />
<asp:Parameter Name="TimeEntryDate" />
<asp:Parameter Name="original_TimeEntryID" />
</UpdateParameters>
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" BorderWidth="0px"
BorderStyle="None" Width="100%" CellPadding="2" PageSize="25"
DataKeyNames="TimeEntryID" onrowdatabound="GridView1_RowDataBound"
onrowupdating="GridView1_RowUpdating" >
<Columns>
<%--<asp:CommandField ShowEditButton="True" />--%>
<asp:BoundField DataField="TimeEntryID" HeaderText="ID"
SortExpression="TimeEntryID" InsertVisible="False" ReadOnly="True"
ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:TemplateField HeaderText="Project" SortExpression="ProjectName">
<EditItemTemplate>
<asp:DropDownList
ID="DropDownList1"
runat="server"
DataSourceID="sdsDdlProjectsEdit"
DataTextField="ProjectName"
DataValueField="ProjectID"
AutoPostBack="True"
onselectedindexchanged="DropDownList1_SelectedIndexChanged">
</asp:DropDownList>
<asp:SqlDataSource
ID="sdsDdlProjectsEdit"
runat="server"
ConnectionString="<%$ ConnectionStrings:ttuser %>"
SelectCommand="SELECT ProjectID,ProjectName FROM dbo.aspnet_starterkits_Projects">
</asp:SqlDataSource>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("ProjectName") %>'></asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Category" SortExpression="CategoryName">
<EditItemTemplate>
<asp:DropDownList
ID="DropDownList2"
runat="server"
DataSourceID="sdsDDL2"
DataTextField="CategoryName"
DataValueField="CategoryID">
</asp:DropDownList>
<asp:SqlDataSource
ID="sdsDDL2"
runat="server"
ConnectionString="<%$ ConnectionStrings:ttuser %>"
SelectCommand="SELECT CategoryID,CategoryName FROM dbo.aspnet_starterkits_ProjectCategories WHERE ProjectID=@ProjectID">
<SelectParameters>
<asp:Parameter Name="ProjectID" />
</SelectParameters>
</asp:SqlDataSource>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("CategoryName") %>'></asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:BoundField DataField="TimeEntryDescription" HeaderText="Description"
SortExpression="TimeEntryDescription" ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:BoundField DataField="TimeEntryDuration" HeaderText="Hours"
SortExpression="TimeEntryDuration" ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:BoundField ApplyFormatInEditMode="True" DataField="TimeEntryDate"
DataFormatString="{0:d}" HeaderText="Week Ending"
SortExpression="TimeEntryDate" ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:CommandField ShowEditButton="True" HeaderText="Edit" ButtonType="Image" EditImageUrl="images/icon-edit.gif"
UpdateImageUrl="images/icon-save.gif" CancelImageUrl="images/icon-cancel.gif" />
</Columns>
</asp:GridView>
I have a datalist menu that has several menuitems in it(each item load user control).I want to show each menuitems in seperate dynamic Ajax tabs when I click on first item tab is created but when I click on second menuitem to create second dynamicajax tab I faced this error:
[Code]....
[Code]....
I want to update the data using vb.net , my webpage has many dropdownlistlist ,
I got an error when update the dropdown field ,
"Dropdownlist error: SelectedValue which is invalid because it does not exist in the list of items."
I need to show a tab two times in my web page ,,, each time this tab will be showed it will have different data will be called from a database while the page loaded >>>> when I use my code I can show the tab one time only
I will insert my code here look at it and tell me where the error
[Code]....
code behind is as follow:
[Code]....
I have a many to many table in my database called PeopleLanguage
PeopleId, pk and Languags pk each go to the own table People and Language
I know make a method call with my objectdatasource GetPeopleByLanguageId
This returns the languages that the selected person speaks and has a select
query also to lanaguageTable to get LanguageName.
I now print out the results in a datalist that is binding to LanguageName.
What i want to do is show the languages in a horizontal format with a comma after each one.
At the moment if there are 3 languages it shows each one on a seperate line / if I make it horizontal
layout I still dont get a comma. Perhaps I can use a repeater?
I have drop down list box that I would like to show two columns, is this possible? Or can it be done with a list box?The query correctly retrieves all of the table data to be displayed, one colum is an abbreviation, the other a bit longer description.
View 2 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 a databound dropdownlist and have a problem with the default value it selects.When I attempt to edit a record the dropdownlist shows the first value in the list rather than the current value. I want the dropdown list to display the current value.
I'm sure this is very simple but I'm very new to ASP.NET.
I'm using .NET version 4.
I am able to export multiple gridviews in a single excel worksheet
My question is can I separate these gridviews in multiple tabs under the same excel file ?
This is my current method under the link button
[Code]....
The List Page display child Entity using the gridview each row will have link to the parent
How can I change the link so it shows the parent but in list view(using list.aspx) not detailes (detailes.aspx)view
I am bindibg data to a grid and in my asp page I have the following asp:HyperLinkField:
asp:HyperLinkField
DataNavigateUrlFields="serialno"
DataTextField="serialno"
HeaderText="serialno" DataNavigateUrlFormatString="DeviceDetails.aspx?serialno={0}"
/>
This is working perfectly, but when I add a second parameter to the querystring it does not work anymore:
DataNavigateUrlFormatString="DeviceDetails.aspx?serialno={0}&id={1}"This
I get the following error during DataBind to a grid: [System.FormatException] = {"Index (zero based) must be greater than or equal to zero and less than the size of the argument list."} What does this mean? Is {1} not a string or is it because of something else?
I am using list view to display the the data but i am getting an error like An item placeholder must be specified on ListView 'ListView1'. Specify an item placeholder by setting a control's ID property to "itemPlaceholder". The item placeholder control must also specify runat="server.Even i have specified the itemplaceholder id but no use still same error.
[Code]....
I'm trying to build a chart in my application which will act as a client for an ASP.NET 3.5 web service that I created. The error I get is as follows:
Series data points do not support values of type System.Data.DataViewManagerListItemTypeDescriptor only values of these types can be used: Double, Decimal, Single, int, long, uint, ulong, String, DateTime, short, ushort.
I've tried various ways to resolve this but can't. This error points at the
chtStats.DataBind() line in the code below:
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
I am in need of getting the correct sysntax for being able to use paging with a datalist whose data is being generated by a SQL Datasource and a stored procedure inside the aspx(asp.net VB...Not C#) page. A Gridview or any other rigid control that does not allow full control and layout will not work so I have to use the datalist. I have the datalist working perfectly but I need to add paging. I did some searching and found a good solution. It was a C# solution, in particular the code behind syntax so I used a code converter to convert it to VB. However, as I am not an experienced coder I need help converting the portion for handling the datalist. I am fairly confident I have the buttons on the aspx page worked out. I will ask that if you se something I need to do besides the section(5) I have listed please offer suggestions. So that you can help me better I have boken the code out into sections where I'm listing the code I copied, my code and the section I need help with. I think at a minimum I will have to change the references of Repeater to Datalist.
The section I need help with is section 5 where the original autor is referencing items generated in the Repeater where he used XML. As I said I'm using a SQL Datasource with a Datalist so I truly don't understand what I need to change to get the code behind to work with my Datalist. As always I appreciate all of you guys and ladies help. And also as always I will ask to please provide the actual code to type in because telling me how to do it just won't help very much. Sorry about that.
Here is what I have:
SECTION 1 - The buttons to handle the paging
*******************************************
<td> <asp:label id="lblCurrentPage" runat="server"></asp:label></td>
</tr>
<tr>
<td> <asp:button id="cmdPrev" runat="server" text=" << " onclick="cmdPrev_Click"></asp:button>
<asp:button id="cmdNext" runat="server" text=" >> " onclick="cmdNext_Click"></asp:button></td>
</tr>
********************************************
SECTION 2 - 4Guys repeater reading an XML file
*********************************************
<table border="1">
<asp:repeater id="repeaterItems" runat="server">
<itemtemplate>
<tr>
<td> <b><%# DataBinder.Eval(Container.DataItem, "ItemName") %></b></td>
<td> <b><%# DataBinder.Eval(Container.DataItem, "ItemDescription") %></b></td>
<td> <b><%# DataBinder.Eval(Container.DataItem, "ItemPrice") %></b></td>
<td> <b><%# DataBinder.Eval(Container.DataItem, "ItemInStock") %></b></td>
</tr>
</itemtemplate>
</asp:repeater>
</table>
*********************************************
SECTION 3 - My datalist control.
********************************************
<asp:DataList ID="DataList1" runat="server" DataKeyField="eid"
DataSourceID="SqlDataSource1">
<ItemTemplate>
<table cellpadding="0" cellspacing="0">
<tr>
<td>
</td>
</tr>
<tr>
<td>
<table cellpadding="0" cellspacing="0" width="600px">
<tr>
<td valign="top">
<table cellpadding="0" cellspacing="0">
<tr>
<td>
<b>Name</b></td>
</tr>
<tr>
<td>
<asp:Label ID="nameLabel" runat="server" style="font-size: 7pt"
Text='<%# Eval("name") %>' />
</td>
</tr>
<tr>
<td>
<b>Description</b></td>
</tr>
<tr>
<td>
<asp:Label ID="exDescriptionLabel" runat="server" style="font-size: 7pt"
Text='<%# Eval("exDescription") %>' />
</td>
</tr>
<tr>
<td>
<b>Workout Notes</b></td>
</tr>
<tr>
<td>
<asp:Label ID="notestipLabel" runat="server" style="font-size: 7pt"
Text='<%# Eval("notestip") %>' />
</td>
</tr>
<tr>
<td>
<b>Base Workout</b></td>
</tr>
<tr>
<td style="font-size: 7pt">
<asp:Label ID="broutineLabel" runat="server" Text='<%# Eval("broutine") %>' />
</td>
</tr>
<tr>
<td>
<b>Major Bodypart</b></td>
</tr>
<tr>
<td style="font-size: 7pt">
<asp:Label ID="bodypartmgLabel" runat="server"
Text='<%# Eval("bodypartmg") %>' />
</td>
</tr>
<tr>
<td>
<b>Target Bodypart</b></td>
</tr>
<tr>
<td style="font-size: 7pt">
<asp:Label ID="bodypartspecificLabel" runat="server"
Text='<%# Eval("bodypartspecific") %>' />
</td>
</tr>
<tr>
<td>
<b>Supporting Muscles</b></td>
</tr>
<tr>
<td>
<asp:Label ID="secondary_areasLabel" runat="server"
Text='<%# Eval("secondary_areas") %>' />
</td>
</tr>
</table>
<b>
<br />
</b>
</td>
<td valign="top">
<asp:HyperLink ID="HyperLink31" runat="server"
ForeColor="White"
ImageUrl='<%# Eval("videoplay") %>'
OnClick='<%# String.Format("return popIt({0})", Eval("eid")) %>'
NavigateUrl='<%# String.Format("~/player2010.aspx?eid={0} ", Eval("eid")) %>'
Text='<%# Eval("ddupdateworkout") %>'>
</asp:HyperLink>
</td>
<td valign="top">
<table>
<tr>
<td>
<table align="left" cellpadding="0" cellspacing="0">
<tr>
<td>
</td>
<td style="text-align: center">
<asp:Image ID="Image1" runat="server" ImageUrl='<%# Eval("modelImage") %>' />
</td>
</tr>
<tr>
<td>
</td>
<td style="text-align: center">
<asp:Label ID="modelNameLabel" runat="server" Text='<%# Eval("modelName") %>' />
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
</td>
</tr>
<tr>
<td>
<asp:HyperLink ID="HyperLink1" runat="server" ForeColor="White"
NavigateUrl='<%# String.Format("~/favorites_addexercise.aspx?eid={0}&name={1}&exercateg={2}&bodypartmg={3}&bodypartspecific={4}&demolink={5} ", Eval("eid"),
Eval("name"), Eval("exercateg"), Eval("bodypartmg"), Eval("bodypartspecific"), Eval("demolink")) %>'
Text='<%# Eval("addtofavorite") %>'></asp:HyperLink>
</td>
</tr>
<tr>
<td>
<asp:HyperLink ID="HyperLink30" runat="server" ForeColor="White"
NavigateUrl='<%# String.Format("~/workouts_create.aspx?eid={0} ", Eval("eid")) %>'
Text='<%# Eval("ddnewworkout") %>'></asp:HyperLink>
</td>
</tr>
<tr>
<td>
<asp:HyperLink ID="HyperLink2" runat="server" ForeColor="White"
NavigateUrl='<%# String.Format("~/workouts_saved_addexer.aspx?eid={0} ", Eval("eid")) %>'
Text='<%# Eval("ddupdateworkout") %>'></asp:HyperLink>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table cellpadding="0" cellspacing="0">
<tr>
<td>
</td>
</tr>
<tr>
<td>
</td>
</tr>
</table>
</td>
<td>
</td>
<td>
<table cellpadding="0" cellspacing="0">
<tr>
<td>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<br />
<br />
</ItemTemplate>
</asp:DataList>
********************************************
SECTION 4 - Public Property CurrentPage() As Integer
Get
' look for current page in ViewState
Dim o As Object = Me.ViewState("_CurrentPage")
If o Is Nothing Then
Return 0
Else
' default to showing the first page
Return CInt(o)
End If
End Get
Set
Me.ViewState("_CurrentPage") = value
End Set
End Property
Private Sub Page_Load(sender As Object, e As System.EventArgs)
' Call the ItemsGet method to populate control,
' passing in the sample data.
ItemsGet()
End Sub
SECTION 5 - NEED HELPING IN CHANGING TO WORK WITH DATA LIST
***************************************************
Private Sub ItemsGet()
' Read sample item info from XML document into a DataSet
Dim Items As New DataSet()
Items.ReadXml(MapPath("Items.xml"))
' Populate the repeater control with the Items DataSet
Dim objPds As New PagedDataSource()
objPds.DataSource = Items.Tables(0).DefaultView
objPds.AllowPaging = True
objPds.PageSize = 3
objPds.CurrentPageIndex = CurrentPage
lblCurrentPage.Text = "Page: " & (CurrentPage + 1).ToString() & " of " & objPds.PageCount.ToString()
' Disable Prev or Next buttons if necessary
cmdPrev.Enabled = Not objPds.IsFirstPage
cmdNext.Enabled = Not objPds.IsLastPage
repeaterItems.DataSource = objPds
repeaterItems.DataBind()
End Sub
Private Sub cmdPrev_Click(sender As Object, e As System.EventArgs)
' Set viewstate variable to the previous page
CurrentPage -= 1
' Reload control
ItemsGet()
End Sub
Private Sub cmdNext_Click(sender As Object, e As System.EventArgs)
' Set viewstate variable to the next page
CurrentPage += 1
' Reload control
ItemsGet()
End Sub
when i am selecting an item in dropdown list datasource is bind and after another selection it is bind again .but i want it bind only once.
View 4 Repliesi 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??
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()
Basically I want to populate a drop down list with time slots for a user to select. If the time slot is already recorded in the database table I want to skip that one so it doesn't display as a selection in the drop down list.
So my drop down list looks like;
[Code]....
And then I have setup a datasource (even though I may get rid of it to bind in the code behind file)
[Code]....
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 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 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?