Data Controls :: Changing Gridview Field By Clicking A Check Button
Oct 19, 2012changing gridview field by clicking a check button in gridview
View 1 Replieschanging gridview field by clicking a check button in gridview
View 1 RepliesI am trying to edit data using checkbox value. Firstly, I created popup window which using querystring some data from main page. In popup window, I want to change the checkbox value. For example, I made setSpare column and given the value to show bit data type such as 0 or 1 using checkbox(false or true). If some data has non setSpare(means 0), it wil lbe come out uncheckbox. If I want to check it and clicking submit button, It was not change. I am going to show the code below.
public partial class AddSpare : BasePage
{
string ObjectId;
protected void Page_Load(object sender, EventArgs e)
{
ObjectId = Request.QueryString["ObjectId"];
displayComInfo(ObjectId);
}
protected void displayComInfo(string ObjectId) // it informed relative data on web through using DB.
{
string query = "usp_ShowComputerList";
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SCSConnectionString2"].ConnectionString))
{
SqlCommand cmd = new SqlCommand(query, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter paramobjectId = cmd.Parameters.Add("@ObjectId", System.Data.SqlDbType.Int);
paramobjectId.Value = ObjectId;
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
ModelTxt.Text = dr["Model"].ToString();
ModelTxt.ReadOnly = true;
ComputerTxt.Text = dr["ComputerName"].ToString();
ComputerTxt.ReadOnly = true;
userTxt.Text = dr["UserName"].ToString();
userTxt.ReadOnly = true;
ntTxt.Text = dr["NtLogon"].ToString();
ntTxt.ReadOnly = true;
HDDTxt.Text = dr["HddSize"].ToString() + "GB";
HDDTxt.ReadOnly = true;
RAMTxt.Text = dr["MemorySize"].ToString() + "GB";
RAMTxt.ReadOnly = true;
SerialNoTxt.Text = dr["SerialNo"].ToString();
SerialNoTxt.ReadOnly = true;
TextBox1.Text = dr["Spare"].ToString();
inputChkSpare.Checked = (bool)dr["Spare"]; //(bool)dr["Spare"] display false or true.
dr.Close();
}
}
}
catch (Exception ex)
{
MessagePanel1.Type = MessageType.Error;
MessagePanel1.Text = MessagePanel1.Text = "This is an error." + ex.Message;
}
}
protected void okBtn_Click(object sender, EventArgs e)
{
string query = "usp_SetSpare";
try
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SCSConnectionString2"].ConnectionString))
{
SqlCommand cmd = new SqlCommand(query, conn);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter paramobjectId = cmd.Parameters.Add("@objId", System.Data.SqlDbType.Int);
SqlParameter paramspare = cmd.Parameters.Add("@spare", System.Data.SqlDbType.Char);
paramobjectId.Value = ObjectId;
if (inputChkSpare.Checked == true) // if I change the check box, it does not bring the changed value. It will bring the above value(already displayed thing)
{
paramspare.Value = "1";
}
else {
paramspare.Value = "0";
}
conn.Open();
cmd.ExecuteNonQuery();
cancelBtn.Value = "Close";
okBtn.Enabled = false;
MessagePanel1.Type = MessageType.Information;
MessagePanel1.Text = "This computer is spare from now.";
}
}
catch (Exception ex)
{
MessagePanel1.Type = MessageType.Error;
MessagePanel1.Text = MessagePanel1.Text = "This is an error." + ex.Message;
}
}
I have a gridview and sqldatasource in a form. My sqldatasource has select,delete and update command. The delete command is working but the update doest not work when I click the update command field.
Here is my code [Code]....
i have a UP and DOWN buttons ouside a gridview and a checkbox inside the templated field .I will check the checkbox to sleect a row , after that if i click on UP button the checkbox above the selected checkbox should be selected.
same with when i click on DOWN button the checkbox below the selected checkbox should be selected.
When I change my insert update and delete buttons to template field....they do not work properly anymore. I get a "Cannot insert a Null Value into...blah blah blah, error.
View 2 RepliesI created a grid and successfully done update, delete, filled functionality.
But whenever I m clicking on Gridview row, its hieght get increased and color of the row become red while clicking on edit button. But this problem is occuring in Mozilla,IE7 not in IE6. Project is running good in IE6. What could be the solution for this.
I have a button called Next outside the GridView. If I click on Next, I want to highlite the 2nd row and display the details of the 2nd row below in panel. If again I click on Nextm i want to highlite 3rd row and want to display 3rd row results in a panel
View 8 RepliesIs there any way to stop Gridview to turn back to first row when user click edit link button. Say there are 50 rows in gridview, user scrolled down to 45th row then click edit button. Gridview shifted to editmode but user need to roll down back again to reach the row 45th.
View 1 RepliesI want to do the effect like MS Word, if the user modified something, then click close button, will prompt a msg to remind the user to save changed.
my page has the web controls textbox,dropdownlist, and repeater, how to check these data??
I have loaded up a gridview object with data. I have turned on Edit on the grid. It lets me edit the data, but I also want to put some code to check for correct data in each field. I tried to assign a requiredfieldvalitor, comparevaliditor but they don't work. Is there an event I can capture to fire up some code before the grid sves my data?
View 3 RepliesI have a detailsview with an update button one of the update fields is a checkbox which when is checked I want to automatically update a date field of when the checkbox was checked, am I going the right way with this code....... as I am getting a number of errors
Dim i As Integer
For i = 0 To detailsview2.Rows.Count - 1 Step i + 1
Dim row As GridViewRow = GridView1.Rows(i) [code]....
Ihave a gridview item template field namely Status as mentioned above ...
i want when user click on hold button of particular row then the record from the particular row is transfered to another page. ... means.... if i click on the hold button of 1st row of gridview then seats=35 and booking closed =08:00:00 PM willbe trasferred to
Me.Response.Redirect("Select_seats.aspx?s_no=" & label22.Text.ToString & "&" & "journey=" & label6.Text & "&" & "seater=" & label4.Text & "&" & "sleeper=" & label2.Text & "&" & "service=" & lab5.Text.ToString) ..
and if i click on the manage button of same row then the record of that row will be transferred to
Me.Response.Redirect("Select_nfo.aspx?s_no=" & label22.Text.ToString & "&" & "journey=" & label6.Text & "&" & "seater=" & label4.Text & "&" & "sleeper=" & label2.Text & "&" & "service=" & lab5.Text.ToString)
Call JavaScript function on GridView Row click using jQuery in ASP.Net works great!, but if I want to have a first column with an image button so the user can click only there to select a row it always produce a postback when using a button field, how can I avoid that postback while having an image button for the selection click in the gridview?
View 1 RepliesWhen I try to edit a field of a GridView or DetailsView on the WebServer I have to highlight the area I want to edit instead of just clicking into and empty field and start typing What setting did I forget to set to allow easy editing without having to highlight the are first?
View 5 RepliesIam using a radio button in a Gridview. I want to check whether it is checked or not. If it is checked i want to pass one value or if it is unchecked i want to pass another value. But even when i checked the radio button, it is still showing unchecked in the Debugger. How to check whether it is checked or not. Following is the code iam using:
[Code]....
How to change a column from hyperlink field to button in Gridview?
My current code is as follows
<asp:TemplateField HeaderText="Click">
<ItemTemplate>
<asp:HyperLink ID="HyperLink1" runat="server"
NavigateUrl='<%# Eval("ID", "Detail.aspx?ID={0}") %>'
Target="_blank" Text="Detail"></asp:HyperLink>
</ItemTemplate>
<EditItemTemplate>
</EditItemTemplate>
</asp:TemplateField>
I have a asp:button in template field of gridview, I set command name for this and in grid I mention on command event. On clicking the page it shows error message is :
Invalid postback or callback argument. Event validation is enabled using <pages enableEventValidation="true"/> in configuration or <%@ Page EnableEventValidation="true" %> in a page. For security purposes, this feature verifies that arguments to postback or callback events originate from the server control that originally rendered them. If the data is valid and expected, use the ClientScriptManager.RegisterForEventValidation method in order to register the postback or callback data for validation.
Below is my code
<asp:GridView runat="server" ID="gridManageClients" AutoGenerateColumns="False" OnRowCommand="gridRowCommand">
<Columns>
<asp:BoundField DataField="Clientid" ItemStyle-Width="75px" />
<asp:BoundField DataField="ClientName" ItemStyle-Width="300px" /> [code]...
Ive got a list of records in a gridview (from an SQLDataSource) where a field value is set to True. I've also added a "reset" button in a template field at the start of the row in the Gridview.
What I would like to do is allow the user to click the reset button on a particular row and 'reset' the true value to 'false' (updating the source data).
I created a gridview that is bound with an SQL datasource - I added a gridview button column. I need to update/insert 'Y' on a specific cell in the row when I press the button
This is my gridview code
[code]....
The button column I have says delete on it but it shouldn't really delete it - Once I press the button it puts a 'Y' on a column that is filtered out by my sql statement in the sql datasource
My gridview has id in first column but I have hidden it . How do I send the gridview id to next page in query string.
View 1 RepliesI have just a form with several text boxes and two buttons one with next and anothe with previoues i have writtern code
<form id="Info" method="post" runat="server" defaultbutton="btnNext">
</form>
very first when the page loads the focus willl be on the next button, when i try to enter the text in the text box, focus changes from the next to the previous button (Previous button is the first button i have).
I need to check for two differect text to make the Edit button inactive. For example, I need to make the button inactive when the ActionTypeName field has value either Accepted date or Received date. I can do one check with Accepted date but not both.
View 1 Replies I've created a databound gridview inside the gridview's RowDataBound I use the RowSpan property to merge cells. The grid ends up looking like this for example....
Data Data Data Button
Data Data Button
Data Data Data Button
Data Data Button
Data Data Data Button
The button is generated using a Template Field and is a standard ASP:Button. If I click a button in an unmerged row everything works as expected. If I click a button in a merged row...the sender object on the command comes back as null and no matter what I try I can't seem to fix it or get a reference to the button.
sender.CommandArgument
for example returns and empty string.
I want to populate a detailsview cell by a value from a drop'dn list(based on values from another table).
View 4 RepliesI have a panel, panel is a button and listbox, when the user clicks the button it should fire but it doesn't. Why would this be?
View 4 Replies