profile provider stores profile datas in aspnet_profiles table fields format something like :
propertynames:ActiveRole:S:0:5:MobilePhone:S:5:6:JobAddress:S:11:3:HomeAddress:S:14:48:HomePhone:S:62:6:LastName:S:68:6:FirstName:S:74:9:
propertyvaluesString:Roles546456xcvxvxcvxcvxcvxvxc vxcvxcvxv xvxcvxcv xcvxcvxc546456546456546546456
I have a datalist which shows a username.i want to find the usernames profile.firstname and display it in a label.i have tried doing this with this code, but i get object not set error..:
protected void Page_Load(object sender, EventArgs e)
{
Label Label1 = (Label)DataList1.FindControl("Label1");
Label theiruseridLabel = (Label)DataList1.FindControl("theiruseridLabel");
[code]...
I try to pass two parameters to code behind
Into gridview
Visible='<%# Show(DataBinder.Eval(Container, "DataItem.Id").ToString()) %> + <%# MostrarBotonBorrar(DataBinder.Eval(Container, "DataItem.Rol").ToString()) %>'
in codeBehind:
public bool Show(string value,string value2)
{
if(value == LbluserInvisible.Text)
{
return true;
}
else
{
return false;
}
}
I have a gridview where I already have a select link which takes me to different page. I want one more link which will take me to a separate page.
View 7 RepliesI have gridview which takes data from storedprocedure with some in parameters.
How to change storedprocedure in parameter values for sqldata source and update gridview on button click?
I have a gridview and I have an edit template for one control. I have a drop down box in this edit template so that you can select a value from it and then when you hit 'Update' the value from the drop down box is committed to the updated record. Unfortunately when I do hit the update button I get a fault that the "Status" field cannot be null.
Here is the code that picks the value from the drop down value and assigns it to the new values list:
[Code]....
Im populating gride using sql datasource. I have assigned email to lable using "eval".
I have another datalist control on same page which im populating using another sql datasourse. Now fro this the condition will be where email = email which I have assigned to label in above gride.
I have added a gridview in my aspx web page. I have added a hyperlink field, to navigate to another page from the gridview. I am getting the error as:
"There was an error rendering the control.
Index(zero based) must be greater than or equal to zero and less than the size of the argument list. "
This is the code i have used:
[Code]....
[Code]....
When i remove the hyperlink, the grid is getting displayed. I know, there is something wrong i have coded in the DataNavigateURLformatstring, but not sure what is wrong.
I want to pass the StudentID,CourseID,ChildImageID with the link as the querystring.
I have a asp.net gridview control on my page with several fields and a couple of command fields. However, the update command is giving me problems.
Here is what works. The update command works provided I put straight text into the textboxes that appear. I even have one field that contains a dropdown list which works fine.
Here's the problem. I have two fields that need to access their value programmatically. These fields will reflect the current datetime and the current loggedin user from active directory. I have already created public strings in the C# code.
When I run the edit command on the asp form the grid uses one "DataKeyNames" element. With this the grid can update the selectedrow. However, I haven't been able to access it programmatically in the C# code. I can access the selectedrow in the "selectedindexchanged" event but then I am not able to update my fields in the gridview itself. So, part one of my question is how to I access the "DataKeyNames" properties of a gridview control.
if I can't access the "DataKeyName" property perhaps I could set the label nested within the gridview to the "myCurrentUser()" public string. I am inserting my code to hopefully make this clearer.
i've got a gridview and sql datasource. Its connected to a stored proc that has four optional parameters. In VS when i set up the data source, if i use the test option, and dont supply any values for the sproc, it returns all the values in the table which is what it should do. Now when i try to fill the gridview, it wont return anything at all unless i provide values for all 4 parameters.
It's not even trying to search because i had sql profiler open and nothing shows up until i provide all 4 values. any idea why it's doing this? How do i get it to actually bind even if provide less then all 4 (or none) of the values?
I Have a gridview where I have a link to a details page and I need to pass multiple parameters. I currently have the following:
<Columns>
<asp:BoundField DataField="AssocID" HeaderText="AssocID" InsertVisible="False"
ReadOnly="True" SortExpression="AssocID" />
<asp:BoundField DataField="FirstName" HeaderText="First Name"
SortExpression="FirstName" />
<asp:BoundField DataField="MiddleInitial" HeaderText="M. I."
SortExpression="MiddleInitial" />
<asp:BoundField DataField="LastName" HeaderText="Last Name"
SortExpression="LastName" />
<asp:BoundField DataField="State" HeaderText="State" SortExpression="State" />
<asp:BoundField DataField="EMail1" HeaderText="EMail 1"
SortExpression="EMail1" />
<asp:BoundField DataField="AddrType" HeaderText="Addr Type"
SortExpression="AddrType" />
<asp:HyperLinkField DataNavigateUrlFields="AddrID,AssocID"
DataNavigateUrlFormatString="Details.aspx?AddrID={0}&AssocID={1}" HeaderText="Details"
Text="Details" />
<asp:BoundField DataField="AddrID" HeaderText="AddrID" InsertVisible="False"
ReadOnly="True" SortExpression="AddrID" Visible="False" />
</Columns>
According to all I have read my DataNavagateUrlFields string should work but it isn't. The deal is that any one (AssocID) can have multiple AddrID's associated with it. Regardless of which I choose I only get back the first AddrID for that AssocId.
I'm trying to allow my users to select a record from their list of attendees and edit it using a details view positioned below the GridView. The issue I'm having is when I run the code I get my error message and no data is displayed in the DetailsView. Error Message is:
DataBinding: 'System.Data.Common.DataRecordInternal' does not contain a property with the name '10002'.
[Code]....
I have done this with a DropDownList but not 2 text boxes that require date info.
With the DropDownList once a itme is selected from the list the GridView gathers the data in a SQL query and displays it in the same page
I want to have the same type of response when the user enters date data in two text boxes. It would be nice that when they exit the 2nd parameter box to show the grid.
Not sure how to do that in SelectParameters and convert the text data to a date.
I am going to use RequiredFieldValidtors but I am not sure what to do to make sure a valid date is entered.
I am extremely new to ASP and just started learning. I want to know which is better between Datalist, Gridview or Listview if I need paging and sorting functionality? This is what I have so far.
I've tried Datalist but I am having trouble with the paging portion. I've tried gridview and listview and got the paging to work but for some reason, when I click on Pg 2, it refreshes the search or something and what was shown on Pg 1 would appear again on Pg 2.
I am going to have a page that list an (image, description, category) this needs to be an editable list (the user should be able to edit description or select a cateogry from a dropdown or delete the whole image). lets say I need to display 20 rows per page.here are my questions:1) should I use datagrid, gridview or datalist?2) would PagingBulletedList works well with any of the above control3) when I go to the database to get the rows , since i am going to have 20 items per page should I just bind the control with all the rows or should I just display the first 20 items and when the user click page 2 i go to the database to bring the second set of 20 items?
View 2 RepliesI want to show just the first row or the datalist although datareader returns x number of rows. I need to use it for printing so is it possible to get x number of wors from the datareader and display just the first row hiding all other (it will make printingeasier)
[code]...
I am facing problem in doing paging.Below is my datalist and gridview coding:
Datalist:
<head runat="server">
<title></title>
</head>[code].....
i have a gridview and the delete option.
when i press delete button i want to run my stored procedure which requires an input variable. how can i do this?
I have downloaded the code 39 font to display barcode in my GridView or DataList. It shows the barcode with the numeric value under it. I only want to show the barcode. how to omit numeric value from barcode?
View 4 RepliesI have a webform that functions as a kind of a timesheet. The way it works now is that a user selects a project from a dropdownlist, the enters a date and the amount of hours worked. After that the user selects the link button "register" and the worked hours are registered and the result will be shown in a datalist (for each project a new one). Is there some possible way to show a user in advance all the projects he is authorized for in a datalist or so, so he can fill out the hours for all the projects at once? Now the selection for a project from the dropdownlist is a problem for some users cause they have a lot if projects and it is quit a workload on the manor now.
View 3 Replies am using a gridview, which is inside datalist, but whenever I try to serach gridview in datalist it reyurns NULL. I using the following code, bolded line is not able to assign gridview:
amespace DataListXML
The problem is that i have a search page. Access Database holding the information. I have a Access Datasource on the page with a Datalist to show the data. I need to find a way on setting it up to says "Sorry no results found" when the is no results. i am unsure on how to do this though.
Below is my datasource and datalist
[Code]....
I want to have a dropdownlist in the footer row of a gridview. The dropdownlist must be populated with an stored procedure that receives a parameter and has a select. Is that posible?? I think yes but I having problems with the parameters.
[Code]....
The exception says incorrect sintax... but I've changed the procedure for something very simple to solve the problem like select 'hello' or select 1, 'hello' and I'm getting the same problem...
I have a GridView and a DataList on the same page in a father/son relationship.I am trying to have the selected row on the GridView be in 'focus' on postback so if a person toward the bottom of the list is selected then the scroll position is maintained.I am trying to do the same with a DataList too.Heres my javascript.
[Code]....
and I have this around the GridView :
[Code]....
and this around the DataList:
[Code]....
The funny thing about this code is when I comment out the DataList portion, the GridView scroll postition works, when I comment out the GridView javascript portion the DataList scroll postion works.Is there a special way to make sure both of these can work or is it a javascript issue?
I'm new to web dev and c# so please bare with me. I am trying to create a dynamic gridview in a web form for users to to answer questions with (code below).
The dificulty im having is that i am nesting a dropdwonlist in the gridview and want to be able to dynamically set the list values based on parameters (of the row they are on). These values are in the main dataset for the gridview as each row represents a questionid and question text and then a ddl for the criteria...
I just don't know how to set the values for the dropdown all the code so far is below... just need to be able to populate the dropdowns with the relevant values.
I have created a stored proc to return the different criteria based on the questionid and questionGroupid which is the dataset that populates the other fields in the gridview: dbo.usp_QuestionCriteria @QuestionGroupId, @QuestionId
I have added this as a tableadapter called criteriaTableAdapter in a xsd file as well using the wizard... not sure if this is the right option though or just use the same method as i have for the other stored procedure as in the code below:
[CODE
]using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Sql"].ConnectionString);
con.Open();
SqlCommand com = new SqlCommand("usp_QuestionGroupDS", con);
com.CommandType = CommandType.StoredProcedure;
SqlDataAdapter ada = new SqlDataAdapter(com);
DataSet ds = new DataSet();
ada.Fill(ds);
for (int i = 0; i < ds.Tables.Count; i++)
{
if (ds.Tables[i].Rows.Count > 0)
{
GridView gvDynamicQuestion = new GridView();
gvDynamicQuestion.Width = Unit.Pixel(700);
gvDynamicQuestion.BorderWidth = Unit.Pixel(0);
gvDynamicQuestion.Caption = "<div id="nifty" class="QuestionGroup"> <b class="rtop"><b class="r1"></b><b class="r2"></b><b class="r3"></b><b class="r4"></b></b>" + ds.Tables[i].Rows[0]["Category"].ToString() + " Questions<b class="rbottom"><b
class="r4"></b><b class="r3"></b><b class="r2"></b><b class="r1"></b></b></div>";
gvDynamicQuestion.AutoGenerateColumns = false;
gvDynamicQuestion.ShowFooter = true;
TemplateField tf = null;
tf = new TemplateField();
tf.HeaderTemplate = new DynamicGridViewTextTemplate("QuestionId", DataControlRowType.Header);
tf.ItemTemplate = new DynamicGridViewTextTemplate("QuestionId", DataControlRowType.DataRow);
tf.FooterTemplate = new DynamicGridViewTextTemplate(DataControlRowType.Footer, ds.Tables[i].Rows.Count);
gvDynamicQuestion.Columns.Add(tf);
tf = new TemplateField();
tf.HeaderTemplate = new DynamicGridViewTextTemplate("Question", DataControlRowType.Header);
tf.ItemTemplate = new DynamicGridViewTextTemplate("Question", DataControlRowType.DataRow);
gvDynamicQuestion.Columns.Add(tf);
tf = new TemplateField();
tf.HeaderText = "Criteria";
tf.HeaderTemplate = new DynamicGridViewTextTemplate("Criteria", DataControlRowType.Header);
tf.ItemTemplate = new DynamicGridViewDDLTemplate();
gvDynamicQuestion.Columns.Add(tf);
////tf = new TemplateField();
////tf.HeaderText = "Criteria";
////tf.ItemTemplate = new DynamicGridViewDDLTemplate();
////gvDynamicQuestion.Columns.Add(tf);
gvDynamicQuestion.DataSource = ds.Tables[i];
gvDynamicQuestion.DataBind();
phDynamicGridHolder.Controls.Add(gvDynamicQuestion);
}
}
}
protected void DynamicGrid_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.Footer)
{
//
}
}
}
public class DynamicGridViewTextTemplate : ITemplate
{
string _ColName;
DataControlRowType _rowType;
int _Count;
public DynamicGridViewTextTemplate(string ColName, DataControlRowType RowType)
{
_ColName = ColName;
_rowType = RowType;
}
public DynamicGridViewTextTemplate(DataControlRowType RowType, int QuestionCount)
{
_rowType = RowType;
_Count = QuestionCount;
}
public void InstantiateIn(System.Web.UI.Control container)
{
switch (_rowType)
{
case DataControlRowType.Header:
Literal lc = new Literal();
lc.Text = "<b>" + _ColName + "</b>";
container.Controls.Add(lc);
break;
case DataControlRowType.DataRow:
Label lbl = new Label();
lbl.DataBinding += new EventHandler(this.lbl_DataBind);
container.Controls.Add(lbl);
break;
case DataControlRowType.Footer:
Literal flc = new Literal();
flc.Text = "<b>Total No of Questions:" + _Count + "</b>";
container.Controls.Add(flc);
break;
default:
break;
}
}
private void lbl_DataBind(Object sender, EventArgs e)
{
Label lbl = (Label)sender;
GridViewRow row = (GridViewRow)lbl.NamingContainer;
lbl.Text =DataBinder.Eval(row.DataItem, _ColName).ToString();
}
}
public class DynamicGridViewDDLTemplate : ITemplate
{
// Implementation of ITemplate
public void InstantiateIn(System.Web.UI.Control container)
{
// Create a DDL
DropDownList ddl = new DropDownList();
//Attach method to delegate
ddl.DataBinding += new System.EventHandler(this.ddl_DataBind);
container.Controls.Add(ddl);
}
//Method that responds to the DataBinding event
private void ddl_DataBind(object sender, System.EventArgs e)
{
//DropDownList ddl = (DropDownList)sender;
//DataGridItem container = (DataGridItem)ddl.NamingContainer;
//ddl.Data.Checked = [Data binding expression];
}
}
[/CODE]