I have the following SqlDataSource on my page
[Code]....
Now, what happens is I get *all* rows from the DB, even though I specified only the top 10. The worst part is that if I run the query from the query builder, or even directly on the DB, it only gives me the rows I want. In addition, it doesn't sort :S
I have two image buttons inside of templates that are handling delete and select. I have a Select handler and a delete handler. The command name of each image button is set to delete and select. It dosen't work.
If I set them back to regular buttons or text it works perfectly but not as an image button. I need it to work as an image buttton because I have a onclientclick inside of it.
I did a debug and notice it dosen't even fire the delete and select methods....
select all checkbox in gridview header doesn't select all rows in the grid when it is in in content placeholder using javascript or jquery .how to resolve it.
View 1 RepliesI 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?
Is there any way to do this? I can't find anything to latch on to.
View 2 Repliesi m facing a issue in my code i m calling a user control which is in master page, and in row databound i m calling it and it is working fine but on select index change of checkbox it is not working
protected void chkIntClient_SelectedIndexChanged(object sender, EventArgs e)
{
UserControls_AlwaysVisible uc = this.Page.Master.FindControl("Alwaysvisible") as UserControls_AlwaysVisible;
uc.Visible = true;
ArrayList raters = new ArrayList();
CheckBox chkselproducer;
[code]...
i have the following select staement which deosnt work, can anyone advise me whats wrong with it:
string _name = ddl_Name.SelectedValue.ToString();
string cmd =
"SELECT ID, Telephone FROM User_List WHERE Name = '' + _name;
i keep getting an invalid column name error? and i know the syntax next to _name isnt correct. how are the single quotes meant to go?
I want to export the grid data to excel then write the following code but the following lines of code are working at firefox3 but not at ie8(no response).
System.Web.HttpContext.Current.Response.Clear();
System.Web.HttpContext.Current.Response.AddHeader("Content-disposition", "attachment;filename=ProjectTimeSheet.xls");
System.Web.HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
string excelFile = "";
excelFile = ConvertToExcel(PrepareGridViewForExport()); //generate formated table for excel
System.Web.HttpContext.Current.Response.Write(excelFile);
System.Web.HttpContext.Current.Response.End();
Ive got an ASP:Menu in my page and want to display a background image for each item, and have that background change when the user hovers over, or selects it.
However, the UnselectedTab style applies when the page loads but then the style doesnt change on either select or hover, ...
Code in my asp.net page...
[code]...
i am using a datalist in usercontrol.. i need to select data from datalist using jquery and store it in session?
View 2 RepliesI have an accessdatasource with multiple columns, one column I use it to populate a dropdownlist. Can I use the data from other columns to insert into a table, insert being done in the aspx.vb page, without creating gridview etc.
Is it possible to make a detailsview one column visible= false and still be able to evaluate its contents?
I have two Data Table, One data table contain Product-A information, and another data table contain Product-B Information, I want to get the uncommon values between the two data table, I would like to achieve this using LINQ, find the sample values below
Product Data Table
Product-A-Id ProductName
W10012 A
W10013 B
W10014 C
W10015 D
Sales Data Table
ProductId ProductName
W10013 B
W10013 B
W10015 D
X10020 AC
I want to find the uncommon data from both data table using LINQ, So find my expected Data Table result is
Result Data Table
ProductId ProductName
W10012 A
W10014 C
X10020 AC
I am having dataset and I want to validate particular column for Integer(Numeric) value.
e.g.
ErrorRows = dt.Select("LEN(Year) <> 4 ")
Above I have to validate Year column for Numeric value otherwise it should give me erroneous records which have data other than numeric.
I am experimenting with 3 dropdowns bound to 3 different datasources. I want the contents in each dropdown depending on what is selected from the above dropdown and the datasource queries reflect this.
<asp:DropDownList ID="DropDownList_CostCentres" runat="server" Height="16px"
Width="138px" DataSourceID="CostCentreDataSource" DataTextField="CostCentre"
DataValueField="CostCentreID">
</asp:DropDownList>
<asp:SqlDataSource ID="CostCentreDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:corkABCConnectionString %>"
SelectCommand="SELECT [CostCentreID], [CostCentre] FROM [CostCentres]">
</asp:SqlDataSource>
<br />
<br />
<asp:Label ID="Label2" runat="server" Text="Manager:" Font-Bold="True"></asp:Label>
<br />
<asp:DropDownList ID="DropDownList_Managers" runat="server" Height="16px"
Width="138px" DataSourceID="ManagerDataSource" DataTextField="EmployeeName"
DataValueField="EmployeeID">
</asp:DropDownList>
<asp:SqlDataSource ID="ManagerDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:corkABCConnectionString %>"
SelectCommand="SELECT [EmployeeID], [EmployeeName] FROM [Employees] WHERE ([CostCentre] = @CostCentre)">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList_CostCentres" Name="CostCentre"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
However, the second dropdown does not load with the relevant data when I select a value from the first dropdown (stays blank). Must I still provide an event handler and how do I combine this with the sqldatasource?
I have extended GridView in order to have consistent look & feel, paging and sorting. However, when the page is first time loaded, the select method is getting called twice. It works fine when i move between pages in pagination.
Note, i am using Asp.net 2.0.
I have a dropdownlist and a button(btnSend).
protected void btnSend_Click(object sender, EventArgs e)
{
InsertIntoTemporary();
LoadAddressdetails();
MassSendOut();
}
What i need to do is as follows;
1) Once i select the item in the dropdownlist, it will extract data from my sql query which is :
string mySQL = "SELECT * FROM examtimetable WHERE subject_name= '" + dd_cat.SelectedValue + "'";
Once seleted,it will display everything in a gridview1.
subject_id subject_name admission_no date venue seat_no
I need to know how can I select a gridview row based on a query string data. In my case, the query string will contain the id that exist in the Table related to that grid. Is there a way to do this from the code behind? In other words, if I click a link with that specific query string, can I open the page and tell my grid to select a specific row based on the table row id?
View 1 Replieser trying to develop in asp.net and I think this is the best site that I visited ever.I'm trying to develop webapplications with some controls like calendars, textbox, check box etc. in order to allows to the user to built a query made by himself (and complementing with strings), and of course only to display data according to the gathered information by the controls.
View 2 Replies I am using the following code to select data which appears between 2 dates:
string query = "SELECT (name, date) FROM date where tableinfo
BETWEEN @date1 AND date2";[code]....
Now the above code is working fine. The only problem is that the date in the date column of the gridview is not in the proper format. What can i do in order to change the format of the date in the gridview. If the format of the date is changed in the databse itself I may be able to use the above SQL query.
I have a Gridview that show the values from mysql database .Can U tell me whn I click on linkbutton on grid view then Display the pop Box nd Data show in textboxes in pop box
id 01
Name GD
Ph 09582901670
Protected
Sub CompanyGridView_SelectedIndexChanged(ByVal sender
As
Object,
ByVal e
As System.EventArgs)
Handles
[code]...
Im coding in VB Im looking to transfer data from a gridview to a table. In the grid view i have enabled Selection, and on the code behind, as i need help getting started selecting the attributes adding it to a table. The grid is being populated from a table however i would like to take the information selected and store it in another table, which will have some more attributes. i have found a way which will add the row by an sql query from one table to another however i would like to give the user the option to select and add data to the table.
And i was thinking i could use this SQL query in the code behind but im not sure how to add it to the code behind of the select.
[Code]....
I have a class Myclass with variables a,b,c,d. I declare a List<Myclass> lst = new List<Myclass> (); And I pass it to gridview as gridview.datasoure = lst; The question is the gridview will show a,b,c,d at all. How can I just show a in gridview, andnot show b,c,d in gridview?
View 3 RepliesI don't want to use the built in "Select" hyperlink that's in the gridview, I'd like to just use the first data column, is there a way to do that or are we forced to use the automatically generated "Select" column.
View 5 RepliesIam trying to understand why my sqldatasource control bound to gridview will not return data while i have cascading dropdownlist coded in pageload and selected events respectively?
from which sqldatasource control stored procedure obtains its parameter values.
only when i select items from second dependent dropdown does the grid display data?