Im trying to change the information on each row depending on the result from the query. Im thinking that at the minute my problem is that I'm only returning the first result from the query into the result.
e.g. query returns row 1 with '1232' row 2 '1243' but result is only ever set to '1232'
What would it be the simplest way to merge a result like this from a sql query to be displayed in an asp.net gridview?
NULL Tarde Fer W. Lunes
Mañana NULL Fer W. Lunes
I need the result to look like this
Mañana Tarde Fer W. Lunes
i have 2 tables assignment and feedback, in a gridview it displays all the assignments, the assignments then get feedback. im then wanting to change the view feedback button in the gridview depending on if there is new feedback for example:
the feedback table has a state field in it so when its 1 i want that image button to change to the one with the +
The dataGrid view is being populated. The Autogeneratedcolumns is set to false. How do I change the colour of a cell of a row depending on the text? i.e. Row 2, column 5 says "Failed". I would like to change the colour of that cell to be red.
View 2 RepliesNew to Linq and Var type have a method where linq query is executed, want to return the result and assign it to GridView. but method don't take the return type as var.
So was wondering how do i return this query result?
Should i assign this result to DataTable first and make the method return type as DataTable?
Here is the code, This is what i want to do but not sure what is the right way
[Code]....
I have this ListView that has a Drop Down List.Everything works fine (I think/hope) except that the drop down list are not showing its result correctly.This is the code.
Front-End
[Code]....
The code behind consist of the page_load and the ItemDataBound
[Code]....
I'm having a problem with my Linq to XML query. I'm getting the result data I want, but it's nested so deep that there must be a better way.Here is my XML:
[Code]....
I'm trying to get a list (simple string[]) of all Item IDs where Category Names contains "Other".Here is my Linq:
[Code]....
[Code]....
Here is a snapshot of my result from Visual Studio:The results I want are there ("item100", "item400", "item500"), but buried so deeply in the results var.
How can I get the query to return a simple
string[] = { "item100", "item400", "item500" }
This is just an efficiency question really.. I'm interested to know if there is a more efficient or logical way that people use to handle this sort of scenario.
In my asp.net application I am running a script to generate a new project my code at the top level looks like this:
[code]....
I create a boolean and each function returns a boolean result, the next function in this chain will only run if the previous one was successful. I do this because an asp.net application will continue to run through the page life cycle unless there is an unhandled exception and I don't want my whole application to be screwed up if something in the chain goes wrong (there is a lot of copying and deleting of files etc.. in this example).
I was wondering if anyone could help me. I have a template field which has four itemtemplates that each hold a label in a gridview. These labels are always constant with the same strings. What I want to do is change the css formatting of these four labels depending on the value of a column. So the css formatting would have to be done for each row, not the whole column. I bind the gridview to a dataaccesslayer so there is no sqldatasource on the page. Does anyone have any idea how to do this and where it would be done. I will have the dataview with the data sorted in the correct order. The actual column that is used to alter the CSS will not be in the gridview although I could assign it to the datakeyname if that makes it easier as the data is not sensitive.
View 1 RepliesI have a page to show a thread content, it take the ID of the thread from the query string.
depending on the ID, I show the content using the FormView control.
how could I then change the page title depending on the databinding result?
I've figured out that I can do that before the databinding in the Page_Load event, by querying the title of the thread depending on the ID from the QueryString object, but I'm wondering if I can achieve my goal during the databinding!
I am trying to display this query result in an aspx page.
It is very slow in loading. Here is the query. The inner query inside the outer quesry is the problem.(Please see the underlined part in the query) - (If I remove that part it is very fast.)
select
top 500
--This column is the issue
,Governing_Class=( case when exists (select top 1 tqc.class_code from
t_quote_class tqc
inner join t_quote_class_premium tqcm on tqc.class_code =tqcm.
class_code
where tqc.appid=pi.appid and tqc.class_code not in('8742' ,'8810','7380')
order by tqcm.premium_amt desc
)
then ( select top 1 tqc.class_code from
t_quote_class tqc
inner join t_quote_class_premium tqcm on tqc.class_code =tqcm.
class_code
where tqc.appid=pi.
appid
order by tqcm.premium_amt desc
)
......... From tables
i have tow query in one stored procedure
first query and the second one every of them return only value
i want to copy the result of tow values in a new row in new table
as i want to check on this tow values in ado.net
i want to get only this tow values as a row not first and secon query
only a row has result of first and second query results
[Code]....
I have page A, B and C. In the page load of C, i have used a query string parameter to display some tables depending on where it came from, either A or B. Page C has Cancel button. When a user clicks Cancel, it has to check where it came from and should redirect to same page, i mean either A or B. I am not at all sure how to use query string for redirecting.
View 2 Replies[Code]....
In above query I want to have top 10 rows as well as count of all rows.
I am binding a gridview to a stored procedure. I want to change of some row color based on the data binding.
For example: if "Lesson" =0, change the row color to RED.
[Code]....
This should not be to hard but my head is not going for it today I have a gridview that changes the sales reps name every 3 rows. The data is group in 3 rows for each rep. estimates, job & invoices each have their own row I want to change the backgroup for each rep. I am using C# and I would guess it would be in the code behind file I got this far but can not remember a way to check the next row to make sure it is the same of changed from the previous row
protected void gvSaleReport_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
string prevRep;
prevRep = e.Row.Cells[0].Text;
if (prevRep == e.Row.Cells[0].Text)
e.Row.BackColor = System.Drawing.Color.Blue;
else
e.Row.BackColor = System.Drawing.Color.White;
}
}
I have requirement like client can able to Drag and drop and change the position of rows in Gridview
View 1 Repliesi want to change the color of border rows and columns in the grid view in asp for printing purpose.
View 1 RepliesIn the original site, master page has code-behind to check a query string parameter value. Depending on this value, code-behind dynamically modify some CSS property to hide / display master page elements.
As MVC2 has no code-behind because we are supposed to perform everything in the controllers, how should I proceed in this case ?
I see this : [URL]
It partially answers my needs but the query string processing is common to all pages. How can I move this processing in a common code section ?
I have asp:Table with number of asp:Label inside asp:FormView, it represents short stats info.I need to set Label.CssClass to "red" if it's text isn't "0".Currently I do this on FormView.DataBound event. But think that it's better to use JavaScript and probably jQuery. How can I do that?
View 1 RepliesI would like to alter the query that is run, depending on the selection made by the user in a drop down list on the same page. Would this best be done using a partial page update (AJAX)? Ideally it would be great to have the textbox result change quickly once the drop-down list value has changed, without a full page postback. I would like to change the SQL query to a completely different query if the user selects an option different to the default (page_load value) in the drop-down list. I would then like the newly retrieved result to be displayed in the textbox as before.
My current VB function looks like this:
[Code]....
Access to my application is controlled by user accounts. I would like my text labels to change within my pages depending on the user logged in. This needs to be easily managed.
What is the best way to achieve this? Would using the resources file work?
I do not have much experience with asp:menus. How would I be able to make visible or invisible certian pages depending on a factor that I get from a session varaible? I plan on doing this on the backend in VB.net.
View 3 RepliesI have a question that probably is the easiest one but can't figure it out, this is the deal; I have a table in reporting services that shows the names of employees and their position in a company, but what I want to do is to make the background gray of the entire row when the position is equal to "supervisor", do I made myself clear.
View 3 RepliesI use the follwoing code to get a value from the SQL query. But now i would like to use some sql function like Sum() count() ... and i would like to get the result of that.
vb Code:
Dim constg As New SqlConnection
constg.ConnectionString = "Data Source=m......."
constg.Open()
Dim payrollquery As String '= ("SELECT * FROM xxxxx.nnnnn WHERE ID IN(" & ID & " ) AND sent = 'U' ")
Dim cmd3 As New SqlCommand(sqlstr, constg)
Dim reader As SqlDataReader = cmd3.ExecuteReader