have gridview in my asp.net webform, and if i select rowafter the database is refreshed i see the ID correct.but when i run any query on the data and i see for example 4 rowsand i select one row i see wrong IDi use this for select row: ID = GridView1.SelectedRow.Cells[1].Text;
View 1 Replies
I have a SQL statement as below
SELECT [Motor]
,[Time]
FROM [logger].[dbo].[motor]
WHERE day([Time]) = day(getdate())
ORDER BY [TIME]
This is a very basic table that gives me the status of a motor at a given time. All i want is a select statement that will give me the latest result if possible. I can get it so it gives all of todays results but if i could get it that it only displays the latest result that would be great.
And I realise that a user/member can have mutlple roles.HOW Can I do a select SQL query that returns the result set like this (SQL 2005)
SELECT Roles FROM <tbl>
WHERE UserID = <GUID>
AND Roles IN ('AA','CC')
sql_select = "SELECT auid FROM tbl_auAccount WHERE username='" & IarUN & "'"
'Step Three is Creating Connection Object and opening the database
'Add Error Trapping Later
con = Server.CreateObject("ADODB.Connection")
con.Open(data_source)
'Step 4 is to Execute the SQL Command
con.Execute(sql_select)
'Step 5 Done. Close the connection
con.Close()
con = Nothing
This works fine, but I want the returned id (which I will right code to make sure it is not null and that it is only one returned) to show up as a label (or the text of a label)
lblShowNEWUserauID.Text = ?
I'm programming a webpage in ASP.NET which displays a list of students not listed as participants in something, and upon clicking a student name shows you a brief summary of their details, so the user can ensure they're selecting the right person.
My code currently correctly obtains their ID, adds it as a parameter to my stored procedure and executes the procedure;
[code]....
However, when I try to access the results I get the following error:
System.NullReferenceException: Object reference not set to an instance of an object.
Upon debugging, there don't seem to be any results returned... but when running just the stored procedure in SQL Server with the same data, it does return a single row, as expected.
How do I access this result so I can bind it to my fields?
(I am working in ASP.NET 3.5 in Visual Studio 2008, with SQL Server 2008.)
Im using SQL Server 2005 and im using stored procedures. Is this possible? i need to get a number of results and do it in one SELECT statement or just one result set. Im using MS Chart Controls for reporting and they cant seem to process multiple result sets this is my problem, so basically to run a barchart i need to assign a column to the X axis and a column to the Y axis and it will then display my results.
My stored procedure below returns a result set with columns subpolicy_name, building_name, floor_name, room_name and total_savings. Im just wondering is it possible to split my total_savings column into 4 columns, for example subpolicy_savings, building_savings, floor_savings and room_savings, i need everything in a separate column. If you run this stored procedure you will see the result set.
[Code]....
I have a DetailsView that binds a User's Profile data into an ItemTemplate upon the Page_Load. When the user chooses Edit Mode, all of the Data is correctly carried over, except for the DropDownLists selected values. If on the ReadOnly page, the user's data shows "Male" for the Sex, then on the edit Mode page, I would like the DropDownList that gets the sexes from the database ("male", "female"), to have automatically selected "Male" in the DropDownList, not the lowest indexed item.
[Code]....
[Code]....
I have gridview. some columns are data, and some are link buttons. now, I need move these link buttons to a hovermenu. this is done. but I got a javascript exception, and it is because if there is no row was selected in gridview, it will pop this.
so, the question is: how can I select a row in gridview without select command? simply by code?
I have the following simple linq to sql statement:
[Code]....
Instead of showing me the UserName from the aspnet_Users table, it showed me the SQL select statement.
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" }
I'm using the code below to extract data from a gridview and populate it into textboxes for the days and two drop downs for Project and Category.
For some rows in the gridview everything but the category ddl populates correctly. If I click the row a second time the category ddl displays the correct category.
why I have to click twice for some rows?
[Code]....
I want to select a row of gridview and display a DetailsView. There is issue of real estate on page so I do not want to use a select button.
View 5 Repliesi created a gridview and ive bended the data using a ObjectDataSource,
for some reasons i created the CRUD methods to do the work instead of using the CRUD method generated by the LINQDataSource; everything is just working fine but the update method,when i update a row in my gridview everything become as if there isnt any update!but when i check the database i can see that the rows is been updated!i can't find a solution (yet) to this issue.i'am using the updatepanel to have the autopostback without refreshing the page.
I have a gridview which I am using to display a dataset result. The problem is I am using paging in it. But when I click on the page # it says that I haven't handled the event. Do I need to rebind the dataset?
View 1 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 a requirement in which the user can search for other user he enters three char of the name clicks on the search button and a new window is opened and he can see all the search results in a gridview he can select one of them and this closes the new window and the details are populated on the previous page.
View 6 RepliesIm 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'
Rate AnodeRate TotalRate
100 100 200
txtrate,txtanoderate n txttatalrate are added in ItemTemplate of gridview.
rate field is in database table while anoderate n totalrate not in database table ,also totalrate is readonly so that user can see only its addition,this addition will b passed to txtrate field n wil get bind that value in database. also i took
<asp:HiddenField ID="hdnTotalRt" runat="server" /> as it is readonly..
sample code:
enter code here
<asp:TemplateField HeaderText="Standard Rate">
<ItemTemplate>
<asp:TextBox ID="txtRate" runat="server" BorderWidth="0.5pt" Text='<%# Bind("rate") %>' BorderColor="green" BackColor="#ffffcc" Width="40px"></asp:TextBox>
[Code]....
It is showing me error as The name "txtRate"does not exist in d current context
Let's say I have a gridview with some columns like, title, name, funding agency. Here's an example of what I want to do:
I want to display all the records in the gridview to start. There would be a dropdownlist that lets the user select whether to search by title, name, funding agency and a text box that lets them type in what they want to search for (and a button to start the search). After searching, the gridview would only display the records that matched the criteria.i already know how to connect datasets to the gridview, but i am using mysql database and writing code in vb.how to accomplish this task
I am new at this VB/Microsoft Visual Web Developer 2010 Express thing. I am amaze that I even got this far and thatI manages to make this search page work. Below is the code and picture for this search page. It's working. However I want to transfer the result/the gridview onto a second page Result.aspx. But I tries all kind of thing and it just doesn't seem to want to cooperate with me. If anyone can give me some hint/some sample codes on how I might be able to transfer controlfrom one page onto another. I just have to learn it from a class extra credit project. Also in the picture above I am using a direct connection to an Access database not the ObjectDataSource. I was just playing around with it to see which is better. But I ended up going with direct connection to Access database.
<%@ Page Language="VB" ClassName="SenderClass" EnableSessionState="True" %>
<head>
<script runat="server">
Sub closeSite(ByVal sender As Object, ByVal e As EventArgs)
Response.Write(" <script language='javascript'> { window.close(); }")
End Sub
Sub Page_Transfer(ByVal sender As Object, ByVal e As EventArgs)
'Storing in Context
Session("SearchBox") = SearchBox.Text
Session("ListBox") = ListBox1.Text
Session("DropDownList") = DropDownList.DataTextFormatString
'Context.Items("DropDownList") = DropDownList.Text
'Server.Transfer("SearchResult.aspx")
End Sub
Sub Page_Transfer2(ByVal sender As Object, ByVal e As EventArgs)
Dim field1 As String = ("SearchBox")
Dim field2 As String = ("ListBox")
Dim field3 As String = ("DropDownList")
'Dim TestString As String = ("SELECT * FROM [Books] WHERE (([Title] = ?) AND ([Category] = ?))")
End Sub
Sub Test(ByVal sender As Object, ByVal e As EventArgs)
AccessDataSource1.SelectCommand = "SELECT * FROM BOOKS WHERE "
If DropDownList.SelectedIndex = 0 Then
AccessDataSource1.SelectCommand += String.Format(" ((Category = @Category OR 'Computer' ")
AccessDataSource1.SelectCommand += String.Format(" OR 'Literature & Fiction' OR 'Reference'")
AccessDataSource1.SelectCommand += String.Format(" OR 'Romance' OR 'Science'")
AccessDataSource1.SelectCommand += String.Format(" OR 'Home Design' OR 'Accounting & Finance'")
AccessDataSource1.SelectCommand += String.Format(" OR 'Horror' OR 'Refernce'))")
Else
AccessDataSource1.SelectCommand += String.Format("(( Category = @Category ))")
End If
For Each Item As ListItem In ListBox1.Items
If Item.Selected = 0 Then
AccessDataSource1.SelectCommand += String.Format(" AND ((Title Like @Search + '%'", Item.Text)
AccessDataSource1.SelectCommand += String.Format(" OR [Author(s)] Like @Search + '%'", Item.Text)
AccessDataSource1.SelectCommand += String.Format(" OR Publisher Like @Search + '%'", Item.Text)
AccessDataSource1.SelectCommand += String.Format(" OR ISBN Like @Search + '%'", Item.Text)
AccessDataSource1.SelectCommand += String.Format(" OR Price Like @Search + '%'", Item.Text)
AccessDataSource1.SelectCommand += String.Format(" OR Category Like @Search + '%'", Item.Text)
AccessDataSource1.SelectCommand += String.Format(" OR Year Like @Search + '%' ))", Item.Text)
End If
If Item.Selected = 1 Then
AccessDataSource1.SelectCommand += String.Format(" AND (Title Like @Search + '%' )", Item.Text)
End If
If Item.Selected = 2 Then
AccessDataSource1.SelectCommand += String.Format(" AND ([Author(s)] Like @Search + '%' )", Item.Text)
End If
If Item.Selected = 3 Then
AccessDataSource1.SelectCommand += String.Format(" AND (Publisher Like @Search + '%' )", Item.Text)
End If
If Item.Selected = 4 Then
AccessDataSource1.SelectCommand += String.Format(" AND (ISBN Like @Search + '%' )", Item.Text)
End If
If Item.Selected = 5 Then
AccessDataSource1.SelectCommand += String.Format(" AND (Price Like @Search + '%' )", Item.Text)
End If
If Item.Selected = 6 Then
AccessDataSource1.SelectCommand += String.Format(" AND (Category Like @Search + '%' )", Item.Text)
End If
If Item.Selected = 7 Then
AccessDataSource1.SelectCommand += String.Format(" AND (Year Like @Search + '%' )", Item.Text)
End If
Next
Dim KeywordCom As String = AccessDataSource1.SelectCommand.ToString
Context.Items("Test") = KeywordCom.ToString
Server.Transfer("Result.aspx")
End Sub
</script>
</head>
<html>
<body>
<a href="Default.aspx">Home</a>
<a href="About.aspx">About.aspx</a><a href="SearchResult.aspx">SearchResult.aspx</a>
<form id="form1" runat="server">
<h3>
Search for:
<asp:TextBox ID="SearchBox" runat="server" Width="219px" />
<asp:Button ID="Button1" Text="Search" Width="146px" AccessKey="S"
runat="server" Enabled="True" Onclick="Test" height="26px"
style="position: relative"/>
</h3>
<h3>
Search In:<asp:ListBox ID="ListBox1" runat="server" style="margin-left: 6px"
Width="221px">
<asp:ListItem>Keyword Anywhere</asp:ListItem>
<asp:ListItem>Title</asp:ListItem>
<asp:ListItem>Author(s)</asp:ListItem>
<asp:ListItem>Publisher</asp:ListItem>
<asp:ListItem>ISBN</asp:ListItem>
<asp:ListItem>Price</asp:ListItem>
<asp:ListItem>Category</asp:ListItem>
<asp:ListItem>Year</asp:ListItem>
</asp:ListBox>
</h3>
<h3>
Category:
<asp:DropDownList ID="DropDownList" runat="server" Height="16px" Width="162px">
<asp:ListItem>All Categories</asp:ListItem>
<asp:ListItem>Computer</asp:ListItem>
<asp:ListItem>Literature & Fiction</asp:ListItem>
<asp:ListItem>Reference</asp:ListItem>
<asp:ListItem>Romance</asp:ListItem>
<asp:ListItem>Science</asp:ListItem>
<asp:ListItem>Home Design</asp:ListItem>
<asp:ListItem>Accounting & Finance</asp:ListItem>
<asp:ListItem>Horror</asp:ListItem>
</asp:DropDownList>
<asp:Button ID="Button3" runat="server" Text="Exit Store" Width="146px"
height="26px" />
</h3>
<p>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="ID" DataSourceID="AccessDataSource1" >
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False"
ReadOnly="True" SortExpression="ID" />
<asp:BoundField DataField="ISBN" HeaderText="ISBN" SortExpression="ISBN" />
<asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" />
<asp:BoundField DataField="Author(s)" HeaderText="Author(s)"
SortExpression="Author(s)" />
<asp:BoundField DataField="Publisher" HeaderText="Publisher"
SortExpression="Publisher" />
<asp:BoundField DataField="Year" HeaderText="Year" SortExpression="Year" />
<asp:BoundField DataField="Price" HeaderText="Price" SortExpression="Price" />
<asp:BoundField DataField="Category" HeaderText="Category"
SortExpression="Category" />
<asp:ButtonField ButtonType="Button" CommandName="Select" HeaderText="Select"
ShowHeader="True" Text="Select" runat="server" />
</Columns>
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="~/App_Data/Books.accdb" >
<SelectParameters>
<asp:ControlParameter Name="Category" ControlID="DropDownList" PropertyName="SelectedValue" />
<asp:ControlParameter Name="Search" ControlID="SearchBox" PropertyName="Text" />
<asp:ControlParameter Name="InColumn" ControlID="ListBox1" PropertyName="SelectedValue" />
</SelectParameters>
</asp:AccessDataSource>
</p>
<p>
</p>
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
</form>
</body>
</html>
how to display result in gridview according to textbox only if textbox2 date value is greater than textbox1 ?
i have two textboxes and gridview ... if i type in Textbox1 : 2-Jan-2011 and in textbox2 : 1-Jan-2011 then in label1 the eroor message display else ..if textbox2 value is greater then textbox1 value then gridview will display records according to textbox1 and textbox2 from database ...
how to do that?
I have an aspx webpage with a databound DropDownList and a databound GridView control. The GridView datasource is using a WHERE clause to return its' data. I.e. The user selects a work area from the DropDownList and members of that area appear in the Gridview. The GridView has 3 columns, WrkArea, LastName and FirstName. The page also has a Button.
What I am trying to accomplish is when the user clicks the Button, the data from the GridView is copied to a separate SQL table. I am working in VB. I have been looking at other posts but have to admit, I am really confused.
I have a doubt and i am sending you the details below, what i want to display in Gridview.
below i am describing the sql Table Structure.
Original Table Structure.
ID Date TimeLogged(Hrs) UserName
1 10/8/2012 5.50 Bubai
2 11/8/2012 2.30 Bubai
3 10/8/2012 3.30 Bhanu
4 11/8/2012 7.30 Bhanu
I want result like below. User Name should be dynamic. May be lot of users. User name will come from Database table.
i want to show details in Gridview(Front End).
Date Bubai Bhanu Total
10/8/2012 5.30 3 8. 30
11/8/2012 2.30 7.30 10
Total 8 10.30 18.30
I have a doubt and i am sending you the details below, what i want to display in Gridview. below i am describing the sql Table Structure.Original Table Structure.
ID Date TimeLogged(Hrs) UserName
1 10/8/2012 5.50 Bubai
2 11/8/2012 2.30 Bubai
3 10/8/2012 3.30 Bhanu
4 11/8/2012 7.30 Bhanu
I want result like below. User Name should be dynamic. May be lot of users. User name will come from Database table. i want to show details in Gridview(Front End).
Date Bubai Bhanu Total
10/8/2012 5.30 3 8. 30
11/8/2012 2.30 7.30 10
Total 8 10.30 18.30
I have a database that has names and months of birth. I would like to have a Choose Month: with a drop down menu to select the month of your choice, then have the results show in a gridview at the bottom of the page. I thought this would be fairly simple but my grid doesn't show anything.
<%@ Page language="C#" masterpagefile="MainContent.master" title="HomeSign OutVehicle CalendarProj" %>
<asp:Content id="Content1" runat="server" contentplaceholderid="Content">
<div id="Rightside">
<form><asp:Label runat="server" Text="Choose Month:" id="Label1"></asp:Label> <asp:DropDownList runat="server" id="Month">
<asp:listitem>Choose Month</asp:listitem>
<asp:listitem>January</asp:listitem>
<asp:listitem>February</asp:listitem>
<asp:listitem>March</asp:listitem>
<asp:listitem>April</asp:listitem>
<asp:listitem>May</asp:listitem>
<asp:listitem>June</asp:listitem>
<asp:listitem>July</asp:listitem>
<asp:listitem>August</asp:listitem>
<asp:listitem>September</asp:listitem>
<asp:listitem>October</asp:listitem>
<asp:listitem>November</asp:listitem>
<asp:listitem>December</asp:listitem>
</asp:DropDownList><br /><hr />
<asp:GridView runat="server" id="GridView1" AutoGenerateColumns="False" DataSourceID="AccessDataSource1">
<Columns>
<asp:boundfield DataField="FullName" HeaderText="FullName" SortExpression="FullName">
</asp:boundfield>
<asp:boundfield DataField="Month" HeaderText="Month" SortExpression="Month">
</asp:boundfield>
</Columns>
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="browser.mdb" SelectCommand="SELECT [FullName], [Month] FROM [EmployeeDates] WHERE ([Month] = ?)">
<SelectParameters>
<asp:controlparameter ControlID="Month" Name="Month" PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:AccessDataSource>
</form>
</div>
</asp:Content>
