Forms Data Controls :: Pass User Id To A Boundfield On Insert?
Feb 15, 2010
I have the following code:
[Code]....
This is placed in the sqldatasource selecting sub. It works well and loads up data from the database based on the @UserId parameter.
I load up the detailsview and it only loads up data from the DB based on the currently logged in user, however i want them to be able to insert some data too.
Anyone know how i can achieve this when they select insert? For starters i having endless parameter problems but i am sure i can sort that out. what i really need is someone to tell me how i can pass the UserId into the USERID text when the details view mode changes to "insert"
I know there is a "mode changed" event, should i be using that?
View 4 Replies
Similar Messages:
Jan 12, 2010
I am trying to pass in as an insert parameter for SQLds2 the scope_identity of the insert of SQLds1.
Exception Details: System.InvalidOperationException: Error executing 'InsertCommand' in SqlDataSource 'SqlDataSource1'. Ensure the command accepts the following parameters: @Name1, @NewId
[Code]....
View 4 Replies
Feb 7, 2010
I'm developing an ASP.NET application with C# and Ajax.I have a page that holds user controls loaded dynamically. I need to pass some data (integer values and some strings) to the user control that has been loaded dynamically.Now I use Session to pass these values, but I think I can use another way; something like VIEWSTATE or hidden input.What do you recommend me?The fact that I load the controls dynamically is important because controls are loaded on every postback, and I can't store any value on controls.
View 9 Replies
Jun 30, 2010
I have a gridview inside a user control bind to an object datasource. Now I want to bind the object datasource with a parameter from parent page.
For this purpose I defined a public property in user control but how do I pass it with object datasource ?
I am calling from parent page like
myusercontrol.parameter=querystring["id"];
How to bind object datasource with my parameter ?
View 4 Replies
May 17, 2010
i want to use a grid view for data insert user can insert more than one row.
View 4 Replies
Feb 26, 2010
I have a page, let's called that Parameter page, displaying data from a database table using GridView. (The database is a SQL database.) I allow editing of data in GridView. The GridView uses stored procedure to retrieve data and to update data. In my project, users need to log in before using my asp.net project. So at every page, I know who the current user is by using HttpContext.Current.User.Identity.Name. Now as requirement changes, I need to record who has changed what (row) in the Parameter page. The information is to be written to a new table - audit log. Therefore I do not expect to change the Parameter table structure.
I have modified the stored procedure retrieving data. It returns one more column - an empty column with name currentUser. So GridView will create one more column. After data bound, I have the GridView_DataBound() to popluate that column using HttpContext.Current.User.Identity.Name.
I debug it in Visual Studio and am able to see the name of current log in user as the last column in GridView. I change the update stored procedure to take in one more parameter. That parameter, currentUser, takes default value. The default value is an empty string. So if UI part fails to send in the current user name to stored procedure, it just write the empty string as the user name. I change the <asp:SqlDataSource>. I add a <asp:Parameter> for currentUser.
[Code]....
I debug in Visual Studio. However when I save the change, the SQL profiler shows UI sends in @currentUser as NULL. Why?
View 7 Replies
Apr 14, 2010
how to assign the dynamicData into href={0} when user click on the Pass button?
<asp:HyperLink
id="test"
onclick="btnTest_Click"
runat="server"
href="{0}">Pass</asp:HyperLink>
code:
HyperLink test = e.Item.FindControl("test") as HyperLink;
test.Text = string.Format(HttpUtility.HtmlEncode(dynamicData));
View 6 Replies
Feb 24, 2011
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?
View 2 Replies
Oct 13, 2010
I have a detailsview in insert mode. I want to prompt the user to enter data in all fields, if left empty. Could someone please find a few minutes to show me how to do it?
View 2 Replies
Sep 10, 2010
in my gridview i have a list of names that are bound.
in my aspx i have a list of names that i can select from.
i want to see if each selected name is already in the grid.
something like
if (li.Value == row.FindControl("Name").ToString())
View 2 Replies
Jun 10, 2010
I'm building a web page that is going to make extensive use of User Controls. Using "LoadControl" it will have one of about 20 different User Controls loaded at any one time. Each User Control is somewhat different, gathering different sorts of data.
I've already built the mechanism to load the User Control and pass strongly typed data to it. But now I'm tackling the part of returning the user data to the Parent Form. I can think of several possible approaches to take but wanted to reach out to the community to learn what the best practice for doing this is.
View 2 Replies
Jan 17, 2011
How can I autoincrement the value of a boundfield column in a gridview ?
View 2 Replies
Apr 20, 2010
In vb.net how can I get the value of a gridview's boundfield value? I'm basically putting a value in that boundfield that I need to access in the RowDeleting event so I can pass that into a stored procedure. I'd be open to also trying to get the value of a control from a template column too if that's a better method?
View 4 Replies
Jan 2, 2010
I use ObjectDataSource and DetailsView for Updating records . my Bll input parameter method is an Object instead of regular parameter . So i though i could make my own ObjectParameter in ItemUpdating event of DetailsView and i need some modifiation on the data that user input on boudfield in detailsView . I don't know how to access BoundFiled data from ItemUpdating Method of DetailsView.
View 1 Replies
Nov 3, 2010
Probably a Q more suited for a SQL forum, but I guess it comes up a fair bit in ASP.net web site design?
View 5 Replies
Mar 9, 2011
I am tring to write some custom filters for a gridview and want to base the filters available based on the datatype of the Columns in the GridView. How would I go about determining the datatype of each column?
View 1 Replies
Feb 8, 2011
DLRepository is a class with method getDLandRules. I am binding the gridview with the list that is returned by method. Now I would like to iterate through the list and add 1 more column to each row that is returned. currently, I am getting an error
GridView1.Rows[row].Cells[7].Text 'GridView1.Rows[row].Cells[7]' threw an exception of type 'System.ArgumentOutOfRangeException' strin
View 4 Replies
Jun 4, 2010
i have an Gridview with BoundFiled, for the bound field headertext alo coming from the table, but i dont know how to bind the headertext and data. i have used below code
<asp:BoundField runat="server" DataField="column1_data" HeaderText = DataBinder.Eval '<%# Bind("column1_text") %>'/>
but getting error as "The BoundField control with a two-way databinding to field column1_text must have an ID."
View 5 Replies
Jan 8, 2010
I need to set the HeaderText of GridView BoundField in codebehind file based on a flag at runtime.
I tried setting the column name as
e.Row.Cells[0].Text = "XXXX";
It is worked out but not able to sort that column.
here my requirement is to set the HeaderText programmatically in codebehind and able to sort the column.
View 6 Replies
Jan 15, 2010
I found an useful link which show tutorial for setup Gridview export to Excel.http://archive.aspsnippets.com/post/Export-GridView-To-WordExcelPDFCSV-in-ASPNet.aspxIt works well but if I want to preserve white space for certain boundfield, after the excel export, I got merged cell for every row. how do I avoid the merged cells?
[Code]....
View 4 Replies
Apr 18, 2010
As you all probably know a BoundField will always display a TextBox in edit mode, but i wish to add a RequiredFieldValidator to it. Any easy way to do it except for TemplateField?
View 2 Replies
Feb 17, 2011
I have one two GridViews on a page. One Gridview uses BoundFields inside of the GridView and the Update statement works just fine. The other GridView utilizes TemplateFields due to the fact that Validation Expressions have to be used. I also want This GridView to be able to update the vlues when the user clicks on the Update link on the right side of the GridView. The GridView that uses the BoundFields updates just fine, but the GridView that uses TemplateFields will not update. I have checked and everything is correct other than this difference of BoundField and TemplateField.
View 2 Replies
Nov 19, 2010
I have Gridview with boundfield and one of the fields is weblink in data likewww.yahoo.comI want in Gridview display it shows up as hyperlinks in row.How should I modify the code for the Gridview boundfield for this field ?
View 5 Replies
Sep 24, 2010
I have a gridview on a page with a hyperlinkfield that passes two parameters to a gridview on another page.
Here's the code for the gridview on first page:
<asp:GridView runat="server" AutoGenerateColumns="False" GridLines="None"
<Columns>
<asp:HyperLinkField Target="_blank" DataNavigateUrlFields="gtn_run_num,catg_custom_desc" HeaderText="Wages" DataNavigateUrlFormatString="~/Help/HelpPay.aspx?gtn_run_num={0}&catg_custom_desc={1}"/>
[Code]....
What I am trying to do is open the second page to the point in the page where the boundfield valueon the second page matches the hyperlinkfield value selected on the first page. I'd essentially like to anchor the two pages based on a value being passed (catg_custom_desc).
View 3 Replies
Oct 29, 2010
I I have a GridView attached to a SqlDataSource and all is working well. I also have and edit and delete icon attached to each record in the GridView, and again, all is working well.My problem is when I add a BoundField named 'statusCode', the delete stored procedure fails with:"Procedure or function 'up_delReference' expects parameter '@statusCode', which was not supplied."When I remove the BoundField named 'statusCode' from the GridView list, the delete works fine. I need to show the status in the GridView as the user can chose to see Avtive, Inavtive or Both records and they need to see the status when in Both.Here is the Code:
[Code]....
View 11 Replies
