C# - GridView - How To Perform Custom Update Statements

Sep 21, 2010

I have an ASP.NET GridView which displays a list of neighborhoods.

I wish a user (administrator) to be able to edit the neighborhood name.

Now, the database is quite complex, and as such, i can't simply provide an UpdateCommand / SqlDataSource for the GridView.

I bind the data manually (on first load, and on the PageIndexChanging event).

Binding/listing paged data is working fine.

However, i'm having trouble trying to UPDATE the data.

The user clicks the "Edit" button, the textbox for the neighborhood name is shown, i change the text, click "Update", but the RowUpdating event is not firing.

I basically want to grab the row that was edited, and perform a custom update using LINQ.

Is this not possible with a GridView? If it's not, what are my alternatives? A repeater with LinkButtons and a hidden textbox that can swap in/out the labels?

This is my GridView markup:

[Code]....

And the code-behind:

protected void NeighborhoodsGridRowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow updatedRow = NeighborhoodsGrid.Rows[e.RowIndex]; // not firing. =(
}

I also have the GridView wrapped in an UpdatePanel, if that makes any difference (don't think it should).

View 1 Replies


Similar Messages:

DataSource Controls :: Update / Insert And Delete SQL Statements For Define Custom Statements Wizard

Feb 23, 2011

I'm using the 'Configure Data Source' wizard to connect to my database and show the dataset in Gridview. I want to be able to update, insert and delete entries but am unsure how to build the query. I can write simple update statments to change database entries but how can I do this for entries that have been changed within the gridview?

View 6 Replies

Forms Data Controls :: Multiple Update Statements Per Row In Gridview Edit

Aug 24, 2010

I want to set up a gridview that will display data like this

[Code]....

and that allows editing. Is it possible to have multiple update statements when editing from he gridview? Each day will need a separate update state since the data will be stored in the database like this

[Code]....

I think for each row I would need 7 update statements - one for each day. Is this possible with the gridview edit button?

View 4 Replies

Forms Data Controls :: Using A Gridview To Perform Bulk Update?

Feb 9, 2010

I have a gridview with checkboxlist for each record. I was updating each record individually based on that check, but now they want it to be a bulk update instead of individual. So i have commented out my individual update and added a button below the gridview and created my button event, how to loop thru the gridview and find the checked records and call my update procedure.

i found something kinda close to what i need, but its in VB and not sure how to convert that to C#

[URL]

View 2 Replies

Forms Data Controls :: Use The Gridview To Actually Perform An INSERTand Not A True Update?

Dec 15, 2010

if it's possible to use the Gridview (SQLDatasource) UpdateCommand to actually perform an INSERT and not a true update.Here's the dealUsing a Select statement in my SQLDatasource,I'm retrieving records for which there are no History records for a specified period.(Essentially, I'm asking "Show me all records for which there are no historical records within a specified range").I'm using that result set to feed my GridView. Basically, I'm displaying all I need to know about the insert records sans one piece of info.When the user choose the "Edit" button, the row goes into edit mode.Using a template field, I've created a drop down box to allow the user to input the status of the data for that particular time period.When they click the save button,the idea is that the UpdateCommand will fire.However, when I click the save button (in edit mode),I get a postback error that tells me System.Data.SqlClient.SqlException: Must declare the scalar variable "@EQP_PK".

[code]...

View 6 Replies

ADO.NET :: Configure Both Select And Update Statements?

Sep 6, 2010

i would like to retrieve a value with select and perform a calculation and then save using update in the same batch code?

View 3 Replies

Databases :: MySQL And Auto Generating Insert,Update - Delete Statements?

May 11, 2010

Before I get too far down the road I just want some advice. I'm building a web app using VWD2008 and MySQL 5. I've got the membership provider stuff working fine and have an odbc connection setup which works "fine". what I've noticed is that when I configure a new sqldatasource (that will be used to provide data to a listview or something) the Advanced -> generate Insert,Update..... option is disabled. I'm assuming its because of the sql syntax difference of the square brackets issue between MS SQL Server and MySQL.

Before I start writing all my own insert and update statements does anyone know if there is a way to get MySQL and VWD to talk the same language, maybe a different connector or something. I'm using mysql-connector-odbc-3.51.15

View 7 Replies

Forms Data Controls :: Dynamically Generating Update/delete Statements For A DetailsView Control?

Dec 1, 2010

In my Admin page, I have a drop down list containing all current user tables in the database. The user chooses one.

My DetailsView below uses that parameter to populate itself with data from that table. The stored procedure used to select the data passes a string to sp_executesql. The string is concatenated from a select statement and the tablename parameter. Can I do something similar for Update/Delete statements? I'm not sure of the best approach, given that I won't know which/how many fields will be in the DetailsView at runtime, and which of these are keys - the choice of table depends on the user. I think Insert will be straightforward - am I right? I would like to streamline things as far as possible. Is it possible to dynamically pass in the values in, say, a string, and get my stored procedure to understand them? And what's the best method of grabbing the values from the DetailsView in this situation?

View 4 Replies

ADO.NET :: Perform Update Operation In A Datatable Without Using Loops?

Mar 17, 2011

I need to perform update operation in a datatable without using loops. Is there any way to perform update in a datatabel...

View 3 Replies

AJAX :: Perform UpdatePanel.Update From Different Page?

Sep 17, 2010

I have Page_A.aspx and Page_B.aspx

Page_A.aspx has a text box and a Send button.
Page_B.aspx has a Label control on it, inside an UpdatePanel

I want that when I type something in Page_A.aspx and click Send, the text of Label on Page_B.aspx should be updated with the text box text and the UpdatePanel should be updated. Is this possible?

Page_A.aspx:

[Code]....

Page_B.aspx:

[Code]....

View 4 Replies

AJAX :: Is It Possible To Perform A File Upload Within An Update Panel

Jul 21, 2010

Is it possible to perform a file upload within an update panel.

View 2 Replies

DataSource Controls :: Can't Perform Create / Update Or Delete Operations

May 12, 2010

when i want insert a record i see an error like this

Can't perform Create, Update, or Delete operations on 'Table(MainMenuLink)' because it has no primary key.

with this codes:

MyLinqDataClassesDataContext db = new MyLinqDataClassesDataContext();
MainMenuLink li = new MainMenuLink { Link ="../error/error.aspx", LinkSubject = "subject" };
db.MainMenuLinks.InsertOnSubmit(li);
db.SubmitChanges();
ShowLinks();

what is the problem?

my table have a primary key but i dont know why give an error!!!

View 3 Replies

DataSource Controls :: SQL UPDATE Command - Perform Math Function From Value

Jun 27, 2010

Is it possible to perform an update command which performs addition using a value from a textbox? For example: User inputs a number into TextBox1 (I use regular expression validation to ensure this is an integer).

[Code]....

Basically if the user inputs 5 into TextBox1, I want the update command to subtract 5 from that user's ballance.

View 2 Replies

Forms Data Controls :: Gridview Update With A Custom Source

Jan 27, 2010

I am binding gridivew with custom datasource. I have 3 columns and I want two columns to be editable. right now grid showing the data but i want it to delete and update as well.

View 3 Replies

Forms Data Controls :: How To Perform Edit/Update And Cancel In The Grid View

Oct 23, 2010

how to perform Edit/Update & cancel in the grid view .. already the data is there in the gridview

[code]....

View 2 Replies

DataSource Controls :: Insert A Record Error - Can't Perform Create, Update, Or Delete Operations On 'Table?

May 11, 2010

when i want insert a record i see an error like this Can't perform Create, Update, or Delete operations on 'Table(MainMenuLink)' because it has no primary key. with this codes:

MyLinqDataClassesDataContext db = new MyLinqDataClassesDataContext();
MainMenuLink li = new MainMenuLink { Link = "www.tprogrammer.com", LinkSubject = "subject" };
db.MainMenuLinks.InsertOnSubmit(li); [code]....

View 2 Replies

Forms Data Controls :: Select / Insert Statements In Buttonfield In Gridview

Jul 28, 2010

A bit new to buttonfields in gridviews - Did a bit of research and most of the stuff I came up with had the gridviews with data bound like so :

[Code]....

private void BindGridControl()
{//method created so that the binded gridview can allow paging controls
DataTable dt = new DataTable();
try
{
/*Gridview requires another column either a checkbox or a hyperlink column that
* can drill down another level and load a page where user can edit the data/cheque
* Will place an exception here that will prompt a window to notify users that
there were no rows returned
*/
GridView1.Visible = true;
sqlConn.Open();
sqlSearch = "select store_nbr as [Store number],date as Date,data_type as [Data type],acct_1 as [Account 1], ";
sqlSearch += "amt_1 as [Amount 1],acct_2 as [Account 2],amt_2 as [Amount 2], ";
sqlSearch += "acct_3 as [Account 3], amt_3 as [Amount 3], cheque_nbr as [Cheque Number], ";
sqlSearch += "cheque_amt as [Cheque Amount], gst_hst as [GST/HST], qst as [QST],comments as [Comment] ";
sqlSearch += "from SimpData where store_nbr = '" + StoreNum + "'";
sqlCmd = new SqlCommand(sqlSearch, sqlConn);
SqlDataAdapter adapter = new SqlDataAdapter(sqlCmd);
adapter.Fill(dt);
if (dt.Rows.Count > 0)
{
//if there are rows returned bind the datasource to the gridview
GridView1.DataSource = dt;
GridView1.DataBind();
}
else
{
//label control notifies user that there are no rows found
lblResults.Text = "Search returned no rows";
}
My ButtonFields<Columns>
<asp:ButtonField ButtonType="Button" CommandName="Select" HeaderText="Select item"
ShowHeader="True" Text="Select1">
<ControlStyle Width="50px" />
<HeaderStyle Font-Size="XX-Small" />
</asp:ButtonField>
<asp:ButtonField ButtonType="Button" CommandName="Select" HeaderText="Select item"
ShowHeader="True" Text="Select2">
<ControlStyle Width="50px" />
<HeaderStyle Font-Size="XX-Small" />
</asp:ButtonField>
<asp:ButtonField ButtonType="Button" CommandName="Select" HeaderText="Select item "
ShowHeader="True" Text="Select3">
<ControlStyle Width="50px" />
<HeaderStyle Font-Size="XX-Small" />
</asp:ButtonField>
</Columns>

[Code]....

View 7 Replies

Forms Data Controls :: Add Multiple Statements To A Onclick Attribute Of A Gridview Row

Oct 27, 2010

I'm trying to add multiple statements to a onclick attribute of a Gridview row:[Code]. Something must be wrong with the way I concat the string 'script' with the statement that makes the row selectable. when the session var is null, then the Page.ClientScript statement goes through and the row will be selectable, but when the session var is NOT null and as a result, the whole statement contains the 'confirm' part, the the confirmation dialog pops up but nothing else happenes upon confirming. What's wrong with the "script += Page.ClientScript.GetPostBackEv..." part?

View 4 Replies

How To Perform Server-side Pagination By Using A GridView And A DataPager

Feb 20, 2010

I have a webform which uses a gridview control to show result of a search operation.I wanna to take advantage of using pagination in the webform. But as you all know, gridview pagination is a client-side pagination and it transfers all records have been selected to the client. What I mean by client-side pagination is the client (page) shows records page by page but every time the user clicks on a page link to navigate through records, all the records are selected from Data Source.How can I use gridView with datapager in order to have a server side pagination? Or any other solution to get records page by page by configuring our query?

View 1 Replies

Data Controls :: How To Perform Search Function In GridView

Feb 22, 2014

How to ? Perform the search function in gridview ...

View 1 Replies

Forms Data Controls :: Add A Button To A Gridview To Perform A Reduction?

Jun 28, 2010

I have the following gridvew that contains this information below

Type_id quantity
Red 2
Blue 3
Green 6

Now, I would like to add a small button next to the type_id, so that whenever the user clicks on it, it reduces the quantity by 1 through the use of query, I wrote. see description below

Type_id quantity
(button) Red 2
(button) Blue 3
(button) Green 6

View 8 Replies

Data Controls :: Perform Case InSensitive Search In GridView

May 7, 2015

I have a textbox and a search button and I have a company name "aaa" in grid view

If I typed in textbox "aaa" and click on search button it works

but:

If I typed in textbox "Aaa" and click on search button it doesn't work

I want if i typed "aaa" or "Aaa" in both cases works as it is same word

View 1 Replies

Forms Data Controls :: GridView - Check Box Perform 2 Operations Simultaneously?

Apr 9, 2010

I have placed Chekc box in Gridview when i select the check box can perform 2 operations simultaniously one is entire recordset is populated into form fileds and second one is can delete the selected record permanently from database table.following code for this fuctionality.

GridviewCode
<asp:GridView ID="GVData" runat="server" Height="75px" Width="76px" CaptionAlign="Top"
Font-Size="Medium" EnableModelValidation="True" [code]....

View 3 Replies

Custom Server Controls :: Using Customer Pager Template, In A Custom GridView?

Mar 16, 2010

Using VS2005, VB code behind, Using Customer Pager Template, in a custom GridView...

View 6 Replies

Data Controls :: Restrict Pages Displayed When Implement Custom Pager For GridView With Custom Paging

May 19, 2013

I have read your article from aspsnippets.com about custom paging it really work, but there are a problem that if there are more record in database (2000 to 5000) than  number of page index  will be goes in large number. like 1 to 200, any way which can divide it  like 12345678910...2000.

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved