Data Controls :: GridView Using SqlDataSource / Disappears On PostBack?
Oct 1, 2013
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
[code]....
my data in gridview4 disappears when i click add to cart it shows no data again i have to pass a query from gridview 3 and then gridview 4 appears and then again if i click on add to cart in gridview 4 it shows no data.
View 1 Replies
Similar Messages:
Jan 13, 2010
I have a gridview where in the users are allowed to edit certain data and there is an update on top of the page which will send out all the changes made inside the GridView. But, the problem is , as soon as the update button is clicked, the grid disappearsand no update is made. This problem occurs when the size of the data on the page is huge. When we have less amount of data on the gridview, It does update. But, when there is a huge amount of data on the gridview, it does not. We have tried to increase the page size on the server, but to no use.
View 3 Replies
Feb 23, 2010
I've got a Gridview in which I use the RowDataBound handler to color the lines according to certain conditions
(ie if column x is value y then change the background-color of the row to z etc).
One problem though, as soon as I do a postback the coloring disappears altogether and all rows become white.
Is there some way around this so I can retain my background colors even after a postback?
View 14 Replies
Jun 1, 2010
I have a datarepeater inside which I load a gridview. After the grid's binding is done I create an extra header line to group the columns (that's the only way I could do it, I couldn't figure a way to add an event for a control inside the repeater).That works fine and the page displays perfectly.However everytime I do a postback from other controls, I lose the 2nd header and 1 extra empty line appears at the top of the gridview
View 5 Replies
May 4, 2010
have an ASP.net 4.0 page containing a GridView, where during the Page_Init event I'm dynamically adding BoundField columns to the gridview. I also have some custom sorting and paging methods that I use with this gridview, which result in postbacks on the page. In Chrome, Firefox, Safari, and Opera the gridview behaves as expected. HOWEVER, in IE 6, 7, or 8 when I click to sort a column in the gridview, or go to the next page of results in the gridview, it does not bind on postback, returning nothing back to the browser. Again, in anything but Internet Explorer, paging and sorting (frankly any postback event) brings back the gridview in its expected state. I only have the problem in IE. Relevant snippets of my code follow, where you'll see my Page_Init event calling a method in my WebFunctions class to add the BoundField columns for the table I pass to it, and my Page_Load event that calls the method in the user control responsible for binding my dataset to the gridview. Initial page load works in all browsers, but postback loading of the gridview only works in non-IE browsers.
[Code]....
View 4 Replies
Jul 24, 2010
I'm trying to figure out why my gridview disappears when I trigger the rowediting event.
The Gridview:
[Code]....
The code-behind:
[Code]....
When I click on the edit linkbutton, the gridview disappears. What is going wrong?
View 13 Replies
Jan 18, 2011
I use Server.Transfer("pagename", True) to navigate from a page where two dates have been selected to a page with a gridview that uses the dates to query the database and display the results. The gridview initially displays correctly but when I operate the select or sort it disappears.
View 8 Replies
Jan 21, 2011
I am populating a column in a gridview with a dropdownlist as follows:
[Code]....
[Code]....
When I edit the gridrow, the dropdown is there and I can select a new item.
But I can't find the dropdown during the rowupdated event. The cell control says it's a Textbox. All of the other items in the row are fine and I can get the data back. But I can't get the DropDown item.
Here are some of the things I have tried in the RowUpdating event:
DropDownList test = (DropDownList)e.FindControl("ddlPeriod");
//null
DropDownList ddl = (DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlPeriod");
//Also null
var test = row.Cells[8].Controls[0];
//Says its a textbox.
View 5 Replies
Apr 1, 2011
I have a gridview with daatsource from MembershipUserCollection. When my collection doesn't contain any records the gridview just disappears. I want to display the empty gridview indicating no records exist rather than the grid just become invisible.
How to make gridview always visible ?
View 4 Replies
Jul 28, 2010
I have a page with a TextBox, a Button, a GridView, and a SqlDataSource. I click the Button to execute the SQL in the TextBox using the SqlDataSource. The SqlDataSource populates the GridView. Everything works as expected until I click a column heading to sort.
When I click a column heading, the GridView disappears and I have to click the Button to display the grid again. When I do, the grid is displayed in the order of the column I clicked.
I don't understand why the GridView is disappearing when I click a column header.
Does anyone know how to fix this so the GridView is sorted and displayed only by clicking the column header?
ASPX:
[Code]....
Code behind:
[Code]....
View 9 Replies
Jun 15, 2010
I have a small problem I am returning some data from a query and have allowed paging, however when I click on the next button to view the following page the gridview disappears.
My datasource is specified in the code behind:
<asp:Panel ID="dtpanel" runat="server" Visible="False">
<asp:GridView ID="grddetails" runat="server" AutoGenerateColumns="False" AllowPaging="True"
OnPageIndexChanging="grddetails_SelectedIndexChanged" ViewStateMode="Enabled"
onselectedindexchanged="grddetails_SelectedIndexChanged" AllowSorting="True" >
<Columns>
<asp:BoundField DataField="Col1" HeaderText="Col1" SortExpression="Col1" />
<asp:BoundField DataField="Col2" HeaderText="Col2" SortExpression="Col2" />
<asp:BoundField DataField="Col3" HeaderText="Col3" SortExpression="Col3" />
<asp:BoundField DataField="Col4" HeaderText="Col4" SortExpression="Col4" />
<asp:BoundField DataField="Col5" HeaderText="Col5" SortExpression="Col5" />
<asp:BoundField DataField="Col6" HeaderText="Col6" SortExpression="Col6" />
</Columns>
</asp:GridView>
</asp:Panel>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void GridView2_SelectedIndexChanged(object sender, GridViewCommandEventArgs e)
{
int y = Convert.ToInt32(e.CommandArgument);
Control control = GridView2.Rows[y].Cells[0].Controls[0];
LinkButton btn = control as LinkButton;
string qval = btn.Text;
string query = "SELECT * FROM Table WHERE Col LIKE '%" + qval + "%'";
string connectionString = @"Data Source=servername;Initial Catalog=dbname;Integrated Security=True";
SqlConnection accessConnection = new SqlConnection(connectionString);
SqlCommand accessCommand = new SqlCommand(query, accessConnection);
SqlDataAdapter grddetailsDataAdapter = new SqlDataAdapter(accessCommand);
DataTable grddetailsDataTable = new DataTable("Table");
grddetailsDataAdapter.Fill(grddetailsDataTable);
int dataTableRowCount = grddetailsDataTable.Rows.Count;
if (dataTableRowCount > 0)
{
grddetails.DataSource = grddetailsDataTable;
grddetails.DataBind();
}
dtpanel.Visible = true;
}
protected void GridView1_SelectedIndexChanged(object sender, GridViewCommandEventArgs e)
{
int w = Convert.ToInt32(e.CommandArgument);
Control control = GridView1.Rows[w].Cells[0].Controls[0];
LinkButton btn = control as LinkButton;
string qval2 = btn.Text;
Label1.Text = btn.Text; string query = "SELECT * FROM Table WHERE Col LIKE '%" + qval2 + "%'";
string connectionString = @"Data Source=servername;Initial Catalog=dbname;Integrated Security=True";
SqlConnection accessConnection = new SqlConnection(connectionString);
SqlCommand accessCommand = new SqlCommand(query, accessConnection);
SqlDataAdapter grddetailsDataAdapter = new SqlDataAdapter(accessCommand);
DataTable grddetailsDataTable = new DataTable("Table");
grddetailsDataAdapter.Fill(grddetailsDataTable);
grddetails.DataSource = grddetailsDataTable;
grddetails.DataBind();
dtpanel.Visible = true;
}
protected void grddetails_SelectedIndexChanged(object sender, GridViewPageEventArgs e)
{
DataTable dataTable = grddetails.DataSource as DataTable;
grddetails.PageIndex = e.NewPageIndex;
grddetails.DataBind();
dtpanel.Visible = true;
}
}
View 5 Replies
Mar 16, 2010
I have a gridview with Edit buttons, which turn into Update buttons when pressed:
[Code]....
It worked fine before I added DBInterfaceGridView_RowEditing handler:
[Code]....
Now it seems to be working in Debug mode, but in Release when I press Edit, the gridview just disappears.
View 3 Replies
Jan 30, 2010
I have an asp.net textbox like this:
<asp:TextBox ID="PINPad" runat="server" Columns="6" MaxLength="4"
CssClass="PINTextClass"></asp:TextBox>
It is, as you might have guessed, the text box from an on screen PIN pad. Javascript fills in the values. The page is posted back every five seconds (using an update panel if that matters) to update various other unrelated items on the screen. This works just fine. However, when I convert it to a password text box, like this:
<asp:TextBox ID="PINPad" runat="server" Columns="6" MaxLength="4"
CssClass="PINTextClass" TextMode="Password"></asp:TextBox>
Then whenever the page posts back, the text box is cleared out on the screen and the textbox is empty (though during the timer event, the value does make it back to the server.)
View 1 Replies
Feb 21, 2011
I have an asp:UpdatePanel in my .aspx page.Within the panel I have placed an infragistics ultrawebgrid control.Upon clicking a button (placed outside the panel) , I have to export the data in the grid to excel.I am using
UltraWebGridExcelExporter(Infragistics object) for this. The export will occur only with full postback.For this I have added a PostBack tigger for the button to the update panel.But once the export is complete, if I change the selected item in a dropdownlist(Autopostback="true") in the same page,the updatepanel gets invisible.
View 1 Replies
Nov 25, 2010
i designed a gridview to update, delete the records using sqldatasource, (there is no code in my aspx.cs file) but i dont know how to add the new row the gridview. so that if the table is empty then i cant add / update / delete the data.
how to Add new record on gridview using SQLDatasource without any code behind code?
View 6 Replies
May 7, 2015
i want delete record from gridview(delete template feild) but i have a error!
View 1 Replies
Jan 7, 2011
I am creating a custom control to show message to the user. The custom control is having 2 labels and one button.
I dragged the control in aspx page .
<cc1:MessageBox ID="MessageBox1" runat="server" />
Then i am calling a methos called show to show message to the user.
MessageBox1.Show("applicationname", "Message");
View 3 Replies
Jan 19, 2010
I've coded myself into a state of confusion. I have a form with a postal code TextBox and a country DropDownList both inside an UpdatePanel. When the selected country is changed, the DropDownList auto posts back and sets the regular expression used for validating the postal code. The country DropDownList also has a RequiredFieldValidator. The first item in my DropDownList is empty (Value = Text = String.Empty) and when I select this item, I momentarily see the RequiredFieldValidator appear and then disappear. It seems that the client side script is displaying the error message, but then after my partial postback it disappears. I can see in the country DropDownList's SelectedIndexChanged event handler that the RequiredFieldValidator has IsValid = false, so why doesn't the error message stay visible?
View 7 Replies
Apr 4, 2011
I have a link button:
<asp:LinkButton ID="LinkButtonPrint" runat="server" OnClick="OnPrint_Click">
<img src="img/print-icon.png" alt="" />
<asp:Literal runat="server" Text="<%$ Resources:PrintPage %>" />
</asp:LinkButton>
In code behind I add an onclick handler in Page_Load like this:
LinkButtonPrint.Attributes["onclick"] = "StartLoadTracking(this, '" + GetLocalResourceObject("Loading") + "')";
The rendered HTML is like this:
<a href="javascript:__doPostBack('ctl00$LinkButtonPrint','')"
id="ctl00_LinkButtonPrint" onclick="StartLoadTracking(this, 'Loading...');">
<img alt="" src="img/print-icon.png">Print page
</a>
If I click this button it is working OK (it will respond with a PFD file so no HTML is sent back to the browser), but if I click another button on the page (which makes a full postback) the LinkButtonPrint will not have the inner content, it will be rendered like this:
<a href="javascript:__doPostBack('ctl00$LinkButtonPrint','')"
id="ctl00_LinkButtonPrint" onclick="StartLoadTracking(this, 'Loading...');"></a>
If I remove the LinkButtonPrint.Attributes["onclick"] = ... line from Page_Load everything works fine (except my js function is not called, but that is normal).
What am I missing here?
EDIT
This is duplicate of asp.net Link button image not visible after postback.
View 2 Replies
Aug 26, 2010
Is it possible to use a SQLDataSource to populate a gridview but not use the SQLDataSource for Updating?
I wanted to add the update code in the Gridview_RowUpdating event since it is a complex update I need to do.
I get this message when i click the update button
Updating is not supported by data source 'SqlDataSource1' unless UpdateCommand is specified.
View 4 Replies
Sep 7, 2010
I have textbox that searches for first or last name. Result show in gridview. But when add value in text box and push my button Find nothing happen. Here code:
aspx:
........
<asp:GridView runat="server" AllowPaging="True"
AutoGenerateColumns="False" DataKeyNames="MobileNum"[code]....
View 1 Replies
Feb 2, 2011
I want to sorting the gridview. I am using stored procedure currentlyHow can I put the sorting functions?
protected void populateItem()
{
string itemQuery = "usp_GetStockList";
[code]...
View 2 Replies
Oct 2, 2012
how to export girdview populated with SQLDataSource to pdf file ??
View 1 Replies
Mar 18, 2013
In my asp.net+vb code +sql database web. i have three sqldatasource in on eweb page. i am willing to add radiobutton list for selection of sqldatasourec and show data in gridview.
View 1 Replies
May 19, 2013
in my asp.net+access web code in vb. There is three labels named (tata.text,tvs.text,msu.text) is there any option on clicking on the label named tata.text the data pertaining to tata be displayed in a gridview in another page or a popup display in same page.
View 1 Replies