I have a repository function called getList which retrieves certain information that gets posted to it from a form. My form has 6 fields, and a user can enter searvh criteria in any or all the fields. According to what he has entered, I must execute a SQL string to retrieve matching information.
I have the following:
[Code]....
But, if a user enters only a surname, my query will return no results. Is there a way format my sql string to allow default values, or maybe build the sql string at runtime. In MS-SQL it was easy to do, but how would one do it in LINQ??
1084 syntax error; expecting rightbrace before leftbrace as well as var 'colour' will be scoped to default namespace. Im' not sure what is going on but it is interfering with my ability to debug. it is action script
public class assgn extends Sprite { public function assgn() { var request = new URLRequest("C:UsersFujitsu UserDesktopprojects folder09_10"); var loader = new Loader(); loader.load(request);
i have this code for redirecting one value Response.Redirect("contact.aspx?Pat=" + row.Cells(0).Text.Trim()
i try doing this Response.Redirect("contact.aspx?Pat=" + row.Cells(0).Text.Trim() & "contact.aspx?Nam=" + row.Cells(1).Text.Trim()) but on my landing page it concatenates the 2
this is my landing page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load PatID.Text = Convert.ToString(Request.QueryString("Pat")) Patname.Text = Convert.ToString(Request.QueryString("Nam")) so basically it puts everything in my PatID parameter
I'm having problem in inserting text from a textbox in which user write or copy some text which may contain special characters ( " , . ) etc. If there is any special character it get conflict with CommandText Syntax and generates error in inserting. I want to insert all these characters. How could i do it?
For reporting we used report RDLCs and displayed using an ASPX form. We implemented using the route as shown below. This resulted in forcing us to use the page route below and also to use the hyperlink instead of the normal Action Link. The question is how do we convert the asp:hyperlink ASPX syntax to Razor syntax.
I've been getting "Connection forcibly closed" errors and in researching a resolution, I have seen to with the following web.config options, which currently are not set in my web app.
Before I change them, I'd like to know what they are currently set to.
how to read these values from .NET code, preferably VB.NET, though C# is fine.
I have alot of query strings on one of my seartch pages. The problem is that even if the corsponding setting is not set by the enduser it will be visible in the URL. Is there a way to avoid this?
In this case the Controller actions take an object of the following class :
[Code]....
Is it possible to avoid setting all the values in the URL when it is the default values that are used?
I have a user input form with a cascading dropdown. The code is:
[Code]....
Once the user submits the form, it goes into a temporary table, pending admin approval. On the approval page, I display a GridView of all pending records. Is it possible to use a CascadingDropDown in the GridView, with each Dropdown set to the value stored in the database for that specific record?
If I can't do this with a gridview, how about a dynamic ASP table?
I'm creating user controls that i will put into an update panel and make them visible only when required using triggers. Once visible it will float in a dialog box so it has a close button which will just hide the control on client side.
The controls have multiple post back states, like a wizard, i'm using a multi view control to accomplish that. My problem is that once the user is at step number two in the control, if the user closes the dialog, than opens the dialog again, (note that the control is made visible on the server and reloaded by updating the updatepanel) the second step will still be displayed. The reason is . because whenever there is a postback the control will load its state using the viewstate, even if EnableViewState is false it will still load it using the LoadControlState method. so my quesion is how can i force a user control to load fresh with its default values without any postback data.
I have several pages linked together that I want to maintain drop down selections for. I've seen a number of ways to do this with session values, etc, but I want to set the default value while still having the option of selecting other values.
Effectively, users will make selections on page 1 and then on page 2 they will use those same selections, but also potentially want to change their selections. My thought was that I could load the selections into a table in SQL in page 1 and then in page 2 call that table and set the values as variables. My question, then, is how I would set the default dropdown value to be a variable as opposed to a set value.
I am using VisualStudio2010 with ASP Webforms using C#.
I have a dropdownlist on my view that is being populated from values in a database table and I've added a "--Select One--" header. Selecting a value from this list is optional (it maps to a nullable field in my table). Currently, if a user doesn't select a value from the ddl then it inserts an empty string into the field, wherease I'd prefer to keep it NULL.
Is there any predefined function which could beauty this code? Something like: ValueOrDefault(Model.Image.standard,Url.Content("~/Content/NoImage.jpg"))
I'm making an "Edit Customer" page in asp .net and want to enter in all the current values into the TextBoxes on PageLoad. Is there a way to do this using databinding, or do I have to get the Customer from the DataContext and then set the TextBoxes line-by-line? ie
I have a sql server table with a date column that has a default value of GetDate()
this default does not seem to get passed to the EF and so i was wondering what the most elegant way was to code this default value within my asp.net application? I dont want to manually alter the EF Model as i may want to re-import it and dont want to lose these changes.
i have a master page that has a an accordion and inside the accordion is a cscading dropdownlist and then a button... Basically you select the values from the dropdowns and the click the button to change the content form from default.aspx to history.aspx. This works fine the first time I do it with the exception that cascadiing ddl all reset and then if i populate again and clcik the button again I get the following error(below)... I know I can set enableEventValidation = false, but wondered why this is occuring and what effect setting it to false would have? The second part of the question would be how do I maintain the ddl values when the page changes from default to History.sapx? I am using the following for the button.
<asp:Button ID="btnNewRecord" runat="server" Text="New" PostBackUrl ="~/History.aspx" /> 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.
I'm trying to execute a simple insert statement with the GUID and timestamp populated by default from the server. I have both of their default values set as (newid()) and (getutcdate()) respectively in SQL server. However, I receive the error when I try and execute the command "Insert Error: column name or number of supplied values does not match table definition". How do I construct my sql insert so my id and timestamp columns use their default values as assigned in sql server?
I have a DeatilsViews bound to an ObjectDataSource, I need set some default values for Insert and Update mode, which event(s) on which control(s) will be best to handle this?
I tried to set the default values using TextBoxes inside InsertTemplate, but the values are not saved to DB because 2 way bindings are lost.
