I want to have a gridview which first column is a link to another page. For that I want to create a
link text through a SQL query!
I have the following piece of SQL code, to create the first column of the gridview:
[Code]....
I have a parent repeater that lists the sections of the website. this repeater binds to display a table that contain another repeater of the website pages .. or may display a table that contains another two repeaters of the projects categories and sub-categories.Until now everything is going fine.
The problem comes when I try to include a query of the section ID to the link of the project categories (DataView of the projects repeaters does not contain SectionID)my question is : is there any way to call the SectionID of the first repeater in my projects categories and sub-categories repeaters?Here is my code:
[Code]....
the code behind is as follow:
[Code]....
I Want to be able to replace this bitfield:
<asp:TemplateField HeaderText="Banned" SortExpression="bitBanned">
<ItemTemplate>
<asp:Label ID="Label5" runat="server" Text='<%# ShortDisplay("bitBanned") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
with a link in my gridview that toggles the bit with a method from my dblayer
The ShortDisplay() method seen above looks like this:
protected string ShortDisplay(string strPerm)
{
string result = string.Empty;
if (Eval(strPerm) != null && (string.Compare(Eval(strPerm).ToString(), "True", 0) == 0))
result = "Yes";
else
result = "No";
return result;
}
As you can see it returns just a "yes" or "no", would like it to be a link when the bit is "Yes"
Can I put multiple fields value into the text properties of a link button? My below codes doesn't work. I would like to display "000001-1", "000001" being the job_id and "1" being the job_seq and separated by a dash.
[Code]....
I am trying to add/insert linkbutton dynamically inside gridview row, below is the code
[Code]....
Problem I facing is that the data table is getting created fine with teh linkbutton as well but the gridview is not showing the linkbutton. upon executing I am only the column which is of string type.
I have a link button in my gridview. It is populating correctly; however, being I am populating the values in the gridview using "Eval()" method I don't know how to get the value of the selected Link Button (which is only selected by a user actually clicking
the Link Button).
The user can click on the text directly (instead of showing the "Select" auto created). I want to be able to capture the item they have clicked on's Text property.
Example:Column 1
Value1
Value2
Value3
When the click on "Value2" I want the text property to be stored in a string variable (In this case the text would be "Value2"). In the past I have captured this through GridView.SelectedValue; however, I am not using autopopulate selected button so I need to do this manually and I am unsure as to how I will do this.
Here is my code for HTML and I have not created any code for C# (I want to capture the item using C# in my Grd_Tables_SelectedIndexChanged Event)
[code]....
I am using Web Expression and Access database to build an aspx page.I am displaying records using listview Tiled option and DataPager is enabled also which is creating multiple pages.
View 1 RepliesI've been searching in all the forums, and websites for the last 4 hours without finding a solution for a problem that in the beginning I tought it was an easy one!!!This is my problem, I have a gridview with the following colums: select (link), Room Type (for hotels), and TotalThe total field Is a template field it has in the custom binding property a function: find_total(Eval("Room")) this function makes some calculation and returns the calculated Total value, and shows in the gridview without problems,The thing I cant do is: when the user clicks on the select link I want to get the text of the template field and put in a label control.
I tried, almost all the events of the datagrid, to reference the content of my template field but sometimes I receive a null value (seems that Im looking for the value before the find_total function has been executed) or I get an error "the index is out of range".I dont know how to approach this, I tought It has to be much easier, but Im very confused right now, if anybody knows how to do this
I have this code:
SqlDataSource1.SelectCommand = "Select (AttributeName +'|'+ Value) DisplayTextField tbl_PaymentDetails FROM WHERE AttributeName =" Credit card number ';
[code]...
DropDownList3 click on some text.
Example:
dropdownlist3 ... Test1 (Read in the table)
dropdownlist3 ... Test2 (read from table)
dropdownlist3 ... Test3 (read from table)
[code]...
I have to create a line chart from a sql query. It is as follows:
[Code]....
However,I need to take PlayerName into account too.For example,if there are 2 different PlayerNames,2 different series will be shown on the line chart.
I'm new to ASP.net 3.5 and trying to create a test site so I can figure out how to use it in the real world. I have created a FormView (Formview1) based on a Client table using Linq Data Sources. The page includes a DropDownList to lookup Clients. I have added a list option (<asp:ListOption value="" Text="(Select Client)" and set AppendDataBoundItems=true so my added option is displayed. I decided to try to use Formview with only the Edit and Insert Modes, and I have set the Default Mode = Insert. When you open the page, a blank Client record is displayed.
The Client record contains serveral lookup fields and they have drop down lists for each. When I select a client from the Client DropDownList, is get the following message 'ddlClientType' has a SelectedValue which is invalid because it does not exist in the list of items I had this problem before and decided the best way to handle this (in the interim) was to turn off foreign key constraints for each of the lookup fields (e.g. ClientType) in SQL Server. That worked for 2-3 days. Now the problem has started again.
When I develop in other applications, I would simply create a lookup data source based on a Union Query with the actual data and a blank record. How can you do this using Linq DataSources. Can you get access and modify the queries?
I'm tyring to write a simple DetailsView only used for inserting new records that will pre-fill a textbox with a query string value. Here's the DetailsView:
[code]....
All I want to do is set VenueID_FK.Text to = the "VenueID" querry string. I also want the user to be able to see the VenueID number as they are filling out GridView1.
I know this is probably a simple thing, but I am very new to asp.net. I thought I could handle this in the page load event, but when I try something like this
TextBox VenueID_FK = (TextBox)DetailsView1.FindControl("VenueID_FK");
And then follow by setting the Text property programitically. I've accomplished something similar to this on a different page using a FormView, but only for ReadOnly mode and it was handled in the databound event on that page.
I get the error "The name 'DetailsView1' doesn't exist in the current context." when trying to do the above mentioned. When trying the same line in the databound event here, I get the same error.
Code:
//Link button
LinkButton lnk = new LinkButton();
lnk.Text = " Click Me";
//button
Button btn = new Button();
btn.Text = "Click Me";
i try put the code above to create new Link button and button but problem now is how can put the code; Response.Redirect? and how can I set the Session["ID"]?
I want to create a search form for a table that has many columns. According to input criteria the query will have a where with conditions related to the columns selected or NONE. How can I create a dynamic query according to selected conditions ? is there an example on the net that I can use?
View 2 RepliesI need to search my sql database using full text search.
My question is: How do I create the stored procedure and query?
The full text is already created and I ma using asp.net and c# in my application?
Do I need to include the name of the full text index in the stored procedure and query?
I have a simple dynamic gridview with following code -
GV = new GridView();
I want to create link thumbnails and get link contents like facebook in asp.net, but i couldn't find any resource.
View 1 RepliesI have a datalist in a page which shows a username in a label from the database (theiruseridLabel)I'm trying to take this username, find its profile.firstname and profile.company name, and then display them as the text in 2 hyperlinks.
i have the code below, but this doesnt work..? can anyone see why? there is no error, just the hyperlinks just show as 'hyperlink' rather than the names i want.
HyperLink hp2 = DataList1.Items[0].FindControl("HyperLink2") as HyperLink;
HyperLink hp3 = DataList1.Items[0].FindControl("HyperLink3") as HyperLink; [code]....
I would like to create a text link that will be without underline (such in linkbutton / Hyperlink) also,
I would like to set it's color and it's color when standing on it with mouse, and the mouse pointer image.
With control to use?
and how to make it...
How can I build a query in a new page using the value from a prevous pages control's value. I can transfer the value to the new page, I just don't know how to use the passed value to build a query. I want to populate a data grid filtering with values obtained from the proveous page.
View 3 RepliesI am using the query listed below which includes multiple joins, in the result of the query I need to do some value replacement valuesExample: db.ASSETS.BUILDING_ID=300 that ID does not exist in db.BUILDINGS, in that case I need to return BUILDING_ID=0, db.BUILDINGS.NAME="Unassigned"
[Code]....
I need to export large (more than 50 lakhs) datatable to a .csv file but i dont know how to code. I am creating a windows service ...
View 1 RepliesI'm encountering a strange problem. Here is the scenario. I have built a query that accepts a parameter (WHERE LIKE clause).
I've tested this within the query builder and it returns exactly the number I would expect.
I then go back to my webpage and add the following controls:
Dropdown
Gridview
the user to make a selection from the dropdown. Postback on the dropdown is enabled so the page reloads and the Gridview displays the filtered results (via an objectdatasource). I've set the parameter to the dropdown control.
The trouble is when I run the page I make the selection in the dropdown no results are displayed. Even though the text displayed in the dropdown control is exactly the same as I inputted into the query builder when testing it.
I am trying to create statitics for game downloads and am having dificulty with a sub part of my query. the goup by command is not having the disired result and i think i have been looking at it too long to see what i am doing wrong. [Code]....
At the moment it is producing each result in many rows when only 4 rows should appear. its the download column that is doing it. needs to be sub queried or something to display total in relation to month,gameid,userid.
Month-download-GameID-UserID
1 1
1 1
1 1
1 1
i have a link, i want the text "abcde" will come when mouse is pointed to that link, is ti possible or i need css or other stuff?
View 4 Replies
