I am using a FormView and when I want to update something I have edited, I always get this error:
No value given for one or more required parameters.
I use a SQLDataSource in combination with a FormView.
[Code]....
I'm wanting the URL to my MVC application to be like:www.site.com/BobWhich would in turn 'redirect' to Home/Details/Bob.I've set up the following MapRoute:routes.MapRoute( _Nothing, _"{personName}", _New With {.controller = "Home", .action = "Details", .personName = ""}, _
New With {.result = New NameConstraint()} _
have a site in which there is a link to the users profile page, the info on the profile page is loaded be geting the username from the urleg. http://localhost/app/user/profile.aspx?user=botn this case "bot" the problem is, i don't know how to accomplish this, i dont know how to inject that username value into the url, however note that when i manualy type a username
i used this url which has a asp.net placeholder:
~/user/profile.aspx?user=<% Get_CurrentUserName %>
[Code]....
How to use Control Parameter with SQLDataSource When FindControl is required?
[Code]....
I am doing a library application. I am using a formview control to display and edit the details of an existing borrower.
What I wish to do is to allow the user to enter the borrower barcode into a textbox and select the details of the borrower corresponding to the barcode.
At present I have kept the textbox and a button outside the formview. Once the user enters the barcode in the texbox and clicks the button, the data is displayed in the formview control.
Now, my doubt is that is there a way to keep the textbox inside the formview control itself and use the value(Which should be user input) for selecting the details?
I have a Formview ('formview1') with a pager. I also have a gridview ('gridview1') linked to a SQL datasource ('History'). I need to set the SelectParameter ('Serial') of the datasource to be the value of a field on the current page in the formview. The value i need to get is in the ItemTemplate and is a label called 'SerialNumberLabel'. So, something like:
<SelectParameters>
<asp:ControlParameter Text = "Eval fromview1.currentpage.itemtemplate.SerialNumberLabel" >
I also need to ensure that the SQL source and gridview rebind when the pager is activated.
I have a formview bound to a sqldatasource control. I want to set one of the insert parameters when I click on one of several buttons (outside the formview).
In my sqlDS I have:
<InsertParameters>
<asp:Parameter
Name="benType"
Type="byte"
/>
<asp:Parameter
Name="benName"
Type="String"
/>
<asp:Parameter
Name="benDesc"
Type="String"
/>
</InsertParameters>
I want to set the "benType" depending on which button I've pressed (I don't want/need it to be visible in the InsertTemplate). I tried adding this line to the codebehind for the button click:
formview1.ChangeMode(FormViewMode.Insert)
formview1_datasource.InsertParameters(0).DefaultValue = 2
This doesn't work...what is the best way to set the insertParameter from outside the formview?
I Have an InsertTemplat in FormView that has a DD List.
I also have an Insert Parameter in a SQLDataSource that tries to reference it but can't.
Is my only solution to use event code to move the data to the SQL Parameters?
[Code]....
I am currently able to pass parameter from 1 page to another but I am unable to retrieve it.
<asp:HyperLinkField DataNavigateUrlFields="ID"
i have the following scenario: one formview. when in editmode there is a child formview linked to the other by a column value. i need to take the value of one of the values of parent formview controls and set it to a textbox of child formview in insert mode. I wish to know which event should I use in codebehind to bind both controls? (that escenario will have paging and must keep the binding as if it was master detail)
View 9 RepliesI have a nested formview. I need to set a value for a textbox when I'm in insert mode from parent formview which is editmode.
View 4 RepliesI have a formview that use the formview iteminserted event. The information inserts into the formview fine, but all cells blank out after the insert. How can I make it so I can show all the values I have inserted show up in the formview after the inteminserted event?
View 2 RepliesI've a MDX Query that has where clause as shown below.I'm designing report using SSRS 2008. How can i pass date as parameter? I tried to setup @from and @to as parameter but not working?
WHERE ( {[Date Central].[Calendar Date].[2010-04-01 00:00:00]:[Date Central].[Calendar Date].[2010-08-30 00:00:00]} )
need it to work as
WHERE ( {[Date Central].[Calendar Date].[@From]:[Date Central].[Calendar Date].[@To]} )
Is it possible to change a parameter's property after the uer has made a selection or filled in another parameter field? I'm using VS2005
Case:
- 3 parameter fields; Country,Station,Carrier all three are textfields and are allowed to stay 'blank'.
- When the user enters a Country-code in the 'Country' parameter field, the 'Carrier' parameter should become a required field.
I did some searching on the net, but haven't found the solution. I started to wonder if it's actually possible?
I have a parameter Owner with 1,2,3 options in dropdown.
On selection of option 1 , a country parameter should be enabled with all countries' values defaulted.
Option 2 should enable Region parameter with all the Regions values selected and country parameter should be displayed.
Option 3 should disable both Region & Country Parameter.
I am using SSRS 2005 with Enesys tool as add on.
One of our customers has a report with a single value string parameter that has over 1000+ possible values. selecting single value from 1000+ choices results in bad UI, among other things.create another parameter that acts a filter for the other parameter. So you would have Param1 with say 25 choices and selecting a choice would narrow down the option for the second parameter.Is this the best way. What is the best practice for handling these kinds of parameters?
View 5 RepliesI have a page with a FormView on it. The page is strictly for adding records to a Table. I have the FormView bound to an EntityDataSource and everything works greate except for one thing.
I want to initialize a date field in the FormView to today's date. So, in my page_load event I have:
if (!Page.IsPostBack)
{
//Initialize SetupDate to today.
TextBox setupdate = (TextBox)fvJob.FindControl("txtSetupDate");
setupdate.Text = DateTime.Now.ToShortDateString();
}
The first time this page loads, the txtSetupDate field is initialized.
Although, and subsequent loads of the page doesn't initialize the Text Box. I step through the code in the debugger and I can see that the code is executig, but something (the FormView bind?) is "clearing" the Text Box.
I have a formview that I am adding and editing items. I need to have a lookup button besides a textbox so I can click the button and show a webgrid listing items with their descriptions. Select one and enter the data in the formview control. I know how to put the data in the formview control with the FormView.FindControl method. But how can I add a lookup? Can I do this with a popup panel? And on the postback update the textbox control?
View 5 RepliesI would like to ask if it is possible to access data on a master FormView from a nested detail FormView.
I have a main form (master) with several tabs (detail) and would like to display a label with text from main form that is hidden by the tab at the moment of editting. My asp page looks like this.
[Code]....
Is it possible to get the value of the label CompanyTextLabel from CompanyTextBox using just ASP.NET expressions or something similar without writing c# code in .cs file?
How do you use the http POST method with a Grid View on another page. I am trying to use the POST method to send the ID from the selected row of a Grid View, I am using a link button set to fire the select command and it has the Post Back URL set, from one page and then retrieve the ID value on another page using an Object Data Source. Also, under the Defining Parameters, I am setting the ID parameter to Form Parameter Source and have entered the Grid Views name in the Form Field.
View 4 Repliesi am trying to update a excel file using the oledb connections. But i am getting the following error:
"No value given for one or more required parameters."
This is my code:
String sConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(@"TempUploads" + hdnExcelName.Value) + ";Extended Properties='Excel 8.0;HDR=NO'";
OleDbConnection objConn = new OleDbConnection(sConnectionString);
objConn.Open();
string sql = "update [Sheet1$] set [A8]='apple1.jpg'";
OleDbCommand objCmdSelect = new OleDbCommand(sql, objConn);
objCmdSelect.ExecuteNonQuery();
objConn.Close();
i want to read the following xml file.
[Code]....
using ds.readxml.. .i am getting a column specialties_id in the specialties table. . i have spec_id as PK in tht table ..still it is creating extra column automatically.. i need the output like this.. doctors table is fine.. specialties table columns(spec_id,specialty)..drspecialties table columns(dr_id, specialty_id)
then i need to send three tables into database..sending to database i can do tht... let me know how to read this xml to get the tables as required.. pls solve my prob..
I need to have a GridView listing all invoices of an account. Each account can have a PDF generated for that account, which isn't done instantly - so I need a gridview column to update the user of the progress of this conversion - i.e. 'In Progress'. Then, when the conversion is done the cell's text should change to a hyperlink to the PDF file. I know it's a very vague question in regards to monitoring the state of the PDF, but I'd just like to know if AJAX would be a solution and what controls I would use.
View 1 RepliesDatabase MSSQLSERVER 2008.Visual Web Developer 2008 Express
I am simply attempting to use a details view to insert and edit fields in the database. Some fields in the database have value some are NULL. All fields except the id accept NULL values.This should be a straight forward process, but for some reason it isn't.
Here is the datasource code:
<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:llcagentConnectionString %>" [code]....
I would love to find out why this is causing errors.I have checked to make sure the field names are the same, and of course they are since this is generated by the control.I have tested the connection to the database and it is fine.I have attempted to hard code the values into the string, but that too gives me errors and would not be consistent with what I want this control to do.
I am getting following error on uploading my pages on web server. it working file on my local machineRequired permissions cannot be acquired.
Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
[Code]....