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>
I want to insert a record into a log table ONLY if one exact copy already doesn't exist within ten days, what is a good way to do in one stored procedure what I do above in two?
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?
I am trying to insert a buttonfield at the end of the datagrid. I am using the following code. However, it is getting inserted at the beginning of the datagrid.
I know there are a number of posts along this topic, but everything I find seems to not have a final solution or else I'm just not getting what the solution is. I have a simple GridView with a ButtonField and a BoundField. I'm having the same problem most of the other posts seem to have; I can retrieve the BoundField value easy enough in the RowCommand subroutine, but I can't figure out how to get the value of the ButtonField. Here is the code I'm trying to use:
[Code]....
sAddr is being set to the correct address value, but sName is set to an empty string no matter what I try. The GridView HTML all works correctly, including showing the names from my bound data table on the button text. I can use to retrieve the ButtonField text value?
I want to have two asp:buttonfield buttons in one cell. I have to be able to access the Gridview.SelectedRow. And I don't seem to be able to add a asp:buttonfield to a templatefield.
I have a gridview with a column for tracking numbers. I would like for the user to be able to click the tracking number in that column and it open another browser window to the site with the tracking information. I have tried Hyperllinkfield and I cannot get it to open the website.
I have a gridview with a ButtonField. When I leave the button type as the default LinkButton, clicking that button fires the RowCommand and everything works as expected. As soon as I change the button type to ImageButton and assign an ImageUrl, clicking that button does not fire the RowCommand.
I have 2 gridviews in an aspx file. The First one is master grid, and the second one is detail grid. (such as Customer and it's Invoices) First, I load data into master grid. I use FireBug and notice that every row has it's row id, such as:
Then, in master grid, I select a buttonfiled in a row to load the second gridview.Every thing alright, the second grid has it's row id But The master grid lost all row id that I dont know the reason why?
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?
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?
I tried to find a LINQ section on this forum, but couldn't, so I'll post this here since is deals with LINQ, C#, MVC, SQL Server, and well...just about everything.
Here's the details....My Application is an ASP .Net MVC 1.0 app, using C# 3.5, SQL Server 2005 Std, and LINQ to Entity.
In my View, I have numerous Html.CheckBox controls, they get passed to my Controller as a string collection via a JQuery Ajax call. The values of each checkbox are seperated by a comma(,). I then Split the string, to get the individual values. The overall purpose to to allow users to build a custom report with only the data elements they have checked the boxes for. Here is my controller:
[Code]....
The part that I am having a problem with is that I only want to Insert the data elements into my DB table for the ones that the user has selected the checkbox for. So, for example, I'd like to do something like this:
[Code]....
I don't know if there is a LINQ switch statement in which I can access outside variables and the columns of the table, or any thing like that.
Is it possible to add multiple select statements in a single stored procedure. The select statements are getting data from different tables. If yes, could anybody provide an example in adding multiple select statements, which retrieve data from different tables in a stored procedure.
I want to add my own set of functions into my GridView. For example, I have a help desk management module that displays all the help desk tickets in a GridView. When the tech is finished supporting the customer, I want him/her to click the "Close Ticket" link in the GridView to close the ticket.
I've never used the ButtonField feature field before so I thought this would be perfect but I'm a little confused about getting the TicketID in the GridViewCommandEventArgs method. I thought I could just put the TicketID in the CommandArgument and pull it from there but looks like I can't do that as ButtonField is not giving me the CommanArguement option.
I'm not displaying TicketID's in the GridView because they're "uniqueidentifier" datatype and look ugly. How do I pull the TicketID if I were to use a ButtonField? Or is there a better way to do this?
I already have a method in my DAL expecting the TicketID so all I'd have to do is get the TicketID and call this method.
In the application I am working on there is a Gridview with a select and on clicking the select we get the value of the DataKeyNames.
Basically we have OnSelectedIndexChanged="GridIndexChanged" in the Gridview property.
Now the problem is that I want to add a ButtonField with a Commandname, so that I can call a different method. In the OnSelectedIndexChanged it's simple to get that value by doingGrivView1.SelectedDataKey.value, But how can I get the value of SelectedDataKey in the Button Click?
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'm using a listview control to do a survey stuff. Everything is working perfect to present the data questions, to be answered text with the different type of controls radiobuttonlists, checkboxlists, dropdownlists, etc. The admin can modify, create, change questions, answers, etc. on the survey.When it's select, edit, or insert it's easy to find the control inside a listview.However, I'm wondering how to post user's answers back to DB. How to find controls inside the listview to grab the entered data/responses from there using let's say the submit button that is outside of the listview.I believe there should be a way to do it as otherwise why we put radiobuttonlist on a listview that somebody could click it and then we should be able to get that entries. Or I'm too optimistic on this control?
I would like to know if I can do the following: when I am in insert mode, can I dynamically change the select command of and then display that result in the second dropdownlist based on what was selected in the first dropdownlist.
I would like to include the minimum code to demonstrate what I am trying to do.
I have grid view in ASP.Net 3.5. I need to add multiple blank rows in a gridview and then have to save them in database. How can I do that in most simplest way?
I have a usercontrol that has a gridview. I have a few boundcolumns and then a buttonfield. The buttonfield needs to have a confirm message box and then proceed to the RowCommand event. In the RowCommand, I'm trapping for a CommandName called "DeleteFile".
The weird thing is everything works correctly with deleting a row if the onclick code is not registered. I'm using attributes.add for this.
I know there is another option for using a templatefield and then a button rather than a buttonfield. But, I've noticed that this approach causes a postback that effects another usercontrol on my page. It thinks I've submitted it which can either cause it to error out or potentially sumbit more information which I want to avoid.
I am unsure on how to perform this task, what i need to do is make a gallery with tagging. I need this as it is a requirement for the project. Each user will have there own gallery and be able to upload and delete images from there gallery. I already know how to insert and select images from a database. I will then display the gallery using a data repeator with paging, I am sure i can google an article for data repeator with paging.
My challenge is, when the user wants to save a image to there gallery, he must 1st upload the image and then i must some how display the image, when the image is displayed, i will have a text box where they can add tags, this textbox will save in the tag table for that user_id, picture_id and the tag will have an id also. I am unsure on how to do this When he clicks save, i wanna insert the image into the table, and the tag. If he does not click save, then nothing should be saved. Now the 2nd part.
In the data repeator, i want a modal window to popup when they click an image, this modal will have the image and the respective tags that where saved for this image, I am unsure how to this.
